SUMMARY

• Over 3 years of experience on clinical trial with proficiency in SAS
• Extensive experience in SAS/BASE,SAS/ MACRO, SAS/STAT, SAS/ACCESS, SAS/GRAPH, SAS/SQL, SAS/INSIGHT, SAS/ ANALYST, SAS/ODS, SAS Enterprise Guide, and SAS/GCHART
• Execute analyses specified in the Statistical Analysis Plan (SAP) under the guidance of the project statistician.
• Developing database and support in MS SQL Server environment.
• Writing and tuning SQL queries for maximum performance in a large data volume environment
• Importing various external data files into SAS Dataset / SAS/library by SAS/INFILE, SAS/IMPORT, SAS/SQL, and SAS/ ACCESS
• Importing/exporting data files using SAS/ACCESS SQL Pass - Through Facility, LIBNAME, PROC CDISC, PROC IMPORT/EXPORT, PROC COPY, PROC CPORT, and Data Step programming
• Exporting SAS results to different formats, such as HTML, Excel, and PDF by using SAS/ODS for report and presentation
• Strong ability to work on descriptive statistics, graphics and data frame
• Experience in Creating SAS Datasets, Data manipulation, develops data marts for preparation of reports, tables, listings & graphs.
• Good experience in SAS programming using Base SAS, SAS/Access, SAS/Graph, SAS/Macro, SAS/SQL, SAS/ Stat
• Experienced with working on demographics, adverse events, Meta data, pooled datasets, and messy raw data.
• Developing SAS programs for data cleaning, analysis, and reporting of clinical data, including sophisticated data manipulation and creating customized listings/reports of clinical data.
• Data extraction from Databases and Flat files. Conversion of SAS Datasets to various file types (including Excel, PDF flat files).
• Involved in doing edit checks, validation of Analysis datasets, Tables & Listings.
• Effective team player with strong communication and interpersonal skills as well as self-motivated individual with strong technical and analytical abilities

TECHNICAL SKILLS

SAS Tools: SAS 6/7/8/9/9.1.3, SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH,SAS/SQL, SAS/ACCESS, SAS/CONNECT, SAS/ODS.

SAS Procs: Print, Means, Univariate, Report, Correlation, Regression, mixed,SQL, Tabulate, Freq, Sort, Summary, Format, Import, Export, Append,Transpose, Compare, Plot, Life Test.

Operating Skill: - UNIX, Windows

Software Skills: - SQL, Oracle, Microsoft Office, Minitab

Programming Languages: - Perl, HTML and some C

PROFESSIONAL EXPERIENCE

Confidential, MI

Clinical SAS Programmer

Responsibilities:

• Extracted datasets from database using SAS/ACCESS libname statement and other import methods.
• Verified accuracy and integrity of Clinical data by performing validation checks written in SAS and data cleaning by investigating data related errors and missing values.
• Reviewed clinical study protocols, case report forms and statistical analysis plans for clinical trials.
• Successfully designed and implemented statistical reporting processes for regular data collection and clinical data analysis.
• Analyzed Phase II and III Clinical Trials.
• Developed and maintained programs in SAS using SAS tools for Windows and UNIX in a user support environment.
• Extensively used Base SAS (MEANS, FREQ, TABULATE, REPORT, etc.)andSAS/STAT procedures like PROC ANOVA, PROC REG, PROC CORR, etc., for summarization, cross-tabulations and statistical analysis purposes and SAS/GRAPH procedures like PROC GPLOT and PROC GCHART to generate reports.
• Wrote programs using base SAS and SAS/Macros to extract data from oracle tables.
• Extracted raw data from warehouse and created SAS data sets that are required for the project analysis.
• Involved in creating SAS datasets from flat files and EXCEL data as per requirement.
• Developed Edit check programs to clean invalid data from database.
• Generated tables, listings and graphs including patients demography and characteristics, adverse events, laboratory etc.
• Used ODS in order to generate PDF and RTF files out of tables and listings being created.
• Extensively used different SAS procedures such as Proc Means, Proc Univariate, Proc tabulate, Proc Freq, Proc compare, proc report, proc SQL, proc transpose, proc summary, proc Gplot and Data null step and other statistical procedures.
• Involved in creating transport files for electronic submissions to FDA.
• Collaborated with clinical researchers in the design of clinical trial selection of clinical endpoints, sample size requirements, protocol development, and Research and the Case Report Form design.
• Participated in writing of clinical trial reports and presenting of the trial results.

