04/17/2026
I built a synthetic OB/GYN dataset in Excel to simulate real-world revenue cycle analysis.
Using 20 mock patient encounters, I created pivot tables to evaluate reimbursement by visit type and identify denial trends by payer. I then applied slicers to filter denial reasons (eligibility, medical necessity, missing modifiers, etc.), allowing me to quickly isolate root causes.
Through this, I was able to identify:
• Higher denial volume tied to specific payers
• Eligibility issues pointing to front-end gaps
• Missing modifiers indicating coding opportunities
This project reflects how I’m actively transitioning from coding into data analysis by using data to drive insight, not just process it