All projects/Work/2026 –/Live

Business Intelligence Platform: ERP → Data Warehouse → Power BI → AI

Built for a four-division retail business: ERP data synced into one warehouse, reported in Power BI, with an AI layer that answers questions over the same numbers.

What I built

—Automated ETL from the Smartup ERP into a PostgreSQL warehouse: sales, payments and cash across all divisions.
—Power BI dashboards for leadership: group sales and receivables.
—LLM financial assistant over the warehouse. In development.

Stack

Python · PostgreSQL · Smartup ERP · Power BI · Docker · LLM

Outcomes

—Reporting effort cut by about 80%: daily, weekly and monthly reports build from the ERP sync instead of manual Excel work.