acctiva: expertise in business intelligence, data warehousing, data governance
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
Company introduction
www.acctiva.co.uk
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
But times have changed!
Reducing costs is not enough anymore.
driven by a vision 2
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
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
Trust & Transparency
Hybrid Structure
Focus on Services &Technologies
Reduced Risk Outsourcing
driven by a vision 5
Get the best of both worlds…
Hybrid Structure
driven by a vision 6
Inshore
Company
Nearshore
Competence Centres
Inshore Company: Client Relationship Centre
Client Relationship Centre
UK
driven by a vision 7
Sales
Marketing
Client Management
Purchasing
Client Relationship Centre
Roles & Responsibilities
driven by a vision 8
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
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
Competence Centres
Nearshore Company: Competence Centres
driven by a vision 11
Roles & Responsibilities
driven by a vision 12
Competence Centres
Pre-sales
Technical Support
Implementation Services
Development Services
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
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
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
Business
Intelligence
Data
Warehousing
Data
Governance
We do not do everything. We are focused instead…
Focused Services
driven by a vision 16
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
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
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
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
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
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
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
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.
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
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
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
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
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…
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
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
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
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:
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
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
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
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
Find out
What we can do together…
driven by a vision 38
T: +44 (0) 1494 88 32 02 M: +44 (755) 176 76 94
e-mail: [email protected]
Acctiva Limited
58 Queens Rd., Reading RG1 4RP, UK
ʠ��������������������������ǣ
driven by a vision 39