Michael Gibson

Michael Gibson

Prophet Developer, Axa Sun Life Direct

Previous: Axa Sun Life Direct, MGM, Co-operative Financial Services, Legal and General, Hartford Life Limited, Reliance Mutual, Surrenda Link, Swiss Re, Windsor Life, Generali, Norwich Union, Prudential, Classic Solutions, N/a, Britannic Assurance, Commonwealth Bank of Australia, Insurance Council of Australia, Royal and SunAlliance, Zurich Financial Services, Prudential Corporation Australia Limited, Mss


Previous: University Of Queensland


Prophet Developer

At Axa Sun Life Direct

From January 2012 to June 2012
* Developed Pricing Models to calculate IRR, NBV etc in Prophet for new products. Documentation and testing thereof. * Trained staff in Prophet, both group sessions and one-to-one. * Library: Conventional



From September 2011 to December 2011
* Wrote specifications for various components of the Solvency II Modeling System, e.g. the database that will store the valuation data and results. * Tested components of the Solvency II modeling system e.g. the model to perform the Solvency II cashflow calculations. Built a test spreadsheet. ...
Read more

Operational Risk Framework Specialist Advisor

At Co-operative Financial Services

From January 2011 to April 2011
* Developed an Operational Risk Model based on AMA using Excel, VBA and @Risk for Solvency II Capital Requirement purposes. Documentation thereof. Personal Break to care for my ill father in Australia


At Legal and General

From October 2009 to April 2010
* Developed Prophet Model for new product. ; * Developed Controlling spreadsheet for above model. This spreadsheet can run the model, store and export model point files and tables, and goal seek across a block of business. The spreadsheet is fully automated using VBA, Prophet API etc * ...
Read more

Managed an actuarial trainee

At Hartford Life Limited

From April 2009 to August 2009
* Streamlined a spreadsheet for model point production ; * Managed an actuarial trainee, assigning him tasks and training him in model development


At Reliance Mutual

From September 2008 to December 2008
* Developed Linked and Non-Linked Benefits Sub-models for the Reliance Mutual Office Model in Mo.net. Testing and Documentation thereof. * Developed Reinsurance Sub-model for the Reliance Mutual Office Model in Mo.net. Testing and Documentation thereof. * Testing of Deferred Annuity code...
Read more


At Surrenda Link

From June 2007 to February 2008
* Developed from ``scratch'' a MoSes model for a Traded Senior Life Interest (similar to Traded Endowment Policies) portfolio of policies. The model includes the ability to have flexible data set sizes by using Temporary Tables, can handle both single and joint life policies, has an intelligent...
Read more

Actuarial Modelling Lead

At Swiss Re

From October 2006 to April 2007
* Managing the MoSes modeling team (three staff) within Swiss Re Life and Health. This included prioritizing and allocation of tasks, and reporting work progress to senior management and other stakeholders. * Building Excel spreadsheets to test the correctness of the GE Insurance Solutions...
Read more

Prophet Developer

At Windsor Life

From March 2006 to September 2006
* Investigation of differences between the previous owner's Model Office used for a block of business that Windsor Life bought and this block of business in their current Model Office. Adding/updating/testing code to ensure the Windsor Life Model Office is modeling this business correctly. ...
Read more

Prophet Developer

At Generali

From September 2005 to December 2005
* Developing/Improving and testing the Generali Prophet Model Office. This includes developing the Term Assurance, Whole of Life and Endowments products. This also includes merging individual products, e.g. Conventional Annuities, into the main workspace and appropriate regression testing, and...
Read more

Prophet Developer

At Norwich Union

From June 2005 to September 2005
* Developing standardized output for Norwich Union's Prophet Model Office. This includes coding new variables and indicators, adding new indicators to products, and manually adjusting the definition of variables for individual products. Library: Conventional

Lead Actuary

At Prudential

From March 2004 to May 2005
* Developing a Deferred Annuity model, both from a commutation function approach and a cash flow approach, firstly in Excel, and then in Moses. Testing and documentation of the model. The model was successfully used in year end reporting. * Merging the above model with an existing Immediate...
Read more


At Classic Solutions

From September 2003 to March 2004
* Testing and debugging a Moses model that had been converted from an Excel spreadsheet * Testing and debugging of the TAS10 Universal Life model that has been converted from TAS9.5 to the Moses platform

personal travel

At N/a

From December 2002 to September 2003


At Britannic Assurance

From July 2002 to December 2002
* Developed an advanced Visual Basic program to save 600 hours annually of menial work. * Successfully managed the transition of actuarial systems in Alba Life from Glasgow to Birmingham * Gained a basic knowledge of Moses ; * Completed technical specifications for Alba Life's Traditional...
Read more

personal travel / study

At N/a

From October 2001 to July 2002
Studying, Travelling throughout the United Kingdom, Ireland and Japan

Sales Reporting Analyst

At Commonwealth Bank of Australia

From April 2001 to September 2001
* Re-engineering and automation of reports achieving over 95% reduction in the time taken to complete some reports * Developed programming to produce new reports detailing inforce business and discontinuances * Analysis of impact of the Financial Services Reform Bill on third parties such as...
Read more

Statistical Information Manager

At Insurance Council of Australia

From September 2000 to February 2001
* Designed and commenced testing of a formula to update the value of the insured loss for disasters that occurred in the past * Designed a survey to assess current and future uses of the Internet by the Gen Ins Industry * Analysis of the current and future levels of Fire Services Levy for...
Read more

Senior Actuarial Analyst

At Commonwealth Bank of Australia

From May 2000 to July 2000

Actuarial Analyst

At Royal and SunAlliance

From December 1999 to April 2000
* Completion of end-of-year 1999 APRA returns ; * Developed a spreadsheet to calculate reinsurance premiums, splitting the premium out by benefit * Documentation of difference between an externally audited ``year-end'' Prophet model and the current Royal and SunAlliance Prophet model * ...
Read more

Actuarial Analyst

At Zurich Financial Services

From July 1998 to July 1999
* Writing of specifications to extract model point data from new superannuation administration software and liasing with programmers as part of a team to ensure accurate provision of this data. This involved learning the Easytrieve language, decoding a 600 line program and writing the...
Read more

Actuarial Analyst

At Commonwealth Bank of Australia

From July 1996 to July 1998
* Streamlining and re-engineering of programs and processes which are used in the workplace. Quite often, this also involved using initiative to find more efficient and accurate sources of data and integrating these sources into the relevant spreadsheets. In every case, a substantial reduction...
Read more

Group Risk Fund Administrator

At Prudential Corporation Australia Limited

From November 1995 to June 1996
* Completing complex SQL queries for Management Information purposes ; * Administration of group risk policies. This included administration of claims, installation of new policies and termination of policies that where no longer with Prudential ;

Various & Security Guard

At Mss

From 1994 to 1995

University Of Queensland, Brisbane

Bachelor of Science, University of Queensland

From 1988 to 1993
Major in mathematical statistics


  • Actuarial
  • Cash Flows
  • Cognos Impromptu
  • effective handling
  • Intermediate project management
  • Life Insurance > Term life insurance
  • Lotus Notes/Domino
  • Microsoft Access
  • Show all skills (21)