loading

Business Impact

  • Claims Dashboard

  • Reduction in Manual Tasks

  • Reduces Time to Access Reports

  • Increased Visibility and Usability

Customer Key Facts

  • Location : North America
  • Industry : Supplemental Insurance

Problem Context

The client, one of the largest providers of supplemental insurance, wanted to integrate Dental data into the cloud data ecosystem to enable the following:

  • Self-Service Access to Dental data for Actuarial, Analytics, Underwriting, and Pre-Sales Ops
  • Create data feed to Cloud Lake and open up access for analysis
  • Consolidate, aggregate, and enable visualization for Dental Claims data

Challenges

 

  • Prioritizing impactful KPIs out of all available KPIs
  • Timely access to accounts and databases
  • Getting requirements for future development since complete business information is not yet defined
Challenges

Technologies

Infoworks
Snowflake
Tableau
AWS EMR
AWS S3
Hive
Protegrity

Developed a Consolidated Data Mart for Claims

Solution

Quantiphi developed a consolidated Data Mart for claims along with the Dental data feed. Attributes & metrics for analytics users with refined KPIs represent the state of claims operations across all lines of business at various levels of consumption. Visibility to data domains across Dental data sources by creation of self serve access through Snowflake and Hive

Result

  • Ability to work and search attributes across data for better visibility
  • For claims domains, Quantiphi integrated data from various sources for the claims operational dashboards for claims leadership

Looking for similar project?

Let's Talk

Get your digital transformation started

Let's Talk