SUMMARY

• Around 6 years of broad industry experience in data analysis and statistical modeling. Design, development of Statistical models including data extraction and manipulation, writing macros and reporting on various projects for Financial, Banking and Real Estate industries.
• Proficient in SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/REPORT, SAS/ASSIST, SAS/EG, SAS/EM, SAS/ODS and SAS/ACCESS.
• Hands on experience in financial/economic modelling and analysis.
• Experience in processing large datasets for data transformation including data cleansing, data scrubbing and applying business logic rules to incoming data.
• Strong skills in developing SAS programs for data analysis and working with analysis of variance (ANOVA), regression analysis, linear models, multivariate analysis, predictive solution models including linear, multiple, polynomial and nonlinear regression models.
• Comprehensive skills in working with SAS/BASE, SAS/SQL and SAS/MACRO in Windows environments.
• Skilled in merging SAS datasets, macro facility, preparing data, PROC step, producing reports, SAS formats, storing and managing data in SAS files.
• Expertise in advanced SQL programming for joining multiple tables, sorting data, SQL views and indices.
• Generate new datasets from raw data files imported or modify existing datasets using SET, SET/SET, MERGE, MODIFY, UPDATE, SQL, SORT and FORMAT.
• Plentiful regression experience in Logit, Probit and Time - series.
• Experienced in producing RTF, HTML and PDF files using SAS/ODS, well versed with creating HTML Reports for financial data using SAS ODS facility.
• Extensive experience in programming, debugging and report generation in SAS.
• Successfully using SAS Macro variables to improve efficiency and consistency of results.
• Proficiency in using MS EXCEL, VLookUp functions, MS access for presentations.
• Solid understanding of statistical concepts and econometric techniques. Proficient use of various statistical procedures including PROC CONTENTS, PROC FREQ, PROC MEANS, PROC TABULATE, PROC GPLOT, PROC G3D, PROC BOXPLOT, PROC UNIVARIATE, PROC STDIZE, PROC MI, PROC CORR, PROC GLM, PROC ANOVA, PROC FACTOR, PROC PRINCOMP, PROC LOGISTIC, PROC CLUSTER, PROC VARCLUS, PROC TREE and other SAS/STAT or SAS/GRAPH procedures.
• Comfortable with working under deadlines.
• Excellent communication and interpersonal skills for task accomplishment.

TECHNICAL SKILLS

• SAS (BASE/STAT/GRAPH/SQL/MACRO/ODS/ETL/ACCESS)
• SAS Enterprise Guide
• R
• C programming
• Outlook
• SQL Server
• Oracle
• MS Office
• Data Mining
• Machine Learning
• Statistical Inference
• Intermediate Accounting
• Operations Research
• Time Series
• Mathematical Analysis
• Financial Analysis

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

SAS Programmer

Responsibilities:

• Divided company announcements into 9 main categories and more than 100 subcategories according to their business characteristics.
• Retrieved stock price data from the company database for data preparation.
• Modified data using SAS/BASE, SAS/SQL and Macros according to project specifications.
• Used PROC STDIZE to impute missing values.
• Performed complex statistical analysis using PROC UNIVARIATE to check the data distribution of normality.
• Conducted hypothesis tests to examine the impact of company announcements with PROC UNIVARIATE, PROC FREQ, PROC TTEST
• Developed SAS Macros to simplify SAS code and effectively reduce coding time.
• Troubleshoot, diagnose of issues raised by data manipulation.
• Extensively used SAS procedures such as PRINT, REPORT, TABULATE, SUMMARY and DATA NULL for producing statistical reports.
• Used SAS/ODS facility to create customized reports in HTML, PDF, RTF.
• Documented data reports and model results, communicated with the team manager to share the information in a timely manner.
• Involved with key departments to discuss the primary model requirements for the project.

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ODS, MS Excel.

Confidential, Windsor, CT

SAS Programmer

Responsibilities:

• Created surveys to collect data including people’s education background, years of experience, age, marital status and immigration status
• Applied the Import Wizard to convert the spreadsheet which contains the survey data to a SAS data set with more than 10,000 observations and 14 variables.
• Used PROC UNIVARIATE to check distributions of each variables and deleted missing values by performing SAS conditional processing
• Utilized PROC TRANSREG to perform Box-Cox transformation on dependent variable so that the model assumptions were satisfied.
• Ran PROC REG to fit the model and identify signification variables by checking their P-values.
• Used SELECTION= FORWARD option to conduct the forward stepwise regression model and eliminated those insignificant variables
• Performed PROC UNIVARIATE, PROC AUTOREG and PROC SGSCATTER to check error term’s distribution of normality, autocorrelation among error terms and multicollinearity among independent variables
• Generated highly customized reports in the form of HTML, RTF and PDF using SAS/ODS, PROC REPORT, PROC TABULATE.

Environment: SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/EG, Excel, SAS/ACCESS, Windows.

Confidential, NYC, NY

SAS Programmer / Statistical Assistant

Responsibilities:

• Extracted data from the database using SAS/Access, SAS SQL procedures and created SAS data sets
• Calculated the real estate market metrics including house price growth to rental price growth ratio and real estate investment growth to GDP growth ratio.
• Created new datasets from raw data files and modified existing datasets using SET, MERGE, MODIFY, UPDATE and conditional statements.
• Extensively used SAS SQL procedure for join and union of tables.
• Applied SAS procedures such as PROC REPORT, PROC TABULATE, PROC FREQ, PROC MEANS, PROC SUMMARY
• PROC UNIVARIATE for checking missing values/outliers and producing statistical summary report.
• Analyzed Large database tables and huge SAS data sets, wrote monthly/weekly/daily summary reports on the real estate market.
• Developed and automated many SAS-SQL scripts processes for data file generations.
• Created reports using PROC REPORT, PROC TABULATE, ODS statements and PROC TEMPLATE to generate output formats in HTML.
• Demonstrated Aptitude at working on multiple projects simultaneously

Environment: SAS/BASE 9.2, SAS/BASE 9.1, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/ODS.

Confidential

SAS Programmer

Responsibilities:

• Collected data from surveys regarding questions about people’s satisfaction with 13 different aspects and their overall satisfaction with airports’ services.
• Performed data cleansing with PROC STDIZE and checked distributions of data with PROC UNIVARIATE.
• Fitted the data with ordered logistic regression model and used PROC Logistic to implement the model
• Generated reports and graphs with PROC REPORT, PROC TABULATE, PROC FREQ and PROC GPLOT.
• Utilized PROC FORMAT to customize the reports and graphs.
• Examined VIF for each variables to see if multicollinearity exists using PROC REG

Environment: Base SAS, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/ACCESS, MS Excel.

Confidential

SAS Programmer

Responsibilities:

• Extracted data from the company database with PROC SQL and generated new tables with keyword JOIN.
• Modified existing data sets using SET, MERGE, MODIFY, UPDATE and conditional statements.
• Utilized PROC DATASETS to list detail information for all the variables
• Checked outliers and missing values using PROC UNIVARIATE and PROC FREQ.
• Employed macros to improve coding efficiency.
• Designed customized formats for each report with PROC FORMAT.
• Generated market campaign performance reports with PROC REPORT.
• Translated descriptive business language of market campaigns into standard coding language which could be further processed by the technology team.
• Collaborated with the marketing team and technology team to fulfill more than 100 real-time marketing campaigns.

Environment: Windows, SAS/BASE 9.2, SAS/STAT, SAS/ODS, SAS/GRAPH, SAS/REPORT, MS Excel, SQL.