Data Analyst Business Analyst Python SQL Tableau

XINYANG(SHERRY) LI

925-***-**** ***********@*****.*** https://www.linkedin.com/in/xinyang-li Dublin, CA EDUCATION

M.S. Business Analytics (STEM), California State University East Bay, GPA: 3.7/4.0 Aug. 2018 - Aug. 2020 M.S. Marketing (STEM), Johns Hopkins University, GPA: 3.6/4.0 Aug. 2016 - Aug. 2017 Awards: Dean's Scholarship

B.E. Software Engineering, Minor: English, Dalian Jiaotong University, GPA: 3.5/4.0 Sep. 2010 - Jul. 2015 EXPERIENCE

Career Researcher Business Analytics TA Dec. 2018 - Aug. 2020 California State University - East Bay, Hayward

• Used REST API and Beautiful Soup to scrape the web data and loaded JSON file in a DataFrame

• Built Logistic Regression Models to select the key factors that contribute to a 32% higher employment rate

• Created plots using matplotlib to show key performance indicators (skills, experience, etc.) for a better visualization ECommerce Data Analyst Aug. 2017 – Aug. 2018

Anheuser-Busch InBev, Shanghai

• Implemented Time Series Seasonal MA model in Python to predict the monthly conversion rate and inventory, which reduced around $190K transportation and warehousing 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 for the integrated e-commerce large datasets in EDW using Tableau to help the sales, marketing, and logistic teams make smart decisions Digital Marketing Analyst Aug. 2015 – Jul. 2016

Pangu Network Technology, Shenyang

• Used clickstream analytics tools to diagnose conversion funnel (CTR, CVR) based on the industry trend

• Built SEO plan for clients which improved CTR by 23% and 50K incremental revenue

• Reported technical issues and presented strategic business solutions to clients

• Maintained multiple tables in the ERP System to record the information of transactions and clients PROJECTS

Interactive Brokers Dynamic Position Analysis Project July. 2020 – Aug. 2020

• Gathered data through REST API calls and automated web scraping using selenium

• Implemented automated pipeline using PostgreSQL to integrate and store data from multiple data sources

• Utilized Tableau and related JavaScript library to build interactive dashboards Groupon 2019 Q4 Gross Billing Prediction Analysis - Time Series Project Jan. 2020 – Feb. 2020

• Built time series models (regression-based, seasonal trailing MA, ARIMA, Holt Winter’s Models) for prediction

• Developed the best model with the lowest MAPE to predict the 2019 Q4 gross billing amount, which helped clients make buying decisions on Groupon stock before the release of the annual report Facebook Company Reviews on Glassdoor - Texting Mining Project Nov. 2019 – Dec. 2019

• Fetched and parsed HTML using Jsoup; Gathered the matching elements and tokenized the contents

• Pre-preprocessed the data using nltk and re to remove the indexing, stop words, punctuations, NAs, etc

• Implemented LDA model using Gensim for topic modeling to check the top words in each topic

• Developed Logistic Regression Model to get top 3 significant factors that affect negative reviews United Airline Review Analysis Jun. 2019 – Jul. 2019

• Gathered United Airline reviews data using Jsoup, and built data pipelines using MapReduce on Hadoop to extract features like date, seat type, and overall rating, etc. and stored in HDFS

• Loaded data to Hive, wrote HQL to analyze rating on 3k customers from 2018 to 2019;

• Found the top low rating factors and aggregated max, min, and the average rating for customers of each seat type SKILLS

Programming: Python R SQL Java HTML CSS JavaScript Shell Database: RDBMS (MySQL, MS SQL Server, PostgreSQL) NOSQL (Hadoop, MongoDB) Data Visualization: Tableau Power BI Matplotlib Seaborn Plotly HighCharts Tools: Spark Git VSphere AWS Jira Agile (SCRUM) ERP SPSS Google Analytics

Contact this candidate