Alex Chen Email & Phone Number

New York, Ny, Us

New York, Ny, Us

Toronto, Ontario, Canada

- Used dbt to build, manage, and maintain financially sensitive and broadly used data pipelines, including central order data pipelines.- Managed and deployed Python scripts, scheduled through Airflow, to ingest data via SFTP and API requests- Leveraged Snowflake tasks and Terraform to ingest data from external vendors through Snowflake shares- Engaged with stakeholders to build and design new data ingestion patterns and overhaul existing pipelines- Performed analysis on existing tools and pipelines, including source reconciliation, data integrity, data quality, query efficiency, data governance, and pipeline health.

New York, New York, United States

Develop and augment our Airflow infrastructure, responsible for over 1500 Python and SQL tasks, analyzing their run‐time and efficiency to ensure reliability and correctnessProcess, filter, validate, and otherwise manipulate data using PandasMaintain and optimize our SQL database, including schema design and ensuring maximum efficiency is extracted for queries and usage

Successfully created pipeline to generate synthetic training image data for parking space recognition, using in‐house simulation technologyCollaborated with multiple teams across continents to coordinate efforts and clear blockers in pipelineWrote data post‐processing scripts in Python to properly format images and labels stored in SQLite database

Implemented usability features for high level in‐house language for simulation specification, with underlying Python "compiler"Implemented error catching and debugging tools to pinpoint precise errorsAdded new and robust logging capabilities, debugged and tested across both synchronous and asynchronous use cases

* Created a data processing and visualization tool from scratch using Python, using matplotlib, numpy, scipy, and plotly* Automated tasks to run on a Linux server (Compute Canada)* Debugged and refactored C/C++ code base

Kanata, Ontaraio

* Spear-headed automated testing project, using Robot Framework. Additionally, wrote test libraries using Python, as well as utilizing Selenium and White libraries.* Contributed to existing C++ code base, including fixing bugs and extending features.* Along with supervising manager, jointly migrated company web project from .NET Core 1.0 to 3.0, modifying packages and C# code;* Wrote Microsoft SQL reposting scripts and pushed remote installs to virtual machines through Windows Shell Scripts.* Contributed to C# application’s (Windows Forms) event handling and GUI.* Exposure to features modifying IIS servers, Windows operating system, and COM/COM+/DCOM.

Waterloo, Ontario

New Westminster, British Columbia

Taught students across all grades in a wide variety of subjects. Particular aptitude for tutoring students with English as a second language or native Mandarin speakers.

Bachelor Of Applied Science - Basc, Electrical And Computer Engineering

Ib Diploma