Mahesh Rajput

Monitors SLA, TAT, and real-time queue performance across US Healthcare processes, building Power BI dashboards and automating MIS reports using Excel VBA, Power Query, and SQL Server.

Acted as primary MIS/real-time reporting analyst for a US client, delivering SLA, TAT, productivity, and queue performance reporting, and automated recurring reports using Advanced Excel, VBA, Power Query, SQL Server, and Power BI.

Audited 70-80 AR claims daily and 100-150 back-office accounts across three hospital processes, published daily quality and auditor productivity reports, and ran weekly calibration calls with clients.

Audited Verification of Benefits and AR process work using MEDITECH and My Ability billing scrubber software, ran weekly calibration calls and refresher training, and compiled daily production and ATB allocation reports.

Managed AR follow-up, payment posting, and denial management for US healthcare providers, processed ERA/EOB payments, prepared insurance appeals, and identified denial trends.

Managed denial resolution and appeals on Care Tracker software, including ERA/EOB payment posting and denial quantification/categorization, and maintained daily production and ATB reports in Excel.

Adjudicated medical-only and minor lost-time workers' compensation claims under MetLife policy guidelines, determining benefits due and processing timely claim payments and adjustments.

Bachelor of Commerce degree from Chaudhary Charan Singh University, India.