Kumar Ayush

I’m a results-driven Data Analyst with two years of experience building the reporting and forecasting layer for procurement and supply chain operations—from Python and SQL ETL through to Power BI semantic models. I enjoy turning complex datasets into strategic decisions with measurable impact for data-driven organizations.

In my current role, I engineered 15+ Power BI dashboards with real-time refresh, covering $4M+ in monthly procurement spend across 200+ suppliers and 5,000+ SKUs. I enabled C-suite decisions 70% faster, and I built scalable ETL pipelines in Python and Power Query processing 100K+ daily transactions at 99.8% accuracy—cutting weekly data prep from 10 hours to 45 minutes.

I also analyze vendor pricing and contract data in Python (Pandas, NumPy) and SQL to surface anomalies and renegotiation targets, delivering $50K+ in annual savings. My Regression and Time-Series Forecasting models improved demand forecast accuracy by 40%, reduced stockouts by 35%, increased inventory turnover by 28%, and the markdown strategy cleared $75K of aged inventory.

To strengthen long-term performance, I designed self-service BI infrastructure for 50+ stakeholders with a 95% reduction in recurring manual MIS reporting, optimized SQL and semantic models to cut report load times 60%, and established a data governance framework with automated validation—ensuring 100% data integrity and reducing data-quality escalations 90%. I’m also Microsoft Certified (Fabric Analytics Engineer Associate, DP-600) and actively building toward my Fabric Data Engineer certification (DP-700).