Data Analytics Sql Server

Amber Zhou

Atlanta USA Phone: (***)-*** - **** Email: *********@*****.***

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.

EXPERIENCE

UPS Jun. 2019 ~ Dec. 2024

SQL/ETL Developer Atlanta, GA

•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.

Rentpath May. 2017 ~ Nov. 2018

SQL Developer Atlanta, GA

•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.

•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.

•Built standardized database workflows with Git version control, reducing conflicts by 40% and shortening development cycles by 3 days per sprint.

Wells Fargo Bank Oct. 2015 ~ Jan. 2017

Business Intelligence Developer Charlotte, NC

•Designed 40+ interactive SSRS reports, consolidated data from 3 different sources, maintained dashboards formatting with multi-parameter filtering, and interactive sorting, and published enterprise BI reports in SSRS, serving over 20 stakeholders' organizations wide.

•Optimized query tuning through indexing and optimization plan, reducing report rendering time by 15% for users across Finance and Operations.

•Collaborated with Finance and Marketing to develop an automated data integration solution that reduced quarterly financial reporting from 4 hours to 2 hours.

PROJECTS

我想告诉你的是 (C) Feb. 201x ~ May 201x

•总的来讲 实习和项目经验以三个左右为佳

•多花点时间好好描述 把用到的技术和遇到的麻烦反复练习如何去和面试官讲

•超过三个也不是不行 但是基本不会全被看到或者问到 容易分散重点

其实我这个 Project 要更屌 (Java) Jul. 201x ~ Aug. 201x

•写简历也要按照基本法

•如果你问我资瓷不资瓷你稍微吹吹牛逼

•我当然是资瓷的

EDUCATION

University of the Cumberlands-Williamsburg, KY, USA Jan. 2016 ~ Aug. 2017

M.S. Computer and Information Systems Security

University of San Francisco, CA, USA Aug. 2012 ~ May. 2014

M.S. International and Development Economics

SKILLS

Languages: SQL/MySQL, Python, HTML

Technologies: MS SQL Server, SSIS, Power BI, DBT, Snowflake, AWS, GCP, Git/Agile

Contact this candidate