SUMMARY

• Experienced with SAS programming in pharmaceutical research projects for 5+ years. Good analytical and problem solving skills combined with ability to work independently and collaboratively in a team.
• Experience in Data analysis and Reporting in health care, finance and marketing sectors. SAS experience includes detailed knowledge ofstatistical analysis of financial, marketing and health care data and in the production of reports, tables, graphs and listing.
• Knowledge of clinical trial phase I - IV and clinical drug development process including good understanding of CDISC, SDTM, ADAM and exposure in converting legacy data to CDISC, SDTM Standards and FDA guidance.
• Prepared Statistical Analysis Plans, Table Shells and provided innovative solutions of problems.
• Experienced in statistics modeling and analysis using various SAS procedures, like FREQ, UNIVARIATE, ANOVA, GLM etc.
• Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors.
• Experience in working with SASENTERPRISE GUIDE SOFTWAREfor reporting and analytical tasks
• Performed data extraction, analysis and published results usingSAS ENTERPRISE GUIDE
• Extensive experienced in coding to create tables, listing, graphs using SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/GRAPHS, SAS/ODS, SAS/STAT and optimizing programs by using advanced SAS Programming techniques for development.
• Experience using SAS GRID Manager within the SAS Management Console and also Experienced in SAS Grid Manager Client Utility and grid syntax
• Experienced in statistical analysis using regression, ANOVA, logistic regression, generalized linear models, survival analysis, clinical trials, univariate and multivariate analysis and designing surveys.
• Expertise in Data Manipulations using SAS data steps, such as SAS Formats/Informants, Merge, and Procedure like PROC APPEND, PROC DATASETS, PROC SORT, PROC TRANSPOSE etc.
• Experienced in producing detail and summary reports using PRINT, REPORT, TABULATE, SQL, MEANS and SUMMARY procedures.
• Experienced in generating reports using PROC EXPORT AND DATA NULL, PUT STATEMENTS and SAS ODS to create HTML, RTF and PDF output files in the process of producing reports.
• Worked on different therapeutic areas such as Diabetes, Neurology, Cardiovascular, Respiratory and Ophthalmology etc.
• Good comprehension of FDA (21 CFR part 11) and CDISC guidelines, Good Clinical Practice (GCP), International Conference of Harmonization (ICH) and other regulatory guidelines.
• Utilized MEDDRA and WHO-DRUG dictionaries in creating summary tables for adverse events and concomitant medications respectively.
• ASTER Technologiesportfolio of electrical Testability Analysis, Board Viewing and Quality Management products have been developed over many years by working closely with our customers in fully understanding their problems and providing innovative solutions, toimprove product yield from design through to production.
• Prepared ISS (Integrated summary of safety) and ISE (Integrated summary of efficacy) results with tables, patient data listings, graphs/box plots and reports of clinical trials.
• Strong understanding of Dimensional Modeling, OLAP, Star, Snow flake Schema, Fact and Dimensional tables and DW concepts along with Oracle Data warehouse Configuration, Admin Console, Materialized views, Indexes.
• Attended project team meetings, worked with Bio-Statisticians, Data Managers, and Clinical Research Managers as appropriate. Reviewed and provided feedback for Data Integrity Plans.
• Excellent interpersonal and management skills to direct, conduct motivate and evaluate teams.

TECHNICAL SKILLS

Operating Systems: UNIX, Mainframe, MS Windows XP/Vista, MS 2003 server

Language: SAS 9.1.3, SAS 9.2, SQL.

SAS Tools: SAS/Base, SAS/Macro, SAS/Stat, SAS/Connect, SAS/ODS, SAS/ACCESS, SAS/ETLSAS /Graph, SAS/OLAP Server, SAS BI platform, SAS EG, SAS EBI, SAS add-in MOSAS WRS

Business Intelligence: SAS Management Console, SAS Enterprise Guide, SAS Data Integration Studio, SAS Information Map Studio, SAS Web Report Studio

Database: MS-Access, Oracle, Metadata, SQL server, DB2

Other Technologies: Visio, Microsoft Office (Word, Excel, PowerPoint, Outlook)

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

Responsibilities:

