Modernization of Commercial Data Warehouse for US Pharmaceutical company


Data Warehousing for Commercial Operations can be a challenge to manage; having the right partner is key. A US-based pharmaceutical company had implemented a SaaS-based Commercial Data Warehouse system and was facing a variety of challenges from a solution, partner, cost, and delivery perspective. To assist, AdfarTech, with our 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.

About the Client

US Pharmaceutical company with a focus on CNS market

Business Challenge

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
  • Lack of basic functional capabilities necessary for a Life Science company
  • 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

Our Solution

Phase I (complete)

  • Quick migration to new client-owned, modern, high performance AdfarTech 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 AdfarTech for managed services to provide full DevOps support.
  • Increase support coverage including onsite presence.
  • New base QC framework to address data integration/quality issues.

Phase II (in process)

  • Iterative build-out of required feature backlog.
  • High performing, modern Commercial Data Warehouse
  • Significantly reduced turnaround time and cost for enhancements
  • Reduced time for service requests and incidents resolution.
  • Regular updates on service requests, incidents, enhancements to key stakeholders
  • Increased communication and reduced issue resolution time
case studies

See More Case Studies

Contact us

Partner with Us for Comprehensive IT Resources

We’re happy to answer any questions you may have and help you determine which of our services best fit your needs.

Your benefits:
What happens next?

We Schedule a call at your convenience 


We do a discovery and consulting meting 


We prepare a proposal 

Schedule a Free Consultation