Chandler Sommerville
www.sommerville.devDelivering technical solutions to actuarial problems for over 15 years
About
As an actuarial technologist, I specialize in building data solutions that work for actuaries. I've taken multiple actuarial data warehouse projects from idea through execution, and I also have experience migrating complicated, Excel-based applications to modern, database-powered web applications.
Work Experience
American Modern Insurance GroupRemote
Principal Data Engineer
2024 - Present
2020 - 2023
Built an actuarial ratemaking web application using React and Django. Technical lead on project. Performed several development roles, including front-end, REST API, quantitative development, and data engineer roles. Actuarial liaison on enterprise data warehouse / actuarial data mart project.
Voya FinancialRemote
Actuary Manager
2023 - 2024
Design a data model to integrate billing, claims, compensation, policy, and other data sources into a cohesive data model, suitable for actuarial use cases. Liaise between IT and actuarial teams to execute on the data strategy.
AflacRemote
Senior Actuarial Systems Consultant
2017 - 2020
Built an actuarial data warehouse to support fine-grained actuarial analysis. Migrated legacy data sets from DB2 to Teradata. Developed ETL jobs. Trained and deployed machine learning models to enrich the data model.
Medical University of South Carolina
Senior Quality Analytics Consultant
2016 - 2017
Used data to drive evidence-based medicine practices in the hospital. Statistical analysis (OLS, GLM, LASSO) to measure efficacy.
Aflac
Actuary I - III
2008 - 2016
Exam-taking actuary. Migrated actuarial data out of MS Access into DB2. Overhauled reserve calculation and experience studies processes by writing as SQL stored procedures. Financial and data analysis.
Accomplishments
Associate of Society of ActuariesFormer
2014
Stopped paying dues due to career shift to technical roles
Education
Georgia Institute of Technology
2003 - 2007
B.S. Applied Mathematics