Summary
Overview
Work History
Education
Skills
Awards
Projects
References
Timeline
Generic

Brian Tran

Toronto,Canada

Summary

Databricks Certified Associate Developer for Apache Spark 3.0 Certified Microsoft Azure Data Scientist Associate, Data Engineer Associate: Databricks, Synapse, Azure Data Factory

Microsoft Certified Solutions Expert (MCSE) in Data Management and Analytics: SQL Server, SSIS, …

Tableau Desktop Specialist, SAS Certified Professional: Advanced Programming, Microsoft Data Analyst (PowerBI)

Alteryx Designer Advanced Certification, Alteryx Server Admin Certification

CIBC MomentMaker Awards 2021, 2022, 2023

Overview

9
9
years of professional experience

Work History

Sr. Data Engineer

CIBC
Toronto, ON
06.2020 - Current
  • Designed and developed data pipelines using Databricks, Azure Synapse Analytics, dbt; implemented Azure Data Lake Storage Gen2 for storing large amount of data using Delta table format
  • Developed 4 automated deployment pipelines using Git, pytest and Azure DevOps, saving ~30 developer hours/weak
  • Developed customized Tableau dashboard extensions (JavaScript) and Alteryx tools (Python) using vendor SDK
  • Monitored, maintained and upgrade BI systems to ensure the services availability for 12,000 users in Tableau and 1,500 users in Alteryx
  • Strategized, troubleshooted BI tools integration with Cloud data sources (Azure SQL, Databricks, Synapse)
  • Hosted several Tableau & Alteryx Workshops to help users across the bank with automation, solution design, ETL best practices, performance improvement
  • Developed 35+ automated data pipeline using Alteryx to ingest, blend and analyze data, cutting down 50 man-hours/week

Assistant Instructor

University of Toronto
Toronto, ON
12.2021 - 06.2022
  • Provided comprehensive academic support and tutorials in class and in one-on-one session with students, answered questions related to course materials (Excel, VBA, Python, SQL, MongoDB, …)

Financial Data Automation Engineer

Techcombank
Hanoi
08.2015 - 07.2017
  • Designed data analysis model to analyze monthly, quarterly performance with forecasting for more than 300 branches
  • Developed Bad Debt Management Dashboard that helped reduce bank’s Bad Debt Ratio from 3.1% to 1.9% in 6 months
  • Lead the development of 6 interactive PowerBI dashboards, effectively consolidating and visualizing complex financial data, leading to enhanced decision-making for senior management and stakeholders.

Education

MSc Computer Science -

Toronto Metropolitan University
08.2024

Post Graduate Certificate - Database Application Developer - Business Analytic

Seneca College
04-2020

Banking and International Finance Bachelor -

Foreign Trade University
06.2016

Skills

  • Python
  • Azure Synapse
  • Databricks
  • dbt
  • SAS
  • JavaScript
  • Elixir
  • Excel VBA
  • Java
  • Shell script
  • MS SQL Server
  • Snowflake
  • Oracle PL/SQL
  • MongoDB
  • Redis
  • Azure Database
  • Alteryx
  • Oracle
  • Tableau
  • PowerBI
  • Hadoop
  • SSIS
  • Continuous integration
  • Performance Tuning
  • Advanced SQL
  • Git Version Control
  • Spark Development

Awards

  • CIBC MomentMaker Awards 2021
  • CIBC MomentMaker Awards 2022
  • CIBC MomentMaker Awards 2023

Projects

Sentimental Analysis using Deep learning with Python, https://github.com/haphantran/Sentiment-analysis-with-Python-using-Keras Analyze App Store data using Pandas, https://colab.research.google.com/github/haphantran/datascience_dataquest/blob/master/Project1-%20Analyze%20Apple%20store%20and%20Google%20Play%20store%20application.ipynb StravaAPI/Alteryx/Tableau Running Data Visualization, https://haphantran.com/blogs/how-i-download-and-visualize-my-running-data-using-strava-api-alteryx-tableau Logistic regression using Excel, https://youtu.be/hAmwPDPqduQ Build Machine learning model using Azure ML Studio, https://youtu.be/Pp05pj7Wqrk Intro to Cloud Computing (Youtube), https://www.youtube.com/watch?v=yGa0Sx32AIU Intro to Data Analytics (Youtube – Vietnamese), https://youtu.be/5DTG2fVwzpo Alteryx – How to build offline installer .yxi, https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Python-tool-yxi-offline-installer-by-pass-network-block-to-PyPI/td-p/927795 Alteryx – Writing multiple streams to Excel file, https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Writing-to-multiple-Excel-Sheets-in-the-same-files-Using-Block/td-p/1094967

References

References available upon request.

Timeline

Assistant Instructor

University of Toronto
12.2021 - 06.2022

Sr. Data Engineer

CIBC
06.2020 - Current

Financial Data Automation Engineer

Techcombank
08.2015 - 07.2017

MSc Computer Science -

Toronto Metropolitan University

Post Graduate Certificate - Database Application Developer - Business Analytic

Seneca College

Banking and International Finance Bachelor -

Foreign Trade University

Similar Profiles

CREATE PROFILE
Brian Tran