SUMMARY

• SAS Programmer with 7 years of experience in using SAS tools for analysis. Development, design and implementation of various pharmaceutical and clinical environments.
• Sound knowledge on accessing raw data from different databases like Excel, SQL, MS ACCESS and ORACLE to extract raw data.
• Used SAS to import, export, read and write different data file formats like Spreadsheets, Microsoft Excel and Access.
• Generated reports and analysis datasets from raw data using SAS Macros.
• Experience in preparation of SAS datasets, creating reports, tables, listings and graphs (TLG’s) using BASE SAS techniques according to the Standard Operating Procedures (SOP) and specified guidelines.
• Generated reports from raw data using BASE SAS procedures like PROC IMPORT, PROC FORMAT, PROC EXPORT, PROC SORT, PROC FORMAT, PROC APPEND, and SAS FUNCTIONS.
• Handled different types of SAS data like Demographics, Lab data, Adverse events and Vital signs.
• Good knowledge in ad - hoc reporting and converting SAS datasets to different file types like HTML, PDF and RTF files using SAS ODS and convert different file types to SAS datasets.
• Familiar with ICH, GCP and FDA guidelines and knowledge about different phases of clinical trials and the guidelines for generating reports as per CDISC, SDTM, ADaM and FDA guidelines.
• Formatted data using statistical procedures like PROC ANOVA, PROC UNIVARIATE, PROC REG, PROC MEANS, PROC LIFETEST AND PROC CORR.
• Familiar with different phases of clinical trials, study protocols and analysis plans of pharmaceutical data.
• Developed monthly and weekly reports for assessment of project progress.
• Experience in programming, debugging and reporting data.
• Experience in data transforming and analyzing Case Report Form (CRF) data.

TECHNICAL SKILLS

Operating system: Windows XP, Vista, Windows 2007

SAS: V 9.2, SAS/BASE, SAS/ACCESS. SAS/SQL, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/REPROTS AND SAS/ODS.

Database: ORACLE, SQL, MS ACCESS

Languages: SAS, C

Others: MS Office (All versions), STATA.

PROFESSIONAL EXPERIENCE

Confidential, Santa Clara, CA

SAS Programmer

Responsibilities:

• Filtered data to separate missing values, avoid duplicates, sort, merge and create new data sets.
• Used existing macros and created new macros to reduce the programming time.
• Performed verification, documentation and review of all the procedures following standard operating procedures (SOP).
• Generated reports, listings and graphs using SAS/ACCESS, SAS/SQL, SAS/GRAPH, SAS/STAT AND SAS/ODS.
• Expertise in generating reports and tables using SAS REPORTS, DATA NULL and SAS TABULATIONS.
• Created statistical reports using SAS procedures like PROC MEANS and PROC FREQ.
• Generated tables and reports from Phase I, Phase II and Phase III of clinical trials data
• Developed ad-hoc reports as per requirements.
• Validated reports using PROC COMPARE.
• Generated safety and efficacy tables for different studies from ISS and ISE.
• Accessed raw data from different databases like ORACLE using PROC DBLOAD and created SAS views and tables.
• Accessed and modified data using SAS procedures like PROC IMPORT and PROC EXPORT, PROC TABULATE, PROC FORMAT and PROC SORT, merging the sorted datasets and generating reports as PDF, RTF or HTML files using SAS ODS.
• Produced weekly and monthly reports using existing SAS macros.
• Analyzed and checked Case Report Form (CRF) data.

Environment: SAS/SQL, SAS/MACROS, SAS/BASE, SAS/STAT, SAS/GRAPH, PL/SQL, SPSS Oracle8

Confidential, Ann Arbor, MI

SAS Programmer

Responsibilities:

• Extensively used SAS techniques like PROC FORMAT, PROC SORT, SAS REPORTS, SAS TABULATIONS and MERGE to modify the existing data and create reports as per client requirements.
• Extracted raw data from different databases using LIBNAME and PROC SQL.
• Generated reports using SAS REPORTS and converted output to PDF, RTF and HTML files using Output Delivery Systems (ODS).
• Used SAS ACCESS, SAS MACROS to access and modify data according to the client requirements.
• Performed statistical analysis and generated graphs and charts using PROC GRAPH and PROC PLOT for various types of data for easy interpretation by the end user.
• Converted ORACLE datasets into SAS datasets using PROC SQL and created SAS views and tables.
• Modified data using SAS procedures for merging, sorting, appending and formatting raw data.
• Created new macros to reduce the programming time and used existing macros.
• Debugged of SAS programs using DATA NULL and PUT statement.
• Reviewed data and reports.

Environment: SAS Base 9.2, SAS/Base, SAS/STAT, SAS, SQL, SAS/Access, SAS/ODS, SAS/Graph, SAS Macro, MS-Excel, MS-Access, Windows.

Confidential

SAS Programmer

Responsibilities:

• Used procedures like Proc Means, Proc Freq and Proc datasets to run metrics on different datasets.
• Generated tables, listings and graphs for clinical trial data.
• Supported in generation of ad-hoc reports.
• Performed statistical analysis on data using PROC ANOVA, PROC GLM, PROC UNIVARIATE.
• Used SAS MACRO’s to generate reports from raw data.

Environment: SAS Base, SAS/STAT, SAS/Graph, SAS Macro, MS-Excel, MS-Access, SQL, Oracle Clinical, Windows, SAS/AF, Oracle 8, Clinical Trial.

Confidential

SAS Analyst

Responsibilities:

• Extracted data from databases and creating SAS datasets.
• Programmed using BASE SAS techniques.
• Developed graphs using PROC GCHART.
• Generated reports using PROC REPORT and Generating Tables by using PROC TABULATE, merging, sorting and formatting raw data.

Environment: SAS Base, SAS/STAT, SAS/SQL, SAS Macros, SAS/Graph, ODS, Oracle Clinical, MS-Excel, and Windows 2000 Server.