Management Assistant

Yi Liu

**** ******** *** *** *, Pittsburgh, PA***17 Phone: 412-***-**** Email: *****@******.***.***

EDUCATION Carnegie Mellon University Pittsburgh, PA

H. John Heinz III College, School of Public Policy and Management May 2013

Master of Science in Public Policy and Management 3.88/4.00 GPA

• Relevant Courses: Management Science, Econometrics, Database, GIS, Spreadsheet Modeling,

Corporate Financial Reporting, Financial Analysis and Modeling, Financial Information and Valuation,

Data Visualization, Desktop Publishing, Strategic Presentation Skills, Advanced Strategic Writing.

Fudan University Shanghai, China

B.A., English Language and Literature 3.51/4.00 GPA July 2011

Second Major: Teaching Chinese as a Foreign Language

EXPERIENCE Steel Valley Council of Governments Homestead, PA

Database Designer & Analyst June 2012-August 2012

• Designed an Access database with Macro and SQL for property management; Researched for relevant law

articles, policy issues, economic implications and comparable systems.

• Communicated with municipal staff and members to populate the database.

• Performed initial data processing and analysis of a five-year fight-blight project.

The Walt Disney Company (Shanghai) Limited Shanghai, China

Marketing Coordinator for Disney Publishing June 2010-May 2011

• Coordinated major regional events and projects: Disney Consumer Products EXPO; Editing of Disney

Publishing Worldwide Catalog; Disney annual conference with licensees.

• Trained Disney colleagues and external PR staff to better demonstrate Disney’s e-products.

• Planned and executed Disney storytelling events; negotiated with vendors and event site managers for support.

International Channel Shanghai Shanghai, China

Production Assistant June 2009-August 2009

• Provided production support for a brand lifestyle TV program “City Beat”.

• Searched for program topics and contributed feasible filming ideas.

• Edited script for the program host, and assisted footage editing.

ACADEMIC

PROJECTS Systems Synthesis: Brownfield Redevelopment in the Monongahela Valley, 2013

• Identified trends in the industrial and non-industrial market demand, performed comparative regional analysis.

• Conducted labor force analysis and interviewed local employers and stakeholders in the community.

• Proposed a marketing plan and stakeholders engagement strategies to implement the project; addressed

stakeholders’ concerns.

National Consumer Expenditure and Behavior Analysis, 2013

• Used R Studio to conduct a quantitative analysis of consumer’s expenditure pattern across the nation.

• Customized different graphs to compare expenditure among different regions and categories.

Stock & Financial Statement Analysis – ExxonMobil and BP, 2012

• Analyzed ExxonMobil and BP’s financial statements; provided performance rating and investment strategies.

• Compared the implications of IFRS and USGAAP on financial statements.

LEADERSHIP

&ACTIVITIES Graduate Teaching Assistant for Professional Writing at Carnegie Mellon University 2012-2013

• Coached graduate students to improve their professional writing skills; Assisted class discussions and grading.

Disney Storyteller 2010-2011

• Read Disney stories and played games with pre-school kids at bookstores and child centers.

Deloitte Case Challenge 2011

• Worked with a team to solve a Medicaid case in two days, and presented the solution to the clients.

Editor-in-Chief, Twenty Somethings Magazine 2007-2009

• Responsible for the production of a student magazine. Made final editing and arrangement decisions.

PR Director, FACES-Fudan (Forum for American-Chinese Exchange at Stanford-Fudan) 2008-2009

• Led a team of four to raise operation fund; established strategic partnership with off campus sponsors.

SKILLS Language: English & Mandarin. TOEFL: 115/120; GRE: 800 Math, 620 Verbal.

Excel, Access Database, Stata, ArcGIS, R, SAS, Illustrator, InDesign, Photoshop, and Microsoft Office.

Contact this candidate