Skip to Content
Back to projects

Insurance risk analytics

Actuarial Forecasting and Reporting

Cash-flow and loss-forecasting models, IFRS 17 implementation, and automated actuarial reporting across insurance portfolios at Allianz in London.

The short version

  • At Allianz in London I developed cash-flow and loss-forecasting models for reserve adequacy and capital planning on a portfolio of more than $500M, feeding quarterly presentations to Allianz Group in Germany.
  • I owned the firm's monthly Claims Tracking Report, coding in R and SAS, and automated actuarial reporting to cut monthly reporting time by half.
  • I supported the move from IFRS 4 to IFRS 17 across more than 15 lines of business, and presented pricing and benchmarking analysis to the Underwriting Committee.

Portfolio

$500M+

Lines of business

15+

Monthly reporting time

-50%

Tower Bridge and the Shard in London at dusk

The setting

I joined Allianz's graduate programme in London (2022 to 2024), rotating through technical underwriting and the actuarial function.

Technical underwriting

In underwriting I built premium risk models across insurance portfolios and supported pricing decisions that reduced projected loss ratios by 1.5%. I presented competitor benchmarking, cost-benefit analyses, and revenue scenarios across more than 30 fee categories to the Underwriting Committee, and built Power BI dashboards across motor, home, and travel products to make complex data simple for senior managers.

The actuarial function

In the actuarial function I developed cash-flow and loss-forecasting models for reserve adequacy and capital planning on a portfolio of more than $500M. I owned the firm's monthly Claims Tracking Report, coding in R and SAS, and built cash-flow models that fed quarterly presentations to Allianz Group in Germany.

I also supported the transition from IFRS 4 to IFRS 17 across more than 15 lines of business, and automated actuarial reporting with SAS, R, and Excel to cut monthly reporting time by half.

What it taught me

Both rotations put the work in front of senior audiences, whether the Underwriting Committee in London or Allianz Group in Germany. Preparing for those rooms taught me to explain a model in plain English before anyone asked for the technical detail.