Power Bi Data Analytics

Aishwarya Nimmagadda

********************@*****.*** +1-571-***-**** Fairfax, VA LinkedIn

Professional Summary

Health Informatics professional with 5 years of experience in healthcare data analysis, medical coding, EHR systems, Regulatory compliance and clinical workflow optimization. Proven track record in extracting actionable insights, supporting care delivery optimization, and consulting with cross-functional teams on data-driven healthcare solutions. Proficient in SQL, Python, Tableau, Power BI, and Excel, with a strong grasp of ICD-10/CPT, FHIR/HL7, and HIPAA- compliant data handling. Improved reimbursement rates by 15% through predictive modeling and reduced claim rejections by 20% via documentation enhancements. Skilled in ETL, data visualization, and statistical analysis to support evidence-based decisions. Certified in Google Data Analytics and BCG Data Science for Public Sector Simulation, with a focus on leveraging health data for operational and clinical improvements. Skills

Technical Skills & Programming - Python (Pandas, NumPy, SciPy), SQL (Microsoft SQL Server, Joins, CTEs), R, Jupyter Notebooks, Netica, Google BigQuery, SAS, Git/GitHub

Data Analytics, Modeling & Visualization - Tableau, Power BI, Excel Dashboards, Google Data Studio, Descriptive & Inferential Statistics, Predictive Modeling, Logistic Regression, Random Forest, LASSO, Survival Analysis, Time-Series Forecasting, Executive Dashboards

Healthcare Informatics & Standards - EHR/EMR Systems (Epic), Clinical Decision Support Systems (CDSS), PACS, DICOM, Health Surveys (NHANES), ICD-10, CPT, LOINC, SNOMED CT, MedDRA, FHIR, HL7, HIPAA Compliance, CMS Regulations, Value- Based Care

Data Engineering & Management - ETL Pipelines, Data Cleaning & Wrangling, Data Mapping, Data Warehousing, Data Governance, Relational Databases, Workflow Automation, Risk Management

Health Policy, Operations & Communication - Medical Coding & Billing, Revenue Cycle Management, Claim Denial Analysis, Quality & Compliance Reporting, Policy Briefs, Stakeholder Presentations, Population Health Analytics, Root Cause Analysis

Professional Tools & Consulting Competencies - Agile/Scrum, Jira, Confluence, MS Office Suite, Client Communication, Team Collaboration, Problem Solving, Status Reporting, Presentation Delivery, Workflow Optimization, Stakeholder Engagement. Professional Experience

Health Infomatics Analyst, IQVIA Aug 2024 - Present USA

Maintained end-to-end clinical analytics solutions using SQL, Python, Power BI, enabling executive dashboards and actionable insights that improved care quality KPIs by 30% and reduced reporting latency by 40%.

Integrated and analyzed structured and unstructured data from EHR systems (Epic, Cerner), claims, and operational sources via automated ETL pipelines using SSIS, Azure Data Factory, and cloud storage, centralizing over 10M+ patient records in a HIPAA-compliant data warehouse.

Delivered predictive and statistical modeling for hospital readmission, chronic disease risk, and utilization trends using Python, R, SAS, and SPSS, supporting value-based care and population health management initiatives.

Collaborated with clinical, IT, and compliance for data accuracy, governance, and adherence to HIPAA regulations, implementing alerting systems using FHIR, HL7, and standard vocabularies (ICD-10, CPT, SNOMED CT, and LOINC).

Led Agile-based analytics projects, documented workflows in Jira and Confluence, and mentored junior analysts, improving team efficiency and establishing best practices in healthcare data management and reporting.

Collaborated with interdisciplinary teams to extract, clean and validate clinical datasets for operational dashboards and strategic decision-making, supporting both data-driven analysis and workflow consulting. Medical Documentation & Coding Analyst, IKS Healthcare Sep 2022 - Aug 2023 India

Reviewed and accurately coded over 1,500 patient records using ICD-10-CM, CPT, and HCPCS Level II, achieving 99% accuracy and ensuring high-integrity administrative and clinical data for billing, reporting, and compliance consulting.

Conducted predictive analytics and root cause analysis on claim denials using SQL and Excel, leading to a 15% increase in reimbursement rates, reduced rework, and improved transparency in the revenue cycle management (RCM) process.

Led monthly HIPAA and PHI compliance audits, maintaining 100% adherence to federal regulations and minimizing organizational risk through early detection and mitigation of privacy issues.

