Graduating in MS Business Analytics in Aug. 2020. Aspiring and meticulous data analyst with 2+ years of work experience. Experienced in building and analyzing statistics models and data visualization. Advanced Python, SQL, Tableau, R, and BI skills. Actively seeking full-time and internship Data/Business Analyst opportunities.
-
Experience
ECommerce Data Analyst Aug. 2017 – Aug. 2018
Anheuser-Busch InBev Inc, Shanghai
• Implemented time series seasonal MA model in Python to predict the future monthly conversion rate and inventory; reduced ~$190K the transportation and storage costs per month
• Optimized the advertising campaign using K-means Clustering to segment customers based on buying behaviors and demographic features; promoted with various advertising strategies respectively increasing ROI from 2.7 to 4.2
• Built real-time dashboard of the integrated e-commerce data in EDW using Tableau to help the sales, marketing, and logistic teams to make better decisions
-
Projects
Interactive brokers dynamic position analysis project Jun. 2020 – Present
• Gathered data through REST API calls and automated web scraping using selenium
• Implemented automated pipeline to integrate marketing data, options position data from interactive brokers, and yahoo finance, implemented dynamic position analysis using tableau.
• Utilized Tableau and related Javascript library to build interactive dashboards/charts.
Groupon 2019 Q4 Gross Billing Prediction - Time Series Project
Jan. – Feb. 2020
• Imputed missing values using SimpleImputer function of sklearn; Split the web-scarped dataset with 3 years (1095 data points) of growth billing data into testing and training sets for model training, validation, and predictions
• Built time series model (regression-based, seasonal trailing MA, ARIMA, Holt Winter’s Models) using the training set
• Developed the best model with the lowest MAPE and RMSE to predict the 2019 Q4 gross billing amount, which helped customers to make buying decisions on Groupon stock before the release of the annual report