loading

Business Impact

  • Provide foundational information supporting fact-based business decisions

  • Support planning for current state & forecasting for future efforts

  • Reduce FTEs needed for ad-hoc data engineering

  • Utilize simplified, repeatable processes for delivery of information

Customer Key Fact

  • Location : North America
  • Industry : Supplemental Insurance

Problem Context

The client, one of the largest providers of supplemental insurance, wanted to build an aggregator to consolidate and visualize claims operations KPIs across different businesses (group and individual). It would provide the ability to monitor the key measures to drive operational efficiencies & strategic business planning for:
-Claims Inventory
-Visibility & Accuracy of Claims Settled
-Reduce Engineering Efforts for Ad-Hoc Reporting

Challenges

 

  • Complex sequences and multiple ingestion jobs to be meet hourly reporting needs
  • Lack of coherent reporting KPIs across different lines of business
Challenges

Technologies

Infoworks
Snowflake
Tableau
EMR

Build an Aggregator to Consolidate and Visualize Claims Operations

Solution

Extensive KPIs design and consolidation across lines of business for claims operations (141 KPIs were consolidated to 14 KPIs).

Implementation of the project in a phased manner with the delivery of features including:

  • Consolidation
  • Data Aggregation
  • Data Visualization

Result

  • Rationalized list of KPIs for which user experience was revamped through intuitive Tableau visualizations
  • Ingestion of several key sources of data available on Snowflake
  • Reduce time to access reports from weeks to a few hours
  • Reduction in manual tasks for reporting
  • Reduction of technical debt
  • Automated pipelines

Looking for similar project?

Let's Talk

Get your digital transformation started

Let's Talk