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.
Key Challenges
- Need to scale up or scale down the data warehouse capacity as needed
- A solution that could onboard, process, and analyze data in a timely manner, thus enabling faster decision-making
- Need for a self-service analytics model to perform administration, maintenance, and workload management activities
Ready to experience?
TALK TO EXPERTS
The Solution
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.
With Infosys and Snowflake, the client is now enabled with a cloud-based data warehouse, with elastic scalability and near-zero management that lets users access real-time data in 15 minutes of refresh.
- All business users were on-boarded from the legacy platform to Snowflake and the new platform was adopted within a few weeks
- Infosys leveraged data migration assets and made data available on Snowflake within 15 minutes of refresh on the system
- The client can test, analyze, and make business decisions faster
Benefits
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
