Innovative Industry-Specific Solution for a Global Insurance Leader

Client

The client is a global leader in insurance broking and risk management, designing and delivering innovative industry-specific solutions.

Challenges

• Lack of a single source of truth for driver-based planning and rolling forecast.
• Managing all dimensions in a single repository in the new application.
• Requirement of an alternate approach for security provisioning.
• Need for optimizing dimension members in the new Planning and Budgeting Cloud Services (PBCS) applications.
• Difficulty in baselining performance in the new PBCS environment by leveraging the latest features.

LTM Solution

LTM implemented Enterprise Performance Management (EPM) Cloud by migrating the existing on-premises Hyperion application into Enterprise Planning and Budgeting Cloud Service (EPBCS) leveraging Migra BOTS. The solution consisted of following key features:

• LTM implemented tailored Hyperion On-Premise applications to match the new EPM cloud applications via a sprint-based implementation process and leveraging EPM Migra BOTS.
• Implemented driver-based planning and forecasting to allow the regional planner to forecast numbers on the parent member.
• Converted all the member formulas and rewrote them in calculation manager rules for the workforce module.
• Integrated capex planning directly with E-Business Suite Fixed Assets.
• Enabled integration with Workday (HCDM) and PeopleSoft to eliminate the manual effort.
• Automated data load process using Python and EPM Automate. Automated security sync-up was completed using Python and REST APIs unlike direct integration of active directory with foundation services.
• Automated metadata load process with introduction of EBX5 management tool.
• Real-time integration was developed for loading monthly depreciation information to planning application.

Business Benefits

• 15% Reduction in manual effort by automating the process of loading metadata in EPBCS using Python and REST APIs.
• Sharp reduction in the time required for nightly aggregation for the Workforce application from three hours to 15 minutes.
• Significant reduction in the aggregation time by converting the member formulas to rules, resulting in saving several hours of manual effort.
• On-premise workforce aggregation process was brought down from four hours to just 30 minutes of execution time with the help of the calculation manager.