Student at Cornell University

Yifei Zheng

*** ****** ** *** ***, Ithaca, NY ***50

************@*****.*** 607-***-****

EDUCATION

Northwestern University, Evanston, IL Aug 2021 - Dec 2022 Master of Science in Analytics

Cornell University, Ithaca, NY Sept 2017 - May 2021 Bachelor of Arts in Information Science, Minors in Education and Psychology

• Cumulative GPA: 4.01 / 4.30 Dean’s List: Spring 2018, Fall 2018, Fall 2019

• Related Courses: Linear Algebra Multivariate Calculus Object-Oriented Programming & Data Structures Int. Design & Programming for the Web Machine Learning Learning Analytics Business Intelligence Systems

SKILLS

Programming/Scripting: Python R SQL MATLAB HTML CSS JavaScript PHP Software: Jupyter Notebook Tableau SQL Server SQLite Qualtrics Dell Boomi WhereScape Modeling: XGBoost AdaBoost Random Forest SVM K-Means KNN Regressions Neural Network HMM Interpersonal skills: Active listening: Certified mental health peer counselor Responsibility: CS course consultant Communication: Mentor at local programs Collaboration: E-board Member at Cornell Swing Dance Club

PROFESSIONAL EXPERIENCE

Cornell Biotechnology Resource Center, Ithaca, NY

Business Intelligence Analyst Oct 2020 – Dec 2020

• Designed and implemented a business intelligence pipeline for 420k order data with WhereScape and SQL Server

• Liaised with lab representatives to gather requirements on invoices, schedules, clients, and employee analysis

• Automated finance, efficiency, and lag reporting with customized filters by building fact and dimension tables

• Visualized the impact of pandemic on BRC’s finance, testing performance, and instrument utilization with Tableau

Axus Stationery Co. Ltd, Shanghai, China

E-commerce Intern June 2017 - Aug 2017

• Conducted customer sentiment and feedback reviews for 3 top-selling color pencil products on Taobao using Excel

• Reduced the number of negative comments by 16% with plans on product design, manufacture, and transportation

PROJECTS

Apple, Cupertino, CA

Data Scientist July 2020 - Sept 2020

• Analyzed account and app data in relation to 3.6 million transaction records with SQL Server and Python

• Engineered 5 dimensions and 20 features to segment 100k accounts with K-Means clustering models

• Tailored marketing strategies for 4 different account clusters according to user behavior

• Predicted bi-weekly transactions and revenue by fitting and tuning time series models (ARIMA and Prophet)

• Created Tableau dashboards to measure business health on account acquisition, engagement, and monetization

Electronic Arts, Redwood City, CA

Marketing Data Scientist April 2020 - July 2020

• Slashed advertisement cost by 66% and boosted revenue by $1.5 million with a new budget allocation plan

• Forecasted FIFA 16 conversion propensity with 0.956 AUC by analyzing and building models (XGBoost, SVM, Random Forest, etc.) for 700k FIFA 09-15 purchase entries in Python

• Presented key statistics and visualized insights regarding purchase behavior in Tableau

RESEARCH

Future of Learning Lab, Ithaca, NY

Research Assistant June 2019 - Present

• Developed an exploratory codebook and hand coded 700 MOOC intervention responses

• Investigated linguistic patterns in 75,000+ intervention responses through NLP topic modeling analysis in Python

• Examined intervention impact on MOOC outcomes with LIWC analysis, regression models (linear, logistic, and lasso), and statistical tools (t-test, MSE, etc.) in R

• Reviewed prior MOOC literature and co-authoring research paper

Contact this candidate