SUMMARY

• Extensive experience over 7 years in analysis, design and development of Projects for Pharmaceutical industry and health care industry.
• Experienced in handling large amount of health care data using table driven architecture.
• Familiar with cisco tidal enterprise scheduler.
• Experience in implementing CDISC standards to clinical trial data using converting raw datasets to SDTM datasets with of mapping documents prepared by following SDTMIG.
• Experience in analyzing and reporting experience using SAS in Cardiovascular, Oncology therapeutic areas.
• More than 2years of Profoundexperience in understanding in working with Large Datasets /Databases and data mining using SAS ENTERPRISE MINER.
• Developed SAS Programs to generate reports employing various SAS procedures like PROC PRINT, PROC REPORT, PROC PLOT, PROC CHART,PROC SQL,PROC SUMMARY,PROC FREQ, AND DATA NULL, PROC GPLOT.
• Familiar with various data analysis methods including t - test, z-test, repeated measure analysis test, linear regression, Wilcoxon singed rank test, Kruskl-wallis test, Binomial test, Chi-square test, Fisher’s Exact test, Log-rank test.
• Good knowledge of Clinical Trials Research Methodologies and also Federal Regulations (21 CFR Part 11) and other regulatory guidelines and CDISC SDTM standards for regulatory submissions.
• Sound knowledge of CLINICAL TRIALS DATA like Demographic Data, Adverse Event, Serious Adverse Events, Vitals,Laboratory Data and Bioavailability.
• Experience creating reports in HTML, PDF AND RTF formats using SAS/ODS facility and also in generate Tables, Listings and Graphs by SAS/BASE, SAS/MACROS, SAS/GRAPH, SAS/STAT and departmental guidelines.
• Expertise in using SAS/STAT procedures like PROC UNIVARIATE,CORR,REG,ANOVA,RANK and TRANSPOSE, PROC NILN, PROC PROBIT.
• Proficient with data cleaning, transformation, validation and model building using various SAS tools.
• Experienced using SAS on UNIX domain Strong experience in new application developments and enhancements of existing applications by following Software Development Life Cycle (SDLC) i.e. Requirements gathering, design, development, testing and maintenance by following Software Development Life Cycle (SDLC) to implement software applications using SAS Reporting and SAS Data warehousing (ETL - Extraction, Transformation and Loading).
• Experienced in performing procedures like PROC MIXED, PROC LOGISTIC, PROCLIFE TEST, PROC LIFETEST, PROC PHREG, PROC NPAR1WAY and PROC MULTITEST.
• Producing data in various output formats including HTML, RTF, XML, PCL, PDFusing ODS (output Delivery System).
• Developed standard macros and also used existing macros wherever possible by defining the macro parameters and different debugging options.
• Experience in creating and transporting files using PROC COPY and importing using PROC CIMPORT.
• Ability to Work under Pressure, Self starter, self motivated,, ability to interact with individuals at all levels and meeting deadlines, recording regular activities by commenting codes and documenting while doing analysis.

TECHNICAL SKILLS

SAS Versions: SAS 9.0, SASV9.1.3, SAS 9.2, SAS ENTERPRISE GUIDE.

SAS Tools: Base SAS, SAS/SQL, SAS/MACROS, SAS BI, SAS DI, SAS/DM,SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/ACCESS, SAS/CONNECT,SAS ENTERPRISE MINER.TDA, TIDAL.

SAS PROCEDURES: PROC PRINT, PROC REPORT, PROC PLOT, PROC CHART, PROC SQL, PROC SUMMARY, PROC FREQ, AND DATA null . PROC UNIVARIATE, CORR, REG, ANOVA, RANK and TRANSPOSE, PROC NILN, PROC PROBIT. PROC MIXED, PROC LOGISTIC, PROC LIFE TEST, PROC LIFETEST, PROC PHREG, PROC NPAR1WAY and PROC MULTITEST.PROC COPY,PROC CIMPORT

REPORTING TOOLS: MS Excel, MS Word, MS-PowerPoint.

REPORTING FORMATS: HTML, RTF, XML, PCL, PDF.

OPERATING SYSTEMS: WINDOWS,UNIX, LINUX.

DATA BASE: ORACLE, MS-ACCESS,MS SQL SERVER, DB2.

PROFESSIONAL EXPERIENCE

SAS programmer/analyst

Confidential, West Hartford, CT

Responsibilities:

