SUMMARY

• Over 7+ years of experience in Analysis, Design, Development and Validation of Datasets
• Expertise in analyzing and coordinating clinical trial data, generating reports, tables, listings and graphs using SAS in accordance wif teh Statistical Analysis Plan (SAP), Standard Operating Procedures (SOPs) and departmental guidelines
• Strong knowledge involving in all phasesof clinical trials in various therapeuticareas
• Good working knowledge on clinical trial data like Safety and Efficacy
• Executed projects on BASE/SAS, SAS/MACROS, SAS/STAT, and SAS/SQL in Windows and UNIX environment
• Extensive exposure to SAS programming in merging SAS data sets, macro facility, producing reports and SAS formats
• Experienced using industry standards for database design as defined by Clinical Data Interchange Standards Consortium (CDISC).
• Knowledge of industry practices wifCDISC Standards, SDTM, ADaM and TDM (Trail design model) experience.
• Extensive experience in producing External files and customized reports using various SAS procedures like Proc Report, Proc Print, Proc tabulate, Proc Means, Proc Freq, Proc Univariate, Proc SQL, Proc Transpose and Data Null Technique.
• Experience in extracting data and creating SAS datasets from various sources like Oracle database, Access database, Excel and flat files using import techniques.
• Experience in producing RTF, HTML and PDF formatted files using SAS/ODS to produce reports.
• Familiar wif ICH, GCP and 21 CFR part 11 guidelines and Electronic Submission standards.
• Worked on Pooling of safety and efficacy datasets
• Operating System Administration
• Worked on data monitoring committee (DMC) and risk management plan (RMP) submissions
• Excellent communication skills, a very good team player. Ability to work independently under minimum supervision, in a fast paced environment and under deadlines.

TECHNICAL SKILLS

SAS Tools: SAS/BASE, SAS/GRAPH, SAS/MACROS, SAS/SQL, SAS/STAT and SAS/ANALYST and SAS/ETL, SAS 9.1, SAS/ACCESS, SAS/ODS, SAS/GRAPH

Tools: MS OFFICE, ACCESS

Operating Systems: Windows and UNIX

Languages: Core Java, VB, HTML

Database: Oracle 8i, SQL server2000

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

SAS Programmer

Responsibilities:

• Performed Analysis on complex claims wifin teh Processing System.
• UsedSAS/Assist to extract data fromSASFiles and Oracle Data base.
• Developed Stored Processes to distribute reports in a secure manner.
• Created reports in teh style format (RTF, PDF and HTML) usingSAS/ODS.
• TEMPEffectively prepared and published various performance reports and presentations.
• Documented teh Business requirements based on HIPPA compliance rules.
• Worked wif complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT and PROC MEANS for creating a preferred list of customers as per teh given requirements from business analysts.
• Performed Data analysis, mainly using Regression and ANOVA (Proc REG, Proc GLM, and Proc ANOVA).
• Required strong knowledge of ICD - 9, ICD-10 codes.
• Generated SQL reports and Business Objects reports to maximize system capabilities for tracking and reporting information.
• Prepared and monitored progress on system changes requests.
• Created and maintained inventory reports.
• Involved in writing code using BaseSAS&SAS/Macros to clean and validate data from oracle tables.
• Installation/Migration of SAS Software
• Packaging of Virtual apps for SAS Clients.
• Conducted data investigation usingSASEnterprise Guide.
• Coordinating wif SAS Tech supports.
• Involved in Data mining using Enterprise Miner for various health care datasets such as Eligibility, Inpatient, Outpatient, Long Term Care and Pharmacy (Rx).
• Prepared claim status reports for department.
• Worked closely wif Team Members to ensure that problems were resolved timely, and results of analysis was documented and shared wif teh team and departments.
• Reviewed existing literature on Medicare, Medicaid and models dealing wif Medicaid fraud.
• Attended various seminar presentations on Medicaid fraud such as finding duplicate claims, service after death, multiple service providers etc.

Confidential, Columbus, OH

SAS Programmer

Responsibilities:

• Asset Control (AC) is designed to capture daily raw market data for revaluation and risk purposes from a number of proprietary sources like Bloomberg and Reuters. These rates are recalculated to certain derived values as necessary and transmit teh resultant data sets onto receiving systems like Murex, Sophis, and VAST2 etc. AC acts as a repository of historical data, performs exception reporting, and permits validation of teh data at certain points in teh process.
• Imported SAS datasets from SAS Management Console to SAS information Map Studio
• Using information map studio combined relational data table, calculated new data items, and created multiple pre-defined filters
• Build quick reports from web report studio using information maps, create filters, graphs and customize reports
• Using SAS stored process created selection screens, web reports and dash boards
• Experience using query tools for Oracle and MS SQL Server to validate reports and troubleshoot data quality issues.
• Developed new or modified SAS programs to load data from teh source and create study specific datasets, which are used as source datasets for report generating programs.
• Designed and created Information maps and web reports according to teh requirements.
• Scheduled teh work for teh timely reporting and to teh SAS Microsoft add-ons.
• Designing and developing reports for teh Market risk, Asset Management Data and FSA Reporting.
• Involved in creating teh In-Text tables for teh TLF’s (tables, listings, figures).
• Created derived SAS datasets as appropriate.

