Benjamin Erickson Email & Phone Number

Harrisburg, Pennsylvania, United States

• Developed VBA macros for computing accrued pension benefits for over 500 pension participants across 3 terminating pension plans based on plans’ specific provisions, benefit formulae, and salary and service data• Efficiently and accurately prepared over 40 pension documentation forms for submission to the IRS• Automated the simultaneous searching of data in multiple PDF files with a VBA macro, enabling the performance of searches in under 15 seconds per file and eliminating human error

Radnor, Pennsylvania, United States

• Transitioned quarterly captive reserves reporting Excel file utilizing 9 VBA macros to a new set of statutory regulations, documenting all processes performed by the file and assessing the macros’ transferability• Automated the quarterly process of importing IUL fund data into an Access table with a VBA macro, decreasing the process’s duration by up to an hour and minimizing error potential• Prepared over 10 MG-ALFA models for sensitivity analysis, assisting in determining the model’s volatility• Job shadowed over 25 full-time actuaries, developing networking aptitude and gaining exposure to a wide variety of actuarial roles across 5 business lines • Delivered a 15-minute presentation to over 20 full-time actuaries summarizing projects completed and skills gained during the internship

Doctor Of Philosophy - Phd, Mathematics

Passed qualifying exams: Abstract Algebra

Bachelor Of Science, Mathematics: Actuarial, 4.00

Activities and Societies: Actuarial Club (President), Sports Analytics Club (Vice President of Analytics), SGA Treasury Team and Funding.

High School Diploma