Zachary Miller
Senior Data Analyst
Windsor Mill,Maryland
Summary
Detail-focused Data Analyst with knowledge in data visualization, process validation and business needs analysis. Proven to understand key stakeholder requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
8
8
years of professional experience
Work History
Senior Data Analyst
Penske Truck Leasing
3 2024 - Current
- Analyzed over 50 million historical incoming vendor records to determine platform-wide normalization requirements
- Developed dashboards using AWS Quicksight to communicate business trends and customer analyses to key stakeholders, reducing internal research time by 70%
- Successfully implemented crosswalk tables to decode data fields and integrated decoded fields into key reporting in Python and SQL for ease of communication
- Created process guides for AWS products, such as DataBrew and QuickSight.
Lead Benefits Analyst
CBIZ
04.2020 - 03.2024
- Provided strategic consulting, accurate data analysis, and benefit calculations for de-risking projects, earning firm over $1 million and impacting over 6,000 participants
- Developed Visual Basic and SQL-embedded Microsoft Excel-powered benefit calculators, ensuring consistent and accurate benefit calculations
- Improved data feed reconciliation by 50% by successfully utilizing Visual Basic and Microsoft Access to automate existing processes
- Promoted from Benefits Analyst to Senior and Lead Benefits Analyst.
Ceded Reinsurance Accountant
AXA XL
02.2018 - 03.2020
- Improved premium and loss reconciliation timeline by 50% for various long-term accounts
- Coordinated with underwriters to accurately construct more than 200 supplemental bordereaux for delivery to key stakeholders, including brokers and reinsurers
- Successfully and promptly reconciled over $250M of cessions in quarterly data quality process to fulfill statutory requirements.
Pension Benefits Analyst
Willis Towers Watson
10.2016 - 02.2018
- Reduced monthly payroll reconciliation time by 90% by developing Visual Basic and SQL-embedded Microsoft Excel tools
- Successfully managed the system testing process for client team responsible for 20,000 participants
- Created and maintained documentation of internal processes for client team overseeing 20,000 participants.
Education
Bachelor of Arts - Mathematics
Gettysburg College
Gettysburg, PA 05.2001 -
Skills
Python Programming
ETL processes
Advanced Excel
Statistical modeling
R Programming
SQL Expertise
Tableau Software
Data Synthesizing
Technical Writing
Project Management
Timeline
Lead Benefits Analyst
CBIZ
04.2020 - 03.2024
Ceded Reinsurance Accountant
AXA XL
02.2018 - 03.2020
Pension Benefits Analyst
Willis Towers Watson
10.2016 - 02.2018
Bachelor of Arts - Mathematics
Gettysburg College
05.2001 -
Senior Data Analyst
Penske Truck Leasing
3 2024 - Current
Similar Profiles
NATHANIEL V. BLUIETTNATHANIEL V. BLUIETT
Facilities Coordinator at Penske Truck LeasingFacilities Coordinator at Penske Truck Leasing
Kamar ColemanKamar Coleman
Diesel Mechanic at Penske Truck LeasingDiesel Mechanic at Penske Truck Leasing
Daniel MardockDaniel Mardock
Customer Service Coordinator at Penske Truck LeasingCustomer Service Coordinator at Penske Truck Leasing
Nicholas CrowellNicholas Crowell
Sales and Operations Management Trainee at Penske Truck LeasingSales and Operations Management Trainee at Penske Truck Leasing
Syed RizviSyed Rizvi
Security Officer at Allied Universal Security ServicesSecurity Officer at Allied Universal Security Services