Drew Hunt
Data Analyst
Phoenix,AZ
Summary
Problem-solving Data Analyst with over 9 years of experience in Property and Casualty Insurance. Regularly consulted for data management and improving automation using a variety of tools. Excellent reputation for ease of collaboration and idea sharing. True passion for building repeatable ETL processes resulting in solutions for ease of data discovery / analytics for end users. Eager to continue to learn and develop industry-leading ETL skills.
Overview
1
1
Certification
9
9
years of professional experience
Work History
DATA ANALYST
STATE FARM INSURANCE COMPANY
Tempe, Arizona
01.2015 - Current
- Manage and analyze large datasets (100M+) using SAS and SQL through ETL ideas; build ad hoc sets as needed.
- Led and created data strategy for high-profile team, supporting 8 other high performing analysts.
- Create and maintain multiple dashboards, often used by several hundred users.
- SAS programming techniques include report generation, data transformation, data scrubbing, data visualization and dashboard creation.
- Provide visuals/exhibits for State Farm Executives in deliverables on a monthly basis.
- Collaborate with end-users to identify data needs and improve data management processes.
- Analyze claims and underwriting data to identify emerging trends and profitability concerns.
- Design systems to quickly identify population groups experiencing adverse claims trends.
- Automate recurring deliverables using VBA in Excel and PowerPoint.
- Investigate and compare data manipulation for best performance (SAS / Python / R).
- Test future migration efforts from Excel / SAS ecosystem to AWS ecosystem.
STAFF FINANCIAL ANALYST
ALLSTATE INSURANCE COMPANY
Tempe, Arizona
02.2013 - 01.2015
- Consult with Claims Leadership to direct efforts towards achieving claim metrics / staffing goals.
- Optimize cash flows for potential agency candidates.
- Report and present weekly/monthly production and financial data to senior leadership.
- Plan and forecast various insurance measurements for Allstate Specialty products.
- Analyze loss ratio trends and related measurements monthly to determine underwriting income impacts.
- Develop key action plans on cross functional teams to meet SW Regional Goals.
REPORTING ASSISTANT
ALLSTATE INSURANCE COMPANY
Las Cruces, New Mexico
02.2012 - 02.2013
- Perform analyses for call center metrics for teams of processors (Vehicle inspections, survey results, phone metrics, etc).
- Led Core Presentation for April 2012 Las Cruces Express Staff Meeting.
- Diagnose Computer System issues for Processors/Managers locally.
- Manage real-time Staffing to meet Global Service Level for meeting business/customer needs on daily/weekly/monthly/quarterly basis.
- Member of VOICE Action Planning Committee Team.
CUSTOMER SERVICE REPRESENTATIVE
ALLSTATE INSURANCE COMPANY
Las Cruces, New Mexico
09.2011 - 02.2012
- Provide quality service as first liaison between Allstate and customer.
- Set up vehicle inspections for customers.
- Collaborate with Allstate Preferred shops on behalf of customers.
Education
B.S. MATHEMATICS - Finance, Risk Management & Insurance
NEW MEXICO STATE UNIVERSITY
Skills
Amazon Web Services (Quick Sight, S3, Athena, Glue)
Certification
Base SAS Programmer
Timeline
Base SAS Programmer
06-2016
DATA ANALYST
STATE FARM INSURANCE COMPANY
01.2015 - Current
STAFF FINANCIAL ANALYST
ALLSTATE INSURANCE COMPANY
02.2013 - 01.2015
REPORTING ASSISTANT
ALLSTATE INSURANCE COMPANY
02.2012 - 02.2013
CUSTOMER SERVICE REPRESENTATIVE
ALLSTATE INSURANCE COMPANY
09.2011 - 02.2012
B.S. MATHEMATICS - Finance, Risk Management & Insurance
NEW MEXICO STATE UNIVERSITY