SUMMARY

• Advanced Programmer for SAS9 with over 6 years of experience in Pharmaceutical, BLS and Clinical Research.
• Experience comprises of data capture, data validation, data analysis, report generation and intense documentation using SAS/Base, SAS/Macros
• SAS/Stat, SAS/SQL, SAS/graph SAS/Connect and SAS/Access on Windows and UNIX platforms.
• Worked on CNS, Cardiovascular and Oncology clinical data in Phase I, II, II and IV of Clinical Trials in compliance with Clinical Protocol, SAP and internal SOPs.
• Worked with statisticians, Data managers and Clinicians to provide SAS Programming support in analyzing Clinical Trial Data, generating final study reports, tables, listings and graphs for onward submission to FDA.
• Performed QA edit checks and data validation.
• Expertise in Data Manipulations using SAS data step statements such as, SAS Formats/Informats, Merge, DATA NULL, Set
• Functions and conditional statements and prepared statistical summaries and reports for use in regulatory hearings.
• Performed Statistical Analysis (Regression and ANOVA) and predictive modeling using SAS/Stat.
• Produced Survival Analysis reports for oncology studies.
• Modified existing SAS programs and created new programs using SAS macros to improve ease and speed of modifications as well as consistent results.
• Extensively wrote SQL Programs to Extract, Manipulate and Report Data from Oracle.
• Good understanding of Clinical Trials research methodologies and ICH guidelines.
• Created Pharmacokinetic (PK) and Pharmacodynamic (PD) analysis and reporting (A&R) datasets.
• Good knowledge on new drug release life cycle, IND and NDA
• Good understanding of CDISC SDTM mapping specifications and data definition tables (DDT).
• Created datasets for integrated summary of safety (ISS) and integrated summary of efficacy (ISE).
• Generated output files in RTF, PDF, and HTML formats using SAS ODS.
• Involved in efficiency SAS programming to increase I/O efficiency while working with large datasets.
• Expertise in various SAS procedures such as Proc format, Proc Report, Proc Means, Proc Sort, Proc GLM, Proc datasets, Proc Univariate
• Proc Tabulate, Proc Freq, Proc reg, Proc Gplot, Proc Gchart, Proc Mixed, Proc Import, Proc Export and Proc transpose.
• Excellent communication skills, Self - starter, good team player, enthusiastic and challenge oriented.

TECHNICAL SKILLS

Operating Systems: Windows, UNIX

Languages: SAS, SQL, C, C++, PL/SQL

Web Technologies: HTML, XML, XSD, XSLT

Packages: MS - Office-2010 (Word, Excel, Access and Power point)

Tools: SAS/Base, SAS/Macros, SAS/graph, SAS/Connect, SAS/Access, SAS/Stat

Databases: TERADATA, Oracle, Sybase

PROFESSIONAL EXPERIENCE

SAS Programmer

Confidential, Ardsley, NY

Responsibilities:

• Review and acquired knowledge about documents related clinical trials like clinical protocol, SAP, Clinical Study Report and CRF (Annotated CRF).
• Worked with Clinical Data Management team for creating clinical datasets by using different Proc SQL joining techniques such as outer join, left outer join, and full outer join, union all join, and merge processes.
• Extensively involved in creating safety and efficacy tables, listing and figures by using different SAS procedures such as Proc Print, Proc means, Proc Report, Proc Tabulate, Proc Graph and Proc Plot.
• Created SAS Customized Reports using the Data Null technique for FDA evaluations.
• Using SAS/STAT, Proc Reg, Proc ANOVA, and Proc Corr to perform analysis of variance for balanced or unbalanced clinical trial designs.
• Performed Debugging on the existing codes and datasets to validate and manipulate clinical data.
• Extensively used company standard macros for effective and efficient outputs for clinical trials. Created study specific macros too for better performance.
• Hands on Experience in developing Ad - hoc reports and Excel pivot charts to compare the different clinical trials.
• Participated in automating and optimizing the SAS codes to reduce the efforts and errors.

Environment: SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/SQL, SAS/WINDOWS, SAS/MACRO, MS Access, MS Excel.

