All projects/Work/2026 –/Live
Supply Group: AI and data systems for a four-division retail group
As Digital Systems Engineer I build and run the software behind Supply Group LLC, a private retail group with four divisions: Telegram storefronts, an ERP-fed data warehouse, Power BI reporting, and an AI assistant over live company data.
What I built
- —Three production Telegram bots, storefront, marketing broadcast and customer service, live across all four divisions. The storefront runs as a Mini App with a plain-button fallback for phones that cannot open Mini Apps.
- —Browser admin panel for products, prices, photos and orders. A price changed in the panel appears in Telegram immediately.
- —PostgreSQL data warehouse with automated ETL from the Smartup ERP, consolidating sales, payments and cash across all divisions.
- —Power BI dashboards for leadership: group sales and receivables. Daily cash-flow and debtor reports generated automatically, replacing spreadsheet reconciliation.
- —Dockerized Linux server hosting 17 production services, with health monitoring and alerting.
- —LLM financial assistant that answers natural-language questions against live company data. In development.
Stack
Python · aiogram 3 · FastAPI · PostgreSQL · Docker · Power BI · Supabase · Cloudflare R2 · LLM
Outcomes
- —Leadership sees group sales and receivables as they happen, not at month end.
- —Orders, prices and stock change in one place and propagate to every division's bot.
- —One monitored server and one deploy path for every bot and report.