Environment: SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ODS, MS WINDOWS 2000 and UNIX.

Confidential, Dublin, CA

Clinical SAS Programmer

Responsibilities:

• Extracted clinical trials data from the clinical data warehouse (Oracle), using SAS/ACCESS and created SAS data sets.
• Reviewed company SOP’s, Case Report Forms and SAP of the clinical trials.
• Extensively used SAS procedures like means, frequency and other statistical calculations for Data validation.
• Programming of SAS GUI applications using SAS/AF and SAS/FSP.
• Involved in writing code using SAS/BASE and SAS/MACROS to extract, clean and validate data from oracle tables.
• Involved in development of CRT for Clinical trial analysis and Electronic submissions to FDA in eCTD format.
• Maintained CDISC SDTM and Adam standards Extensive experience with the SAS programming and in data step and with various SAS Procedures in Base SAS and SAS/Stat, including thorough knowledge of SAS Macro Language.
• Performed Data analysis, statistical analysis, generated reports, listings and graphs using SASTools SAS/Base, SAS/Macros and SAS/Graph, SAS/SQL, SAS/Connect, SAS/Access.
• Data extraction from the Clinical databases and created SAS statistical analysis files for regulatory submission to FDA approval.
• Designed and created SAS datasets from various sources like Excel datasheets, flat files and Oracle, creating reports and files from existing SAS datasets.
• Reviewed and created electronic data and Clinical data for FDA and electronic submissions.
• Created survival graphs in Excel by transposing SAS datasets into Excel spreadsheets.
• Implemented data management principles, such as joining data set, indexing, data aggregation, record selection, sub-setting, multiple records per case, creation and modification of views, accessing multiple databases.
• Involved in the process of transferring and converting data from one platform to another for the future use of different phases of clinical trails.
• Created reports using SAS/ODS and extensively used SAS/ARRAYS.
• Developed SAS macros for data cleaning and reporting and to support route processing.
• Performed statistical analysis using various procedures such as Proc Anova, Proc Reg, Proc Univariate, Proc Corr and presented results in histograms and box-plots.
• Assisted system analysts, data analysts, statisticians and medical writers.

Environment: SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ODS, SPSS and MS EXCEL.

Confidential, Hillsborough, NJ

Clinical SAS Programmer

Responsibilities:

• Generated statistical analysis files, summary tables, listings and graphs using SAS/BASE, SAS/MACROS, SAS/GRAPH and SAS/STAT.
• Used SAS/ACCESS to extract data from Oracle and other relational databases for analysis.
• Used Dynamic Data Exchange (DDE) feature of SAS for importing data from SAS, MS Access and Excel.
• Prepared new datasets from raw sets files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, Formats, and Functions.
• Developed and customized reports using PROC REPORT, PROC FREQ and PROC MEANS and DATA NULL .
• Created new datasets from existing data-sets by using concatenation, merging, interleaving and using conditional statements.
• Defining, Manipulation, Controlling and Reporting/Storage (Query Language) of Clinical Data by using PROC SQL.
• Forecasting the data transformation, ARIMA modeling and forecasting, regression analysis with autoregressive errors and regression analysis of panel data.
• Generated routine and ad-hoc reports using PROC PRINT, PROC FREQ and PROC REPORT.
• Generated required Charts, Graphs and reports using Proc REPORT, Proc GPLOT and SAS/Graph for graphical analysis.
• Gathered subset of enterprise data using SAS Scalable Data server for analysis to check the performance of business intelligence and analytic applications.
• Developed and improved the efficiency of programs through the use of SAS macros.
• Moved the datasets and final results between multiple platforms.
• Created an annotated CRF document that maps CRF data sets to SAS data sets.
• Validation done on all the data sets and developed testing scripts and Flag the scripts according to priority using PI manager Tool.
• Used SAS/ODS facility to generate custom reports and thus directing SAS output to RTF, HTML and PDF files.
• Reviewing developed SAS code to eliminate any possible errors and improve functionality.

Environment: SAS/BASE, SAS/BI, SAS/MACROS, SAS Enterprise Miner, Enterprise GuideSAS/ODS, Proc TABULATE, Proc ANOVA.