endorsedOngoing

Data Warehouse Solution for Insurance Company

Services Covered:

Custom Software Development

Industry

Business Consulting & Services

Duration

67 months

Budget

10K - 49K

Start Date

1 January 2021

Team Size

1-5 Employees

Engagement Model

Onshore

Project Capability Score (PCS)

80/100

Strong

Project Capability Score (PCS) estimates how capable Nuvento Inc is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Confidential

United States of America

Project Summary

An insurance company engaged Nuvento to implement a data warehouse solution to manage claims operations and to redesign ETL and reporting processes. Nuvento implemented an agile, micro-milestone delivery model, used MS SQL Server to integrate multiple source systems (claims system, ERP, AS400, mainframe), and reduced the data load time from 36 hours to 6 hours, simplifying operations.

Key Challenges

Implement a data warehouse to manage claims operations.
Reduce ETL runtime to under 7 hours.
Redesign reports to achieve a 5-second query time requirement while using existing hardware.

Project Deliverables

Data warehouse for claims operations
ETL pipelines that reduced data load time from 36 hours to 6 hours
Redesigned reports meeting a 5-second query time requirement

Project Solution

Nuvento executed a micro-milestone-based agile plan with verifiable milestones delivered every three days and validated with business users for data quality and performance. The team integrated multiple source systems into an MS SQL Server-based data warehouse, redesigned reports to meet strict query-time SLAs, and optimized ETL processes to run within performance targets.

Project Outcome

Data load time reduced from 36 hours to 6 hours.
Operational and maintenance tasks were simplified.

Platforms

Tech Stack

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Thanks to the contributions of the Nuvento team, the company was able to simplify their operational and management tasks as well as reduce their data load time from 36 hours to 6. The company appreciated how they had direct access to the entire team which helped move the project forward smoothly.”
Anonymous
Claims Management Specialist
Date: 10/20/2021