• Conducted independent statistical analysis, descriptive analysis, hypothesis testing and logistic regression.
• Provided assistance for health care projects through SAS statistical and analysis software tools.
• Assisted in development of data formatting and cleaning criteria from various data sources.
• Generated database reports, presentation and documentation of analytical methods.
• Performed ad hoc analysis of data sources for all external and internal requirements.
• Coordinated with clients for management of data mining and recovery projects.
• Participated in refinement and technical documentation of database reporting requirements.
• Extensively worked on Table Driven Architecture(TDA) for implementation and production of large health care data of different clients.
• Hands on experience on Cisco TIDAL ENTERPRISE SCHEDULER.
• Formulated procedures for data extraction, transformation and integration of health care data.
• Conducted assessment to ensure data quality and completeness with validation techniques.
• Assisted in designing and development of health related analytical products for overall enterprise.
• Provided assistance for quantitative data analysis with health care, biometric and survey data.
• Designed and developed continuous outcomes reporting for multiple intervention programs.
• Participated in critical review and revision of existing systems for updates and enhancements.
• Supported data management team for development and execution of supplemental analytical tools and methods.

Environment: SAS (V9.3), SAS ENTERPRISE GUIDE, TDA, CISCO TIDAL,SAS/SQL, SAS/MACROS, SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/REPORT, ORACLE.Ms-office, Outlook.

Clinical SAS programmer

Confidential, San Diego, CA.

Responsibilities:

• Created complex and reusable Macros, used existing Macros, developed SAS Programs for Data cleaning, Data validation, Data analysis and Report generation.
• Extensive knowledge of three different areas. The first is medical claims with all the associated clinical claim data such as diagnosis codes, drug codes and procedure codes.
• Worked closely with the Actuarial department to provide analysis of per diem data for inpatient services and the setting aside of reserves based on usage. This work was mainly SAS based.
• Worked on the systems for the Marketing Account Reporting unit. This involved taking on HMO data from a new data source.
• Assigned the analysis of this new data feed and how to translate the various data entities into the system. Also many of the programs had to be amended to take notice of the new data. The System was written in SAS and the output was of a graphic form producing tables and pie charts of usage. The whole package produced Trend Reports, which were then taken to the Participating Groups.
• Worked closely with the Research and Development department providing data extracts of claims and data in SAS format which they then produced reports for the U.S. Government Hedis reports
• Worked extensively on SAS DI, SAS BI and ENTERPRISE MINER.
• Develop and plan programming documentation including plans and specifications, as appropriate.
• Extensively used Proc SQL to perform queries, create, join and manage tables.
• Generated numerous ad-hoc reports on routine basis

Environment: SAS (V9.2), SAS/SQL, SAS/MACROS, SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/REPORT, ORACLE.Ms-office, Outlook.

SAS Programmer

Confidential, Eagan, MN

Responsibilities:

• Data Analysis of Phase I Clinical trials, responsible for providing the biometrics team with programming support.
• Created SDTM and CDISC datasets for phase I studies.
• Read in and reconciled electronic data with the CRF.
• Batch run and QC datasets to ensure their accuracy and that they meet client specifications.
• Performed recons of raw lab file, PK, ECG files.
• Took on responsibility for studies to ensure that the datasets and associated documents are completed in a timely manner.
• Updated the SDTM datasets based on client comments received on draft/pre-final stage datasets.
• Coordinated with the biostatisticians and Data management team in dealing with the data issues, and to better understand the data required for programming.
• Performed 1 Volume checks of the datasets prior to sending it to the client.
• Performed QC of datasets, DDDs, CRF to ensure their accuracy and that they meet the client specifications.
• Developed SAS Programmable edit checks to assist in data review as needed.
• Attended weekly s on SDTM datasets, QC of datasets, updating the code, performing recons.
• Communicated effectively with the other programmers of the team and overseas team in ensuring that the deliverables reach to the client on time.
• Effective use of SAS DI for history load management and generating reports.
• Worked on SAS Business Intelligence (BI) platform to drive the automation of standardized analytics.
• Generating SAS EG stored processes with static and dynamic prompts for product-specific analyses.
• Modifying existing codes for improvement in the performance.Advanced Querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finallygeneratingSASdatasets.

Environment: SAS BI/SAS Enterprise Guide,SAS DI, SAS/Macros, SAS/Base, SAS/SQL, SAS/ODS, SAS/GRAPH, MS Word, Excel, Power Point, Outlook, Ultra Edit, Linux.

Confidential, Columbia, MD

Statistical Programmer

Responsibilities:

