Manyu (Joanne) Zhou

**** *. ****** **., *** Angeles, CA 90007 • 267-***-**** • acsgcn@r.postjobfree.com EDUCATION

University of Southern California, Los Angeles, CA Anticipated Graduation-December 2015 Master of Science in Business Analytics Cumulative GPA: 3.95/4.0 Drexel University, Philadelphia, PA Graduation-June 2014 Bachelor of Science in Business Administration (Finance) Cumulative GPA: 3.89/4.0 HONORS AND AWARDS

• 1st Place and $1000 prize in Traffic Collision Data Analysis Competition for the City of LA, 2015

• Dean's Scholarship, Drexel University, 2011-2014

• Dean's List, Drexel University, 2011-2014

• Beta Gamma Sigma Nomination, 2014 (Top 10% of Senior Business Students) CERTIFICATION

SAS Certified Base Programmer for SAS 9 (Certificate No: BP053116V9) September 2015 WORK EXPERIENCE

Pharmavite LLC. Northridge, CA

Demand Planning Intern June-August 2015

• Extracted marketing and supply chain data using business intelligence tool PowerPivot and prepared forecast matching check report and scorecard

• Analyzed the order driver and correlation among historical inventory, week of supply, POS and demand from different data sources using statistical techniques

• Created dynamic account forecast model by Excel and presented standard operating procedure to the team Citibank (China) Co., Ltd. Shenzhen Branch Shenzhen, China Operation Department Intern June-August 2012

• Organized and mailed bank or commercial acceptance bills to other banks and companies

• Checked the status of over 1000 electronic receipts per day using Citibank's internal system

• Recorded foreign exchange settlements per day using Microsoft Excel

• Optimized the process of detecting critical credit changes of Citibank’s institutional clients PROJECT EXPERIENCE

Traffic Collision Data Analysis, Los Angeles Department of Transportation February-April 2015

• Cleaned and organized 170,000 traffic collision records from the LAPD and Department of Transportation

• Detected factors of “greater risk” and visualized data into interactive format using Tableau

• Converted GPS records to real longitude/latitude and created heat maps of collision data locations using R packages “ggmap” and “ggplot2”

• Presented results to the LAPD to facilitate and maximize safety in traffic engineering for new locations Online Expedia Hotel Search Optimization, University of Southern California August-December 2014

• Managed and analyzed 1 million records of Expedia Hotel Booking Data from Kaggle (a platform for analytics competition), created ANOVA table to improve the relevance of online hotel search results

• Predicted the likelihood of online hotel click/book through binary logistic regression method in SAS Enterprise ADDITIONAL INFORMATION

• Software: Advanced Microsoft Excel/PowerPoint/Access; R; Tableau; SAS; SQL; Oracle Crystal Ball; JMP; IBM Lotus Notes

• Language: Mandarin Chinese, English

• Interests: Data Analysis, Hiking, Cooking, Playing Ukulele, Playing Ping Pong

Contact this candidate