Aaron (Yanjie) Wu, MBA

**** ******** *** ****, ***********, ON M1K 5J7 905-***-**** aczjzf@r.postjobfree.com

SUMMARY OF SKILLS

Top achiever in workplace and academic with strong leadership and analytical skills

4+ years of experience in Data Analysis, Marketing Analysis, and Reporting across industries

Strong quantitative and qualitative analysis skills in customers, products, and social media data

Creative thinker with strong problem solving skills; highly organized with attention to details

Excellent skills in Excel VBA, SQL, SAP, SAS Enterprise Miner, SPSS, Weka, and Google Analytics

Proficient in Excel (VBA macros, charts, regression analysis, pivot tables), Access

Excellent communication and teamwork skills; ability to communicate with senior management team

WORK EXPERIENCE

Marketing Data Analyst (1-year contract) March 2016 - Present

KE Solutions Inc. (an HR analytics consulting firm), Toronto, ON

Analyzed customer data, registration data to target potential customers; improved conversion rate by 20%

Analyzed social media marketing data to analyze trends and topics that attracted followers

Prepared monthly reports with KPIs to managers in analyzing client successful rate and project status and performance using Excel and SQL

Utilized CRM system to manage milestones, timelines, to-do lists and efficiently track and update the progress in career consulting projects

Maintained client databases; conducted data quality and data integrity checks in MySQL

Assisted in developing creative job search products: Jobster (a job recommender application) and RezMonkey (a resume ranking and visualization application) by using data mining and machine learning techniques

Assisted with project creation, status update reports and project evaluations

Tools Used: Excel, SQL, MySQL, in-house CRM application, Jobster, RezMonkey

Analyst January 2015 – December 2015

Hydro One Networks Inc, Toronto, ON

Analyzed 50 call clips and client account information daily through Witness system; summarized client requirements and account information efficiently for discussion and training purpose; significantly improved efficiency and quality of customer service

Extracted data from SAP and clustered issues by indicators

Led 11 call-a-customer training sessions and coordinated the schedules for 101 managers and executives

Monitored the training program using excel sheets and dashboards and updated the feedbacks from both managers and customers on SAP system

Assisted in designing the training binder, promotion flyer and PowerPoint slides

Tools Used: Excel, VBA, SAP

Marketing Manager May 2014 - December 2014

Mandi Grill, St. Catharines, ON

Improved restaurant branding and updated latest events through various social media platforms

Coordinated two large events during the 2014 FIFA World Cup in an attempt to attract new patrons while ensuring an innovative venue for existing clients as well

Improved quarterly sales by 10% in 2014 through in-depth analysis on current market trends

Initiated a strategic loyalty plan (the 10th order free) and increased customer base by 10%

Management Consultant June 2013 - December 2013

Oak Centre, Welland, ON

Assisted in the upgrading of all policies and procedures using a high attention to detail to fulfill the current legislative requirements and management directives

Enhanced overall efficiency for staff and clients by utilizing new technology and systems

Implemented a new filing system using Microsoft Excel to import and interpret client data

Assistant Manager August 2010 - August 2011

China Civil Engineering Construction Corporation, Saudi Arabia

Oversaw daily operations executing excellent time management skills by managing visa applications, tickets, rooms booking as well as other activities as required

Maintained the flow of information with the communication of all progress and reported new strategies during weekly meetings

EDUCATION

Master of Business Administration – GPA: 83% October 2015

Goodman School of Business, Brock University, St. Catharines, ON

Bachelor of Arts in Arabic Language and Literature June 2010

Beijing International Studies University, China

AWARDS & ACHIEVEMENTS

Outstanding Contribution Award of the Year, Graduate Business Council March 2015

Congeniality Award, Goodman School of Business August 2013

Winner of Case Simulation Competition, Goodman School of Business August 2013

TRAINING AND CERTIFICATIONS

Certificate of Success, Brock University July 2014

Recognizing students for excellence in their academics and extra-circular experience

Competition and Case Preparation Series, Goodman School of Business February 2014

Recognizing students for excellent case analysis and presentation skills

The Foundations in Leadership Practicum Series, Brock University December 2013

Recognizing students with excellent communication, problem solving and teamwork skills

Certificate in Arabic Language Studies May 2009

COMMUNITY ACTIVITIES

Hydro One Charity Fun Run, Sunnybrook Park, Toronto, Canada September 2015

Assisted the organizer in distributing the bib number and raffle ticket to the participants

Inside Ride, Hydro One Networks Inc., Markham, Canada September 2015

Raised $1000 for Coast To Coast Against Cancer Foundation through selling pizzas, cookies and lotto tickets

MBA Games Director, Goodman Graduate Council, Brock University, Canada June 2014 - December 2014

Improved number of applications for the MBA Games by 15% from the previous year through enhanced promotions including email announcements and classroom presentations

Raised $1000 in sponsorship from both internal and external partners by developing a comprehensive sponsorship mail-out and arranging new events with potential sponsors

Brock Cares Day of Service, St.Catharines, Canada September 2014

Worked with a team of 5 to paint the staircases saving costs for our community centers and allowing their funds to be distributed to those in need

Assisted seniors by articulating the resources available in the building

Contact this candidate