ORACLE HYPERION PLANNING Implementation in NIS Budapest 20
Конфиденциально ORACLE HYPERION PLANNING Implementation in NIS Budapest, 20. 11. 2014 1/7
Конфиденциально Road to success Define requirements 2 Define strategy Define execution plan
Конфиденциально Key points to remember Budgeting and management consolidation reports are integrated part of complex reporting system of every company During process and budgeting model definition you will be able to discover most of the weaknesses of current budgeting process, optimize time and resources During process and budgeting model definition all relevant stakeholders must be actively included in the project 3
Конфиденциально Steps to develop new methodology Issue coding Walkthrough Level 1: Strategic Alignment check planning alignment Stratification of reports Dynamic Flexible analytics & Reporting / Queries Simulation & Advanced analysis BI / EPM Transacfunctional scope tional Static Reports Dashboards & visualisation Analytics & reporting; Business planning & Budgeting; Strategy & management √ √ Level 2: Operational planning alignment √ √ √ KPI list Emphasis on: • Strategic vs. Operating KPIs • Consistency check (Name / Formula / Measure/ Data source) • Best Practices KPI dictionary 4 Issue coding RACI Matrix √
Конфиденциально Solution footprint Strategy Management BI Foundation Suite Business Planning & Budgeting Financial Consolidation BI Foundation Suite Hyperion Planning Data management and repositories (DATA WAREHOUSE & META DATA LATER) Data Transformation and Integrity (ETL - extraction, transformation and load) CORE TRANSACTION SYSTEMS Operational data extraction EXTENDED ERP SYSTEM ERP CORE BACK-OFFICE FUNCTIONALITIES CRM LOYALTY Order to Cash General Ledger Procure to Pay Managing Financial Resources (Investment projects, Treasury) Integration Emerging NIS core transactional systems* 5 SCM EAM Operational reports TBC Costing & Profitability BI Foundation Suite Planning data Balanced scorecard Costing and Profitability reports Analytical & Management reports Corporate Performance Management BI/EPM SYSTEM Analytics & Reporting Data corrections Portal BI Foundation Suite
Конфиденциально Business requirements What should we change? Implementing appropriate budgeting solution and integrate with new GPN corporate Co. A Adopting financial structure in accordance with strategic business development (from 45 to more than 100 consolidation levels) Standardizing budgeting forms and approval process for all segments Optimize time necessary for realization of business planning process in more complex financial structure 6 Solutions We have chosen Hyperion planning as appropriate application, finished implementation and now we are integrating with GPN management reporting system We should create new model that would ensure financial result and operating indicators analysis on every consolidation level We should adopt existing Corporate budgeting Standard and redesign integrated approval process We should adopt integrated system solution that would ensure data entry and approval process monitoring Ensure planning assumptions alignment with Corporate strategy We should Centralize planning assumptions entry and integrate within budgeting model (FX rates, spreads, quotations, variable borrowing rates, margins etc. ) Ensure actual data integration with Budget data within Hyperion – “green button” We should design integration forms between ERP/BI system and Hyperion, ensure plan vs. actual analysis in comparable structure
Конфиденциально Project step 1: Methodology development Financial structure Approval process NIS Group NISAD OFS REF UPS SRB PRO ENR Group budgets NC ANG SEV SRD BAC GMT 1 GMT 2 GMT 3 ELM Functional budgets (Co. A) Parameters model Price calculation model Adjustments Consolidation model (corrections and eliminations) Product costing model KPI calculation model Register model High level budgets Budgeting model P&L BS CF • Profit and loss statement available on every level of financial hierarchy • FA is formed on the Blocks and calculation elements level • BS, WS and CF are formed on NIS Grupe level Standard of business planning 7 WC FA
Конфиденциально Project step 2: System Implementation Budgeting model handover, technical request approval and project scope definition Adopting your model in accordance with system functionalities, system architecture design, documenting process Implementation and testing of Hyperion Planning Go-live and postproduction support First and second level of system administration preparation, IT and Functional administrator training organization Training users and administrators Support agreement 8
- Slides: 9