🏥 Healthcare Data Analyst  ·  Clinical, Claims & EHR Analytics

SELECT name, title, experience, edge
FROM analysts
WHERE name = 'Loknadh Kona';

· Aug 2025 – Present

• Optimized complex SQL (SQL Server, PostgreSQL) and Snowflake data models on large-scale claims datasets, improving reporting performance by 35%.
• Performed advanced EDA in Python (Pandas, NumPy, SciPy) on Medicare & Medicaid data, contributing to an 18% cost-optimization gain.
• Built interactive Power BI dashboards (claims volume, reimbursement trends, denial rates), cutting claim processing delays by 22%.
• Implemented SQL + Python data quality frameworks, improving accuracy and consistency by 30%, and automated reporting workflows to reduce manual effort by 40%.
• Delivered HIPAA & HITECH-compliant regulatory reports, reducing audit discrepancies by 25%.

· Jan 2021 – Dec 2023

• Managed EHR and claims analytics using SQL, SAS, and Advanced Excel, improving reporting efficiency by 25%.
• Developed Tableau dashboards and executive reporting on clinical performance and reimbursement metrics, reducing prep time by 40%.
• Performed data cleaning, wrangling, and QA across Oracle & MySQL, improving data integrity by 28%.
• Validated ICD, CPT, and HCPCS coding accuracy, reducing coding-related data exceptions by 22%; supported successful audits with zero major findings.

Python · Jupyter · scikit-learn · Random Forest · Permutation Testing

A clinical-grade validation case study: the same Random Forest on the same EEG signal data scored 81% → 51% → 37% depending only on how honestly it was tested. Demonstrates leakage-aware train/test splits, baseline-anchored benchmarking, effect sizes, and a permutation test — then reports an honest null result. The exact rigor that separates a trustworthy clinical metric from a misleading one in healthcare analytics.

SQL Server · Python · Power BI · DAX · CMS HRRP FY2026

Analyzed 30-day readmission rates across 3,055 U.S. hospitals using CMS HRRP FY2026 data, identifying $402.2M in avoidable excess cost. Built a 5-page Power BI dashboard pinpointing the conditions, hospital types, and states driving the highest Medicare penalty exposure.

T-SQL · Star Schema · Medallion Architecture · SQL Server

Built a production-grade data warehouse from scratch (Bronze → Silver → Gold layers). Engineered 13 advanced analytical scripts covering customer segmentation (VIP / Regular / New), product rankings, and time-series revenue analysis (YoY & MoM) using RANK, DENSE_RANK, LAG, and window functions.

Power BI · SQL · DAX · Data Modeling

Uncovered a hidden 15% delay rate in Standard Class shipments across the Southern region using custom SQL SLA metrics. Built interactive Power BI dashboards giving logistics managers a single view to isolate bottlenecks and drive corrective action.

Excel · Pivot Tables · Dynamic Slicers · KPI Tracking

Interactive Excel dashboard analyzing 1,000+ call records with dynamic slicers, KPI tracking for operational analytics, rep performance, and regional breakdowns — enabling fast, data-driven service decisions.

Excel · Array Formulas · FILTER Function · Map Charts

Interactive Excel dashboard exploring 2023 data science job salaries across 9 roles, 50+ countries, and 5 schedule types — built with advanced array formulas and geographic map charts for instant global insight.