Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Amber Zhou

Atlanta

Summary

SQL/ETL Developer with extensive experience at UPS, adept at designing efficient ETL pipelines and optimizing data workflows. Proven track record in enhancing data processing efficiency and improving stakeholder satisfaction with precise data solutions. Proficient in MS SQL Server and SSIS, with a strong focus on data accuracy and operational reliability.

Overview

9
9
years of professional experience
1
1
Certification

Work History

SQL/ETL Developer

UPS
Atlanta
01.2019 - 12.2024
  • Architected ETL workflows processing 10 GB daily from GCP BigQuery, Oracle 19c, and flat files using SSIS with custom C# components
  • Implemented incremental loading that improved efficiency by 25% while handling 3x data growth
  • Transformed business requirements into optimized SQL solutions using SQL Server 2019/2022, implementing partitioned tables and indexed views, improving query performance by 15% and reducing manual SSIS jobs interventions by 20% overall
  • Managed 40+ mission-critical ETL jobs with SSIS
  • Monitored database activities using SolarWinds DPA and SQL Profiler, achieving 99.98% uptime through proactive monitoring and automated alerts, reducing incident resolution time by 30%
  • Supported zero-downtime migration from SQL Server 2019 to 2022 for 1.2 TB environment using Always On Availability Groups
  • Configured SSIS jobs post-migration, implementing Git version control and automated testing, reducing deployment errors by 40%
  • Resolved SQL and ETL-related issues for downstream stakeholders, collaborating closely with Product and Finance teams to achieve 99.5% data accuracy

SQL Developer

RentPath
Atlanta
05.2017 - 02.2018
  • Developed optimized T-SQL queries and stored procedures generating JSON business requests for Zuora cloud ETL, processing 1.2M monthly transactions with 99.8% reliability
  • Built fault-tolerant SSIS data transformation workflows that resolved inconsistencies affecting $500K in monthly billing revenue through proactive data quality monitoring
  • Enhanced system performance by 25% through advanced indexing strategies while implementing data integrity constraints and delivering 8 new business-critical features
  • Participated in cross-functional implementation using Agile methodology, achieving 97% first-time acceptance across all deliverables while consistently meeting project milestones
  • Established standardized database workflows with Git version control, reducing conflicts by 40% and shortening development cycles by 3 days per sprint

Business Intelligence Developer

Wells Fargo Bank-International Group
Charlotte
10.2015 - 04.2016
  • Optimized SQL Server 2014 database performance through indexing and optimization plan, reducing report rendering time by 40% for 200+ daily users across Finance and Operations
  • Designed 40+ interactive SSRS reports and maintained dashboards formatting with multi-parameter filtering, drill-downs, and interactive sorting for the Information Management and Analytics team
  • Maintained 99.8% uptime for BI infrastructure while developing modular SSRS solutions that reduced data refresh cycles from daily to hourly, integrating Salesforce, Oracle ERP, and legacy systems
  • Collaborated with Finance and Marketing to develop an automated data integration solution that reduced quarterly financial reporting from 2 days to 2 hours while improving accuracy from 92% to 99.7%
  • Published enterprise BI reports in SSRS, consolidating data from 5 systems and reducing ad-hoc report requests by 65%, serving over 30 stakeholders’ organization-wide

Education

M.S. - Computer and Information Systems Security

University of the Cumberlands
Williamsburg, KY, USA
08.2017

M.S. - International and Development Economics

University of San Francisco (USF)
San Francisco, CA, USA
05.2014

Skills

  • MS SQL Server 2015/2019/2022
  • SSIS/SSRS/Power BI
  • ETL development: SSIS/Snowflake/DBT
  • Cloud Platform: AWS/GCP
  • Programming: SQL/Python
  • Performance tuning
  • ETL modeling
  • Database troubleshooting
  • Version Control: Git

Certification

  • DeepLearning.AI Data Engineering at Coursera
  • Complete End To End Data Project Hands-On Guide at Udemy
  • Python for Data Science and Machine Learning Bootcamp at Udemy
  • The complete dbt( Data Build Tool) Bootcamp at Udemy

Languages

English
Professional
Chinese (Mandarin)
Native/ Bilingual

Timeline

SQL/ETL Developer

UPS
01.2019 - 12.2024

SQL Developer

RentPath
05.2017 - 02.2018

Business Intelligence Developer

Wells Fargo Bank-International Group
10.2015 - 04.2016

M.S. - Computer and Information Systems Security

University of the Cumberlands

M.S. - International and Development Economics

University of San Francisco (USF)

Similar Profiles

CREATE PROFILE