Yi Du
( Columbia, MO, 65201
abhsxh@r.postjobfree.com ( Cell Phone: 1-573-***-****
SUMMARY:
. SAS Certified Advanced Programmer
. SAS, MatLab and R professional with an overall experience of three
years
. Possessing Masters in Econometrics and having experience in
Statistical modeling and forecasting. Experience in application of
OLS, GLM, Logistic Model, Probit Model, Tobit Model, ANOVA,
Multivariate Analysis, ARIMA, Non-parametric estimation, GARCH,
Bootstrapping, Monte-Carlo Simulation, Cointegration and Kalman
Filtering.
. Experience in SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ODS, SAS/STAT,
SAS/GRAPH, SAS/ACCESS, SAS/QC, SAS/ETS, SAS/FSP
. Experienced in data management, data extraction, manipulation,
validation, crunching and analyzing large sized data
. Extensive programming experience with proc SQL, proc report, proc
print, proc means, proc freq, proc summary, proc tabulate, proc
datasets, proc format, proc transpose, proc plot, proc chart, proc
compare, proc append, proc import, proc export, proc explode, proc
print and SAS/STAT procedures
. Far-reaching experience in with merging, concatenating, and
interleaving SAS datasets
. Broad knowledge in handling databases like Oracle, MS Access, SQL-
server
. Highly skillful in problem solving and delivering practical solutions
as an individual or in team environments
. Well organized, multi-tasking, detail-oriented with excellent
communication and customer service skills
TECHNICAL SKILLS
Platforms: Microsoft Windows, UNIX, Mac.
Computer Language: C and C++, R(S-Plus).
Software / Tools : SAS(SAS/BASE, SAS/ETS, SAS/STAT, SAS/IML, SAS/SQL,
SAS/GRAPH and SAS/Macro), SAS Enterprise Guide, SPSS, MatLab, VBA, Eviews,
STATA, Microsoft Office (Excel, Access, PowerPoint and Word) and LaTeX.
PROFESSIONAL EXPERIENCE
Economic and Policy Analysis Research Center
June 2009 - Present
Dept. of Economics, University of Missouri - Columbia
Graduate Research Assistant
. Analyzing large data sets and multivariate analysis using SAS, STATA,
R and MS-Excel(VBA and pivot table).
. Crafting Econometric models for forecasting the performance of
Missouri and Indiana labor force data set.
. Conducting Monte-Carlo simulation and building statistical models
(probit model, logit model, OLS) for predicting retirement behavior of
Missouri and Indiana school teachers. Further carried out
Bootstrapping to generate confidence intervals.
. Data mining and conducting queries using SQL from OSEDA (Office of
socio economic data analysis) data warehouse and other databases, such
as School and Staffing Survey and Teacher Follow-up Survey.
. Responsible for coding, design and develop different report templates
based on vice provost's requirements.
. Provide SAS programming support to the institutional research team in
data cleansing, scrubbing and extracting data.
. Developed reports using PROC REPORT, DATA _NULL_ and automated them
using SAS MACRO.
. Execute report programs and download the results into EXCEL for data
analysis.
. Created Graphical reports showing PIE and BAR charts for analysis
. Use SAS/GRAPH to generate the monthly, yearly and the history graphs
. Work extensively in sorting, merging, concatenating and modifying SAS
Data sets in different environments (Windows and UNIX).
. Use PROC SQL for querying and reporting and use SAS/STAT for
Statistical Analysis.
. Imported / converted data files from Excel, Word, Text Based Data
files into SAS Data Sets for analysis.
. Environment: SAS/BASE, SAS/SQL, SAS/MACRO, SAS/ACCESS,
SAS/GRAPH, SAS/CONNECT, MS-Excel, Oracle, MS SQL, UNIX, Windows
NT/2000
Nanjing University, P.R.China
September, 2005 - June, 2008
Research Assistant
. Conducted a research on developmental issues in East Asian countries.
EDUCATION
M.A. Economics University of Missouri-Columbia,
Expected May 2011.
Sepcialization: Econometrics and Quantitative Economics Minor: Statistics
M.A. Economics Nanjing University
2008.
B.A. Economics Nanjing Institute of Technology
2005
Certification: SAS Certified Advanced Programmer for SAS 9, SAS Certified
Base Programmer for SAS 9
Fields Of Interest
Econometrics ( Risk Modeling ( Time Series ( Corporate Finance ( Data
Analysis.
TEACHING EXPERIENCE
Dept. of Economics, University of Missouri - Columbia
January, 2009 - May, 2009
Teaching Assistant
. Teaching "Money, Banking and Financial Markets", grading homework and
taking class quiz.
RESEARCH PUBLICATIONS
A. Papers
. Sun, Ninghua, Du, Yi and Hong, Yongmiao, "Labor Market Distortion,
Efficiency Difference and Income Discrepancy Between Rural-urban
Areas", Management World, September, 2009.
. Du, Yi, and Sun, Ninghua, "Numerical Solution of Dynamic Stochastic
General Equilibrium Based on the RBC Model", Mathematics in Economics,
Volume 24(3), September, 2007:219-299.
. Du, Yi and Sun, Ninghua, "The Risk Formation of China's Derivative
Market and its Management", Finance and Economics of Xinjiang, 148(5),
October, 2007: 50-54.
B. Research Project
. Primary Investigator, Kellogg Rural People, Rural Policy Grant and MU
Extension, entrepreneurship and small business development in rural
America($5,000, Nov, 2010-Feb, 2011).
. National Social Science Youth Foundation research grant, Applied
Economics Program, research project entitled "Risk Formation of
Financial Derivative Tools and their Management".
AWARDS
. Excellent Graduate Student, Nanjing University, 2008
. Xu Jilian First-Class Prize Scholarship, Nanjing University, 2007
. First-Class Scholarships, Nanjing Institute of Technology, 2002-2004
REFERENCE
Available upon Request.