Quality Control Sas Programmer

Summary

Experienced SAS programmer with ** years of experience in Epidemiology using real world data to produce datasets, tables and reports for epidemiologists and analysts. Able to use excellent quality control procedures to look for outliers, patterns of missing data and units to build both patient cohort and analysis datasets and reports.

Professional Experience

DLH Corporation

May 2022 to January 2024.

Senior SAS Programmer and Data Manager

Develop SAS programs and macros for observational study requests from NIH rare diseases and NIEHS environmental disease exposure epidemiologists using real world data

Use SAS and SQL to extract, clean and validate data from large database applications on different platforms such as Redcap and other web locations

Create datasets, tables and reports for analysts and epidemiologists

Perform quality control of team member programs

Create documentation for team programs

Work smoothly with team members

Attend R seminar. Continue with R class.

AFSvision Business Intelligence

April 2019 to January 2022

Senior SAS Programmer.

Create SAS programs for ETL, query reporting of very large datasets in many different forms such as SAS datasets, Microsoft SQL, and text or hexadecimal datasets

Upgrade current large SAS application system with hundreds of programs from SAS 9.2 to SAS 9.4.

Perform quality control of programs from other team members as well as transfer data to other SQL applications for web based visualization

Work and communicate well with team

Amgen

2017 – 2019

Senior SAS Programmer

Create SAS and SQL programs and macros to produce patient cohorts for epidemiologists and analysts using real world claims data from Marketscan and Optum’s Commercial, Medicaid and Medicare very large datasets as well as British and Japanese databases

Perform quality control of other programmer’s programs at a 99% data match rate

Create both disease and drug datasets to be used in visualizations in Spotfire for epidemiologists and analysts

Allergan

2016 – 2017

Senior SAS Statistical Programmer

Using SAS and SQL, download complex patient level healthcare data from Marketscan and Optum’s Commercial, Medicaid and Medicare large datasets to develop patient cohorts for epidemiologists and HEOR researchers

Analyze data using SAS following Statistical Analysis Plan and contribute to plan updates.

Pfizer

2015 – 2016

SAS Programmer

Using SAS and SQL to download and process data from large patient level datasets of cohorts in Truven, Optum, Humedica and Thin claims databases checking for outliers and missing data.

Using RX, lab, hospital and physician reported data and ETL to create SAS programs to support drug safety analyses and cohort creation with SAS Base/SQL, proc report, ODS, XML, Macros and Teradata SQL

Output and validate tables, listings and graphs for epidemiologists

Perform QC of programs for Epidemiology programming group as well as review previous programs for comparison to new Saeftyworks software

Review OMOP outcome definitions from mini-sentinel group white paper to select disease algorithms with highest consensus among reviewers for ten important diseases

Contribute to the development of analytic standard operating procedures (SOPs), guidelines, and reference materials

Blue Cross

2014

SAS Programmer

Extract and analyze healthcare patient level data with SAS and Teradata SQL to produce reports and data downloads from very large (>50 M) claims databases to connect data to new epidemiological screening tool linking field nurses and high risk Medicare clients saving company millions of dollars.

Produce logic checks, derived datasets, data listings, summary tables, and figures

Debug, modify, and validate programming

Work well with both junior and senior staff to efficiently design solutions to solve analytic or data management problems within the context of a project team

University of Pennsylvania Medical School (Sleep Epidemiology)

2000 – 2014

SAS Programmer

Use SAS Base, STAT, Procedures and Macros to validate, clean, and apply statistical procedures and algorithms to observational data from epidemiological patient trials.

Use ETL to extract data from many different sources such as Stata and SQL databases, actigraphy and performance handheld machine output as well as Sandman sleep diagnosis software

Produce batched quality control and statistical reports for team members as well as creating datasets for FDA submission

Develop tables, listings and graphs using SAS, SQL, Stata, and VBA as well as graphing software.

Communicate and work smoothly with all members of clinical team

