Summary
Overview
Work history
Education
Skills
Certification
LIFE INSURANCE ACTUARY
CERTIFIED MECHANICAL ENGINEER
Timeline
Generic

Willem Johannes Landman

Sherbourne,Warwickshire

Summary

Accomplished professional specializing in actuarial modeling and data analysis, with advanced proficiency in Prophet and RiskAgilityEC. Expertise in programming languages including VBA, Python, SQL, R, and PowerShell, alongside strong skills in Microsoft Office Suite. Proven track record in project management, process design, and optimization, with experience in Solvency II compliance and IFRS 17 reporting. Focused on driving operational efficiency through innovative solutions.

Overview

16
16
years of professional experience
11
11
years of post-secondary education
1
1
Certification

Work history

PROPHET CONSULTANT (Contract)

SwissRe
London
02.2024 - 11.2025
  • Lead IFRS17 Prophet Library developer
  • Liaison between accounting hub and actuarial model
  • Review of central and business IFRS17 requirements
  • Design of IFRS17 Prophet model data flow (IDR, modelpoints, etc..)
  • Testing central and business requirements against Prophet IFRS17 model build

PROPHET CONSULTANT (Contract)

Americo
Kansas City, MO
02.2023 - 01.2024
  • ALS – setting up structures and configuring of investment strategies
  • ALS – develop custom Americo functionality
  • US360 - develop custom Americo functionality
  • Undertook financial analysis to guide budget planning and investment decisions.

PROPHET CONSULTANT (Contract)

Ameriprise Financial
Minneapolis
08.2022 - 02.2023
  • ALS enhancement for Ameriprise primary risk metrics - change in excess capital, GAAP earnings and cash liquidity
  • Writing requirements, assisting in process design and testing code
  • PE API, PowerShell automation script development
  • R script development for data management

SOLUTIONS ARCHITECT (Contract)

Irish Life
Dublin
03.2020 - 08.2022
  • SME for Prophet suite – PE, PP, PE API, PP API, FRAPI, PRD, IDR, DCS, Glean. This includes installation, configuration and development
  • SME for Prophet IFRS17 library
  • Solution design of common actuarial platform utilizing Azure cloud and Prophet
  • Liaison with user group to gather functional requirements and creation of user stories
  • Option analysis and feedback to user group
  • Costing of implementation and sustainment
  • Created custom test models for user stories and stress testing

CONSULTANT ACTUARY (Contract)

Legal and General
Hove
10.2019 - 03.2020
  • Lead IFRS17 Prophet Library developer
  • Liaison between accounting hub and actuarial model
  • Review of central and business IFRS17 requirements
  • Design of IFRS17 Prophet model data flow (IDR, modelpoints, etc..)
  • Testing central and business requirements against Prophet IFRS17 model build

CONSULTANT ACTUARY (Contract)

Lloyds Banking Group
Bristol
02.2018 - 09.2019
  • Lead IFRS17 actuarial model developer
  • Main contact between model development, methodology and actuarial systems
  • Responsible for model scope, user stories and testing requirements
  • Part of end-to-end IFRS17 process design

ACTUARIAL SOLUTIONS MANAGER

FIS (formerly SunGard)
Chertsey
09.2012 - 02.2018
  • Solutions architect on 3 global IFRS17 projects
  • Product owner of Prophet’s Insurance Data Repository (IDR)
  • Developed end to end IFRS17 demonstration model utilising: Prophet control centre, Prophet Enterprise, Assumptions Manager, IFRS17 library, PRD, IDR and BI
  • Created training material for IDR, PRD data solutions
  • Created Prophet unit test models for new system functionality such as nested structures, nested modules, assumptions manager, IDR and PRD
  • Investigated using ALS (external) and nested structures for SII internal model projected balance sheets
  • Development of SII standard formula models using nested stochastic functionality
  • Continues Solvency Monitor proof of concept using the proxy fitting library
  • Developed a desktop application for quick analysis of the impact of changes in underlying risk factors on the solvency capital requirement (SCR) using the Solvency II standard formula approach
  • Lead on development of Generalized Linear Modelling and data cubing software (Glean)
  • Provided internal training on Economic Capital modelling for internal models

PROJECT ACTUARY

Wesleyan Assurance Society
Birmingham
04.2011 - 09.2012
  • Developed continuous solvency monitoring proof of concept as part of internal model
  • Economic Capital modelling; loss function fitting, Risk factor distribution fitting
  • Developed profit and loss attribution proof of concept for internal model
  • Implementation and user acceptance testing of Prophet Enterprise and new data warehouse system
  • Implemented methodology changes in dynamic financial analysis model (DFA/ALS)
  • Managed team of three Actuarial Analysts
  • Supported various teams during year end reporting

CONSULTANT ACTUARY (Contract)

Sun Life of Canada
Basingstoke
08.2010 - 04.2011
  • Prophet coding of SII model
  • Created SQL database and comparison templates to assist in creating single model office library

