Luo Yang
Dallas
Summary
Results-driven Data Analyst with a proven track record, enhancing data quality and efficiency through automated SQL scripts and successful migrations to Snowflake. Skilled in data visualization and pipeline development, utilizing robust analytical skills to provide impactful insights and driving significant improvements in error discovery rates.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Engineer
AT&T
Plano
11.2023 - Current
- Develop automated audit SQL scripts for Power BI dashboards to identify and resolve data discrepancies and quality issues. Successfully increased 30% error discovery rates and increased efficiency for data engineers.
- Lead multiple data migration initiatives from Teradata to Snowflake, including the successful conversion and optimization of 100+ Teradata SQL scripts for compatibility with the Snowflake environment. Executed parallel data validation to ensure accuracy and minimal disruption to business operations throughout the transition process.
- Optimize SQL stored procedures to automate manual data processing tasks, improve process efficiency up to 60%, and support scalable data workflows to replace inefficient and error-prone practices.
Data Analyst
CVS Health
Plano
01.2023 - 11.2023
- Performed tuning and optimization in data migration projects to transform existing Teradata SQL scripts to the Snowflake environment, resulting in 40% increase in efficiency.
- Developed complex SQL queries in Teradata to analyze over 10M+ pharmacy retail data to provide daily analytical reporting.
- Led the development of Power BI dashboards, contributing to a 15% improvement in operational efficiency for the Patient Convenience and Growth team.
- Delivered actionable analytical insights that shaped 10+ A/B mini tests, directly informing customer experience enhancements and leading to a 7% increase in patient engagement over three months.
Data Analyst
Capital One
Plano
01.2022 - 11.2022
- Worked with a banking client to provide business metrics reporting for Risk Management team.
- Constructed complex Python and SQL logic to transform 1M+ banking transaction data from Snowflake.
- Developed 15+ Tableau dashboards based on user-defined metrics, resulting in a 25% improvement in efficiency.
- Worked with business users to create 100+ interactive filters, parameters and calculations in Tableau dashboards and worksheets, which increased 15% usability.
Big Data Engineer / Data Scientist Consultant
AT&T
Plano
05.2020 - 12.2021
- Led the production cycle for machine learning models to detect fraudulent behaviors and customer health on Azure using Python and Azure Devops, which has resulted in 80% fraud detection and prevented 20 million dollars potential losses.
- Assisted in cloud migration projects - converting data sources from on-premises databases to Azure databases such as Delta Lake, developing pipelines on Azure Databricks and optimizing script runtime efficiency.
- Designed feature engineering pipelines used in Databricks and PySpark to support cloud migration from HDFS to Azure.
Education
M.S - Business Analytics
University of Texas
Richardson, TX05.2020
B.A - English
National Chengchi University
Taipei, Taiwan06.2018
Skills
- Languages: SQL (SnowSQL, Hive SQL, T-SQL, PL/SQL), Python (Pytorch), R
- Tools: Excel, Google Sheet, Hadoop, Spark, Hive, Microsoft Power BI, Tableau, Snowflake, Redshift, Postgres
- Skills: Data Visualization, Data Pipelines
- Cloud: Microsoft Azure, Databricks, Azure Data Factory
Certification
- Tableau Desktop Specialist Certification
Timeline
Data Engineer
AT&T
11.2023 - Current
Data Analyst
CVS Health
01.2023 - 11.2023
Data Analyst
Capital One
01.2022 - 11.2022
Big Data Engineer / Data Scientist Consultant
AT&T
05.2020 - 12.2021
M.S - Business Analytics
University of Texas
B.A - English
National Chengchi University
Similar Profiles
Elda BenitezElda Benitez
Sales Manager Representative at AT&TSales Manager Representative at AT&T
MURICEO FELIXMURICEO FELIX
Premier Service Consultant at AT&TPremier Service Consultant at AT&T
Brandon GrissomBrandon Grissom
Wire Technician at AT&TWire Technician at AT&T
Kathy ValladaresKathy Valladares
Associate Director at AT&TAssociate Director at AT&T
Casey AdesuluCasey Adesulu
Medical Assistant at OUI MEDICAL INCMedical Assistant at OUI MEDICAL INC