Stephen Lloyd Email & Phone Number

Secaucus, Nj, Us

• Analyzed retail fulfillment network using Python/Jupyter Notebook, validating pool strategy and exposing 10% potential cost avoidance• Developed retail pricing and benchmarking model using statistical tools, identifying $3 million in potential savings• Developed gold zone slotting tool with the assistance of ChatGPT, increasing warehouse ergonomic replenishment and picking by 50%• Lead and developed new senior and junior supply chain analysts while overseeing MicroStrategy dashboard creation for distribution operations and retail and e-commerce order fulfillment• Developed and enhanced new retail transportation Snowflake supported MicroStrategy dashboard by including new measurements and visuals resulting in fast error resolution and quick response times to executive level inquiries • Developed warehouse inventory weeks of demand reporting for executive leadership team resulting in the development of new store buying and replenishment tactics and the discontinued use of offsite inventory• Implemented supply chain MicroStrategy dashboard for executive leadership team resulting in the reduction of automated email reporting by 25% and the elimination of daily aggregation processes

Secaucus, Nj, Us

• Managed supply chain analytics team through continuous mentoring and training resulting in successful centralization of development, improvement and distribution of warehouse, transportation, and inventory performance reporting • Designed and developed onboarding program for new hires resulting in efficient and successful integration of junior supply chain analysts • Lead team in the development of warehouse and carrier performance dashboards resulting in the escalation of store fulfillment issues, elevation of EDI failures and the reduction of lost product costs

Secaucus, Nj, Us

• Directed supply chain analysts in the development of carrier performance report resulting in increased understanding of Snowflake, SQL, and VBA as well as greater visibility to the quality of retail carrier network• Trained multiple supply chain analysts to an intermediate level of understanding for analytical tools including Oracle SQL, Visual Basic for Applications, and Microsoft Access and Excel• Designed and implemented automated VBA/SQL reporting to track and forecast delivery for 750 retail locations’ shipments resulting in $120,000 in annual savings

Midvale, Utah, Us

• Developed models and tactics for the consolidation of multiple facilities by analyzing supply chain metrics of multiple business units resulting in the termination of two 3rd party contracts and the reduction of 300,000 sq.ft of warehouse space• Created SQL based aged inventory reporting to determine low inventory turn and low sales volume SKUs resulting in the identification and removal of $10M of dead inventory from Bed Bath & Beyond e-commerce distribution network • Built and administered SQL based reporting to monitor fulfillment times at new 500,000 sq.ft E-commerce fulfillment centers resulting in the exposure of noncompliant replenishment processes• Developed SQL based FedEx right size cubing model for E-commerce fulfillment packaging resulting in freight and indirect material savings of over $10M annually• Scheduled and reported on multiple 500,000 sq.ft distribution centers progress meetings ensuring transparency and communication between Bed Bath groups and sub-contractors resulting in on time project completion at facility start up• Developed and enhanced network wide, E-commerce reporting to produce a more simplified, user friendly dashboard resulting in a 50% reduction of order reconciliation times. • Designed multiple 800,000 sq.ft distribution centers using AutoCAD software by analyzing historic process times, previous labor requirements, and current physical building constraints• Data mined and analyzed historical throughput and inventory data in order to develop an e-commerce fulfillment network model resulting in the effective planning of future distribution centers • Coordinated and organized RFQs with suppliers for numerous multimillion dollar projects in order to guide and expedite upper management’s vendor selections

Irving, Texas, Us

• Spearheaded reconciliation and expansion of returnable packaging program resulting in savings of $120,000 in labor costs and $15,000 in indirect material costs for 20% of inbound material• Designed 50,000 sq ft warehouse space for the development of new inbound logistics node for US manufacturing facilities using AutoCAD software and Access databases resulting in annual savings of $650,000 • Revised and implemented new standard work process for manufacturing and warehousing resulting in a 50% reduction in grief resolution time and a decrease of $80,000 in labor costs annually• Analyzed and executed a re-slotting solution for inbound repack material resulting in a 10% reduction in point of use hits and a decrease of $90,000 in logistics costs annually

Irving, Texas, Us

• Exposed $100M savings for integrated logistics manufacturing supply chain by analyzing delivery performance, supplier network, total personnel, and lead time metrics using a TCO model • Created an interactive map of $20B global parts network using Tableau to find inefficiencies in distribution and advised upper management on strategic improvements within the supplier-buyer interface including consolidating demand, sourcing in zone, and developing new suppliers• Data mined engineering prints to validate facility submitted PFEPs and part dimensions in order to concept assembly line parts in 3rd party integrated logistics distribution center, resulting in cost savings of greater than $100,000• Analyzed process inefficiencies at 3rd party global forwarding facility and provided solutions including process change, floor map redesign, and system reconfiguration resulting in monthly savings of $2M

Irving, Texas, Us

• Managed 25 union employees at Caterpillar Worldwide Distribution Center’s 800,000ft2 Yard that fulfilled orders for over 50 different customer routes at an on-time rate of greater than 99% and an overtime rate of less than 10.6% • Coached diverse team of individuals on standard work and conflict resolution resulting in a decrease in dealer claims rate by 33% and an increase in engagement by 133%• Advised a cross functional team of supervisors, operation managers, and six sigma black belts on improvement opportunities in the Bin Denial Process Six Sigma project resulting in recovered revenue of $400,000 • Coordinated and determined data collection for track type tractor coils and made-to-order production parts for Six Sigma project aimed at reducing fill times, resulting in an increase of output by 50% and a decrease in annual spend of $10,000

Irving, Texas, Us

• Designed and developed an Excel based internal supplier performance tool that tracks and records multiple short and long term metrics for over 80 Caterpillar suppliers with the goal of improving global supplier quality• Developed flow charts of part rejection, disposition, root cause, and corrective action processes using Six Sigma and process mapping tools with the goal of supporting improved visibility across the quality supply chain• Implemented and performed improved weekly and monthly Caterpillar supplier performance reports by reviewing current Access database tools and presentation deliverables improving supplier-buyer relations

Norwalk, Connecticut, Us

• Supervised technical support team on company-wide multimillion dollar commercialization of 24 new and reformulated bakery products resulting in a 50% increase of bread shelf life and supermarket exposure• Analyzed technical data from oven profiling tools to assess the manufacturing capability of bakery production equipment increasing 1st product production and decreasing thrift product production by 33% • Led quality assurance team tasked with analyzing 30 product textures to validate 100 consumer complaints on stiff and soggy bread and cookies over 21 day and 6 month shelf life respectively• Supported bakery HACCP document review team by developing and implementing new pertinent manufacturing process control documents based off bakery production critical control points • Coordinated test product sample distribution to improve collaboration between manufacturing line operators and corporate personnel allowing corporate and plant teams to better analyze issues related to product defects

• Assisted in the estimation of costs for power, lighting, and fire alarm systems for current and future government contract projects providing opportunities for faster submission of bidding applications• Supported the receiving and distribution of raw materials and overall up keep of the company warehouse expediting project completion and eliminating part related project delays• Evaluated and reported construction job progress to estimator, construction manager and company president allowing both job client, contractor and other sub contractors to better assess project progress• Planned and reorganized filing systems of past contracts allowing for faster rough estimates for future government contracts

Master Of Business Administration (Mba), Logistics, Materials, And Supply Chain Management

Bachelor Of Science, Civil Engineering