SUMMARY:

• 7+ years of experience in SAS programming with strong emphasis on analysis of Financial & Marketing Analysis, Telecommunication, Clinical Trial projects in Pharmaceutical and Healthcare Industry.
• Extensive experience with BASE SAS, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/SQL, SAS/GRAPH, SAS ODS in Windows environments.
• Substantial experience in managing and analyzing large volume Clinical and Healthcare Data.
• Experience with transforming data from formats like excel, CSV, ASCII into SAS datasets.
• Expertise in Data Import/Export via SAS Data Steps, using SAS PROC IMPORT, SAS/ACCESS, SAS/SQL and SAS/ODS.
• Experience in joining, merging and extracting data from various databases using SQL and PROC SQL.
• Expertise in Data Manipulations using SAS data step, such as SAS Formats/Informats, Merge, Procedures like PROC APPEND, PROC DATASETS, PROC SORT, PROC TRANSPOSE.
• Extensive experience in generating Reports employing various SAS data steps and proc Steps such as DATA NULL, PROC REPORT, PROC TRANSPOSE, PROC FORMAT, PROC MEANS, PROC FREQ, PROC TABULATE, etc.
• Worked on writing, editing and debugging code using SAS/BASE and SAS/MACRO.
• Expertise in generating Graphs by employing SAS procedures like PROC GPLOT, PROC GCHART.
• Trained in Good Clinical Practice (GCP), Regulatory Compliance and FDA Guidelines.
• Experience in advanced SAS/STAT procedures including Categorical Data Analysis, Nonparametric Analysis, Survival Analysis, Logistic Regression using PROC FREQ, PROC ANOVA, PROC GLM, PROC MIXED, PROC LIFETEST, PROC PHREG, PROC LOGISTIC and PROC TTEST.
• Extensive experience in developing code for different SAS/STAT procedures such as PROC REG, PROC GLM, PROC FREQ, PROC MEANS and PROC UNIVARIATE.
• Experience in design and building of SAS programs to analyze and generate Files, Tables, Listings, Graphs, Validations, Documentation.
• Familiarity with statistical modeling techniques and data mining for CRM.
• Experience in using SAS Enterprise Miner and SAS Enterprise Guide.
• Proven skills in building Data Mining and Statistical models using SAS, and SAS Enterprise Miner.
• Strong understanding in various statistical concepts such as ANOVA, Pearson chi - square test, T-Test, Correlation, Regression Analysis and Multivariate Analysis.
• Extensively used Enterprise Miner for Data mining, predictive modeling and statistical analysis for marketing campaigns.
• Thorough hands-on experience in using ODS to generate different files including RTF, MS Excels, PDFs and HTMLs.
• Using SAS in a Mainframe environment, developed new reports and modified existing reports in relation to the new system.
• Quality Control, Execution, and Maintenance (Debugging, Enhancements, and Testing) of all delivered Production Code.
• Communicate effectively with management; quality oriented and performance driven nature with strong technical problem solving skills.
• Highly motivated, organized Team player with excellent analytical and communication skills
• Excellent oral and written communication skills and outstanding presentation skills.
• Experienced in Handing large volume of data (approx. 2M) and conducting data analysis to look at trends in business and generate adhoc and Standard reports (in Excel).
• Good understanding of CDISC, SDTM models and exposure in converting legacy data to CDISC, SDTM (Study Data Tabulation Model) Standards.
• Experienced in producing RTF, PDF, HTML formatted files using SAS ODS facility.
• Good understanding of Clinical Trials research methodologies
• Extensive experience in PhaseII and III clinical trials studies in therapeutic area such as Oncology.
• Proficiency in understanding of Study Protocols, SAP (Statistical Analysis Plan), and CRF.
• Using macros to modify and simplify the data.
• Quick learner and excellent team player, consistently meeting deadlines and can work under pressure.
• Highly motivated individual with excellent organizational and interpersonal skills.

TECHNICAL SKILLS:

SAS Tools: SASV8, V9, Base SAS, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/ETS, SAS Enterprise Guide, SAS Enterprise Miner, SAS Model Manager, SAS Management Console, SQL Server Management Studio, SAS Forecast Studio

