acctiva: expertise in business intelligence, data warehousing, data governance

40
Company introduction www.acctiva.co.uk

Upload: acctiva-ltd

Post on 02-Jul-2015

686 views

Category:

Technology


1 download

DESCRIPTION

Easy about complex things. Data Warehouse, Business Intelligence, Data Governance. If you need help on this, Acctiva has an extensive experience to share. Take a look at our company introduction and see Acctiva's simple approach to these complex things.

TRANSCRIPT

Page 1: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Company introduction

www.acctiva.co.uk

Page 2: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

In the old days people used outsourcing to save

money. For this they hired offshore suppliers at

lower rates. And received cheap hands to do

simple work.

In the end people lowered their short-term costs

and utilized additional pair of hands.

Even though sometimes these hands acted behind

people’s will.

driven by a vision 1

Page 3: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

But times have changed!

Reducing costs is not enough anymore.

driven by a vision 2

Page 4: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

People now understand, they need not just

another pair of hands,

But hands and heads, who can meet people’s will

and understand people’s wishes.

These days people need not just an outsourcing

supplier…

But outsourcing partner to respond to changing

market conditions at a lower risk.

driven by a vision 3

Page 5: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

We understand people’s wishes.

We understand how to lower people’s risks.

And this comes out of our core principles.

We call these principles

Reduced Risk Outsourcing

driven by a vision 4

Page 6: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Trust & Transparency

Hybrid Structure

Focus on Services &Technologies

Reduced Risk Outsourcing

driven by a vision 5

Page 7: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Get the best of both worlds…

Hybrid Structure

driven by a vision 6

Inshore

Company

Nearshore

Competence Centres

Page 8: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Inshore Company: Client Relationship Centre

Client Relationship Centre

UK

driven by a vision 7

Page 9: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Sales

Marketing

Client Management

Purchasing

Client Relationship Centre

Roles & Responsibilities

driven by a vision 8

Page 10: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

13 YEARS ˑn market

UK BASED management team

COMMON LEGISLATION and business procedures

GUARANTEE of contract obligations

STABILITY and predictability

Advantages

driven by a vision 9

Page 11: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Andrew Saoulis Managing Director

Gennadiy Armashula Business Development Director

• 30+ years experience in IT • 20+ years of practical

management • A nice person to talk to and

work with • Likes oysters with beer on

Fridays

• 20+ years experience in IT • Founder of 5 companies • Predicts thoughts • Owns and plays 7 guitars

Irina Zhelezniakova Business Development Manager

• 8+ years experience in IT • 6+ years of partner and client

management • Likes going to Ronnie Scott’s

in red shoes

Management Team in Faces

driven by a vision 10

Page 12: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Competence Centres

Nearshore Company: Competence Centres

driven by a vision 11

Page 13: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Roles & Responsibilities

driven by a vision 12

Competence Centres

Pre-sales

Technical Support

Implementation Services

Development Services

Page 14: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Developers and architects

Projects delivered

DWH

27 BI

18 DG

4 58 certificates

Staff turnover <5% 12 Years

ˑn the market

Advantages

90 49

driven by a vision 13

Page 15: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Alexander Technology Services Director

Oleg Team Lead

• 12+ years experience in IT project management

• Certified in PM and Methodology

• Highly committed person • Has played football since he

was 5

• 15+ years experience in warehousing

• Certified: Oracle, Informatica, IBM

• In his free time teaches his kids to optimize database performance

Competence Centres in Faces

driven by a vision 14

Alexey Project Manager, Team Lead

Janusz Senior Architect, Project Manager • 20 + years of experience in

software development, project management and IT strategy

• Certified: PRINCE2 • Get inspiration in classical

literature for own publications

• 20+ years of experience in software development, enterprise architecture and project management

• Certified: TOGAF, PMP • Builds corporate architecture

as easy as he runs marathon

Page 16: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

4th WORLD PLACE for number of IT specialists

Top30 OUTSOURCE LOCATIONS

107 000 IT PROFESSIONALS available on the market

2 HOURS’ FLIGHT from London

Ukraine:

Poland:

Why Eastern Europe?

driven by a vision 15

250 000 IT PROFESSIONALS available on the market

2 HOURS TIME DIFFERENCE from the UK

EUROPEAN UNION MEMBER

