Designed and implemented a full traceability system for two 20-station headlamp assembly lines building 2019-model-year automotive headlamps — tying together PLC cycle data, barcode scanning, and a custom Visual Basic + SQL Server application so every part could be tracked from bulb assembly through final photometric release.