Public résumé / Engineering & business intelligence

Liam McGrath

Manufacturing data systems · ETL & Power BI · Simulation & controls

Builds data-collection systems, ETL pipelines and Power BI reporting for manufacturing, with experience in process simulation and industrial controls.

Explore experience ↓

This is a curated public HTML résumé. Print / Save PDF creates a browser-formatted copy, not the original awesome-cv PDF. The original template is preserved privately; no compiled original PDF is available yet. Private contact details and original source/template downloads are omitted.

01 / Professional practice

Experience

  1. Business Intelligence Lead

    Honda of Canada Mfg.

    Jan 2023 – Present

    Current scope Business intelligence work now supports the Manufacturing Division at Honda, having previously focused on the Weld Department. Works with the company’s Pillar Leads, who oversee department-level matters.

    The role dates describe the BI Lead position; the division-scope update is undated.

    • Designed data-collection scripts and validated-entry Python/Tkinter interfaces for quality and safety documentation.
    • Built ETL workflows that combine and transform data for Power BI reporting; standardized reporting using solutions developed in Weld and mentored leads from other departments.
    • Developed SQL and Excel production-whiteboard reporting for downtime, throughput and asset state.
    • Automated file migration to Microsoft SharePoint and routine API-based data transfers.
    • Used process simulation to identify efficiency opportunities and estimate output changes from engineering projects.
  2. Process Engineer

    Honda of Canada Mfg. · Engineering Group

    Jan 2020 – Jan 2023

    • Built critical-control-point reporting pipelines and automated A-rank quality check sheets; collaborated with Production Unit Leaders on scrap and throughput reports.
    • Modified tooling, PLC logic and WINCAPS III robot programs to improve processes.
    • Analyzed scrap and process-point data to assess efficiency changes; collaborated with an international New Model Group on development cycles.
  3. Simulation Software Developer

    University of Waterloo · Roy Research Group

    Jan 2018 – Sept 2018

    • Developed Python/MMTK simulations using path-integral Monte Carlo (PIMC) and path-integral molecular dynamics (PIMD).
    • Developed C++ potential-energy and gradient calculations and implemented the MB-pol many-body water potential.
    • Automated shell-based simulation submission and trajectory analysis; used parallel processing and Compute Canada research computing.
  4. Research Assistant

    The Woodbridge Group · Corporate R&D

    Sept 2016 – May 2017

    • Formulated polyurethane foams and measured physical and chemical properties for automotive seating, thermal insulation and acoustic insulation.
    • Studied resin and solid-polyol dispersions using FTIR and viscosity measurements; presented research results and product-development updates.

02 / Foundations

Education

Honours Bachelor of Applied Science in Nanotechnology Engineering (Co-op)

University of Waterloo

2014 – 2019

03 / Educational design

Selected project

Room-temperature NO2 sensor

University of Waterloo · Fourth-year design capstone

Sept 2018 – Apr 2019

  • Designed and fabricated a portable nitrogen dioxide sensor with professors and engineering classmates as an educational capstone.
  • Deposited carbon nanotubes between interdigitated electrodes and electroplated tellurium to improve sensitivity.
  • Evaluated dose-response under controlled NO2 concentrations and built Arduino-interfaced readout circuitry to display concentrations.

04 / Working toolkit

Technical skills

Programming & query languages
  • Python
  • SQL
  • VBA
  • C++
  • Java
  • PowerShell
Data & business intelligence
  • Power BI
  • Tableau
  • Excel
  • pandas
  • NumPy
  • pyodbc
  • xlwings
Operating systems
  • Linux
Cloud & collaboration
  • AWS
  • Microsoft SharePoint
Simulation & scientific computing
  • PIMC / PIMD
  • MMTK
  • Molecular dynamics
  • Monte Carlo
  • COMSOL
  • SIMUL8
Interfaces & controls
  • Tkinter
  • PLC logic
  • WINCAPS III
  • Arduino
Machine learning tools
  • scikit-learn
  • TensorFlow
  • Keras
Scientific authoring & visualization
  • TeX
  • Matplotlib
  • VMD

05 / Academic recognition

Awards

NSERC / USRA research grant

University of Waterloo · Research under P. N. Roy

2018

President’s Scholarship

University of Waterloo · Academic achievement

2014