01
Sep 2025 — Dec 2025
Toronto, ON
TD Bank
Software Engineer Co-op
- Engineered an automated ETL pipeline with Power Automate to extract unstructured Confluence data into SQL-ready CSVs, cutting manual entry latency by 90%.
- Built SQL stored procedures that processed TMX user requests and categorized users into Blocklist, Watchlist, and Safelist based on real-time security logic.
- Eliminated 5+ hours of weekly manual QA by implementing validation scripts that enforced data integrity prior to ingestion.
- Designed a high-availability Power BI dashboard to monitor aggregator logins and SLA metrics, optimizing DAX for faster refresh and query performance.
SQL · Power Automate · Power BI · DAX