Management High School

Lei Li

**** ******* ****, ********* ** ***** Tel: 216-***-**** Email: *****@****.***

Please visit http://www.CodingSoFun.com to see my SAS/SQL/Excel/VBA codes and my Projects

OBJECTIVE

* Expertise in finance and computer programming, seeking job opportunities as finance/business/data analyst

HIGHLIGHTS

* Statistical Analysis including Survival Analysis, Logistic Regression, One-Way ANOVA, Two-Way ANOVA,

t-Test, Binomial Test, Chi-Square Test, Wilcoxon Signed-Rank Test, Wilcoxon Rank-Sum Test

* SAS Certified Base and Advanced Programmer for SAS 9, experienced in SAS programming including SAS/BASE, SAS/STAT, SAS/SQL, SAS/GRAPH and SAS/MACRO

* Microsoft Excel, Access, and VBA programming

* SQL programming, Microsoft SQL Server

* Web design and development using HTML, CSS, and JavaScript

* Financial Statements Creation and Analysis, Budgeting Preparation, Financial Modeling and Forecasting

SELECTED PROJECTS

* Credit Risk Modeling To Forecast Bank Borrower’s Default Probability

Built a model to estimate a bank borrower’s default probability by using logistic regression

Analyzed model by scrutinizing different statistical criteria; evaluated the model by using cross validation and by using internal and external data

Acquired extensive SAS programming techniques including PROC GLM, PROC TRANSPOSE, PROC FREQ, PROC REPORT, PROC GPLOT, PROC SQL and PROC DATASETS

* Investment Management

Managed a small cap growth mutual funds using various investment strategy to maximize funds return

Designed and created an Investment Portfolio database using Excel and VBA which greatly facilitated funds management. The database kept track of over 300 stocks and automatically optimized the weights of portfolio component. The database can be downloaded at http://CodingSoFun.com/VBA.html#2.

Optimized Stock Portfolio using Modern Portfolio Theory (MPT) & Capital Asset Pricing Model (CAPM) principles to leverage portfolio expected return and its risk

Analyzed management performance using various financial ratios including Sharpe Ratio, Jensen's Alpha, and Treynor Ratio

* Financial Valuation of Wal-Mart Store Inc.

Used various valuation methods including liquidation valuation of equity, discounted cash flow analysis, comparable company analysis and economic value added to value Wal-Mart Store Inc. equity and asset value

Interpreted company’s financial statements in detail and calculated/ forecasted its free cash flow ; applied Modigliani–Miller theorem in suggesting how to optimize a company’s capital structure and dividend policy

* Analysis of Factors Affecting First-Year College Students GPA

Built a multiple regression model using SAS to predict college students first year college GPA based on high school and SAT performance data in order to identify the best criteria for future students admission

Identified multicollinearity problems in the model and cleaned data to remove multicollinearity impact; acquired extensive SAS programming techniques including PROC REG, PROC TABULATE, PROC GLM, PROC MEANS and PROC TTEST

PROFESSIONAL EXPERIENCE

* Research Associate, Department of Chemistry, Case Western Reserve University 2008 - 2011

Laboratory management including instrument maintenance and training new users

Develop training programs for >20 people and lead on-boarding orientation schedules for new staff

EDUCATION

* MBA in Banking and Finance Case Western Reserve University, 01/2012

* PhD in Chemistry Case Western Reserve University, 05/2008

References available upon request

Contact this candidate