Drew Clardy Email & Phone Number

Dallas, TX, US

Dallas, Texas, US

Irving, Texas, US

• Revitalized the SIOP process and led the organization through expanding lead times and record setting sales. Implemented scenario planning and allowed the Executive team to choose the inventory investment to meet sales.
• Developed statistical safety stock models that accounted for demand and supply variability along with the two-echelon network that was implemented. Redefined the service level targets for each material segment and.
• Redesigned the two-echelon network model to account for capacity and shipping constraints. Labor, trucking, and additional inventory investment were included in the analysis to give a clear view of the financial impact.
• Led the development and design of a container building model in Python. Model saves hours of work for multiple buyers reducing the time for purchase order creation. Additional time allows buying team to move towards.

Irving, Texas, US

• Owned the monthly forecasting process for all items and order types totaling $1.42 billion in sales across 34 locations and multiple customer groups.
• Using Facebook’s Open Source Prophet R module, Alteryx, and SAP HANA, designed and implemented a new forecasting engine replacing SAP APO. Improved accuracy allowed for a reduction in inventory of $15M in the network.
• Collaborated with cross-functional departments to develop a singular consensus forecast for Supply Planning and Financial Planning using the Demand Planning forecast as the base for projections and reporting.
• Using Alteryx and Tableau, developed an Open Sales Order dashboard to discover and identify issues with shipping and picking capacity at the distribution locations allowing the Operations teams to proactively correct.
• Prime Star award winner in 2020 - Employee recognition award from Executive team to top employees in company

Irving, Texas, US

• Executed Pricing Actions that drove $12M in additional profit for the company helping reach record margin performance.
• Designed and built company-wide Price Books, using Alteryx and Tableau, to provide the sales team with the latest pricing, inventory, and sales information while visiting customers.
• Designed and implemented, using Alteryx, Excel, and SQL, the pricing submission process reducing the time spent processing information by 20 hours per week. Redundant communications to the sales team were eliminated.
• Designed and directed the SAP technical team to build custom reports that allowed the sales operations team to handle EDI errors more effectively allowing our team to drive more results through analytics and data.
• Orchestrated the setup and configuration of Alteryx and Tableau Server in the organization.

Calhoun, Georgia, US

• Designed and built a product mix model that quickly showed units, gross revenue, gross margins, and standard margins at the item level using SQL, VBA, and Excel, which allowed the company to optimize production costs.
• Implemented a product tracking system in Access with custom VBA functions and a SQL database back-end so that all parties were immediately notified of changes to future product designs and manufacturing needs through.
• Led the product optimization process to reduce the number of actively stocked products allowing inventory dollars to be moved into faster selling items increasing service and company revenue.

Calhoun, Georgia, US

• Owned the monthly operational forecasting process for 13,000 actively stocked items totaling $2.12 billion in annual gross revenue for four Strategic Business Units.
• Facilitated S&OP demand consensus between the Executive, Sales, Marketing, Finance, and Planning Teams helping to drive revenue and margin growth in all product teams.
• Managed the long-term strategic planning and annual operational plan process for all products teams and Strategic Business Units.

Calhoun, Georgia, US

Calhoun, Georgia, US

Calhoun, Georgia, US

Calhoun, Georgia, US