Quentin Duncan
Ericeira
Summary
Logistics and Data Analytics Professional who recently moved to Ericeira, Portugal with a valid residence visa.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Senior Logistics Data Analyst
HD Supply
05.2024 - 04.2025
- Supports domestic transportation department with ad-hoc, daily, weekly and monthly reporting using Excel, Mercury Gate TMS, Snowflake, and Tableau
- Support Channel Management, Inventory Planning & Procurement decisions by performing lane and volume analysis using Snowflake, MercuryGate TMS and Excel
- Perform cost-out analysis by aggregating lane data to minimize number of trucks for annual RFP
- Responsible for managing monthly truckload market data into Snowflake tables and providing monthly analysis for Procurement truckload data
- Migrated existing carrier operational performance PowerBI dashboard into Tableau
- Collaborated with operations and finance to create a Tableau dashboard showcasing a daily trailer count and resulting detention costs for each of our major facilities, resulting in 20% improvement in yard fluidity
- Utilizes Snowflake SQL and Excel for ad-hoc reporting and data management for cross-functional partners and executive leadership, including, but not limited to, importing monthly DAT rates into a Snowflake table
- Created process roadmaps with cross functional partners to improve existing field operations, reporting, and truck pricing processes
Logistics Analyst
Yamaha Motor Corporation USA
09.2023 - 05.2024
- Report and present individual transportation carrier KPI's - billing issues, freight claims, on-time deliveries, missed appointments, etc. using SAP Business Objects, SAP ERP and MS Excel
- Assist transportation supervisor and manager with annual carrier RFP/Procurement process including, but not limited to data gathering and analysis (using SAP BO, MS Excel and PowerBI), negotiations, lane awards, and final recommendations to leadership
- Creates dashboards using PowerBI showcasing trends in volume by product category, and side-by-side comparisons for carrier bid award analysis
- Created PowerBI dashboard to compare dedicated carrier rate submissions and made recommendations based on cost benefit analysis
- Works cross-functionally with IT for any systematic issues in SAP Business Objects reporting (freight payments, rate tables, data integrity, etc.)
- Works on ad-hoc projects as needed for the entire Yamaha Logistics division (financial, operational, warehousing, transportation)
- Utilizes SAP and Excel to audit and ensure timely payment of freight invoices to carriers
Senior Logistics Analyst
The Home Depot
07.2018 - 08.2023
- Responsible for ensuring the efficient and effective movement of inbound, outbound and transload freight for the across all modes (drayage, full truckload, intermodal, LTL, and parcel)
- Partners cross-functionally to strategically deliver event and seasonal import containers within the distribution network, resulting in 99% in-stock
- Develops reporting to hold container management company and carriers accountable to expected service levels
- Utilize Google BigQuery for ad-hoc requests from DCs and internal business partners to improve visibility
- Implement strategies with field leadership, internal partners and 3rd party container management companies to reduce port expense and improve DC operational flow
- Led improvement projects with carriers delivering a 5% increase in carrier on-time pickup
- Managed ~700 vendor shipping origins and ~4,000 shipments per week holding carriers/vendors accountable for timely loading, pickup, EDI submission and delivery
- Collaboration both internally and externally and with port terminals, container management companies, carriers, and DCs to ensure capacity and forecasting is aligned
- Created a Tableau dashboard to showcase bobtail expenses accrued by each DC by fiscal week
Logistics Coordinator
Hapag-Lloyd AG
02.2018 - 06.2018
- Managed import and export shipments associated with the Port of Charleston
- Supported transportation moves in the most cost-effective manner possible
- Provided cargo tracking through final delivery to ensure service expectations are met
- Led cost saving opportunities by balancing one-way transport costs against trucker and equipment accessibility
Intermodal Fleet Manager
J.B. Hunt Transport
01.2017 - 02.2018
- Responsible for maximizing driver efficiency and productivity by identifying and planning loads designed to fill underutilized driver segments
- Managed 30+ company drivers
- Supported transportation operations by utilizing the company's in-house transportation management system to assign loads and analyze freight movement
- Led administrative functions to include scheduling, routing, payroll, driver counseling, and accident reviews
Education
Bachelor of Business Administration - Logistics and Intermodal Transportation
Georgia Southern University
Statesboro, GA12.2016
Skills
- Transportation operations
- Data Analysis
- Google BigQuery
- Microsoft Excel
- Microsoft Power BI
- Procurement
- Request for Proposal (RFP)
- SAP
- SAP Business Objects
- SAP ERP
- Snowflake
- SQL
- Tableau
- Process Improvement
- Freight Auditing
- Transportation Management Systems
- 3rd Party Logistics (3PL)
- Logistics
- Transportation Management
- Project management
- Data warehousing
- Microsoft Access
- Process mapping
Accomplishments
- Increased On-Time Pickup: Improved carrier on-time pickup to 93.8% using Tableau.
- Enhanced Yard Fluidity: Achieved 20% improvement in yard fluidity with new dashboard.
- Decreased Port Expenses: Reduced port expenses by 15% with strategic planning.
- Boosted Carrier Performance: Contributed to a 5% carrier performance improvement.
Certification
- Hands-On Essentials: Data Warehousing Workshop
- Snowflake - Issued May 2024
Timeline
Senior Logistics Data Analyst
HD Supply
05.2024 - 04.2025
Logistics Analyst
Yamaha Motor Corporation USA
09.2023 - 05.2024
Senior Logistics Analyst
The Home Depot
07.2018 - 08.2023
Logistics Coordinator
Hapag-Lloyd AG
02.2018 - 06.2018
Intermodal Fleet Manager
J.B. Hunt Transport
01.2017 - 02.2018
Bachelor of Business Administration - Logistics and Intermodal Transportation
Georgia Southern University