Review database set-up specifications.

Provide leadership, project specific training, stakeholder management, external sponsor support, resource management, and project management for the required programming tasks supporting clinical trial activities.

Interact with sponsors and internal stakeholders with regard to statistical programming issues.

Assist project teams in the resolution of problems encountered in the conduct of their daily work.

Deliver best value and high quality service.

• Created customized reports to help client provide in understanding risk and accordingly perform better customer selection and customer satisfaction.

• Proficiently used SAS procedures like PROC SQL to extract data from different relational database management systems and used SQL Assistant to analyze and query from the Teradata DB.

• Performed Data Cleansing widely during the ETL's Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.

• Extracted, transformed and loaded data from large Teradata tables using Data stage in data ware house. Passed parameters in shell script to read daily and on request jobs to reduce complexity of business process.

• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools.

• Maintained large data sets, combined data from various sources in varying formats to create SAS data sets.

• Create partition tables and apply threading techniques using SASTRACE.

• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT and PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.

• Performed Data analysis, mainly using Regression and ANOVA (Proc REG, Proc GLM, and Proc ANOVA).

• Created reports in the style format (RTF, PDF and HTML) using SAS/ODS.

• Efficiently prepared and published various performance reports and presentation

• SAS programming expertise in producing ADAMS, Tables, Listings and Graphs from SAS/BASE, SAS/MACRO and SAS/GRAPH, SAS/SQL, SAS/ STAT.

• Develop, modify and validate SAS programming work according to Statistical Analysis

plan (SAP).

• Created and validated ADAM datasets like ADSL and BDS datasets for the study

• Created tables, listings, graphs for safety reports.

• Performed Statistical Analysis using SAS/STAT procedures PROC MEANS PROC FREQ

etc

• Worked on datasets like Demographics, AE, Vitals, Concomitant medication, Physical

Examination, Labs.

• Generate reports, listings and graphs using SAS/BASE, SAS/MACRO, SAS/SQL and

SAS/STAT.

• Create reports in RTF/pdf format using SAS Output delivery system as per the client requirement.

• Extract data from Oracle database using SQL pass through facility, MS Access, Tagsets Excel sheets, and Delimited text files. Import and export procedures were applied in these procedures.

• Extracted, merged the data from diverse sources using matching conditions and then upload in to the data warehouse based on user defined Business rules.

• Develop SAS Reports using PROC REPORT, PROC TABULATE and load SAS data sets as tables into Oracle and SQL Server using SQL pass through facility, library reference method.

• Validate data and create reports using different procedures like Freq, Means, Transpose, Datasets, Sort, Compare, SQL, REPORT and SAS/ODS facility.

• Create, enhance and incorporate new systems with existing systems SAS Programs for generating reports, graphs, tables and lists.

• Indexing huge SAS data sets and utilizing those indexes as a part of SQL queries for quick results and write SQL joins to Merge the data sets to find exceptions from different tables.