SUMMARY

• Over 8 years of experience in SAS/BASE, SAS/MACROS, SAS/GRAPH, SAS/STAT, SAS/ETL, SAS/SQL, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/ENTERPRISE GUIDE, SAS BI, SAS/ASSIST in WINDOWS environment.
• Extensive knowledge in all phases of clinical trials (I - IV). Clinical Data Interchange Standards Consortium (CDISC) SDTM mapping of clinical trial data to generate SAS compliant datasets as per CDISC standards.
• Skillful in data extraction and data sorting from various databases like Oracle, DB2 and MS Access.
• Well experienced in analysis of clinical trial data and generating reports, graphs, listings, summaries, tables and standard operating procedures based on company standards in compliance with 21 CFR Part 11, FDA and other GCP Guidelines.
• Conceptual understanding in various business requirements in both clinical and financial. Generating the needs by having firm grip over various statistical procedures like proc SQL, proc report, proc tabulate, proc plot, proc chart, proc format, proc import, proc export, proc print, proc sort, proc compare, proc append, proc connect, etc.
• Quick in generating output in all formats available in output delivering system HTML, PDF, RTF. XML and creating customized reports
• Experienced in exporting and importing huge files from external databases like oracle and also from Excel spreadsheets.
• Generated various graphs using SAS/GRAPH procedures like PROC GPLOT, PROC GCHART and PROC BOXPLOT.
• Hands on experience in New Drug and Drug release process from Investigational New Drug submission to getting approved from FDA.
• Outstanding organizational skills including ability to multi-task, prioritize and manage complex issues.
• Effective team player with excellent analytical, problem solving, communication and interpersonal skills, ability to interact with individuals at all levels. Hard working, ethical and highly result oriented.

TECHNICAL SKILLS

Operating systems: UNIX, WINDOWS XP/2000/98/95.

Web Technologies: HTML, Adobe Dream Weaver.

SAS Tools: SAS/Base, SAS/Stat, SAS/Graph, SAS/SQL, SAS/Access, SAS/ODS, SAS/Report, SAS/JMP, SAS Enterprise Guide.

Database: Oracle Clinical, SQL Server 2000, PL/SQL and MS Access.

MS Office: Word, Excel, PowerPoint, Access and Outlook.

Statistical tools: SAS v 9.x/8.x, SPSS, R/S-Plus, Minitab.

Statistical Procedures: Print, Report, Tabulate, Format, Freq, Univariate, Means, Summary, Transpose, Options, Import, Export, Anova, Boxplot, Gplot, Gchart, Gmap.

PROFESSIONAL EXPERIENCE

Confidential, Henrico, VA

SAS Programmer/analyst-clinical trial

Responsibilities:

• Involved in Phase I through phase IV clinical trials by providing required tables and listings.
• Developed routine SAS Macros to create tables, graphs and listings for inclusion in clinical study reports.
• Worked on time to event data to generate the required results for the comparator drug and the control drug.
• Loading SAS data sets as a table onto DB2 using SQL pass through facility, library reference method or PROC DBLOAD, which is then used for UAT purpose to be tested by Business users.
• Reviewed large macro codes for running the programs.
• Worked on Kaplan-Meier macro to generate the graphs as per the requirements for FDA submission.
• Executed SAS programs in mainframe and developed programs for reporting purposes.
• Validating the data sets and comparing the results to that of source programmers output.

Environment: SAS/Base, SAS/Stat, SAS/Graph, SAS/SQL, SAS/Macros, SAS/Access, MS-Excel.

Confidential, Palo Alto,CA

Clinical SAS Programmer

Responsibilities:

• Involved in entire Software Development Life Cycle of multiple projects related to healthcare.
• Used SAS/ACCESS to extract data from Oracle and other relational databases for analysis. Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Participated in designing, coding, testing, debugging and documenting SAS Programs and Macros. Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, Formats, and Functions.
• Created various enrollment/incentive/Reimbursement payment reports.
• Formatted HTML, RTF and PDF reports, using SAS output delivery system ODS.
• Created SAS reports using the Data Null technique and Proc Report as per CMS regulations and company standards.
• Retrieved data from Oracle, using SQL within SAS to be analyzed and exported to Excel for further analysis.
• Extensive use of libname/SQL Pass through to interact with Oracle database.
• Created various standard macros to reduce code runtime, using control concept to load bulk of data to database.

