John Moore

Continuous Improvement Specialist & Aspiring Data Analyst

John Moore, Continuous Improvement Specialist

John Moore

Continuous Improvement Specialist & Aspiring Data Analyst

From the plant floor to the data pipeline. One class at a time.

8+ years in food service manufacturing. I connect MES, ERP, and QMS systems to eliminate manual reporting and surface insights that actually move the needle.

View My Work Get in Touch

What I Work With

The tools and systems at the core of my work.

Excel & Power Query

Dashboards, automation, data transformation

MES — Ignition

Machine data, OEE, real-time monitoring

ERP & QMS

Production orders, quality, cross-system joins

SQL & Access

Legacy databases, intermediate query layer

Python

Data generation, automation, scripting

HTML, CSS & JavaScript

Web development, this site

Projects

Real systems built to solve real problems on the plant floor.

Ignition MES Implementation

Facilitated deployment of real-time machine monitoring across 100+ pieces of equipment facility-wide.

MES Ignition IoT

Forming Dept. Daily Production Report

Replaced manual shift data collection with an automated MES API-connected workbook across 62 shift sheets.

Power Query Web API Excel

Press Production & Speed Loss

ERP-driven scrap approximation at the run level plus a structured speed loss capture overhaul across the press department.

ERP Power Query OEE

Centerline Effectiveness Measurement

Anchor-date methodology and historical OEE analysis to measure whether machine centerlines actually improved performance.

OEE Power Query MES

Machine Sensor Fault Analysis

Fleet-wide fault frequency report flagging both excessively faulting machines and potential sensor reliability failures.

MES Web API In Progress

Cross-System Reporting

Merged MES, QMS, and ERP data via ODBC and API into automated Excel dashboards used daily by plant leadership.

ODBC Power Query BI

Skills

  • Python
  • SQL & Access Databases
  • Excel & Power Query
  • HTML & CSS
  • JavaScript
  • C# / OOP Fundamentals
  • MES / ERP / QMS Systems
  • QlikSense BI Reporting
  • Lean & Six Sigma
  • Process Optimization

Career at GPI

Operator

Where it all started

Pack Team Leader

First leadership role

Trainer

Process & standards

Lead Operator

Floor-level performance

Group Leader

Cross-team coordination

Data Collection Coordinator

Data became the focus

CI Specialist

Current role, still climbing