Fail Code Savings Analysis Preview
North American On-Highway Marketing Intern | Cummins Inc.
PROJECT OVERVIEW
Analyzed over 10,000 engine fail code claims from a top Cummins client to identify missed cost-saving opportunities under Cummins’ extended coverage plan. The goal was to quantify potential savings and build a compelling financial case for the client to invest in expanded coverage moving forward.
*Browse through a preview of the guide below
PROCESS
Click each of the tabs below to explore each step of my process towards completing this project.
1. Data Standardization
-
Received a dataset of 10,000+ fail code entries spanning over a year
-
Cleaned and standardized inputs to align with Cummins’ coverage documentation
OUTCOME
-
Delivered a breakdown comparing fail code costs covered by Cummins vs. EPA and CARB regulations
-
Identified thousands in missed savings that would have been covered under Cummins’ extended plan
-
Created a clear, data-backed savings summary used to support client discussions
-
Helped influence the client’s decision to adopt the extended Cummins coverage plan
SKILLS
-
Data Cleaning & Large-Scale Analysis – Worked with complex, high-volume datasets to extract meaningful financial insights
-
Excel Automation & Logic Writing – Used formulas to streamline fail code-to-coverage matching
-
Cost-Benefit Analysis – Translated technical data into tangible business value