Rachel Zhao

** ****** ******, ***** ****, ON, Canada M2N 0E1

LINKEDIN http://ca.linkedin.com/in/rachelzhaobiyuan CELL 778-***-**** E-MAIL aczjtd@r.postjobfree.com SUMMARY OF QUALIFICATIONS

l Solid computer skills in MS PowerPoint, Word, Excel (Formula, Pivot Tables, Vlookup, Macros) l Strong interest in marketing and data analysis; in-depth understanding of marketing research design and analysis

l Proficient in database software SQL, website analytics tool Ahrefs, and programming language R, SAS, and Python

l Professional written and oral communication skills, with the ability to distill complex issues into understandable terms and formats for a variety of audiences l Self-motivated, forward-looking, and detail-oriented team player capable of working independently l Excellent at problem solving, analytical thinking, and time management; strong ability to learn quickly l Fluent in English and Mandarin

EDUCATION

Master of Management Sauder School of Business Completed June 2016 University of British Columbia (UBC)

l Won 1st place in the Capsim Competition

l Course of Interest: Applications of Statistics in Management (93%), Marketing Research (90%), Managerial Accounting (89%), Economics (88%), Key aspects of Marketing (85%) l Relevant Projects:

Data analysis of “Microvan” survey result

o Determined the research objectives and strategies for the “Microvan” study o Examined the survey scaling and sampling schemes and organized the survey data using R o Created frequency distributions and histograms for each variable to identify outliers o Investigated the relationship among the 30 attribute variables and the target variable, tested the significance of coefficients between each two variables o Conducted factor analysis to decrease the redundancy in the attribute variables and constructed regression models with reduced factors

o Conducted the segmentation analysis using cluster analysis to identify the “ideal” customer for

“Microvan” to target

Bachelor of Science in Statistics & Life Science Completed June 2015 University of Toronto

l Double majored in Life Science (Health & Disease) and Statistics l Course of Interest: Practice of Statistics (93%), Statistical Computation (81%), Methods of Multivariable Data (85%), Experimental Design (87%), Biology (79%), Lab Health Disease (80%) l Relevant Projects:

Dataset Analysis using R

o Collected data from different sources; extracted raw data from data warehouse and analyzed the logic of the data ETL process

o Tested assumption for model fitting with corresponding plots and tests o Selected model that best represent the data (e.g. check R2, AIC, BIC, Mallow’s Cp) o Conducted analysis on missing or suspicious data using statistical tools o Selected proper diagnostic checking tools to ensure appropriate modeling fitted o Transformed data into analyzable forms (Box-Cox, power, linear) o Drafted comprehensive reports in a concise fashion WORK EXPERIENCE

Digital Marketing Analyst (Volunteer) WTC Tax Consulting March 2017 –Present l Researched and identified keywords of interest about taxation using Ahrefs to increase company web traffic

l Analyzed the data collected from Ahrefs and complete the “Keyword Summary Report” using Excel Student Consultant BC SPCA December 2015- May 2016 l Researched and collected relevant data from various sources (government, industrial, individual company reports) about project feasibility, compiled the gathered data in appropriate formats and presented to the clients with understandable language l Helped the organization to receive the Vancouver Foundation fund of $180,000 to support the launch of the project

l Conducted competitor research and product lifecycle analysis to prepare for the humane pest control project kickoff

l Developed a detailed five-year business financial projection and a break-even analysis l Constructed “Humane Wildlife Control Program Business Plan” and presented it to the team, the project supervisors, and the BCSPCA board of directors

Sale Representative Mobilicity June – September 2013 l Enhanced customer experience by informing them of phone products and services l Solved customer inquiries in a timely manner

l Integrated strategic plans to bring in more business l Supervised and provided coaching to three team members VOLUNTEER EXPERIENCE

Volunteer Alzheimer Society Manulife Walk November 2013 l Organized the guest list to expedite the checking process l Collaborated with other volunteers to assist in event preparation l Replied donors’ queries on site

Blue Crew Member U of T Student Union September 2013-May 2014 l Coordinated activities in Winter Week of Welcome, including club, summer job fair, student union concert, and street festival

LEADERSHIP

Founder U of T Fighting World Hunger 2013-2015 l Arranged charity events and organized donation for fighting world hunger organization l Scheduled weekly meetings

l Organized volunteer events for club members at the Scott Mission INTERESTS

l Swimming, Volleyball, Squash, Badminton, Yoga, Skiing, Snowboarding, and Traveling

Contact this candidate