A retail shop had eight years of sales locked in a legacy point-of-sale database that nobody could query.
- SQL and Python ETL that extracts, cleans and loads the records into a DuckDB warehouse.
- A small API on top so the cleaned data can be queried for sales and product reports.
Python, SQL, DuckDB, Pandas, FastAPI
Private repository (contains real business data). Happy to walk through it in an interview.