SUMMARY

• Over 6 years of broad industry experience in data analysis and statistical inference. Design, development of Statistical models including data extraction and manipulation, writing macros and reporting on various projects for Financial, Banking, Insurance, Investment and Sales industries.
• Proficient in SAS/BASE, SAS/STAT, SAS/ETS, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/INSIGHTS, SAS/ASSIST, SAS/EG, SAS/EM, SAS/ODS and SAS/ACCESS.
• Hands on experience in financial/economic modelling and analysis.
• Handled large datasets for data extraction, transformation and applying business logic rules to incoming data.
• Comprehensive skills in working wif 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 indexes.
• Generate new datasets from raw data files imported or modify existing datasets using SET, SET/SET, MERGE, MODIFY, UPDATE, SQL, APPEND and HASH.
• Experienced in random sampling using SAS functions and PROC SURVEYSELECT.
• Plentiful regression experience in Logit, Probit, Panel and Time - series.
• Experienced in producing RTF, HTML and PDF files using SAS/ODS, well versed wif 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.
• Thorough experience in data extraction and sorting from various databases like Oracle, DB2 and MS Access
• 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 wif working under deadlines.
• Excellent communication and interpersonal skills for task accomplishment.

TECHNICAL SKILLS

• SAS/BASE
• SAS/STAT
• SAS/ETS
• SAS/MACROS
• SAS/SQL
• SAS/ODS
• MATLAB
• STATA
• MAPLE
• MS WORD
• MS EXCEL
• MS POWERPOINT

PROFESSIONAL EXPERIENCE

Confidential, OKC, OK

SAS Programmer

Responsibilities:

• Involved wif key departments to discuss teh primary model requirements for teh project.
• Retrieved clients’ data from teh bank’s intranet system for data preparation.
• Modified data using SAS/BASE, SAS/SQL and Macros according to project specifications.
• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC GPLOT, PROC REG and PROC GLM to check teh data distribution of normality and homoscedasticity.
• Used PROC STDIZE to impute missing values.
• Classified discrete and continuous variables using PROC CLUSTER and PROC VARCLUS respectively.
• Performed variable screening using PROC CORR.
• Sketched teh LOGIT graphs to check teh linearity of teh response and predictors.
• Performed logistic regression using PROC LOGISTIC.
• Used PROC SCORE to implement model validation.
• 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.
• Prepared and published various performance reports and presentations.
• Documented data reports and model results, communicated wif teh team manager to share teh information in a timely manner.

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ODS, MS Excel, MS Visio, MS Project, Oracle, PLSQL Developer, UNIX.

Confidential, Watchung, NJ

SAS Programmer

Responsibilities:

• Used PROC/SQL to fetch tables from Teradata warehouse.
• Merged tables by using PROC SORT.
• Random sampling using PROC SURVEYSELECT.
• Performed logistic regression on each variable and tan delete teh redundant ones.
• Used APPEND to generate teh outcome variable table.
• Checked outliers and missing values using PROC UNIVARIATE and PROC FREQ.
• Macros were employed for data transformation and filling up missing values.
• PROC VARCLUS was used to check teh collinearity among explanatory variables.
• Performed logistic regression on newly selected variables.
• Created LIFT probability table and GAIN chart.
• Model monitoring and verification

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

Confidential, Tulsa, OK

SAS Programmer / Risk Analyst

Responsibilities:

• Created new datasets from raw data files using PROC IMPORT and modified existing datasets using SET, MERGE, MODIFY, UPDATE and conditional statements.
• Involved in developing, testing, and writing programs and reports in SAS according to specifications as per required.
• Performed extraction, transformation and loading (ETL) from large Oracle tables.
• Extensively used SQL procedure for join and union of tables.
• Worked on pre-existing macros for data validation by checking data distribution and comparison to standard empirical distribution.
• Performed data cleansing by identifying and eliminating missing values, outliers and inaccurate data using PROC FREQ, PROC MEANS, PROC COMP, PROC UNIVARIATE and PROC RANK.
• Transferred and migrated data from one platform to another to be used for further analysis.
• Generated highly customized reports in teh form of listing, HTML, RTF and PDF using SAS/ODS, PROC REPORT, PROC TABULATE.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/STAT, SAS ETL, SAS/EG, Excel, UNIX (SOLARIS), Windows, Oracle.

Confidential

SAS Programmer / Statistical Assistant

Responsibilities:

• Imported Data from relational database into SAS files as per detailed specifications.
• Calculated risk factor for individual clients based on hierarchical demographical information.
• Assisted Structuring teh WOE index for categorical variables.
• Extensively used SAS procedures such as PROC REPORT, PROC TABULATE, PROC FREQ, PROC MEANS, PROC SUMMARY and PROC UNIVARIATE for checking missing values/outliers and producing statistical summary report.
• Carried out data extraction and data manipulation using PROC SQL to create preferred tables as per business requirements.
• Developed and analyzed periodic forecasting reports using MATLAB and SAS tools.
• Prepared graphs using teh modified tables for analysis.
• Successfully used SAS/STAT to perform ANOVA, MANOVA and Contingency Table analysis.
• Generated Reports, Summary tables, Charts and Graphs for different users using SAS/Graph and SAS/ASSIST component.
• Performed competitor and customer analysis, risk and pricing analysis and forecasted results for credit card holders on demographical basis.

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

Confidential

SAS Programmer

Responsibilities:

• Model specification and variable selection.
• Collected data from various sources including UN and World Bank archives.
• PROC SQL was implemented intensively for joining tables.
• PROC REPORT, PROC TABULATE, PROC FREQ and PROC GPLOT was used to generate report and graphs.
• PROC TSCSREG was used for panel regression.
• Granger Causality Test was performed and residual vectors were read into SAS by using PROC IML.

Environment: Base SAS, SAS EG, SAS/Access, SAS/Connect, SAS/Stat, SAS BI Enterprise Server, SAS/Graph, SAS/SQL, SAS/ODS, SAS Macros, MVS, JCL, Oracle 9, DB2, PL/SQL, Teradata, MS Excel.