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

2,361M € in premiums

4.6 million contracts

4.6 million contracts

2.5 million customers

2.5 million customers

More than 7,000 points of sale and advising

More than 7,000 points of sale and advising

Related Projects