SUMMARY

• Over 7 years of experience in data analysis and statistical modeling including data extraction, manipulation and validation techniques, writing macros and reporting on various projects for Health Care and Financial industry using SAS and its tools.
• Data preparation for various statistical modeling which includes data cleaning, descriptive analysis, missing data analysis, data validations, data triangulations and preliminary data reporting.
• Experience in SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ODS, SAS/STAT, SAS ETL, SAS/ACCESS, SAS Enterprise Guide.
• Strong experience in coding using SQL, Procedures/Functions, SAS macros.
• Solid understanding and proficient use of various SAS procedures.
• Implemented best practices and thus enhancing performance and maximizing efficiency.
• Excellent command in writing complex routines for Data Validations, Data Extraction, transformation and loading to target decision support systems using MS Excel, Pivot tables and SAS on various environments.
• Proven skills in Data Cleansing, Data Archival, Data Migration, ad - hoc reporting and coding utilizing SAS on UNIX, Windows in using various MS office tools for analyzing, arranging and presenting data
• Experience in creating SAS programs for EDIT CHECKS and performed data validation on raw data sets and created data set for analysis
• Extensive experience in preparation of reports, tables, listings and graphs.
• Performed analysis, validation and transformation on very large data sets with millions of records effectively.
• Good analytical skills pertaining understanding a business domain coupled with excellent teamwork and strong communication skills.
• Hard working, ethical and highly result oriented. Ability to quickly grasp and apply new concepts and technologies.
• Good knowledge in software engineering methodologies

TECHNICAL SKILLS

Operating Systems: Windows NT, Unix, Sun Solaris, HP-UX

Database Platforms: Netezza, Oracle 9i/10g, MS ACCESS, DB2,Teradata, AS-400/i series, MS SQL server

SAS Tools: SAS/BASE,SAS/STAT,SAS/GRAPH,SAS/SQL,SAS/ACCESS,SAS/MACROS,SAS/EG

Data Base Tools: SQL Plus, PL/SQL, HTML, Java, Edit plus

MS Office suite: MS word, MS PowerPoint, MS Excel.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

SAS Developer/Architect

Responsibilities:

• Provided detailed designs based on the user requirements for the enhancements and the updates to the existing reporting Modules with accurate estimates for development tasks in UNIX environment.
• Designed and implemented new architectural changes to address the data warehouse updates that would impact downstream reporting processes.
• Created and modified Data transformation and Data Loading (ETL) scripts for Data Warehouses to access the data from Netezza using SQL pass through and Libname statements.
• Researched and resolved underlying long term issues in the reporting process flow.
• Created Technical Design documents for new updates, test plans for unit testing and detailed process flow of complex SAS reporting processes.
• Identified different areas of potential efficiency improvements in the end to end reporting module and leveraging several Libname and Proc SQL options for SAS/Access and thus optimizing the processing time.
• Extensively used UNIX Korn shell scripts to schedule and execute several ADHOC and PROD reporting process on UNIX server. Also used Reflection FTP client to submit SAS jobs.
• Created Unix scripts to automate certain SAS programs that were regularly used.
• Used WINSQL to debug the defects from complex logs from a series of SAS programs which include porc SQLl pass through steps on Netezza database.
• Used SAS EG to validate, debug and profile the data in different databases like Netezza, SQL server.
• Optimized SQL joins on huge tables to minimize the runtime for specific queries involving multiple inner and outer joins.
• Extracted, performed validation and generated SAS data sets from data bases like Netezza, SQL server.
• Created Macros to automate several Data Warehouse load processes.
• Generated output files and reports in text format and Excel using SAS ODS and ExcelXP tag sets.

Environment: SAS9.2,SAS/SQL,SASMacro,SAS/ACCESS,SAS/STAT,SAS/SCL,SAS/ODS,UNIX, Windows/XP,Netezzza, DB2, MS SQL Server, Java UI interface

Confidential, New York, NY

Sr. SAS Programmer/Analyst

Responsibilities:

