60317c5a-cc45-41cd-a29d-1f1efbd0c7a3

Andrew Smith


287 Custer Street, Hopewell, PA 00000

(000) 000-0000

Professional Summary

I am working at Aon Consulting Pvt Ltd as Actuarial Analyst as part of UK Retirement team.

I cleared CS1 from IFOA and I cleared CT-9 from IAI. I am member of both IAI and IFOA . The combination of my computer science background and passion for data analysis makes me the right fit for the ever changing landscape of the insurance industry.

Employment history

Actuarial Analyst, Kuhlman Group. Kristophermouth, Tennessee
Feb. 2020 – Present
Working for UK DB pension Schemes

Main Responsibility:

1) Pension Valuation : 

  •   Estimation of liability on different basis: Last time’s Ongoing basis  ,Current Ongoing Basis, Solvency Basis  etc.
  • Checks the liability from the tool manually – Global checks,individual member checks,roll forward checks and change of basis checks using Excel and Pen and Paper.
  • Prepared Prism setup which helps in estimating funding level of the pension scheme during the valuation periods. 
  • Valuation Report and  Valuation Notes were prepared.
2) Funding Updates:
  • Doing Quarterly/Half yearly/Annual Funding Updates to estimate the funding level of the pension scheme between the valuation periods.
  •  Annual/Quarterly Funding Report , Recovery plan report were prepared.
  • Global checks using Pen and Paper. 
3) Accounting:
  •  Preparing  Accounting Disclosures.
  •  Analysis of Surplus , Sensitivities.
  •  Preparing US GAAP, IAS19 and FRS102 report.
4) Doing individual  transfer  member  pension calculation along with corresponding checks of that member was done using pen and paper.

5) Part of AROM (Aon Retirement Optional Model) team: Various test cases  were built up on to create the model and corresponding reports were done and set up report of the  model.

Intern, Stoltenberg, Rath and Barrows. West Juliana, Delaware
May. 2017 – Jun. 2017
Worked on REM(Random Effect Model) to create a model, the specific task included data cleaning, understand underlying data,handling missing values,testing missing models and reporting 

Intern, Douglas Group. North Dexter, Indiana
Apr. 2017 – May. 2017
Did internship in University of Hyderabad under the guidance
of Dr B.G Manjunath on “Survival Analysis on Titanic
Disaster using R”.

Education

North Bosco College, Kossfurt, Kansas
Master of Science, Actuarial Science, Dec. 2018

Western Delaware Institute, North Landonfurt, Kansas
B-Tech, Computer Science, Nov. 2016

Western Florida University, Franklinchester, Arkansas
High School Diploma, 12th Class, Dec. 2012

Accomplishments

Languages

English

Hindi

Tamil

Telugu

Skills

Team Player

Problem Solving

Mentoring

Analytical Skills

Excel

R Programming language

b6b6dfb7-eb50-44b3-9e27-8a8ed5f67d67

Andrew Smith


287 Custer Street, Hopewell, PA 00000

(000) 000-0000

Professional Summary

I am working at Aon Consulting Pvt Ltd as Actuarial Analyst as part of UK Retirement team.

I cleared CS1 from IFOA and I cleared CT-9 from IAI. I am member of both IAI and IFOA . The combination of my computer science background and passion for data analysis makes me the right fit for the ever changing landscape of the insurance industry.

Employment history

Actuarial Analyst, Rippin, Cronin and Mitchell. West Issactown, Georgia
Sep. 2019 – Present
Working for UK DB pension Schemes

Main Responsibility:

1) Pension Valuation : 

  •   Estimation of liability on different basis: Last time’s Ongoing basis  ,Current Ongoing Basis, Solvency Basis  etc.
  • Checks the liability from the tool manually – Global checks,individual member checks,roll forward checks and change of basis checks using Excel and Pen and Paper.
  • Prepared Prism setup which helps in estimating funding level of the pension scheme during the valuation periods. 
  • Valuation Report and  Valuation Notes were prepared.
2) Funding Updates:
  • Doing Quarterly/Half yearly/Annual Funding Updates to estimate the funding level of the pension scheme between the valuation periods.
  •  Annual/Quarterly Funding Report , Recovery plan report were prepared.
  • Global checks using Pen and Paper. 
3) Accounting:
  •  Preparing  Accounting Disclosures.
  •  Analysis of Surplus , Sensitivities.
  •  Preparing US GAAP, IAS19 and FRS102 report.
4) Doing individual  transfer  member  pension calculation along with corresponding checks of that member was done using pen and paper.

5) Part of AROM (Aon Retirement Optional Model) team: Various test cases  were built up on to create the model and corresponding reports were done and set up report of the  model.

