SUMMARY

• 7 years of professional experience of SAS programming in Clinical and Financial Industry for data analysis, coding and implementation.
• Experience in clinical trial process (Phase I - III).
• Expertise in SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/SQL.
• Experience in SAS Enterprise Guide 4.1, SAS Enterprise Miner 4.3.
• Experience in teh BI Suite in SAS including SAS OLAP Cube Studio, SAS Web Report Studio, Information Map Studio.
• Skilled in SAS programming, merging SAS datasets, preparing data, producing and validating reports, SAS formats, and Managing data.
• Expert in using report generating procedures like PROC CONTENTS, PROC PRINT, PROC REPORT, PROC TABULATE, PROC FORMAT, PROC FREQ, PROC UNIVARIATE, PROC SUMMARY, and PROC TRANSPOSE.
• Expert in generating ad hoc reports, tables and graphs for presentations and data modeling using SAS Web Report Studio.
• Experience in using SAS/STAT procedures like PROC ANOVA, PROC GLM, PROC REG, PROC CORR, PROC TTEST, PROC RANK, PROC NPAR1WAY, PROC LIFETEST, PROC PHREG and PROC ANOM.
• Experience in using SAS/STAT for data modeling and predictions.
• Experience in dynamic programming and list processing using SAS/MACRO.
• Excellent programming skills in joining, merging and extracting data from various databases using SQL and PROC SQL.
• Experience in using SAS/GRAPH procedures like PROC GPLOT, PROC GCHART and PROC BOXPLOT.
• Expert in using teh ODS facility to create HTML, RTF, XML and PDF files.
• Experience in Integrated Summaries of Efficacy (ISE) and Safety (ISS) according to Statistical Analysis Plan (SAP) and protocols.
• Strong experience in MS Excel formulas and pivot tables.
• Experience in querying and creating views in MS Acess.
• Strong working knowledge of FDA regulations, ICH Guidelines and GCP requirements.
• Experience in New Drug and Drug release process from IND submission to getting approved from FDA.
• Excellent communication, analysis and people skills.

TECHNICAL SKILLS

• SAS 8/9
• Base SAS
• SAS/MACROS
• SAS/ACCESS
• SAS/GRAPH
• SAS/STAT
• SAS/SQL
• SAS/ODS
• SAS OLAP Cube Studio
• SAS Web Report Studio
• SAS Enterprise Guide
• Information Map Studio
• Print
• Report
• Tabulate
• Format
• Freq
• Univariate
• Means
• Summary
• Transpose
• Anova
• Glm
• Mixed
• Reg
• Corr
• Ttest
• Rank
• Boxplot
• Gplot
• Gchart
• Gmap
• SPSS
• S-plus
• Minitab
• JMP
• Windows 95/98/NT2000
• UNIX
• SQL
• PL/SQL
• MATLAB
• Microsoft Office (Excel
• Word
• Power Point
• Access)
• Oracle
• MySQL

PROFESSIONAL EXPERIENCE

Confidential, MI

SAS Programmer

Responsibilities:

• Created derived datasets using SAS/BASE, SAS/STAT, SAS/GRAPH software
• Reviewed Protocols, Case Report Forms and Statistical Analysis Plans for clinical trials.
• Performed data analysis on teh datasets using PROC UNIVARIATE, PROC MEANS, PROC FREQ, and PROC ANOVA
• Worked with biostatisticians for designing and generating analysis datasets, tables, listings, and graphs (TLG)
• Prepared SDTM Version-3. 1 and AdaM-Version 2.0 data sets as per CDISC standards.
• Gained experience in preparing tabular reports with line sizes, page breaks, Header message, and Bottom message using PROC SORT, PROC PRINT, and PROC REPORT.
• Created ad hoc reports as per statistician requirements.
• Performed sorting and merging of data and generated CRT’s, tables, listings and graphs using SAS/Base, SAS/Stat and SAS/Graph, SAS/SQL.
• Created ad hoc reports and graphs from SAS datasets.
• Generated output in various formatted files such as Excel sheets, RTF, and HTML using SAS/ODS
• Worked with different clinical trials (Phase II and III) data like Demographics, Adverse Event, Laboratory Examination, ECG and Vitals data.
• Involved in preparing study results as well as ISS and ISE for NDA submissions using SAS.
• Performed integration of datasets from different studies for further analysis.
• Provided data in SAS transport files, other appropriate deliverables, and documentation for regulatory submissions by using Proc Copy and PROC CPORT with Xport engine.
• Validated datasets using PROC COMPARE
• Created Macros and developed SAS programs for data cleaning, validation, analysis and report generation using newly created as well as existing macros.
• Used Data Null and SAS procedures such as report, tabulate, freq, means, summary and transpose for producing customized reports using SAS Web Report Studio.

