Production data tools built for a private Bargain Booze retail franchise (up to 4 sites, 30 staff). Both tools are live and used in daily operations.
Automated ETL pipeline ingesting supplier PAL pricing files, consolidating data across 13 promotional periods, calculating cost movements and value efficiency, and producing a fully formatted decision-ready master tracker.
Tech: Google Apps Script · Drive API · Google Sheets · JavaScript
Inventory management system tracking 1,800+ SKUs across multiple sites with automated reorder logic based on sales velocity, stock thresholds, and case size multiples.
Tech: Google Apps Script · Google Sheets
Built by Kieran Burrell · LinkedIn