SUMMARY

• Seven Plusyears of SAS programming experience in Statistical analysis, Validation and Statistical report generation of Healthcare and Clinical trial data.
• Extensive experience in the application of SAS tools such as SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACROS, SAS/ACCESS, SAS/SQL, SAS/ENTERPRISE GUIDE, SAS/ENTERPRISE MINER, and SAS/ODS.
• Extensive experience in creating external files and customized reports using SAS procedures such as Proc Report, Proc Tabulate, Proc Means, Proc Freq, Proc Univariate, Data Null, Proc Summary.
• Experience in validating Tables, listings and CRTs manually and using Proc Compare as well as with departmental standard macros.
• Solid knowledge of CRT dataset creation, CDISC and MedDrafor regulatory submissions.
• Extensive knowledge of both CDISC SDTM and ADAM models.
• Strong understanding ofClinical Trials (Phases I - IV), FDA guidelines, 21 CFR part 11 and GXPs (Good Clinical Practice, Good Laboratory Practice and Good Manufacturing Practice).
• Solid knowledge in clinical trial data like Demographic data, Adverse Events data, Vital Signs data, Laboratory data etc.
• Proficiency in writing maintainable, supportable, and well-documented SAS codes.
• Experienced in Data management, data extraction, manipulation, validation, purification and analyzing large sized data.
• Experience in generating RTF, HTML and PDF formatted files using SAS/ODS.
• Experience in developing SAS Macros, applications for data cleaning and reporting and involved in preparing documentation.
• Worked on statistical parametric analysis methods such as Correlation, Regression, Analysis of variance and general linear models using SAS STAT procedures such as PROC ANOVA, PROC GLM, PROC CORR, PROC REG.
• Maintained and enhanced existing SAS reporting programs for marketing campaigns.
• Experienced working on operating systems like Windows, UNIX, and IBM Mainframes.
• Good understanding of study related Statistical Analysis Plan (SAP) and produced Tables, Listings and Graphs based on the specifications in SAP.
• Experienced in working with different databases such asOracle, SQL Server, DB2, Access and Teradata.
• Good knowledge of Relational DBMS and Multidimensional DBMS
• Enthusiastic, result-oriented, team player as well as able to work well independently with strong communication, analytical, logical and programming skills.

TECHNICAL SKILLS

Statistical Software: BASE/SAS, SAS/STAT, SAS/MACRO, SAS/GRAPH, SAS/ODS, SAS/AF, SAS/ACCESS, SAS/Connect, SAS/Enterprise Guide, SAS/ETL

Programming Languages: SQL, PL/SQL, C, C++, JCL

Databases: Oracle, DB2, MySQL, MS-Access.

Operating Systems: Windows 9x/NT/XP/Vista, UNIX, Shell Scripting, MVS

Internet Technologies: J2EE, JSP, Servlets, HTML/DHTML, XML.

PROFESSIONAL EXPERIENCE

Confidential, San Carlos, CA

SAS Programmer/Analyst

Responsibilities:

• Created CRT(Case Report Tabulations)datasets using CDISC standards for submissions to the FDA.
• Extensively used Dynamic Data Exchange(DDE)for importing data inExcel sheets into SAS.
• Extracted, validated and generated SAS data sets from Oracle; applied‘SQL Pass through Facility’.
• Successfully designed and implemented statistical reporting processes for regular data collection and clinical data analysis.AnalyzedPhaseI, IIandIIIClinical Trials.
• Performed statistical analysis, wrote SAS code forData Managementand reporting, and performed validation, including testing SAS code.
• ProducedTables/Listings forIntegrated Summaries of Efficacy (ISE)andSafety (ISS).
• Communicated withStatisticians and Bio-Statisticiansto discuss about various SAP related issues and made presentations to discuss about various possible changes in it.
• Maintained appropriate study application documentation.
• Used theSAS Macrofacility to produce weekly and monthly reports.
• PerformedData Validation and Data Cleaningon Clinical Trial data.
• Created and maintained SAS Datasets that are extracted from anOracle ClinicalDatabase.
• Created SAS Customized Reports usingData Null technique for FDA regulations.
• Produced accurate, precise tables and listings for Clinical Study Reports by conducting, documenting and reporting computer validation inspections in compliance with21 Code of Federal Regulations (21CFR) Part11,FDAand other regulatory compliance.
• Developed routineSAS macrosto create tables, and listings for inclusion inClinical study reportsandregulatory submissionsand maintained existing ones.
• Performed SAS programming using techniques asSAS Base, SAS Macro, data manipulation techniques, and statistical procedures(e.g.,Proc Means, Proc Freq, Proc Report).
• Extensive interaction with the functional users to understand the requirements on statistical methods and measures.
• Designed flowcharts indicating the input data sets and the techniques that would be used (sorting, merging, etc.) to get the desired output
• Preliminary data validation (clinical data quality checks) is done on the clinical trial data usingSAS/SQL.
• Produceddata listings, summary tables and graphsfor interim and final analyses and publications using different statements/functions/procedure for data manipulation.

