Evan Liu Email & Phone Number

Los Angeles Metropolitan Area

Developed and maintained data pipelines in python to perform automated ETL workExtracted data from sources such as Google Analytics, BigQuery, Fivetran, Teachable, Brandcycle, S3, etcUpdated and stored data into AWS Redshift and linked the data to LookerRefactored python scripts to meet business goals, and to be more efficientPerformed ad hoc analysis for QA purposes and for KPIsGuided teammates through projects and helped them develop their coding skills

Developed a cost progression for episodes of care with monthly episode shipments in PythonInvestigated impact of how Covid affected the cost of episode of care Implemented a Postgres database schema and tables to store annual historical dataRefactored python scripts to meet business goals, and to be more efficientPerformed ad hoc analysis for QA purposes

San Carlos, Ca

• Detected anomalies in AWS Lambda activities using a stacked model with GMM, SVM, and Isolation Forest• Implemented kNN clustering in Python using metrics from Kolmogorov–Smirnov test to reduce false positives

Novi, Michigan

• Validated data metrics for clients in the auto industry• Automated and calculated the process for clients to send targeted marketing• Analyzed high-volume data to identify and report trends• Created and implemented an employee rewards system• Trained interns in excel and SQL

• Calculated exponentials of matrices using partial fractions, differential equations, and series• Demonstrated that partial fractions can be used on specific types of matrices• Presented findings to professors and students in powerpoint created with LaTeX

Master'S Degree, Data Science

Bachelor Of Science - Bs, Financial Mathematics