Employer details.

Professional Summary

• SAS Programmer with 7 Years of experience in using SAS for programming and reporting in Pharmaceutical industry.
• Strong experience in Base SAS, SAS/MACROS, SAS/ACCESS, SAS/CONNECT, SAS/GRAPH, SAS/STAT, SAS/ODS, SAS/CDI and SAS/SQL in Windows.
• Experience in transforming data in various formats excel, CSV, ASCII into SAS datasets.
• Developed programs in SAS Base for converting the Oracle Data into SAS datasets using SQL Pass through facility and library engines.
• Excellent command in producing reports employing various SAS procedures like Proc Report, Proc Tabulate, Proc Mean, ProcFreq, ProcUnivariate, Proc Transpose, and Data NULL etc.
• Strong experience using SAS/GRAPH to produce Graphs by employing SAS procedures such as Proc GPLOT and Proc GCHART.
• Exceptional ability in problem solving, data analysis, complex reports generation with macro and data transfer between different environments.
• Knowledge of Clinical Data Interchange Standards Consortium CDISC relating to data standards including Study Data Tabulation Model SDTM , Analysis Dataset Models ADaM .
• Good understanding of Clinical Trial Phases, clinical protocols/ CRF's/Annotated CRF's, ICH and GCP guidelines, NDA, IND, MedDRA, 21 CFR PART 11. Familiar with Electronic submission guidelines to FDA.
• Excellent communication, interpersonal skills with strong analytical and problem solving skills. Ability to learn quickly and take up new tasks and responsibilities. Can work effectively in cross-functional team environments.
• Good team player with excellent technical and interpersonal skills. Pro-active, self-motivated and able to work independently as well as in team.
• Experienced in producing RTF, PDF, and MS Excel formatted files using SAS ODS facility.
• Created SAS data sets and generated listings, Analysis Data Sets ADS , graphs and tables TLG as per Statistical Analysis Plan SAP , also performed validation of the CDISC Models.
• Experience in data cleaning and resolving data issues as well as merging data from different sources into a single integrated dataset.
• 100 Project completion on time while meeting strict timelines and budget requirements.

Technical Skills:

• SAS Skills: BASE SAS, SAS/Enterprise Guide, SAS/DI 4.3SAS/MACRO, SAS/CONNECT, SAS-SQL, SAS/STAT, SAS/GRAPH, SAS - ODS, SAS/ACCESS, SAS/CDI.
• SAS Procedures: TRANSPOSE, CONTENTS, MEANS, CHART, PLOT, TABULATE, UNIVARIATE, SUMMARY, SORT, SQL, FORMAT, FREQAND DATASETS
• Operating Systems: MS WINDOWS2003/2008
• Databases: ORACLE

Professional Experience:

Confidential

Clinical SAS Programmer

PPD is a leading global contract research organization providing drug discovery, development, lifecycle management and laboratory services. Clients and partners include pharmaceutical, biotechnology, medical device, academic and government organizations. With offices in 46 countries and more than 13,000 professionals worldwide, PPD applies innovative technologies, therapeutic expertise and a commitment to quality to help clients and partners accelerate the delivery of safe and effective therapeutics and maximize the returns on their R D investments.

Responsibilities:

• Loading the data from various sources into the system.
• Worked with statisticians in analyzing the Clinical Trial Data, generated reports, tables, listings and graphs using SAS in accordance with the Statistical Analysis Plan SAP and departmental guidelines.
• Created reports for online and batch applications for various servers.
• Modified data using SAS/BASE and Macros.
• Understanding and using departmental utilities, processes, and procedures where applicable.
• Involved in publications, programming and testing of utility macros for standard reports and validation.
• Involved in analysis of Phase II and III clinical trials.
• Created SDTM datasets and ADAM datasets according to CDISC standards.
• Prepared graphs using the modified data for business analysis.
• Produced Safety reports in PDF format.
• Worked with Data management team, investigating data issues and solving technical problems.
• Accuracy, completeness, quality, and timeliness of clinical programming deliverables.
• Performed QC of derived datasets, TLG's and coded programs and involved in Data Validation.
• Performed program documentation on all programs, files and variables for future reference.
• Programmed all study-specific edit checks and review listings.

Environment: SAS 9.2 SAS/BASE, SAS/ODS, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/STAT, SAS/ACCESS, MS Excel/Word/PowerPoint

Confidential

Clinical SAS Programmer

Confidential company that researches and develops a broad range of innovative products in three primary areas viz., Pharmaceuticals, Vaccines and Consumer Healthcare. GSK has a significant global presence with commercial operations in more than 150 countries, a network of 86 manufacturing sites in 36 countries and large R D centers in the Confidential.

Responsibilities:

