Summary

Overview

Work History

Education

Skills

Programming

Certification

Collin Pepin

Saint Paul,MN

Summary

Actuarial Consultant with solid grasp of insurance industry processes, practices and reporting requirements. Highly analytical and detail-oriented yet capable of leading high-level discussions with non-technical audiences. Nearly 7 years of related experience.

Overview

7

7

years of professional experience

1

1

Certification

Work History

Actuarial Consultant

Securian Financial

2021.02 - Current

Lead pricing effort for new UL product, coordinating teams across various departments to ensure successful product launch
Assist customer service with actuarial questions from policyholders on life and annuity products
Develop model for new UL product in Prophet with deterministic and stochastic functionality
Complete annual experience study for Deferred Annuity mortality and compare with prior years
Model cash flow projections for Deferred Annuity products based on various assumptions
Evaluate Fixed and Variable Annuities requiring complex customized quotes
Lead repricing effort and assumption update for Variable Annuity product
Monitor new business sales and earnings for FIA products
Act as resource for questions on UL, FIA and VA products from other departments.

Actuarial Associate

AIG

2018.06 - 2021.02

Calculated reserves in Pension Risk Transfer business using various actuarial methodologies
Provided financial data for Pension Risk Transfer quarterly earnings report along with appropriate analyses to justify multi-million dollar profits and billion dollar reserve increases
Provided financial data for quarterly earnings report along with appropriate analyses
Assisted with implementation of GAAP LDTI and analysis of its impact on earnings and Deferred Profit Liability
Was responsible for year-end valuation and annual reports for states of Texas and New York
Mentored recent college graduates in actuarial student program.

Actuarial Associate (Contract)

AIG

2017.11 - 2018.07

Calculated in-force illustration requests for policyholders that complied with IRS regulations
Edited models for individual customers to optimize potential growth projections
Provided audits for in-force term policies, comparing expected to actual premiums paid by customers
Provided software support for various systems used by AIG to calculate policy projections.

Software Analyst Internship

Gradient Financial

2016.06 - 2016.08

Conducted assessments of financial software related to ease of user interface within SQL database prior to monthly release
Identified software issues and determined root causes to maximize client satisfaction
Reported technical and non-technical evaluations from assessments to management team.

Education

Bachelor Of Science - Actuarial Science

University of St. Thomas, St. Paul, MN

05.2017

Skills

Mentoring and Coaching
Experience studies
Actuarial software proficiency

Product pricing
Model Development

Programming

Microsoft Excel
VBA
Prophet
RStudio
SQL
SAS
ARC-CASE
Python

Certification

Associate of the Society of Actuaries (ASA)