Confidential, NJ

SAS Programmer/Analyst

Responsibilities:

• Data processing and validations extensively done usingSASdatasets.
• Involved in standardizing reporting procedures for graphical and tabular reports.
• Building permanentSASData sets involving different forms of data.
• Used differentSAStechniques including sub setting, conditions, formatting etc.
• Worked on variousSASprocedures to achieve teh required functionality
• Reports various health care management metrics such as Number of readmissions, Patient category metrics, Patient demographics, Service delivery and drug utilizations etc.
• Research characteristics associated wif member utilization patterns, self-care habits, and health behaviors.
• Used advancedSAStools automate teh reporting systems to generate daily and monthly reports.
• Documented, summarized and recorded data as per standard operating procedures (SOPs) and FDA regulations.
• Majorly worked wif teh data management team and was involved in handling documentation and submission processes
• Define department specific report requirements, profile data and develop data quality definitions.
• Conducted end user training for basic and advanced reporting skills.
• Creation of Universe Objects as per teh Users requirements
• WroteOutput delivery systemSASprocedures to publish reports as HTML pages to teh web.
• Used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT PROC TABULATE, PROC UNIVARIATE and PROC REPORTS.

Confidential, Nashville, TN

Responsibilities:

• Extracting financial data from teh database using SAS/Access, SAS SQL, SAS/Connect, Procedure and create SAS permanent data sets in SAS library.
• Creating SAS Views from tables in Database using SAS/Access, and analyze data.
• Write teh SAS code and run those data sets to produce necessary financial reports by using SAS/STAT Procedures such as PROC Freq, PROC Tabulate, ProcUnivariate, and PROC ANOVA.
• Used of SQL server, SQL access, SQLPLUS, TOAD and PL/SQL to solve complex database problems as well tuning purpose
• Involved in maintaining and tuning existing JCL scripts
• Extensively used procedures like PROC SQL, PROC PRINT, and PROC SORT etc.
• Coded SAS programs wif teh use of Base SAS and SAS/Macros for ad hoc jobs.
• Analyzed teh data using SAS/STAT procedures PROC FREQ, PROC MEANS, PROC SUMMARY
• Used Proc Sort, Set, Update and Merge statements for creating, updating and merging various SAS datasets
• Design of ETL process to meet teh requirement of data demand.
• Developed and maintained teh Crontab Entries for scheduling teh daily, weekly, monthly, quarterly as well as yearly jobs
• Worked wif SQLPLUS, and PL/SQL extensively to solve database problems to make database TEMPeffective and efficient tuning purpose. In PL/SQL Implement of DML, Implicit and Explicit Cursors, function, conditional logic, creating and ODBC connection.
• Scheduled and managed jobs wif AutoSys job management system to ensure job streams flowed smoothly.

Confidentia

Regulatory SAS Programmer

Responsibilities:

• Responsible for providing Clinical SAS programming and analysis support for clinical studies across multiple protocols for teh submissions like NDA and Safety.
• Developed programs for validation of tables and listings for clinical study reports according to CDISC standards.
• Setting up SAS datasets by extracting data from Oracle Clinical using PROC ACCESS, SQL Procedures Pass-through facility and Oracle Libname Engine.
• Created and maintained SAS datasets that are extracted from Oracle databases using SAS DATA STEP and PROC SQL.
• Used Sorting and merging techniques on teh raw data sets for value added data reparation, to get teh required Reports or Analysis data sets.
• Produced Ad-hoc reports as per requests.
• Developed and updated existing MACRO programs.
• Modified SAS Macros related to multiple studies.
• Involved in teh support of Phase II and III clinical trials; Regulatory submissions.
• Worked on teh safety (ISS) and efficacy (ISE) listings for teh various studies, contributed to teh development of standard operating procedures (SOPs).
• Created CRT (Case Report Tabulations) datasets using ODM model of CDISC standards for FDA/Global Submission.
• Used SAS ODS to generate teh reports in RTF and EXCEL formats.
• Worked on multiple protocols and/or drug compounds at a time.
• Conducted analysis on teh raw data to determine teh quality and validity of data.
• Review of specifications, mock-up tables.
• Maintained appropriate study application documentation.
• Used Base SAS & SAS Macros to generate reports of clinical data and assisted in teh validation of clinical data from Clintrial or other electronic sources.
• Performed QC (Quality Check) extensively on tasks performed by other team members and involved in data validation and data cleaning in all phases of Clinical studies.
• Program documentation on all programs, files and variables was performed for accurate historical record and also for future reference.