Environment: SAS/Tools, SAS/Base, SAS/Macro, SAS/Graph, SAS/SQL, SAS/Access SAS/AF, SAS/STAT, SAS/Connect, MS SQL server, MS-Excel, and Windows XP.

Confidential, Frederick, MD

Clinical SAS Programmer

Responsibilities:

• Involved in entire Software Development Life Cycle of multiple projects related to healthcare.
• Responsible for providing Clinical SAS programming and analysis support for clinical studies across multiple protocols for the submissions like CSR and Safety.
• Worked with a team of Bio-statisticians and Data Managers for Generating Safety and Efficacy tables across Phase I, II, and III Clinical Studies in various disciplines including oncology and anti-fungal medications.
• Reviewed protocol, case report form (CRF) and Responsible for Edit checks of clinical trial data to identify illogical data entries.
• Wrote code using SAS/Base and SAS/Macros to extract clean and validate data from flat file, Excel file, Access Database, and Oracle Database.
• Developed reports for Laboratory Tests and Visits as per study requirements.
• Used many Base SAS procedures for analysis, management, presentation and access of the data.
• Produced Reports, Listings, Tabulations and Summaries of the clinical trial data using procedures such as PROC MEANS, PROC SUMMARY, PROC UNIVARIATE, PROC TABULATE.
• Extensively using PROC GPLOT and PROC GCHART for generating graphs and plots.

Environment: SAS/Tools, SAS/Base, SAS/Macro, SAS/Graph, SAS/SQL, SAS/Access SAS/AF, SAS/STAT, SAS/Connect, MS SQL server, MS-Excel, and Windows XP.

Confidential, Wilmington, DE

SAS Analyst

Responsibilities:

• Designed and developed different SAS programs to analyze financial data.
• Worked on various procedures PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE, and PROC REPORT.
• Extensive work on generating reports using PROC REPORT, PROC TABULATE and DATA NULL for analysis.
• Imported huge data from various databases like ORACLEACCESS in to SAS environment by using LIBNAME and SQLPASSTHROUGH.
• Testing on large raw data file using FIRSTOBS and OBS option, use of Datalines to enter data internally.
• Loop iteration in data step using Do-End statement.
• Used SAS extensively for match merge, append data validation, and data correction and cleansing.
• Responsible for maintenance and enhancements in reporting systems using SAS/BASE, SAS/MACRO, SAS/STAT, and SAS/GRAPH.
• Extensive usage of ProcSQL among developing queries of the data based on the firm requirements and generating the reports of the designed queries.
• Submitted reports for different financial services on daily basis.

Environment: SAS 8.2/Base, SAS/Access, SAS/Macro, SAS/SQL, SAS/Graph, SAS/STAT, SAS/Connect, MS SQL Server, MS-Excel, and Windows XP

Confidential, Santa Ana, CA

SAS Programmer/ Data Analyst

Responsibilities:

• Assisted in the installation, implementation and management.
• Acted as training coordinator for the implementation and use of SAS.
• Periodic Conversion of database to SAS data sets.
• Used various statistical procedures for analyzing data and creating summary reports Programming of data listings and data validation was done using SAS.
• Gained a lot of knowledge in SAS procedures and also in building macros.
• Importing and exporting data from various databases to SAS and vice versa.
• 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.
• Tabulated the data to make easier to analyze and create reports. Extensively used Proc Report, Proc Tabulate.
• Used various SAS procedures as PROC SORT, PROC TRANSPOSE, PROC FORMAT, PROC CONTENTS, PROC FREQ, PROC UNIVARIATE, PROC GLM, PROC MEANS, PROC REPORT.
• Created RTF, HTML reports using ODS techniques.

Environment: Base SAS 8.2, SAS, Windows, UNIX, SAS/Access, SQL, SAS/STATS.