Hamza Yalcin

Data Engineer — Scotiabank

Developing and productionizing cloud-based data products and pipelines using GCP, dbt, SQL, Python, and Airflow to support analytics, data quality, and client personalization across Canadian Banking.

• Built and productionized batch ETL pipelines to clean and standardize millions of Canadian Banking merchant records daily, leveraging Python, regex, and Gemini on Vertex AI to improve data quality and deliver analytics-ready data for downstream business use.
• Developed standardized dbt data products and SQL transformations for client interactions, integrating data across digital, call centre, and branch channels to support client personalization initiatives.
• Performed source-to-target mapping, data validation, and transformation development to support the migration of on-premises Mastercard data to GCP.
• Designed and automated data quality validation frameworks and Airflow audits, using SQL to validate data integrity across GCP source systems and monitor DAG execution, while developing a Power BI dashboard that automatically refreshed with new data loads to provide ongoing visibility into data quality and pipeline health.
• Translated stakeholder requirements into scalable data solutions, defining data requirements, validation criteria, and technical workflows to deliver analytics-ready datasets.
• Mapped data relationships and dependencies across enterprise source systems to support standardized client interaction data and initiatives focused on personalized customer experiences.
• Engineered a Python pandas data profiling tool to automate statistical analysis of BigQuery datasets, generating record counts, aggregates, min/max values, and top-frequency distributions to accelerate data validation, identify data quality issues, and verify datasets against business requirements.

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 using Python to assess co-op eligibility based on GPA and course requirements, reducing manual review effort by 15+ hours.
• Analyzed 5 years of student and graduate data using Excel PivotTables, SQL, and Python to identify enrollment and outcome trends that informed program strategy and decision-making.
• Engaged with business stakeholders to gather requirements, evaluate implementation costs, and assess technology solutions to determine the best fit for organizational needs.
• Configured Salesforce Flows and validation rules to automate business processes, enforce data quality, and support the implementation of new workflows.

Analyst — First National Financial LP

Supported enterprise technology integration initiatives by combining data analysis, QA testing, risk assessment, and stakeholder coordination to improve implementation readiness and visibility.

• Developed automated tracking tools to monitor integration milestones, dependencies, and implementation timelines, providing stakeholders with visibility into project progress and potential delays.
• Performed QA testing across technology integration workflows, validating system functionality, data flows, and business requirements prior to production rollout.
• Analyzed integration and project data to identify risks, dependencies, and potential implementation issues, supporting risk assessments and technology decision-making.
• Collaborated with technical and business stakeholders to gather requirements, communicate findings, and support the successful delivery of technology integration initiatives.

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.
• Designed and facilitated consulting case competitions based on real-world business scenarios, helping students develop problem-solving, analysis, and consulting skills.

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