← 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).
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