Zhenxu Liu

About Zhenxu Liu

Self-motivated Columbia Engineering student studying in Business Analytics, Data Science,…

Experience

1. Data Engineer

   CVS Health

   Feb 2023 — Present

   Led a strategic, long-term reengineering of robust data ETL pipeline leveraging GCS, Pub/Sub, Airflow (Python),Bigquery, and Dataproc (Apache Spark) for quarterly batch processing of 7M+ medical data with terabyte size fromEPIC Payer Platform, increased efficiency by 62% and cut costs by 71%• Optimized Bigquery SQL codes and migrated data from hierarchical data layer to conformance data layer, enablingefficient data modeling, schema design, and data visualization• Created streaming data ingestion pipeline utilizing Bigquery, Cloud Logging, and Cloud Function, for SCD Type IIdimension data warehouse for Aetna insurance, facilitating seamless member information update and integration;thrashing large dataset verification and deduplicating processes using hash key comparison• Designed and developed interactive dashboards and reports using Tableau, presenting both workflows performancemonitoring and business insights derived from cleansed and processed data• Developed a testing framework with Pytest that boosted code coverage by 30% across three teams, significantlyimproving code integrity and reliability

Education

• New York University

  Bachelor of Science - BS, Applied Psychology

• Columbia University

  Master's degree, Business Analytics