Durga Prasad Vangari

Analyzed large-scale patient data from the EPIC EHR system to enhance clinical quality reporting and patient outcome tracking. Developed advanced SQL queries to extract demographics, ICD-10 and CPT codes, and billing data to support clinical and revenue cycle analytics. Built interactive Power BI dashboards to monitor readmissions, length of stay (LOS), mortality rates, patient throughput, and care gaps, while performing patient risk modeling using Python to identify high-risk populations and reduce hospital readmissions. Automated ETL pipelines using SSIS and Azure Data Factory and integrated HL7 feeds into a centralized data warehouse to streamline data ingestion. Ensured HIPAA compliance, conducted EMR-to-claims data validation, and delivered CMS-compliant reports for value-based care initiatives. Performed cost and revenue leakage analysis, optimized SQL queries reducing runtime by 35%, and partnered with clinical and executive teams to support population health strategies, executive reporting, and regulatory audits.

Extracted and analyzed patient data from hospital EMR systems to support clinical, operational, and financial reporting. Developed SQL-based reporting solutions and interactive Tableau dashboards to track inpatient, outpatient, and emergency department metrics, bed occupancy, patient flow, and length of stay (LOS). Analyzed admission trends, seasonal disease patterns, and mortality/morbidity data to support informed clinical decision-making. Created financial reports for insurance claims and billing reconciliation, improving revenue cycle reporting accuracy by 25%. Performed data cleansing and transformation to ensure high data quality and integrity, while identifying discrepancies in patient registration and claims records. Automated Excel-based reporting processes, reducing manual effort by 40%. Supported NABH compliance reporting, infection control monitoring, and chronic disease cohort analysis. Collaborated closely with clinicians and IT teams to enhance EMR data integration, ensure data confidentiality, and improve overall reporting efficiency.

Analyzed patient diagnostic data including lab results and imaging records to support clinical, operational, and revenue insights. Built interactive Power BI dashboards to monitor test volumes, turnaround time (TAT), patient registrations, and billing performance for leadership reporting. Wrote and optimized SQL queries to extract patient, appointment, and revenue data, improving reporting accuracy and efficiency. Conducted statistical and trend analysis to identify abnormal lab patterns and support quality assurance initiatives. Automated recurring reports using SQL and Excel macros, reducing manual effort and turnaround time. Partnered with healthcare providers and administrative teams to ensure data accuracy, regulatory compliance, and continuous improvement in reporting processes.