PROFESSIONAL SUMMARY

• Around 8+ Years as SAS Programmer with experience in software development, design, analysis, coding, implementation, maintenance and support as a SAS Programmer/Developer/Analyst with profound experience in Healthcare and Financial Industry.
• Experienced in various phases of SDLC from planning, requirement analysis, designing, development, testing, implementation and support of projects in production environment.
• Experience in Base SAS,SAS/STAT, SAS/MACRO,SAS/GRAPH,SAS/SQL, SAS/ODS and SAS/ACCESS on Windows and Unixplaforms and competence in carrying out statistical analysis of large scale data.
• Experience in design and development of ETL processes for Data Integration studio(DI) projects to perfrom data loads.
• Experise in using various statistical procedures in SAS such as like PROC SQL,PROC SORT, PROC FREQ, PROC PRINT, PROC MEANS,PROC IMPORT/EXPORT, PROC TRANSPOSE,PROC UNIVARIATE, PROC CORR,PROC REG, PROC GLM, and PROC ANOVA.
• Strong Knowledge in Clinical Trials and Reporting tools and have created statistical reports for FDA/NDA submission.
• Experience in creating teh SAS datasets by merging,concatenating,interleaving and validating datasets and TLG’s based on company requirement and resources.
• Extensive experience in generating reports and creating summaries accordinf to teh specifications of Statistical Analysis plan(SAP) and Standard Operating Procedures(SOP).
• Expertise in generating reports in PDF,RTF and HTMS foramtsusindOutput Delivery System(ODS).
• Experience working on different appications using Oracle, MS SQL Server, Teradata, IBM DB2,MS Access,MS Excel .
• Excellent interpersonal,organizational and oral/written communication skills contributing to project success in multi - tasking, fast paced environment.
• Experience in working with customers to determine their needs,gather,analyze and document requirments, communicate with customers throughout teh development cycle,manage customer expectations,resolve issues and provide project status.

TECHNICAL SKILLS:

SAS Tools: SASV9.1.3, SAS 9.2, SAS 9.3Base SAS, SAS/SQL, SAS/MACROS, SAS DM, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/ACCESS, SAS/CONNECT

Reporting Tools: Base SAS versions 9.3/9.2/9/8/6, SAS Enterprise, SAS Graph, AXUM, MS-EXCEL, SAS BI Platform, MS-Visio, MS-PowerPoint.

Databases: Oracle, Microsoft SQL Server, MS-ACCESS,DB2

Languages: SAS, SQL, Basic, HTML

Batch Server: Unix, Putty, SSH, SAS scripting

Platforms: Windows 95/98/XP/Vista/Win 7, Unix, Mainframe.

PROFESSIONAL EXPERIENCE

Confidential, Bethesda, Maryland

SAS Programmer/Analyst

Responsibilities:

• Assessed and identified mitigation for risks, including those related to high level design, integration, and data quality.
• Worked with clinical research staff and study group to provide SAS programming support for Clinical Trial projects.
• Used DATA step to derive analysis dataset from raw dataset using define feature in SAP and Clinical Report Forms (CRF’s).
• Experienced in extracting teh data from Oracle, SQL Server databases, efficiently using SAS/Access.
• Designed comprehensive design specifications to facilitate creation of ETL programs.
• Created SAS transport files and converted teh Transport files into SAS Data Sets.
• Worked on Data Archival and Data Migration from Mainframes to Windows and UNIX and Converted teh SAS program compatible for UNIX and Windows.
• Used various procedures like PROC FREQ, PROC MEANS, PROC TABULATE, PROC SUMMARY and PROC REPORT to generate various data tables, patient data listings and reports according to Statistical Analysis Plan (SAP).
• Contributed to Integrated Summary of Safety (ISS) analysis.
• Created tables, graphs and listings (TGL’s) for inclusion in clinical study reports and regulatory submissions and also maintained existing ones by using SAS MACROS.
• Wrote Customized Safety and Efficacy Reports directing SAS output to PDF,RTF and HTML files using ODS facility.
• Production Jobs monitoring and handling teh job failures to keep all teh reporting processes up and running.

Environment: SAS/Enterprise Guide, SAS/Base 9.3/9.4, SAS Macros, SAS/SQL, SAS/ETL, SAS/Graph, SAS/ODS, SAS/Stat, MS Access, Windows, Oracle 11g,MS Office, Unix.

Confidential, Princeton, NJ

ClincialSAS Programmer

Responsibilities:

• Involved with analysts and users on requirement gathering.
• Verified accuracy and integrity of Clinical data by performing validation checks written in SAS and data cleaning by investing data related errors and missing values.
• Reviewed clinical study protocols, case report forms and statistical analysis plans for clinical trials.
• Worked with variousSAS/STAT, SAS/MACRO, SAS/GRAPH, SAS/SQL, SAS/ODS and SAS/ACCESS to develop required solutions.
• Successfully designed and implemented statistical reporting processes for regular data collection and clinical data analysis.
• Extensively used BaseSAS (MEANS, FREQ, REPORT) for summarization, cross-tabulations and statistical analysis purposes and SAS/GRAPH procedures like PROC GPLOT and PROC GCHART to generate reports.
• Extensively used different SASprocedures such as PROC MEANS, PROC SORT, PROC FREQ, PROC COMPARE, PROC REPORT, PROC SQL, PROC GPLOT and Data NULL step and other statistical procedures.
• Wrote programs using base SAS and SAS/Macros to extract data from oracle tables.
• Knowledge of CTMS, drug discovery and development, bioinformatics, ICH-GCP, drug protocol development, clinical trials, CDISC, SDTM, ADaM, clinical data management, CRF Design, EDC and Pharmacovigilance.
• Generated tables, listings and graphs including patients demography and characteristics, adverse events, laboratory etc.
• Collaborated with clinical researchers in teh design of clinical trial selection of clinical endpoints, sample size requirements, protocol development, and Research and teh Case Report Form design.
• Participated in writing of clinical trial reports and presenting of teh trial results.

