Dan Coffman

Experience

• 

  UTi Worldwide

  Feb 2007 - Feb 2015

  • Created metrics to trend mode mix, average load weight, and cost per hundred weight to determine client’s transportation budget.• Designed carrier scorecard to benchmark performance. First time client had means to leverage transportation spend.• Assisted in streamlining carrier pricing entry. New process slashes overall load time by 90%.• $540,000 in cost savings identified in 2013 by analyzing lowest cost carrier optimization, weekly consolidation, intermodal vs truckload, and pool point opportunities.• $2,000,000 in overall savings since 2012 implementation. Show less • Negotiated carrier contract rates for Less-Than-Truckload, Truckload and Intermodal. Averaged 3-4% in cost savings/cost avoidance.• Normalized carrier fuel and accessorial by mode for better rate comparison.• Reassessed client’s commodity value, which reduced carrier liability per pound, resulting in lower carrier rates.• Successfully conducted Less-Than-Truckload and Truckload RFQs. Net savings $50,000 LTL; $160,000 TL.• Mitigated risk to client and employer by auditing carrier contract folders and identifying the missing documents for contract. Show less

  • Support Supervisor

    Jul 2014 - Feb 2015

  • Logistics Analyst

    Apr 2012 - Jul 2014

  • Contract Administrator

    Dec 2007 - Apr 2012

  • Freight Payment Specialist

    Feb 2007 - Dec 2007
• 

  Create and Craft USA

  Mar 2015 - Oct 2016

  Logistics Liaison Manager

  • Demonstrates good judgement to distinguish sellable vs non-sellable stock when processing customer returns.• Successfully coordinates six month stock audits between 3rd party warehouse and inventory auditors. 1.2 % stock value discrepancy between actual count and expected count; exceeding the 2% goal.• Utilize strong working rapport with 3rd party warehouse to achieve 95% goal of all picked, packed and shipped orders within a 48 hour window of receipt.• Applies root cause analysis to customer order issues to improve overall buying experience and maximize customer retention.• Identifies end of life cycle stock and assists buying team in planned obsolescence strategies to maintain a manageable and profitable stock volume. Show less

• 

  R+L Global Logistics

  Dec 2016 - Jul 2021

  • Develop SQL reporting procedures to automate data extraction from transportation management systems. Distribution methods include scheduled emails via CSV open row sets or ODBC connections. • Create and maintain SQL views to provide data sets for dashboard presentations in Power BI.• Support KPI reporting requests for other business departments such as finance, pricing or operations group. Utilize Spiceworks ticketing system.• Monitor nightly SQL job processes to ensure accurate data refresh.• Apply SQL Server Integration Services packages for enterprise-level data solutions. Show less • Compile historical freight moves in the McLeod database to competitively price over the road truckload bids. $500K in new truckload brokerage revenue for YtD 2017.• Review new client opportunities for over the road, intermodal and dedicated truckload services to provide and implement cost-saving solutions.• Customer contract review analysis to ensure organization is protected from potential loss of revenue.• Monitor customer account assignments in McLeod to maintain transparency and data integrity.• Utilize Truckstops optimization software to identify cost savings and efficiency gains for current and potential new customers. Show less

  • SQL Developer

    Mar 2019 - Jul 2021

  • Logistics Business Analyst

    Dec 2016 - Jul 2021
• 

  Scotlynn

  Jul 2021 - now

  Senior Developer