Sales Assistant

Zhang “Vivian”Guo

**** ******** ****, *** **** 612-***-****

Los Angeles, CA 90048 ******@*****.***

EDUCATION

University of Minnesota, Minneapolis, MN Aug 2013

Ph.D in Economics GPA: 3.732/4.0

University of Minnesota, Minneapolis, MN Jul 2012

Master in Economics GPA: 3.732/4.0

University of Toronto, Toronto, ON, Canada Jun 2008

B.S. in Economics and Mathematics GPA: 3.75/4.0

RELATED EXPERIENCE

China Southern Airlines, Los Angeles, CA

Economist 9/2012~present

Sales Analysis, Business Intelligence and Quantitative Method

- Collected data through the use of SQL

- Produced quantitative and qualitative trend analysis with statistical packages such as R

- Created dashboards with Business Intelligence Tools (Excel Spreadsheet, Pivot Table,

Tableau…) to help business keep track of important metrics

- Prepared demand forecasts based on factors such as historical performance and

seasonality

- Conducted performance review with major US travel agents to help them reach sales

target

- Worked with marketing department for product promotion (A/B test)

- Provided ad hoc analytical reports, including sales effectiveness, customer behavior,

Competitive Analysis

University of Minnesota, Minneapolis, MN

Research Assistant 6/2012~9/2012

Mathematical modeling and presentations of research findings 6/2011~9/2011

- Constructed mathematical models to analytically address economic issues

- Interpreted the model results in both quantitative and qualitative ways

- Presented research findings to faculty members on weekly basis

- Summarized existing literature and explored potential research topics

Graduate Instructor 1/2011~6/2012

Giving lectures on undergraduate courses and reporting official grades for a class of

40 students

- Taught undergraduate courses in Introductory Macroeconomics, Advanced

Macroeconomics and Chinese Economics

- Prepared lecture materials including slides and handouts

- Maintained course resource web page

- Designed grading scheme and assignments

- Gave guidelines to teaching assistants on grading and tutorial

- Held office hours for course work inquiry and consultation

- Reported official grades

Teaching Assistant 8/2008~12/2010

Organizing Tutorials and holding office hours for 3 classes with 40 students in each

- Organized weekly tutorials and graded for assignments/exams for a class of 40

students

- Gave feedback to instructors about students’ progress

- Held office hours for course work inquiry /consultation

- Worked with other teaching assistants discussing students’ course progress

EYE Investment Group, Changsha, China

English Trainer 6/2005~9/2005

Teaching English to a small class of students

- Taught English to a class of 20 students

- Focused on speaking

OTHER SKILLS

Computer Skills: SQL, Tableau, R, Microsoft Excel, Microsoft Word, Microsoft PowerPoint

Languages: English, Mandarin, Cantonese

HONORS AND AWARDS

2nd Place of Hardy Third Year Paper Competition, University of Minnesota, 2011

Summer Fellowship, University of Minnesota, 2009

The Herbert Mohring Fellowship, University of Minnesota, 2008

Professor William Kingston and Dr. John Kingston Award, University of Toronto, 2007

Faculty of Arts & Science Dean’s List, University of Toronto, 2005~2008

Margaret R Taylor and Thomas P Taylor Award in Math, University of Toronto, 2006

University of Toronto Scholar, 2004&2006

Professor RK Arnold Award, University of Toronto, 2006

Mary Keenan Award in Economics, University of Toronto, 2006

Simon Janes In-course Scholarship, University of Toronto, 2005

Bloor Lands Admission Award, University of Toronto, 2004

Contact this candidate