// projects
Better processes. Cleaner data. Fewer errors.
CAD Automation · Logic-Driven Design
Automated shop drawing generation for 83 configurable lighting products with four DriveWorks projects driven by the XML from Universal Configurator — cutting order-line generation from 1.3 hours to 6 minutes.
ENGINEERING AUTOMATION · EXCEL TOOLING
Co-developed a macro-driven Excel solver for every pattern fixture shape — mechanical and electrical solving inside MU10, released May 2025.
Service Management · Reporting
Owned the Jira Service Desk as Business Application Owner — triaging every automation and IT request — and built the JQL Jira dashboard the whole engineering department runs on.
Lean Six Sigma · Process Design
Lean Six Sigma Green Belt project: consolidated every document needed to create and verify a shop drawing for 24 beam pattern products into one revision-controlled Excel file in the PDM Vault.
Configurator Logic · Data Architecture
Designed the data architecture and solving logic that let the universal configurator handle power feeds and mounting options — from prototype Excel model to C# integration and flag-driven CAD.
Data & SQL · Diagnostics
Built the key queries as a reusable stored-procedure library on MS SQL Server and documented in Confluence — so anyone in the automation team could run the right procedure for solving the jira ticket in front of them without rewriting SQL.
Built the MU13 series/parallel driver-current calculator for 24 products — adopted across five teams — and owned MU13 maintenance through the PDM Vault.
Data Migration · Product Standardization
Executed the automation data migration from 80 CRI to 90 CRI boards across all 472 products — staged SQL updates, chip-data validation, and BOM correction with the BOM team.
Process Standardization · Intake
One standardized intake template so every new product reaches automation with complete data — refined with engineering input and raised as Jira Enhancement tickets.
LEAN SIX SIGMA · PRODUCTION EFFICIENCY FORECAST
Grew a Kaizen event into a Lean Six Sigma project that let production forecast its own hourly efficiency, automating attendance, ERP data flow and reporting across 7 business units.
Inventory · ERP · Process Improvement
Led generic part-number mapping, LOT tracking and first-in-first-out picking for LED boards — live in Epicor in September 2024.
Process Standardisation · Technical Documentation
Replaced scattered documents with a version-controlled standards library and verification tools for a 26-member shop drawing team.
Quality · Process Design
Built a validation team, tools and a new KPI to catch shop drawing errors before orders reached production.
Data Engineering · Logic Driven Systems
A central SQL data model and a Universal Configurator now solve every automated order from its ordering code. Automation Engineers maintain the data themselves through a simple data management tool.
Process Design · Engineering Tools
A single, version-controlled Excel solver for linear fixtures. It gives every department the same driver current, board voltage, driver selection, input power and input current.
Inventory · ERP & Automation Logic
Orders were matched to obsolete LED boards by engineering-approved rules, in both the ERP and the shop drawing automation. Power BI alerts told us when to stop.