CONSULTANT ACTUARY (Contract)

Scottish Widows
Edinburgh
05.2010 - 08.2010
  • Developed financial risk models as part of group financial risk management process

Education

Certificate - Finance and Investments

Institute of Actuaries
United Kingdom
01.2000 - 01.2007

BEng Hons - Mechanical

University of Pretoria
Guateng, South Africa
01.1990 - 01.1994

Skills

  • Prophet (PP, PE, PRD, IDR) and RiskAgilityEC
  • Microsoft Office Suite
  • VBA, Python, SQL, R, and PowerShell
  • Actuarial modelling
  • Project management
  • Process design and optimization
  • Solvency II compliance
  • Data analysis
  • IFRS 17 reporting

Certification

  • Fellow of the Institute of Actuaries
  • Fellow of the Society of Actuaries
  • Professional Engineer - Engineering Council of South Africa

LIFE INSURANCE ACTUARY

  • Variety of roles in South Africa, UK and Holland
  • Lead on “statement of intent” project to determine compensation to endowment and RA policyholders on whom early termination penalties were imposed
  • Introduced new actuarial modelling platform (Prophet)
  • Developed SQL database and methodology to perform monthly movement reconciliations and experience investigations
  • Reserve, Embedded value and Capital adequacy requirement calculations
  • Developed Budget model and process
  • Expense and experience investigations
  • Developed Unit Linked pricing methodology
  • Developed a post-retirement medical assistance valuation model, risk-based capital model for medical schemes, pricing model for medical scheme trustees and a managed care demand model for a healthcare group
  • Pricing of medical scheme contribution rates, capitation arrangements and recommended tariffs
  • Solvency valuation and experience investigation of medical schemes
  • Developed revenue account and balance sheet spread sheets for monthly reporting and a new business profitability model
  • Created product level reconciliation spread sheets to reconcile actuarial models and accounting data
  • Developed financial modelling software for post-retirement medical aid liabilities

CERTIFIED MECHANICAL ENGINEER

  • Variety of roles in Canada and South Africa
  • Responsible for the technical leadership and manufacturing on a variety of integrated solutions for the oil and gas industry: gas compressor units, water injection packages, 2 and 3 phase separators, vapour recovery units and pump jacks
  • Responsibilities:
  • Acted as QA/QC manager
  • Managed portfolio of projects running concurrently
  • Developed company specific piping, pressure vessel and welding specifications
  • Review of supplier documentation for integration within bid submissions and project design (general arrangements/details/calculations/fabrication procedures)
  • Review of PID, design calculations and manufacturing drawings
  • Explosion analysis
  • Cash-flow projections and optimisation of supplier payments
  • Review of pricing methodology and reconciliation after project completion
  • Managed safety reviews, audits, event investigations and managed API audits
  • Lead Mechanical Engineer for the design and procurement of a brown field process plant:
  • Preparation of equipment technical specifications for enquiry (specification/mechanical data sheets)
  • Technical evaluation of supplier bids
  • Preparation of equipment technical specifications for order
  • Review of supplier documentation for integration within project design (general arrangements/details/calculations/fabrication procedures)
  • Project technical support:
  • Risk assessments
  • Design reviews
  • Constructability reviews
  • HAZOP
  • Inspection support, construction support, site support
  • Initiated and managed a research project to determine the effect of repeated post weld heat treatment on the mechanical properties of materials
  • API Fitness for service evaluations
  • Responsible for the mechanical design of process plants equipment and procurement of process equipment for engineering projects in the petrochemical industry
  • Mechanical design of pressure vessels, heat exchangers, tanks, piping and piping components in accordance with international design codes (ASME, BS, AD MerkBlatter, TEMA) Perform Finite Element stress analysis on load bearing components and equipment using NISA software

Timeline

PROPHET CONSULTANT (Contract)

SwissRe
02.2024 - 11.2025

PROPHET CONSULTANT (Contract)

Americo
02.2023 - 01.2024

PROPHET CONSULTANT (Contract)

Ameriprise Financial
08.2022 - 02.2023

SOLUTIONS ARCHITECT (Contract)

Irish Life
03.2020 - 08.2022

CONSULTANT ACTUARY (Contract)

Legal and General
10.2019 - 03.2020

CONSULTANT ACTUARY (Contract)

Lloyds Banking Group
02.2018 - 09.2019

ACTUARIAL SOLUTIONS MANAGER

FIS (formerly SunGard)
09.2012 - 02.2018

PROJECT ACTUARY

Wesleyan Assurance Society
04.2011 - 09.2012

CONSULTANT ACTUARY (Contract)

Sun Life of Canada
08.2010 - 04.2011

CONSULTANT ACTUARY (Contract)

Scottish Widows
05.2010 - 08.2010

Certificate - Finance and Investments

Institute of Actuaries
01.2000 - 01.2007

BEng Hons - Mechanical

University of Pretoria
01.1990 - 01.1994
Willem Johannes Landman