Consumer Goods/Food Manufacturing

CheckPoint provided automated solutions to greatly reduce, and in some instances eliminate, the costs associated with manual processes for one of the largest consumer goods manufacturers in the world.

Our team of seasoned experts developed an actionable EPM solution roadmap to implement multiple Oracle Hyperion products, including HFM, Planning, Essbase, IOP, DRM and FDM, resulting in horizontally and vertically scalable environments for this company as well as integration with their SAP transactional data. This client can now have flexibility for application and user growth. Other benefits include increased stability of existing environments, assurance of recovery in critical failure scenarios, the ability to execute migrations between environments while maintaining complete application integrity, and enhanced internal knowledge of the LCM tool for more IT autonomy.

Additionally, a set of standardized business structures can now be used across the enterprise and calculation of key business metrics is supported, provding better performance analysis. Procurement and product costing decision makers now have the ability to model changes in commodities and link directly to the financial forecast.

Client Issue

• Manual and inefficient close process delayed delivery of accurate reporting
• Product/Customer profitability distributed across multiple applications at group level resulting in fragmented and incomplete reporting
• Lack of standard governance processes and methods across divisions
• Limited capability to provide the demand creation side of the organization with actionable information in a timely fashion

Hands On Approach

• Assessed the current state and drove requirement needs into an actionable performance management solution roadmap to implement multiple Oracle Hyperion and BI Products (HFM, Planning, Essbase, IOP, DRM, FDM)
• Program Managed a large scale complex program with both CheckPoint and client’s technical resources
• Designed EPM environment to provide more timely and accurate data, single version of truth and a self-service environment for end users
• Provided change management plan and activities to adopt the new performance management processes
• Developed HFM for consolidations, Hyperion Planning for Product/Customer monthly profitability and more detailed forecasting; Essbase ASO reporting cubes for historical reporting
• Developed and rolled out commodities analytics utilizing Integrate Operational Planning (IOP) to help create a sandbox for “what if” analysis, adjust by any level in the commodity hierarchy, and review and approve sandbox adjustments to baseline
• Designed Extract, Transform and Load (ETL) processes to extract master and financial data from SAP R/3 and SAP BW
• Designed Data Relationship Management (DRM) as central repository for all EPM hierarchies, integrated directly with EPMA for tight integration and EPM master data management
• Designed standard allocation methods applied to all divisions
• Designed, built and optimized the technical infrastructure to support the solution

Benefits

• Automated solution that eliminates the costs associated with manual processes
• Direct analysis of Product/Customer profitability (both current and historical) directly in one consistent tool
• Standardized set of business structures that can be used across the enterprise
• Scalable solution that can be leveraged during the subsequent phases
• Consistency in the definition and calculation of key business metrics resulting in consistent performance analysis
• Improved procurement and product costing decision making processes through the ability to model changes in commodities and link directly to the financial forecast