Reporting
Automation
7+ siloed data sources unified into one Python pipeline — Excel & SQL Server — cutting manual reporting time by 40% across three teams.
Problem
Data lived across 7+ disconnected tools — CRM, ticketing, spreadsheets, third-party portals. Ops pulled metrics manually every morning; numbers drifted between teams.
Approach
Mapped every source → wrote Python scrapers into a SQL staging layer → built a VBA-driven Excel layer that refreshed daily reports on schedule.
Outcome
40% reporting-time reduction. 3 teams aligned on one source of truth. Single-click daily MIS pack replaced a 90-minute manual process.