• Created, derived and pooled datasets, listings and summary tables.
• Verified the accuracy and integrity of data by performing validation checks written in SAS and investigate data related errors, outliers, and missing values.
• Developed and executed edit check programs according to specifications provided by data management operations for purposes of database verification.
• Involved in managing phase II and III clinical trial data in the respective projects.
• Used SAS SQL Pass through facility and Libname facility to import and create datasets from Oracle database.
• Developed and executed Proc SQL queries for merging, concatenating, and updating large volumes of data.
• Used Base SAS MEANS, FREQ, SUMMARY, TABULATE, REPORT etc. and SAS/STAT procedures REG, GLM, ANOVA, UNIVARIATE etc. for summarization, Cross-Tabulations and statistical analysis purposes.
• Created complex and reusable Macros for various instances for automating listings and graphing of data for analysis.
• Developed statistical reports by using Proc Report, Data null and SAS Macro.
• Executed report programs and imported the results into Excel for data analysis.
• Created Adhoc reports using the SAS procedures and created reports using ODS statements and Proc Template to generate different output formats like pdf and excel.
• Created SDTM datasets according to CDISC standards using Base SAS and validated using validator tools.
• Collaborated with Data Management to annotate raw data with standardized variables and formats using Proc Datasets, Proc Formats.
• Performed data extraction from various repositories and pre-process data when applicable.

Environment: SAS/BASE, SAS/ACCESS, SAS/SQL, SAS/MACRO, SAS/GRAPH, SAS/STAT, Windows.

Confidential

Role: Clinical SAS programmer

Responsibilities:

• Involved in managing randomized phase II and III clinical trials data.
• Extracted data from Oracle using SQL Pass through facility and generated ad-hoc reports.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets and/or ASCII files by using Set and Merge for generating Reports and Graphs.
• Developed new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, Formats, Functions and conditional statements.
• Extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Generated Tables and Listings for inclusion in Clinical study reports and regulatory submission.
• Participated in preparing study results as well as ISS,IND and NDA application for FDA submissions using SAS.
• Modified macros for report generation using SAS Macros as per the Biostatistician's requirements.
• Developed safety tables including Adverse Events table, Laboratory Shift table and Concomitant Medication tables.
• Attended project team meetings, worked with Bio-Statisticians, Data Managers, and Clinical Research Managers as appropriate.
• Gone through the documentation like study protocols, SAP's, CSR etc.,
• Supervision of Clinical data base building.
• Generated derived data sets for the statistical analysis as per SAP.
• Generated Ad-hoc reports and browser viewable reports using SAS ODS.
• Successfully handled multi-projects/tasks at a time.
• Got a good understanding of Clinical Trial Phases, clinical protocols/ CRF's/Annotated CRF's, ICH and GCP guidelines, NDA, IND, MedDRA, 21 CFR PART 11. Familiar with Electronic submission guidelines to FDA.

Environment: SASBASE, SAS/STAT, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, ORACLE CLINICAL

Confidential

Role: Clinical SAS programmer Junior

Responsibilities:

• Successfully implemented statistical reporting processes for regular data collection and clinical data analysis.
• Analyzed Phase II and III Clinical Trials.
• Experience with SAS programming and in data step and with various SAS procedures in Base SAS and SAS/Stat.
• Performed Data analysis, generated reports, listings and figures using SAS TOOLS SAS/BASE, SAS/MACROS, SAS/SQL, SAS/CONNECT, SAS/ACCESS.
• Retrieved ORACLE tables with PROC SQL using PASSTHRU facility.
• Used sorting and merging techniques along with SAS functions on the input data sets for Data manipulation, to get the required output and then writing the code using SAS tools.
• Created SAS customized reports using the DATA NULL technique for evaluations.
• Produced quality customized reports by using PROC TABULATE, REPORT, and SUMMARY.
• Also produced descriptive statistics using PROC MEANS, FREQUENCY AND UNIVARIATE.
• Used the SAS Macro facility to produce weekly and monthly reports.

Environment: SASBASE, SAS/STAT, SAS/MACROS, SAS/GRAPH, SAS/ACCESS

Confidential

End Client: Royal Bank of Scotland

Role: SAS Programmer

• Confidential is a Consulting Provider Company.
• This project deals with the Standard file layout for all the Business Users clients from the Data warehousing. Process is fully automated Using PROC FORMAT, ODS, PROC PDF, PROC HTML, DATA NULL , MACROS .

Responsibilities:

• Analyzing the task before doing the configuration.
• Maintaining large data sets, i.e. reading in data from various sources in various formats to create SAS data sets and/or ASCII files.
• Documenting the process, i.e. documenting all the possible information about the application like SAS programs, DATA files and source.
• Creating ad-hoc reports.
• Identifying the tools to use in the process.
• Implementing the process in intervals and testing the process.
• Used SAS ODS to create HTML, RTF and PDF outputs files in the process of producing reports.
• Used SASPROC SQL Pass through Facility to work with oracle database.
• Used SAS DATA NULL and PUT statements to create the customized reports.
• Extensively using existing macros for report generation using SAS/Macros as per the customer's requirements.
• Default Report output is HTML and provided the options of RTF EXCEL formats using SAS/ODS statements.
• Used FTP to download SAS Formatted Data into EXCEL AND CSV format.

Environment: SAS /Base, SAS/Macro, SAS/CONNECT, SAS/STAT, SAS/GRAPH.