← All projects

PRJ-12

Dec 2024 — Mar 2025 · a high-mix architectural lighting manufacturer in Montreal

Fixture Appearance App Migration

Configurator Logic · Data Architecture

Automation

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 feed table and drawings for the EXTEND 4 pendant — standard, top and end feed options

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

→