SUMMARY

• SAS certified professional with around Six years of experience in Analysis, Design, Development, Implementation and Testing of various clinical projects using SAS tools in Pharmaceutical Industry.
• Experienced in Data analysis and Reporting in health care, and clinical domain.
• Highly experienced in healthcare analytics.
• Facilitated reporting on patient care quality through providing SAS Programming and administrative support for Healthcare Effectiveness Data and Information Set (HEDIS) submissions using Data Step, SAS Macro, and Proc SQL to perform data manipulation, quality checks on results, and reporting.
• Excellent understanding of ICD 9, ICD 10, HCPCS, and CPT.
• Experienced in SAS/BASE, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, and SAS/CONNECT in UNIX and Windows environments.
• Very good experience working on HIPAA translation based claim processing systems.
• Strong ability to write SQL queries using PROC SQL.
• Experienced in utilizing SAS Procedures, Macros and other SAS applications for data extraction, data cleansing, data loading and reporting.
• Expertise in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT.
• Participated in the SAS programming efforts generating and validating Tables, Listings and Figures (TLFs) as per specifications.
• Extensive experience reviewing study protocols, Case Report Forms (CRFs), Statistical Analysis Plans (SAPs), and dataset specifications.
• Through knowledge and experience in creating and validating CDISC SDTM and ADaM datasets.
• Involved in theData mappingfromExisting Raw datatoCDISC SDTMStandard,data mapping fromSDTM to ADAMdomains and review CRFs (Case Report Form) to ensure consistency with protocol and adequacy in collecting data to meet objectives defined in protocol.
• To ensure allottedCRFannotation is done and corresponding PeerQCis done withQCcomments documented on tracking tool for each work request.
• Provided input to the mock - shells and programming specifications for multiple clinical trials.
• Supported time-sensitive ad-hoc requests addressing questions from regulatory authorities.
• Therapeutic area of expertise: Oncology, Hypertension, Cardiovascular.
• Possess excellent interpersonal skills.
• Ability to work efficiently and independently in Team environment.

TECHNICAL SKILLS

Clinical Practices: CDISC Standards (SDTM, ADaM, MedDRA, NDA and regulatory submissions, RECIST)

SAS Tools: SAS/Base, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/ODS, SAS/GRAPH, SAS Enterprise Guide, SAS/CONNECT

Operating Systems: Windows, UNIX

Databases: Oracle, MS Access, MS Excel, Clintrial

PROFESSIONAL EXPERIENCE

SR. SAS Programmer

Confidential, PA

Responsibilities:

• Support SAS Programming activities for membership and claims data and involved in Systems Development Life Cycle of the project.
• Provide SAS programming support for HEDIS data deliverables.
• Work for implementing HIPAA compliant standards to a large data warehouse.
• Work on ICD-9 code with health measurement quality indicators and adopt knowledge training of ICD-9 to ICD-10 conversion.
• Use LIBNAME and SQL PASSTHRU facility to read data from other sources.
• Use SAS/ACCESS to read datasets from Databases, Flat files, also work with other PC File formats.
• Manipulate existing Oracle database by accessing the data using SQL pass through facility.
• Work on pre-existing macros for data validation by checking data distribution and comparison to standard data.
• Perform data cleansing by analysing and eliminating duplicate and inaccurate data using proc freq proc univariate and macros in SAS
• Create new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, and conditional statements.
• Validate, document and test component programs for inclusion in integrated reports.
• Develop, analyse and design SAS programs in UNIX platform.
• Generate highly customized reports in the form of listing, HTML, RTF and PDF using SAS ODS, PROC REPORT, PROC TABULATE, and PROC SQL.
• Involve in discussions with business users and data architects to define metadata for tables to perform ETL process.

SR. SAS Programmer

Confidential, PA

Responsibilities:

• Provided Clinical SAS Programming support for the submission level projects like CSR, CSS and CSE across multiple protocols.
• Involved in data cleaning and data validation for the phase II-III of clinical studies.
• Extracted data from ORACLE database and performed data cleaning using various edit check techniques and generated patient listings for initial review for Statistician.
• Generated and validated TLFs based on the requirement of statistician and medical review team.
• Created ad-hoc TLF reports and combined all the outputs for the statistician review.
• Successfully generated CSS and CSE reports for the analysis of Clinical trials.
• Successfully created and validated top line tables during the process of data unblinding for medical review team as per request in timely manner.
• Used PROC CDISC to validate compliance of CDISC datasets for the submission.
• Debugged SAS codes and provided area of improvement to junior programmers.

Statistical Programmer Analyst

Confidential, NJ

Responsibilities:

• Involved with analyses and creation of TLFs to support ISS/ISE and Phases I - III of clinical trials.
• Identified gaps in between the statistical analysis plans and specifications for the mock shells.
• Created analysis dataset programming specifications based on the SAP and TLF mock-shells.
• Combined data from multiple studies to create pooled datasets for reporting of ISS/ISE.
• Created analysis/derived datasets from CRF/raw datasets and adopted data standards.
• Created standard Safety tables for Adverse Events, Concomitant Medications, Electrocardiograms, Vital Signs and Labs and also generated shift tables and outputs for Efficacy Endpoints.
• Performed edit checks on datasets as part of due diligence efforts and provided comments to study data manager.
• Created SAS macros for reporting of tables across studies and for subgroup analyses in ISS/ISE.
• Modified macros according to the programming needs in the specific studies, and tested and debugged the modified macros as per the requirements.