python, SQL, Tableau, R programming, Excel, Word, PPT, marketing

YUXIANG WANG

*** ******** ***, ****, **. Louis, MO 63130

314-***-**** https://www.linkedin.com/in/yuxiang-wang-a595b2178 adcz8c@r.postjobfree.com PROFESSIONAL SUMMARY

A self-motivated and highly adaptive Business Analytics student with a strong interest in data-driven problem-solving in fast-paced environments. Proven abilities in analytics tools, team-oriented approaches, and value-add strategies to achieve business objectives.

• SQL and Database

• Python

• R Programming

• Microsoft Office – Excel, ppt

• Data Visualization -- Tableau

• Predictive modeling

• Marketing research

• Communication

• Leadership

EDUCATION

WASHINGTON UNIVERSITY, OLIN BUSINESS SCHOOL, ST. LOUIS, MO Jul. 2019 – Dec. 2020 Master of Science in Business Analytics – Customer Analytics

• GPA:3.76/4 Degree qualifies for a STEM designation; eligible for 36 months of OPT (12 months OPT+ 24 months of extension) CAPITAL UNIVERSITY IN ECONOMICS AND BUSINESS, BEIJING, CHINA Sep. 2015 – Jul. 2019 Bachelor of Administration Management, Minor in Accountancy

• Overall GPA: 90.43/100(top 5%)

EXPERIENCE

NEAR SOUTH SIDE EMPLOYMENT COALITION, St. Louis, USA Feb. 2020 – May 2020 Marketing Consultant

• Updated database ensuring data integrity; cleaned and analyzed data in the past 3 years using Excel, SQL, Tableau to identify trends, get business insights; Assist client in improving website structure and content using WordPress.

• Proposed the marketing plan on social media (including Facebook, Twitter, Instagram), updated brochure, to obtain as many volunteers, employers and donors as possible; wrote final report and delivered presentation to the client. UK TRAFFIC ACCIDENT ANALYSIS, St. Louis, MO Nov. 2019 – Dec. 2019 Course Project, Big Data and Cloud Computing

• Analyzed large datasets to pinpoint trends and patterns of UK Traffic Accidents and extract meaningful insights. Researched factors that lead to severity and higher frequency of car accidents using bash code, Cloudera-impala, SQL and Tableau.

• Cleaned, processed and visualized data after combining information tables; interpreted results and created accurate predictions using Tableau. Based on results, provided insights on key findings and regulation suggestions. KANTAR TNS CONSULTING (WPP GROUP), Beijing, China Jan. 2019 – May 2019 Qualitative Research Intern, the Department of Marketing Analytics

• Interviewed 10+ customers about feedback on goods and services such as Airbnb, Lenovo GameBook, retail stores; summarized 100+ interviews, as well as collecting competitors’ data, and recommending targeted marketing strategy.

• Researched industrial information, designed survey, analyzed interview materials and drafted reports to support clients’ goals. Prepared final analysis report and Power Point presentation for leaders and Focus group participants. QIANSHAN CAPITAL MANAGEMENT CO., LTD, Beijing, China Jul. 2018 – Sep. 2018 Investment Manager Intern, Investment Management Department

• Analyzed the shareholder background, business model, analysis of competitive overlap, investment pros and cons, financial status and calculated quantitatively profit forecast of a company with Excel resulting in a successful investment.

• Prepared and conducted preliminary survey and evaluation on projects’ business plan; drafted due diligent report; and communicated project details and the background of team members with three founders ACTIVITIES/INTERESTS

UNIVERSITY STUDENT INNOVATION AND ENTREPRENEURSHIP TRAINING, Beijing Jan. 2017 – Mar. 2018 Project Leader

• Visited three community nursing homes to investigate their willingness to join the “virtual nursing homes” program and analyzed the demand tendency of the elderly for different services; Excel is used to visualize the conclusion. THE TASK PRICING OF “TAKE PICTURES, MAKE MONEY” 2017 The 10th Mathematical Modeling Challenging Contest, the second prize

• Utilized cluster analysis, correlation analysis and research method to analyze factors affecting task pricing. INTERESTS: Traveling, hiking, writing.

Contact this candidate