About
MIS Analyst with a Computer Science (Data Science) background and hands-on experience building automated reporting systems, KPI trackers, and BI dashboards across finance, healthcare, and logistics data. Skilled in Advanced Excel (INDEX/MATCH, XLOOKUP, Power Query, Macros/VBA), Power BI (DAX, data modeling), and SQL for extracting and transforming operational data. Comfortable owning a tracker end-to-end — from cleaning raw exports to flagging the exact metric that moved and why.
Projects4
Budget & Expense Variance Tracker
Built an automated MIS tracker on a public government expense/budget dataset using Power Query to clean data into a Star Schema. Developed DAX measures for YTD spend, remaining budget, and variance views to flag over allocation with focus on exact category overruns.
- Excel
- Power Query
- Power BI
- DAX
Public Health Program Data Quality & Reporting Dashboard
Created a district-level MIS dashboard using public health data tracking case-reporting completeness, submission timeliness, and data gaps. Designed validation/audit checks for data consistency and weekly variance summaries for stakeholders.
- SQL
- Power Query
- Power BI
- Data Validation
Healthcare Cost & Utilization Analysis
Cleaned and standardized public healthcare cost data using SQL, handling missing and inconsistent data. Built drill-down Power BI dashboard analyzing patient utilization and out-of-pocket cost by chronic condition and demographic segments.
- SQL
- Power BI
E-Commerce Order Fulfillment & Delivery Performance Tracker
Modeled multi-table e-commerce operations data into a Star Schema and developed Power BI dashboard tracking delivery metrics and fulfillment performance by region and seller. Conducted root-cause analysis of late deliveries to identify impacting sellers and logistics partners.
- SQL
- Power Query
- Power BI
- DAX
Education1
B.Tech
2021 — 2025Inderprastha Engineering College
Computer Science & Engineering (Data Science)