PRJ-12
Dec 2024 — Mar 2025 · a high-mix architectural lighting manufacturer in Montreal
Fixture Appearance App Migration
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.
FEEDS & MOUNTING TYPES
MANUAL SOLVING→AUTOMATIC
Problem
Many power feed, power cable and mounting options had no automated solving to generate shop drawings.
Approach
- Designed the data architecture — four SQL tables (Dimensions, Lens, Power, Mounting) — and the solving logic as a prototype Excel model that an IT developer integrated into the C# universal configurator
- Migrated the full existing product data into the new SQL tables and added new data for non-automated fixture parameters.
- Extended the XML to carry updated fixture dimensions, lens dimensions, power input locations and mounting locations
- Updated the DriveWorks projects to read it, and added flag-driven SolidWorks parts so models switch by power type and mounting type
Outcome
Multiple power and mounting types now generate shop drawings automatically.
Artifacts
Selected outputs from the project — videos, generated drawings, code, and stakeholder decks.

FAA POWER FEEDS — EXTEND 4 PENDANT: STANDARD, TOP AND END FEED OPTIONS SOLVED FROM THE POWER FEED TABLE.
Next · PRJ-13
SQL Query Library for Data Diagnostics