Python · SQLAlchemy · PostgreSQL · xlsxwriter
A 6-stage modular ETL pipeline processing 63,474 property transaction records: HTTP extraction → SQLAlchemy transformation → PostgreSQL load → insight generation → Excel export. Built as independent, reusable Python modules with an orchestration entry point.
CSV → Extract.py → Transform.py → Load.py → Execute.py → PostgreSQL → Creating Insights → Exporting Insights.py