SUMMARY

• Certified Base SAS Programmer with 8 years of experience in analysis, design, development and validation of SAS programs for Statistical Analysis and Reporting.
• Extensive working knowledge in handling complex transformations using BASE/SAS, SAS/STAT, SAS/Macros, SAS/SQL and Graphs
• Hands on working experience in Phase 1 - 3 of clinical trials and various therapeutic areas.
• Good knowledge and hands on experience in CDISC guidelines while producing SDTM and ADaM datasets, Tables, listings and Figures.
• Experience in creation of annotated CRF with SDTM variables.
• Proficient in creating programs with the combination of basic Data Step, Procedures and also DataStep2.
• Experience in writing SDTM mapping specifications and ADaM specifications.
• Strong experience in playing developer as well as validator roles.
• Involved in FDA submissions.
• Written programs using the Procedures, Proc DS2 and Data step.
• Created macros and also modified existing macros.
• Involved in SAS edit check programming for Data management.
• Ability to work in a cross platform environment that includes Windows and Unix Operating Systems.
• Familiarity on working with Netezza interface.
• Worked extensively with databases like Oracle.
• Excellent communication skills, good at multi-tasking and a good team player meeting timelines.
• Experience in using SAS to read, write, import and export to another data file formats, including delimited files, Spreadsheet, Microsoft Excel and Access tables.
• Experience in using Base SAS procedures such as Proc Freq, Means, Summary, Univariate, Format, Import, Export, Report, Tabulate, Transpose, Datasets, Copy and Print.
• Expertise in Data Manipulations using SAS data step, such as SAS Formats/Informats, Merge, Procedures like PROC APPEND, PROC SORT, and PROC TRANSPOSE.
• Good communication, analytical, interpersonal and problem solving skills.

TECHNICAL SKILLS

SAS Tools: SAS (SAS/BASE, SAS/STAT, SAS/ODS, SAS/Macros, SAS/SQL, SAS/Graph)

Operating System: UNIX, Solaris, Red hat, Windows

Languages: C, Java

RDBMS: Oracle, SQL Server, MS Access, PL/SQL

Scripting Languages: Perl, Python

Microsoft Office: Word, Excel, Access.

PROFESSIONAL EXPERIENCE

Confidential, MA

Clinical SAS Programmer/ Analyst

Responsibilities:

• Creation of SDTM datasets, ADaM datasets using CDISC standards.
• Created programs with the combination of basic Data Step, Procedures and also DataStep2.
• Extensive knowledge on Health care claims processing.
• Used SAS/IML along with R to compute functions according to the requirements.
• Knowledge of producing different outputs in different file types using ODS in SAS.
• Generate statistical analyses and accompanying Tables, Listings and Figures on regular or Ad-hoc basis based on team requirements.
• Gathering requirements and analysis, estimation of cost, preparation of design documentation, design reviews of SASgraphs and related codes, enhancements, project planning.
• OptimizedSAScode and helped team to work on various other projects which led to reduction in the length of project duration as well as efficiency and productivity on the part of team members.
• Worked on Netizza for connecting through databases.
• Review of Annotated CRF as per CDISC guidelines.
• Knowledge in preparing Integrated Summaries of Efficacy (ISE) and Safety (ISS) reports.
• Created and used standard or customized macros.
• Validate standard programs and macros written by other programmers.
• Worked on annotations as per the Global Standards Tables and Listings requirements.
• Generated Efficacy analysis outputs for Progression Free Survival (PFS).
• Provided descriptive statistics using PROC MEANS, FREQ and UNIVARIATE.
• Produced quality customized reports by using PROC REPORT, PROC TABULATE and PROC SUMMARY.
• Tested and maintained SAS macros to create tables, graphs and listings for inclusion in Clinical study reports and regulatory submissions.
• Worked on Perl in developing code for integration.

Environment: SAS 9.4 (SAS/Base, SAS/STAT, SAS/ Macros, SAS/ SQL), SAS Enterprise Guide, SAS BI Studio, UNIX, Enterprise Miner.

Confidential, MA

Sr. Clinical SAS Programmer/ Analyst

Responsibilities:

• Derived datasets from key variables, adverse events, exposure, disposition, demographics.
• Involved in creating Stored Processes for requesting applications.
• Creating datasets using SDTM and ADAM data models.
• Reviewed statistical analysis plans, tables, listings, specifications and provided feedback to the statistician.
• Performed ad-hoc reports for data managers, statisticians and medical writers.
• Reviewed and acquired knowledge about documents related to clinical trials like clinical protocol, SAP and Clinical Study Report.
• Gained experience in Import and Export of data across a variety of applications to and from SAS.
• Processed health care claims data by generating different outputs in different file formats according to the requirement.
• Developed reports using PROC REPORTS, PROC TABULATE and DATA NULL .
• Used ODS in order to generate PDF, RTF files out of listings and tables being created.
• Experience in survival analysis by using procedures like PROC LIFETEST (KAPLAN MEIER), LIFEREG, PHREG, LOGISTIC.
• Extracted data from different sources like Oracle and MS Access, Excel, and text files using SAS/Access, SASSQL procedures and created SAS required datasets.
• Presented data analysis in graphs using the SAS/GRAPH.
• Prepared new datasets and modified existing datasets using Set, Merge, Sort, Update, Formats and Functions and created Tables and Listings for the same.

