Sas Certified Advanced Programmer Resume
Newark, DelawarE
Skills and Certifications
SAS CertifiedAdvanced Programmer
SAS (Macro/SQL/STAT) 4 years hands-on experience
Data modeling/analysis (e.g. logistic regression, GLM, principle analysis, cluster analysis) using SAS
Excel (VBA/Pivot Table/function), MS-Office, SQL, UNIX, C++, Matlab, Eviews
Passed CFA level IIExam(Chartered Financial Analyst)
Education
MS
BS Mathematics
(National Mathematical Modeling Award)
Work experience
Confidential, Delaware, 09/2011-05/2012
Statistical Modeling (SAS):
- Used different models(mixed, glm, logistic) to evaluate the performance ofDuPont's products
- Conducted simulations of field data, test and control analysis to compare DuPont's products with others
- Conducted ad-hoc analysis, data extract for modeling purpose
- Created SAS modeling modules and macros to automate the analysis process
Reporting (SAS) & VBA:
- Create Excel VBA to automate the test and control analysis on dose response data
- Generated various graphs and tables for reporting using SAS, Excel
- Presented results of statistical analysis in group meeting and in meeting with clients
Project: DuPont's Compounds' Effects over Insects
- Built logistic regression model and used it to describe the factors influencing compounds' performance
Project: Compounds Activity Project
- Build model for dose-response analysis, and random effect model for variance component analysis
Research assistant, Confidential, Delaware, 12/2010-02/2011
Project: Market strategy analysis for an electronic product retailer
- Applied decision tree to make customer segmentation and detect influential explanatory variables
- Built and validated a logistic regression model to target potential customers
Intern, Confidential, China, 07-08/2009
- Merged card holders data tables and divided customers into groups following different criteria
- Assisted employees in producing seasonal reports
Awards
National Mathematical Modeling Contest Award (top 20/600)China, 2008
Awarded project: Evaluation Model of Various Designs of Lottery
- Calculated the distribution of hitting prizes and expectation of bonus for various designs
- Constructed a nonlinear optimization model and found the optimized solution
Selected projects
Cluster analysis of international portfolio diversification, University of Delaware, 2011
- Classified international stock markets based on the similarity of index returns
- Derived an optimum investment strategy usingMarkowitz algorithm
Empirical time series study on China CSI300 index,University of Delaware, 2011
- Calculated index return and volatility and selected AR-model for index return
- Fitted and compared various GARCH models on volatility of CSI300 index