SUMMARY

• Over 6 years of experience in SAS programming using SAS 8/8.2/9.1/9.2 and Data management in Healthcare, Pharmaceutical domain.
• Experience with SAS/BASE, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/GRAPH, SAS/ODS, for analysis, design, development and implementation of data models and applications for major pharmaceutical/biotech companies.
• Experience in preparation of SAS datasets, Tables, Listings, Graphs, Reports, Output Delivery System (ODS), Summaries, Standard Operating Procedures (SOPs), Statistical Analysis Plan (SAP) for inclusion in clinical study reports and regulatory submissions
• Proficient in maintenance of large data sets and data extraction from different database environments such as Oracle, MS SQL Server and MS Access to and from SAS using PROC ACCESS, SQL pass - through facility and Oracle libname engine.
• Experience in data cleansing, Data Archival, and Data Migration, ad-hoc reporting and coding utilizing SAS programming skills in SQL and understanding of data management principles, such as joining data sets, data aggregation and sub setting using PROC SQL.
• Extensive knowledge of different SAS procedures such as DATA-STEP PROGRAMMING, PROC SQL, REPORT, PRINT, MEANS, FREQ, SUMMARY, TABULATE, SORT, PROC UNIVARIATE, PROC FUNCTIONS, GCHART, GPLOT, DATASETS, APPEND, FORMAT, IMPORT, EXPORT, SUMMARY, MACROS.
• Well versed in application of statistical analysis of data including p-values, confidence intervals, linear regression analysis, ANOVA, Descriptive Statistics, Correlation Analysis, non-parametric analysis for the purposes of data analysis and reporting.
• Excellent Analytical, Organizational and Problem solving skills. Ability to focus, manage time and priorities. Excellent communication skills, self - starter, good team player, enthusiastic, and innovative.

TECHNICAL EXPERTISE

Windows 9X/NT/2000/XP, UNIX, SAS/BASE, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/STAT, SAS/ODS, SAS/ ENTERPRISE GUIDE, C, C++, SQL, PL/SQL, HTML, Oracle 8/9, MS SQL server, MS Access, MS Office 2003 suite

PROFESSIONAL EXPERIENCE

Confidential, New Brunswick, NJ

SAS Programmer

Responsibilities:

• Participated in designing, coding, testing, debugging and documenting SAS programs.
• Created analysis datasets, data listings and summary tables and performed their validation through independent SAS programming for ongoing oncology trials.
• Used various Statistical procedures for analyzing data and creating summary reports.
• Designing statistical summary tables, graphs and patient data listings using SAS BASE and SAS/GRAPH.
• Created RTF reports using ODS techniques.
• Tabulated the data so as to make it easier to analyze and create reports by extensively using PROC REPORT, and PROC TABULATE
• Coordinated with Bio-Statisticians to analyze the results obtained from various statistical procedures like ANOVA, UNIVARIATE, MEANS.
• Participated in development of programming conventions, work flow and SOPs to streamline the Data Outputs operation.
• Modified existing SAS programs and created new programs using SAS Macro variables to improve ease and speed of modification as well as consistency of results.
• Experienced in Locking and archiving databases.
• Created SAS master file that is done on a monthly and weekly basis, Used these weekly master files on Oracle databases for report generation.
• Integrate data from wide range of sources including in-house clinical data management systems, labs and contract research organizations and perform data cleaning with data steps and procedure steps
• Performed Data Analysis on the data sets using PROC ANOVA, PROC MEANS, PROC UNIVARIATE, PROC FREQ, PROC MANOVA
• Developed reports using PROC REPORT, and PROC TABULATE
• Use ODS statements and PROC TEMPLATE to create reports in style format.

Environment: Windows XP, SAS 9.1/9.2, SAS/BASE, SAS/STAT, SAS MACROS, SAS/EG, SAS/ACCESS, MS-Excel

Confidential, Indianapolis, IN

Clinical Data Analyst

Responsibilities:

• Developed project analysis plans, including table specifications, statistical analyses and report formats.
• Review of specifications, mock tables and listings.
• Performed Statistical Analysis and generated reports using SAS/MACRO, SAS/ODS, Proc Report, Proc Print, Proc Summary, Proc Freq, Proc means, Proc tabulate and Proc SQL.
• Used Base SAS to perform sorting, indexing, merging of datasets and generated reports.
• Modified existing SAS programs using SAS macro variables to improve the ease, speed and consistency of the results.
• Extensively used SAS DICTIONARY tables to get updated information on datasets.
• Extensively used BASE SAS functions like ROUND, SCAN, INDEX, SUBSTR, TRIM, LENGTH, PUT, INPUT, DATE, MAX, MIN and MEAN.
• Used SAS/ODS to generate the Statistical reports in HTML format.
• Used SAS macros functions to simplify the process and to get consistent results.
• Developed routine SAS Macros to create tables, graphs and listings for inclusion in clinical study reports and regulatory submissions and maintained existing ones

Environment: Windows 2000, AS/400, SAS 8.2/9.1, SAS/BASE, SAS/STAT, SAS MACROS, SAS/EG, SAS/ACCESS, SQL Server, MS-Excel.

Confidential, San Diego, CA

SAS Programmer

Responsibilities:

• Performed data analysis and statistical analysis using SAS/Base, SAS Macro and other procedures like Proc freq, Proc Univariate and Proc Means.
• Effectively used many SAS functions like SCAN, SUBSTR, TRIM and applied strategic logic on data using INTCK, INTNX, SUM, SQRT, STD and VAR.
• Used Dynamic Data Exchange and Proc Import for inputting data from Excel sheets.
• Generated primary and derived secondary SAS datasets, identified inconsistencies and problems in the database and reported the findings to the appropriate data management department personnel.
• Effectively and timely contacted Project Manager of the respective studies about the various data issues and resolved the queries through meetings.

Environment: SAS v8, SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACROS, SAS/SQL, SAS/ACCESS, SAS/ODS, Windows XP, and Oracle 9i.ICON

Confidential, Atlanta, GA

Data Analyst

Responsibilities:

• As a SAS programmer, took part in production team that included statisticians and system analyst.
• Developed SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generations.
• Collected requirements from statisticians, prepared requirements document. Used SQL pass-through facility to access the data. Prepared test plans and test runs for the respective program changed or created. Promoted developed code to production environment and developed associated documentation.
• Investigated and fixed several issues and proactively suggested new output formats to satisfy the statistician’s requirements.
• Created reports in PDF, HTML, RTF formats using ODS statements.
• Used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE and PROC REPORT.

Environment: Base SAS, SAS Macros, Oracle 8i, SQL, PL/SQL, MS-Excel.

Confidential

SAS Programmer/Analyst

Responsibilities:

• Created and applied user defined formats to specific variables in SAS data sets.
• Developed SAS programs using SAS/BASE and SAS/SQL for preparing, analysis and reports from databases
• Responsible for manipulating and analyzing clinical data, performing statistical analyses.
• SAS, to generate tables, listings and graphs, and producing output files for use in reports or for use by physicians, statisticians and analytic staff.
• Designed and developed reusable SAS code to prepare data for analysis.
• Provided secondary review of others output, and created and maintained necessary documentation
• Engaged in the development of SAS programs.
• Provided information and support for high-level internal and external audiences