Nicholas Smith Email & Phone Number

Louisville, Ky, Us

• Oversee the creation and ownership of a greenfield enterprise reporting data solution inclusive of a dozen Würth Industry of North America (WINA) Operating Companies totaling $700 MM revenue across three countries• Act as lead data engineer collecting, normalizing, and storing 2 TB of data from disparate ERP platforms (SAP, Prophet 21, INxSQL) into a standard data layer using Python and SQL• Manage CI/CD DevOps and Scrum processes using Git repositories, Jenkins pipelines, and Asana• Lead a remote team of 3 consisting of analysts and a solutions architect to develop, enhance, and maintain both our BI (business intelligence) solution and our BI M365 SharePoint site• Partner with business stakeholders to identify, prioritize, and provide business insights with an emphasis on profitability• Recommend changes to processes and applications of data to improve productivity and profitability of Operating Companies by leveraging SSRS reports and PowerBI dashboards distributed on our PowerBI Report Server• Coordinated $710 M in realized savings from strategic sourcing initiative across 4 Operating Companies• Streamlined $300 M in validated, annual tariff billings to be passed on to customers• Provided discovery dashboard that identified $3 MM in future inventory reserve 3 months in advance

Louisville, Kentucky

• Managed and led a very successful transition to SAP for the Purchasing department• Compiled master data as well as supported and validated item mappings for 33,000 items• Created, coordinated, and led end user training as a key user• Managed a team of 3-5 individuals responsible for executing the MRP • Responsible for analyzing and maintaining the MRP for a $58 MM distributor• Exceeded the monthly 98% service degree goal just three months onto SAP• Rebalanced team responsibilities while operating at a -25% reduced head count a month onto SAP• Developed and maintained a business intelligence website once on SAP using SSIS, SQL, and SSRS• Created and utilize KPI’s for validating the MRP, managing workloads and productivity, and to drive exception-based actions

Louisville, Kentucky

• Responsible for maintaining the inventory planning and buying process for a $58 MM distributor• Converted from a min/max planning process to a scalable, system calculated and parameter driven process• Developed and maintained the new planning process using SSIS and SQL• Created and led end user training on the planning parameters and buying process• Reduced on hand inventories $3 MM (16%) by properly aligning the planning process and strengthening the decision making amongst the team• Department lead and roundtable member of the SAP transition team• Led the process mapping and end user training within our department

Louisville, Kentucky

• Maintained inventory strategies and forecasts for a $100 MM, 125,000 SKU, multi-echelon distributor• Developed SQL and SSIS planning and forecasting solution to eliminate a 3rd party planning solution (Clever by TCLogic) and best utilize our current ERP system (Prophet 21 by Epicor) • Raised monthly service degree by over 2% in four months• Identified customer provided forecast variances from sales history for 3,500 SKU’s• Led project, managing 15 branch managers, that reduced branch on hand inventory by over 10%• Led major customer implementation recovery across sales, purchasing, quality departments that resulted in the customer asking us to supply additional business 2 months later• Coordinated and tracked daily buyer and planner purchasing activities• Established vendor stock and release programs for $750,000 of annual spend and developed the standard operating procedures to be followed for further utilization of this type of program • Defined material management requirements and discrepancies transitioning to SAP as a SAP super-user

Louisville, Kentucky

• Led collaboration between 5 Würth Industry of North America (WINA) companies and the central distribution center (CDC) as a part of a strategic sourcing initiative• Identified qualified SKU’s to be stocked in the CDC• Coordinated usage data validation, performed vendor total cost analysis, and drove the re-sourcing execution at the CDC and each WINA company for $2 MM• Approved CDC purchase orders as part of excess inventory prevention• Identified lowest cost vendors across WINA for each SKU• Managed optimal package quantity data collection across the WINA companies and was the administrator for the package quantity database• Responsible for calculating and distributing purchase price performance for each WINA company

Indianapolis, Indiana

• Led technical and strategic customer support for all production models totaling $450 MM in inventory• Managed support and implementation issues in FogBugz case management system • Created implementation plans based on the customer’s business, procurement process, and deliverables • Developed ETL integration for new implementations using DTS and SSIS packages • Created and configured business rules to develop stocking strategies on $250 MM in total inventory across automotive, electrical, HVAC, medical, metal, glove, fastener, and furniture industries• Performed our BIDS analysis for prospective customers• Assisted the development of Clever’s database schema and user interface• Integrated customer forecasts with Clever’s MRP process• Designed and created custom analyses to enhance end user processes and drive exception-based actions• Custom designed inventory reserve analysis with CFO for intelligence on financial reporting

• Identified and consolidated duplicate SKU’s both plant and network wide• Organized plant visits and composed review documents from a suggested duplicates master report• Updated item maintenance in Oracle and relabeled bin locations for the discontinued SKU’s • Provided supersession reports to the Supply Chain department as well as the storeroom managers

Bs, Industrial Engineering

Education record