We helped a generic drug sourcing company streamline their data management using Platform-as-a-Service in the cloud.
In an age where business operations require an immense amount of data, it can be challenging and cumbersome to scale enterprise applications and analytics. It is even more difficult to house, store and showcase this data in a way that promotes ease of use and drives insights that impact business success.
Our client is one of the largest generic drug providers, supporting one-third of all generic drug sales in the world. As generics contribute to nearly 90 percent of drug sales, companies like our client help lower the skyrocketing cost of prescription drugs, saving the US health system more than a trillion dollars every year.
As a source of 8,000 different generic drugs and a partner to more than 140 suppliers, the client must manage an enormous amount of data streaming into their systems daily. They require a robust and dependable data management system to keep up with demands and sustain long-term growth. The client had previously engaged Centric Consulting’s Modern Software Delivery and Data and Analytics experts to establish an Azure virtual machine-based solution (similar to on-premise), which successfully ran their company for several years.
After experiencing rapid growth, they found the virtual machine-based platform could not cost-effectively sustain desired performance levels. They needed to modernize and streamline their data management using a system that could scale as their business grows. The answer: update their platform systems to a Platform-as-a-Service (PaaS) in the cloud.
Enter Centric: Real-Time Insights in One Central Place
While the client’s initial, on-premises data server had served their needs well for quite some time, it was due for an upgrade. Outdated analytics technology spread critical business logic and data across numerous platform components, which slowed down data processing time, limited maintenance windows, and overall, impeded client’s business operations.
The company needed our help to modernize their solution, which required migrating existing operational and analytical platforms to Azure PaaS resources. A move to the cloud would allow our client to continue to innovate and make more effective decisions through real-time, across-organization access to information.
“We knew they wanted to significantly scale, and the cloud gives them the flexibility to do that very easily,” says Senior Data Architect Jeff Aalto.
Our “re-platform” effort involved rewriting and migrating dozens of SSIS jobs to Azure Data Factory, lifting two legacy applications into Azure App Services, and supporting it with new implementations of Synapse Analytics (Azure SQL Data Warehouse), Azure Analysis Services, Azure Blob Storage and many other supporting PaaS components.
We took their existing solution and shifted them to a modern platform as a service approach that takes the maintenance away from them. We migrated their codebase from their old, on-premise location into a cloud-based implementation that improved performance and gave them a platform that can grow and evolve with the business over time.
The Results: A Fully Functional Cloud-Based System
In just a few months, we delivered a fully functional cloud-based data management platform, which resulted in a variety of benefits for our client, including:
- A more expedient source file process, shortening process time from days to hours
- Centralized monitoring of the overall solution with a Power BI dashboard that brings together processing data, input data validation information and data reconciliation analysis enabling users to identify issues more quickly and resolve them more efficiently
- Consolidated and centralized business logic within the data warehouse as the single source of truth from which users can derive all downstream analytical and application sourced information, increasing supportability of the solution over time
- Integrated data and process logging throughout the solution, significantly improving the ability to troubleshoot and resolve issues quickly and correctly
- A higher degree of confidence in the accuracy and timeliness of data for end-users.
In summary, we provided our client with a single system that allows them to manage their data more efficiently and effectively, enabling them to improve business operations as a whole.