About the client: A major life sciences company with core competencies in the areas of healthcare and agriculture, focusing on prescription products, especially for cardiology and women’s healthcare, and on specialty therapeutics in the areas of oncology, hematology, and ophthalmology. The division also comprises the radiology business, which markets diagnostic imaging equipment together with the necessary contract agents.
With a broad product portfolio, the company generates, houses, processes, and analyzes huge volumes of data from multiple sources in their data warehouse. Insights derived from this data enable timely and effective decision-making that help drive the business forward.
Ready to experience?TALK TO EXPERTS
A cloud-based data warehouse with elastic scalability and near-zero management
In close collaboration with the client, Infosys performed an exhaustive review of cloud-based data warehouse vendors. While defining the roadmap, our team recommended Snowflake, as the cloud platform. In the next 8-10 weeks, leveraging data sets of 200 GB, our team worked closely with the client to run a series of high-volume queries simulating 50 concurrent users. Our team identified specific customizations and enhancements required for the Snowflake implementation.
Snowflake met all performance tests. Furthermore, it excelled in workload management and instant scalability. Earlier, the other cloud-based data warehouse solutions required the company to hire highly skilled engineers to perform database administration, maintenance, and workload management activities.
Our team integrated machine learning by querying data in Snowflake and feeding it into tools. We also trained a model based upon a patient data set, then applied that model to a larger database to see if other patients fell under the same categorizations.
The team delivered real-time alerts to sales reps via Tableau. Our team leveraged Snowflake's support for semi-structured data and built a reusable and scalable framework. The alerts informed sales reps about important events, such as when physicians change prescriptions to a competitor's drug, etc.
Faster business decision-making with instant scalability
Near-zero maintenance reducing the need for data warehouse support
A cloud-based data warehouse with elastic scalability and near-zero management that enabled users to access real-time data