Data Analyst Manager
Resume:
Aijie Li
530-***-**** *****@*******.*** San Francisco, CA www.linkedin.com/in/aijieli/ https://github.com/Aijieli P R O F I L E
Professional experience in leveraging dashboard building, metrics building, as well as problem conceptualization to identify growth opportunities and build product/ customer-facing products with data-driven strategies in Internet and finance industry. Specialties: Data Analytics (SQL, Python, R, Stata, Excel), A/B Testing, Tableau, Statistical and Quantitative Modeling Certification: AWS Certified Cloud Practitioner, Tableau Desktop Certified Associate E D U C A T I O N
University of California, Davis San Francisco, CA
Master of Science, Business Analytics, STEM (3.8/4.0) Aug. 2019 - Jun. 2020 Nanjing University Nanjing, China
Bachelor of Science, Economics (4.6/5.0) Sep. 2015 - Jun. 2019 P R O F E S S I O N A L E X P E R I E N C E
Bird Rides, Inc San Francisco, CA
Data Analyst and Project Manager, Practicum Project Sep. 2019 – Jun. 2020 Collaborated with the unicorn by leading a team of 8 to launch a new feature predicting vehicle’s health for service center.
• ETL and Big Data Manipulation. Improved the data transformation runtime by 75% and enabled real-time prediction using Spark SQL to create efficient pipeline on Databricks with more than 200 variables and 460 million rows of data.
• Visualization. Improved monitoring efficiency for general managers by dynamic and interactive Tableau dashboards streamed from Databricks with vehicle engagement metrics reflecting the fleet performance.
• Modeling. Created a vehicle failure reflecting system with potential saving of $6 million by building engagement metrics and machine learning models (Survival Model and Logistics Model) using Python.
• Strategy. Guide analysis of scrapping 20K+ scooters by integrating scrapping metadata and leveraging cohort analysis. Guotai Junan Securities Nanjing, China
Quantitative Analyst Intern Jun. 2019 – Aug. 2019
Quantitative market research analysis to drive investing strategies in one of top 3 financial institutions in China.
• Recommended 3 companies of high potentials for stakeholders with insights extracted from perceptual maps with principal component analysis using R, market size prediction and competitive analysis.
• Enhanced stock price prediction model accuracy by 20% by adding time series analysis ARIMA into framework using R.
• Decreased manual workload by 75% by standardization and automation of routine week report via Excel VBA. GREE Electric Appliance Zhuhai, China
Quantitative Analyst Intern Jul. 2018 – Sept. 2018 Quantitative analysis to improve investment management for No.1 household appliance manufacturer in China.
• Improved operation management efficiency of 50+ subsidiaries by 75% by creating interactive Tableau dashboard with KPIs.
• Played a pivotal role in industry research by using word cloud and sentiment analysis to visualize company’s key strengths.
• Provided investment advice of $1bn acquisition plan by market analysis and due diligence of target company. D A T A S C I E N C E P R O J E C T S
Customer Relationship Management (CRM) of Venmo using PySpark
• Segmented transaction types by text analysis and leveraged RFM model (Recency and Frequency) and social network analysis (PageRank, clustering coefficients) to build metrics of the users’ transaction profile.
• Applied OLS model to predict the users’ first-year transactions volume with ~0.7 R-squared. Analysis of A/B Testing of Game Fun’s Banners Experiment using R
• Checked baseline rate of test and control group with two sample t-test and proposed solutions avoiding selection bias.
• Analyzed purchase rate to find ideal customer group and made recommendation to the improve revenue management. Web Analytics for MLB website using Adobe Analytics
• Built heavy-user dimension and identified the problems of low purchase intention with flow chart.
• Use A/B testing design to find the casual effect of initial purchase and make suggestions to MLB such as target promotion.
Contact this candidate