← All projects

PRJ-03

Mar 2023 – Sep 2024 · Axis Lighting

Engineering Data Architecture

Data Engineering · Logic Driven Systems

SQLC# Universal ConfiguratorXMLData GovernanceSolidWorks PDMAgile Releases

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.

NCRs on newly automated products

29.5%→5.1%

Excel configurators

49→1 (MU10)

Ordering codes tested before go-live

6,000

Challenge

  • Millions of possible product configurations, with missing data and no standards for specific products.
  • 49 Excel configurators and scattered documents, each with its own logic and no rule on which to use.
  • The shop drawing is the one document that travels from client approval to shipping, so every data error reached the floor.

Approach

  • Led the project as PM from charter through go-live, and ran the current state analysis in Mar 2023.
  • Designed the universal solving logic as an Excel prototype (MU10). IT built it into the Universal Configurator, which reads the ordering code, pulls rules from SQL and outputs solved XML.
  • IT built the Axis Data Management Tool so the automation team could set up fixtures without writing SQL. Engineers test it and own the data.
  • Released in stages: MU10 calculator in Nov 2023, Universal Configurator go-live on 6 May 2024.
  • Tested about 6,000 ordering codes with 11 people before go-live.

Outcome

  • NCRs on newly automated products fell from 29.5% to 5.1% by Sep 2024.
  • Data is now version-controlled and engineer-owned, with no hardcoded values.
  • This foundation made possible the automated shop drawings in PRJ-08 (DriveWorks Transformation).
PRJ-08 — DriveWorks Transformation →

Artifacts

Selected outputs from the project — videos, generated drawings, code, and stakeholder decks.

THE DATA AND LOGIC DRIVEN SYSTEM BUILT TO GENERATE DRAWINGS AUTOMATICALLY BASED ON THE OUTPUTS IN THE XML.

Next · PRJ-04

MU10 Linear Solver

→