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 11.1.2.4, 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).
Solution
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 11.1.2.4 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.
Results
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.
Partner SpotLight
Oracle
Oracle has the most comprehensive suite of integrated, global business applications that enable organizations to make better decisions, reduce cost..
Case Studies
Accumen
Thanks to the intervention of MindStream Analytics, Accumen's Finance department can now model their business with a new, more organized structure that isn't conventionally available in NetSuite.
Acme Brick
Acme Brick turned to MindStream Analytics for help implementing OneStream to replace their outdated TM1 solution.
Alterra
Alterra sought the expertise of MindStream to address the challenges they faced in their Capital Planning process.
ATCO Group
Energy conglomerate ATCO operates worldwide in utilities, power generation, and related services.
Avalon
Working with MindStream Analytics, Avalon Healthcare Solutions adopts NetSuite Planning and Budgeting to accelerate budgeting and forecasting processes.
Bayer Health Care
Bayer Healthcare implemented Hyperion Planning and Workforce Planning in 10 weeks to dramatically streamline their Income Statement budget and Workforce Planning process..
BluEarth
MindStream Analytics' partnership with BluEarth Renewables epitomizes the power of technology and collaboration.
Celgene
An Oracle Hyperion Planning Upgrade provides multi-national organization Hyperion Application optimization and stabilization.
Cleaver Brooks
OneStream XF was chosen as the platform that would transform Cleaver-Brooks' Finance processes.
CoorsTek
The collaboration between CoorsTek and MindStream resulted in significant improvements in CoorsTek's financial consolidation and reporting processes.
Elite Body Sculpture
MindStream Analytics' collaboration with Elite Body Sculpture encapsulates the transformative potential of targeted tech solutions in streamlining administrative processes.
Enlyte
Enlyte, a merger of Mitchell, Genex, and Coventry, faced challenges with disparate financial solutions and the need for combined reporting.
Flanders
MindStream Analytics collaborated with Flanders to implement OneStream Consolidation and Reporting solution.
Foley Products
Foley Products was facing a significant challenge with its Excel-based actual management reporting system.
Harte Hanks
The collaboration between MindStream Analytics and Harte Hanks culminated in a highly customized, user-friendly NetSuite implementation.
Interface
Interface used a complex, manual, excel-based FP&A process for monthly review, and the summary data was loaded in OneStream.
Kymera International
Thanks to Mindstream Analytics' assistance, Kymera was able to load all of their data into OneStream and validate it successfully.
MacLean Fogg
MacLean-Fogg partnered with MindStream, a leading implementor specializing in modernizing and optimizing enterprise systems.
MEPPI
MindStream's expertise and experience were sought to conduct a vendor selection initiative focusing on MEPPI's F2023 planning process.
OUAI
MindStream Analytics and OUAI's collaboration showcases the transformative power of strategic technological intervention.
Plaskolite
By migrating to OneStream, Plaskolite has achieved a material reduction in consolidation time and overall Financial Close cycle, eliminated the hours spent compiling and verifying data in Excel, streamlined its Planning, Budgeting and Forecasting model and delivered flexible and timely reporting that enables more strategic analysis of their financial data.
Redwire
Understanding the nuances of Redwire's challenges, MindStream Analytics devised a holistic approach to overcome them. The implementation of NetSuite was just the beginning.
Simon
Simon's existing corporate Hyperion Financial Management (HFM) production application was consolidating at a rate of seven hours, a performance issue causing great headache to corporate Accounting.
Source Code
The successful transition to OneStream revolutionized Source Code's financial reporting.
Subway
Subway collaborated with MindStream Analytics for the NetSuite Analytics Warehouse implementation.
UPenn
MindStream Consulting and AppCare team members are proud be working side by side with UPenn university in accomplishing this implementation and along with continuing our AppCare services after go-live.
USG
USG was an Oracle Hyperion customer realizing that it needed more specialized support for its various Oracle Hyperion applications.
Vantiv
Dividing a hyperion planning application, expanding the hyperion footprint to forecast on the business? Customer categories.
Versant Health
Versant Health engaged MindStream to help resolve the challenges they were experiencing with their consolidation, close, and financial reporting processes.
Virginia Spaceport Authority
The MindStream team implemented the Standard + Workforce NetSuite Planning & Budgeting.
WeWork
MindStream Analytics determined that the best solution was to implement Oracle Essbase Cloud as part of the Oracle Analytics Cloud (OAC) platform-as-a-service
WindStream
Innovative use of essbase to streamline and connect hyperion financial management for enhanced financial analysis.
XY Planning
MindStream Analytics, well-versed in addressing such challenges, presented a comprehensive Netsuite solution for XY Planning.