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
Experience
08/2022 - Present
TD BankData 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 OntarioHonors 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
Technical Skills
Python
Java
C/C++
VBA
SQL
HTML / CSS
JavaScript / Node.js
jQuery
PHP
MySQL / SQL Server
Projects
![](https://img.icons8.com/plasticine/100/000000/web.png)
A minimal, clean, and responsive static website for planning, managing, and tracking all day to day activities.
![](https://img.icons8.com/color/96/000000/javascript.png)
If you are insensitive to color, this is the web game for you. It will randomly pop out an RGB value, and you pick the correct one.
![](https://img.icons8.com/color/144/000000/java-coffee-cup-logo.png)
A Java program for creating a visualization of Canadian cities.
![](https://img.icons8.com/plasticine/100/000000/database-options.png)
Provide a solution for resizing VARBINARY(max) images in the SQL Server database while retaining the original aspect ratio.
![](https://img.icons8.com/wired/64/000000/php-logo.png)
A simulated web-based medical system written in PHP. It allows end-users to perform CURD operations to a database through the website.