Sign in

Business Intelligence Analyst

Kansas City, Missouri, United States
October 22, 2018

Contact this candidate


Alan C. Schrader

**** ***** ***

Kansas City, MO 64114


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

Contact this candidate