SUMMARY:

• Certified SAS Programmer with over 6 years of experience as SAS Programmer Analyst in healthcare and Pharmaceutical industry.
• Proficient in using SAS/BASE, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ MACRO, SAS/ODS, SAS/SQL, SAS/GRAPH.
• Proficient in using Oracle, SQL Server, MS Access, and Excel.
• Experience in using SAS to read, write, IMPORT and EXPORT to another data file formats, including delimited files, Spreadsheet, Microsoft Excel and access tables.
• Experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS tables using LIBNAME and SQL Pass through facility
• Solid knowledge in data management and processing techniques such as merging, appending, concatenating, interleaving of SAS datasets and data validation.
• Good experience in using SAS functions such as Date functions, Character functions and very good knowledge in using formats and informats with data and proc steps.
• Thorough knowledge in SAS programming using SAS Procedures, SAS Functions, SAS Formats, and ODS facility in data scrubbing, manipulation, and preparation to generate summary datasets and reports
• Successfully created new programs using SAS macro variables to improve efficiency and consistency of the reports with MACROS.
• Experience in writing ad-hoc queries to service ad-hoc report requests.
• Skilled in using statistical procedures such as PROC REPORT, PROC TABULATE, PROC CORR, PROC GLM, PROC ANOVA, PROC LOGISTIC, PROC TTEST, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC LIFETEST
• Hands on experience in implementing CDISC standards SDTM
• Good understanding of clinical trial phases, clinical protocols, ICH and GCP guidelines, 21 CFR-PART 11, CDISC and other regulatory submissions.
• Reviewing Clinical Study Protocol, CRF forms, and Data Analysis Plan documents
• Good capability to work either individually with minimal supervision or as a member of a large team and a quick learner with strong analytical, debugging and problem solving skills.
• Excellent report writing, communication, presentation and interpersonal skills.

TECHNICAL SKILLS:

Languages : SAS 9.2, SAS 9.1, SQL

SAS Tools : SAS/BASE, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT, SAS/SHARE.

SAS Procedures : Means, Summary, Freq, Sort, Print, Append, Import, Export, Format Tabulate, Chart, Compare, Content, SQL, Univariate, Transpose

Databases : SQL Server 2000/2005/2008 , MS Access, Oracle 9i/10g, DB2.

Operating Systems : Windows 95/98/XP, 2000, 2003, Vista, Windows 7, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential

Role: SAS programmer

Responsibilities:

• Involved in extracting and analyzing the raw data related to customers using SAS.
• Participated in meetings with managers to develop and document specifications.
• Created SAS data sets by extracting data from Oracle tables using SAS/CONNECT and SAS/ACCESS.
• Manipulated existing Oracle database by accessing the data using SQL pass through facility.
• Worked on pre-existing macros for data validation by checking data distribution and comparison to standard data.
• Worked with complex datasets and generated highly customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT, PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts
• Performed data cleansing by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE in SAS.
• Generated SAS/ MACROS for reusability and to minimize data processing.
• Used PROC SQL for ad-hoc report programming, to perform data manipulation of multiple views in Oracle, creation of the ad hoc reports for marketing research data
• Validated, documented and tested component programs in an efficient manner for inclusion in integrated reports.
• Created reports in the style format RTF, PDF, HTML using ODS statements
• Generated graphs using Proc Gplot and Proc Gchart.
• Used Proc Anova, Proc Means and other statistical procedures in generating real time reports
• Participated in project meetings, presentations and findings

Environment: SAS 9.2/9.3, SAS/MACROS, SAS/SQL, SAS/Graph, SQL, SAS/STAT

Confidential

Role: clinical SAS Programmer

Responsibilities:

• Developed and analyzed programs to create SAS datasets used for Phase II and Phase III studies
• Responsible for generating final study reports, tables, listings and graphs by using PROC TABULATE, PROC SQl, and PROC CHART.
• Worked with data managers to create reports by extensive use of Base SAS, SAS/Macro, SAS/SQL and SAS/Graph.
• Generated detailed reports extensively using PROC REPORT
• Using SAS/STAT to perform analysis of variance for balanced or unbalanced designs, multivariate analysis of variance, and repeated measurements analysis of variance.
• Created survival graphs in EXCEL by transporting SAS data sets into EXCEL spreadsheets.
• Created Kaplan-Meier Survival Curves using PROC LIFETEST and PROC GPLOT in SAS.
• Create electronic data sets SAS transport files for electronic submission.
• Created SDTM Data sets by following CRF, Dataset Specifications and CDISC SDTM Implementation.
• Ensured quality of dataset at the protocol level while working to deliver competitive advantage and cost efficiency to the company as a whole.
• Conducted documenting and reporting computer validation inspections in compliance with 21 Code of Federal Regulations 21CFR and other regulatory compliance.
• Involved in preparing analysis plans, data analysis and statistical report writing presentations to FDA and programming of patient profiles for statistical reports.
• Provided SAS programming and statistical support to Statisticians
• Created SAS Customized Reports using the Data Null technique for FDA evaluations.
• Generated graphs using SAS/GRAPH and the SAS Graphics Editor.
• Developed SAS macros for data cleaning and Reporting and to support routing processing.
• Converted ORACLE data tables into SAS data files using SAS SQL pass through facility

