SUMMARY

• Over 7 years of professional experience of SAS programming in various Pharmaceuticals, Biotech and Healthcare industries.
• Experienced in analyzing clinical trial data and reporting it through SAS.
• Proficient in SAS v9.2/9.1.3, SAS/BASE, SAS/MACROS and SAS/SQL.
• Worked on SAS datasets, Optimization of sas codes using indexing technique to increase the overall performance. Good Experience with SAS procedures such as Proc Gchart, Proc print, Proc format, Proc sql, Proc Stat, etc.
• Responsible for Data extraction from several databases like SQL Server and other external files.
• Good experience in UNIX. Worked with batch files and ran SAS programs using UNIX shell scripts.
• Good experience in Preparing analysis datasets from SDTM datasets and also in analyzing clinical data, creating tables, listing and generating reports.
• Extensive Experience in programming, debugging, analysis and report generation in SAS environment.
• Hands on experience in Phase I to Phase IV Clinical Trials and ICH GCP E9 guide lines.
• Experience in Creation of new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Update, and Conditional statements.
• Experienced in producing RTF, HTML and PDF formatted files using SAS/ODS.
• Good comprehension of FDA (21 CFR part 11) and CDISC guidelines, Good Clinical Practices (GCP), International Conference of Harmonization (ICH) and other regulatory guidelines.
• Excellent Team player with good communication and inter - personal skills.

TECHNICAL SKILLS

• SAS 6.12/7.0/8.0/9.0/9.1/9.2/9.3.
• SAS Tools such as SAS/BASE
• SAS/MACROS
• SAS/ACCESS
• SAS/GRAPH
• SAS/STAT
• SAS/SQL
• SAS/ODS
• JMP
• Windows 95/98/NT2000
• UNIX
• SQL
• PL/SQL
• MATLAB
• Microsoft Office Excel
• Word
• Power Point and Access
• Oracle
• MySQL
• C/C++

PROFESSIONAL EXPERIENCE

Confidential, Groton, CT

SAS Programmer/Analyst

Responsibilities:

• Wrote macros to automate the process like creating CRF datasets and automate documentation of output datasets. Created ISE/ISE reports.
• Developed programs for Listings, Summary tables and Patient profile as per study requirement
• Designed tables, graphs for clinical study reports. Collected requirements from statisticians, prepare requirements document, follow up and develop new macros as per statistician's request.
• Involved in QC the programs.
• Worked with DDE when reading external data files like Excel.
• Investigated and fixed several issues and proactively suggested new output formats to satisfy the statistician's requirements. Developed reports using SAS/ODS and PROC REPORT.
• Used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT AND PROC REPORT. The generated reports are reviewed and sent to the FDA (Food and Drug Administration).
• Extracted data from Oracle views and created reports using Proc Univariate and Proc Regression.
• Peer Review (QC) of SAS Macros coded by other member of the team.
• Developed utility macros for QC of SAS codes. (e.g.: bail out when an assumption is not satisfied in a program or log has critical errors like merge not followed by statement).
• Worked for different studies like Ophthalmology, Daily pain Rating Scale (DPR), Daily Sleep Interference Rating Scale (DSI). Nicotine Use (NU), Short Form 36, Smoking History (SMH).

Environment: SAS/BASE 9.3, SAS/STAT, SAS/ODS, SAS/MACRO, UNIX, MS Excel.

Confidential, Overland Park, Kansas

SAS Programmer/ Analyst

Responsibilities:

• Developed Oracle SQL scripts to extract data from warehouse to facilitate content validation.
• Extensively used Proc Report, Proc Tabulate, Proc Univariate, and Proc Means.
• Involved in documentation of design, Code and Reports for handling over the project.
• Involved in delivering Output using ODS (Output Delivery System) in the form of RTF and HTML files.
• Worked on creating SAS views from tables in oracle database using SAS/Proc SQL
• Used base SAS procedures FREQ, TABULATE, and MEANS to validate current results with expected results.
• Created reports in a form of text as well as Graphical using SAS/Graph, SAS/Reports and Base SAS procedures.
• Using Proc Export export all the datasets into MS Excel.
• Using SAS/Access to communicate with Oracle database and extract data.
• Using SAS macros generating tables and listing using SAS Tables.
• Worked on Web logic server communication with SAS server using SAS/Connect API.
• Worked with validation team to validate the applications compliance with 21 CFR part11 and other FDA mandatory regulations.

Environment: SAS/BASE 9.2, SAS/STAT, SAS/ODS, SAS/GRAPH, SAS/REPORT, MS Excel, HTML, Oracle.

Confidential, Mountain View, CA

SAS Programmer/ Analyst

Responsibilities:

• Involved in extracting clinical data from Oracle, designing the reporting environment for users, configuring the database, web server, front end management tools, creating views for each and every CRF, creating custom views, creating data snapshots, configuring the query tool, maintaining the status flags for data.
• Assisted the team in moving the application to various instances and deploying the application in production.
• Participated in meetings with Biostatics team and documentation team for QC and FDA Guidelines.
• Prepared efficacy data for analysis using SAS, including data Validation.
• Developed new SAS Macros to generate statistical tables and listings.
• Developed summarize clinical trials data using SAS/STAT procedures and data Step programming.
• Transferring data between SAS and Microsoft excel and access with Microsoft Visual Basic Script.
• Excel Macro and VBA programming for data manipulation and presenting Quality Output.
• Extensively used Proc Report, Proc Tabulate, PROC UNIVARIATE, and PROC MEAN.
• Documentation of Design, Code and Reports for handling over the project.
• Involved in Delivering Output using ODS (Output Delivery System) proc Template.
• Created SAS views from tables in oracle database using SAS/Access
• Extensive experience in preparation of data mining, reports, writing scientific research papers, tables, listings and graphs.

Environment: SAS/BASE 9, SAS/BASE 9.1, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/ODS, Oracle.

Confidential, Salt Lake City, UT

SAS Programmer/ Analyst

Responsibilities:

• Extensively used SAS Macros, SAS stat and SAS Graph in reporting clinical trial data.
• Produced reports using PROC MEANS, PROC TRANSPOSE, PROC TEMPLATE and also generated RTF, PDF and HTML reports using ODS.
• Produced reports looking into various treatment methods and their effects.
• Generated statistical tables and listings to summarize clinical trial data using SAS/STAT procedures, SAS Macros, PROC REPORT.
• Responsible for debugging and analysis of SAS protocols and documentations.
• Involved in creating customized reports using DATA NULL for regulatory purposes by FDA.

Environment: SAS 7, SAS 8.2, SAS/MACRO, SAS/GRAPH, SAS/STAT, SAS/ODS, HTML.

Confidential

Programmer/ Analyst

Responsibilities:

• Worked with clinical statisticians and data management systems.
• Developed Full client reports which involved tables and graphs.
• Responsible for creating SAS programs to tabulate data according to different criteria.
• Used Proc means, Proc Annova, Proc Format etc to validate information provided.
• Created reports using ODS statements and Proc template. Used SAS BASE to develop reports.
• Fixed issues and suggested new formats to be used to satisfy the statisticians’ requirements.

Environment: SAS 6.12, SAS 7, SAS/BASE, SAS/STAT, SAS/ODS.