Databases: Clinic-Trial, SQL server, Argus safety database

Languages: SAS, SAS Enterprise Guide., MATLAB, lab view, solid work

Office Tools: MS-OFFICE, Word, Excel, PowerPoint, and HTML

Core Competencies: Statistical programming, Clinical Trials, Data Analysis, Reports Development

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

SAS Programmer

Responsibilities:

• Worked on conversion of several domains .XPT files into SAS Data Sets, by copying from xpt file library into craw library with memtype =data option.
• Several folders created (Adhoc Analysis Backup Data DDD Doc Format Log Macro Qc TLG Xpt) to store appropriate output for future s.
• Adhoc Reports generated for each of the analysis data set with the required variables and checked for missing value before sending it to the business users, Manager towards database lock.
• Imported and converted PKDATA and PKARDATA .xls files into SAS DATA Sets through SAS Application environment.
• Annotated the CRF (Case Report Form) hard copy as per the requirements identified LABELS, TYPE & FORMAT and mapped them with the variables from the raw data sets.
• Performed the data validation on the raw data sets and cleaned up the data without any missing values or duplicate records for the final data analysis by using PROC SORT, FREQ, SQL, UNIVARIATE, COMPARE and FORMAT.
• Performed edit checks specifications on the raw data sets i.e., DEM, ECG, AELOG, ADPAGG, BLEED, CRIT, CONC, VIT, LABs, VISIT and MEDH to check the chronological order, duplicate records, extreme observations, missing values for date and time and certain deviations. Extracted data from Clinical database using proc SQL and SET statement.
• Derived variables such as SAFEPOP, GRP, ITT, Age, BMI in the master domain DM Data Set, AE DUR in AE Data Set, CO FACTO, CBL, PCBL, etc in LB Data Set, PC TREAL, CONC in PC, D AGE, WT COD, D WT in PH, GEO MEAN in PK (pharmacokinetic & pharmacodynamic phases).
• Generated and reported the listings as per the requirements/template for the AE,DM, DS,EG,IE,LB,MH,PE,SG, by using FORMAT, SQL, REPORT with output file RTF using ODS Method and PROC PRINTTO. Variables from the files as well as the derived ones were mapped with the CRF (case report form) and annotated on both the CRF and the Excel Data Listing document.
• Generated SUMMARY Tables/TABULATE as per the template/requirements with PROC FORMAT, TABULATE, MEAN, FREQ/AGREE, SORT, TRANSPOSE, REPORT, PRINTTO:- n, pctn, Mean, Min, Max, std, and Nmiss; on DM, CM, PK, PKAR, AE, ER, EX final data sets.
• Developed NONMEM datasets POPPK and ER. POPPK data set derived variables in the analysis data are EPID, DOSE N, EVID, ATAFD, ATAPD, and NTAPD. And in ER data set are EPID, PTYPE, and ID. Analyzed the Data and generated the Statistical reports with Graphs for POPPK analysis and ER parameters for the Pharmacologists to analyze the drug performance.
• Generated GPLOT STAT/Graphs on PK, CM AE, EX to analyze the outcome after generating the statistical reports.
• Maintained the detailed QC methods with validation (priority high=independent programming, priority medium=partial programming, priority low=eyeball review with little or minimum programming). With QC log and documentation for the study.

Confidential, New York

SAS Programmer

Responsibilities:

• Go through the BRD (Business requirement Document) to understand the requirements and configure codes to read data from designated Teradata tables.
• Designed, developed, implemented and maintained targeted marketing campaigns and analytic programs. Ensured integrity of campaigns and analysis through rigorous attention to detail and validation of data.
• Extracted and processed large quantities of data from the various data marts using SAS/Access, PROC SQL pass through facility and different data steps respectively used to create SAS datasets.
• Implementing various logics, creating various channel specific reports for auditing and verification purposes using SAS/SQL.
• Worked with 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 the given requirements from business analysts.
• Created Macros and used existing company standard macros and developed SAS Programs for Data Cleaning, Validation, and Analysis and Report generation. Tested and debugged existing macros.
• Development of standard SAS macros to be used throughout out the marketing campaigns.
• Developed adhoc-reports as per business requirements and created various reports like summary reports, tabular reports using PROC REPORT, PROC TABULATE, statements ODS and PROC TEMPLATE to generate output formats in HTML.
• Provided analytic, statistical and technical thought leadership on projects designed for initiatives and programs. Developed and recommended solutions.
• Professional Debugging, Revision and Testing of all deliverables, including Production Code, to abide by QC Checks, Execution standards and Maintenance requirements.
• Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies.

