The client had 26 data sources consisting of their e-commerce platform and ERP and with rising competition, providing personalized customer experiences was pertinent for growth. But they were facing challenges in ensuring data quality and reporting.
Nuvento worked with the management and the analyst/operations team to identify the needs of each team and define enterprise KPI/ Core Parameters. We conducted an in-depth study of their infrastructure ecosystem first and adopted a multi-pronged strategy based on it. We created a plan for data management and ETL process optimization, and customized report generation for end-to-end reporting to provide visibility and optimize their operations. The key considerations included accommodating future regulatory changes and managing new systems and channels due to large M&A in the area. The proposed solution spanned across every level of organization data. The solutions covered 30,000 people with more than 35 different business divisions that include liability, casualty, fire, theft, commercial, workers’ compensation, and coverage
We built a centralized data warehouse and performance scorecards integrating 32 data sources across 35 lines of business (covering 16,000 users, 2 million Annual Claims, and 40 million data transaction points).
Centralized data warehouse
We built a centralized data warehouse bringing down the volumes of data to 6 terabytes organized into Star Schema. To ensure effective synchronization of all data, we deployed Nuvento’s Extract, Transform, Load (ETL) centre.
Self-service data portal
The solution also included a 75-parameter self-service data portal that allowed analysts to ingest data and build analytical data models for operations optimization, claims forecasting, capacity planning, etc.
Performance management framework
We built a balanced scorecard to monitor and implement strategy maps covering auto, commercial, property, and workers’ compensation lines. The metrics and Key Performance Indicators (KPIs) were created based on 4 million claims with more than 200 million transactional activities on a yearly basis.
Implemented Oracle BI Suite for reporting across all lines of business and enabled easy creation of self–service reports with the use of best BI tools. The reports have the flexibility to drill down according to the needs of business users.
Share your requirement with us and our team will contact you within one business day to schedule a personalized consultation.
Once you connect with our technology leaders, they will evaluate your specific business case and share a proof of concept with estimates of costs, the effort required in terms of technologies and developers, and the timeline for the process.