Problem
- Andon, BW/GW toggle, booster and dispatch criteria existed only as natural-language SOPs
- A missing leakage filter and ambiguous JOINs made the dashboard metrics hard to trust
Company
OnePiece Mission Validation & SOP Rule Engine
Natural-language operating SOPs formalized into thresholds and AND/OR conditions in a Python rule engine
Period | 2026.06 ~ 2026.07
Turning SOPs that only existed as documents into executable rules
My Role
- Reorganized Mission and Segment SQL by purpose; fixed the missing leakage filter and ambiguous JOINs
- Built a parity protocol comparing actuals with dashboard values, plus a KPI catalog
- Formalized SOP criteria as thresholds and AND/OR conditions with a Pydantic input schema and one rule engine
Result
- Validated as a standalone prototype, then integrated into OnePiece with test and demo UI
- Documented SOP terms and decision flows with a glossary, tables and Mermaid for validation and onboarding
