Snowflake Strategy & Architecture Assessment for a US Multinational Pharma Company

Client

The client is one of the world's largest American multinational pharmaceutical major, leading across generic and patented drugs. The company develops and produces medicines and vaccines for a wide range of medical disciplines.

Business Challenges

• Assessing the existing data warehouse landscape to understand its functionality, inventory, complexities, technical debt, and possibilities of migrating to the cloud.
• Defining a best-fit, cloud-native architecture considering future vision, requirements, TCO, and industry best practices.
• Creating a detailed migration approach and plan for moving to a cloud-based data platform.
• Identifying risks involved and planning for mitigation, so that the 180+ reporting and downstream apps embrace a minimum impact on extensive end-user testing.
• Building a complete operating target model for the future state architecture to facilitate a scaled and seamless execution.

LTM Solution

• Performed a technical assessment on the existing DW landscape to deep-dive into the as-is architecture to understand the key pain points and expectations.
• Created a detailed data overview report to summarize the pain points, inventory analysis, and suggested pathways for cloud migration to Snowflake.
• Analyzed various architecture options compared with seven comprehensive parameters to recommend a robust and efficient future state architecture considering the costs and risks.
• Designed a meticulous roadmap for the migration strategy with the predicted timelines and critical success factors for a well-educated transition. 
• Provided recommendations and suggestions leveraging our proven migration playbook to accelerate and simplify the data migration journey.

Business Benefits

• Business case Developed Snowflake business case across the variable to justify the business investment, thereby reducing the overall platform management cost.
• TCO calculator Built unified Snowflake cost calculator to derive final cloud usage/ compute cost to help make an informed decision.
• Cloud-based architecture Defined key architecture options, along with its comparison and recommendation.