Empowered a large pharmaceutical company to improve the TCO, scalability and query performance by building a data lake on AWS and migrating Oracle DB applications to PostgreSQL Database

Migrating Pharmaceutical Reports Open-Source Success

Case Study: Migrating Pharmaceutical Reports: Open-Source Success

About the Client

The client is a multinational pharmaceutical company based in India. Moreover, the client deals in manufacturing and selling active pharmaceutical ingredients and pharmaceutical formulations in India and the US. Considered as one of the most reputed brands in India, the client has expanded with joint ventures and acquisitions in the last two decades.

The Business Challenge

The client wanted to migrate reports, i.e., their existing Oracle-based (EDW, GDW) and Tableau reports to open-source software and tools. Additionally, with their new business model, the additional requirement of dashboards, reports, and enhancements around existing dashboards, data volume increased greatly. Moreover, with online access provided to every sales representative, the user base rose to 9000+. Therefore, instead of investing further into on-premises infra with licenses, the client wanted to migrate reports to On-Cloud open-source platform expecting to keep TCO in control with rising volume and requirement. Hence, scalability, performance, cost, and improvement of batch job processing were the key factors for the analytics modernization.

What Aptus Data Labs Did

Our team analyzed the client’s existing infrastructure, platform, tools, and taken-up tasks and:

The Impact Aptus Data Labs Made

Our approach helped the client to:

The Business and Technology Approach

We followed a phased approach for the migration:


Tools Used

The Outcome

With spiraling license fees from Oracle, the potential upside in terms of cost savings was easy to appreciate. Moreover, this engagement not only provided the client with the evidence of skills and expertise that Aptus Data Labs could provide. Additionally, it also made it an obvious decision for the client to award Aptus Data Labs the contract for 24/7 Production Support.

Related Case Studies

Case Study: Achieving Low-Latency API-Based Queries with MongoDB

Achieving low-latency API-based queries with Mongo DB

Performance analysis - MapR DB vs. Mongo DB - Tool Selection Process
Case Study: Boosting Performance with Apache Spark Migration

Revolutionizing Pharma Analytics with AWS Data Lake

Enterprise Data Lake and Analytics implementation for a large Pharmaceutical Company in India on AWS platform

Boosting Performance with Apache Spark Migration

Data Migration & Performance Improvement of large data processing

Unlock the Potential of Data Science with Aptus Data Labs

Don't wait to harness the power of data science - contact Aptus Data Labs today and start seeing results.

Get In touch with our  Experts

If you’re looking to take your business to the next level with data science, we invite you to contact us today to schedule a consultation. Our team will work with you to assess your current data landscape and develop a customized solution that will help you gain valuable insights and drive growth.