top of page

Professional Projects

  • Prepaid Toll Management - Implemented PrePass tolls/bypass into a Fleet of 450 units, setup internal process to monitor offenders with weekly reporting, integrated unit expense into profitability statements

  • Power BI Implementation - Introduced Power BI to a company with a high acceptance rate. Implemented various Operational, Sales, Recruiting and Accounting specific dashboards and reports

  • Quarterly Customer Profitability - Defined, and established a process to report net income per customer using activity-based costing and proper assumptions where necessary

  • Data Warehouse Implementation - Managed and Administered the implementation of a Data Warehouse using HelpSystem's Data Warehouse tool. Actively developed new ETL's and solutions with the tool daily

  • Lane Rating Tool - Developed an in-house lane rating tool to better help Sales with large rating schedules (100+ lanes)

  • Driver Pay Calculator - Redeployed a starting pay calculator utilizing Microsoft's Power Apps platform

  • Quarterly Safety Bonus Calculation - Developed a means of calculating a safety bonus for driving professional if they qualified given a multitude of criteria such as CSA scores, accidents/incidents, training assignments completion, HOS compliance etc...

  •  Daily Revenue Reporting - Distribute daily reporting for month to date tracking by revenue type

  • Forecasting Fiscal Revenue and Expense - Contribute annually to the forecasting of the company's budget

  • Weekly Company Scorecard - Developed a weekly scorecard for the company to track and monitor performance in multiple departments

  • Power BI Administration and Implementation - Introduced Power BI to the transportation department of a second company with a high acceptance rate. Managed all aspects of the Analytics initiative: report conceptualization and creation, maintenance and distribution.

  • Trailer Demurrage Tracking - Developed an on demand Trailer storage dashboard within Power BI utilizing multiple stage tables which held temporary trailer positions to then be stored in a historical table for tracking. In conjunction with a PowerApp for Operational users to comment and confirm the storage was taking place.

bottom of page