Accomplished ID generating script with Python, including duplicate, gap, and parity error checks. Processed more than 100,000 rows of geospatial data by concatenating data frames and detecting duplicates. Summarized and cleaned data by diagnosing and resolving anomaly values, and charted frequency tables for columns.

Pathloom | May 2022 - Aug 2022

Consumer Analytics Intern

Established customer relationship management (CRM) database by building relational tables in AWS RDS and MySQL to store consumer data from email activity and online surveys and by merging data into integration tables. Launched connections to automatically update consumer data from 3 platforms to CRM database by designing flows and retrieving data through customized application programming interface (API). Illustrated user email activity trends and insights by cross-joining JSON tables, creating charts, and organizing dashboards in Superset.

Shepherd Ventures | Jan 2022 - May 2022

Quantitative Analyst Intern

Applied Chi-squared test to identify the distribution of betas of stocks in S&P 100 as a normal distribution. Developed and modified codes with Python to select stocks for optimizing portfolios with the highest protection ratio.

Shanghai K&Z Construction Project Management Co., Ltd. | Sep 2020 - Jun 2021

Assistant Engineer

Arranged tasks of compiling plans and schedules for civil aviation airport construction projects to the team. Investigated and guided projects to launch and proceed as planned. Provided daily updated schedule to make Yutian Airport finished 3 months ahead of time.

Fosun Sinopharm (Shanghai) Enterprises Management Co., Ltd. | May 2020 - Aug 2020

Intern

Compiled contracts, bidding reports and agreements and completed contract settlements. Kept in touch with project managers to support with files and contracts remotely.

My Education

Take a look at my formal education

Master's degree, AnalyticsUniversity of Southern California | 2023

Bachelor's degree, Civil EngineeringTongji University | 2020

Create Your Data Portfolio for Free