Max Mackay Email & Phone Number

Zeeland, Mi, Us

• Designed and implemented a comprehensive Heat Treat tracking application, utilizing User Defined Tags (UDT) to monitor and display real-time rack locations within the oven• Developed a rack lookup feature summarizing time in oven zones, temperature ranges, enhancing quality control and process analysis as well as reporting all necessary data to ERPDesigned and implemented a comprehensive, high availability traceability MES solution for a global Tier 1 automotive supplier, enabling highly flexible configuration for ensuring all required part birth, data collections and operations are completed on each part before processing• Designed traceability capable of integrating subassembly part checks before unioning to the master part, and performing final validation before auto-packing• The traceability system was deeply integrated with ERP to manage order and container data, monitor production and scrap counts, track employee qualifications, and ensure compliant operation of equipment and processes• Developed a part lookup summary and disposition screen to efficiently manage and document manual part statusing, ensuring accurate tracking and accountability within the production process • Integrated UDT interlocks with Siemens and Allen Bradley PLCs within the traceability MES solution, ensuring seamless and reliable enforcement of process checks and validations across diverse automation environments

Columbus, Ohio, Us

• Design and develop manufacturing execution systems (MES) forcommercial and industrial clients including metals, paints, coating,adhesives and manufacturing systems• Rewrote 150+ poorly performing SQL Stored Procedures & Functions to leverage highly optimized set-based code reducing query time from minutes/hours to seconds or even milliseconds• Architect, deploy, monitor, and administrate Azure solutions for theMES application to maintain high uptime and optimizedperformance•Manage 20+ IoT devices configuration and remote orchestration, along with secureMQTT communication of 100,000+ client's data points to the MES cloudapplication• Coordinate with other engineers and customers to ensureseamless integration of plant equipment to MES solution• Actively participate in Agile ceremonies including daily standups, biweeklysprint planning, sprint reviews, and retrospectives to ensurealignment with team goals and project milestones• Designing and implementing 100+ python unit tests for MES backend functionality validation

Columbus, Ohio, Us

• Designed & Scripted SQL Relational Database for Manufacturing Execution Systems (MES)• Built application to integrate scanners to facilitate tracking of goods and monitoring/alarming of equipment critical to the function of the process• Constructed Ignition Java Modules that served data to the MES product platform• Software programming/architecture • Product development• Customer interface• Database theory• Programming theory• Implement Software Development Life Cycle (SDLC) best practices• Software implementation

Torrance, Ca, Us

• Researched open-source data historians for more modular SCADA solutions for manufacturing customers.• Lead proof of technology for Raspberry Pi 4s to be deployable edge devices for data collection machine side. • Developed a proof of technology for container orchestration for rapid development opportunity for business customers needing a service. i.e. Web Server and/or Database• Provided R&D engineering support for a proof of concept for a vision system used to inspect car quality and provide judgement to associates

Us

• Evaluated cutting-edge IoT & IIoT technologies for plant floor use cases• Administered Nagios XI Server for 500+ Hosts & 5000+ Services • Developed scripts for automation of thin clients to deploy GALC application• Deployed & Administered 325+ Wyse thin clients for 4 manufacturing plants• Assisted with Root Cause Analysis(RCA) for plant & department downtime events• Supported Operation Technology group with VM standup and migration• Developed Powershell scripts to configure Windows hosts• Assisted in plant wide initiative for asset condition monitoring project(SCADA) specifically supporting network segmentation of OT and IT equipment & VM standups• Developed & Integrated Label Verification System for Automotive Vehicle Certification Label

Us

HAM iT GALC Development• Developed in Java for Global Automated Line Control(GALC), Honda’s MES • Utilized JIRA(Atlassian) for bug & feature tracking & Confluence(Atlassian) for Wiki topicsAssembly Frame Quality Systems• Evaluated GALC with AF SME for feature improvements to be proposed to Region(HNA)• Confirmed proper function of application during 2HX DAN-0 events• Designed communication cable for scanner to Omron CJ1 PLC Forming Department (Plastics)• Converted MAP Instrument Panel(IP) Line to GALC• Modified & Troubleshooted Mitsubishi PLC Ladder Logic• Developed DeviceWISE triggers for data processing of IP• Managed a demolition of an office to increase inventory space for bumpersHAM iT Web Development• Designed relational database for Honda Lot Check App• Developed website of Honda Lot Check App utilizing Java & JavaScriptAnna Engine Plant GALC Development • Developed DeviceWISE triggers for factory machine to GALC application communication

• Developed their Grid Enterprise Manager(GEM) customer web page.• Expanded installer for the FrameWorx system. • Created the testing platform for GEM project.• Designed the test cases used to test against the GEM system.• Stood up a Jenkins server on Linux to run unit tests

Cincinnati, Ohio, Us

• Managed a C++ programming & Robotics laboratory equipped with 40 students. • Instructed students with lab assignments• Graded lab reports

Charlotte, North Carolina, Us

• Performance and reliability testing of analog and digital circuits.• Testing firmware on completed circuit designs and products. • Designed and developed new testing applications for new and legacy products in C#.• Characterized and tested pressure transducers to .08% error level.• Responsible for designing new test cases for new and upcoming products.

Columbus, Ohio, Us

• Operated camp store including inventory management, stocking and registering campers.• Dealt customer relations and customer service.