© 2015-2024. MindStreamAnalytics.com

Celgene Case Study


Celgene is a multinational biopharmaceutical company committed to improving the lives of patients worldwide. Their mission as a company is to build a major global biopharmaceutical corporation while focusing on the discovery, the development, and the commercialization of products for the treatment of cancer and other severe, immune, inflammatory conditions. Celgene sells each drug under strict risk management plans that ensure they are safely administered. The firm has other drugs in development that combat inflammatory diseases and cancer.

After completing a Functional and Technical Application Review, Celgene sought to apply these insights and best practices to an Oracle Hyperion Planning upgrade to version With the goal of increasing the capabilities of their budgeting, planning, and forecasting process, the existing Celgene applications had significant opportunities for improvement. With a new functional budgeting and forecasting process, Celgene reached out to MindStream to replace their inefficient data integration process and enhance overall application performance. Celgene's main concerns included forward adaptability of their system to expand over time, without having to rework core foundations or negatively affect performance, as business processes change. Too much time was spent managing the ebb and flow of data, constricting their opportunities for true business analysis.

Solution :

First, MindStream upgraded their Hyperion Planning to 11.1.2, stabilizing their environment. This upgrade, along with some tactical redesign of the application architecture and underlying plan types, simplified and consolidated both the number of applications and total number of environments. Together with the improved functionality of Enterprise Performance Management Architect (EPMA) in system, the new environment improved the management of metadata across multiple applications.

During the upgrade, Celgene utilized MindStream's Development environment located in their Amazon Cloud slice. The service enabled Celgene to begin the project while they were in the process of procuring and staging their Production hardware. Once the application was ready, MindStream then facilitated the application migration to Celgene's permanent environment.

In addition, MindStream implemented Financial Data Quality Management (FDM) to not only ensure data integrity but to save time spent on data reconciliation and maintenance. This gave way to more time for analysis, an ultimate goal of the organization. Oracle Hyperion's data integration and validation tool improved data flow and automated data feeds directly from PeopleSoft. Finally, the new application leveraged Oracle Hyperion Essbase to improve management reporting capabilities. Using certain configurations of the Essbase's powerful engine, budget reporting submission and analysis could be done more swiftly, integrating data smoothly from PeopleSoft to Hyperion for a full view of the business.


The organization was able to report back a smooth transition to a new, more stablized Oracle Hyperion environment with the upgrade of the Planning application and related application architecture. The consolidation of applications across their American and European organizations with Corporate was key to a more simplified, dynamic environment, capable of adapting as their business grew and processes changed.

Throughout the project, many processes are implemented as opportunities for efficiencies and process improvements arose, including: implementation of defragmentation and error routines, business process advisement on use/elimination of dimensions (including Legal Entity and Currency), automation of data feeds from PeopleSoft to Hyperion, improved calculations for allowing more what-if-scenarios, enabling Dynamic Time Series, and more. Together with the implementation of FDM for data flow enhancement,levering Essbase provided for improved management reporting, No longer hindered by inefficient processes and applications, Celgene was now capturing the full value of their Hyperion investments.

Partner SpotLight


Oracle has the most comprehensive suite of integrated, global business applications that enable organizations to make better decisions, reduce cost..

Oracle Profile

Case Studies


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 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.


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..


MindStream Analytics' partnership with BluEarth Renewables epitomizes the power of technology and collaboration.


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.


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, a merger of Mitchell, Genex, and Coventry, faced challenges with disparate financial solutions and the need for combined reporting.


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 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.


MindStream's expertise and experience were sought to conduct a vendor selection initiative focusing on MEPPI's F2023 planning process.


MindStream Analytics and OUAI's collaboration showcases the transformative power of strategic technological intervention.


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.


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'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 collaborated with MindStream Analytics for the NetSuite Analytics Warehouse implementation.


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 was an Oracle Hyperion customer realizing that it needed more specialized support for its various Oracle Hyperion applications.


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.


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


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.

Related Links