Professional Summary

• SAS Programmer with over seven years of SAS programming experience in developing applications for pharmaceutical, financial, healthcare and insurance sectors.
• Experience in Analysis, Design, Development and Validation of applications.
• Extensively involved in Clinical Data Analysis and preparation of SAS Datasets, reports, tables, listings, summaries and graphs according to the Standard Operating Procedures SOPs and department guidelines.
• Strong experience in BASE SAS, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ODS and SAS/SQL.
• Performed Data Validation and Data Cleansing on clinical trial data using different statistical procedures like PROC FREQ, PROC MEANS and PROC UNIVARIATE.
• Generate customized reports using PROC REPORT, PROC TABULATE, PROC SUMMARY, Data NULL and SAS/ODS.
• Extensive experience and proficiency in using SAS/ODS to create output files in a variety of formats including RTF, HTML and PDF.
• Expert in implementing SQL procedures, SAS functions and application for data cleaning, programming, reporting and documentation.
• Experience in using SAS to read, write, import and export to another data file formats including delimited files, spreadsheet, Microsoft excel and access tables.
• Possess strong ability to quickly debug SAS compiling errors, review SAS code and identify areas of concern.
• Successfully increased portability of existing SAS programs by developing stored compiled macros and stored formats.
• Experience in developing SAS Macros from scratch and developed application for data updates, data cleansing and reporting.
• Quick learner and ability to meet deadlines and work under pressure.
• Exceptional problem solving skills for delivering useful and prudent solution.
• Ability to work effectively both as an individual and as part of a team.

Technical Skills

.

PROFESSIONAL EXPERIENCE:

Confidential

SAS Programmer

Responsibilities:

• Worked with Business team to analyze and understand the changes involved for the new business requirements.
• Performed reconciliation of the payment files received from the States, to validate eligible claims payment.
• Developed SAS programs to calculate monthly and quarterly ACA PCP payments made to eligible providers in different health plans.
• Validate the payments received from the State against the payment made by the health plan and generate reports based on the analysis.
• Generate Payment file which include all the valid provider claims that are eligible for receiving the payments.
• Generate Remittance Advice send to providers before making payments using PROC REPORT, DATA NULL and SAS MACROS.
• Developed new or modified SAS programs and used Libname methods to extract data from the Teradata DB and created study specific SAS datasets, which are used as source datasets for report generating programs.
• Extensively used various statistical Procedures like PROC FREQ, PROC MEANS to understand data quality, produce reports and handle the missing values.
• Created SAS Datasets with the usage of SAS MACRO, Macro Variables, CALL SYMPUT.
• Generated customized reports using SAS/MACRO facility, PROC REPORT, PROC TABULATE and PROC SQL.
• Extensively performed Data Cleansing during the ETL's Extraction and Loading Phase by analyzing the raw data and creating complex reusable Macros.

Environment: Base SAS, SAS/ACCESS, SAS/CONNECT, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ODS, SAS Enterprise Guide 5.1

Confidential

Clinical SAS Programmer

Responsibilities:

• Worked as a SAS Programmer with Biostatisticians for Phase I Clinical Trials.
• Converted existing raw data into CDISC standards and reviewed CRFs Case Report Form to ensure the consistency and adequacy with the protocol requirements.
• Data was collected on designing of Phase I clinical trials and was involved in study of Safety, Tolerability and Pharmacokinetics.
• Extracted data from data warehouse and flat files and created SAS datasets.
• Defined variables, merged datasets, created derived datasets prior to BASE SAS programming.
• Extensively used SAS/BASE, SQL queries and Macros.
• Created several reports meeting the requirements of Data Managers and was involved in validating of data and generating tables and reports.
• Developed standard and custom data listing, summary tables and Graphs.
• Validated datasets, data listing, summary tables and Graphs.
• Developed standards and conventions for programming and quality checks.
• Extensively used procedures like SQL, SUMMARY, UNIVARIATE, MEANS, TABULATE, GPLOT, FREQ, COMPARE, REPORT, DATA NULL and other statistical procedures.
• Based on the Clinical Trials Protocol and guidelines, the data is analyzed using SAS Statistical procedures such as Proc means, Proc Univariate, Proc GLM, Proc Reg, Proc test and created output datasets

Environment: SAS/Base, SAS/Macros, SAS/Graphs, SAS/AF, SAS/SCL, Oracle7.3, MS Access2000, Windows NT

Confidential

SAS Programmer

Responsibilities:

• Automated the Monthly, Quarterly and Half yearly Production process using shell scripts and setup cron jobs to schedule them on the UNIX box.
• Analyzed different internal data and supported ad hoc request from business.
• Regularly involved in Data preparation, Data manipulations and formatting to support the statisticians with their models.
• Regularly used SQL Pass thro, libname Statements and PROC SQL to interact with different RDBMS like Oracle, Teradata.
• Created Stored Processes for the business to generate different ad hoc reports based on the parameters passed.
• Have experience creating information maps which would be utilized by web report studio to generate static reports.
• Automated Reports using SAS Add-in for Microsoft Office.
• Designed and developed code with SAS/EG to support ad hoc requests.

Environment: SAS, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/EG

Confidential

Clinical SAS Programmer India

Responsibilities:

• Worked as a primary SAS programmer to analyze initial data sets and create listings and Tables TLs for clinical trials. Modified existing datasets using Set, Merge, Sort and Format Techniques.
• Created Analysis Datasets, Summary Tables, Listings and Plots according to the specifications of the study for statistical analysis.
• Modified Tables and Datasets in previous studies according to the requirements of the statisticians. Validated Data and performed quality check control of the displays and datasets according to the different QC levels.
• Worked on the summary of clinical data like Demographic, Adverse Events AE , Serious Adverse Events SAE and Related Adverse Events. Extensively used PROC REPORT to produce reports for the purpose of validation.
• Used statistical procedures like Proc Means, Proc Univariate and Proc Freq for analysis.

Environment: SAS/BASE, SAS/SQL, SAS/ODS, SAS/STAT, Windows, MS Excel.