Environment: SAS V9.2, SAS/BASE, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/ACCESS, MS EXCEL, Windows XP, UNIX

Confidential, California

Data Analyst

Responsibilities:

• Used programming tools such as SAS base V9 (Windows and Unix), SAS MACRO, PROC SQL, Microsoft Excel etc.
• Read both worksheets into SAS data sets and compared teh data for any discrepancies. Worked on manipulating data to be used as input to Microsoft Excel.
• Developed, validated and maintained SAS programs for validation, manipulation, analysis and reporting of large volume of data as per teh business requirements.
• Modified data in several ways using various procedures like Proc transpose to obtain teh desired format.
• Created information maps using Information map studio.
• Created stored processes and stored them on BI metadata server.
• Modified existing SAS programs and created new programs using SAS macros to improve ease and speed of modifications as well as consistency of results.
• Experienced in SAS Business Intelligence area and in-depth knowledge of SAS BI including OLAP Cube Studio, Web Report Studio, SAS Add In for MS Office,stored processes.
• Created SAS data sets by extracting data from Oracle tables via an ODBC connection using SQL PASSTHRU facility in SAS/ACCESS (and writing SQL queries).
• Verified and validated data accuracy to improve teh overall accuracy of customer records, product data and other information.
• Worked on resolving production issues, debugging procedures for existing SAS code.
• Generated highly customized reports using PROC FORMAT, PROC REPORT, PROC TABULATE and ODS HTML.

Environment: SAS 9.2, Base SAS, SAS/MACROS, SAS/ETL, SAS/ ACCESS, SAS/SQL, Information Map Studio, Web Report Studio, OLAP Cube Studio, SQL Server, MS Excel, Windows XP, Unix.

Confidential, Durham, NC

SAS Programmer/Data Analyst

Responsibilities:

• Converted data from outside sources into formats used in-house (e.g., ASCII, Oracle or Excel into SAS).
• Wrote teh code / data step for calculation of likelihood functions SAS/Base to be incorporated with different procs such as PROC FREQ, PROC UNIVARIATE, PROC REG.
• Created teh design process of analysis of data variables using different STAT procedures.
• Responsible to investigate data discrepancies and make corrections in teh process of data checking and cleaning.
• Generated different tables, listings and graphs.
• Created SAS views from Oracle database tables using SAS/Access and writing SAS programs using Base SAS and SAS/Macros to create reports.
• Responsible for coding using Base SAS & SAS/Macros to extract, clean and validate data from oracle database.
• Interacted with data management personnel on a regular basis to ensure dat datasets are in usable format and lock teh data sets.

Environment: SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/QC, ANOVA, Oracle, Unix and Windows XP.

Confidential, Baltimore, MD

SAS Programmer Analys

Responsibilities:

• Performed statistical analysis, wrote SAS code for data management and reporting and performed validation, including testing SAS code.
• Prepared clinical data listings and summaries for statistical analysis and analyzed clinical data using SAS system.
• Developed reports using PROC REPORTS, PROC TABULATE and DATA NULL .
• Developed efficient, well documented, readily comprehensible and modifiable SAS code using SAS/BASE and SAS/MACRO facility.
• Used SAS for pre-processing data, SQL queries, data analysis, generating reports, graphs and statistical analyses.
• Accessed various database to gather data, performed a table lookup and translated data values for meaning and readability.
• Downloaded data from Oracle using SQL in to SAS to be analyzed and tan exported to Excel for further analysis.
• Was involved in clinical trials programming of data tables and listings for reporting on safety and efficacy.
• Produced customized reports by using PROC TABULATE, REPORT, SUMMARY and also provided descriptive statistics using PROC Means, Frequency, Univariate.

Environment: SAS V8, SAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/STAT, Oracle 8i, Windows XP

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 V8.2, SAS/BASE, SAS/SQL, SAS/ODS, Windows, Excel/Access 2000.