Environment: SAS 9.1.3 (Windows NT), SAS/ Base, SAS/Graph, SAS/Stat, SAS/Macros, SAS/ODS, Oracle Clinical.

Confidential, Modesto, CA

SAS Programmer

Responsibilities:

• Gathered business requirements from users and wrote program specifications for coding.
• Extracted data from ORACLE database through SAS/ACCESS for ORACLE and extensively used PROC SQL to manipulate data.
• Used PROC IMPORT to read customer information from CSV, flat, txt and excel files.
• Extensively used the SET, UPDATE and MERGE statements on SAS datasets to read and manipulate customer data on IBM Mainframe Environment.
• Analyzed data using PROC FREQ and PROC MEANS.
• Involved in regression analysis, time series analysis, and trend analysis along with statisticians
• Generated customized reports and graphs using various SAS procedures including PROC REPORT, PROC TABULATE, PROC PRINT, PROC CHART, PROC FORMAT and PROC PLOT, regarding financial transactions, sales details and purchase details for business analysis.
• Studied analytical results and enhanced existing SAS reporting programs for marketing campaigns.
• Tested, debugged and implemented SAS macros in order to analyze customer satisfaction.
• Used ODS features and PROC EXPORT for outputting SAS data into Excel, HTML and PDF formats.

Environment: SAS 9.1.3, SAS/BASE, SAS/ACCESS, SAS/SQL, ORACLE 8i, IBM Mainframe.

Confidential, Atlanta, GA

SAS/BI Analyst

Responsibilities:

• Prepared new Datasets and modified existing datasets using Set, Merge, Sort, Update, Formats and Functions and created Tables and Listings for the same.
• Participated in designing, coding, testing, debugging and documenting SAS Programs
• Written Complex SQL queries to pull data from SQL Server Database
• Statistical analysis included coding the data sets, calculating simple percentage distributions, graphs, comparison of rates by Agency’s t-test and chi-square test, multiple tables and reports developed using SAS/STAT
• Created RTF, PDF, HTML, LISTING using Output Delivery System (ODS)
• Extensively used various SAS Data Step functions, SAS procedures, and SQL to write reports logics for SAS Stored Processes
• SAS Enterprise Guidewas used toconvert existing SAS programs to SAS stored processes using dynamic prompts and produced packaging and streaming outputs as required.
• CreatedStar Schema tables from Relational Schema tablesusing OLAP Cube Studio and createdOLAP Cubesand performed interactive reporting.
• SAS Management console used to create metadata libraries.
• Trainingthe end users how to run these SAS Stored Processes using SAS Add-in for Microsoft Officeand other SAS BI clients fromSAS Information Delivery Portal.
• Converting existingCognos reportsto SAS web reports by creating SAS Information Maps and using those maps for creating SAS web reports usingSAS Web Report Studio.

Environment: SAS/BASE, SAS Macros, SAS/STAT, SAS/ACCESS, SAS Integrated technologies, Futrix, SAS Metadata Server, SAS/GRAPH,ORACLE, JBoss Web Server, Windows Vista (client), SQL Server, MS-VISIO, MS-WORD, MS-Excel, XML, SQL, and Windows bit Enterprise Server.

Confidential

SAS Programmer/ Data Analyst

Responsibilities:

• Utilized SAS procedures and other SAS applications for data updates, data cleansing and reporting
• Identified and correct data step syntax and programming logic errors.
• Gained experience in Import and Export of data across a variety of applications to and from SAS.
• Validated programs and processes to extract data from clinical data management systems, to prepare data listings, summary tables and reports using SAS.
• Became proficient in SAS/BASE, SAS/ODS, SAS/SQL and in producing external files and reports employing various SAS procedures like PROC PRINT, PROC REPORT, PROC SUMMARY.

Environment: SAS V9, SAS/BASE, SAS/SQL, SAS/ODS, Windows 98, Excel/Access 2000.