Yuke Luo

646-***-**** adey04@r.postjobfree.com LinkedIn.com/in/yukeluo

SUMMARY

Fast learner and multitasker with business analytics background and experience in data analysis and complex business problem-solving. Motivated to make progress and become a critical and valued member of the team. EDUCATION

College of William & Mary, Raymond A. Mason School of Business May 2020 Master of Science, Business Analytics GPA: 3.79/4.00 Penn State University May 2019

Bachelor of Psychology (Business Focus) GPA:3.51/4.00 TECHNICAL SKILLS

Python, R, SQL, data analyzing, data mining, machine learning, optimization, statistical computations, database management in Alteryx, big data, spark, Artificial Intelligence, data visualization in Tableau, Heuristic Algorithms, Web- scraping, Excel pivot tables, lookups and match functions, HTML, CSS, JSON PROJECTS

Major Telecommunication Company Cell Tower Placement Capstone April 2020 – May 2020

Web-scraped, cleaned and analyzed data by exploring missing data using time series in R

Predicted future population by uncovering top features using XGBoost and Random Forest model in Python

Optimized spending by locating most beneficial areas to build cell towers using Knapsack algorithm in Python

Visualized results by creating map of all possible locations using Tableau and ArcGIS Applied Data Science Capstone by IBM on Coursera March 2020 – April 2020

Extracted and cleaned data using Foursquare API to access geographic addresses and map coordination in Python

Analyzed data to split Williamsburg into several different neighborhoods and store information about each restaurant within the area in a data frame for further calculations

Predicted the best locations to open a restaurant in Williamsburg and show optimal areas on the map Database Management Project, College of William & Mary, Williamsburg November 2019 – December 2019

Collaborated with teammates to investigate public housing quality by collecting and cleaning raw data from various sources in SQL and Excel, to predict future inspection scores and provide suggestions for future development

Designed and optimized Data Warehouse by ETL (Extraction, Transformation and Loading) workflows utilizing Alteryx

Demonstrated data visualization and stories through Tableau to provide professional business insights EXPERIENCE

Wealedger Network Technologies Co.Ltd., Shanghai, China Data Analyst Internship June 2019 – July 2019

Collected data regarding coupons issuing and make a prediction of budget spending by time series in R

Designed an optimization model using Gurobi in Python for the budget spending on different types of coupons

Analyzed data for utilization rate of different types of coupons, sales rate of coupons sold, and popularity rate of various athletic activities, by utilizing lookup functions and pivot table in Excel

Planned a commercial strategy that maximizes the usage rate of coupons that are most popular and profitable in order to fully spend the 3 million RMB governmental investments CITIC Travel, Shanghai, China

Summer Marketing Analyst, Online Sales Department June 2017 – August 2017

Collected and analyzed data from similar or competing products of peer companies

Assisted with the development of data-driven product optimization using solver and goal seek in Excel ADDITIONAL INFORMATION

Leadership:

Table Tennis Club at PSU - President August 2015 – May 2019

Organized a ping-pong match annually within the club to encourage every member in the group keep passionate Research on Schema and False Memory – Researcher January 2017 – April 2017

Hypothesized people would have False Memory on specific items with their schema

Cleaned and analyzed all data using excel to calculate the p-value to determine the significance of the hypothesis Volunteer: Food Server – Participated in Westmoreland County Food Bank Inc.’s activity Certificate: IBM Data Science Professional Certificate; The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert Languages: Bilingual in English and Mandarin Chinese