Kevin (K.M.) Mcclafferty Email and Phone Number

Work as a part-time consultant doing Excel and Access projects for companies large and small. Completed 100+ projects for companies including Rexam, Raytheon, and ABB Robotics.http://www.forwardsquare.com/

• Developed VBA macros that automated the refresh of an Excel-based Program BOM tracker by allowing the user to import an updated BOM file and the program highlighted new parts in green, deleted parts in red, and changed parts in yellow. This saved Program Managers significant effort in managing their parts list as their assemblies went through design updates.• Developed VBA macros for a number of existing Excel workbooks used to manage company information. Used VBA to save workbooks to SharePoint for enterprise sharing. Many of these improvements produced efficiencies by enforcing business rules and automating routine functions.• Developed custom-built Access databases to collect and manage information for tracking: Tooling, Pricing for Precious Metals, Design Department Workload including a Vacation Planner, Design Change Rule Violations, and Equipment Location/Storage. Development included integrating with Outlook using VBA for seamless notification.

Collaborated with business and IT leaders to define and deliver business solutions to achieve business goals. Worked with business leaders to understand functional strategies and develop roadmaps to support respective business unit initiatives and processes. Analyzed business needs, gathered requirements, documented and designed complex processes using various modeling techniques. Worked with developers to prioritize solutions, develop/execute test plans and deliver solutions.

• Tracked and managed $5,000,000 budget for plant capital and expense spending.- Developed Access database to connect to corporate database tables, using ODBC connection.- Interfaced Excel with Access using VBA to collect and report on purchase order and work order spending.- Automated management reports with “One Button Click” using VBA macros.• Developed Access database for tracking contamination issues. • Automated the process of writing and tracking projects, using VBA within Excel, Access, and Outlook.• Managed equipment disposals for four-speed transmission machining and assembly lines that went out of production in 2014.- Worked to minimize equipment thrown away and coordinated shipments of equipment and supplies to reseller, which resulted in over $700,000 recovered by company.

• Led effort to develop a global web application to manage supplier quality metrics.- Conducted small-group Joint Application Design sessions with project stakeholders.- Developed data flow diagrams to model new designs.- Mapped business requirements to functional requirements.- Supported developers in implementing designs.- Developed and documented test plans.• Developed VBA macros for Excel-based scorecard prototype used by 5,000 suppliers to assess program readiness.- Tool was utilized three to four years until replaced by IT department at cost of $1,000,000.• Developed VBA macros for Excel-based reporting tool that interfaced with corporate databases and allowed for reporting of Supplier Quality Metrics by region and globally.- Reduced time to generate reports from one week per month to one hour per month.

Optimized direct and indirect labor. Evaluated line layouts and control logic, using computer simulation. Developed computer tools to conduct shift pattern and buffer sizing analyses. Certified MODAPTS practitioner, manufacturing simulation subject matter expert.

Led effort to develop web-based solution to allow manufacturing engineers access to product CAD data. Collaborated with project scoping. Represented customer on cross-functional development team. Worked with IT business analysts to develop functional requirements. Supported developers during development. Coordinated efforts between three organizations to include automatic tessellation feature that required outsourced development. Developed test cases and performed unit testing. This web-based solution was the only one of 5 teams to deliver a solution to their organization and I was recognized with an Outstanding performance review and awarded stock options due to my efforts on this project.Developed simulation models of manufacturing processes, using WITNESS simulation software, with one simulation study saving company from investing $375,000 in unnecessary equipment. Developed user-friendly interface to WITNESS simulation software package using VB6 and Microsoft Access that allowed non-technical users the ability to quickly conduct simulation analyses of manufacturing systems. Developed critical path diagrams of product development processes, using project management software. Evaluated project management software for corporate deployment to manage program timing.