OUTSOURCE LOCATIONS Top20 since2004

Page 17: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Business

Intelligence

Data

Warehousing

Data

Governance

We do not do everything. We are focused instead…

Focused Services

driven by a vision 16

Page 18: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Data Warehousing platform is at the core of any reliable and efficient Business Intelligence and Analytics solution.

And…

We have over 12 years experience of working in a wide variety of data environments and building best-in-class Data Warehousing infrastructures.

Focus on Data Warehousing

driven by a vision 17

Page 19: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Data Warehouse Architecture

and Infrastructure

Data Warehouse / Data Mart

Design

Data Integration

Data Quality

Data Sources

Operational

System

ERP

CRM

SQL

Flat Files,

Spredsheets

Data

Validation

Data Cleaning

Data

Transforming

Data

Aggregating

Data Loading

Data Warehouse

Datamarts

ETL

Extract, Transform, Load

Data Flow

driven by a vision 18

Data Warehousing Services

Page 20: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

12 YEARS OF PRACTICAL

experience

SUCCESSFUL PROJECTS for Telco, Banking, Retail, Manufacturing

SPECIALISTS analysts, architects, developers

TECHNOLOGIES Oracle, Informatica, Microsoft … your platform

27

50

Data Warehousing Competencies

driven by a vision 19

Page 21: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

We proposed for the client an integrated solution of a Data Warehouse System

based on Oracle data warehouse methodology. This solution contained 3

integrated data layers: operational, detailed and analytical, to provide better

capability of the system. Users access to the Data Warehouse was accomplished

by means of SAP BusinessObjects BI tool.

At the end of the 16-months project the client received a single source of accurate data, an improved reporting, reduced time of reports generation, quick access to analytical data for all involved business users.

At present the System supports over 2 thousand users.

A leading Telco company with over 26 mln. subscribers received its reporting from different departments in various formats generated from separate source systems. Information was managed with the help of an in-house data warehouse system that didn’t integrate source systems. One and the same data varied in different reports, as there was no single source of correct information.

Data Warehousing Case Study

driven by a vision 20

Page 22: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Business Intelligence is all about getting a better business insight just in time to make a critical managerial decision.

And…

We understand your challenges and know how to address them with the right method and tailored technology solution.

Focus on Business Intelligence

driven by a vision 21

Page 23: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Business Intelligence Services

Presentation Level Design

Dashboards and Reports

Development

Data Flow BI results

OLAP

Analysis

Data Mining

Data

Visualization

Reports

Dashboards

Alerts

Datamarts

driven by a vision 22

Page 24: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

10 YEARS OF PRACTICAL

experience

SUCCESSFUL PROJECTS for Telco, Banking, Retail, FMCG

SPECIALISTS analysts, architects, developers

TECHNOLOGIES SAP, Oracle, IBM, Microsoft … your platform

18

33

Business Intelligence Competencies

driven by a vision 23

Page 25: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

driven by a vision 24

Business Intelligence Case Study

We implemented Analytical Reporting System based on SAP BusinessObjects

platform for required subject areas, such as Credits, Deposits, Current Accounts

and some others. It included database for integration data from subject areas into

Data Mart and analytical reporting tool.

After 6 months of project lifetime the client received a set of over 200 ready-for-use analytical reports and semantic layer objects (8 universes) for ad-hoc analysis. Users received complete and correct data about their clients, accounts and their transactions.

Our client, one of the leading commercial banks, had 3 separate DWH systems for different data areas and types of analysis. But data from these systems could not be integrated for reporting. Analytical reports were generated exclusively by the IT team in the form of data sheets with no possibility for interactive analysis. Users received their reports after constant delays.

Page 26: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Data Governance is a quality control discipline for managing, using and protecting your data, turning it into a valuable corporate asset.

And…

We can support your efforts in building a sound Data Governance process and platform.

We will support you in getting maximum value of your data.

Focus on Data Governance

driven by a vision 25

Page 27: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Data Governance Strategy

Master Data Management

Metadata Management

Data Governance

Council

Me

tad

ata

Ma

na

ge

me

nt

Da

ta S

ec

uri

ty

Ma

ste

r D

ata

Ma

na

ge

me

nt

Ma

ste

r Q

ua

lity

Ma

na

ge

me

nt

Data Architecture

driven by a vision 26

Data Governance Services

