Marketing Data

Qi (Vicky) Luo

Los Angeles, CA ***** 424-***-**** *****@***.*** www.linkedin.com/in/qi-luo-vicky EDUCATION

University of California, Irvine, CA. GPA: 3.8 Rank: N/A 06/2017 Henry Samueli School of Engineering& Paul Merage School of Business Master of Science, Engineering Management

Relevant coursework: Statistics for Business and Economics, Design & Analysis of Algorithm, Analytical Decisions Models, Marketing Management, Quantitative Research Methods Xiamen University, Fujian, China. GPA:3.7 Rank: 2/43 06/2016 Master of Engineering, Mechanical Manufacturing & Automation Relevant coursework: Matrix Theory, Numerical Analysis, Effective Presentation Skills Southwest University of Science & Technology, Sichuan, China. GPA: 3.7 Rank: 4/400 06/2013 Bachelor of Engineering, Mechanical Design Manufacturing & Automation Relevant coursework: Multivariate Calculus, Statistics & Probability, Linear Algebra, VB programming TECHNICAL SKILLS & APPLICATIONS

Proficient in MS Excel (solver, analytical solver platform), Azure, R, Git, SQL, Tableau, Minitab, Mathematica, C++, C# Certificate in C Language, National Computer Rank Examination (NCRE) Grade 2 Strengths: Analysis, Data Mining, Database Design, Problem Solving, Collaboration, Presentation Language: Proficient in English, Advanced in Chinese PROJECTS & EXPERIENCE

PARKER AEROSPACE, Irvine, CA 01/2017-03/2017

Data gathering, Quantitative analysis, Five force analysis, SWOT analysis Recommended M&A target companies for Parker Aerospace aligning with "More Electric Aircraft" industry trend.

• Analyzed Aerospace industry (five forces analysis) and Parker Aerospace (SWOT analysis and Product & Technology expansion analysis) to identify key core products and adjacencies focus.

• Gathered raw data from Paris Airshow website and Farnborough Air show website.

• Using Excel, developed a quantified evaluation system for grading 800+ target M&A companies.

• Delivered and presented detailed profiles and brief "name cards" of top 4 companies to the “Strategic Planning/M&A” group executives of Parker Aerospace. RVCA, Costa Mesa, CA 09/2016-12/2016

Data gathering, Data visualization, Market research, Survey design Delivered a business plan for RVCA to strengthen existing markets and to expand to new markets.

• Using Mintel business database, Actionwatch and Survey Monkey tool, conducted extensive market research and analyzed consumer demographics and psychographics for determining the best positioning strategy to maximize product efficiency and effectiveness.

• Using Excel, extracted and visualized data to deliver a marketing plan of increasing brand recognition and identifying potential new target markets to the VP of Marketing of Billabong. Salary Forecast for Baseball Player Howie Kendrick 09/2016-12/2016 Data gathering, Data analysis, Multiple regression, Time series forecasting

• Gathered statistics of 100+ players in 2015-2016 season, including Howie, from MLB.com and Databaseball.com.

• Using Minitab regression module, narrowed 30+ variables down to 6 variables to get a convincing salary calculation model with R-square 0.94 and P-value 0.00.

• Using Minitab time series forecasting module, forecasted Howie Kendrick’s specific statistics in next season. HANJIANG MACHINE TOOL CO., LTD., Shanxi, China 07/2014 – 06/2016 Database Design, Mathematical Modelling, Software Developing (National Project, Funding: $180,000)

• Created mathematical models of complex curve surface for interpolating the grinding trajectories.

• Using MFC of Microsoft Visual C++, developed a set of indexable insert grinding software for 5-axis CNC machine (ZMK7150).

• Applying Microsoft Office Access database techniques, developed product management database connecting with database manipulation area on the software interface.

• Published 3 related research papers in several academic journals and international conference.

Contact this candidate