Multinational Insurance Company
Automation of technical closing
Data warehouse and reporting for reduction of operating costs, minimization of manual interventions and reduction of operational risk.
GOAL
Optimize the management of internal processes in relation to the monthly technical closing, reducing work time and eliminating the use of Excels manuals.
Optimize data quality and guarantee data integrity.
STRATEGY
- Incorporation of multiple data sources.
- Normalization.
- Data warehouse and process design.
- Analytical model / semantic layer design.
- Creation of a report portal in SSRS that includes all the options of the technical closing.
RESULTS
- Standardized and unique data.
- Recurrent incidental reduction.
- Reduction of closing time from one month to one day: data is constantly updated and closing occurs on demand, with all calculation processes automated.
2,361M € in premiums
4.6 million contracts
2.5 million customers
