A global insurer had to centralize its financial data across various European subsidiaries in order to meet the Solvency II regulatory reporting requirements. They realized a centralized data warehouse (CDW) would help unify all its financial data, ensure full compliance with regulatory reporting mandates and provide better financial oversight.
Their existing decentralized model, where every operating unit managed its financials independently, came in the way of creating a centralized data reporting system. Early attempts to get individual operating units to populate the CDW were unsuccessful due to a lack of capacity to feed data into a CDW.
We sought to bring all the data together in multiple phases. First, we focused on the European subsidiaries, with the goal of meeting Solvency II compliance. We carried out a detailed examination of each source system in various regions, including Germany, Spain, Norway, Sweden, and the United Kingdom, and developed customized extracts to transform and channel data into a standardized CDW model. It involved analyzing source systems, adjusting data to fit the standard model, and validating the accuracy of the data to ensure precise reporting, while complying with European GDPR requirements.
The phase I implementation met the Solvency II regulatory reporting requirements. For the first time, a centralized data store containing all financial data from all its European subsidiaries, was in operation. Its success was replicated across all its North American subsidiaries, marking a shift towards a global centralized financial data system.
Leverage Microsoft’s transformative cloud platform to scale and innovate with unprecedented flexibility and efficiency.