Sr. SAS Programmer/Analyst

Confidential, Wausau, WI

Responsibilities:

• Extracted and analyzed data from the database using SAS/Access, SAS/SQL procedures and created SAS datasets.
• Created complex SQL queries to access the Oracle database.
• Performed various statistical works to resolve and develop SAS applications using PROC REG, PROC UNIVARIATE, PROC CORR, PROC ANOVA, PROC MEANS etc.
• Created new financial tables and manipulated customer data by using various joins and merges and then appended the data (proc append) from the existing source tables containing millions of records.
• Developed summary reports and graphs using SAS procedures like PROC FREQ, PROC GRAPH, PROC GPLOT, PROC GCHART, PROC UNIVARIATE
• PROC SUMMARY, PROC REPORT, PROC MEANS, and PROC TABULATE etc.
• Used ODS statements and PROC TEMPLATE to create reports in style format.
• Used SAS extensively to create ad hoc reports, match merge and created graphs by using SAS/GRAPH base.
• Data validation was done using SAS Enterprise guide.
• Used several arithmetic, aggregate, character, date time, character sting matching and special mathematical functions in expression builder while mapping the data to output datasets

Environment: Windows XP, Oracle, Base SAS 9.2, SAS/MACRO, SAS/STAT, SAS/SHARE SAS/ETS, SAS/GRAPH, SAS/ACCESS, SAS ENTERPRISE GUIDE 4.2, Teradata 12.

SAS Programmer/Analyst

Confidential, NYC

Responsibilities:

• Programming and analyzing in guiding with the design and development of the application.
• Data Preparation: Drawing flowcharts indicating the input data sets, sorting and merging techniques to get the required output and then writing the code.
• Data validation: Data is validated before use the same for final analysis.
• Data Analysis: The validated data is analyzed to get the following: Market share Find top customers for the target lists Look for responsiveness of targets based on sales force effort.
• Extensively used Arrays in SAS Data Steps.
• Merging Datasets and Manipulating Datasets.
• Extensively done SAS/Macro Programming.
• Used SCL for customized method developments and integrating PROCs with components.
• Used SAS DATA NULL and PUT statements to create the customized reports.
• Developed new macros for report generation using SAS/Macro as per the customer's requirements.
• Produced SAS Graphical reports showing Trend Analysis charts for campaign.
• Used SAS PROC SQL Pass through Facility and SAS/CONNECT to work with Oracle database.
• Used SAS GRAPH for generating various graphs and charts for analyzing the product sales.
• Upload SAS data sets across platforms from PC to UNIX and Vice Versa.

Environment: SAS/BASE (V9.1.3, V8.2), SAS/STAT, SAS, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/ETS, SAS/QC, SAS/Connect, UNIX, SQL, MS Access, EXCEL, SPSS, Windows XP.

SAS Programmer/Analyst

Confidential, Jersey City, NJ

Responsibilities:

• Programming of data listings, Summary tables, Categorical tables and figures using Base SAS, Macros, SAS graph and SAS Stat and analyzed the data.
• Worked mainly on Central Nervous System and Cardiovascular therapeutic areas.
• Extensively used the SET, Update and Merge statements for creating, updating and merging various SAS datasets.
• Created analysis datasets from raw datasets as per the specifications.
• Performed Edit check programming, to identify potential data issues and Export the final listings output to Excel.
• Created and used macros for generating tables, listings and graphs.
• Provided SAS programming support to statisticians, Data managers, and the Writers to develop reports.
• Reviewing of Statistical Analysis Plans (SAP), Mock - up tables and listings.
• Generated tables, listings and graphs as well as integrated summary of safety (ISS) and integrated summary of efficacy (ISE) reports and NDA for onward submission to FDA.
• Created RTF, PDF, and HTML listings, tables and Reports using SAS ODS.
• Developed CDISC SDTM mapping specifications and created data definition tables (DDT).
• Created transport files as per the CDISC standards for electronic submissions to the FDA.
• Extensively used Macros, SQL and PL/SQL to improve data extraction and manipulations.
• Developed data models using regression analysis for future predictions.