Enosis Outsourcing logo
Free Consultation
EndorsedendorsedOngoing

Data Warehouse Solution for Insurance Company

Services Covered:

Custom Software Development
Project hero — replace with case study imagery
Industry
Industry

Business Consulting & Services

Duration
Durationinfo-circle

9 months

Budget
Budget

10K - 49K

Start Date
Start Date

1 January 2021

Team Size
Team Size

1-5

Engagement Model
Engagement Model

Offshore

Project Capability Score (PCS)

gauge meter
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

map 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

  • ERPERP

Tech Stack

  • SQLSQL

Client Endorsement

Overall Review Rating

5star

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

Note: This endorsement is based on publicly available client feedback from external review sources.

More Projects by Nuvento Inc