Resume Details:           Click here for the printer friendly format   Information about the candidate   Click here to request candidate information Resume ID #:  423 Position desired:  Contract Travel:  Limited Relocate:  Yes Current location:  Blue Bell, PA 19422 SAS Product Experience Base SAS® SAS® Data Quality - Cleanse software SAS / ACCESS® software SAS / ASSIST® software SAS / CONNECT® software SAS / GRAPH® software SAS / STAT® software Industry Experience Financial Services for 2 year(s) Pharmaceutical and Biotechnology for 4 year(s) SAS functional experience Implementation Consulting End-user Training SAS technical experience Develop and modify SAS programs SQL programming skills Technical production support SAS software experience:  Software : SAS/BASE,SAS/STAT,SAS/GRAPH,SAS/ACCESS,SAS/CONNECT,SAS/ASSIST, MS Access 2000,Excel,MS-SQL, PGP, Forte,Power Point,MathCAD,Lotus, PhotoShop, Illustrator, Visual Basic, IPRO,Doculex. PROC(SAS) : PROC PRINT,PROC IMPORT,PORC CONTENTS,PROC SORT,PROC FORMAT, PROC MEANS,PORC FREQ,PROC TABULATE,PROC REPORT,PROC TRANSPOSE, PROC UNIVARIATE,PROC CORR,PROC REG,PROC ANOVA,PROC GLM,PROC EXPORT, PROC APPEND, PROC CHART, PROC CONTENTS, PROC CORR, PROC DATASETS, PROC FACTOR, PROC FORMAT, PROC LOGISTIC, PROC NPARWAY, PROC RANK, PROC PLOT, PROC RSQUARE, PROC STEPWISE, PROC SUMMARY, PROC TTEST. Non-SAS general professional experience:  Work History Wyeth Pharmaceuticals       7/2005 to 6/2007 Clinical SAS Programmer 07/05–06/07 Status: Contract * Writing SAS programs for analysis in UNIX and PC environment. * Validation and review of other Programs. * Delivering safety and Efficacy tables, listings, graphs, derived datasets in a timely manner for Clinical Trials. * Transforming Data and Creating Analysis Data sets. * Creating Modular code with Macros, writing Macros with conditional logic, writing Data- Driven Programs with CALL SYMPUT. * Testing Categorical Data with PROC FREQ, Producing Statistics with PROC MEANS. * Writing edit checks from the Data Cleaning Plan (DCP) specifications. Checking values of Numeric Variables, Checking for Missing Values, Looking for "n" Observations per subject, verifying double entry and Using SQL for Data Cleaning. * Extracting Data from Oracle database using SAS/ACCESS, E-review, PROC SQL. * Writing Delimited and HTML files using ODS. * Using PROC TTEST, PROC UNIVARIATE, PROC CHART, PROC GLM, PROC ANOVA for Relationship with Continuous dependent variables. * Converting SAS datasets to Xport format. * Provide SAS training to Oracle Clinical programmers. * Setting up data extracts in Oracle Clinical. Medarex Pharmaceuticals       6/2007 to Clinical Programmer * Responsible for study CRF annotation and Data specification. * Design study data entry screen following the global standards. * Maintain study database and change management. * Transforming Data and Creating Analysis Data sets. * Program the edit checks to support clean file efforts. Program derivation procedures if Needed. * Develop conversion, loading and merging program. * Responsible for coordinating data access and related programming activities (e.g. I- Review and Merged SAS dataset) * Run routine conversion/loading programs. * Program database enhancements. Write and execute ad hoc programs to meet the needs of study team. Provide other programming support to clinical data management. * Participate in database programming testing and debugging TIRs. * Manage CRO in terms of programming deliverables. Population Council       3/2005 to 6/2005 Clinical SAS Programmer * Writing computer programs in SAS and preparing template for the production of Clinical Trials Deliverables (analyzing datasets and specifications, well documented SAS code, Statistical Summary Tables Figures, patient Data Listings, Data _Null_ Reports, ODS) for Internal projects. * Reading Clinical data from SQL database tab delimited files and other types of raw data files. * Performing verification of SAS-generated output. * Assisting in designing data collection forms, converted ASCII, Access and Excel datasets to SAS format, conducted data cleaning and validation. * Downloading data from Oracle using SQL within SAS to be analyzed and exported to Excel for further analysis. * Developing Macros to create tables as RTF files using Percent Macros, ODS, PROC Tabulate and PROC Report. * In addition to complex Data Step processing several SAS procedures were used including FORMAT, FREQ, ANOVA and TRANSPOSE. * Enhancing existing SAS environment by adding utility Macro variables, formatting and pagination macros. * Concatenating, interleaving, and merging datasets. * Providing assistance to biostatisticians on programming techniques. * Develop study databases using VBA. * Producing quality assurance and edit check programs. Procter & Gamble       7/2004 to 2/2005 Clinical SAS Programmer * Providing SAS/SQL programming expertise in the production of Analyses, Tabulations,Graphics and Listings from various data. * Using SQL for data analyses and Statistical Reporting and to create, Populate and Delete tables. * Duties included SAS Programming on UNIX Enterprise Server (C-Shell) and Windows NT environments. Testing a series of SAS programs to generate PDF, HTML, RTF and ASCII Listings using SAS. * Using SAS (BASE, Macros, PROC REPORT, PROC SQL, PROC GLM) programming to support Phase III trials. * Transferred data between databases using import/export facility in SAS and FTP. * Creating SAS Macros to consolidate and streamline table writing routines. * Report-producing from Datamarts/data Warehouses using VBA. * Writing stored procedures using MS SQL. * Converting SPSS system files to SAS. Uploaded SAS transport files onto UNIX. * Converting Excel applications to HTML, utilizing ODS. * Assisting in the integration of data from remote entry sites. Recycle America       3/2003 to 6/2004 SAS Programmer * Writing SAS code to Produce Tables, Listings, Figures, Datasets, pre-processing data, Data Analysis, generating Reports, Statistical Analysis, and Graph; to support reviewing existing SAS code to document the programs, trouble shoots the programs and also taking part in operational settings. * Producing/Transforming users requirements/structured diagrams into code, or Macros/Procedures within application software creating a fully documented, validated application, which can be used by the requester and others to satisfy their needs. * Performing statistical analysis and hypothesis testing using PROC MEANS, REG,TTEST, UNIVARIATE. * Conducting a market research for Enterprise Business Products to identify reasons of lost sales using SAS. Identified research attributes, designed a questionnaire, and gathered real time data from customers. Modeled the trend (used proc format) and performed statistical analysis (used proc freq). * Linear and non-linear Regression Modeling, Cost-Benefit Analyses through Statistical Simulation. * Writing SQL queries to create custom reports for clients, Modifying and updating Tables. * Writing custom safety and efficacy reports directing SAS output to RTF and HTML files. * Cleansed, transformed, analyzed, and presented data from Oracle using SQL Procedure Pass-Through facility (SPT). * Runs weekly productions in an IBM Mainframe environment . * Using PROC GLM for Unbalanced Designs. * Executing numerous Ad-Hoc reports for Marketing department. * Writing ODS SAS procedures to publish reports as HTML pages to Web. Education - , BS in Computer Science , Economics Minor Candidate's Professional training  Click here to request candidate information                         Back to top Questions or comments? Please feel free to contact Implementation Services Group, Inc. at 512/656-7787 or email eric.krohn@sasresources.com Implementation Services Group, Inc. is not affiliated with The SAS Institute, Inc. in any manner. SAS and all other SAS Institute, Inc. product or service names are registered trademarks of SAS Institute, Inc. in the USA and other countries. ® indicates USA registration. Copyright © 2000 - 2010 Implementation Services Group, Inc. Implementation Services Group, Inc. 2423 WestLake Dr. Austin, TX 78746 1-800-474-7079