About Me
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.
Skills & Technologies
Projects
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.
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.
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.
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.
Education
B.Tech
Computer Science & Engineering (Data Science)