Improving Enterprise Performance Management

1. Improving Enterprise Performance Management Len Romano – Regional Director

2. SUCCESS Create Strategic Vision RECOGNITION Define Project Goals VALUE ACHIEVEMENT Quantify Success CONFIDENCE Implement Solutions Develop Client Expertise TopDown Consulting, Inc. At a Glance • Oracle Certified Advantage Partner • Over 400 successful customers globally Differentiators • Experts in EPM and BI solutions • Financial Reporting and Close Cycle • Planning, Forecasting, and Modeling • Operational Reporting and Analysis • Scorecards and Dashboards • Proven Project Success Methodology™ • Infrastructure and Technical Expertise • TopDown Migration Manager™

3. Defining Enterprise Performance Management • Set of integrated, closed-loop management and analytic processes, supported by technology, that address financial as well as operational activities • Enables businesses to define strategic goals, and then measure and manage performance • Core processes linked to organizational strategy • Financial and Operational Planning • Consolidation and Reporting • Modeling & Analysis • Monitoring of KPI’s

4. EPM VisionExtend Operational Excellence to Management Excellence Competitive Advantage MANAGEMENT EXCELLENCE OPERATIONAL EXCELLENCE Time

5. Technology Enables Tools Process How and Why Repeatable / Sustainable Culture Defines the company Degree of change T P C The Balancing Act BalancedSolution

6. Key Drivers for Adopting EPM • Close the gap between strategy and execution • Effective performance measures • Compliance • Sarb-Ox / IFRS • Not a one-time exercise • Penalties • Governance, Risk and Compliance • Communication • Align business strategies for all stakeholders • Competitive advantages • Visibility and insight • Collaborative • Decision making • Respond vs. React • Confidence • Collaborative environment • Improve quality of information • Ownership • Closest to the source

7. EPM WORKSPACE Web Search • Alerts Mobile Desktop Office Performance Management Applications BI Applications BI Applications Business Intelligence Foundation Fusion Middleware OLAP Data Warehouse Data Mart Business Process OLTP & ODS Systems SAP, Oracle, Siebel, PeopleSoft, Custom Excel XML Oracle’s EPM System

8. Oracle Performance Management Applications Strategic Products

9. Hyperion Planning at a Glance Planning Budgeting Top Down and Bottom up Planning Driver Based Planning Workforce & Capital Asset Planning Resource Allocation Budgetary Process Management Reviews and Approvals Forecasting Variance Management Predictive Analysis Statistical Forecasting Scenario Analysis and Versioning Plan vs. Actuals Exception Management Root Cause Analysis and Explanation

10. Hyperion Financial Management Consolidating Compliance Global financial consolidation, reporting and analysis Collects, consolidates & reports financial results in multiple GAAPs & IFRS Reduce the cost of compliance i.e. Sarbanes-Oxley , electronic filing, & other regulatory requirements Support disclosure requirements, such as sustainability reporting Auditing Reporting Complete audit trails 10K/Q to general ledger audit trail, providing confidence in the numbers Powerful reporting and analysis tools Deliver timely results internally and externally

11. Hyperion Workforce Planning Planning Budgeting Plan salary and other compensation Add and delete new hires Integration with external HR systems Budget for salaries and bonuses Plan projects/salary at any level Forecasting Management Set payroll taxes for states & years Forecast compensation for hourly employees Manage status of existing employees Transfer employees between depts.

12. Hyperion Capital Asset Planning Planning Simulating Automates planning of capital assets & capital asset related expenses, such as depreciation, maintenance and insurance Built-in functionality includes account structures, calculations, Smart Lists, data forms, dimensions, and menus Assessing Management Assess the impact of your capital expenses on your overall expenses and financial statements Modify existing capital assets with improvements, impairments, and retirements, as well as transfer capital assets from one cost center to another using multiple methods

13. Hyperion Strategic Finance Modeling Planning Financial modeling identifies financial impact of alternative strategies Debt Scheduler models cash flow & implications of debt Integrate long-term planning, treasury strategies and corporate development analysis Simulating Reporting Deal Period functionality to simulate mergers and acquisitions Freestyle Reporting for professional-quality reports and graphs

14. Dashboards & Scorecards

15. Oracle Business Intelligence Enterprise Edition

16. Financial Reporting

17. Getting Buy-in CXO level to all stakeholders is critical It is important to show the value to all audiences Engage with a partner who has previous experiences and can present the strategic value of the solution Showing Business Value It’s NOT just about being able to close your books and report faster, nor is it just about being able to better plan It IS about being able to gain a competitive business advantage by modeling “what if” scenarios and being more agile and nimble It IS about being more dynamic and gaining the ability to to re-forecast on a monthly basis versus having an annual static budget that doesn’t take into account where things are today Best Practices in Implementing EPM & BI

18. Reducing the Time to “Go Live” Leverage a partner with specific domain expertise in finance and reporting and previous experience with implementing Hyperion EPM and BI solutions Understand Risks, Political and Cultural Impacts Know and understand the potential political and culture issues in advance so they can be mitigated and eliminate resistance Implement in Phases Pilot, department rollout, enterprise rollout Training Ensure each stakeholder is successful by ensuring proper training from a knowledge expert Best Practices in Implementing EPM & BI

19. Documentation Ensure the solution rollout is documented to ease any future changes to the system Improving Best Practices Build an EPM or BI Center of Excellence Educate the organization on the value – i.e. how strategic financial and operational planning, workforce planning, world-class financial close, performance scorecards and dashboards, business intelligence and modeling “what if” scenarios creates a Performance Accountable Organization (PAO) Choosing a Partner Select a partner that covers the full spectrum of Hyperion technologies and understands how ERP fits into the picture Best Practices in Implementing EPM & BI

20. Apollo Group • Reporting packages produced directly from transactional systems • Heavy reliance on Excel for consolidation, planning, and reporting • Financial and Planning Models required significant time to update, distribute, and collect data • Company was actively acquiring new schools globally • Need to improve Sarbanes-Oxley compliance & auditability • Lack of financial and KPI analysis and reporting • Define Business Requirements • Design, Develop, Implement, Test and Train in support of global Implementation of HFM • Establish data integration strategy to support HFM and Planning • Leverage Best Practices to define world class standardized external reporting toolsets • Establish SOX compliant security processes for system access and change controls • Improve Financial and KPI reporting and analysis utilizing OBIEE Financial Analytic Application • Streamlined and accelerated monthly close process • Established SOX-compliant security processes for system access and change controls • Improved Budget and Forecast process • Created single version of the truth with tighter Oracle EBS integration • Designed Dashboards and Data Warehouse to facilitate flexible & timely reporting of financial & operational data • Improved controls and efficiency by automating manual tasks and increasing user satisfaction • Architected to support future projects • Global Consolidation, Planning, Forecasting, Reporting, and Analysis, including both Financial & Operational Detail • HFM, FDM, Planning, Essbase, OBIEE, BI Applications

21. Contact Information • Len Romano • Regional Director • (708) 453-1549 • lromano@topdownconsulting.com