Katherine Li

About Katherine Li

Katherine is a master student studying data science at Columbia University. She is specialized in data visualization using Tableau and PowerBI. She loves solving complex business problems, such as the Kaggle project she recently worked on, predicting Airbnb rental pricing.Katherine has worked at Business Insider as a business analyst. This experience empowered her skills in presenting KPIs, data visualization, and analysis to derive insights that enable effective decision making and can be leveraged by leadership to drive sales performance. She improved her explanatory and predictive analytical skillsets in R while analyzing subscriber churn. She also gained more practice in database management, such as extracting real-time data from Google Analytics through API.Besides, Katherine’s undergraduate education in mathematics and economics prepared her to thrive as a data analyst, with an analytical mindset and strong business acumen. Moreover, her five-year professional experience as an admission representative equipped her with outstanding sales and people skills.Katherine is advanced in business intelligent reporting in Tableau, R(Shiny), Looker; Advanced in explanatory, predictive, and prescriptive data analytics: Python (seaborn, scikit-learn, pandas), R(dplyr, tidyr, ggplot2, tidytext, caret, rpart, ROCR, RandomForest, gbm), Advanced Excel; Experienced in Database management and Database design: MySQL, MSSQL, Oracle SQL, Star Schema; Advanced in Feature Engineering and Selections: Regression, Correlation, Clustering Analysis.

Experience

1. Data Product Manager Intern

   Tencent

   Jun 2020 — Present · Shenzhen, CN

   Conducted value-based customer segmentation, utilizing machine learning logistic regression algorithms, deployed the classifier in cloud architecture• Designed data product feature and collaborated with front & back end engineers to implement product plan• Formulated industry-focused sales strategies based on user analysis of more than 500K business customer data, increasing unique visitors of new feeds by 38% within 3 weeks• Predicted and quantified product benefits to perspective costumers based on company scale, industry, and interest in product features

Education

• DePauw University

  Bachelor of Arts in Economics, Math and Communication Minor

  2015 — 2019

• University of International Business and Economics

  Summe School , International Economics, Multi-Variable Calculus

  2017 — 2017

• Columbia University

  Master's degree, Applied Analytics

  2019 — 2020

• The University of Edinburgh

  Visiting Student Experience Seeking, Finance, Linear Algebra, Econometrics

  2017 — 2018