1 / 21

Oracle Open World 2014 EPM on Exalytics FIAT CHRYSLER AUTOMOBILES experience

Oracle Open World 2014 EPM on Exalytics FIAT CHRYSLER AUTOMOBILES experience. Agenda. The Group The Product The Process Information Systems ICT Challenges Project Challenges Project timeline Business Case & results The roadmap. Fiat Chrysler Automobiles – Group key figures*. 159.

ciaran-downs
Télécharger la présentation

Oracle Open World 2014 EPM on Exalytics FIAT CHRYSLER AUTOMOBILES experience

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. Oracle Open World 2014EPM on ExalyticsFIAT CHRYSLER AUTOMOBILES experience

  2. Agenda The Group The Product The Process Information Systems ICT Challenges Project Challenges Project timeline Business Case & results The roadmap

  3. Fiat Chrysler Automobiles – Group key figures* 159 3.394 1 16 Plants Net revenue (€Mio) 150 3.362 Group Commercial Brands 4 78 Countries (€Mio) for R&D investments 225.587 86.816 Regions R&D centers Employees (€Mio) Revenues *@31/12/2013 .

  4. The Group - Regions NAFTA EMEA APAC LATAM

  5. The Group - Brands

  6. The Product -Dimensional model Brand: Fiat Model:Freemont Version:2.0 Multijet II 16v 140 CV Serie: 1 Options:DVD, radio,… Trim Level: Urban Motorization:Diesel Powertrain:2.0 cc 140CV APPLICATION PERIMETER Brand: 8 Models: 70 Version/Serie: 5000 Options: 3000 Trim Level: 60 Motorization: 8 Powertrain: 50

  7. The Process- Major improvement for finance analysis - from wholesale reporting to retail analysis T0 + xx T0 Statutory Commercial control Integration from Dealer Frtont-end to Financial Systems Fleet Employee Retail Fleet Rent a Car Government Employee Dealer Rent a Car Retail

  8. The process- Major improvement for integration Marketing, Sales and Finance

  9. Information Systems - ICT Challenges Technological upgrade Process integration • Technological upgrade from Oracle Financial Analyzer/ Oracle Express for obsolescence • Process integration across countries and businessfunctions • Rolling forecast capabilities User Interface Performance • Easy to use data entry forms. • Reduce manual activities on excel spreadsheets and rolling forecast capabilities • More details, less time = more analysis capabilities • Commercial Reporting views: product dimensional model extension • User free reporting capabilities (web and excel) Reporting Application integration • new and used vehicle business, • pricing and incentives simulations, • spare parts and warranty control. Usability • accuracy • simplification, • flexibility 9

  10. Information Systems -Project Challenges Technological upgrade Process integration • Technological upgrade from Oracle Financial Analyzer/ Oracle Express for obsolescence • Process integration across countries and businessfunctions • Rolling forecast capabilities User Interface Performance • Easy to use data entry forms. • Reduce manual activities on excel spreadsheets and rolling forecast capabilities • More details, less time = more analysis capabilities • Commercial Reporting views: product dimensional model extension • User free reporting capabilities (web and excel) Reporting Application integration • new and used vehicle business, • pricing and incentives simulations, • spare parts and warranty control. Usability • accuracy • simplification, • flexibility 10

  11. Project Challenge – EPM Technological upgrade 11

  12. Project Challenges - Performance Technological upgrade Process integration • Technological upgrade from Oracle Financial Analyzer/ Oracle Express for obsolescence • Process integration across countries and businessfunctions • Rolling forecast capabilities User Interface Performance • Easy to use data entry forms. • Reduce manual activities on excel spreadsheets and rolling forecast capabilities • More details, less time = more analysis capabilities • Commercial Reporting views: product dimensional model extension • User free reporting capabilities (web and excel) Reporting Application integration • new and used vehicle business, • pricing and incentives simulations, • spare parts and warranty control. Usability • accuracy • simplification, • flexibility 12

  13. Project Challenge:Infrastracture ESSBASE PLANNING ODI OBIEE Server consolidation • 9 server wintel to 2 EXALYTICS System Management Model • TCO and application management simplification ContractualNegotiation • New Service Level ODS LEGACY C-level TCO COST REDUCTION

  14. EPM Technological upgrade: Project Timeline Business Case Business Case approval HW delivered on June 21 GO LIVE AUG 26 on all the applications and users 1 monthimplementation • Release upgrade • Applications migration EXALYTICS POC with ORACLE 2013 2012 Jun Apr Aug Nov Jul May Jan Set • Release upgrade da 11.1.2.1 a 11.1.2.2 • SR management • Change Management HW installed In Data Center on July 15 Business Case Business Case definition start With the participation of ORACLE Insight SOURCING HW and Licenses ORACLE OPEN WORLD EXALYTICS certified on HYPERION Planning The Project has respected the Timeframe and the Economical Targets with the help of:

  15. Business case - highlights Business Benefits • Reduced Budget cycletimes • Reduced Data Consolidationtimes • Reduced Reports Availabilitytimes Productivity Benefits • Improved Productivity of: • Planning and Reporting IT Staff • Application Users Operational Benefits • Running maintenance • Evolutionary maintenance Infrastructure TCO Benefits • Improved Cost Figures due to Consolidation: • Computing • Storage

  16. Business Case results – Timing and economics INVESTIMENT - Pay Back period: 1 Year • TCO - Cost Reduction:15% • IMPLEMENTATION TIME- 50% lessthanplanned

  17. Business Case results– Customersatisfaction USERS • Calculation time reduction: 65%: • Overlappingcalculatios time improvement: 100% BACK-END (consolidation): • Elaboration time reduction: 65% • Consolidation time reduction: 50% FUNCTIONALITIES: EXALYTICS implementationhasenabled: • Possibility to perform «what-ifanalysis» thanks to calculation time reduction • Possibilityto ultilizeBI Mobile, for managerialdashboard (C-level)

  18. The Roadmap: Landscape Group ReportingLayer ReportingLayer by Region E E E E L L L L N N N N A A A A ConsolidationLayer reportingperemiter reportingperemiter reportingperemiter reportingperemiter • Planning Layer E L A N DataWarehouse Layer Accounting Layer Legacy System Legacy System Legacy System Legacy System … … … … … … … … … … … …

  19. The Roadmap: Global Reporting Systems on Oracle OBIEE Group ReportingLayer ReportingLayer by Region ESSBASE E E E E L L L L N N N N A A A A ConsolidationLayer FINANCIAL MANAGEMENT FDQM reportingperemiter reportingperemiter reportingperemiter reportingperemiter • AnalyzingLayer HYPERION PLANNING / ESSBASE E L A N DataWarehouse Layer Accounting DocumentLayer Legacy System Legacy System Legacy System Legacy System … … … … … … … … … … … …

  20. Inserire Titolo Evento Thanks for yourattention

  21. Project Challenge -Performance • Planning and Simulation: The level of detail required in the planning stage makes the process simulation very complex and time consuming (i.e: a complex Forecast takes 2 days for a complete cycle). The calculations complexity and the level of details force users to restrict the simulation and calculation time of the what-if scenarios • Reporting Environment: The back office activities to consolidate and publish data of all the markets on the reporting environment takes more than a day with a big impact on the availability of data for the executives. In addition some dashboard don’t meet the performance requirements expected Flexibilityandspeedof reaction are essential requirements

More Related