• Translation of Business requirements into Technical requirements.
• Creation and maintenance of data extracts which will be used as source to the ViPS systems.
• Creation of Specification document
• Get user sign off
• Creation of new SAS program as per Specification document
• Prepare Test Plan, Production release notes and inventory
• Unit test case execution
• Support during implementation
• Built Data Warehouses to store all the data pertaining to New York and New Jersey Managed care and commercial plan insurance.
• Created Data transformation and Data Loading (ETL) scripts for Data Warehouses.
• Modified tables in warehouses according to business user requirements using SAS/BASE and SAS Macros.
• Documenting of service requests by business users, developed code documentation, logs and outputs documentation, creating Test Plans and Production Release Notices for QC, QA and Production teams to perform further analysis.
• Extensively used PROC SQL pass through for column modifications, field populations on Teradata Data warehouse tables using ODBC.
• Additional responsibilities being Requirements gathering, Designing, Coding and Analysis, Testing, Debugging, Output generations in prescribed formats, extensive documentation of SAS Programs and Macros.
• Process optimizations in reading the raw data to the Data Warehouse tables, using different Libname and connect options for SAS/Access to Teradata and MS SQL Server.
• Optimizing several load process using different techniques like Hash join and SQL joins.
• Enhancement of scripts for Macros and SCL Frames utilized for standard processes.
• Extracted, performed validation and generated SAS data sets from data bases like oracle, SQL server.
• Analyzed large datasets for data integrity and quality.
• Created Macros to automate several Data Warehouse load processes.
• Generated output files in text format, HTML & PDF format usingSASODS.
• Created several analytical reports based on the Ad hoc

Environment: SAS9.1.3/9.3, SAS/SQL,SASMacro,SAS/ACCESS, SAS/AF, SAS/SCL, SAS/ODS, Windows/XP, Teradata, MS SQL Server, AS-400/i-series

Confidential, NY

SAS Programmer

Responsibilities:

• Worked for the Analytics team, to update the regular reports and providing solutions for the ad-hoc requests.
• Understand and update the existing code or create new code by using BASE/SAS, SAS/MACROS and SAS/SQL to implement new requirements.
• Get the Production the SAS code and analyze.
• Wrote various format and integrity edit checks on CSV files and on staging SAS datasets.
• Develop SAS code to validate data of different portfolios.
• Extensive skills in extracting, loading, and transforming data.
• Modified existing SAS programs and created new programs using SAS macro variables to improve ease and speed of modification as well as consistency of results.
• Generate Reports in user required format by using ODS and PROC Report.
• SAS data sets are validated using SAS procedures like Proc Means, Proc Frequency and Proc Univariate.
• Performed data integrity checks and data cleaning using SAS MACROS and data steps, created HTML outputs with table of contents using ODS HTML.
• Used SAS PROC SQL Pass through Facility to work with Teradata and DB2 databases.
• Did data reconciliation in various source system and in Teradata.
• Analyzed and implemented the code and table changes to improve performance and enhance data quality.
• Done Code Optimization using SAS macros.
• Creates and revises the common macros.
• Reading data from different sources like .csv, excel, tab delimited files.
• Perform various business checks on the source data to confirm whether data is correct or not.
• Compare the source data with historical data to get some statistical analysis.
• Perform transformations like Merge, Sort and Update etc. to get the data in required format.
• Create the understandable EXCEL template to start dad mapping for each line of business.
• Extensively utilized SAS/BASE, SAS/SQL and SAS/MACRO.
• Extensively used procedures such as PROC APPEND, PROC IMPORT, PROC MEANS, PROC SUMMARY, PROC CONTENTS and PROC SQL.
• Involved in project review meetings with respective Business SME’s.
• Generate the genealogy by using EXCEL MACRO to make it better understandable to end user.

Environment: SAS 9.1.3, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS/ODS, Teradata, DB2 UNIX and Windows XP.

Confidential, Richmond, VA

SAS Developer

Responsibilities:

• Enhancement of scripts for Macros at Confidential Bank.
• Extensive use of SAS Macros to modify hard coding in existing programs into Automatic process through an excel sheet.
• Unit tested the results between Pre and Post changes.
• Generated reports validating changes between pre and post modifications.
• Retrieved surplus records from DB2 by connecting to the remote server using FTP and retrieved data.
• Modified tables in warehouses according to business user requirements using SAS/BASE and SAS Macros.
• Extensively used PROC SQL for column modifications, field populations on warehouse tables.
• Generated output files in text format, HTML & PDF format usingSASODS.
• Worked with several SAS procedures like FORMAT, FREQ, MEAN, PRINT, SORT for data validation, cleansing, analysis and reporting purposes.

Environment: SASBASE, SAS/SQL,SASMacro,SAS/ACCESS, SAS/AF, SAS/SCL, SAS/ODS.