A government-owned pension fund
Client. A dedicated provider of supplementary pension insurance products, with €2bn under administration across a large unit-linked and annuity portfolio.
Challenge. The actuarial and innovation team was expanding and moving from Excel-based workflows to programmatic ones at the same time. Two changes at once, either of which is difficult alone. We were brought in to set up and lead the transformation programme and to support the team through the transition.
Approach. Over 18 months we ran on-site workshops and presentations to align the team, senior leadership and the board behind a single vision, because a transformation of this kind fails on consent long before it fails on code. Alongside that we worked with internal staff to build their skills in Python and GitHub.
The bulk of the work was automating existing processes in Python. We also built a novel stochastic model for time value of options and guarantees that removes the need for an external scenario generator, and a large liability forecasting model. The first as an Excel workbook with embedded Python for the people who work in spreadsheets, the second as a Python library for the people who work in code. The entire corpus was handed over to their internal team.
Outcome. A large part of Solvency reporting now runs in Python. The team has a liability model that produces ORSA reports in a single run, which also makes planning more realistic than it was before. A set of Python scripts handles cross-validation, data transformation and datafile generation, saving time and reducing errors in the reporting process.
Most importantly, they have internal people trained in Python and version control. The team can maintain and extend the work without us, which is the only version of this outcome that lasts.