In this role, I use SQL, Python & SAS coding skills, along with Power BI dashboard & data visualization expertise, to support criminal investigations and audits of DOI contracts and grants. My work also includes database design and extraction-transformation-loading (ETL) for our SQL Server warehouse.

As part of the Pandemic Response Accountability Committee (PRAC) Data Science Fellowship program, I was detailed to the US Department of the Interior / Office of Inspector General / Data Analytics Unit to identify fraud, waste, abuse, and mismanagement among pandemic relief funding recipients, primarily for the Paycheck Protection Program (PPP). I also completed general data analysis projects to support audits, investigations, and evaluations of DOI-awarded contracts and grants.ETL • SQL /… Show more As part of the Pandemic Response Accountability Committee (PRAC) Data Science Fellowship program, I was detailed to the US Department of the Interior / Office of Inspector General / Data Analytics Unit to identify fraud, waste, abuse, and mismanagement among pandemic relief funding recipients, primarily for the Paycheck Protection Program (PPP). I also completed general data analysis projects to support audits, investigations, and evaluations of DOI-awarded contracts and grants.ETL • SQL / Python / SAS • Power BI Dashboards & Visualizations Show less

SAS- & SQL-based report development and analysis for Medicare's Oncology Care Model (OCM) program at 16 practices within The US Oncology Network. I collaborated with clinical & non-clinical practice staff and internal quality & finance teams to deliver insights related to practice operations and total cost of care. For example:• predictive, claims-based eligibility, enrollment & billing reports for practice staff, with 96% accuracy rate;• total cost of care and hospice utilization… Show more SAS- & SQL-based report development and analysis for Medicare's Oncology Care Model (OCM) program at 16 practices within The US Oncology Network. I collaborated with clinical & non-clinical practice staff and internal quality & finance teams to deliver insights related to practice operations and total cost of care. For example:• predictive, claims-based eligibility, enrollment & billing reports for practice staff, with 96% accuracy rate;• total cost of care and hospice utilization evaluations;• practice-specific reports to identify missed revenue opportunities, within the constraints of Medicare billing rules; and• SAS-based ETL macros to ingest >300M quarterly & semi-annual claims data lines, with 21 different file layouts, to enable analysis & Tableau visualizations by my colleagues.I was also part of a cross-functional team that completed ad hoc analysis projects to support value-based care contract evaluations and practice/payer negotiations (e.g., collaborating with finance and clinical pharmacy colleagues to evaluate chemotherapy regimen selections by specific cancer type / stage / biomarker combinations for an episode-based contract proposal; identifying a patient population based on complex clinical & administrative eligibility criteria, for multiple practices; etc.). Show less

SAS- & SQL-based report development and analysis for the United Healthcare "Episodes of Care" pilot program at two practices within The US Oncology Network. I collaborated with clinical & non-clinical practice staff and our internal quality leads to deliver insights related to total cost of care. Highlights:• Developed an automated daily report to highlight inpatient admissions and discharges for practice staff, to enable timely clinical follow-up.• Developed an automated quarterly… Show more SAS- & SQL-based report development and analysis for the United Healthcare "Episodes of Care" pilot program at two practices within The US Oncology Network. I collaborated with clinical & non-clinical practice staff and our internal quality leads to deliver insights related to total cost of care. Highlights:• Developed an automated daily report to highlight inpatient admissions and discharges for practice staff, to enable timely clinical follow-up.• Developed an automated quarterly report a practice's Medical Director of Quality could use to identify potentially inappropriate use of expensive white blood cell growth factors.• Developed automated weekly patient enrollment & regimen selection reports for practice leadership. Show less

(1) Managed all aspects of the beneficiary survey and reporting process for 30+ Nurse Advice Line and Disease Management clients:• designed and implemented survey campaigns based on contract requirements, national accreditation guidelines, and industry standards;• wrote complex SQL queries for sample data extraction;• coded SAS programs for statistical analysis of results;• wrote summary reports; and• presented findings to internal / external customers.(2) SAS- &… Show more (1) Managed all aspects of the beneficiary survey and reporting process for 30+ Nurse Advice Line and Disease Management clients:• designed and implemented survey campaigns based on contract requirements, national accreditation guidelines, and industry standards;• wrote complex SQL queries for sample data extraction;• coded SAS programs for statistical analysis of results;• wrote summary reports; and• presented findings to internal / external customers.(2) SAS- & SQL-based reporting and analysis for health outcomes studies, Six Sigma projects, quality initiatives, geographic analysis, targeted marketing campaigns, accreditation reviews, and call center operations. Show less

University of Colorado Center for Lower Atmospheric Studies — HIRDLS SIPS Project — http://archive-eos.acom.ucar.edu/hirdls/