Operations Specialist
CurrentResponsible for a variety of projects related to the daily operations of Caron Transport including creating Power Bi reports, excel model construction for a variety of operational problems, and inventory management.I spearheaded the business analytics and reporting across departments using a combination of PowerBi and Excel. The dashboards and analysis I provided are used by Caron executives to make data-backed decisions across safety, finance, and operations departments. When creating the PowerBi dashboards, I prioritized data pipeline efficiency so that users who are unfamiliar with the data sources and PowerBi functionality could easily access real-time analyses.I also built a variety of Excel-based computer models for multiple business functions, from fuel reporting to cost of revenue analyses. The models aim to automate and standardize important operational investigations. The models I built pull data in automatically from the ERP system, clean it, and then sort it so that the user can streamline their workflows. I created an inventory management system for all the parts associated with installing heavy-duty truck dash cameras. This model creates a log of the inventory position for 15+ unique parts based on the current inventory and parts in shipment. The system ensures that Caron has enough inventory to satisfy their demand based on new truck deliveries and current truck camera failures, all while minimizing the waste associated with holding inventory.