Challenges

• Build a financial and accounting system business intelligence environment while optimizing access to the transactional system based on Oracle E-Business Suite
• Optimize the operational reporting process, as well as the tracking and valorization of IT projects for consulting, technology, and outsourcing clients within 78 business units
• Improve operational activity reporting process for a large volume of reports in a changing global financial system through an optimized decision-making architecture
• Integrate a reliable architecture designed for enhanced development and performance within the existing transactional environment
• Reduce infrastructure and operational run costs by leveraging internal Oracle expertise

Solutions

• Moved the global business intelligence financial system on Oracle Exadata Database Machine accessible to more than 16,500 users and 78 business units in 28 countries
• Extracted mass data on a daily basis from the Oracle E-Business Suite-based group’s accounting and financial system to accelerate activity report production of the customer projects for 4,000 financial managers and project managers
• Enabled financial managers to produce a variety of activity reports including trends in revenue per business unit as well as business objectives against business unit occupancy rate
• Optimized budget tracking and operational valorization thanks to a business intelligence platform that can manage more than 80,000 IT projects in one year to improve the reliability of financial planning
• Improved reporting performance by 100% and reduced the average report execution time from four minutes to one minute with Oracle Exadata Smart Flash Cache features
• Increased activity report production in one year by 35%, enabling production of more than 250,000 reports per month
• Improved the user experience and the user productivity by providing real-time database tracking, detection of the most bandwidth-consuming queries, and report execution improvement, thanks to Oracle Enterprise Manager

Why Oracle

“Oracle helped Capgemini build a transactional financial infrastructure and a reliable and high-performing data warehouse to homogenize our global database systems and capitalize on our expertise to reduce costs. Choosing Oracle Exadata helped us combine scalability and performance to seamlessly transform our global financial system both in terms of managing data volume and increasing new user support, reliably, and effectiveness,” said Jerome Marchandiau, technical manager at Global Financial System, Capgemini.

Resources

• Capgemini augmente de 35 %  la production des rapports d’activités de ses Business Units  au niveau mondial et réduit de  75%  le temps moyen d’exécution des reporting opérationnels 
• More Reference Assets About Oracle Exadata and Professional Services