Technical Skills

SAS: SAS EGS/Unix, SAS/BASE, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/GRAPH

SAS/STAT: t-tests, chi-square, Fisher’s exact, one-way ANOVA, paired t-tests, logistic regression, linear regression, multiple regression, and McNemar or Wilcoxon sign rank test

SQL: SAS SQL, TeraData SQL, Impala, Hadoop SQL, Hue

Relational Databases: Optum, Marketscan, Blue Cross claims database, JMDC, THIN, Humedica and unique EHR and lab datasets, UK Read database

Enrolled in R course, finished class in GIS mapping

Reporting: Spotfire, Tableau

Platforms: Unix, Linux, Windows server, Microsoft

Other skills: Medical terminology, healthcare claims, ICD10 and ICD9, CDM, VBA

Education

Temple University

BA in Mathematics

Publications

An Implementation and visualization of the tree based scan statistic for safety event monitoring in longitudinal electronic health data. Schachterle S, Hurley S, Liu Q, Petronis K, Bate A Drug Safety, 2019

Screening for severe obstructive sleep apnea syndrome in hypertensive outpatients. Gurubhagavatula I, Fields BG, Morales CR, Hurley S, Pien GW, Wick LC, Staley BA, Townsend RR, Maislin G. J Clin Hypertens (Greenwich). 2013 Apr;15(4):279-88.

Predictors of continuous positive airway pressure use during the first week of treatment. Ye L, Pack AI, Maislin G, Dinges D, Hurley S, McCloskey S, Weaver TE. J Sleep Res. 2012 Aug;21(4):419-26.

In-home, self-assembled sleep studies are useful in diagnosing sleep apnea in the elderly. Morales CR, Hurley S, Wick LC, Staley B, Pack FM, Gooneratne NS, Maislin G, Pack A, Gurubhagavatula I. Sleep. 2012 Nov 1;35(11):1491-501.

Noninferiority of functional outcome in ambulatory management of obstructive sleep apnea. Kuna ST, Gurubhagavatula I, Maislin G, Hin S, Hartwig KC, McCloskey S, Hachadoorian R, Hurley S, Gupta R, Staley B, Atwood CW. Am J Respir Crit Care Med. 2011 May 1;183(9):1238-44.

Outcome of CPAP treatment on intimate and sexual relationships in men with obstructive sleep apnea. Reishtein JL, Maislin G, Weaver TE; Multisite Study group. J Clin Sleep Med. 2010 Jun 15;6(3):221-6.

Obstructive Sleep Apnea in Patients Undergoing Bariatric Surgery-A Tertiary Center Experience. Sareli AE, Cantor CR, Williams NN, Korus G, Raper SE, Pien G, Hurley S, Maislin G, Schwab RJ. Obes Surg. 2009 Aug 11.

Validation of venous leg ulcer guidelines in the United States and United Kingdom. McGuckin M., Waterman R., Brooks J., Cherry G., Porten L., Hurley S., Kerstein MD. American Journal of Surgery. 183(2):132-7, 2002 Feb.

Screening for sleep apnea in commercial drivers: single-night heart-rate variability. Penzel T., Staley B., Hurley S., Keenan B., Maislin G., Gurubhagavatula I.

Feasibility of unattended sleep studies in diagnosing sleep apnea in commercial drivers. Staley B., Hurley S., Keenan B., Maislin G., Gurubhagavatula I.

Value of unattended, overnight oximetry in finding occult sleep apnea in commercial drivers. Staley B., Hurley S., Keenan B., Maislin G., Gurubhagavatula I.

Portable sleep studies as screening tools for sleep apnea in commercial drivers. Staley B., Hurley S., Keenan B., Maislin G., Gurubhagavatula I

Role of actigraphy in estimating sleep time in commercial drivers. Staley B., Hurley S., Keenan B., Maislin G., Gurubhagavatula I

Contact this candidate