Python, SQL, Tableau, R, Splunk, Excel

Lei (Iris) Guo

Arlington, VA ***** 202-***-**** ***.***@*************.***.*** https://www.linkedin.com/in/leiguo47/ EDUCATION

University of Maryland, College Park College Park, MD Master of Science, Business Analytics (STEM) August 2017-December 2018 New York University New York, NY

Bachelor of Science, Major: Finance, Minor: Mathematics August 2013-May 2017 EXPERIENCE

Comcast Washington, D.C

Quality Assurance Analyst May 2019-Present

• Developed KPIs and descriptive statistical reports with Tableau for Xfinity Home Intelligence team to track performance metrics for camera objective detection algorithm

• Created interactive real-time dashboards on Splunk to share business insights and recommendations with product manager, enhanced reporting process efficiency by 20%

• Increased user group by 8% within a quarter by communicating with cross-functional teams, extracting data from multiple sources using SQL and performing ad-hoc analysis to identify customers’ needs

• Delivered data-driven presentation on key business problem on JIRA-based Scrum meeting monthly to help with the SDLC process

Freightos Miami, Florida

Part-time Data Analyst (Remote) September 2018-December 2018

• Extracted fright index (FBX02) and bunker fuel price historical data from Bloomberg terminal and applied Python script to transform unstructured data into structured data without missing values

• Implemented stepwise variable selection and feature extraction to improve model accuracy by 18%

• Built predictive models by applying machine learning and statistical techniques ranging from Linear Regression model to Random Forest model in Python, increasing adjusted R-squared from 0.51 to 0.90 Santander Bank, N. A Shanghai, China

Research Analyst Intern May 2017-August 2017

• Identified main research goal and designed research plan for each phase based on company vision after providing pre-market insights on new service offering

• Researched 35 websites within the E-commerce market and conducted competition analysis to improve company’s website

• Interviewed 10+ key stakeholders to reveal operational inefficiencies and undercover risks; reduced document preparation time by 50% during the partnership with Alibaba

• Analyzed both quantitative and qualitative customer survey dataset to generate recommendation report which has contributed to a 20% increase in online customer satisfaction PROJECTS

Microsoft SQL Server Database Management System February 2018

• Established the architecture of data warehouse through ER diagram in Lucidchart

• Executed ETL data pipeline with more than 10,000 lines of SQL queries and present searching outcomes through front-end website.

Airbnb Rating Prediction In-class Kaggle Competition March 2018-April 2018

• Cleaned original dataset which contains over 5 million meta data across 70 features and impute missing values with different methods

• Used R to Develop predictive model (Logistic Regression, SVM, Random Forest) which achieved 92% accuracy; helped our team to win 2nd place among 9 group NLP Analysis Using Yelp Review October 2018-November 2018

• Downloaded JSON format data from Yelp and set up in Python; tokenized reviews using TFIDF and 1-grams

• Achieved 83% accuracy in predicting polarity of a review through topic modeling, sentiment analysis and logistic regression

CERTIFICATION & SKILLS

• Certification: Google Analytics Individual Identification, Google AdWords Fundamentals

• Programming: SQL (Microsoft/ MYSQL), R, Python, Excel (VBA)

• Visualization: Tableau, Power BI, Python (plotly/matplotlib/seaborn), Excel

Contact this candidate