Data Analyst Python
Resume:
Yuke Luo
646-***-**** **********@*****.*** 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
Contact this candidate