• Extracted data from Oracle using SQL Pass through facility, Proc Access, Libname Method and generated reports.
• Performed statistical analysis, wrote SAS code for data management and reporting, and performed validation, including testing SAS code.
• Performed program documentation on all programs, files and variables for accurate historical record and for future .
• Extract data from Excel into SAS datasets.
• Created summary reports and tabular reports using Proc Tabulate and Proc Report.
• Performed data quality checks on very large physician database for large pharmaceutical using SAS.
• Created analysis ready datasets for statistician as well as sales performance reports for client.
• Wrote and executed quality control programs for epidemiological study.
• Performed QC (Quality Check) extensively on tasks performed by other team members
• Performed Data Validation and Data Cleaning. Involved in All Phases of Clinical Study.
• Extensive use of Proc SQL to perform queries, join tables.
• Develop Annotated CRF Pages for the study protocols.
• Extensive Experience in Clinical Data Analysis, Producing Tables, Listings, and Graphs.
• Experience in producing outputs in PDF, and RTFformats using SAS/ODS.
• Modification of existing SAS programs and creation of new programs using SAS Macros.
• Worked with Statisticians and Clinical Data Managers to provide SAS programming in analyzing the Clinical Trials and generating Reports.
• Worked on multiple protocols and/or drug compounds at a time.
• Retrieve Oracle tables with PROC SQL using ‘Pass through Facility’.
• Worked with different clinical trials data like Demographic, Adverse Events, Physical Examination and Vital Signs.
• Developed numerous SAS programs to create summaries and listings.
• Generated customized reports using PROC REPORT.
• Created Transport files for the datasets as a part of the FDA submission.
• Creating Analysis datasets using ADAM data standards.

Environment: SAS 9.0, SAS Macro, SAS/ACCESS, SAS/SQL, SAS Enterprise Miner, SAS/ODS, SAS/REPORTWindows, Ms-office, Outlook.

Confidential

SAS Programmer

Responsibilities:

• Assisted statistical, data management and project teams in the production of statistical reports.
• Import datasets from different sources like a spreadsheet of Excel, flat file, Access, and data file with delimiters etc.
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, Formats and Functions. Participated in designing, coding, testing, debugging and documenting SAS Programs.
• Worked with Bio-statistician to analyze the results obtained from various statistical procedures like PROC ANOVA, GLM, UNIVARIATE, MEANS and regression model
• Organize datasets into forms for statistical analysis by merging, combining, splitting, and coding, and performed edit-check for datasets to assure the quality of the datasets.
• Performed data quality checks on very large physician database for large pharmaceutical using SAS.
• Produced Listings, Reports and Summaries of the clinical trial data using various SAS procedures.
• SAS data sets were validated using SAS procedures like Proc Means, Proc Frequency and ProcUnivariate.
• Designed statistical summary tables, graphs and patient data listings using SAS Base and SAS/GRAPH.
• Tabulated the data so as to make easier to analyze and create reports. Extensively used Proc Report, Proc Tabulate.

Environment: SAS 9.0,SAS/BASE,SAS/MACROS,SAS/GRAPH, SAS/REPORT, Windows XP, Ms-Office, Outlook.

Confidential

Clinical SAS Programmer

Responsibilities:

• Worked as a primary SAS programmer to analyze initial data sets and create listings and Tables (TLs) for clinical trials. Modified existing datasets using Set, Merge, Sort andFormat Techniques.
• Created Analysis Datasets, Summary Tables, Listings and Plots according to the specifications of the study for statistical analysis.
• Modified Tables and Datasets in previous studies according to the requirements of the statisticians. Validated Data and performed quality check control of the displays and datasets according to the different QC levels.
• Worked on the summary of clinical data like Demographic, Adverse Events (AE), SeriousAdverse Events (SAE) and Related Adverse Events. Extensively used PROC REPORT to produce reports for the purpose of validation.
• Used statistical procedures like Proc Means, ProcUnivariate and ProcFreqfor analysis.

Environment: SAS/BASE, SAS/SQL, SAS/ODS, SAS/STAT, Windows, MS Excel.

Confidential

SAS programmer

Responsibilities:

• Produced quality customized reports by using PROC REPORT, SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.
• Generated graphs using SAS/GRAPH and SAS Graphics Editor.
• Developed routine SAS macros according to the given specifications.
• Imported/Converted randomization data files from Excel, .CSV data files into SAS data sets for analysis.
• Performed SAS Edit Checks on the raw SAS data sets.
• Designed flowcharts indicating the input data sets and the techniques that would be used (sorting, merging, etc.) to get the desired output.
• Wrote SAS code for data management and reporting, and performed validation, including testing SAS code.
• Wrote statistical sections of Clinical Study Reports and assisted in preparing integrated Clinical/Statistical reports.

Environment: SAS/BASE, SAS/GRAPH, SAS/REPORTS,SAS/STAT, MS-Office and Windows.