Summary
Overview
Work History
Education
Skills
Timeline
Generic

Danial Khawaja

Dallas,TX

Summary

As a proven contributor to Banner Health’s Medical Economics team, I combine advanced SQL, Excel, and Power BI expertise with deep healthcare domain knowledge to deliver accurate, high-impact reporting that drives both operational efficiency and strategic decision-making. Over the past 1.5 years working in the Medical Economics Analyst role, I have become a trusted resource for delivering accurate, timely, and actionable data to support both operational and strategic initiatives. From complex SQL querying for finance and behavioral health reporting, to managing the Member Overlap Power BI dashboard, to leading Medical Loss Ratio reporting and Value-Based Payment accrual reporting, I have consistently provided high-quality deliverables that drive informed decision-making. My deep understanding of our data systems, payer requirements, and cross-departmental workflows allows me to anticipate needs, streamline reporting processes, and contribute meaningfully to Banner’s mission. I am excited for the opportunity to continue making this impact as a full-time member of the team.

Overview

9
9
years of professional experience

Work History

Medical Economics Analyst

Banner Health
04.2024 - Current
  • Serve as a trusted analytics partner across finance, behavioral health, and clinical teams by fulfilling recurring ad hoc data requests involving member-level rate matching, county code identification, Medicare HICN lookups, and Medicaid redetermination reporting using advanced SQL querying and Excel integration
  • Deliver quarterly data and metrics to the Behavioral Health Committee, including dementia cohort analysis and raw dataset curation, leveraging multi-table SQL joins and precise data extraction to support care model refinement
  • Support senior leadership initiatives by leading long-term analytical projects on Medical Loss Ratio (MLR) reporting, financial impact assessments, and chronic disease cohort analyses (e.g., ESRD, Diabetes, Dementia), combining SQL data modeling, Excel-based financial calculations, and clear, actionable data storytelling
  • Own and manage a Power BI dashboard (Member Overlap Report) that tracks payer plan overlaps at the member level, providing critical visibility into dual/multiple enrollments to inform payment, care coordination, and audit processes
  • Lead the backend querying and data preparation for monthly Value-Based Payment (VBP) accruals reports, including payment estimation, MMR/RX validation, and patient roster updates for multiple payer contracts, ensuring financial reporting accuracy and operational efficiency
  • Collaborate with actuarial, finance, and clinical teams to design, validate, and automate monthly reporting templates, particularly for payer-specific deliverables, helping streamline complex reporting cycles across multiple stakeholders

Healthcare Data Analyst

Valora Medical Group
09.2023 - 04.2024
  • Extracted data from eClinicalWorks EMR and SQL Database analyzing several Medicare, clinical, and operational variables as well as ICD / CPT Codes in order to transform raw data for analytics
  • Constructed analytical reports in Microsoft Excel by utilizing VLOOKUP, Index Match, Pivot Tables and performed Data Cleaning and Statistical Analysis in order to identify cost savings opportunities
  • Designed comprehensive dashboards and data visualizations in Tableau, Excel, and Power BI in order to effectively communicate KPIs to non technical stakeholders and generate data-driven decision making
  • Spearheaded 2 healthcare software integration projects with EMR by coordinating Extract, Transform, and Load process in order to reduce gaps in care as well as automate Medical Economics metrics in Value-Based Care model
  • Developed multi-step formulas calculating provider utilization percentage based on productivity variables in order to optimize physician scheduling across 10 clinics and 30 providers which resulted in a 25% increase of utilization across the organization

Data Analyst

Professional Development - Career Transition
04.2022 - 08.2023
  • Executed multiple comprehensive data analytics projects in SQL, Excel, Power BI and Tableau, regarding healthcare quality metrics, patient outcomes, and clinical research from publicly-available datasets in order to demonstrate proficiency in technical skills and analytical process
  • View my public projects on my portfolio: danial-khawaja.github.io/DanialKhawaja.github.io

Healthcare Client Solutions Associate

Gerson Lehrman Group
04.2021 - 04.2022
  • Analyzed sales data in Tableau to determine efficiency of new workflow tools by measuring its effect on KPIs and communicated visualizations to team members
  • Conducted competitive analysis and market research to identify target companies for investments in several Healthcare fields such as EHR software, clinic operations, biotechnology, hospital finance, and health insurance

Medical Scribe & EHR Specialist

Kidney Associates of Texas
01.2017 - 04.2021
  • Documented medical histories, physical exams, labs, imaging, procedures, medications, plus additional clinical data in Epic EHR in 4 clinics with an average of 30 patients per shift in order to update patient charts
  • Extracted and Transformed 1000 patients charts from previous EHR software and manually transferred into Epic and validated data in order to coordinate health-system integration process
  • Developed comprehensive knowledge of medical terminology, billing and coding processes, and HIPAA regulations

Education

Bachelor of Arts (B.A.) - Economics, Minor in Public Health

University of Texas at Dallas
Richardson, TX
12.2020

Skills

  • Data Analytics
  • Data Visualization
  • SQL
  • Tableau
  • Power BI
  • Microsoft Excel

Timeline

Medical Economics Analyst

Banner Health
04.2024 - Current

Healthcare Data Analyst

Valora Medical Group
09.2023 - 04.2024

Data Analyst

Professional Development - Career Transition
04.2022 - 08.2023

Healthcare Client Solutions Associate

Gerson Lehrman Group
04.2021 - 04.2022

Medical Scribe & EHR Specialist

Kidney Associates of Texas
01.2017 - 04.2021

Bachelor of Arts (B.A.) - Economics, Minor in Public Health

University of Texas at Dallas