Harsh Gupta

As a highly skilled and detail-oriented Power BI System Analyst, my objective is to leverage my expertise in data analysis, visualization, and business intelligence to provide actionable insights and enhance decision-making processes. I aim to apply my proficiency in Power BI, SQL, and data modeling to design and implement efficient reporting solutions that streamline operations and drive business growth. By collaborating with cross-functional teams, I seek to continuously improve data analytics strategies and help organizations achieve their goals through effective data-driven decision-making

• B.A, 3 Yrs. degree, CSJM University, 2020
• Diploma in Electronics & Communication Engineering, 3 Year, BTEUP Lucknow, 2017

• Data Visualization Projects
• Coding and Data Programming
• Reading Articles on Data Trends

RCM Performance Dashboard

• Description: Create a comprehensive dashboard that tracks key RCM performance indicators like accounts receivable (AR) aging, denial rates, payment trends, and collections efficiency.
• Key Features: KPIs like AR days, denial ratios, payment collection trends, payer mix analysis, and historical performance comparisons.

Revenue Cycle KPI Dashboard

• Description: Design a KPI dashboard to monitor metrics such as days in accounts receivable (DAR), average payment time, clean claims rate.
• Key Features: Visualizations of revenue cycle metrics by payer, department with drill-down capabilities to identify areas for optimization.

Accounts Receivable (AR) Aging Report

• Description: Create a detailed AR aging report in Power BI that tracks unpaid invoices by age bucket (0-30 days, 31-60 days, etc.) and identifies overdue accounts.
• Key Features: AR aging summary, overdue invoice visualization, payment collection trends.

RCM Quality Dashboard

• Description: Developed a comprehensive RCM Quality Dashboard to monitor key performance metrics such as Quality Score, Fatal%

Automated Data Extraction from Multiple Tools (ECW, Modemed, Waystar, TriZetto)

• Description: Use Power Automate to extract data from various healthcare tools such as ECW (eClinicalWorks), Modemed, Waystar, and TriZetto, and integrate it with other data systems (e.g., databases, SharePoint, Excel).
• Key Features: Automate data extraction from different platforms, consolidate data into a central repository, automate data transformation and storage for reporting.

Denial Management and Report Automation

• Description: Automate the denial report creation process by extracting relevant data from multiple RCM tools, aggregating it, and generating reports using Power BI Report Builder. Use Power Automate to automatically send the denial reports to stakeholders.
• Key Features: Data extraction from RCM tools (e.g., ECW, Waystar), automated generation of Denial Reports in Power BI, email notifications, and scheduling of automated report delivery.

• Father's Name: Late Ramesh Chandra Gupta
• Date of Birth: 08/13/97
• Gender: Male
• Marital Status: Married