PROFESSIONAL SUMMARY:

• Certified SAS Programmer with 9 years of programming experience with SAS 8.2, 9.0, 9.1.3, 9.2, 9.3 in Mainframe, Windows and UNIX Environments.
• Extensive programming experience in BASE/SAS, SAS/SQL, SAS/MACROS, SAS/ACCESS, SAS/ODS, SAS/STAT, SAS/GRAPH, SAS/EG
• Experienced in Base SAS procedures such as PROC FREQ, MEANS, SUMMARY, UNIVARIATE, FORMAT, IMPORT, EXPORT, REPORT, TABULATE, TRANSPOSE, DATASETS, COPY, PRINT and SQL.
• Possess extensive knowledge in SAS BI tools like SAS ENTERPRISE GUIDE, SAS ENTERPRISE MINER, SAS INFORMATION STUDIO.
• Performed Data management like Merging, concatenating, interleaving of SAS datasets using MERGE and SET statements in DATA step and PROC SQL.
• Experienced in using SAS to read, write, import and export to other data file formats, including delimited files, Microsoft Excel, Access files.
• Worked in the domains HealthCare, Pharmaceuticals and Insurance.
• Worked Primarily for Medicare and Medicaid in HealthCare.
• Involved in Phase I, Phase II, Phase III of Clinical Trials and has working knowledge of Phase IV.
• Has great understanding and working knowledge of Good Clinical Practice (GCP), Code of Federal Regulations (21 CFR Part 11), eCTD and FDA regulations.
• Highly knowledgeable of Clinical Data Interchange Standards Consortium (CDISC) Version 2 and 3, SDTM, ADaM and International Conference of Harmonization (ICH) guidelines
• Has knowledge of Integrated Summaries of Efficacy (ISE) and Integrated Summaries Safety (ISS)
• Experienced at preparing reusable components and SAS Macros for automation of the application
• Has thorough knowledge in Statistical Analysis Linear Regression, Descriptive Statistics, Factorial ANOVA, Regression Analysis, etc.
• Strong experience in developing Test Plans, use cases, Test cases using requirements and design documents while specifying Testing Overview, Approach, Strategy, Scope, Roles and Responsibilities.
• Experience includes establish strategic direction, methodologies and procedures for testing.
• Experienced in Mainframes Z/OS environment with COBOL, JCL, VSAM, GSAM, Confidential DB/DC, DB2, MQ series.
• Worked with various Databases like Oracle, DB2, Sybase, Confidential DB, SQL SERVER and Teradata.
• Extensive knowledge in SQL, PL/SQL.
• Very knowledgeable with tools like ENDEVOR, XPEDITER, File - Aid, QMF, SPUFI.
• Received a “Pat-on-the-back” business award for Targit-6 project for outstanding performance.
• Received a “Feather-in-a-cap” award for the best practices, proactive interaction with the client and process improvement.
• Has a strong ability to interact with business knowledge experts to understand, and in some cases help define business functional needs
• Has the ability to work as a team as well as to perform individually
• Has exceptional problem solving skills for delivering useful and prudent solution. A quick learner with an eye for detail and excellent analytical and quantitative skills.
• Excellent written and verbal communication skills, self-starter and good team player.

TECHNICAL PROFILE:

Operating Systems: MS-DOS, Unix, Windows NT/2000/2003 Server/XP/Vista, OS/390

Languages: COBOL, VS COBOL II, JCL, VB, C, C++, JAVA, SQL, PL/SQL, UNIX SHELL SCRIPTING, HTML SCRIPTING, JAVA SCRPTING.

SAS Tools: Base SAS, MACROS, ACCESS, SQL, GRAPH, ODS, SAS ENTERPRISE GUIDE, SAS ENTERPRISE MINER, SAS INFORMATION STUDIO.

Database: Oracle,Sybase,DB2, Confidential DB, VSAM, GSAM,MS Access

OLTP: CICS, Confidential DC, TELON

Mainframe Tools: File-Aid, Endevor, JCL, QMF, SPUFI, Xpediter

Utilities: TSO, ISPF, IBM Utilities.

Domains: Insurance, Health Care and Pharmaceutical

Other Skills: Team Leading, Reviews, test planning and conducting vertical audits

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Senior SAS Analyst/Medical Economic Analyst

Responsibilities:

