Marguerite Ravensworth-Ofori

Built a weekly SKU-level demand forecast in SQL and Power Query for 3 retail clients (14,000+ SKUs), improving forecast accuracy from 71% to 86% and cutting safety stock by $620K Designed carrier scorecards in Power BI tracking on-time pickup, tender acceptance and claims for 22 LTL/TL carriers, shifting 18% of volume to top performers and saving $240K annually Automated 9 daily inventory and order-cycle reports with SQL and Python, freeing 12 analyst hours per week and reducing reporting errors by 90% Ran ABC velocity slotting analysis in Manhattan WMS for a 600,000 sq ft DC, re-slotting 2,300 locations and lowering average pick travel by 17% Reconciled SAP S/4HANA and WMS inventory variances during monthly cycle counts, raising record accuracy from 97.2% to 99.4% Partnered with transportation team on a freight-consolidation model that reduced partial shipments by 21% and saved $170K in annual freight spend

Analyzed 18 months of air cargo booking data to build a volume-by-lane model, helping planners rebalance ULD capacity on 6 peak routes Created an Excel/Power Query dashboard for ramp dwell time, identifying bottlenecks that cut average cargo dwell by 2.5 hours Audited 4,000+ freight invoices against contracted rates, recovering $38K in billing discrepancies Presented a capstone recommendation on cold-chain pharma handling to the VP of Operations, later adopted for 2 pilot lanes

Picked, packed and staged 250+ orders per shift with RF scanners at 99.8% accuracy while carrying a full course load Trained 6 new seasonal associates on receiving, putaway and safety procedures during peak season Suggested a returns-staging layout change that reduced returns processing time by 15%

GPA 3.7/4.0; Dean's List 6 semesters Relevant coursework: Demand Planning & Forecasting, Logistics & Transportation Management, Operations Analytics, Procurement, Database Management (SQL), Business Statistics Capstone: network optimization model for a Memphis 3PL that identified $1.2M in potential lane savings Member, APICS/ASCM Student Chapter and Council of Supply Chain Management Professionals (CSCMP)