Headline

Data Analyst | SQL Server · Power BI · Python | Operational Dashboards & Cost Analytics | 5 Yrs | Learning: Azure Data Engineering.

About

I build data systems that people actually open on Monday morning. For the past 5 years at Anvita Constructions, I've been the one person connecting messy field data to boardroom decisions — building and scaling a centralized SQL Server database that continuously onboards new construction and telecom sites as projects grow, all live-linked to Power BI dashboards that management checks daily. Here's what I've shipped: → Real-time cost dashboards across CPWD government projects (Behror, Jaipur, Deoli) — cost overruns flagged before they become expensive → Excel VBA + Power Query automation saving 10+ hours of manual work every week → Vendor performance analytics that replaced gut feel with lead-time and costing data → Payroll automation for 500+ employees — built once, runs clean, zero recurring errors → Scalable site-onboarding system: new project sites plugged into the data pipeline continuously as the business grows

Location

Mathura

Work experience

Data Analyst at Anvita Constructions (I) Pvt Ltd, Jun 2021 - Present · 5 yrs 1 mo, • Architected a centralized SQL Server database consolidating material consumption, labour, billing, and project aging data from 3 CPWD government sites and multiple ongoing telecom project sites — replacing fragmented Excel-only reporting. • Built real-time Power BI dashboards tracking estimated vs. actual costs, billing status, and project aging KPIs across CPWD government projects (Behror, Jaipur, Deoli) — used daily by senior management to flag overruns before they escalated. • Developed DAX measures for cost variance, billing status, and project aging — delivering a single live management dashboard across all active project sites. • Automated stock reconciliation and weekly MIS reporting using Excel VBA and Power Query — eliminated manual errors and saved the team 10+ hours every week. • Built vendor performance analytics and site costing analysis across material usage, transport, and project expenses — enabling fact-based procurement decisions with early overrun flagging. • Gathered reporting requirements from business stakeholders across construction and telecom projects and delivered Power BI dashboards for project costing and billing visibility.

Education

KDS international school

Master of Computer Applications - MCA, Computer and Information Sciences and Support Services, Mangalayatan University, Aligarh