Healthcare Eligibility RPA (1000+ Patients/Day)
Built at an enterprise consulting firm
Overview
Built a Python-based Playwright RPA that checks Medicaid eligibility for 1000+ patients every day. Every morning, the automation pulls patient records from Microsoft Dataverse, uses Power Automate Desktop to orchestrate Python scripts that navigate the Medicaid portal, check eligibility for each patient, perform OCR verification to double-check and reduce errors, and write all results back to Dynamics CRM. The human only needs to log in to the website once per day.
The Problem
Staff manually checked Medicaid eligibility for each patient one by one — a repetitive, error-prone process consuming over 60 hours of manual work every week.
My Approach
Built a Python Playwright automation that pulls patient lists from Dataverse each morning, navigates the Medicaid eligibility portal, checks each patient, uses OCR to verify results and reduce errors, and writes everything back to Dynamics CRM. Power Automate Desktop orchestrates the Python scripts. Human only logs in once per day.