1 / 13

Capgemini significantly improves performance and reporting with Oracle Exadata

Capgemini significantly improves performance and reporting with Oracle Exadata. 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.

jalen
Télécharger la présentation

Capgemini significantly improves performance and reporting with Oracle Exadata

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Capgemini significantly improves performanceand reporting withOracle Exadata Elizabeth RabetSeptember 2014

  2. Capgemini – Global Oracle overview • Over 13,000Oracle trained resources including 5,000+ Oracle specialized consultants and 650Oracle 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). • Capgemini has received various Oracle partner awards/recognitions, including 2013 Oracle Specialized Partner of the Year, 2013 Customer Support Services Partner of the Year, 2012 Global Specialized Partner of the Year. • 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.

  3. 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 • Paris • 24h/7d AM • Mumbai • 5 a.m. – 1 a.m. CET • 5d/7 CC • Paris • 8 a.m. – 8 p.m. CET • 5d/7

  4. 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 LocalApps BO DataWarehouseOracle DB BOLocalReports Interface batches Extract Queries Oracle eBs BOGroupReports Transactions Extract • Bi-hourly 5h-23h CET • Meta data nightly Daily Oracle DB GFS users SAP ETL N2K Interface batches ProjectDataOracle DB GlobalApps NetApplication N2K Oracle eBs Exadata

  5. 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 andcapital costs • End-to-End Resource Management • Most Available and Secure • Reduce the OracleE-Business Suite- to-reporting iteration time • Reduce report turnaround 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

  6. This drives tangible results, especially around the acceleration of the close process … Activity ReportProduction Acceleration of activity report production of customer projects, available to over 2,000 financial managers and 4,500 project and engagement managers DataCentralisation Centralization and extraction of mass data on a bihourly basis from the Oracle E-Business Suite-based accounting and financial system BudgetTracking Optimization of budget tracking and operational valorization to ensure that system can manage 100,000+ IT projects and provide real-timefinancial planning UserExperience 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

  7. The situation BO GFS ebs Data Warehouse Exadata • 2,000 users • 50,000 reports N2K Project Data Exadata • 4,500 users • 250,000 reports 700,000 ICB transactions 500,000 batches 2,200 ebs users

  8. 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 everymonth 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

  9. 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.”

  10. Q&A

  11. 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: subir.dutt@capgemini.com

  12. 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 In-Memory 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; nick.james@capgemini.com

More Related