William Duff Email & Phone Number

Buffalo, Ny

I analyze differences in actual vs. standard labor and machine hours to aid in prioritizing equipment maintenance and cost-saving plans. I compute yearly labor and overhead rates for resources to support cost management and profit enhancement efforts. I collaborate with the FP&A Director and business unit general manager to create budgets and quarterly forecasts. I evaluate monthly financial results with the business unit manager, examining budget, forecast, and previous year discrepancies. I analyze revenue based on price, volume, and mix through Power BI tools.• Generated 20 Power BI reports within 14 months, doubling the department's report automation capabilities. • Authored dozens of TSQL queries to effectively harness data from company systems for enhanced operational insight. • Estimated material costs for $200M business unit in budgeting and forecasting. • Transformed Excel reports into Power BI reports through SQL and DAX for monthly P&L reports using ERP data from Microsoft Dynamics Navision 2018.

Amherst, Ny

I collected data to evaluate operational issues and recommended enhancements for production reporting procedures and inventory management/cycle counting. I supported annual accounting audit by gathering and analyzing data. I played the lead role in calculating standard costs for over 20,000 items annually by combining production efficiency data from operations and estimated raw material expenses from procurement, ensuring financial precision and budgeting efficiency. I established standard costs for new items. I developed Access queries to extract and leverage data from the company's ERP system. I corrected high negative stock levels and prepared cycle count reports on a monthly basis.• Successfully assisted IT in establishing a program that improved the planning department's efficiency and waste reduction. • Ensured accurate transfer of critical manufacturing data by acting as a key contributor to ERP data migration project. • Streamlined warehouse operations by consolidating material storage and freeing up significant space for optimized use.

Amherst, Ny

Participated in dozens of month-end closes analyzing material/labor discrepancies. I oversaw inventory obsolescence management and reserves. I conducted training for 3PL staff, assisted the document control team, and proficiently operated company ERP, Microsoft Dynamics AX. I gathered and merged data for various departments and managed Bills of Materials and Production Routes. I contributed to yearly standard cost updates by querying and collating data from various sources to be used as basis for key input changes. • Secured hundreds of thousands of dollars by devising a tracking system for temporary import bond materials and submitting necessary customs paperwork. • Reduced dependency on IT resources by creating user-friendly shop floor application. combining production efficiency data from operations and estimated raw material expenses from procurement. • Designed a process for plant floor operators to record production in the ERP system, allowing for more immediate inventory adjustments and improved data accuracy.

Amherst, Ny

I administered precise measurements/tests for analyzing and contrasting samples against standards. I evaluated data on non-conforming products, promptly reporting to the material review board. I directed QA Hold inventory and recommended steps for material disposition. I orchestrated handling of customer returns, probed root causes of low quality, and authenticated claims. • Decreased QA holds by tens of thousands of dollars through effective material management. • Executed strategies with management for addressing key quality issues through 5 Why, Failure Mode and Effects Analysis (FMEA), value stream mapping, and other quality tools.

Bachelor Of Arts - Ba, Mathematics

Master Of Education - Med, Adolescent Mathematics Education

Tesol Training