top of page
Projects & Awards
A selection of my Professional Projects & Awards
EXCEL & POWERPOINT | Uncovering Billing Fraud: The Importance of Data-Driven Decision Making
In a recent project, I analyzed billing and claims data to understand provider performance and discovered a discrepancy between the data and operational assumptions.
Despite initial pushback from leadership, I trusted the data and investigated further. By engaging with operational leaders, I uncovered that the provider in question was consistently coding all patients as high-level established visits, regardless of their actual status, to maximize reimbursement and compensation. This practice not only misrepresented the provider's performance but also constituted Medicare fraud. The incident highlighted the importance of speaking truth to power, relying on accurate data, and understanding the sources of truth within an organization. Ultimately, the provider was removed from the practice, and patients and Medicare were reimbursed.
This experience reinforced the critical role of data-driven decision making in identifying and addressing unethical practices within healthcare organizations.
Despite initial pushback from leadership, I trusted the data and investigated further. By engaging with operational leaders, I uncovered that the provider in question was consistently coding all patients as high-level established visits, regardless of their actual status, to maximize reimbursement and compensation. This practice not only misrepresented the provider's performance but also constituted Medicare fraud. The incident highlighted the importance of speaking truth to power, relying on accurate data, and understanding the sources of truth within an organization. Ultimately, the provider was removed from the practice, and patients and Medicare were reimbursed.
This experience reinforced the critical role of data-driven decision making in identifying and addressing unethical practices within healthcare organizations.
TABLEAU | Variance to Budget CMIAA Adjusted
As a Tableau developer, I recently completed a project for a client that involved creating a custom dashboard for their monthly executive team meeting. The dashboard was designed to show the variance to budget in labor costs and included key financial indicators (KFIs) for case mix index (CMI), admissions, and length of stay (LOS).
To develop the dashboard, I first gathered requirements from the client to identify the KFIs that should be included and the types of visualizations that should be used. Based on these requirements, I created a custom dashboard that included graphs and charts to help executives visualize the data and identify trends.
The dashboard was designed to be interactive and allowed executives to drill down into the data for a more detailed view. It also included both actual and budgeted data to provide a real-time view of labor costs.
To ensure that the dashboard was accurate and up-to-date, I sourced the data from the client's financial system and updated it on a regular basis. I also tested the dashboard to identify any issues or bugs and provided ongoing support to the client to ensure that they could use the dashboard effectively.
Overall, the custom Tableau dashboard that I developed provided the client with valuable insights into their labor costs and helped them identify areas where cost savings could be achieved. The KFIs for CMI, admissions, and LOS allowed the client to track their performance in these areas and make informed decisions based on the data.
To develop the dashboard, I first gathered requirements from the client to identify the KFIs that should be included and the types of visualizations that should be used. Based on these requirements, I created a custom dashboard that included graphs and charts to help executives visualize the data and identify trends.
The dashboard was designed to be interactive and allowed executives to drill down into the data for a more detailed view. It also included both actual and budgeted data to provide a real-time view of labor costs.
To ensure that the dashboard was accurate and up-to-date, I sourced the data from the client's financial system and updated it on a regular basis. I also tested the dashboard to identify any issues or bugs and provided ongoing support to the client to ensure that they could use the dashboard effectively.
Overall, the custom Tableau dashboard that I developed provided the client with valuable insights into their labor costs and helped them identify areas where cost savings could be achieved. The KFIs for CMI, admissions, and LOS allowed the client to track their performance in these areas and make informed decisions based on the data.
TABLEAU | Labor Cost Per UOS
As a data analyst, I worked on a project to create an automated Tableau dashboard that made reviewing budget variance metrics for labor analytics a breeze. The dashboard was designed to sit directly on the GL server, providing real-time updates and freeing up more time for coffee breaks.
I worked closely with the client to develop a custom dashboard that met their needs and preferences. I automated the data extraction and transformation process, reducing the need for manual intervention and freeing up more time for... well, more coffee breaks.
The user-friendly dashboard included a variety of visualizations and charts that allowed users to easily review actual-to-budget metrics and identify trends in the data. It was almost as easy as sipping on a freshly brewed cup of coffee.
The project streamlined the labor analytics process, saving the client time and resources while improving their efficiency and productivity. By automating the process and providing real-time updates, the dashboard enabled the client to make better-informed decisions while allowing me to enjoy my coffee in peace.
I worked closely with the client to develop a custom dashboard that met their needs and preferences. I automated the data extraction and transformation process, reducing the need for manual intervention and freeing up more time for... well, more coffee breaks.
The user-friendly dashboard included a variety of visualizations and charts that allowed users to easily review actual-to-budget metrics and identify trends in the data. It was almost as easy as sipping on a freshly brewed cup of coffee.
The project streamlined the labor analytics process, saving the client time and resources while improving their efficiency and productivity. By automating the process and providing real-time updates, the dashboard enabled the client to make better-informed decisions while allowing me to enjoy my coffee in peace.
Note: Identifying details have been anonymized for client confidentiality
bottom of page