Mercy Otieno

Actuarial Analyst

Contact

**** ***** ******,

Shakopee, MN 55379

952-***-****

adg70z@r.postjobfree.com

linkedin.com/in/mercy-otieno-306b25138

Profile

Detail and goal-oriented individual with strong quantitative analysis and communication skills. In-depth knowledge of data extraction, modification, modelling and validation testing. Proven self-motivator who works well independently and within a team environment comfortably playing both leading and member role. Committed to attaining a Fellow of the Society of Actuaries (FSA) designation and building up my practical experience.

Key Skills

R

SQL

Matlab

Prophet

MS Office

Excellent oral and written communication

Organized, diligent, and tenacious

Activities and Interests

Travel

Literature

Art

Yoga

Reading

Relocation

Will relocate for a suitable role

Actuarial Science Exams

Exams Passed (Society of Actuaries - SOA)

Probability Exam

Exams Passed (Institute and Faculty of Actuaries - IFoA)

General Insurance: Reserving and Capital Modelling (ST7)

General Insurance: Pricing (ST8)

Projects

Pension Scheme Project (July 2020)

• Conducted an actuarial analysis on the impact of public pension scheme reformations in the United Kingdom (UK) by using MS Excel to model the distribution of future pension financial statements and ultimately assessing the Standard Contribution Rate.

• Managed and executed the entire project from start to finish including data gathering and manipulation, synthesis and modelling, problem solving, scenario testing and communication of insights.

• Gathered appropriate industry data such as lapse and retention rates through the IFoA and investigated the mortality experience to ensure the production of accurate cashflow.

• Carried out calculations to check the reasonableness of assumptions and figures. Prepared liability analysis for defined benefit pension plans based on actuarial data under a variety of assumption sets.

• Quantified UK government’s risk exposure and proposed ways to minimize risk.

• Prepared and presented a detailed report documenting my findings and conclusions.

Pandemics (May 2020)

• Investigated the actuarial perspective of pandemics focusing mainly on the impact of covid-19 on the economic and social environments of the UK.

• Using the IFoA publication – Longevity Bulletin 6 as a guide, I considered the amendments the UK government should have implemented on its pandemic risk models and public health policies in order to mitigate the impact of covid-19 on the UK population.

Saga Workshop (September 2018)

• Worked closely with a group of fellow students to propose ideas to help a local insurance company - Saga, develop commercially attractive products and services that would best meet their current and prospective customers’ needs.

• Saga is a leading provider of products and services for people aged 50 and over in the UK. They adopted a variety of our proposals from the workshop. For instance, the implementation of partnering with cottages.com to offer discount to their clients who desire to go for a retreat with or without their families around the UK, Ireland, France and Italy all year round. As a result, Saga increased their clientele by 10%.

Experience

Jan 2017 – Aug 2017

Data Reporting Analyst COMCAST • Englewood, Colorado

• Worked as a data analyst in a Business Intelligence team, where I developed and analyzed both cadence based and ad-hoc reporting. This information was used to gain insights that were shared with key stakeholders who made strategic decisions to achieve the institution’s financial goals.

• Created and maintained financial databases and reports. Utilized Macro-VBA programming to automate report updates.

• Provided input into analytic project plan development and used query tools to complete work projects, primarily by modifying existing code and tools.

• Translated nuanced data analysis into non-technical visualizations and written summaries to demonstrate how the analysis answers identified questions.

• Analyzed account executives’ key performance indicator (KPI) in order to quantify the efficacy of sales strategies.

Aug 2016 - Dec 2016

Pension Analyst WILLIS TOWERS WATSON • Denver, Colorado

• Prepared and peer reviewed pension benefits packages in accordance to plan provisions, institutional procedures and government regulations.

• Performed basic checks for data consistency, according to defined criteria

• Maintained clear work documentation using audit trail.

• Managed queries from clients and beneficiaries, ensuring good client relations was enhanced and maintained.

Jun 2013 - Aug 2013

Inside Federal Sales Intern GLOBAL TECHNOLOGIES RESOURCES • Denver, Colorado

• Facilitated correct and detailed Request for Proposals (RFP) for Solutions for Enterprise-Wide Procurement (SEWP) V for NASA.

• Conducted vendor selection to identify companies that were compliant with NASA IT specification.

• Collaborated with a team to acquire IT hardware and software that fulfilled NASA’s technical requirements

Education

August 2020

MSc in Actuarial Science with Data Science• Accredited by IFoA,

HERIOT-WATT UNIVERSITY, Edinburgh, Scotland, UK

August 2019

MSc in International Actuarial Science •Accredited by IFoA

University of Kent, Kent, England, UK

May 2015

Bachelor of Science in Mathematics with a concentration in Probability and Statistics and a Minor in Economics.

University of Colorado, Denver, Colorado, US

Additional Training

Coursera Courses

Data Science (by John Hopkins University)

Excel to MySQL: Analytic Techniques for Business (by Duke University)

edX Courses

Data Science: Productivity Tools (by Harvard University)

Data Science: Inference and Modelling (by Harvard University)

Data Science: Visualization (by Harvard University)

Affiliations

Member: Institute and Faculty of Actuaries

Contact this candidate