Multinational Insurance Company

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.