PROFESSIONAL SUMMARY

• Certified SAS Programmer with over seven years of programming experience with SAS 8, 9.0, 9.1.3, 9.2 in Mainframe, Windows and UNIX Environments.
• Extensive programming experience in SAS tools like BASE/SAS, SAS/SQL, SAS/MACROS, SAS/ACCESS, SAS/ODS, SAS ENTERPRISE GUIDE, SAS ENTERPRISE MINER, SAS INFORMATION STUDIO
• Experienced in Base SAS procedures such as PROC FREQ, MEANS, SUMMARY, UNIVARIATE, FORMAT, IMPORT, EXPORT, REPORT, TABULATE, TRANSPOSE, DATASETS, COPY, PRINT and SQL.
• 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.
• Experienced in preparing reusable components and SAS Macros for automation of the application
• Possess thorough knowledge in Statistical Analysis Linear Regression, Descriptive Statistics, Factorial ANOVA, Regression Analysis, etc.
• Strong experience in setting strategic direction, methodologies and procedures for testing including Test Plans, Use cases, Test cases, Testing Overview, Approach, Strategy, Scope, Roles and Responsibilities.
• Experienced in Mainframes Z/OS environment with COBOL, JCL, VSAM, GSAM, IMS DB/DC, DB2, MQ series.
• Domain experience in Pharmaceuticals, Insurance and Health Care. Involved in Phase I, Phase II, Phase III of clinical trials and working knowledge in Phase IV.
• Good understanding of Good Clinical Practice (GCP), Code of Federal Regulations (21 CFR Part 11), eCTD and FDA regulations.
• Highly knowledgeable in Clinical Data Interchange Standards Consortium (CDISC) Version 2 and 3, SDTM, ADaM and International Conference of Harmonization (ICH) guidelines, Integrated Summaries of Efficacy (ISE) and Integrated Summaries Safety (ISS)
• Worked with various Databases like Oracle, DB2, IMS DB, and Teradata with extensive knowledge in SQL, PL/SQL.
• Very knowledgeable with tools like ENDEVOR, XPEDITER, File-Aid, QMF, SPUFI.
• Received multiple client appreciation awards for outstanding performance, proactive interaction, process improvements and following best practices.
• Strong ability to interact with business experts to understand, and in some cases help define business functional needs
• A quick learner with an eye for detail and excellent problem solving, analytical and quantitative skills.
• Excellent written and verbal communication skills, a self-starter, and works well independently as well as in a team environment.

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,DB2,IMS DB, VSAM, GSAM,MS Access

OLTP:

CICS, IMS 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,LLC Aug 2010- Date
Lead/ Sr. SAS Programmer

Confidential,mission is to provide exemplary research and consulting services to its domestic and international clients in the areas of social program evaluation, economic research, and policy analysis. IMPAQ is committed to providing our clients’ with personalized service of the highest quality in each of IMPAQ’s core competencies like Evaluation and analysis of government program impacts, benefits, and costs, Data collection and analysis etc.

Roles and Responsibilities:

• Responsible for developing SAS programs to analyze 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 without 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.
• Used HIPAA standards for protecting PHI (Protected Health information) to do de-identification of the PUF datasets and made the information available to researchers as 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.
• Worked on part D report Card analyses to produce the star rating values for all the contracts that offer Part D coverage.
• Worked 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 Jan 2008-Jul 2010
Clinical SAS Programmer
Confidential,deals in three therapeutic areas, infectious disease, neurology and dermatology, which deals with diseases like viral, infectious diseases, cancer and neurological maladies. As a SAS Programmer, I was involved in phases II & III of study to determine safety and effectiveness of drugs.

Roles and 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 Mar 2006 -Dec 2007
Clinical SAS Programmer
Project Description:

Confidential, is a leading Biopharmaceutical company engaged in the development of therapeutics for the treatment of diabetic neuropathic pain and HCV. I was involved in phases I and II of development of drug ‘Bicifadine’ for treatment of neuropathic panic, a chronic condition resulting from damage to peripheral nerves due to diabetes. The study was to evaluate the safety and long term efficacy of two dosages of bicifadine.

Roles and 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 into 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 Oct 2004 – Feb 2006
SAS Programmer

Confidential,is a third largest property and casualty insurer in U.S which provides auto, home, life as well as personal liability. I worked as a sas programmer in the mainframe environment for various projects with PL, WC, and auto claims.

• Provided programming support in compliance with relevant SOPs and working practices. Extensive experience with SAS programming in data step with various SAS Procedures in Base SAS including thorough knowledge of SAS /SQL
• Preparing Gap Analysis report for migration by interacting with SME and clients.
• Performing impact analysis to find the programs that need to be changed.
• Extracting the data from IMS 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.
• Prepared 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, IMS DB, DB2.

EDUCATION
Bachelors in Computer Science Engineering