• Automating health care service re-certification and review procedures using standard SAS macros, Data set (Base SAS 9.4), SAS add-in for MS Office, SAS Stored processes, SAS Enterprise Guide, SAS ODS RTF, Excel, VBA, VB, VBS and specialized SAS Procs
• Developing ETL from clinical and hospital reporting systems and reviewer commentaries
• Automating final, fully-formatted reporting documents in Word and Excel including letters, graphs and detailed supporting data, as well as dynamic and customizable reporting structures

• Used standard SAS macros, Data set (Base SAS), and specialized SAS Procs with Hadoop/HIVE/Impala to test the implementation (as well as Unit Acceptance Testing) of components of critical risk models and give preliminary BI interpretations of the effects of broad changes in methodology related to a Hadoop Data Warehouse
• Developed, hands-on coded, tested and implemented a complete BI architecture for evaluating data constructed from a range of sources
• Built and tested Latex and Tableau implementations to combine and assess Loss Forecasting models using logistic regression and monte carlo methods to expand the predictive range of structural models
• Coded Python 3.5 with Pandas to parse data from Hadoop via the Pig JSONStorage function
• Coded Python 3.5 to read Excel specifications directly into SAS programs to test risk model implementation integrity
• Generally used SAS 9.4, UNIX, SASGRID, various forms of SQL (Impala, Teradata, Oracle, Proc SQL) and SAS Enterprise Guide in a Scaled Agile Framework as the basic query-writing environment for most of the above tasks

Set up Epics in a scaled agile project environment to budget and guide development of very large Tableau arrays (and the Hadoop/HIVE/Impala views on which the arrays were based) describing a population stability indexing model as well as testing everything about population stability in an industrial sector and ensuring the dynamic reporting and customizability needed to access and use these arrays

• Wrote SAS for bootstrapping, used proc surveyselect and hash functions
• Coded Shiny Pages and Monte Carlo models in R as well as bootstrapping in R
• Produced data visualization in R and SAS
• Developed and validated analytic processes to cut waste in Medicare programs
• Worked on Medicare Fraud detection
• Cross-checked procedures in R and SAS for accuracy and optimization in a DB2 SQL environment
• Controlled input and output using SAS intranet, ODS and ODS tagsets, Excel and R (with LATEX and Shiny or Tableau using JSON or XML in some cases)
• Ran simulations in R to ensure samples from large data are adequate to determine the 95% confidence interval for use in potential litigation
• Produced analyses in R (using Rstudio and statistical, graphics and input/output packages) and SAS 9.4 using large macros and statistical procs

Wrote Unix scripts (bash and Bourne-shell) to automate testing

• Created model development and data analysis for all loan investors (FNMA, FHLMC, FHA, VA, Wells Financial, Legacy Wachovia, Wells Owned, etc.)
• Worked with SAS, SQL, PL/SQL, SAS IML and SAS Statistical and Time Series Procs
• Oversaw the automation of Excel VB analyses into SAS analyses

• Designed and built FDA/Clinical Data Consortium Compliant Study Databases for review by independent scientific agencies. This included all forms of analysis and data manipulation, from setting flags to building structures based on the interrelation of dates and times
• Worked with SAS Base, Macros and Oracle technologies to complete Study Databases with full audit trails and complete analytic variables

Advised Statisticians on the consistency and implementation of study and database specifications based on my experience working with Data Monitoring Boards

• Developed and implemented a complete architecture for epidemiological studies using 3 million patients from the GPRD (the health-care system of the UK) while at RTI Health Solutions. This included all patient visits, drugs, treatments, events and outcomes and required extensive communication with epidemiological teams across the globe.
  • FDA labelling for a common anti-depressant was changed as a result of this successful integration of complex treatment data, including timing of physician visits, drug treatments and behavioral outcomes

• Wrote Standard Operating Procedures (SOPs) for the range of types of studies. This required gathering and codifying study requirements and data specifications from clients, clinicians and statisticians. Developed full specs for all stages of analysis based on procedural outlines
• Worked with serious adverse event groups at RTI Health Solutions to bring their information out of their extremely rigid systems in a usable form. This included some unusual types of data extraction such as using SAS(JAVA) XMLmapper to read narratives
  • Directed problem-solving with clients for the complex data problems that arise during programmatic transitions
• Conducted parallel validation of data, statistical and analytic results for clinical studies using stored processes in some cases
• Installed SAS 9.1.3 on a UNIX server at RTI Health Solutions and validated the installation to FDA standards
• Worked with scientific advisory panels to reconstruct and programmatically replicate published studies from final data in order to demonstrate the completeness and accuracy of data in a research repository. This included an extraordinary range of data extraction and manipulation as well as SAS procs related to logistic regression and survival analyses such as PHreg.
• Prepared combined study data reports for Data Monitoring Boards. This included data extraction and modification of analyses from diverse studies
• Used S-plus, R and SAS for data visualization
• Prepared integrated drug safety data reports pulled from multiple studies for submission to the FDA

Created exploratory analyses of large databases (such as UNOS organ transplant data, cancer registries and insurance data) in collaboration with research statisticians and epidemiologists

Oversaw adherence to FDA regulatory requirements at all stages of clinical trials projects

• Programmed clinical studies in SAS 6.12 and 8.2 in the VAX, UNIX and Windows environments using SAS SQL, Macros, ODS and Proc Report among other SAS tools
• Acted as analysis group and project leader for managing the programming side of a number of protocols including meetings with clients to determine regulatory requirements, actions and specifications for all parts of clinical studies
• Gathered and codified requirements for analyses, summaries and reports from clients, clinicians and statisticians
• Developed full specs for all stages of analysis from outlines provided by clinicians and statisticians
• Implemented arrays to extrapolate and interpolate data points according to various algorithms
• Developed and maintained format libraries for a number of studies
• Incorporated human genetic data into analytic structures

Served as a member of Biostatistics Committee which oversaw the introduction of Windows-based procedures, to replace VAX eventually throughout entire department, requiring excellent communication and organizational skills

• Used Base SAS (Version 8) on PC and Sun/Solaris UNIX to analyze test results in academic achievement for students in North Carolina Public Schools
• Used Visual Basic and CGI to maintain websites for assisting teachers with testing procedures and ordering test materials
• Maintained Microsoft Access database, modifying for each new year of testing

• Wrote and validated new analytical, listing and summarizing programs in SAS 6.12 programs to run under CTReview
• Transferred Oracle-based Clintrials 4.1 data structure, an Oracle-based clinical trials monitoring system, using PL/SQL, into new SAS structures and programs using SAS proc SQL
• Worked in a variety of development environments including VAX/VMS, SAS running in AIX (UNIX) and PC SAS

• Wrote SAS programs with Macros for standard tables, listings and graphs
• Supported statistical analyses with statistical procs such as MIXED
• Wrote Statistical Analysis Plans
• Lead programming teams for a number of clinical studies, including collaboration with the clinicians, and assigning team roles and tasks
• Conducted parallel validation of data, statistical and analytic results for clinical studies

• Developed, coded, tested and implemented a complete architecture for epidemiological studies using 3 million patients from the GPRD (the Data Mart for the health-care system of the UK) while at Research Triangle Institute Health Solutions. This included all patient visits, drugs, treatments, events and outcomes and required extensive communication with epidemiological teams across the globe
  • FDA labelling for a common anti-depressant was changed as a result of this successful integration of complex treatment data, including timing of physician visits, drug treatments and behavioral outcomes