Alan C. Schrader
Kansas City, MO 64114
ac7gn6@r.postjobfree.com
Career Objective
Over nine years of actuarial experience using statistical and analytical methods to provide data mining and business intelligence insight for executive-level business decisions
Professional Experience
Hudson Insurance Group Overland Park, KS
Actuary December 2017 – May 2018
Developed statistical models to allocate policies based on historical and categorical risk
Conducted statistical tests to substantiate model output and verify credibility of data-based insights
Built tables and dynamic queries using SQL Server for day-to-day projects and analyses
Used SQL Server, Power BI, R Studio, VBA, Excel, and Word in daily activities
Cameron Insurance Companies Cameron, MO
Actuarial Analyst II August 2008 – December 2017
Strategized with executives and board members to create and execute business plan items
Implemented a comprehensive rate conversion for the commercial auto line of business while transitioning into a new policy system
Built revenue effect models for multiple lines of business to more quickly and more accurately predict the outcome of given rate changes
Automated quarterly and annual analyses using dynamic SQL Server queries and VBA to increase efficiency
Worked closely with Information Technology, Underwriting, and Marketing to implement rate changes, effectively communicate coverage changes to our agency force, and receive feedback from both agents and insureds to affect product decisions
Submitted rate/rule filings to state insurance departments and corresponded with reviewers to settle objections or concerns
Owned product reviews for multiple lines of business and was responsible for analysis, timelining, discussion steering, presenting the recommendations to the executive board for approval, implementation, and wrap-up
Used SQL Server, Tableau, VBA, Excel, and Word in daily activities
Collegiate Education
Truman State University Kirksville, MO
Bachelor of Science in Mathematics May 2008
with minors in Statistics and Actuarial Science