B. Brooke Mann Email & Phone Number

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.
• 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.
• 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.
• 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.
• 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.

• 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.
• 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.
• 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:

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

Ba, Geology

Activities and Societies: Rice Women's Club Soccer Team, Rice Coffee House Manager, Campanile Orchestra (flute), Rice Karate Club, Sid.

Ms, Business Analytics