PROFESSIONAL SUMMARY

• Experienced at preparing reusable components and SAS Macros for automation of the application
• Has knowledge of Integrated Summaries of Efficacy ISE and Integrated Summaries Safety ISS
• Highly knowledgeable of Clinical Data Interchange Standards Consortium CDISC Version 2 and 3, SDTM, ADaM and International Conference of Harmonization ICH guidelines
• Has great understanding and working knowledge of Good Clinical Practice GCP , Code of Federal Regulations 21 CFR Part 11 , eCTD and FDA regulations.
• Involved in Phase I, Phase II, Phase III of Clinical Trials and has working knowledge of Phase IV.
• Worked Primarily for Medicare and Medicaid in HealthCare.
• Worked in the domains HealthCare, Pharmaceuticals and Insurance.
• Experienced in using SAS to read, write, import and export to other data file formats, including delimited files, Microsoft Excel, Access files.
• Performed Data management like Merging, concatenating, interleaving of SAS datasets using MERGE and SET statements in DATA step and PROC SQL.
• Possess extensive knowledge in SAS BI tools like 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.
• Extensive programming experience in BASE/SAS, SAS/SQL, SAS/MACROS, SAS/ACCESS, SAS/ODS, SAS/STAT, SAS/GRAPH, SAS/EG
• 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.
• 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, IMS DB/DC, DB2, MQ series.
• Worked with various Databases like Oracle, DB2, Sybase, IMS 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

PROFESSIONAL EXPERIENCE

Confidential

Senior SAS Analyst/Medical Economic Analyst

• Confidential is a national leader for HealthCare Solutions for Underserved. It is one of the largest Organizations of Medicaid Managed Care plans.
• This project is to implement PCP rate increase associated with the Affordable Care Act statue ACA PCP . Main goal of this project is to increase Medicaid payment for specified primary care services furnished by certain primary care physicians in Year 2013 and 2014.
• I worked as a SAS Analyst/Medical Economics Analyst to generate the enhanced payments to the eligible Providers.

Roles and 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

Senior SAS Programmer/SAS Lead

IMS is the leading provider of information services for the healthcare industry, covering markets in 100 countries around the world. IMS gets data prescription drug data from various suppliers and IMS applies its propriety methodology to process and present the meaningful reports to the pharmaceutical companies useful in their research. I worked as a SAS developer in PC, Mainframe and UNIX environment.

Roles and 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

SAS Programmer

IMPAQ International, LLC's 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 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

Clinical SAS Programmer

Valeant Pharmaceuticals principally 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

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 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

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.

Roles and 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.
• Extracting the data from IMS DB in to SAS files and working on the files to transform the data.
• Performing the impact analysis to find the programs that needs to be changed.
• 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.
• Developed and improved the efficiency of programs through the use of SAS/MACROS for calculating Money control totals.
• Responsible for modifying the existing SAS programs to change the functionality according to new business requirements.
• 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, IMS DB, DB2.