Hamza Yalcin

Analytics Engineer — Scotiabank

Building and maintaining dbt models and automated data quality workflows that support reporting and business decisions across Canadian Banking.

• Built two separate ETL pipelines — one for payment merchants, one for non-payment — cleaning and standardizing records with Python regex and Gemini, then orchestrating each through Airflow
• Automated data quality audits in Airflow for DAG monitoring, and validated data integrity across GCP source systems with SQL
• Translated stakeholder requirements into scalable data solutions, backed by checklists, validation frameworks, and leadership presentations
• Mapping how data connects across source systems to build a more personalized customer journey across the bank's digital, call center, and branch channels

Information Security Analyst — Scotiabank

Supported the bank's security operations, from platform testing to leadership reporting.

• Assisted with development and testing of D3 Security platform tools — gathering stakeholder requirements, supporting UAT into production, and decommissioning unused case types to simplify the platform for investigators
• Built live security-incident visualizations for senior leadership, replacing static reporting with real-time monitoring
• Optimized the analyst onboarding process using Power Apps, cutting manual effort and ramp-up time by 50% through new frameworks

Business Analyst — Career, Co-op & Student Success Centre

Built tools to evaluate student eligibility and surface trends across the co-op program.

• Automated transcript analysis with Python to flag co-op eligibility based on GPA and courses taken, cutting manual review by 15+ hours
• Analyzed 5 years of student and graduate data using Excel pivot tables, SQL, and Python, surfacing trends that informed program strategy
• Met with potential stakeholders to scope costs and requirements for integrating a new tool into the organization, and helped determine the best fit
• Built out Salesforce Flows and validation rules to support the resulting workflows

Summer Analyst — First National Financial LP

Analyzed risk and integration timelines for new technology being brought into the organization.

• Built automated trackers to monitor integration timelines and flag delays
• Conducted QA testing across integration workflows to catch issues before rollout
• Supported data analysis work informing the risk assessment of each integration

Director of Corporate Relations — Toronto Metropolitan Consulting Association

Ran corporate relations and consulting programming for the club, while mentoring associates.

• Organized 15+ professional events engaging 500+ students
• Led corporate outreach, connecting with 250+ professionals and sponsors and securing $5,000+ in sponsorships
• Built out case competitions and consulting skill-building sessions, contributing to the club winning Student Interest Group of the Year and Best Collaboration

Süper Lig Match Predictor

A random forest model that predicts Turkish Süper Lig match outcomes (win / draw / loss). Engineers features like rolling 3-game form, goals for/against, home advantage, and season-long points-per-game, trains with a time-based split to avoid lookahead bias, then scores the rest of the season with win/draw/loss probabilities and exports feature importances.

GitHub

Lumina Paint

A real-time collaborative drawing app with live cursor tracking and presence awareness across ephemeral sessions — no accounts, no saved state, just people drawing together in the moment.

• Supabase Realtime Channels broadcast drawing events directly, with no database storage
• Interactive HTML5 canvas editor with multiple tools, undo/redo, and export

Live demo·GitHub

Citco

A web app investigating whether a researcher's citation count tracks with how much NSERC Discovery Grant funding they receive.

• Web-scraped dataset combining NSERC grant records with Google Scholar citation counts
• Found a Pearson correlation of roughly 0.3 between the two — a weak but real relationship

GitHub