Sarath Kumar Sugumar

Data Analyst @McKesson

Denton, TX, US

Developed advanced SQL queries to extract and analyze EDI 837 and 835 healthcare claims data, enabling accuratereimbursement validation and detailed denial root cause analysis.Designed and deployed interactive dashboards in Tableau to monitor KPIs such as claim acceptance rate, denial trends,turnaround time, and reimbursement variance for operational and executive teams.Engineered and maintained ETL workflows within Microsoft Azure to integrate EMR/EHR datasets into structured datamodels for centralized healthcare reporting.Automated recurring claims reconciliation and compliance reporting processes using Python, reducing manual reportingeffort by 35% and improving data accuracy.Performed comprehensive data quality checks aligned with HIPAA and CMS regulations to ensure PHI protection andregulatory compliance across reporting systems.Conducted regression analysis and anomaly detection on high-volume claims datasets, improving billing accuracy by20% and supporting revenue cycle optimization.Optimized SQL-based reporting logic and backend data models, reducing Tableau dashboard refresh time by 30% andenhancing performance for business users.Standardized HL7 & FHIR data formats by mapping, validating, and transforming structured and semi-structured healthcare data, ensuringaccurate patient and provider record integration, interoperability compliance, and improved cross-system data consistency across platforms.Supported fraud detection initiatives by analyzing claims patterns and identifying suspicious billing activities, reducingfinancial risk exposure by 15%.

Vel Tech Rangarajan Dr. Sagunthala R & D Institute of Science & Technology, Chennai

Bachelor of Technology - BTech, Computer science and engineering

University of North Texas

Master's degree, Information systems and technology

VELTECH RANGARAJAN DR.SAGUNTHALA R&D INSTITUTE OF SCIENCE AND TECHNOLOGY

Bachelor of Technology - BTech, Networks and Cybersecurity

University of North Texas

Master of Science - MS, Information systems and technologies