Rusty Hegler Email & Phone Number

Guilford, Connecticut, United States

Black Mountain, Nc

● Support Purchasing department using Power Query and VBA to analyze production and demand data to calculate orders placed in SAP for international parts, which make up over 50% of material SKUs.● Participate in monthly Sales and Operations Planning supplying data and developing operations plans to maintain appropriate staffing levels, training, and certifications to support organizational goals.● Use Power BI and Excel to visualize and analyze sales order backlog and material lead time to provide forecasting for order delivery dates and determine how to improve request date service level.● Establish plans achieving continuous improvement in safety, quality, delivery, cost, and cash flow.● Created database to track employee training and certifications. Using SQL to query the database to ensure recertifications are scheduled and that training doesn’t expire for employees in each role.● Execute daily operations by managing 24 employees in assembly, planning, testing, and packaging in 5 manufacturing cells making ASME Section I, IV, and VIII safety relief valves.

Asheville, Nc

● Developed dashboards, visualizations, and reports in Salesforce for Sales, Marketing, and Supply Chain teammates, managers, and directors in North and South America.● Led price adjustment project for over 4000 customers, extracting data for product pricing (~250 SKUs), disseminating to sales reps, then loading newly negotiated prices in SAP and proprietary ERP tool.● Managed rebate contracts for over 20 key and strategic accounts providing data and reports to customers and the business controller in finance to ensure contract rebates were being paid correctly. ● Served as the local Salesforce CRM administrator and primary support for all departments including Supply Chain, Purchasing, Sales Representatives, Product Managers, and Customer Service.● Created sales related objects in Salesforce including forms for data collection, data validation, and maintenance of external database connections.● Trained all teammates in the use of reports, dashboards, and objects in Salesforce.

Fletcher, Nc

● Coded a reporting tool with VBA to combine data from multiple datasets, such as Cognos PowerPlay to automate creation of SPC charts, Cpk charts, histograms, and other data visualizations in Minitab.● Developed interactive reports for 3 factories that were easily extracted and published on SharePoint pages for supply chain to facilitate the planning of coating production.● Customized Salesforce program to streamline customers’ special product purchasing requests.● Analyzed special product requests from customers and advised leadership on projected manufacturing efficiency and profitability, as well as risks of acquiring new product business.● Collected data and managed supplier scorecards regarding delivery and quality of raw material suppliers including paper, adhesive components, and silicone components.

Mills River, Nc

● Managed and completed a Black Belt project simultaneously in two US manufacturing sites that saved over $360K annually by reducing the top manufacturing defect by 50%.● Coordinated all Lean Six Sigma projects across 3 US factories and acted as the liaison for the global LSS team to help leverage projects at other factories.● Managed engineering interns and delegated project tasks as well as other process improvement tasks.● Learned to work across the organization making improvements in coating operations and also interacting with supply chain, finishing, quality, customer service, sales, and product development to make sure results are value added for the organization and not just a single department.

Mills River, Nc

• Led successful raw material cost reduction project of silicone components where product quality and machine efficiency were maintained with no negative impact on customers or delivery time. • Reduced environmental impact through production effluent and wastewater recycling. Project resulted in ability to reclaim waste material and reduce the impact on the metropolitan sewer district.