Experiences

Jan. 2025 - Apr. 2025

Waterloo, ON

Software Developer

Reduced page load times by 62% through SQL query and stored procedure optimization, including targeted indexing, removal of redundant computations, and simplification of aggregations.
Engineered a data archival workflow to transfer historical records from MySQL to partitioned BigQuery tables, reducing cloud costs by 30% and improving query performance for transactional workloads.
Developed real-time automation algorithms using C# and Flask to optimize budget adjustments and ad pausing through API integrations, leveraging GCP BigQuery, Cloud SQL, and MySQL for historical data analysis, enhancing data-driven decision-making.
Designed and implemented an automated ETL pipeline using C# to ingest advertising performance data from third-party marketing APIs, perform data transformation and enrichment, and load structured results into MySQL, enabling real-time ad campaign analytics via integrated Tableau dashboards.

May. 2024 - Aug. 2024

Waterloo, ON

Research Assistant Intern

Conducted research to optimize log analysis of large scale log data from various software systems by establishing a pipeline to generate ground truths for template based log parsing.
Saved 10+ hours weekly by developing Python scripts to analyze over 2 million log entries and templates from 12 different software systems, streamlining data collection for the study.
Generated a user study for 20 participants to identify discrepancies between automatically generated log templates and user perceptions, leading to improved log parsing techniques.

Sept. 2023 - Dec. 2023

Toronto, ON

Full Stack Developer Intern

Enhanced realtor efficiency by collecting, processing and visualizing real-time housing market data from over 2.5 million listings across diverse Canadian regions by leveraging React, ASP.NET Core, and a MySQL database.
Facilitated seamless communication between front-end and back-end systems, enabling efficient data retrieval and enhancing user experience by designing and implementing RESTful APIs.
Optimized data retrieval, manipulation, and analysis, resulting in a notable reduction in processing times by 95% through utilizing parallel processing and asynchronous programming techniques within data processing APIs.
Engineered a WinForms desktop application using C# and .NET Core to display various company media on multiple screens.

Jan. 2023 - Apr. 2023

Toronto, ON

Switch Technician Intern

Improved the reliability of fiber optic transport links through collaborative testing and troubleshooting using RFC 2544 and BERT tests.
Contributed holistically to all Rogers customers, working with GSM (2G), UMTS (3G), LTE (4G), and 5G technologies.