Xinrong Sarah Lian

An experienced and enthusiastic Analyst, troubleshooter and storyteller with 3 years' experience in advertising industry. Familiar with the entire data lifecycle, including data collection, cleaning, developing dashboards and reports.

Predicting Red Hat Business Value, 11/19, 12/19, Leveraged real world data to predict potential cooperative partners with the best business value for Red Hat., Cleaned customers' behavior data provided by Red Hat through data visualization and deleted redundant data., Detected multiple models in Machine Learning with Python to classify potential business partners., Conducted feature engineering in machine learning model; increased the model accuracy to an 85.6 AUC score. Disaggregation of Yelp Review Ratings, 10/19, 12/19, Separated ratings on Yelp by topic and explored which topics contributed to the ratings most., Applied Natural Language Processing (NLP) in order to extract topics from Yelp review texts and label different topics., Generated a sentiment intensity score for each sentence based on topic segmentation in Python., Disaggregated eight million reviews of restaurants in Las Vegas by generating coefficients of each topic in linear regression.