Multi-location restaurant group - POS data automation
Replaced fragile local scripts with a cloud automation that logs into a legacy POS daily, extracts sales, cost, and inventory reports, and loads them into a ClickHouse warehouse. The system computes theoretical ingredient consumption daily.
- Eliminated manual report pulls.
- Improved visibility into inventory discrepancies.
- Moved a local workflow into monitored cloud infrastructure.