UPGRADING A GLOBAL HYPERION FINANCIAL MANAGEMENT ENVIRONMENT AND INCORPORATING NEW APPLICATIONS FOR ENHANCED CONSOLIDATIONS
The Company is a global health service company dedicated to helping people improve their health, well being, and sense of security.
Its insurance subsidiaries are major providers of medical, dental, disability, life and accident, and related products and services worldwide.
The Company's 39,000 employees have capabilities in 30 countries & jurisdictions and more than 90 million customer relationships.
The Company's corporate Finance team needed to begin the upgrade of their Oracle Hyperion Financial Management application to 22.214.171.124,
and foresaw an opportunity to improve their system with Financial Close Manager (FCM) and Financial Data Quality Management (FDMEE).
The Chief Accounting Officer wanted to newly implement Account Reconciliation Manager (ARM), an FCM module, to enhance automations for
the financial close and consolidation process The timing was ripe to upgrade all the Hyperion products, so, the organization wanted to
make the ARM/FCM 11.2.4 environment the standard for all other Hyperion products, including Hyperion Financial Management (HFM),
Essbase, and Hyperion Profitibaility and Cost Management (HPCM).
Drill-back capabilities would need to be greatly improved, however. In addition, performance as it related to integration with their Oracle E-Business Suites
(EBS) needed enhancements due to excessive custom scripting. With corporate Finance executives watching, the project was expected to become the corporate Center
of Excellence for Hyperion products globally.
Due to MindStreams's proven record of multiple Oracle Hyperion application implemetations for the company, as well as its close, long-standing relationship
with Oracle, the Company chose MindStream to upgrade their global HFM application. MindStream asked to advise and manage a team of 8 resources in the process
of aligning HFM, Essbase, and HPFCM with the ARM implementation. The project involved leads across the Finance team as well as a senior director of IT.
All environments would need to continue its life hosted by Oracle's Private Cloud Hosting Services in order to maintain security and continue previous
performance levels for enterprise critical applications.
A critical piece of the project was the upgrade to FDMEE with the new 126.96.36.199 system to provide more effective drill-back capabilities. MindStream took an
approach that would leverage a combination/hybrid schema copy of relational repositories and Oracle's Life Cycle Management (LCM). Overall, the desire was
to reduce analysis time by leveraging FDMEE's load/drill back capabilities. With enhanced drillback, MindStream advised, migration capabilities for new
applications and upgrades would be greatly improved. In addition, the value of built-in multi-dimensional mapping functionality of FDMEE was also key to
reducing custom scripting for enhanced data loads.
MindStream effectively managed the process, and the results were efficiencies across the entire financial close process. A 20% increase in consolidation
performance was realized. Wit the use of the built-in ERPi adapter for FDMEE, analysis time was reduced by 30%. In addition, with new optimization in both
script and script maintenance, scripting and script maintenance experienced a 50% reduction, saving time and resources in the long-term.
Contact MindStream Analytics
Want to know more about how we helped Cigna? Fill the form below and we'll get back to you shortly