Michael Dy Email & Phone Number

Chicago, Il, Us

Bolingbrook, Illinois, United States

Bolingbrook, Illinois, United States

• Developed multiple production KPI dashboards to calculate highest running defect issues and calculate product yield data by automating data wrangling and cleaning with VBA, constructing complex and dynamic Excel formulas, and creating user-friendly interfaces which accelerated data analysis.• Built a Work Order Ticketing system for the Materials Science Lab with MS Excel VBA to organize report requests and manage technicians’ workloads by creating a file database, writing file interaction scripts to read and post data, and automated external/internal group emails to increase communication. • Updated the manufacturing change request process to improve user satisfaction and increase document control by developing a multi-user system, creating a new interactive change request form, and automating data management files reducing system and user issues by 70%. • Constructed an automated report accessor and formatter to streamline KPI reporting times and save engineering resources by automating data fetching, data filtering, and file accessing which reduced engineering report work time by over 96%. • Refined product specification documents to clarify product acceptability, reduce NCR disposition time, and raise quality expectations on the manufacturing floor.

Urbana, Illinois, United States

Tier 1 Tech. Consultant (University of Illinois at Urbana-Champaign)Aug. 2019 – May 2022Urbana, IL • Maintained a welcoming and respectful work environment for students by supervising university computer labs and cleaning computers and workstations periodically • Troubleshot printers and printing issues for university students and faculty by empathizing with their concerns and aiding them in using university websites• Assisted students and faculty to navigate university websites by presenting the procedural steps both visually and verbally