This is a sanitized professional case study. No proprietary datasets, confidential business rules, internal screenshots, or production code are published here.
The business problem
SmartWay is the EPA program that helps companies that ship freight measure, compare, and reduce fuel use and pollution. Each year, the fleet's fuel and mileage data had to be collected, validated, and analyzed for the annual submission, and it had to meet strict federal environmental reporting standards.
My role
I handled the data collection, validation, and analysis for the fleet's annual EPA SmartWay submission, which earned the EPA SmartWay Excellence Award.
Data validation & analysis
- Audited complex fuel and mileage datasets to meet strict federal environmental reporting standards.
- Wrote and automated SQL queries against the transportation database to support the submission and ongoing reporting.
- Worked with transportation analysts to verify that the data I brought in, and the way it was presented, was correct.
- Benchmarked sustainability performance and identified areas for fuel and emission reductions.
Streamlining it as emissions reporting grew
As emissions reporting became a higher priority for DHL eCommerce and our parent company, DHL Group (formerly Deutsche Post DHL Group), I optimized and streamlined the process. I worked cross functionally with the Finance analysts who reported emissions to DHL Group.
- Built the ETL pipelines with SSIS and SQL Server, and designed the data models behind the reporting.
- Designed the Power BI report that supported emissions reporting to DHL Group.
- Later transitioned the reporting to Databricks through the Enterprise Data Lake Migration & BI Modernization project.
Impact
The work supported an EPA SmartWay Excellence Award submission, identified opportunities to reduce fuel use and emissions, and streamlined the data and reporting process used for emissions reporting to DHL Group.
What this demonstrates
Data validation against external reporting standards, cross functional work with Finance and transportation analysts, ETL and data model design, Power BI reporting, and carrying a reporting process from SQL Server to Databricks. A related project working with transportation data is Supply Inventory & Cost Visibility Analytics.