Environment: SAS/Base, SAS/ODS, SAS/Stat, SAS/Access, Enterprise Guide (EG 4.0), UNIX (AIX 5.2), Teradata, Ultra Edit.

Confidential, New Jersey

Responsibilities:

• Import datasets from different sources like a spreadsheet of Excel, flat file, Access, and data file with delimiters etc.
• Organize datasets into forms for statistical analysis by merging, combining, splitting, coding and performed edit-check for datasets to assure the quality of the datasets.
• Created derived datasets and produced reports using SAS/BASE, SAS/MACRO, SAS/STAT and SAS/GRAPH.
• Generate tables, listings and reports according to SAP using PROC FREQ, PROC TABULATE, PROC MEANS, PROC SUMMARY, PROC MIXED, and PROC FORMAT etc.
• Created SAS customized reports using DATA NULL .
• Create chart, graph and plot using PROC GCHART and PROC GPLOT.
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS and Excel.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets and/or ASCII.
• Created complex and reusable Macros and extensively used existing macros.
• Developed SAS programs for data cleaning, validation.
• Generated ad-hoc reports for raw datasets using Print and Report procedures.
• Delivered data dumps for Clinical Data Management before database lock.
• Developed safety listings, tables and plasma concentration graphs for clinical study team and bio-statistical team review.
• Attended project team meetings, worked with Bio-Statisticians, Data Managers, and Clinical Research Managers as appropriate. Reviewed and provided feedback for Data Integrity Plans.
• Conduct statistical analyses such as generate descriptive statistical summary, analysis of variance, categorical analyses, logistic regression, survival analyses etc. using PROC MEANS, PROC SUMMARY, PROC UNIVARIATE, PROC FREQ, PROC ANOVA, PROC GLM, PROC MIXED, PROC LOGISTIC, PROC LIFETEST, AND PROC PHREG.
• Conduct and generate the Regression, Correlation studies and Analysis of Variance using PROC REG, PROC CORR, PROC GLM, and PROC ANOVA.
• Customize SAS outputs to RTF, PDF and HTML formatted files through Output Delivery System (ODS) facility.

Confidential, Atlanta, GA

SAS Programmer/Analyst

Responsibilities:

• Ensure the accuracy of reports using SAS reporting procedures and VBA tools.
• Query databases (ECDW/Teradata and Kronos/Oracle) on on-going and ad-hoc basis.
• Automation of Data Extraction, Transformation and Loading the results to final datasets using Oracle, SAS and SQL.
• Using Toad 11.5 to access Kronos/Oracle DB.
• Have account on dspsas01 on Unix Box, familiar with using UNIX commands and Crontabs.
• Using SAS Base 9.3 and EG 5.1. Query Man 10.13 for SQL Querys.
• Generate Reports, Summary tables, Charts and Graphs for different users using SAS/ASSIST.
• Create input data sets by using SAS Enterprise Guide, SAS/Base and SAS/ACCESS facility for Teradata.
• Use SAS/Base procedures and functions for data cleaning, validation and data quality checks.
• Conduct ad-hoc statistical tests and create reports using SAS/STAT procedures such as Proc Univariate, Proc test and Proc Anova.
• Create reports for business development using SAS reporting procedures such as Proc Report, Proc Tabulate, Proc Summary and Proc SQL.
• Understand and document in house SAS optimization program and generate reports as per schedule.
• Interact with field teams to understand business process and make recommendations on model enhancements.
• Report management on model performance and reporting.

Environment: SAS/Base, SAS/ODS, SAS/Stat, SAS/Access, Enterprise Guide (EG 4.0), UNIX (AIX 5.2), Teradata, Ultra Edit.