At R1 RCM Inc., I built an Excel production tracker to monitor progress and productivity across a 25-member team, replacing manual employee-by-employee searches and reporting.
I distribute daily work inventory using XLOOKUP, VSTACK, and IF formulas. I also review patient financial documents and assess charity care eligibility against organizational and regulatory guidelines.
My work includes calculating patient income and financial responsibility with standardized formulas, then validating data for accurate, policy-compliant decisions.
In my projects, I designed a relational MySQL database to analyze Spotify data, developed a Power BI dashboard for student performance, and created an Excel dashboard for e-commerce sales trends.