Intern, Johnston and Sons. Lawandafort, Maine
May. 2017 – Jun. 2017
Worked on REM(Random Effect Model) to create a model, the specific task included data cleaning, understand underlying data,handling missing values,testing missing models and reporting 

Intern, Turner, Hermann and Klein. Wisokyberg, Mississippi
Apr. 2017 – May. 2017
Did internship in University of Hyderabad under the guidance
of Dr B.G Manjunath on “Survival Analysis on Titanic
Disaster using R”.

Education

Bergnaum University, Hirtheport, Alaska
Master of Science, Actuarial Science, Jun. 2018

Southern Kilback College, North Warrenfort, Hawaii
High School Diploma, 12th Class, Mar. 2016

East North Carolina College, Carterstad, Nebraska
B-Tech, Computer Science, Feb. 2016

Accomplishments

Languages

English

Hindi

Tamil

Telugu

Skills

Team Player

Mentoring

Analytical Skills

Problem Solving

Excel

R Programming language

actuarial analyst

  • Experience Studies (November 2015 – Present)Analyze statistical information to estimate mortality, lapse and morbidity rates.
  • Review and understand the assumptions and business drivers for Retail, Group and Federal Long Term Care.

actuarial analyst

  • Conducts regular experience monitoring and studies on claims. The study has managed to improve company’s financials by increasing business profitability by x% and embedded value by x%, as part of its recommendations.
  • Leads the analysis and implementation of the changes in reinsurance treaties. Initiatives implemented have helped reduce reinsurance cost annually which effectively increased the company’s embedded value by x%.
  • Have handled other experience studies and projects such as:Review of commission and expense assumptions
  • Study on underwriting non-medical authority limits
  • Financial analysis on agency benefit structure changes
  • Policy rider attachment monitoring, and Asset-Liability management

actuarial analyst

  • Responsible for 2 clients under 2 different supervisors’
  • Liaison between the company and the client on basic data collection and communication 
  • All regulatory tasks related to the client from data handling to final reports.
  • Self-learned VBA in free time to develop more complicated models and standardize tasks.
  • Trained 2 personnel on different actuarial reserving methods and data analysis and handling.

actuarial analyst

  • Built GLM Models (split by Perils) for Corporate, SME and Personal lines. Extensive tests were carried out to identify correlations an interactions between suitable rating factors.
  • Impact Analysis was done which showed the credibility of models. Separate loading for Large Losses was decided based on age bands.
  • Carried out discussions with underwriters and business teams to add the factors in the Pricing Module which was then used for quotations. Also, was actively involved in Large Corporate Pricing.
  • Helped in Technical Pricing of a new product to be launched by taking into consideration the specifications, limits and exclusions by comparing it with existing products.

actuarial analyst

  •   Estimation of liability on different basis: Last time’s Ongoing basis  ,Current Ongoing Basis, Solvency Basis  etc.
  • Checks the liability from the tool manually – Global checks,individual member checks,roll forward checks and change of basis checks using Excel and Pen and Paper.
  • Prepared Prism setup which helps in estimating funding level of the pension scheme during the valuation periods. 
  • Valuation Report and  Valuation Notes were prepared.

actuarial analyst

  • Explain changes in provisions to client companies.
  • Ascertain cash reserves and liabilities necessary to ensure payment of future benefits.
  • Providing different types of actuarial reports for Employee Benefits.
  • Arrange for disposal of surplus materials.Fasten seams or joints together with welds, bolts, cement, rivets, solder, caulks, metal drive clips, or bonds to assemble components into products or to repair sheet metal items.

senior actuarial analyst

  • Currently responsible for one of the biggest general insurance companies in UAE (ADNIC)
  • Liaison between the company and the client
  • Meeting with clients
  • Complete all regulatory tasks related to the client from data handling to final reports.
  • Pro-actively developed and standardized different models to handle different analysis and requirements effective and efficiently reducing time and redundant tasks
  • Undertook a (first time in UAE) project relating to worker’s compensation in concern with Ministry of Human Resources and Emiratization (MOHRE) with a team of 3
  • Supervisory and training role over 2 personnel

senior actuarial analyst

  •  Assisting in profit testing using the company product portfolio
  • Assisting with experience studies.
  •  Actuarial model creation using DCS (subsystem of prophet actuarial software) and coding
  • Company Valuation, Cash flow generation and liability calculation using prophet actuarial software and using excel for un-modelled products.
  • Complete responsibility in handling actuarial data process, Checking, cleaning, filtering and converting data.
  • Complete responsibility in model point creation through DCS.