SUMMARY

• Around 7 year of Extensive IT experience in Data Analysis, Design & Development in the Finance, Banking & Insurance domains.
• Hands on experience using SAS as data management and statistical analysis tool in retail bank, Mortgage, credit card, insurance and other financial services.
• Core technical expertise in design, development and debugging SAS programs and Macros to query, extract and manipulate large datasets, perform statistical model analysis, produce files, tables, listings, graphs, reports using SAS/BASE, SAS/STAT, SAS/SQL, SAS/ACCESS, SAS/MACRO, SAS/ODS, SAS/ETS, SAS/GRAPH, SAS/AF, SAS/FSP, SAS/CONNECT, SAS/SQL, in Windows and UNIX environment
• Advanced skills on data cleaning and manipulation using PROC procedures such as PROC SUMMARY, PROC SORT, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC FORMAT, PROC TRANSPOSE, PROC PRINT and many SAS data steps such as ARRAY, MERGE, SET, etc.
• Strong exposure to all steps of project life cycle such as original data collection, secondary data query, data manipulation and analysis, Optimizing, summary of findings, develop analysis indications; communicate strategic insights and presentation of results.
• Hands on Experience on SAS Visual Analytics (VA)
• Experience creating ad hoc reports as per requirements.
• Thorough Knowledge and experience of Microsoft Office tools like MS Access, MS word, MS PowerPoint, and MS Excel.
• Good experience in CCAR, DFAST, PPNR Stress Test Data model.
• Strong analytical skills that include insight on successfully applying technological solutions and best practices to resolve business issues, while improving overall efficiency.

TECHNICAL SKILLS

• SAS: BASE SAS
• SAS/SQL
• SAS/MACRO
• SAS/GRAPH
• SAS/ACCESS
• SAS/ODS
• SAS/CONNECT
• SAS/Grid Manager
• SAS DDE
• SAS/ODS
• RTF
• .csv
• .html

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

Sr. SAS Programmer / Analyst

Responsibilities:

• This project is to validate BASEL data before models use them and responsible for downloading data from sources like Economy.com, BLS.gov etc., read those external data and validate them against internal data.
• Generate comparison reports among the FED CCAR scenario mnemonics (Base, Adverse, and Severely Adverse) on periodic basis.
• Generate comparison reports on Moody’s actual mnemonic values and Confidential Internal forecast mnemonic
• Involved in CCAR, DFAST stress test by loading the economic data for the test.
• Used python to read the external data which is in XML format and convert them as a SAS dataset.
• Identify process needs and improvement opportunities, develop solutions, get them accepted and coordinate their execution in a continuous improvement environment.
• Helped to generate tool based software to validate the economic data and generate the report how the data values are trending over the month/years.

Confidential, New York, NY

SAS Programmer

Responsibilities:

• Involved in project called Global New Accounts (GNA) which extract credit card applicant and candidate information and get direct, possible and No matches based on their Account Number, Name and Address for 13 markets.
• Involved in analysis, design, development, code, testing, and documentation and support activities for client business requirement.
• Project involves extracting information from Mainframe, Sybase and Sql Server using SAS Base
• Generated new SAS Datasets from raw data files using Import Techniques and modified existing datasets
• Used Macros to read, validate, parse and import file from different sources.
• Wrote Korn and shell scripts to submit the series of Jobs on UNIX and for transfer the data, reports and SAS programs from one location to another location.

Confidential, Jacksonville FL

SAS Programmer

Responsibilities:

• This project is mainly into validating data between DB2 database to Teradata database.
• Involved in reengineering multiple DB2 sql to Teradata sql and optimize them to reduce the runtime
• Performance tuning, including collecting statistics, analyzing explaining & determining which tables needed statistics. Increased performance by 35 - 40% in some situations
• Responsible for converting SAS scripts, SQL Queries, testing in Dev, keep track of UAT testing and moving into production.
• Expertise in primary index selection for uniform data distribution across the AMPs and compress columns for efficient utilization of available disk space
• Responsible for creating and testing Store procedures in SAS
• Creating daily reports activity onsite through the creation of a Teradata.
• Extensively used SAS macros and executing Unix command thru SAS Codes
• Worked on SAS Add-in for Microsoft office to bring the data to MS Excel from SAS datasets and by executing STP.

Confidential

Data Analyst

Responsibilities:

• Created SAS datasets from Oracle database with random sampling technique and created Oracle tables from SAS datasets by using SAS Macros.
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset merging techniques of SAS/BASE.
• Analyzed data using various statistical procedures
• Used SAS/Macro facility to create macros for statistical analysis, reporting results and data extraction.
• Worked on SAS data sets in both Windows as well as in UNIX environments.
• Proposed a set of action plans to mitigate the risks identified with the sourcing decision.
• Generated HTML, Listings, EXCEL and RTF reports for presenting findings of various statistical procedures

Confidential

SAS CONSULTANT

Responsibilities:

• Provided structured programming analysis, design, development, code, testing, documentation, implementation, and quality assurance during enhancement, maintenance, and/or production support activities for various client business application solutions.
• Created Ad hoc, Macros and Stored Procedures for ETL Interfaces Programs.
• Used SQL join, Splitter, Extract, loader, Sort, Summary, validation and SCD Type2 loader Transformation in SAS DI Studio.
• Used SAS to reports employing various SAS procedures,
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management