Skip to main content

Modernization of Commercial Data Warehouse for US Pharmaceutical company

article banner

Overview.

A US-based pharmaceutical company implemented a SaaS-based Commercial Data Warehouse system and faced various challenges from a solution, partner, cost, and delivery perspective. Data Warehousing for commercial operations can be a challenge to manage; having the right partner is key. To assist, Coforge, with its deep Data & Analytics expertise, migrated the client off the SaaS platform to a new, modern platform, implemented a managed service model, and initiated introduction of features from the backlog requests.

Challenges

The client was having numerous challenges with a SaaS-based Commercial Data Warehouse solution that was supporting all core Commercial Operations business processes. Challenges included:

  • Fully outsourced model with no ability to implement enhancements outside of SaaS vendor.
  • Long lead times and high costs for enhancements
  • Long lead times and high costs for enhancements
  • Limited architecture and data model that did not support all business use cases.
  • High number of defects with lack of transparency around root cause and resolution
  • Data integration issues with providing and consuming partners/applications
  • Slow response for information and service requests
  • Significant time/cost required for vendor management.
  • Lack of complete and proper documentation.

Solution

  • Quick migration to new Customer-owned, modern, high performance Coforge Data Warehouse platform.
  • Platform technology architecture (high-level):
    • Microsoft Azure Data Factory infrastructure
    • PySpark data pipelines
    • Snowflake database
    • Expanded, flexible data model.
    • Qlik for Reporting & Analytics
  • Migration to Coforge for managed services to provide full DevOps support.
  • Increased support coverage including onsite presence.
  • Implemented new base QC framework to address data integration/quality issues.

The Impact

  • Ensured high performing, modern Commercial Data Warehouse implementation.
  • Significantly reduced turnaround time and cost for enhancements
  • Reduced time for service requests and incidents resolution.
  • Enabled regular updates on service requests, incidents, enhancements to key stakeholders.
  • Increased communication and reduced issue resolution time.

Bring us your challenge.

Let’s Coforge your next success story.

Related reads.

WHAT WE DO.

Explore our wide gamut of digital transformation capabilities and our work across industries.

Explore