1. technology and computing
2. software
3. databases

Capgemini significantly
improves performance
and reporting with
Oracle Exadata
with you
Elizabeth Rabet
September 2014
Capgemini – Global Oracle overview
Over
13,000 Oracle trained resources including 5,000+ Oracle specialized consultants and
650 Oracle Cloud Specialized resources globally.
5,000+ successful implementations of Oracle applications across all industry sector, with
delivery quality ensured through various delivery centers, CoEs, and Capgemini innovative
methodologies (Rightshore, Rapid, ASE and more).
2013 Oracle
Specialized Partner of the Year, 2013 Customer Support Services Partner of
the Year, 2012 Global Specialized Partner of the Year.
Capgemini has received various Oracle partner awards/recognitions, including
20+ Oracle approved solutions globally, and expertise spread throughout the Americas,
Europe, Asia Pac, etc. With 20+ demo centers and 15+ CoEs worldwide.
Capgemini is recognized as a Diamond Level Partner of Oracle – the highest status – with 30
basic and 12 advanced specializations (including Sales Cloud and HCM Cloud
Advanced Specializations) on Oracle.
Oracle Engineered Systems | September 2014
Copyright © Capgemini 2014. All Rights Reserved
2
Capgemini can leverage its Global Finance System
(GFS) in partnership with Oracle and deliver improved
performance at lower costs for its clients
Capgemini is a global company operating in over 40 countries with 140,000
employees
 eBusiness suite 11i single instance
 An SAP BO based data warehouse
 In an house project reporting tool
(N2K – Need to Know)
 31 countries
 65 legal entities
 99 Operating Units
 130,000 employees
 100,000 projects
 A single, global support
organization
IM
AM
 Paris
 24h/7d
CC
 Paris
 8 a.m. – 8 p.m.
CET
 5d/7
 Mumbai
 5 a.m. – 1 a.m.
CET
 5d/7
Oracle Engineered Systems | September 2014
Copyright © Capgemini 2014. All Rights Reserved
3
GFS challenges
 Each financial center has its own financial close process and timing, even
though GFS is a single instance financial system
 The bulk of financial processing done at month end
 GFS has a financial process based on daily, multiple, full cycle iterations from
Oracle E-Business Suite to reporting
Local
Apps
Interface batches
Extract
BO
Local
Reports
Oracle DB
Queries
Transactions
BO
Data
Warehouse
Oracle eBs
Oracle DB
GFS users
Interface batches
Global
Apps
Oracle eBs
 Bi-hourly 5h-23h CET
 Meta data nightly
SAP ETL
Extract
Daily
N2K
Project
Data
BO
Group
Reports
Net
Application
Oracle DB
Exadata
N2K
Oracle Engineered Systems | September 2014
Copyright © Capgemini 2014. All Rights Reserved
4
Oracle Exadata Database Machine enables us to combat
these challenges via its unique features and capabilities
Benefits
Specific Objectives
 10x Faster Database
 10x More Efficient Storage
 Lower operations and
capital costs
 End-to-End Resource
Management
 Most Available and Secure
 Reduce the Oracle
E-Business Suite- toreporting iteration time
 Reduce report turn
around time
 Absorb new deployments
and organic growth
without impacting
performance
Unique Features
 Exadata Intelligent Storage
Grid
 Exadata Hybrid Columnar
Compression
 Exadata Smart Cache Flash
This delivers extreme performance for data warehouse, OLTP and mixed workloads
www.oracle.com/exadata
Oracle Engineered Systems | September 2014
Copyright © Capgemini 2014. All Rights Reserved
5
This drives tangible results, especially around the
acceleration of the close process …
Activity Report
Production
Acceleration of activity report production of customer projects, available to
Data
Centralisation
Centralization and extraction of mass data on a bihourly basis from the Oracle
Budget
Tracking
User
Experience
over 2,000 financial managers and 4,500 project and engagement managers
E-Business Suite-based accounting and financial system
Optimization of budget tracking and operational valorization to ensure that
system can manage 100,000+ IT projects and provide real-time
financial planning
Improvement in user experience and user productivity by providing real-time
project tracking, acceleration of bandwidth-consuming queries, and report
execution improvement
Shared Service Center Enabler
Oracle Engineered Systems | September 2014
Copyright © Capgemini 2014. All Rights Reserved
6
The situation
BO
GFS ebs
Data Warehouse
Exadata
 2,000 users
 50,000 reports