• Involved in Analysis & Marketing Team to make business decisions
• Interacting extensively with end users on requirement gathering, analysis and documentation
• Involved with key departments to analyze areas and discuss the primary model requirements for the project
• Documented methodology, data reports and model results and communicated with the Project Team / Manager to share the knowledge
• Analyzed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model
• Involved in credit risk assessment model to calculate risk factor for individual clients based on hierarchy
• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time
• Imported Data from relational database into SAS files per detailed specifications
• Imported data using LIBNAME and PROC SQL Pass -Thru facility to reduce processing time
• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA
• Extensively performed Data Cleansing during the ETL’s Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros
• Carried out data extraction and data manipulation using PROC SQL, PROC SORT, PROC REPORT to create preferred customer list as per business requirements
• Extensively used SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY, TRANSPOSE and Data Null for producing ad-hoc and customized reports and external files
• Wrote SAS programs in UNIX platform. Developed UNIX shells/scripts to support and maintain the implementation. Multiple project automated build and release process.
• Responsible for generating Financial Business Reports using SAS Business Intelligence tools (SAS/BI) and also developed ad-hoc reports using SAS Enterprise Guide
• Developed Income statements & Balance sheets in MS Excel
• Extensively used SAS ODS facility to create customized reports in HTMLPDF,RTF
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS Integration Studio, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access
• Created complex web reports from SAS data and information maps usingSAS WEB REPORT STUDIO.
• Extensively worked on Extracting, transforming and loading data into data warehouse usingSAS DI Studiofor further analysis and reporting
• Created web based interactive analytical and reporting systems. Generated daily and weekly reports using PROC REPORT, SQL, and Data Step interfaced with HTML, DDE, ODS, Word, Excel, and ExcelXP Tagsets.
• Advanced analytical experience includes using Base Procedures, Table lookup with Index Processing and hash objects used to validate data. Data Step and SQL Pass-thru to Oracle, DB2, Teradata, Netezza, SQL Server, and PC files. SCL, CRM, Data Validation, ETL and Data Cleansing processing to extract internal and external data. Use of Formats and Informats including dynamic generation from existing data, FTP, UNIX scripting, and automating processes, Web development with SAS and custom programing generating HTML.
• Execute and manage transformation processes and tools.Create domainXMLschemafor use of integration, services and messaging.Execute tasks on XMLregistry, XSLT/XQuery and transformation capabilities.Validatemapping definitions, schemas and transformations.Coordinate withdata modelingand architecture resources.Create data mapping from multiple data sources to a single domainmodel.Analyze and evaluate constraints in mapping data, XML, and object models.
• Proficient with design tools for XML-based vocabulary technologies.
• Performed competitor and customer analysis, risk and pricing analysis and forecasted results for credit card holders on demographical basis
• Created reports in the style format (RTF, PDF and HTML) using ODS statements and PROC TEMPLATE
• Written validation packages using PL/SQL package. Used PL/SQL to validate data and to populate billing tables
• Performed Consumer profiling, Sales forecasting and testing of financial and business models
• Designed and Created Database objects and Written PL/SQL PROGRAMMING for data extraction and transformation.
• Effectively prepared and published various performance reports and presentations

Environment: SAS V8.2, SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ACCESS, ORACLE, DB2, SQL, WIN NT

Confidential, Rockville, MD

SAS Programmer

Responsibilities:

• As a SAS Programmer Receives the Report Design Specification (RDS) from the Primary Contact, Distribute the Task to the Team members.
• Extracting the data from Database using SAS/ACCESS, SAS/SQL Procedures and create the Data Set.
• Involved in SAS programming with clinical research data for Phase II - IIIClinical Trials for Immunology.
• Created Derived Data Sets from the Raw Data according to the specifications given by Statisticians.
• Involved in writing the code using Base SAS and SAS/MACROS to Extract, Clean and Validate data from Oracle and MS Excel tables by using Proc Sort, Proc Freq, Proc Means, Proc Print, Data Null .
• Retrieve the data from Oracle and MS Excel received from CRA and converted to SAS Data sets for analysis using SAS/STAT Procedures such as Proc Means, Proc Freq, Proc Tabulate, Proc Test, Proc Univariate etc.
• Creating Reports using the analysis output and Export them to the Web to enable the users to have access through Internet using SAS/ODS.
• Used MS SQL Server to excess data from database in Excel format and from that created table for analysis.
• Generate Charts and Plots based on the Requirements using SAS/GRAPH Procedures such as Proc Gchart, Proc GPlot, and Proc Box Plot.
• Generate Reports and Adhoc Reports based on the requirements using Proc Sort, Proc Tabulate, Proc Report, and Proc Print.
• Worked on CDISC standard for SDTM datasets for AE and Demographic datasets.
• Using Annotate facility generate a special data set of graphics commands from which we produce the graphics output.
• By using the Proc Greplay Procedure display and manages graphics output is stored in SAS catalogs. Two or more Plots and Graphics output showed in a single Template.
• Extensively used Procedures like Proc Sort, Proc Print, Proc Report, Proc Tabulate, ProcMeans, etc. and extensively used SET and MERGE statements.
• Involved in Preparation of Documentation.
• Converted SAS datasets into TRANSPORT format using SAS XPORT ENGINE.
• To identify illogical data entries from clinical trial data, reviewed study protocol, Case Report Form (CRF) and performed Validation of data.
• Used different Data Manipulation procedure to convert datasets into the SAS Datasets as per requirements.
• Checked and verified CTD’s (Common Technical Document) in compliance with regulatory FDA requirements.
• Used PROC SQL to find the queries from the datasets for data cleaning.
• Generated Efficacy dataset tables and also Safety tables for Adverse Events, Patient Profile, Demographic Listing and Vital Signs.
• Receive the code from Team members, Integrated it, testing the whole program and generated the Reports, Plots and Charts by Requirements.
• Involved in preparing the tables, listings and graphs for Integrated Summaries of Efficacy (ISE) and Integrated Summaries of Safety (ISS).

