Estuate Rids Pharma Major of Data Cholesterol

single image

Industry       :  Healthcare

Practice Area  :  Information Lifecycle Governance & Security


The client is one of the world's largest pharmaceutical companies by revenues, and headquartered in the United States.  With a strong global portfolio that includes medicines and vaccines, as well as many of the world's best-known consumer healthcare products, the company has established relationships with healthcare providers, governments and local communities to support and expand access to healthcare around the world.

Business Challenge:

The client used the Revitas Contract And Rebate System (CARS) to handle their revenue management processes and to process complex chargebacks. While using the Revitas CARS Solution, the client was beginning to experience the effects of “data cholesterol”.  Data cholesterol resulted from years of accumulated data, most of which was no longer used, and was beginning to clog the client’s revenue management system performance. Maintaining the Service Level Agreements with their customers for adequate performance was their biggest business challenge. Their typical response to the data growth problem was to throw hardware resources - CPU, memory and storage.  However, this was neither scalable, nor cost effective, and they needed a more intelligent solution to the problem.

The Estuate Solution:

Estuate offered a data growth and archiving solution to extract little-used data from the production database and store it in an archive. The solution covers the full lifecycle of all data included within CARS. It ensures optimal system performance by controlling the challenges connected with long-term data growth. Key solution highlights include:

  • Automated end-to-end archival, deletion and restoration of managed care and chargeback data (Revenue Manager module).
  • Adherence with business and compliance policies related to the management, archival and retention of application data
  • Rapid response to audit and discovery requests with worldwide accessibility to archived information.
  • Centralized management and control of data archival across across CARS and ChargeBack solutions.
  • Improved performance of CARS through reduced data growth and centralized data control and security policies.

Business Impact:

Estuate’s Optim Data Growth and Archiving solution eliminates data cholesterol by archiving historical data safely to a secure archive. This had a significant impact on CARS performance and brought data growth in a range of enterprise business applications under control while lowering cost and risk. Key benefit include:

  • Reduced hardware, storage, and maintenance costs by optimizing data management policies.
  • Improved application performance by controlling ongoing database growth.
  • Increased IT operational efficiencies by streamlining maintenance processes.
  • Strengthened Revitas FLEX platform offerings by improving performance and streamlining system migration.

        Estuate’s expertise in the area of Information Lifecycle Governance was critical to bringing our costs under control and improving our overall application performance. Our previous approach - which was to throw money at the problem - was not going to work and we needed a smart solution from an expert partner. Estuate’s consultants were highly knowledgeable about the technology and industry best practices related to Information management. Their skills, coupled with their thoroughness and professionalism, made them a pleasure to work with.

Director, Architecture and Solution Delivery