Supply Chain Project Manager

YUFENG YAO

Atlanta, Georgia; Mobile: 470-***-****; Email: ******.***@*****.***

SUMMARY OF QUALIFICATIONS

• Results-driven project manager with focus on business performance, cost reduction, customer experience and project success. Established ability to investigate and resolve highly complex problems with cross functional team collaboration.

• Strong technical background with proven ability to generate valuable decision-making business insights and recommendations. Skills include project management, advanced analytics techniques (optimization, data visualization, statistical analysis, and simulation), and financial analysis. PhD in Industrial Engineering at Georgia Institute of Technology.

• Over 18 years of Supply Chain expertise, in the areas of inventory management, forward and reverse logistics, warehousing, transportation, metric design and implementation.

• Effective communicator working with stakeholders and adept at translating complex data into actionable strategies for executive leadership to implement solutions.

• Advanced experience with MS office (e.g. Excel Solver), Tableau, Power BI, JMP, SQL, Visio, Snowflake, Simulation tools, IBM OPL, Asana, PC Miler, Java, VBA.

PROFESSIONAL EXPERIENCE

AT&T: Senior Business Solution Architect 8/2020 – Present

Project Management & Supply Chain Operations

Spearheaded end-to-end project lifecycle—from identifying root business pain points and translating requirements into user stories, to overseeing development, driving UAT, and executing enterprise-level rollouts—consistently delivering projects on time and within scope.

Directed cross-functional launches of new products, aligning planning, warehousing, transportation, asset tracking, and reverse logistics for seamless supply chain integration.

Championed onboarding new warehouses and 3PLs, acted as SME to align systems (Blue Yonder, OMS, OTM, WMS), scaling operations and boosting distribution center efficiency.

Improved fulfillment efficiency by 13% through implementation of system enhancements such as order volume caps, cutoff times, and refined ship date logic, reducing bottlenecks and increasing SLA compliance.

Led delivery network resilience by integrating regional carriers, reducing reliance on national carriers during peak season.

Strategy & Program management (Data Insight)

Validated cost model in Snowflake to expose financial underperformance at wire centers, influencing strategic P&L decisions with SQL and Power BI.

Designed a technician-level stock optimization model based on statistical analysis for core CPE, reducing truck rollbacks and cutting working capital by $0.7M, while delivering $2M in annual savings; developed a scalable rollout roadmap for enterprise-wide deployment.

Mentored and led interns in developing a backorder redirect tool, improving inventory responsiveness and operational efficiency.

AT&T: Senior Business Management 2/2019 – 8/2020

Crisis Response & Risk Mitigation

Led enterprise-wide COVID response operations across AT&T, DTV, and Warner Brothers, ensuring timely PPE distribution to 120K+ employees through coordinated inbound planning, product setup, and optimized storage allocation under capacity constraints.

Tailored and implemented a national technician inventory and safety stock strategy in response to COVID-related garage closures, optimizing van stock levels and mitigating SLA risks to ensure uninterrupted service under constrained operating conditions.

Logistics & Cost Optimization

Drove the initiative to audit and correct the carrier matrix setup, aligning shipping logic with SLA demands and unlocking $1.5M in transportation savings.

Developed a proxy rate shopping engine leveraging zone, weight, SLA, and surcharge data to optimize carrier selection, improving shipping logic and generating $3.2M in annual transportation savings.

AT&T: Professional Business Management 04/2014 – 2/2019

Network Optimization & Supply Chain Planning

Developed an optimized DC volume planning model at the ZIP Code level using Excel Solver, reducing shipping and handling costs by $1.3M annually for Direct Fulfillment channels, while supporting supplier negotiations and inventory ramp-up strategies

Created operational guidelines for primary DC ramp-up and contingency planning, including fallback DC logic to redirect orders to alternative DCs during stockouts, improving service continuity.

Innovated and implemented warehouse slotting strategies using Microsoft Access and OPL (Optimization Programming Language), factoring in product velocity, dimensions, weight, grouping, and conveyor types to optimize picking speed, accuracy, and storage capacity—boosting productivity by 12% and reducing pick errors.

Loss Prevention & Process Automation

Drove in-depth investigations across multiple databases including 3PL’s scan data, identifying Loss-In-Transit hotspots with Tableau and launching pilots (e.g. white glove or handshake) that reduced losses by 16%.

Created a real-time loss alert system to accelerate case resolution and improve carrier accountability, increasing over goods recovery and visibility.

Advanced Modeling for Peak Efficiency

Constructed a mathematical model to smooth out the workload by arranging different shipping schedules to the stores, smoothing DC workloads and reducing carryover volume.

Devised product forecasting and allocation optimization models with OPL and Java for retail stores, overcoming inventory and shipping constraints to significantly boost DC throughput during peak periods and major product launches.

Conducted statistical analyses of sales patterns and transportation lead times to optimize JDA parameter settings and store replenishment calendar, minimizing daily volume variance by strategically assigning order drop days across DC-mapped stores.

AT&T/Bellsouth: Lead Logistics Analyst 02/2007 – 04/2014

Inventory & Capital Optimization

Developed simulation models to optimize technician truck stock, reducing working capital by 12% while maintaining service targets and operational reliability.

Engineered an inventory optimization tool to set min/max replenishment levels for retail stores, driving an 18% inventory reduction, 15% sales increase, and sustaining 98% SLA—achieving lean operations without sacrificing service quality.

Designed and implemented simulation models using queuing theory to optimize staffing levels at device support centers, achieving peak operational efficiency and unlocking $5.8M in projected annual savings across national operations.

Transportation & Reverse Logistics Innovation

Delivered $3.6M in savings by optimizing last-mile delivery routing, reducing fuel consumption, and streamlining workforce allocation.

Guided reverse logistics strategies that reduced obsolescence and improved recovery rates through optimal refurbish center placements.

Operational Forecasting & Budget Planning

Led enterprise resource and budget forecasting across logistics operations, creating tools that informed strategic planning for fleet, maintenance, and reverse logistics networks.

CitationAir: Consulting Researcher 05/2002 – 12/2006

–Built optimization models using Java and CPLEX to solve complex flight and crew scheduling challenges, including time-window constraints—enhancing operational efficiency, improving resource utilization, and delivering scenario-based analyses for real-world decision-making.

EDUCATION

Ph.D. Industrial Engineering, Georgia Tech, Atlanta, Georgia, 05/2007.

HONORS AND AWARDS

AT&T Individual Award. every year 2018 – 2024

AT&T You Rock Award. 2016, 2017

Six Sigma Green Belt. 2012

AT&T STAR Award. 2010, 2013, 2014

CitationShares Scholarship 2002 – 2006.

Contact this candidate