Business Context
Building laser modules and precision lenses is unforgiving: a micron-level variance can scrap a $5000 assembly. The client’s ERP, MES, and SPC tools all held pieces of the story, yet executives waited two days for stitched-together spread—sheets—too slow to catch drift in dielectric coatings or diode alignment.
Challenges
- Streamlined KPIs missed their SLA each month; engineers wasted 25 hrs/week on manual queries.
- Model Mismatch ERP logged wafers as “lots,” MES as “batch-es,” SPC as “runs,” producing contradictory yields.
- Yield Leakage Inability to spot early-shift anomalies cost an estimated $150K per week in scrap and rework.
- Eroding Trust Only 42% of managers said they “fully trust” the numbers used in quarterly reviews.

