SUMMARY

• SAS Programmer with Four years of experience in the design and development of Statistical data models including data extraction and manipulation, writing macros and reporting on various projects, for CRO and Pharmaceutical companies.
• Extensive experience in Base SAS, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ODS.
• Comprehensive skills in working with Base SAS, SAS/MACRO in Windows and UNIX environments.
• Skilled in SAS Programming, merging SAS Data Sets, Macro Facility, Preparing Data, Producing Reports, Validating Reports, SAS Formats, Storing and Managing Data in SAS Files.
• Excellent experience in Clinical Data Validation.
• Thorough experience in CDISC SDTM mapping of clinical trial data to generate SAS compliant datasets as per CDISC standards.
• Extensive experience with generation reports, tables, listings, and graphs using various procedures like proc print, proc SQL, proc means, proc univariate, proc freq, proc datasets, proc format, proc compare, proc import, proc export, proc transpose, proc append, proc summary and proc connect.
• Successfully increased portability of existing SAS programs and created new programs using SAS Macros variables to improve efficiency and consistency of results.
• Have practical knowledge of implementing CDISC - SDTMIG - v 3.1.1 and v 3.1.2.
• Experience in CDISC SDTM in house conversions.
• Good understanding of GCP.
• Have worked closely with statistician/data managers in analyzing the clinical trial data.
• Successfully handled responsibilities for extracting internal/external data, data cleaning and validation, analysis, and report generation.
• Self - motivated individual with strong Technical & Analytical skills. Always keen and eager to face up to challenges by means of novel and innovative ideas.
• Good Knowledge of Importing data from Oracle, DB2 other databases using SQL Pass - Through Facility.
• A good team player with strong ability to learn, adapt new skills and makes efforts to work effectively.

TECHNICAL SKILLS

SAS Software: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/CONNECT, SAS/SHARE.

SAS Procedure: Means, Summary, Freq, Sort, Print, Append, Import, Export, Format, Tabulate, Compare, Contents, SQL, Univariate, Transpose.

Database: SQL Server (2000/ 2005/ 2007 ), MS Access, Oracle 9i/10g.

Operating System: Windows NT, XP, Windows 7, UNIX.

Programming Language: SAS, HTML, JAVA Script, XML, PL/SQL, VB Script.

Therapeutic Areas: Oncology, Gastro esophageal Reflux Disease and Resistant systolic Hypertension.

PROFESSIONAL EXPERIENCE

Confidential - Durham, NC

Programmer/Analyst

Responsibilities:

• Developed generic codes to perform DMCC checks for all studies as per CDISC standard validation.
• Extensively used different programming techniques such as Proc sql, data null, proc print, proc sort, data step, and proc dataset.
• Pull the data using DICTIONARY tables and columns.
• Used variety of functions such as index, scan, substr, trim, upcase, exist, open, close, strip, reverse, cats, left, anyspace, anydigit, anylower, anyupper.
• Adequately used Macro functions such as %sysfunc, %str, %eval, %sysevalf.
• Developed generic macro code to run on all the domains and all variables.
• Created programs for edit check listings and generated reports using proc sort, data step, proc report and excel output listings through ODS tagsets.
• QC on the NON eCRF data guideline against structure document for variable name, label, type, informat and format.
• Updated data in existing dataset using proc sql.
• Worked on validation phase I and phase II.
• Involve in dataset compliance with SDTM according to CDISC standards
• Executed SAS codes on SAS batch mode using UltraEdit.
• Good understanding of regulatory requirements such as GCP.

Environment: SAS 9.2, SAS Base, SAS Macro, UltraEdit, Windows 2007, UNIX, MS office 2013.

Confidential - Seattle, WA

Clinical SAS Programmer

Responsibilities:

• Worked with a team of Bio-statisticians and Data Managers
• Created and tested SAS programs according to specifications.
• Interact with Data Management, programming manager and Clinical Development staff.
• Performed Data Cleaning, Validation and Report generation.
• Involved in mapping data from source raw data and converted them to CDISC SDTM SAS compliant datasets using mapping specifications.
• Review of CDISC SDTMIG (v3.1.2) mapped datasets.
• Designed statistical summary tables. Preparing SAS datasets, SAS Reports, Listings and Graphs.
• Performed Data Cleaning, Validation, and Analysis and Report generation.
• Programmed statistical summary tables, listings and graphs (TLGs) using PROC REPORT, Data Null, PROC FREQ, PROC PRINT, PROC GPLOT.
• Conducted and generated the Regression, Correlation studies and Analysis of Variance using PROC REG, PROC CORR, PROC ANOVA and PROC GLM.
• Drew flowcharts indicating the input datasets, sorting and merging techniques
• Written code using SAS/Base and SAS/Macros to extract, clean and validate data from flat file, Excel file, Access Database, and Oracle Database.
• Experience in Edit Check, data extraction and integration.
• Formatted HTML, RTF and PDF reports, using SAS output delivery system.
• Generated reports, listings and graphs using SAS/Tools, SAS/Base, SAS/Macro and SAS/Graph, SAS/SQL.

Environment: SAS V9.2, SAS Base, SAS Macro, SAS GRAPH, SAS STAT, SAS Connect, Windows NT, Oracle.

Confidential - Foster City, CA.

Statistical Programmer

Responsibilities:

• Provide programming support for phase III clinical trials.
• Created CRT (Case Report Tabulations) datasets using CDISC standards for submissions to the FDA.
• Created statistical tables, listings and derived datasets. Program the integration of databases from multiple studies or sources.
• Post-baseline and change from baseline summaries.
• Frequency-percentage tabulations for categorical data and n-mean-median summaries for continuous variables.
• Produce tables and listings for a pharmaceutical based CRO.
• Validate tables and Listings. Modify Status Reports.
• Developed mapping specifications for CDISC SDTM data as per the requirements.

Environment: SAS V9.0, Base SAS, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH and Windows 2000.