Environment: SAS 9.3(SAS/Base, SAS/SQL, SAS/Macros, SAS/GRAPH, SAS/STAT), SAS Enterprise Guide, Windows, MS Access.

Confidential, FL

Clinical SAS Programmer

Responsibilities:

• Advanced skills on data cleaning and manipulation using procedures such as PROC SUMMARY, PROC SORT, PROCFREQ, PROC MEANS, PROC UNIVARIATE, PROC FORMAT, PROC TRANSPOSE, PROC PRINT and DATA steps.
• Extensively used PROC PRINT, PROC FREQ, PROC TABULATE, PROC MEANS, PROC SUMMARY, PROC CONTENTS, PROC COMPARE, PROC UNIVARIATE, PROC SQL, PROC SORT, PROC CORR and PROC ANOVA for generating reports.
• Excellent oral and written communication skills. A quick learner with an eye for detail and excellent analytical andquantitative skills.
• Experience in extracting, manipulating data, and creating Data Sets from various sources like Excel, flat files, Oracle database Access database using PROC IMPORT techniques and SQL pass through facility.
• Strong experience in data cleaning such as checking values, missing values, dates, duplication, multiple files, and validation of data sets.
• Imported and Exported data files to and from SASusing Proc Import and Proc Export from Excel and various delimited text based data files such as .TXT (tab delimited) and .CSV (Comma delimited) files into SAS datasets for analysis.
• Optimized data format for further analysis in terms of cleaning, validation, formatting and Labeling using PUT/INPUT Functions, LABEL statement, and PROC FORMAT.
• Created electronic data sets (i.e. SAS transport files) for electronic submissionsusing PROC COPY.
• Programming analysis datasets in ADaM model. Created Table, Listings and Figures by using ADaM data sets.
• Involved in Creating Standardized macros for proper report generation.
• Participated in Data Validation/Edit checks for many studies and in reporting those issues to the data management team.

Environment: SAS 9.2 (SAS/Base, SAS/STAT, SAS/ Macros, SAS/ SQL), UNIX

Confidential, Louisville, CO

Clinical SAS Programmer

Responsibilities:

• Utilized SAS procedures and other SAS applications for data updates, data cleaning and reporting.
• Identified and corrected data step syntax and programming logic errors.
• Gained experience in Import and Export of data across a variety of applications to and from SAS.
• Validated programs and processes to extract data from clinical data management systems, to prepare data listings, summary tables and reports using SAS.
• Became proficient in SAS/BASE, SAS/ODS, SAS/SQL and in producing external files and reports employing various SAS procedures like PROC PRINT, PROC SUMMARY, PROC REPORT.
• Developed analysis plans including specifications for Tables, Listings and Figures (TLFs).
• Produced RTF, MSWORD, PDF and HTML formatting files using SAS/ODS.
• Created efficacy tables by using Analysis of Variance (ANOVA), Proc REG, Proc CORR, Proc GLM, and Proc Mixed.
• Produced SDTM data sets from the existing SASdata sets as per the SDTM 3.1 specifications.
• Created analysis data sets using ADaM model.
• Worked with all kinds of Clinical Trials data such as Demographic data, Adverse Events (AE), Serious Adverse Events (SAE), Laboratory data (Lab data), and Vital Signs.

Environment: SAS 9.2 (SAS/Base, SAS/STAT, SAS/ Macros, SAS/ SQL), UNIX.

Confidential

Clinical SAS Programmer/ Data Analyst

Responsibilities:

• Utilized SAS procedures and other SAS applications for data updates, data cleansing and reporting.
• Identified and corrected data step syntax and programming logic errors.
• Gained experience in Import and Export of data across a variety of applications to and from SAS.
• Validated programs and processes to extract data from clinical data management systems, to prepare data listings, summary tables and reports using SAS.
• Became proficient in SAS/BASE, SAS/ODS, SAS/SQL and in producing external files and reports employing various SAS procedures like PROC PRINT, PROC SUMMARY, PROC REPORT.

Environment: SAS V8, SAS/BASE, SAS/SQL, SAS/ODS, Windows 98, Excel/Access 2000.

Confidential

Clinical SAS Programmer

Responsibilities:

• Cleaned data using Data Step and SAS Base procedures.
• Assigned formats and labels to the variables in analysis data sets.
• Generated tables and listings using Proc Print, Proc Report and Proc Tabulate.
• Generated summary reports and descriptive statistics using Proc Means, Proc Freq, and Proc Univariate.
• Responsible for data validation and corrections - upload and /or download data.
• Developing analysis plans including specifications for Tables, Listings and Figures (TLFs).
• Involved in writing codes using BASE SAS and SAS Macros to extract, clean and validate data.

Environment: SAS V8, SAS/BASE, SAS/SQL, SAS/ODS, Windows 98, Excel/Access 2000.