Environment: SAS 9.1/9.2, SAS/ODS, SAS/MACROS, SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/SQL, Oracle 10g, SAS/ACCESS, Windows XP.

Confidential

Role: clinical SAS programmer

Responsibilities:

• Developed SAS programs to create several SAS data sets and create temporary files using NULL option in DATA step statement for reporting.
• Designed statistical summary tables, graphs, and patient data listings using base SAS procedures such as PROC SUMMARY, PROC TABULATE and SAS/GRAPH.
• Involved in creating transport files to move files between different environments
• Used Output Delivery System ODS facility to write custom safety and efficacy reports directing SAS output to RTF and HTML files.
• Extensively used Data Null and SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY and TRANSPOSE for producing ad-hoc and customized reports and external files.
• Created SAS Proc SQL code to transform the original datasets to target datasets for complex requirements using ETL process.
• Developed SAS MACROs to create tables, graphs, and listings for inclusion in study reports.
• Applied concatenating, merging, and appending techniques to SAS datasets.
• Effectively used many SAS functions such as SCAN, SUBSTR, TRIM and applied strategic logic on data using INTCK, INTNX, SUM, SQRT, STD and VAR.
• Extracted data from various database sources like Oracle using Proc SQL passthrough facility and SAS/ACCESS libname statements.
• Used Proc Import for inputting data from Excel sheets.
• Effectively and timely contacted Project Manager of the respective studies about the various Data Issues and resolved the queries through meetings.

Environment: SAS 9.1, SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACROS, SAS/SQL, SAS/ACCESS, SAS/ODS, Oracle 9i, Windows XP

Confidential

Role: Clinical SAS programmer

Responsibilities:

• Worked with different clinical trials data such as Demographics, Adverse Event AE , Serious Adverse Event SAE , Laboratory and Physical Examination.
• Generated Tables, Listings and Graphs using various procedures such as PROC FREQ, PROC REPORT, PROC TABULATE, PROC UNIVARIATE, Data null , and PROC GPLOT
• Performed Data Validation and Data Cleaning on Clinical data using procedures such as PROC FREQ, PROC MEANS, and PROC UNIVARIATE.
• Performed relevant statistical analysis of surveys and economic data captured during Clinical Trials.
• Used SAS Macros extensively in the creation of new programs as well as modification of existing programs to improve ease and consistency of results.
• Wrote SQL queries to check data for different conditions such as duplicate values and missing values.
• Created and implemented statistical analysis plans and specification documents.
• Integrated with Clinical, Regulatory and Data Management colleagues to coordinate collection and reporting of clinical studies.
• Developed permanent SAS formats, templates and libraries.
• Prepared list of efficacy data for statistical analysis.
• Accessed external excel files, stored and retrieved SAS data sets moving data through multi platforms.
• Generated graphs using SAS/GRAPH.

Environment: SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/CONNECT, SAS/GRAPH, SAS/STAT, Oracle 9i, Clinical Trial.

Confidential

Role: SAS Programmer Analyst

Responsibilities:

• Participated in supervision of data entry operations under the guidance of data manager.
• Data manipulation on SAS data sets using techniques such as merging, appending, concatenating and sorting.
• Used procedures proc means, proc univariate, proc freq to identify outliers and used options such as noduprec, nodupkey to delete duplicate records within the datasets.
• Created Transport Export files.
• Developed SAS programs to generate baseline, follow-up, drug safety reports from Oracle data base
• Created Mock Tables mentioned in the Statistical Analysis Plan.
• Generated outputs in different formats such as HTML and PDF and using SAS/ODS.
• Acquired knowledge in Clinical trial terminology, Good understanding of Clinical Trial Phases, clinical protocols/ CRF's/Annotated CRF's, ICH and GCP guidelines, NDA, IND, MedDRA, 21 CFR PART 11.

Environment: SAS 9.1.3 SAS/base, SAS/Macro, SAS/Graph, SAS/Stat, SAS/SQL, SAS/Access , Outlook, MS office tools, Windows.