Data Analyst Engineer
Resume:
Michael Robert Dietzel
Long Beach California, 90808
P: 440-***-****
E:**************@*****.*** MRD
Objective
Seeking a Data Engineer or Data Analyst Engineer position where I can design, build, and optimize scalable data pipelines and architectures to solve complex business challenges. Technical
Skills
5+ years of experience 3 + Years of
experience
1 + Year of experience Less than one year of
experience
SQL
Script Creation
Query optimization
VBA
Access
Open Text
SAS
Excel
Python
PySpark
Pandas
Tableau
Github
IBM mainframe
SISS
Google Cloud Platform
Data Bricks
Bigquery
Google Cloud Buckets
Power Bi
Azure
Alteryx
R
Gitlab
Composer
Experience
Sales Support Organization, Lead Sales Reporting Analyst, Medical Mutual Of Ohio Dec 2024 to Present
Responsible for supporting the Sales teams move to modern architecture and increasing FTE capacity for new reporting. Creating AD hoc data solutions for Leadership stakeholders. Accomplishments:
● Created a Databricks user layer for Sales and Finance to complete month-end reporting.
● Migrated all relevant Microsoft Access jobs to SQL Server scripts to an EDW system.
● Created Data pipelines to Ingest Forecast and historic data into databrick Silver Plus layer.
● Completed UAT testing of Databricks data to ensure Bronze layer data was correct.
● Created a Key Performance Dashboard to replace manual processes and provide round the clock information.
● Mapped New CRM system and created several Tables and views for analytics teams.
● Reduced report task time of service book of business from 48 hour build time to 22 Seconds by utilizing EDW system.
● Reduced mutual appreciation report time from 1 day to 4 Seconds utilizing EDW SQL scripts.
● Created automated audit process eliminating manual Intervention in Mutual Appreciation maintenance Process.
● Overhauled net change report reducing build time From 4 hours to 14 Seconds.
● Eliminated two customer-exposing SSN processes by replacing them with Member ID usage.
● Created Automated ODS based reporting off legacy application for managing prospects called
“Goldmine” something that had been missing from the company since 2002.
● Created a Prospect Report showing all changes to prospect interactions every 24 hours.
● Created a Prospect History Report Showing each prospect's evolution over the last 6 years.
● Retired old DB2 Book of Business database process that took 36 hours to complete/create monthly.
● Created Data Mart using existing architecture to ensure ad-hoc reporting turnaround could be completed in as little as 2 hours instead of 72 hour turn around.
● Reviewed Weekly KPI and communicated Changes to weekly stakeholders.
● Created an ad-hoc report template utilizing SQL and VBA l so that Internal customers could self-serve data requests saving the data team roughly 40 hours per month.
● Helped Document Processes for translation into the DataBricks Environment.
● Created data mapping documentation for I.T. teams to utilize in data modeling.
● Developed a relational data model for the Data Engineers to implement in early cloud deployments.
● Created five new reports identifying various prospects as required by outside consultants. Analytics & Data Management Organization, Sr Data Management Analyst, CNA May 2022 to Dec 2024
Responsible for supporting the CDE, FDE, and ADK teams. Creating data solutions for analysts and business stakeholders.
Accomplishments:
● Created Common Models tables in GCP to support our Claims Common Models for CNA Analyst teams.
● Migrated data from on-prem to Google Cloud Storage systems.
● Responsible for running monthly reports for senior leadership.
● Created data sets and data feeds for third-party AI vendors. These feeds were utilized in Storm Forecasting and Recalcitrant Carrier disputes.
● Created a daily Snap and Organization roll-up table to capture changes to employees and organizational structures.
● Responsible for repairing Daily report runs and distribution.
● Created a data pipeline that transferred International Data for Monthly/Quarterly reporting.
● Created Python dags to delete legacy files and maintain clean GCS buckets.
● Generated a SQL script to capture and upload Legacy Data in the Google Cloud Storage Buckets.
● Worked with the AI Bill review team to ensure all documents were successfully migrated.
● Responsible for the Automation and maintenance of 27 daily reporting scripts.
● Helped create a balancing process for several files.
● Elevated Scripts from Pre-Prod to production spokes.
● Maintained Companies Central claims reporting script "DOSOT" daily one source of truth. Personal Lines Control, Business Intelligence Team, Bi Developer, Progressive Insurance Jan 2021 to May 2022
Responsible for supporting the Personal Lines initiatives and key objectives. Responsible for working with analysts and creating tables and processes to support senior management needs. Accomplishments:
Responsible for supporting the Personal Lines initiatives and key objectives. Responsible for working with
analysts and creating tables and processes to support senior management needs. Accomplishments:
● Created the Conversion by variable reporting package, combines two analyst workloads into one package that is executed automatically each month using SSIS.
● Created a customer segmentation reporting package allowing for detailed tracking of Customer cross product purchases and across the customer life cycle.
● Built a Multi-Product elasticity report that produced several dozen elasticity calculations in several minutes utilizing a myriad of data sources.
● Created a SL elasticity data table that procure over 1000+ elasticity calculations each month based on
all major Project variables.
● Produce Quarterly, Monthly and Yearly data runs for Progressive homeowners data.
● Created Homeowner policy database to track term to term data. This process replaced the
● Responsible for running National Survey Reporting package for the senior executives
● Repaired Broken VBA code and Macros for various legacy projects.
● Support Analysts attempting to set up VBA
● Responsible for monthly data loads, and addressing any customer concerns.
● Cleaned 3rd party vendor data to allow it to match up with Progressive system needs. Claims Control, Catastrophic response Team Staffing and Efficiency, Technical Data Analyst, Progressive Insurance
June 2019 to Dec 2021
Responsible for supporting the Specialty Zone initiatives and key objectives. Responsible for designing, creating, and elevating reports that allow senior leaders to create tactical and proportional responses to large-scale weather events within 24 hours of occurrence. Accomplishments:
● Created an expected productivity Tool to help define Staffing needs.
● Worked with Zone Process Leaders to identify the best locations to source contingency reps.
● Created data tables and various measures to make sure that the Mailroom team could be held to productivity standards in a contingency environment.
● Created reporting and Tableau visuals for the new mailroom and data entry group.
● Performed time study analysis on the proof of concept team to understand bottlenecks and identify technical/physical solutions.
● Worked to create a post-COVID volume tool to understand the national shutdown's impact on Progressive claims events.
● Created a daily forecast table to better anticipate volume trends, and to better create budgets for the specialty zone.
● Responsible for assisting in purchase order supply analysis for on-site inspections as COVID-19 prevented progressive-managed repair reps from inspecting vehicles in person.
● Created a web application utilizing Flask and Python that automated claims forecasts for hail, flood, and wind events in the United States. Allowed events to be forecasted in short order after their occurrences allowing for more efficient utilization of staffing resources.
● Created a K nearest neighbor algorithm to identify storm types and reporting patterns to understand incoming hail volume better.
● Implemented a k-Nearest Neighbors (k-NN) algorithm to analyze weather events and determine whether forecasts overestimated or underestimated claims and feature volume.
● Created Tableau visualizations for more transparent cost reporting to better insights on storm impact on overall profitability and throughput capacity.
● Created a SAS program to normalize feature forecasts for staffing needs over the past decade. Modeled dozens of business changes across multiple products and states in Data Steps and staging tables. Allowing for a dynamic staffing Model to be created based on historical information.
● Built a SAS program that allows us to modify workflow and process changes to understand the impact on Progressive work.
● Responsible for monthly and daily reporting to Sr. Leadership including the CEO Director of Claims Control and Director of Speciality zone relating to Loss Volume and cost figures. Claims Control, Real Estate and Finance Team,
Technical Data Analyst, Progressive Insurance
April 2018 to June 2019
Responsible for monthly allocations and reconciliation of various accounts. Responsible for creating Allocation programs/application solutions for Company activity to ensure that claim cost was properly allocated to various groups based on utilization.
Accomplishments:
● Created several Applications to fully automate our Allocation process for several areas of the Claims organization.
● Automated our real estate report to provide real-time accurate information.
● Created A Tableau Dashboard for real estate information providing details on costs and occupancy. Modeled various occupancy rates based on various job tasks and schedules.
● Created a capacity planning tool that utilized Claims growth with Staffing models to show sites where Projected growth would result in non-ideal capacity.
● Assisted in the New York state HRCA audit response, providing the state of NY with validation that our HRCA payments were correct and integral. Lowered a $6,000,000 bill from the state of New York to $115,000.
● Created a Python Program to handle fuzzy matching. Eliminating any occurrences where human error would prevent the state of New York from receiving a payment.
● Moved Several internal reports from IBM mainframe to SQL server or SAS as the situation demanded.
Specialty Zone, Data Analyst, Progressive Insurance Jan 2017 to April 2018
Responsible for weekly, monthly, and quarterly reports and identifying outliers in data to ensure report and data integrity. Conduct ad-hoc reports for claims senior leadership relating to obscure data sets and underutilized data tables. Generated SAS programming to facilitate monthly and quarterly reporting. Generated tactical programs to service Progressive's Claims department. Accomplishments:
● Generated a Claims Licensing application for a Specialty zone utilizing Access/VBA. IT had come in with a bid of $1,500,000 with a build time of Eighteen months. I completed the Project in 6 months.
● Automated the Specialty Zones recurring reporting to eliminate unnecessary time spent on recurring reporting so they could spend more time pursuing advanced analytics.
● Designed complex reports using multiple data tables and Excel macros to tell a story to senior leadership.
● Became an Excel SME on a team of two data analysts III and one data analyst IV.
● Responsible for yearly expenditure reports relating to our claims cash processing team. Generated the report from top to bottom.
● Facilitated Ad-hoc reports and generated reports for in-house clients.
● Transformed ad-hoc reports into permanent quarterly/monthly reports.
● Utilized my understanding of MVC software design patterns to ensure my applications are updatable and maintainable by non-software developers. Continual Improvement team, Process Consultant, Progressive Insurance January 2016 to January 2017
Responsible for identifying problem defects that impact Progressive customers, consultants, and process efficiency and effectiveness. Conducted a root cause analysis to tell the complete story of the severity, breadth, and scope of the defect. Common Six Sigma quality methodologies and tools such as process mapping, phone call and customer chat audits, review of IT project requests, and fishbone diagrams used. Work with all roles and levels of employees to achieve outcomes that improve or correct defects. Accomplishments:
● Master process and experience mapping skills with Microsoft Visio. Selected by project sponsor to support significant projects regarding Outstanding Customer Balance collection which is worth approximately $11.7 million to Progressive annually.
● Designed Key Performance Indicators for FLV team under Robert Gorka that allowed for more effective management of teams. As well as validation for current management and coaching objectives.
● Identified defects resulting in corrective actions for processes including but not limited to CRM FMLA, Snapshot, and customer service redesign.
● Reviewed process consultant white paper submissions to the Continual Improvement group for validation. Created supporting documentation for high-level communication to affected process owners. CRM Quality, Chat Process improvement, Progressive Insurance October 2013 - January 2016
Worked as an online customer service consultant that would develop procedures to improve customer experience. As a senior consultant, would train new chat members, while helping to create process improvements to achieve optimal customer outcomes
Accomplishments:
● Created process to support online customers who needed named operator policies resulting in an annual savings of $115K and a lift in retention of 8%(several million of soft savings)
● Implemented a process to address customers wishing to cancel their policy. Directed customers to call CPT versus trying to cancel a policy via chat resulting in efficiency gains.
● Valued member of the process improvement team. Involved in multiple improvement opportunities.
● Worked closely with analysts and Process consultants to ensure Chat team would exit pilot phase on time
Customer Preservation Team Consultant, Progressive Insurance October 2012 – October 2013
Goal was to retain customers who called to cancel their policies. Used retention tool kit and communication influence skills to convince customers that it was in their best interest to continue their policy with Progressive when applicable
Accomplishments:
● Achieved Top Performer recognition status by achieving a 42% retention save rate vs. the CPT average of 30%
Sales and Service Customer Consultant, Progressive Insurance March 2008 – October 2012
As a blended Sales and Services consultant worked with customers to welcome them at time of new business and to retain them while members of Progressive. Licensed in all 50 states Accomplishments:
● Achieved Elite 8 in 2009,2010 in servicing metrics at Mentor site
● Subject matter expert on binding restrictions and process changes
● Responsible for morning reconciliation of follow ups for third shift consultants Professional
Skills
● Six Sigma Blue Belt Certified
● Code review lead and Mentor in Claims Control
● Member of the Developmental Council Progressive Insurance
● Member of Pythonic Progressive
● SME in Process Mapping Using Visio and training on Blue works Live
● Excellent at identifying efficiency, effectiveness, expense opportunities
● Strong team player with experience supporting several projects simultaneously
● Understands how to lead a code review
● Academic understanding of Machine Learning
● Attended Process Owner Boot camp
Education Ohio State University
Bachelor of Arts: Political Science
Software Guild
Java Certification
Contact this candidate