________________________________________________________________________________________________________________________________________________

EDUCATION

Ph.D., Economics; Minor, Statistics (expected May 2012)
Iowa State University, Ames, Iowa, USA
Advisor: Dr. John Beghin, Professor, Department of Economics, Iowa State University

B.S., Agricultural Economics (July 2005)
College of Economics and Management, China Agricultural University, Beijing, China

________________________________________________________________________________________________________________________________________________

EXPERIENCE

Data Analyst Intern (May 2011-Current)
PEMCO Mutual Insurance Company, Seattle, Washington

• Analyzed customer cancellation data to increase retention and help business decisions.
• Analyzed customer service data to improve contact traffic forecasting and service quality.
• Coordinated with teams to collect information, formulate project plans, and set goals.
• Re-structured data gathering categories to improve data clarity and better assist analysis.
• Applied both descriptive statistics and statistical models (cluster analysis, GLM, logistic regression) to identify trends and suggest actionable solutions.
• Presented reports to senior management team and executives.

Research Assistant (January 2010-August 2010)
Iowa State University, Ames, IA

• Conducted a meta-analysis to statistically analyze variations in estimated trade effects of technical barriers to trade. Applied multinomial logistic model and robust regression.
• Developed indices to quantify the protectionism of Maximum Residue Limit regulations.
• Built relational database in MySQL for efficient data queries and manipulation.
• Assisted advisor in obtaining project grant.
• Presented paper in department workshop.

Research Assistant (May 2008-August 2008)
Iowa State University, Ames, IA

• Analyzed the impact of ethanol expansion on land use with logistic model and Seeming Unrelated Regression (SUR).
• Collected and compiled data to build relational database in Access. Ran queries and extracted data for modeling.
• Presented the poster “Assessing the impacts of Bioeconomy Expansion on Food Product Area: a Case Study for the U.S. Midwest" at the 2008 Bio-based Industry Outlook Conference.

Teaching Assistant (August 2005-Decemeber 2009)
Iowa State University, Ames, IA

• Taught the Laboratory in Principles of Microeconomics (Fall 2006).
• Taught Mathcamp for master students (summer 2008).
• Graded homework and exams, instructed recitations, and held office hours.

 ________________________________________________________________________________________________________________________________________________

PUBLICATIONS & WORK IN PROGRESS

Li. Y., & Beghin, J.C. 2011. “A meta-analysis of estimates of the impact of technical barriers to trade.” Journal of Policy Modeling, forthcoming.

Li. Y., & Beghin, J.C. 2011. “A Protectionism Index for Non-Tariff Measures: An Application to Maximum Residue Levels.” Working paper.

 ________________________________________________________________________________________________________________________________________________

HONORS

Quinn Popcorn Foreign Trade Scholarship, Iowa State University, 2009

Finalist, 7th Annual Norman Borlaug Lectureship Poster Competition, 2008

Scholarship for Academic Excellence, China Agricultural University, 2002-2005

 ________________________________________________________________________________________________________________________________________________

TECHNICAL SKILLS

SAS, R, STATA, Matlab, GAUSS, Access, ArcView GIS, Excel

SQL, C, Visual Basic

 ________________________________________________________________________________________________________________________________________________

USEFUL LINKS

Look up movie and showtime in town

 ________________________________________________________________________________________________________________________________________________