How can you automate allocation modeling and regulatory reporting in insurance?

Background

A leading UK insurance company who wished to create a new solution that would allow them to automate an allocation modeling process.

Challenge

Historically, this allocation process was run using a series of SQL scripts which were created and operated by an analyst. Over time, this process had become complex and unwieldy, and required the regulatory reporting team to work closely with this analyst to generate their quarterly returns.

Approach

To create a more robust and transparent process, and to bring the control of the modeling into the remit of the regulatory reporting team, Keyrus made the decision to rebuild the process using Alteryx. Due to the very large data volumes, Power BI was also used to allow users to examine the results of the allocation in detail (visualization). Keyrus was able to automate the following stages of the modelling process: • Data cleansing according to many pre-defined business rules • User-defined manual replacements of invalid data • Allocation of modelled data with multiple allocation approaches • Preparation of CSV files for direct submission to the regulator

Key results

Benefits

The allocation model process is now fully owned by the regulatory reporting team, reducing their dependency on other teams and improving time spent on quarterly returns. The visual Alteryx Designer interface can now be used to easily explain the flow of data throughout the complex process. Collaboration between the client and Keyrus consultants has resulted in a streamlined and more robust process, which requires less manual input and fewer iterations to complete. End users can now access and run the allocation model process directly via the self-service Alteryx Gallery apps.

Share this key play