Environment: SAS/BASE, SAS/MACRO, SAS/ODS, SAS/STAT, SAS/GRAPH, SAS/SQL, MS SQL Server 2005, Windows XP

Confidential, Cambridge, MA

SAS Programmer

Responsibilities:

• Worked on Phases I and II Clinical Trials for Oncology and analyzed Phase I and II Clinical Trials.
• Produced listings, reports, tabulations and summaries of clinical trial data using procedures such as Freq, Means, Univariate, Summary, Tabulate, Report, and Transpose for statistical analysis by other Bio-statisticians.
• Provided input to planning documents such as Validation, Study Protocol and Statistical Analysis Plans.
• Extraction of data from Oracle, DB2, Access and Excel for further analysis using Proc SQL Pass through Facility and DDE.
• Creating & adding users and user groups and assigning ACLs.
• Applying HotFixes/patches, new licenses to Grid environment, licensing upgrade and migration
• Formatted HTML, RTF and PDF reports using SAS/ODS.
• Conducted, documented and reported data validation inspection in compliance with FDA Regulations (21 CFR Part 11) and other regulatory compliance.
• For data analysis and query used Business Objects Tool and once query the data than for that dataset created table for further analysis.
• Participated in designing, coding, testing, debugging and documenting SAS programs and Macros.
• Experienced using SAS/ETL tool to extract, clean, transform, load and manage data in a Windows environment.
• Developed SAS programs using Base SAS for tabulation counts, correlations and checks for dispersion for normality using PROC Means, Proc Tabulate and Proc Univariate.
• Familiar with Proc Lifetest to create Kaplan-Meier Survival Estimates Plot.
• Applied generally accepted programming standards and techniques to assure efficient program logic and Data Manipulation.
• Used Proc Migrate to migrate data sets from SAS 8.1 to SAS 9.1 in a Windows environment.
• Worked on SAS/GRAPH to present results in BAR Chart, PIE Chart and SCATTER Plot.
• Created SAS views from an Oracle database upon statisticians’ requests.
• Worked with team members for SAS data migration and also helped them to validate the data sets after migration with the help of Migrate Validation Tools.
• Created SAS Reports using the Data Null technique and Proc Report for NDA submission as per FDA regulations and company standards.
• Involved in preparing study results as well as ISS and ISE for NDA submissions using SAS.
• ASTER Technologiesportfolio of electrical Testability Analysis, Board Viewing and Quality Management products have been developed over many years by working closely with our customers in fully understanding their problems and providing innovative solutions, toimprove product yield from design through to production.

Environment: BASE SAS V8, SAS/ACCESS, SAS/CONNECT, SAS/GRAPH, SAS/STAT, Excel, Access, Oracle 8, Window NT / 2000, Business Objects Tool, UNIX

Confidential

Junior SAS Programmer

Responsibilities:

• Used various procedures like SORT, SQL, MEANS, TRANSPOSE and CONTENTS to generate various data tables, patient data listings and reports according to Statistical analysis plan.
• Created SAS datasets from various sources like Excel datasheets, flat files
• Integrated safety analyses, efficacy analyses and health authority by using DATA STEPS and PROC STEPS.
• Analyzed data, manipulated multiple datasets, aggregating data and merging datasets for analysis using DATA STEP.
• Assist in the design process and selection of methodologies and interpretation of results from standard statistical analysis.
• Define and maintain standard merges between different views of clinical data and creation of enhanced SAS datasets.
• Generated tables, listings and graphs, including Patient Demography and Characteristics, Adverse Events, Laboratory, Vitals etc.

Environment: SAS/BASE, SAS/STAT, SAS/GRAPH, SQL, SAS/MACROS