Rookesbury Consulting

Actuarial and technical services from Rookesbury Consulting

Rookesbury Consulting specialises in providing model design, build and test services for use in actuarial areas.

We have a wide knowledge of MoSes modelling software, in addition to an advanced knowledge of Word, Excel and VB/VBA, and other software.

Previous actuarial experience includes permanent and contract work for both life and general insurance companies, including HSBC, Prudential, Skandia (Old Mutual Wealth) and Zurich.

If you would like more information about the services which we provide, please contact us.

Partnership

January 2015 to June 2015
(six-month contract)

Location: Partnership Assurance, London.

Overview: Development and testing of MoSes model for pricing and valuation of Defined Benefit Pensions.

Tasks:

  • Functional testing of new Defined Benefit Pensions MoSes model.
  • Regression testing to existing pricing and valuation models.

Prudential

October 2014 to January 2015
(three-month contract)

Location: Prudential, Paddington, London.

Overview: Development and testing of stochastic with-profits MoSes model.

Tasks:

  • User acceptance & functionality tested changes to MoSes asset liability model for with-profits products.

Partnership

March 2014 to October 2014
(three-month contract with one extension)

Location: Partnership Assurance, London.

Overview: Development and testing of MoSes model for pricing and valuation of Defined Benefit Pensions.

Tasks:

  • Functional testing of new Defined Benefit Pensions MoSes model.
  • Regression testing to existing pricing and valuation models.

HSBC Life UK

November 2012 to December 2013
(two-month contract with three extensions)

Location: HSBC Life UK, Southampton.

Overview: BAU development and support.

Tasks:

  • Assisted with design & implementation of MoSes HPC & subsequent user acceptance testing & training.
  • Assisted with developing & testing MoSes data file creation process in SAS.
  • Provided MoSes development & testing support & training.
  • Model documentation of unit linked pension MoSes model.
  • Provision of day-to-day support & task management to MoSes development team of four people.

HSBC Life Malta

October 2012
(fixed price contract)

Location: HSBC Life Malta, Southampton.

Overview: MoSes development.

Tasks:

  • Implemented & tested asset share projection within the HSBC Malta Life unitised with-profits MoSes model, based on a spreadsheet specification.

HSBC Life UK

October 2010 to September 2012
(six-month contract with three extensions)

Location: HSBC Life UK, Southampton.

Overview: Solvency II Project.

Tasks:

  • Investigated existing MoSes models with a view to improving model efficiency, including specification of changes & reporting of anticipated impact on run times.
  • Implemented existing stand-alone stress test runs into a single projection run to significantly reduce overall model run times.
  • Designed & implemented MoSes model changes to improve AoS / PandL attribution process.
  • Implemented MoSes model changes to calculate projected balance sheet capital positions.
  • Provided UAT testing support & training.
  • Performed analysis & investigation into existing MoSes models & subsequent documentation of faults & inconsistencies between models.
  • Provided day-to-day support & task management to MoSes development team of four people.

Prudential

September 2009 to September 2010
(six-month contract with one extension)

Location: Prudential, Paddington, London.

Overview: Solvency II Project.

Tasks:

  • Performed analysis of existing stochastic MoSes model to document potential efficiency improvements.
  • Investigated known model deficiencies & assessed impact of corrections.
  • Created technical specification for model efficiency improvements & deficiency corrections.
  • Specified & user acceptance & functionality tested changes to MoSes asset liability model for with-profits products, & Access/VBA data manipulation tool, used for production of reports.
  • Created, tested & reviewed patched MoSes models to incorporate code fixes or additional functionality between official model releases.
  • Peer reviewed colleagues' testing processes & results.

Pacific Life Re

May and June 2009
(one-month contract with one extension)

Location: Pacific Life Re, London.

Overview: Development and testing of model changes using MoSes, FoxPro & Excel.

Tasks:

  • Developed, tested & implemented changes to MoSes models for annuities.
  • Incorporated existing pension annuity pricing spreadsheet into existing MoSes longevity model.
  • Integrated pricing, valuation & planning MoSes models into a single application for all annuities business.

HSBC Life UK

December 2008 to March 2009
(three-month contract)

Location: HSBC Life UK, Southampton.

Overview: Development and testing of model changes using MoSes, FoxPro, Excel & SQL.

Tasks:

  • Development, testing and implementation of changes to MoSes models for Term, IP and Unit Linked Life and Pensions.
  • Data manipulation using FoxPro and SQL.

Prudential

December 2007 to December 2008
(four-month contract with two extensions)

Location: Prudential, Paddington, London.

Overview: User acceptance testing of MoSes model changes and associated data and reporting tools, using MoSes, FoxPro, Excel, Access & VBA.

Tasks:

  • User acceptance and functionality testing of changes to MoSes asset liability model for with-profits products.
  • Creation, testing and review of patched MoSes models to incorporate code fixes or additional functionality between official model releases.
  • User acceptance and functionality testing of Access/VBA data manipulation tool for production of summary reports from MoSes model results.
  • Regression and step-through analysis between model versions.
  • Review of other people's testing processes and results.
  • Analysis of changes to data input into MoSes model.

Cardif Pinnacle

November 2007
(four-week contract)

Location: Cardif Pinnacle, Borehamwood, Hertfordshire.

Overview: ICAS capital modelling work, using Igloo & Excel for creditor, warranty & shortfall insurance products.

Tasks:

  • Igloo model specification, design & build.

Zurich Financial Services

May 2004 to October 2007

Location: Zurich UK General Insurance, Whiteley, Hampshire.

Overview: Capital modelling, reserving & reporting work, using Igloo, ResQ Pro, SAP, Applix TM1, Excel & VBA.

Tasks:

  • Production of ICAs for 11 legal entities; Created, improved & maintained Igloo/Excel models for Credit, Market & FX risks & an integrated model.
  • Project management of: quarterly reserve report production for UK executive; and annual ICA modelling & report creation over a 3-month period.
  • Created & implemented reserve variability calculations.
  • Quarterly reserve review & peer reviews of Zurich Municipal lines of business.
  • Reviewed & documented annual Asbestos reserve analysis, involving SAS.
  • Provided IT support to department, including technical coding & software questions, hardware and other general IT set up and support.

Skandia Life

September 2001 to May 2004

Location: Skandia, Southampton.

Overview: Financial Reporting Development team, working with MoSes, FoxPro, VB & Excel.

Tasks:

  • Specified, created & reconciled new MoSes models to previous VB programs for life assurance & pension products.
  • Implemented MoSes COM functionality, linked to VB & Access.
  • Obtained requirements, wrote specification & coded data cleaning & manipulation program in VB, with interaction to Access & FoxPro.
  • Maintained & provided support for MoSes models & associated VB programs.
  • Ensured accurate version control of all models & programs.
  • Designed & maintained department intranet site.
Rookesbury Consulting Limited
Copyright © 2015-2017 Rookesbury Consulting Limited | Legal