Alex Zhao Email & Phone Number

Naperville, Illinois, United States

• ETL Pipeline:o Designed and built ETL pipelines to ingest, process, and store millions of rows of data from various sources with cost saving and efficiency in mind.o Built Sub/Pub and CRON based pipelines to ingest raw data from sources such as MSSQL, CSV flat files, and external APIs using AWS SnS, AWS Lambda, and AWS DMS replication tasks. o Built pipelines using Python, PySpark, AWS Glue, and AWS Step Functions to process and enrich the ingested raw data.o Used AWS Redshift, AWS S3 (using HIVE Partition), AWS Glue Catalog, and AWS Athena to provide efficient solutions for storing and accessing the enriched data.o Reviewed queries by PowerBI dashboard builders and other data consumers to ensure efficiency and security.o Provided data analysis and insights to business users such as Finance, Accounting, Transportation and Sales.• Held weekly office hours to aid Jr. Engineer with troubleshooting and reviewing architectural designs for future projects. • Supported the Scrum team by providing architectural guidance, conducting code reviews, approving git pull requests, and solving daily issues as a tech lead.

Los Angeles, California, United States

• Data Pipeline and Cloud Infrastructure:o Designed and built pipelines to ingest, process, and store clinical data for research and model training using Python, AWS S3, AWS Lambda, AWS Batch, Docker, and MongoDB.o Used AWS VPC to build VPN and access control for users across teams.o Built cost efficient storages and databases to store metadata, annotations, and raw data files using AWS FsX, AWS S3, and MongoDB.o Used AWS VPC to configured subnets for data separation per FDA requirements.o Used other AWS services to build an ecosystem of cron-jobs, backups, notifications, and other microservices to ensure data availability, integrity, and security.o Built and maintained a Data Dashboard to report on data collection status and data quality.o This project was recognized by the company for increasing data ingestion efficiency, reducing storage cost by 50%, and improving data quality.• Aided in research and model training by developing tools to annotate and process Transcranial Doppler (TCD) exam data.• Built APIs to access data analysis results.• Worked directly with customers to discuss data quality, feature updates, and process improvements.

Santa Ana, California

• Configured and maintained NIST required security for all CAM systems.• Upgraded and maintained all CentOS Linux operation system to support latest software and security requirements.• Troubleshooted PCB manufacturing machinery errors.• Implemented and managed LDAP database to authenticate all CAM users.

Orange County, California Area

• Developed and implemented web and backend applications using PHP, PostgreSQL, and Laravel MCV Framework.• Used frontend technologies including JavaScript, CSS, HTML to edit and update new and existing web pages. • Tested and deployed new projects using Github, Envoyer deployment tools, and following scrum development processes.• Maintained legacy projects based on daily error reports.• Developed and maintained projects such aso APIso Online Registration o Payment Gatewayso Internal Scripts used for: User management, Data gathering and calculation, Sending bulk notification emails. o Generate sales report by writing SQL queries and exporting to an excel file. • Used raw SQL queries to edit tables, update data, and select information from tables.• Trained new Developers on existing systems and business logic.

Master'S Degree, Computer Science (Big Data Concentration)

Bachelor'S Degree, Computer Engineering With Minor In Mathematics