N2K
Project Data
Exadata
 4,500 users
700,000 ICB transactions
 250,000 reports
500,000 batches
2,200 ebs users
Oracle Engineered Systems | September 2014
Copyright © Capgemini 2014. All Rights Reserved
7
Results by the numbers
 ETL time reduced by half for EBS to DWH
 ETL time reduced 8x for EBS to N2K database
 BO average report turnaround time
reduced 4x
 40% increase in data volumes absorbed with
no impact on performance
 Reduction of 1 FTE for run operations
(25% savings)
 Solution coverage has tripled
 250,000 N2K reports generated every
month without impact on performance
(increase of 3X since Exadata implementation)
 50,000 SAP BusinessObjects reports
absorbed without impact on average
turnaround time (100% increase in 3 years)
Exadata Implementation
Oracle Engineered Systems | September 2014
Copyright © Capgemini 2014. All Rights Reserved
8
Success with Oracle Exadata
“Thanks to Oracle Exadata, we were able to build a
secure, scalable, and robust business intelligence
infrastructure for our group finance system.
The solution has scaled up to encompass 3x the
footprint we had when we started three years ago,
with no impact on performance.
User confidence has been restored, as we have
optimized our operational reporting process by 100%,
producing more than 300,000 reports per month,
without impacting our transactional financial system.”
Oracle Engineered Systems | September 2014
Copyright © Capgemini 2014. All Rights Reserved
9
Q&A
with you
Capgemini will help multiply the benefits of Oracle
Engineered Systems with our 3 service offerings
Platform Rationalization with Management-as-a-Service and
Outsourcing
Applications Modernization by Industry
Database Consolidation with Big Data and Analytics
Learn more at www.capgemini.com/oracle-engineered-systems
Visit us at Moscone South, Booth #911
Contact: Subir Dutt; Executive Sponsor Engineered Systems: [email protected]
Oracle Engineered Systems | September 2014
Copyright © Capgemini 2014. All Rights Reserved
11
t-Police and Oracle Exadata
 Capgemini incorporated Oracle Exadata into
Transform Police, or t-police, part of our
Ready2 series of intellectual property (IP
solutions)
 t-Police enables more informed and connected
police services through an integrated law
enforcement solution that enhances frontline
and support functions
 t-Police is supported and Ready to run on
Oracle Exadata Database Machine, Oracle
Exalogic Elastic Cloud, Oracle Exalytics InMemory Machine and Oracle Supercluster
Learn more at www.capgemini.com/public-sector/transform-police-t-police
Visit us at Moscone South, Booth #911
Contact: Nick James; [email protected]
Oracle Engineered Systems | September 2014
Copyright © Capgemini 2014. All Rights Reserved
12
About Capgemini
With almost 140,000 people in over 40 countries, Capgemini is
one of the world's foremost providers of consulting, technology
and outsourcing services. The Group reported 2013 global
revenues of EUR 10.1 billion.
Together with its clients, Capgemini creates and delivers
business and technology solutions that fit their needs and drive
the results they want. A deeply multicultural organization,
Capgemini has developed its own way of working, the
Collaborative Business Experience™, and draws on Rightshore®,
its worldwide delivery model.
Learn more about us at www.capgemini.com.
www.capgemini.com
The information contained in this presentation is proprietary.
Copyright © 2014 Capgemini. All rights reserved.
Rightshore® is a trademark belonging to Capgemini.