• Attend the business meetings to understand the requirements specific to a LOB.
• Review the meetings and do the GAP analysis and finally come up with Requirement Specifications document.
• Coordination with the Project management to come up with the Project Plan for the Project.
• Analysis includes identifying eligible providers, eligible claims, applying exclusion specific for LOB and Calculating the ACA pricing for the eligible billing codes.
• Further Analysis to validate the fields and tables to do the data pull from SYBASE/ORACLE.
• Libname Oracle/Sybase Engine, SQL Pass through facility to pull the data from the database.
• Optimizing the Proc SQL to write the efficient queries while pulling large data from the DB to reduce the execution time.
• Input from and output to external excel files using SAS/ACCESS for PC file formats.
• Performed data manipulation like Merging, Interleaving, Combining sas datasets and used various sas functions and procedures during transformation of data fields.
• Used Reporting procedures like PROC REPORT, PROC TABULATE, and DATA NULL to create reports to be sent out to the provider groups.
• Wrote Macros to automate the Quarterly creation of payment files for some of the LOBs.
• Prepare the payment file to go in to FACETS system and PDF reports to be mailed to the Providers.
• Load the payment files in to the FACETS system to implement the enhanced rate payment to the providers.
• Implement the ACA payment process in Retroactive payment methodology and Ongoing Payment methodology

Environment: SAS 9.2, SAS EG 4.3/5.1, SAS/STAT, SAS/SQL, SAS/MACRO, SYBASE, ORACLE, Windows 7

Confidential, Collegeville, PA

Senior SAS Programmer/SAS Lead

Responsibilities:

• Participation in the meetings with SMEs to gather high level requirements for the projects.
• Analyzing the requirements and preparing the high level and low level design documents.
• Worked on large datasets of pharmaceutical drug data from various pharmacies.
• Writing SAS programs using PC SAS to do data transformations, validations of the data and to generate sas reports.
• Create summary reports and graphs to the users.
• Worked on adhoc requests to change the existing sas code and macros
• Worked on standardizing and productionising the existing sas jobs using cybermation scheduler in Mainframe environment.
• Coded and modified the existing COBOL programs.
• Wrote UNIX shell scripts to call SAS programs.

Environment: SAS 9.2, SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, Windows xp, UNIX, OS/390, COBOL, JCL.

Confidential, Columbia, MD

SAS Programmer

Responsibilities:

• Responsible for developing SAS programs for the analysis of the data following the information stated in Analysis Plan.
• Worked with various Medicare claims files like Inpatient, Outpatient, Prescription drug, Physician for CMS (Centers for Medicare and Medicaid Services) which were 5% random samples drawn with out replacement.
• Created Comparative effectiveness research public use files (CER-PUF) and deliver the Medicare claims files in the de identified form to CMS which will be useful to the public for comparative effectiveness research.
• Performing Risk Analysis on the PUF datasets combined with the re-identification.
• Using HIPAA standards set for protecting PHI (Protected Health information) for de-identification of the PUF datasets so that the information available to researchers is not IIHI(individually identifiable health information).
• Estimating the identification risk, conducting Re-identification analysis by using inside and outside intrusion after safe harbor treatment.
• Reading data from the external source files such as Comma separated files, mainframe files (EBCDIC) and tab delimited files.
• Created reports using ODS into formats such as RTF, HTML and ODS TAGSETS to create XLS, XML.
• Interpreting and summarizing the analytical findings.
• Identifying the data sources to develop the Voluntary disenrollment measure from CMS’ databases such as Medicare beneficiary Database (MBD), Enrollment Database (EDB) .
• Worked on the SAS code to develop the measure of voluntary disenrollment for Part C and part D and SAS code to identify the involuntary disenrollment.
• Extensively worked on UNIX scripting.
• Worked on part D report Card analyses to produce the star rating values for all the contracts that offer Part D coverage.
• Working on SAS code to import the CME (Common Medicare Environment) data to SAS from EBCDIC format (extracted from Mainframes) and develop the measures for monitoring the Administrative functions.

Environment: SAS 9.2, SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, Windows xp.

Confidential, Irvine, CA

Clinical SAS Programmer

Responsibilities:

