Resume

Sign in

Data Sales

Location:
Williamsburg, VA
Salary:
70,000
Posted:
March 18, 2020

Contact this candidate

Resume:

Yuke Luo

646-***-**** adcchr@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 GPA: 3.74/4.00

Master of Science, Business Analytics Expected May 2020

Relevant Coursework:

- Machine Learning - Database Management - Optimization - Big Data

- Artificial Intelligence - Data Visualization - Heuristic Algorithms - Statistics for Management

Penn State University May 2019

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

TECHNICAL SKILLS

Data analyzing, optimizing and statistical computations using Python and R, database management in Alteryx and SQL, HTML, CSS, JSON, Microsoft Office including Excel pivot tables, lookups and match functions, Photoshop, Premiere, After Effect, Audition, Innovating through new and existing technologies

PROJECT

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 visualizations and stories through Tableau and provided professional business insights

EXPERIENCE

Wealedger Network Technologies Co.Ltd., Shanghai, China

Summer Analyst June 2019 – July 2019

Collected raw data from company’s internal system regarding issuing and make a prediction using linear regression algorithm in R to predict the consumptions of coupons provided by the government in Shanghai

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

Organized a technology summit in Shanghai for 200 attendees on the development of Blockchain in China by inviting industries such as financial, petroleum, gas, bank, etc to discuss Blockchain future

Programmed a website for new mobile application download with QR codes for both IOS and Android systems using HTML, JSON and CSS

CITIC Travel, Shanghai, China

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

Collected data and information regarding products on current visa application services in Taobao Mall (Tianmao.com—a business-to-consumer online retail operated by Alibaba Group)

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

Analyzed data from similar or competing products of peer companies to compare product advantage from the online store page views, conversion rate, length of stay, price setting, service items, etc

Designed a service-level-based pricing model for current products on visa application services

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

Conducted a research to experiment schema and false memory hypothesis

Cleaned and analyzed all data using excel to calculate the p-value to determine the significance of the result

Volunteer: Food Server – Participated in Westmoreland County Food Bank Inc.’s activity

Languages: Bilingual in English and Mandarin Chinese



Contact this candidate