SUMMARY

• 5+ years of professional experience of SAS programming for data analysis, coding and implementation.
• Expertise in SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/SQL.
• Experience in SAS Enterprise Guide 4.1, SAS Enterprise Miner 4.3, SAS Risk Dimensions 5.5.
• Experience in the BI Suite in SAS including SAS OLAP Cube Studio, SAS Web Report Studio.
• Skilled in SAS programming, merging SAS datasets, preparing data, producing and validating reports, SAS formats, and managing data.
• Expert in using report generating procedures (PROC CONTENTS, PROC PRINT, PROC REPORT, PROC TABULATE, PROC FORMAT, PROC FREQ, PROC UNIVARIATE, PROC SUMMARY, and PROC TRANSPOSE).
• Expert in generating ad hoc reports, tables and graphs for presentations and data modeling using SAS Web Report Studio.
• Experience in using SAS/STAT procedures like PROC ANOVA, PROC GLM, PROC REG, PROC CORR, PROC TEST, PROC RANK, PROC NPAR1WAY, PROC LIFETEST, PROC PHREG and PROC ANOM.
• Experience in using SAS/STAT for data modeling and predictions.
• Experience in dynamic programming and list processing using SAS/MACRO.
• Excellent programming skills in joining, merging and extracting data from various databases using SQL and PROC SQL.
• Experience in using SAS/GRAPH procedures like PROC GPLOT, PROC GCHART and PROC BOXPLOT.
• Expert in using the ODS facility to create HTML, RTF, XML and PDF files.
• Experience in Integrated Summaries of Efficacy (ISE) and Safety (ISS) according to Statistical Analysis Plan (SAP) and protocols.
• Risk Management: Market Risk (VaR modeling (Historical, Delta Normal, Delta Gamma, Monte Carlo), Credit Risk (Default probability estimation based on (Historical, bond price, CDS spread, Black - Scholes Merton’s model), CVA risk, Credit VaR, Scenario and Stress testing), Operational Risk, Liquidity Risk, Leverage Risk, BASEL II and III.
• Excellent communication, analysis and people skills.

TECHNICAL SKILLS

• SAS 8/9
• Base SAS
• SAS/MACROS
• SAS/ACCESS
• SAS/GRAPH
• SAS/STAT
• SAS/SQL
• SAS/ODS
• SAS OLAP Cube Studio
• SAS Web Report Studio
• SAS Enterprise Guide
• Information Map Studio
• Print
• Report
• Tabulate
• Format
• Freq
• Univariate
• Means
• Summary
• Transpose
• Anova
• Glm
• Mixed
• Reg
• Corr
• Ttest
• Rank
• Boxplot
• Gplot
• Gchart
• Gmap
• Capital IQ
• Bloomberg
• Operating & strategic planning
• Staffing model & resource planning
• Sharepoint
• Databases (Oracle
• SQL)
• MS Excel
• Access
• PowerPoint
• MS Word
• MATLAB
• @Risk
• StatTools
• Price sensitivity analysis
• Variance analysis
• Trending & statistical analysis template & procedures sensitivity analysis stress analysis
• Gap analysis volatility analysis

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

SAS Programmer/ Data Analyst

Responsibilities:

• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS and Excel
• Developed and implemented quantitative models to measure enterprise widerisk including interest rate, credit risk, operational risk and market risk.
• Worked on data for VaR calculations using various methodologies (Historical, Linear, quadratic and Monte Carlo).
• Assisted in the development of the firm’s Loss Given Default, PDs and EADs methods.
• Recommend risk mitigation activities such as setting maximum exposure limits, establishing covenants, and selling position.
• Maintained large data sets, combining data from various sources in varying formats to create SAS data sets and/or ASCII.
• Performed scenario, sensitivity analysis and what-if analysis.
• Worked onSASETS Software econometric and time series techniques for modeling, forecasting, simulating business processes; modelingriskfactors to predict economic outcomes for various scenarios and using time stamp data to predict trends.
• Created complex and reusable Macros and extensively used existing macros.
• Developed SAS programs for data cleaning, validation and generated ad-hoc reports for raw datasets using Print and Report procedures.
• Developed safety listings, tables and plasma concentration graphs for clinical study team and bio-statistical team review
• Attended project team meetings and collaborate with various stakeholders including Risk Analysts, Project Managers, Business Analysts and other stakeholders.

Environment: SAS 9.0, SAS Risk Dimensions 5.5, SAS/MACROS, SAS/SQL, SAS/Graph, SQL, SAS/STAT, MS Office, Oracle, and Windows NT.

Confidential, Hartford, CT

Data Analyst

Responsibilities:

• Developed validated and maintained SAS programs for validation, manipulation, analysis and reporting of large volume of data as per the business requirements
• Modified data in several ways using various procedures like Proc transpose to obtain the desired format.
• Modified existing SAS programs and created new programs using SAS macros to improve ease and speed of modifications as well as consistency of results
• Read both worksheets into SAS data sets and compared the data for any discrepancies. Worked on manipulating data to be used as input to Microsoft Excel.
• Experienced in SAS Business Intelligence area and in-depth knowledge of SAS BI including OLAP Cube Studio, SAS Add In for MS Office, stored processes
• Created SAS data sets by extracting data from Oracle tables via an ODBC connection using SQL PASSTHRU facility in SAS/ACCESS (and writing SQL queries)
• Verified and validated data accuracy to improve the overall accuracy of customer records, product data and other information
• Worked on resolving production issues, debugging procedures for existing SAS code. Generated highly customized reports using PROC FORMAT, PROC REPORT, PROC TABULATE and ODS HTML

Environment: SAS 9.1.3/8.2, Base SAS, SAS/MACROS, SAS/ETL, SAS/ ACCESS, SAS/SQL, Information Map Studio, Oracle 9i, SQL Server, MS Excel, Windows XP/2000

Confidential

Data Analyst

Responsibilities:

• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data
• Created complex and reusable Macros and extensively used existing macros and developed SAS programs for data cleaning, validation
• Generated ad-hoc reports for raw datasets using Print and Report procedures.
• Delivered data dumps for Data Management before database lock.
• Developed safety listings, tables and concentration graphs for research team and RADAR scientists team review