Student
Developer
Photographer
Chef

Luca Zhou

I am a passionate software developer trying to build solutions to the world’s problems. Whether that be through creating machine learning models or building web applications, all my work is focused on one thing: impact. When I'm not coding, you can find me hitting the gym, taking picture with my Sony A6300, or practicing Chinese cuisine! Feel free to download my resume or contact me for a quick chat at lucazhoumc@outlook.com

Contact

Experience

08/2022 - Present
TD Bank

Data Engineer

  • Bringing conceptual and practical expertise to provide solutions and knowledge on a diverse range of tasks.
  • Leveraging strong programming skills on large datasets and big data technologies to develop data solutions and analyses.
  • Collaborating with business and technology partners to resolve data issues and ensure requirements delivery and compliance.
  • Testing the technical information systems to ensure data integrity and system functionality.
09/2020 - 04/2022
LBM Partner Services Inc.

Data Analyst

  • Implemented complex SQL queries to collect data from various databases and completed data cleaning with Python.
  • Performed data exploratory analysis and developed dynamic BI dashboards using Seaborn and SQL to present key business insights.
  • Structured and loaded 10 million rows of data into an Azure SQL database, reducing data redundancy and improving data integrity.
  • Utilized SQL stored procedures to automate clients’ daily reporting process and developed Python packages to optimize e-commerce website performance.
07/2019 - 08/2019
TRS Information Technology Co.

Back-end Developer

  • Collaborated with a team of 16 people to develop a data platform using Spring Boot, and completed tasks under tight deadlines.
  • Constructed Python scrapers to collect data from over 10 websites including macroeconomic, meteorological, national and industry statistics by using various libraries including BeautifulSoup, and Selenium.
  • Designed, deployed, and maintained a MySQL database based on the business team’s requirements.
  • Created detailed documentation of data processes by using markdown; utilized GitLab for version control and collaboration.

Education

09/2017 - 10/2022
The University of Western Ontario

Honors Specialization in Computer Science

  • Dean's Honor List in the 2018 - 2019 and 2019 - 2020 academic year.
  • Cumulative average of 86%, and A+ grades in Computer Science.
05/2022 - Present
Udacity, Inc.

Data Engineer Nanodegree

  • Learn to create relational and NoSQL data models to fit the diverse needs of data consumers. Use ETL to build databases in PostgreSQL and Apache Cassandra.
  • Create cloud-based data warehouses on Amazon Web Services(AWS). Store big data in a data lake and query it with Spark.
  • Schedule, automate and monitor data pipelines using Apache Airflow. Run data quality checks, track data lineage, and work with data pipelines in production.
09/2020 - 02/2021
Udacity, Inc.

Data Analyst Nanodegree

  • Learned the data analysis process of wrangling, exploring, analyzing, and communicating data using Python
  • Applied inferential statistics and probability to real-world scenarios. Leveraged A/B tests and built supervised learning models.
  • Gathered, assessed and cleaned data programmatically using Python to prepare it for analysis.
  • Implemented visualization principles to the data analysis process. Explored data visually at multiple levels to find insights and create a compelling story.
03/2021 - Present
DataCamp, Inc.

Python Data Scientist Track

  • Learned to import, clean, manipulate and visualize data using Python.
  • Obtained hands-on experience with pandas, NumPy, Matplotlib and Seaborn through interactive exercises and real-world projects.

Certificates

Data Analyst Nanodegree

Udacity Online Program
Feb. 2021

JavaScript (Basic)

HackerRank
11 Aug 2020

Python (Basic)

HackerRank
11 Jun 2020

Problem Solving (Basic)

Western University
11 May 2020

Technical Skills

Python

82%

Java

75%

C/C++

70%

VBA

75%

SQL

85%

HTML / CSS

75%

JavaScript / Node.js

70%

jQuery

60%

PHP

50%

MySQL / SQL Server

80%

Projects