Luna Wang
Digital Marketing/Strategic Analyst/ Business Analyst/ Product Manager/
Talent Acquisition Analyst
LATEST PROJECTS
Team Leader, Kaggle R Project: Amazon Women’s E-Commerce Clothing
· Cleaned and analyzed 23,000 online reviews from Amazon women’s E-commerce Clothing dataset
· Used text mining, sentiment analysis, and built predictive model to visualize the age distribution, popular departments, most common review words in order to provide some recommendations to the Amazon sellers
· Worked closely with group member to deliver presentation in class to explain the insights and recommendations behind the results
· Organized and supervised bi-weekly meeting with teammates for catch up and absorbed the feedback from them in order to improve the project quality
Project | 01
Strategic Analyst, Capstone Project: Digital Marketing for Incremental Sales
· Conduct thorough analyses of Evenflo’s business models, market landscape, strategic direction and news on a weekly basis
· Identified the key variables from in-depth analysis of Amazon advertising, built accurate forecast model and drew the correlation between inventory and order units
· Compiled data and findings into reports and presentations and provide recommendations to senior leadership
Project | 02
Business Analyst: SQL Project: Flight Delay Forecast
1.Determine project goals and design functional tables that are beneficial to customers, analysts, and different groups of people on the board of directors to more easily extract information
2.Design an entity relationship model to link flight delay information with the relationship between departure and destination, and use Metabase and Tableau to visualize the chart
Project | 03
Project Manager: NLP Project: Quora Text analysis
Used Simhash, Topic Modeling and Taxonomy to analyze negative feedback from Quora platform
Project | 04
Python Project: Yelp Review Analysis
-
Analyzed 5200K’s customers' reviews from 174K business and figured out reasons why customers loved or disliked the restaurant.
-
Cleaned the categorical column and implemented Support vector machine model to get score of each word
-
Visualized the distribution of reviews by category and rating through using seaborn packages and provided the suggestions to restaurants based on top 10 negative and positive words in 7 cuisine type on presentation
Project | 05
Group Project: Uber Strategy Analysis
-
Evaluated the current Uber’s situation through SWOT, PESTLE, Porter’s Five Forces and Blue Ocean strategy
-
Formulated a new strategy, self-driving delivery through multi-sided platform, insight Matrix and strategic roadmaps