Jingyuan Cui

682-***-**** adchpw@r.postjobfree.com LinkedIn/gracecui

EDUCATION

Southern Methodist University, Cox School of Business Dallas, TX Master of Science in Business Analytics May 2020

Oklahoma State University/ China Agricultural University (Joint-Program) Stillwater, OK/ Beijing, China Bachelor of Science in Agribusiness, Minor in Marketing(s) June 2019 Awards: Honor’s Roll, Deans List (OSU, 2017 – 2018), Outstanding Graduate (CAU), Academic Excellence Scholarship (CAU) TECHNICAL SKILLS

SQL • Excel • R • Tableau • Power BI • Alteryx • KNIME • Python• Access • Shiny• SAS • Hadoop • Visio • Google Analytics PROFESSIONAL EXPERIENCE

Shanghai Zhiyewuya Education Technology Co., Ltd, a start-up company Shanghai, China Manager of Information System & Operation Coordinator Intern Jan 2019 – Mar 2019

• Created and executed a major project on reforming instructor recruiting system in salary and profile levels; coordinated seven online digital courses operations in class performance, student enrollment, and technological transmission

• Modified information system with new functions for student database access and improved business process

• Consulted with 200 students and provided test preparation plans for graduate admission China Daily Beijing, China

Regional Agent Intern—Marketing Analysis Aug 2016 – Dec 2016

• Analyzed marketing data, including commercials, communicated and negotiated with three subcontractors

• Completed 125 periodical sales digitally and off-line transactions to meet goal

• Managed periodical subscription and distribution, including journals, magazines and newspapers on campus SELECTED PROJECTS

Predictive Modeling – Class Project Dallas, TX

Data Scientist for a mock project Mar 2020- Now

• Analyzed a 70000 row game review metadata in Kaggles.com for better investing or updating advice of the game

• Clean data using machine learning, data mining and text analytics in R to filter valuable reviews for use

• Evaluate customer sentimental information by analyzing reviews and recognize advantage and to-be-improved creatures

Greystar – Program Capstone Project Dallas, TX

Data Scientist for Asset Performance Evaluation and Modeling Jan 2020- Now

• Remodel asset performance measurement by adding factors of general market conditions, competition, competitive pressures, macro and micro trends to improve compatibility and compliance of asset performance metrics

• Clarify the ROI calculation model using Machine Learning Techniques for better invest, upgrade, update, enhance and develop assets to bring in measurable value on business behaviors

• Simplify the prediction on impact of evaluated and predicted ROI on a future improvement investment with higher accuracy rather than current rear-view optics on the ROI based on financial metrics American Airlines – Data Visualization Course Project Dallas, TX Business Analyst for a Data Visualization Project Sep 2019- Nov 2019

• Led a 5-person group to set meetings, conducted research on airline revenue management and built analytic projects

• Visualized 4000 flight in 330 days and forecast risk and benefit in revenue management in flagged flights using Excel, Tableau, R and Alteryx

• Created dashboards for managing flagged flights for analysts in American to be aware, take action and report easier Pulp Pantry – Supply Chain Competition Case Dallas, TX Business Analyst for a Supply Chain Oct 2019- Nov 2019

• Directed and contributed to a 5-person team by developing comprehensive timeline and strategy

• Standardized a whole supply chain solution for a new chip product with optimum pricing strategy, bundles, pack amount and bag sizes based on marketing research on competitors

• Identified a new marketing explanation on wholesale purchase motivation and consumers’ shipping cost concern Applied Predictive Analysis – Class Project Dallas, TX Data Scientist for a mock project Oct 2019- Dec 2019

• Analyzed and manipulated metadata of 45,000 movies, 26m reviews from IMDB and kaggle.com

• Interpreted data using R and employed 2 different statistical models including linear and non-linear on movie ratings and profit creating 4 variables and metrics on simplified sub-datasets

• Assessed and compared the fit of different models to generate model reports and future movie investment forecast Database Management – Class Project Dallas, TX

Business Analyst for a mock project Oct 2019- Dec2019

• Deployed an R Shiny App for individuals to date similar profile users with register, edit and delete functions

• Designed UI functioning HTML structure, using ER-Diagram to analyze user profile and preference database

• Employed SELECT query to return data from the database, matched users with minimized weighted difference Standard Deviation algorithm

Oklahoma State University – Marketing Capstone Project Stillwater, OK Marketing Analyst for a mock project Aug 2017- Dec 2017

• Developed digital and off-line marketing plans for 12 local business in Oklahoma, including improvement on new products or services, solved marketing problems by interviewing shop owners and conducting research on them

• Won 1st place in a case competition of creating a marketing plan for an apparel shop in Tulsa, OK for its new online shopping program, including package, website style and shopping process automation design China Agricultural University Beijing, China

Undergraduate Student Researcher Sep 2016- Jun 2017

• Led Undergraduate Research Program Project, conducted with three people on topic of “Investment Opportunities during the Implementation-- Beijing- Tianjin- Hebei Integration”

• Visited and researched six farmlands, government and entertainment places in Beijing Area on residential needs, competencies and investment opportunities

• Published a research paper with the same name of the project in the Journal of China Agricultural University of a modern farm-park investment opportunity in Beijing area and proved it profitable