Page 28: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Data Governance Competencies

driven by a vision 27

3 YEARS OF PRACTICAL experience

SUCCESSFUL PROJECTS for Telco

SPECIALISTS analysts, architects, developers

TECHNOLOGIES Collibra, Informatica, SAP, IBM, Microsoft

4

7

Page 29: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

The client had lots of data but no procedures to manage it, no assigned roles

for employees on each stage of data processing. There was no unified product

catalogue. As a result there was a discrepancy in the products profitability reports.

Data problems were being solved reactively, as nobody knew what to do when the

problem occurred.

As a result, client is able to understand his metadata, where it comes from and

can react on its changes proactively. All in all, he received a new level of quality in

his data that enables informed decision-making based on complete and correct

information.

Our client, a big Telco company, has lots of operational data. But the more data there is, the more difficult it is to process it, especially when nobody knows what this data means, who created it and for what purpose.

Acctiva implemented Metadata Management System based on Informatica Metadata Manager & Business Glossary and Collibra Data Governance Center.

Data Governance Case Study

driven by a vision 28

Page 30: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Trust & Transparency

driven by a vision 29

We build relationships

with our clients based on

2 principles:

Transparent engagement processes Trustful relationships

Outsourcing is risky unless it’s a transparent partnership…

Page 31: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Outsourcing always carries a risk to the company of losing control of their business processes.

We understand your concerns and offer to reduce your risks by using transparent Engagement

models:

Dedicated team

Full scope project

Set scope project

Transparent Engagement

driven by a vision 30

Page 32: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Benefit: People with the appropriate skills under your control

Pricing model: Time & Materials

Project scope, estimation & planning

Project management

Client responsibilities: Managed resourcing

Staff warranties

Acctiva responsibilites:

driven by a vision 31

Dedicated Team

Page 33: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Provide business vision Provide goals Approve project scope Provide information support Accept results

Project scope & estimation Project planning & execution Project management Project handover & closing

Benefit: Project team to deliver a complete solution and support

Pricing model: Fixed Price, Time & Materials

Client responsibilities:

Acctiva responsibilites:

Full Scope Project

driven by a vision 32

Page 34: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Set Scope Project

driven by a vision 33

Input requirements

Results & timing requirements

Accept results

Works planning & estimation

Works execution

Works delivery

Benefit: Skilled team to deliver a set scope of works under your requirements for your project

Pricing model: Time & Materials, Fixed Price

Client responsibilities:

Acctiva responsibilites:

Page 35: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Understanding is vital for effective interaction. When both parties have a similar vision of the process and awareness of further actions, it’s easier to achieve the goal.

That is why we use world-class

methodologies for projects

delivery.

We divide them into:

Horizontal

Vertical

Transparent Methodology

driven by a vision 34

Page 36: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Initiating

Planning Closing

Monitoring

Controling

Executing

PMI

Project Lifetime

To manage project processes and activities from the point of initiation to project completion regardless of specific project objectives we use core principles of these project management methods:

PMI

CMM

We define them as Horizontal as their purpose is to lead us through the project time line.

Horizontal Methodologies

driven by a vision 35

Page 37: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Analyze

Architect

Operate

So

luti

on

de

ve

lop

me

nt

Deploy

Design

Build Test

To deliver solutions we need a methodology designed with consideration of the specific solution objectives. We use:

Velocity – for Informatica based solutions

Fast Track DWH – for Oracle based solutions

Others… We call them Vertical since these methods are designed to accomplish specific product based solutions.

Vertical Methodologies

driven by a vision 36

Page 38: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

CLIENT oriented attitude

DEDICATED MIDDLE MAN between client and project team

DEFINED RESPONSIBILITIES for each team member

CLEAR ESCALATION procedure

REGULAR: Status updates/Reporting/Results delivery

DETAILED documentation

SIMILAR vision of goals

Trustful Relationships

driven by a vision 37

Page 39: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

Find out

What we can do together…

driven by a vision 38

Page 40: Acctiva: expertise in Business Intelligence, Data Warehousing, Data Governance

T: +44 (0) 1494 88 32 02 M: +44 (755) 176 76 94

e-mail: [email protected]

or [email protected]

Acctiva Limited

58 Queens Rd., Reading RG1 4RP, UK

ʠ��������������������������ǣ

driven by a vision 39