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)
FileZilla Ftp Management
Hyperion Essbase
Microsoft Office (Word, Excel, PowerPoint)
Python
SAS (Base and Enterprise Guide)
Qlik Sense / QlikView
SharePoint (JavaScript/HTML)
SQL
Tableau
VBA
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