Environment:SAS/Enterprise Guide, SAS/Base 9.3/9.4, SAS/Macros, SAS/SQL, SAS/ETL, SAS/Graph, SAS/ODS, SAS/Stat, MS Access, Windows, SQL Server, MS office, Unix and Teradata.

Confidential, Raleigh, NC

SAS Programmer/Analyst

Responsibilities:

• Responsible for Business analysis and requirements gathering of SAS reporting new and existing codes.
• Gathering requirements and documentation for unit test case development and defining and documenting teh integration testing of new applications.
• Maintained performance reports, creation of reports for online and batch application of various servers and involved in preparing executive Dashboards for senior level management.
• Used SAS, SAS/Macros, Procedures like SQL, Freq, Summary, Means, Transpose, Arrays, Tabulate and Sort to extract data, Prepare integrated data base and its analysis.
• Construct campaigns using a combination of Unica campaign, SQL based on inputs from teh campaign owners
• Extracted data sets from server using Proc Import and created datasets in SAS libraries, Coding SAS Programs with teh use of SAS/Base and SAS/Macros for ad hoc jobs.
• Developed programs to created daily HTML reports using ODS and CSV reports using Proc Export.
• Worked with SQL, Macro and DI Studio ETL processes, extracted transformed and loaded data, mapped, scheduled and submitted job to Unix and Oracle environment.
• Created views on Oracle tables and indexes on SAS datasets to enhance teh speed and performance of teh SAS programs.
• Created shell scripts which would take arguments from teh command line and create subdirectories to store teh listing files, output files and graph files.
• Developed web-based reports, scorecards, and dashboards using SAS Information Delivery Portal, Web Report Studio, BI Dashboard, Stored Processes, and SAS Server pages.
• Create OLAP cubes using SAS OLAP tools for teh creation of dashboards and drill-through web based reporting.
• Developed methods to streamline analysis and present business critical information through a combination of SAS BI dashboards and web-based reporting.
• Assist with teh creation, support and scheduling of SAS programs within teh reporting infrastructure.

Environment:SAS 9.1.3, SAS/BI, SAS/DI Studio, Olap cube, Information Map Studio, SAS/Base SAS/Macros, SAS/Access, SAS/Connect, SAS/SQL, SAS/Enterprise Guide, Oracle, DB2, Windows and Linux, Unix-AIX 6.1

Confidential, MN

Clinical SAS Programmer

Responsibilities:

• Worked in Phases of clinical trials for heart diseases and diabetes.
• Designed and implemented statistical reporting processes for clinical data analysis.
• Extensively used SAS/Macro facility to provide reusable programs dat can be conveniently used time to time and created tables, listing and graphical reports.
• Generated output files in text format, HTML & PDF format using SAS ODS.
• Used SAS/ACCESS to extract data from Oracle and other relational databases for analysis.
• Developed reports using PROC REPORT, PROC TABULATE and DATA NULL .
• Designed flow charts indicating teh input datasets and teh techniques dat would be used (sort, merge, append) to get teh desired output.
• Data Analysis and graphical presentation for various summary reports using Base SAS and SAS/Graph facility.
• Developed SAS programs for listing of tables for data review and presentation including adhoc reports, CRTs as per CDISC, patients listing mapping of safety database and safety tables.
• Created CRT (Case Report Tabulations) datasets using CDISC standards for submissions to teh FDA.
• Performed data validation on teh data sets and deleted repeated values using conditional data steps such as @@, if-tan statements.
• Good working noledge of Clinical Trials data like Demographic data, Discrepancy data, Adverse Events (AE), Serious Adverse Events (SAE), Laboratory data (Lab data), Physical and Vital Signs and Audit trials.
• Established and maintained a sound working relationship and TEMPeffective communication within (worked with) Bio-Statistics and Statistical Reporting and Clinical Research and Database personnel.

Environment: Windows, SAS 9.1, SAS/BASE, SAS/STAT, SAS/MACROS.

Confidential

Clinical SAS Programming Consultant

Responsibilities

• Used SAS Base procedures like PROC FREQ and PROC UNIVARIATE to generate Safety tables (Adverse Events, Demographic listing) and quality tables for clinical study reports and regulatory submissions.
• Developed SAS macros for data cleaning and Reporting.
• Generated statistical analysis files, tables, listings, and graphs for clinical trial studies
• Involved in delivering output using SAS/ODS.
• Extracted data from databases and also flat files.
• Created html and PDF output files by using SAS ODS AND PROC REPORT, PROC TABULATE, DATA NULL AND PROC SQL to customize teh reports
• Enhanced reports through teh use of labels, SAS formats, user-defined formats, titles, footnotes and SAS system reporting options.
• Integrate Data from wide range of sources including in-house clinical data management systems, labs and contract research organizations and perform data cleaning with data steps using DLM, DSM, TRUNCOVER, MISSOVER etc.

Environment: SAS/ODS, SAS/SQL, SAS/REPORT, SAS/GRAPH, SAS/BASE, SAS/MACRO, MS EXCEL, MS ACCESS.