• Created SAS datasets by taking database tables as input datasets using SAS/ACCESS SQL Pass Through Facility
• Performed edit check programming for data cleaning using SAS.
• Created tables, listings, and graphs using Base/SAS and SAS/GRAPH
• Developed SAS programs for mapping raw datasets into SDTM domain datasets.
• Validated the Transformed datasets for CDISC compliance.
• Analyzed dose-response curves using PROC GLM AND PROC GPLOT
• Analyzed reference and the test responses using PROC FREQ using Fisher’s exact test option.
• Analyzed data from the lab reports and vital signs using PROC GLM procedures.
• Analyzed descriptive statistics of demographic data using procedures like FREQ, MEANS, TABULATE, UNIVARIATE, SUMMARY, CORR, REG.
• Created adverse event (AE) reports and concomitant medication summaries using PROC TABULATE.
• Prepared final analysis datasets from raw datasets that are CDISC compliant.
• Graphical reports of the results were created using PROC GPLOT, PROC ANNOTATE and PROC GCHART
• Generate customized reports and listings by modifying the existing SAS MACROS.
• Performed validation of the derived variables, reports, and listings.

Environment: SAS 9, SAS/BASE, SAS/GRAPH, SAS/STAT, SAS/SQL, SAS/MACRO, Windows, UNIX.

Confidential, NY

Clinical SAS Programmer

Responsibilities:

• Used SAS and SAS tools on the Clinical trials data to perform sorting and merging to prepare and validate data.
• Created and extracted Clinical data tables from Oracle Clinical and to SAS using SAS tools like SAS/ACCESS, LIBNAME engine.
• Ensured quality of dataset at the protocol level while working to deliver competitive advantage and cost efficient results.
• Extensively worked on SAS MACRO programming.
• Made extensive use of PROC IMPORT, SAS/ACCESS to Pc files for importing external files of MS EXCEL and ACCESS format.
• Worked on Pivot tables and VBA to write macros in Excel.
• Documented the mapping specification rules and created a specification document.
• Transformed raw data in to SDTM domain datasets by mapping process.
• Created and validated specifications for SDTM and ADaM transfer purposes
• Created Analysis datasets referring to the specifications provided according to the CDISC standards
• Create Define.PDF for SDTM datasets and ADaM datasets.
• Created customized reports by using PROC TABULATE, PROC REPORT, and PROC SUMMARY and also provided descriptive statistics using PROC MEANS, PROC FREQ, and PROC UNIVARIATE
• Generated various graphs using SAS/GRAPH
• Created demographics table using PROC TABULATE and PROC REPORT
• Involved in creating transport files as per the submissions to the FDA.
• Created Excel PIVOT tables by using the output from SAS and wrote VB scripts.

Environment: SAS 9, SAS/BASE, SAS/GRAPH, SAS/STAT, SAS/SQL, SAS/MACROS, SQL, UNIX, Windows.

Confidential, Indianapolis, IN

SAS Programmer

Responsibilities:

• Provided programming support in compliance with relevant SOPs and working practices. Extensive experience with the SAS programming in data step and with various SAS Procedures in Base SAS including thorough knowledge of SAS /SQL
• Main role in preparing the Gap Analysis report for migration by interacting with SME and clients.
• Performing the impact analysis to find the programs that needs to be changed.
• Extracting the data from Confidential DB in to SAS files and working on the files to transform the data.
• Major use of Merge statement and procedures like TABULATE, SUMMARY, SORT, SQL, MEANS and COMPARE to meet the business specifications.
• Defined various user defined formats using PROC FORMAT besides using different kinds of predefined INFORMATS and FORMAT statements.
• Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools - SAS/Base, SAS/Macros and SAS/Graph, SAS/SQL, SAS/Connect, SAS/Access.
• Extensive experience in creating, reviewing and validating analysis datasets according to Statistical Analysis Plan.
• Extensive experience in creating test programs, validating datasets for adhering to department guidelines.
• Extensively used SAS/MACRO facility to provide reusable programs that can be conveniently used time to time and to avoid number of programming lines of code.
• Made major use of SAS/ODS and HTML scripts to create the reports.
• Created SAS Customized Reports using the Data Null technique.
• Produced quality customized reports by using PROC TABULATE, REPORT, and SUMMARY and also provided descriptive statistics using PROC Means, Freq, and Univariate.
• Performed and Formatted HTML, PDF, RTF and XML reports, using SAS - output delivery system ODS.
• Wrote JCL to run the SAS Programs created in Mainframe environment.
• Responsible for modifying the existing SAS programs to change the functionality according to new business requirements.
• Developed and improved the efficiency of programs through the use of SAS/MACROS for calculating Money control totals.
• Preparing Unit Test plans and integrated test plans to continue with the testing process for the quality delivery of the product.

Environment: O/S 390(Operating System), SAS 8.2, SAS/BASE, SAS/MACROS, SAS/ODS, SAS/SQL, JCL, Confidential DB, DB2.