Financial Mathematics, regression & time series forecasting, excel, R

William Ritchie

*** *** ***** ****, ***. ** ****.*******@*******.*** 4900 Hadrian Way

Boone, NC, 28607 704-***-**** Charlotte, NC 28211

EDUCATION

College: Appalachian State University

Bachelor of Science: Mathematics, Actuarial Science

Minor: Statistics

Minor: Economics

VEE’s: Met the Economics VEE requirement upon completion of two actuarial exams

TECHNICAL SKILLS

Excel

* Constructed premium calculation models with VLOOKUP, IF statements, etc.

* Analyzed sensitivity with Data Tables utilizing dummy variables.

* Determined how to reach certain premiums and benchmark profit levels with Goal Seek.

* Constructed a Userform for efficient input manipulation.

* VBA proficiency, including writing Macros such as a lognormal Monte Carlo stock price simulation.

* Performed a sensitivity and macro pricing analysis for a critical illness insurance policy model created in excel.

R-Studio

* Performed multiple time series regressions and forecasts.

* Summarized and visualized data with R Markdowns.

* Simulated experiments to calculate various statistical measurements.

WORK EXPERIENCE

Prep Cook: Salsarita’s Fresh Cantina – Charlotte, NC / July 2013 to July 2015

Line Cook: The Cardinal – Boone, NC / May 2017 to July 2018

Customer Service Representative: Appalachian State Book Store: Computer Sales Department – Boone, NC / July 2018 to February 2019

Shift Leader: Lily’s Snack Bar – Boone, NC / July 2019 to Present

LEADERSHIP

Lily’s Snack Bar, Boone, NC

Shift Leader

* Responsible for the timely preparation and quality assurance of food items.

* Serv-Safe certified to oversee adequate sanitation and the prevention of food-borne illnesses.

* Responsible for ensuring employees stayed on task and used their time efficiently during shifts.

REFERENCES

Dr. Kevin Shirley

* Director, Actuarial Science Program – Department of Mathematical Sciences

* Appalachian State University - Boone, NC

* Email: **********@********.***

* Phone: 828-***-****

Seth Sullivan

* Founder/Co-Owner – Snaxx Restaurant Group, LLC

* Email: ****@*************.***

* Phone: 828-***-****

Charlie Chakales

* Founder/Co-Owner – Snaxx Restaurant Group, LLC

* Email: ****@*************.***

* Phone: 828-***-****

Contact this candidate