Digital Analytics Solutions for US-Based Insurance ISV

Client

Our client is a leading provider of cloud-based software and analytics for insurance carriers, brokers, and MGAs.

Challenges

The client wanted to:

• Manage real-time messages from 3,000+ end customers.
• Develop a product-based on massive information generated from messages sent by end customers.
• Migrate the existing EDW on-prem ecosystem to Snowflake.
• Revamp the target EDW model to improve user experience and eliminate data redundancy. 

LTM Solution

• Snowflake on AWS Migrated data from SQL Server EDW to Snowflake. Re-modeled the target architecture to reduce data duplication.
• Dashboard and Reports Created Charts and dashboard for self-service analysis and MIS reporting.
• User Management Defined users and roles for enhancing the security model.
• Integrated Solution Automated end-to-end process including testing and revamping the processing strategy from message-based to batch-based ingestion.

Business Benefits

• 10TB+ data migration from on-premise EDW platform to Snowflake
• ~ 15% reduction in the data processing
• ~ 20% improvement in data availability for downstream consumption
• Simplification of the target data model for seamless data integration
• Implemented an end-to-end automated platform for improved user experience
• Process time optimization of data ingested from multiple end customers using Snowflake, Open-Source tools for scheduling, and SSRS & Power BI