Management Data
Resume:
Ruyin Shi
**** ***** ******, *********, **, *****
Tel: 517-***-**** E-mail: **********@*****.***
EDUCATION
Michigan State University, Michigan GPA: 3.73
Aug. 2007- May 2009
? Master of Science in Statistics
? Major academic courses highlights: Multivariate and Time Series Analysis,
Stochastic Processes and Application
Beijing University of Science & Technology, China
Sep. 2003-July 2007
? Bachelor of Science in Applied Mathematics
EXPERIENCE
Research Associate, SAIC (Science Applications International Corporation)
Frederick, MD Oct. 2009- Present
? Forecast and monitor data trends, with Multicollinearity Detection and
Model Validation process, using Calibration model, Logistic Regression,
Exponential and Generalized Linear Model to determine drug combination
effects, present the reports to Senior Management team
? Examine irregularities in data, evaluate data using non-routine
statistical tests along with post-hoc comparisons utilizing the expertise
in SAS programming and STATISTICA as a team player
? Conduct Time Series Analysis using MATLAB and custom Excel Macros (VBA)
independently in order to extract meaningful characteristics of the data.
Identify Patterns in Time Series Data, conduct Lag analysis, evaluate the
model and use multiple models to forecast future events
? Create inventory dashboards to organize project resources enabling better
efficiency and enhance searching, writing SAS Macros and Excel
VLOOKUP/HLOOKUP codes for data merging, transformation, reformatting and
summarization, present to Senior Management team and gain approval for
projects as an example of resource control
Volunteer, Department of Finance, Univ. of Maryland, College Park, MD
Jan.2011-Present
? Work on projects regarding the linkage between Finance and Social
investment, including programming using MATLAB Financial Toolbox as well as
data management and analysis using STATA
? Use Marketing Mix Model including Time Series Model and Multivariate
Regression Model to forecast the data trend and evaluate the impact of
various marketing tactics, identify the strategy using Decision Tree
support tool
Research associate, Biomedical Research & Informatics Center (Internship)
Lansing, MI Jan. 2009-Oct. 2009
? Work on data cleaning, data management and quality control using SQL as
part of a 4-person effort for a national study of child Autism Spectrum
Disorders (ASD) funded by the Centers for Disease Control and Prevention
? Integrate, consolidate dataset in nearly 1 Terabyte data warehouse and
create Database Indexes
Financial Analyst, China International Trust and Investment Corporation
(CITIC) Bank (Internship)
Beijing, China May 2008- Aug 2008
?Assist in the development of Monthly Financial Statement including Return
On Investment (ROI) ratio calculation, effectively communicate with
portfolio managers and other investment analysts
? Use quantitative measures to monitor risk/statistical data, assess
historical trending and forecast the portfolio activity
? Assist in model developing to manage the downside and maximize the profit
from the portfolio to support the investment decision making process
? Assist in making Marketing Mix Decisions, focus on developing the Pricing
and Promotion strategy
Consulting Assistant, Center for Statistical Training and Consulting,
Lansing, MI Jan. 2008-Apr. 2008
? Create multiple questionnaires, use SPSS software to deal with practical
data manipulation, modeling and analysis problems. Compile reports and
graphs, present the reports to senior management team
HONORS/LICENSES
SAIC Annual Achievement Award
Nov. 2010
Candidate of FRM (Financial Risk Management)
Nov. 2010
Certificate of Level 1 of the CFA (Chartered Financial Analyst ) (35%
global pass rate) Jan. 2009
Certificate of SAS Base/Advanced Programming for SAS 9 with hands-on
experien
c
e
i
n
M
A
C
R
O,
S
Q
L
J
a
n
.
2
0
0
9
SKILLS/ACTIVITIES
Computer skills: SAS, MATLAB, SQL Server, STATA, Excel VBA, Access, C++,
SPSS, STATISTICA, R
Language skills: Fluent in English and Chinese (Mandarin)
Contact this candidate