• Designed the companies S&OP model which blended statistical forecasting techniques with client inputs to create a forecast which consistently achieved less than 5% MAPE in top-line network revenue. • Developed dashboards in SQL and Python for the senior leadership team automating reporting of key metrics (Inventory Accuracy, Forecast Error, SLA Performance, and Transportation Revenue).• Built a labor planning tool using a linear optimization to forecast staffing requirements across the network. Resulted in a throughput percent to plan improvement of 29% from Q4 ’23 to Q1 ’24. • Automated ingestion of data from Google Sheets to Databricks using the Sheets API. Resulted in savings of 5 hours of labor per week.•Owned key supply chain metrics (Throughput Percent to Plan, Inventory Turns, Fulfillment Revenue, and Capacity Utilization) and presented results to the leadership team in weekly and monthly business review decks.• Automated reporting of billed hours which provided visibility into reported vs. punched hours variances. Enabled the team to recover over $100k by disputing invoices from staffing agencies.• Ad-hoc reporting and analysis.

• Led the supply chain planning effort and S&OP process, building all tools, models, and processes from scratch. Responsible for ensuring we had the parts on hand to build to our forecast, system allocation, and monitoring cash flow to ensure AP was synced with revenue generation.• Organized and led ERP training for contract buyers to ramp up a new tier 1 contract manufacturer.• Key team member in ERP implementation.• Built data visualization tools in Excel and Python to track KPI’s (On Time Production, On Time Shipments, and On Time Installations) and presented them to the leadership team during weekly S&OP meetings.• Oversaw a liabilities reduction project which identified over $1M in outstanding purchase orders which could be cancelled to extend the companies runway.• Managed a Buyer on all production related procurement activities with an annual spend over $5M.

• Production Planner for 3 brands across 5 product categories.• Purchasing for sourced product categories with annual spend over $2M.• Eliminated over $590,000 in raw material inventory variances by leading a year-long BOM transformation project to correct material and usage rate errors.• Slashed inventory receiving and purchase order creation times by 2.5 hours per day using Visual Basic (VBA) macros.• Build and maintain forecasts for all product categories.• Perform historical sales and open order analysis used to generate forecasts.• Negotiate payment terms with vendors and ensure timely payments by providing an accurate cash requirements forecast to the CFO.• Data analysis and reporting automation in Python.

•Collaborated with cross-functional teams to develop proposals forpost production support of the P-8 aircraft.•Automated manual data entry and metrics tracking using VBA macros,weekly resource savings of 7 hours.•Communicated part number changes to asset management teams.

•Worked in a cross-functional team to streamline inter-department document flow by designing a SharePoint website that automated the purchase order creation and approval process using workflows and InfoPath forms. The result was an elimination of an estimated 100+ emails per day. •Learned/functioned as a full-time product planner, executing purchase orders and making transportation decisions involving factories over seas. •Improved efficiency of other planners by reorganizing and removing unnecessary documents from the shared purchasing drive. •Worked to eliminate fraud by cross-referencing invoices against their corresponding purchase orders and forwarding checked invoices to accounts payable.

•Maintained a 50% profit margin by communicating with vendors to find the lowest possible prices on parts for customer orders, then pricing the parts according to Fastenal’s pricing model. •Solved problems by effectively communicating with coworkers and vendors to utilize all of the resources at my disposal to satisfy my customers needs.•Reduced order selection time by an estimated 15 minutes per day by organizing inventory into sections which housed parts that were frequently purchased together in close proximity.•Reduced lead times on customer orders up to a week by sourcing products from vendors and distribution centers in close proximity to the customer.

•Increased sales by actively engaging customers and directing them to the products that met their needs.•Learned to work efficiently as a team to reduce customer-waiting time during high-volume hours. Surveyed inventory for accurate replenishment orders.

•Received and priced new inventory and evaluated stock of existing for replenishment orders.•Directly increased sales by providing expertise on various product as well as exceptional customer service.•Utilized Retail Pro 8 to track customer information at the point of sale.