What is Oracle Hyperion Planning

1. What is Oracle Hyperion Planning Centralized, web-based Budgeting and Planning application Combines Operational and Financial measures to improve Business Predictability Provides a scalable planning solution with easy to adopt web based and Microsoft Office interfaces Provides Reporting capabilities to view any slice of data through the powerful multi-dimensional database engine

2. Oracle Hyperion Planning Key Features • Multi-dimensional / multi user planning with a powerful business rules engine • Flexible workflow and plan management capabilities • Comprehensive Microsoft Office integration • Easy to use Web interface • Seamless creation of reports and dashboards • Proven and scalable architecture • Robust integration with ERP systems and other sources • Full set of administrative tools for application management

3. Oracle Hyperion Planning Key Benefits • Reduce budgeting and planning cycles by weeks or months • Improve forecast accuracy • Appeal to a wider user community through an intuitive Web user interface • Shrink the learning curve for users by leveraging Microsoft Office products as an interface into Oracle Hyperion Planning • Eliminate time lag between when plans are updated and reports are refreshed • Reduce cost of ownership thought superior application deployment, management tools and packaged data integration • Lay the foundation for making the transition to Enterprise Business Planning

4. VECG Case Study: Planning as a Consolidation Application • Client Pain Points: • Existing spreadsheet planning process is costly, inaccurate, and inflexible for adjustments • Audit findings indicated lack of controls in existing process • Difficulty consolidating between multiple operating companies and currencies to produce plan • Key Objectives: • Provide a consistent web based interface for all corporate users • Replace the multiple spreadsheets, databases and other tools currently used • Improve the accuracy of reported plan and outlook results • Reduce the cycle time required to finalize plans and monthly outlooks • Provide powerful what-if scenario analysis capabilities to facilitate HR merit and other iterative analyses • Ease currency conversion calculations and provide a standard planning methodology for all currencies • Implement efficient Planning process to reduce corporate overhead labor costs • Scope: • Corporate consolidation process for Annual Plan and Monthly Outlook • Workforce planning and HR Analytics • Source data feeds and ETL logic • Necessary Reporting and Output feeds from Planning to HFM and EDW

5. Existing State Workflow

6. VECG Case Study: Project Approach • Detailed Engagement Options • Assessment Phase • Document Review • Technology Review • Functional and Technical Interviews • Current Situation Assessment • Technical • Further Breakdown by Component • Functional • Further Breakdown by Functional Area • Summary of Findings • Strengths/Weaknesses/Opportunities/Requirements • Recommendations • Technical • Short Term • Medium Term • Long Term • Functional • Short Term • Medium Term • Long Term • Technology strategy • Break down technical components • High level best practices • Recommended Approach by Phase • Phase Detail • High Level Proposed Timeline • Next Steps in Detail • Objectives • Assessment Requirements met in Phase I • Phase 1 Timeline

7. VECG Case Study: Project Strategy Phase 1 Design Develop phase 1 consolidation modules Infra Build Out (Dev) Phase 1 Deployment Prod Env Setup Phase 2 Design Develop phase 2 Outlook + R&D Phase 2 Deployment Phase 3 Design Develop phase 3 HR Analytics Phase 3 Deployment Phase 4 Design Develop phase 4 Annual Plan Phase 4 Deployment • Assumptions: • 1 VECG development resource added for Phase 1 development • Client resources focused on Requirements & Design efforts through November • Client development resource(s) to be cross-trained during phase 2 and 3 development • Client resources lead phase 4 development (assistance from VECG developers only as necessary) • VECG to lead development environment build out and cross train Client resources • Client to own production environment configuration with VECG support

8. Future State Workflow

9. VECG Case Study: Benefits • Dramatically reduced cycle time to Develop Plan and Monthly Forecast • Increased Accuracy of Plan • Reduced cost to develop Plan and Forecast • Rapid adoption by Planning community due to easy to use web based and Microsoft Excel interfaces • Simplified integration with HFM and EDW • AD HOC reporting capabilities unavailable in prior solutions