As a Business Intelligence Analyst, I have developed analytical data solutions supporting hospital leaders and clinical managers using PowerBI, SAP Business Objects, T-SQL stored procedures, and Epic Cogito tools.
Certifications:
-
Microsoft Certified: Power BI Data Analyst Associate
-
Epic Cogito Tools
-
Epic Caboodle Data Model
-
Epic Clarity Data Model
-
Epic Clinical Data Model
The Domains/Subjects reported on include:
Specialty Medical Services
Inpatient Nursing
Surgical and Procedural
Care Management
Trauma Program
Hospital at Home
Transfer Center
Health Information Management
Health System-wide reporting
Chronic Ventilator Dashboard/Exploratory Tool: This dashboard was created for a Quality Improvement Project within the Pulmonary and Critical Care division. This tool allows them to explore a difficult patient population across many dimensions. Including a Drill Through to understand each patient's experience.
Technology Used: PowerBI, DAX, T-SQL, SSMS
Chronic Ventilator Patient Drill Through: In an effort to help the Quality Improvement team, they can drill through from a scatter plot to see details for a patient. The graph was created based on many different discretely recorded data points and allows the user to see them in a visual form that is not available in the Electronic Health Record application.
Technology Used: PowerBI, DAX, T-SQL, SSMS
Pulmonary Consult Service: The purpose of the Pulmonary Consult Service dashboard was to help this group of physicians understand the volume of work they are doing. This helped them in staffing and resource planning.
Technology Used: PowerBI, DAX, T-SQL, SSMS
Surgical Growth Dashboard: The Purpose of this dashboard is to monitor the surgical departments progress to budget targets, surgical cancelations, block utilization, and surgical referrals.
Technology Used: PowerBI, DAX, T-SQL, SSMS
Cancer Related Activities: The purpose of the Cancer Related Activity page is to track progress toward a growth target.
Technology Used: PowerBI, DAX, T-SQL, SSMS
Sample Budget Graph: This PowerBI graph is utilized by Perioperative leadership to track progress to budget.
Technology: PowerBI, DAX, T-SQL, SSMS
Inpatient Nursing: This Health System-wide report was built to monitor progress toward the adoption of a documentation workflow.
Technology: SAP Business Objects, T-SQL
Process Improvement Monitoring: Sample of part of a large system-wide report using statistics (mean absolute error and mean absolute percent error) to access effectiveness of a process improvement.
Technology: SAP Business Objects, T-SQL
Program Impacts: This report was developed to assess programs at General Hospital to connect patients with a variety of health and social programs. The data is used by the program to report to outside agencies as well as used to support grants.
Technology: SAP Business Objects, T-SQL