Skip to main content

Snowflake Optimization: Coforge Drives 40% Cost Reduction for Global Insurance Leader

article banner

Overview.

A leading global insurance firm faced significant challenges in optimizing their Snowflake environment, including high compute and storage costs, inefficient data model design, and suboptimal code management. These issues were increasing operational expenses and hindering system performance. Coforge partnered with the client to implement a comprehensive optimization strategy, leveraging Snowflake and Unravel to enhance operational efficiency, reduce costs, and improve overall system performance in the competitive data and analytics landscape.

Challenges.

  • High compute costs in Snowflake environment
  • Excessive storage costs
  • Inefficient data model design
  • Suboptimal Snowflake code management
  • Increased operational expenses
  • Hindered system performance and efficiency

Solutions.

Coforge implemented a comprehensive optimization plan using Snowflake and Unravel:

High Compute Cost Optimization:
  • Optimized high-cost data load queries
  • Downsized warehouse computes for less resource-intensive queries
High Storage Cost Reduction:
  • Conducted Snowflake account-level database assessment
  • Reduced time travel in non-production databases
  • Purged redundant and unused databases
  • Implemented governance policies using tags
  • Set up Snowflake alerts for identifying large cold tables
Key highlights:
  • Improved control over Snowflake credit usage
  • Developed scalable architecture with business-centric data model
  • Implemented efficient code management processes

The impact.

40%

Reduction in storage costs

30%

Improvement in query performance

10%

Enhancement in warehouse efficiency

Bring us your challenge.

Let’s Coforge your next success story.

Related reads.

WHAT WE DO.

Explore our wide gamut of digital transformation capabilities and our work across industries.

Explore