Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Terry Leng

Los Angeles,CA

Summary

Experienced Data Engineer with 9+ years in data engineering, data warehousing, and big data analytics on AWS and Azure. Skilled in creating ETL pipelines, dashboards, and automation workflows using Python, Apache Airflow, Power BI, QlikView, Tableau, and SSRS. Proficient in data architecture design.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Sr. Data Platform Engineer

Avidxchange, Inc
07.2023 - Current
  • Lead system requirements gathering, specification creation, and effort estimation
  • Designed and implemented Data Lake and big data analytics platforms using AWS & Azure
  • Developed automated ETL pipelines using Python and Apache Airflow
  • Utilized Docker for containerization and Azure DevOps (YAML) for CI/CD pipelines
  • Maintained version control and code deployment with GitHub
  • Delivered interactive dashboards using Power BI and QlikView
  • Environment: AWS, Redshift, S3, Python, JIRA, SQL, AWS Athena, Apache Airflow, Azure DevOps, GitHub, Visual Studio Code, YAML, Docker, Power BI, Qlikview

Sr. Data Engineer

JP Morgan Chase
04.2022 - 07.2023
  • Conducted data mining on large datasets using complex SQL for executive reporting
  • Automated ETL processes using Python and SAS, storing data in AWS S3
  • Built analytical dashboards with Tableau and Excel
  • Collaborated cross-functionally using GitHub, JIRA, and cloud data platforms
  • Environment: SAS, Excel, AWS Redshift, Tableau, Python, Teradata, Snowflake, Alteryx, SQL, GitHub, MSSQL Server, JIRA

Sr. Data Engineer

Hewlett Packard, Inc
01.2016 - 03.2022
  • Delivered data integration solutions using Python, Airflow, and SQL on AWS
  • Migrated and cleansed large datasets into Redshift and Snowflake
  • Built insightful dashboards and reports using Power BI and Tableau
  • Participated across all phases of SDLC and architecture design
  • Environment: AWS, Redshift, S3, EC2, ER-Studio, Python, JIRA, SQL, Tableau, Power BI, GitHub, Snowflake, Airflow, SSIS, MS SQL Server 2008 R2/2012

Data Warehouse Developer

Prometheus Lab (Nestle)
02.2015 - 12.2015
  • Wrote advanced SQL queries and stored procedures for data transformations
  • Built predictive dashboards in QlikView for sales forecasting and trend analysis
  • Managed over 100 Power BI reports including server maintenance and scheduling
  • Developed reports using SSRS and integrated with SQL Server
  • Environment: MS SQL Server 2008 R2/2012, SSMS, SSIS, SSAS, SSRS, SQL, QlikView, Power BI

Education

MBA -

University of Southern California
12.2021

MS - Computer Science

National University
06.2014

BBA - undefined

University of Macau
06.2011

Skills

  • Cloud Platforms: AWS (Redshift, S3, EC2, Athena, Managed Airflow), Azure (DevOps)
  • Data Engineering: Python, Apache Airflow, SSIS, SQL, SAS, JIRA
  • Databases & Data Warehouse: AWS Redshift, AWS Athena, Snowflake, MySQL, MSSQL Server (2008 R2/2012)
  • Business Intelligence & Reporting: Power BI, Tableau, QlikView, Looker, SSRS, Excel, Google Analytics
  • Machine Learning & AI: TensorFlow, Facial Image Processing, NLP
  • Version Control & CI/CD: GitHub, Azure DevOps, Docker, YAML
  • Other Tools & Technologies: Visual Studio Code
  • Data modeling: ER Studio

Certification

  • Deep Generative Model, Stanford University
  • Machine Learning with Graph, Stanford University

Timeline

Sr. Data Platform Engineer

Avidxchange, Inc
07.2023 - Current

Sr. Data Engineer

JP Morgan Chase
04.2022 - 07.2023

Sr. Data Engineer

Hewlett Packard, Inc
01.2016 - 03.2022

Data Warehouse Developer

Prometheus Lab (Nestle)
02.2015 - 12.2015

MS - Computer Science

National University

BBA - undefined

University of Macau

MBA -

University of Southern California

Similar Profiles

CREATE PROFILE