Collaborated with clinical, HIM, and billing teams to standardize documentation protocols, resulting in a 25% improvement in EHR accuracy and more consistent, compliant clinical records supporting improved patient outcomes.

Designed and delivered data-driven quality improvement reports using SQL, CPT code analysis, and dashboards, accelerating claims processing by 15% and enhancing payer-provider communication for value-based care.

Formed and led a cross-functional task force between coding and billing teams; implemented strategic process changes that decreased claim denials by 20% and strengthened alignment across operations and compliance departments. Healthcare Data Analyst – Senior Analyst, AJ Dental Hospital Aug 2021 - Aug 2022 Telangana, India

Designed and automated end-to-end analytics workflows using SQL and Python (Pandas, NumPy), improving data accuracy and reducing report generation time by 40%, while enhancing the clarity of monthly healthcare utilization and clinical outcome reports by 20%.

Led strategic outreach initiatives to interpret national health policy and translate regulatory requirements for underserved populations across 3 counties, aligning efforts with CMS, ACA, and Medicaid standards to promote equitable access to care.

Partnered with local public health authorities to modernize policy surveillance and crisis response systems using Tableau dashboards and real-time monitoring tools, reducing emergency response time for dental health issues by 30%.

Conducted in-depth analysis of clinical, claims, and population health data to identify trends in disease burden, healthcare access, and preventive care adherence, supporting evidence-based interventions and value-based care models.

Ensured data integrity and compliance with HIPAA and PHI regulations, integrating healthcare data across EHR systems, Snowflake, and Azure Data Lake, while standardizing outputs using HL7/FHIR, ICD-10, CPT, and HEDIS frameworks.

Delivered executive-level dashboards and statistical reports using SAS, Power BI, and advanced visualization tools to support strategic decision-making, risk stratification, and health policy planning. Healthcare Data Analyst – Junior Analyst, AJ Dental Hospital Aug 2019 - Jul 2021 Telangana, India

Conducted in-depth analysis of 500+ Electronic Health Records (EHRs) using SQL, Excel, and Python, uncovering clinical trends that informed the development of targeted preventive care strategies and improved population health outcomes.

Partnered with multidisciplinary care teams to design data-driven clinical workflows, achieving a 30% reduction in average patient recovery time through enhanced treatment planning and operational efficiency.

Analyzed public health indicators and standardized clinical documentation using ICD-10, CPT, and HCPCS coding systems, ensuring compliance with regulatory and reporting standards.

Built and maintained interactive dashboards with Tableau and Power BI to visualize patient demographics, comorbidities, and key health KPIs, enabling real-time clinical and administrative decision-making.

Utilized Python (Pandas, NumPy, Seaborn) for data cleaning, transformation, and statistical analysis; maintained HIPAA- compliant workflows to ensure the privacy and integrity of Protected Health Information (PHI). Education

Master of Science, George Mason University Aug 2023 - May 2025 Fairfax, USA Health Informatics

Bachelor of Dental Surgery, MNR College of Dental Sciences Aug 2016 - Jan 2021 Telangana, India Projects

Machine Learning Project on sleep-diet intake May 2025

Led a capstone project analyzing NHANES data to evaluate the relationship between nutrient intake and sleep duration, using machine learning models (LASSO, Gradient Boosting) and achieving 85% predictive accuracy. Chest X-ray Classification Jan 2025

Designed a CNN model (92% accuracy) for pneumonia detection, reducing radiology analysis time by 25% through automated preprocessing.

Policy Impact Modeling - Antidepressant Selection Optimization Aug 2024

Leveraged LASSO regression across 10,000+ Patient records, visualized via Power BI, pinpointing key demographic disparities in medication adherence, enhancing policy recommendations accepted by 3+ state health organizations. AI Chatbot Evaluation for Mental Health Triage Aug 2024

Validated GPT-based chatbot recommendations against expert physician panels improving accuracy and patient trust, driving a 25% decrease in complaints related to chatbot health advice. Heart Stroke Prediction Jan 2024

Built a risk prediction model using Random Forest (85% accuracy) to support early intervention policies for high-risk populations.

Diabetes Management Platform Aug 2023

Engineered a Python-based patient engagement platform integrating personalized health education modules and self-tracking tools, achieving a 40% increase in patient adherence to medication schedules. Certificates

Google Data Analytics Certificate: Coursera

BCG Data Science for Public Sector Simulation: Forage

Contact this candidate