Paul Draper

Intern, Logistics Data Analyst @Mansfield Energy Corp

Denver, CO, US

Operational Efficiency Analysis: Conducted a data-driven review of scheduled DEF deliveries, analyzing over records in Excel to optimize frequency and quantities, reducing unnecessary deliveries and cutting costs. Dashboard Development & Data Visualization: Designed and built interactive Power BI dashboards to track and analyze the performance of milk runs, leading to improved pricing strategies and increased profitability. Advanced Excel & Power BI: Utilized Excel for data cleaning and reporting, including the use of complex, advanced functions. Developed Power BI reports using DAX to create custom metrics and improve decision-making. Business Intelligence & Strategy: Created a geo-mapping tool in Power BI to identify opportunities for new milk runs, supporting business development and enhancing supply chain efficiency. Stakeholder Engagement & Communication: Led meetings, gathered business requirements, and presented findings to executives, improving business intelligence processes and data-driven decision-making.