
Foreign-trained dentist with hands-on experience in oral diagnosis, restorative care, patient history review, and treatment documentation. Background also includes healthcare claims concepts, ICD-10-CM, CPT, HCPCS, EOBs, eligibility, and prior authorization fundamentals, along with strong accuracy, organization, and care coordination in clinical settings.
Healthcare Claims Analysis | MySQL & Microsoft Excel, GitHub: https://github.com/Tejaswi80/healthcare-claims-analysis.git(Personal project), Performed end-to-end healthcare claims data cleaning and transformation using MySQL functions including REPLACE, CAST, and STR_TO_DATE, Developed SQL queries using CTEs, window functions, CASE statements, GROUP BY, and aggregations to analyze claim volume, allowed amounts, paid amounts, payment rates, provider specialties, HCPCS codes, and geographic regions., Conducted allowed-versus-paid amount analysis to identify reimbursement variance patterns and calculated an overall payment rate of 80.51%., Created Microsoft Excel PivotTables and Pivot Charts to analyze claims and reimbursement patterns by specialty, state, and HCPCS code.