# Kumar Ayush

Kumar Ayush is a remote worker on Himalayas, Data Analyst at Ucare.sa, based in India.

Source: https://himalayas.app/@kumarayush

```text
Data Analyst focused on procurement and supply chain analytics—building ETL, forecasting, and BI that drive decisions.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | India |
| Authorized to work in | India, Canada, Germany, United States, United Kingdom, Australia, New Zealand |
| Job categories | Data Analyst, Business Intelligence Analyst, Analytics Engineer, Data Engineering, Predictive Analyst, Analytics Analyst, Data Analytics Specialist |
| Skills | SQL, Python, Pandas, NumPy, DAX, Power Query, Power BI, Star Schemas, Semantic Modelling, Forecasting and KPI Dashboards, VBA, Excel Macros, Microsoft Fabric, OneLake, Lakehouse, Data Warehouse, Data Factory, ELT Pipeline Design, Data Integration, Data Validation, Data Governance, Statistical Analysis, Time Series Modeling, regression, predictive modeling, MySQL, SQLite, Azure, Factory |

## What I'm looking for

```text
I’m looking for a data-driven role where I can build procurement/supply-chain reporting and forecasting, deliver self-service Power BI, and use Python + SQL ETL to create measurable savings, faster decisions, and trustworthy governance.
```

## About

```text
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).
```

## Experience

### Data Analyst (current)

Ucare.sa. Jun 2024 - Present

```text
Built and optimized Power BI dashboards and scalable Python/Power Query ETL pipelines for procurement and supply chain analytics, including spend visibility across 200+ suppliers and 5,000+ SKUs. Delivered vendor pricing anomaly analysis and forecasting models that improved demand forecast accuracy and reduced stockouts, while reducing recurring manual reporting and data load times.
```

Skills: Power-BI, DAX, SQL, Python, Pandas, NumPy, Power-Query, ETL, Data-Modeling, regression, Predictive-Analytics, Data-Governance, Data-Validation

## Education

### Maharaja Agrasen Himalayan Garhwal University

Bachelor of Computer Applications, Computer Applications. 2020 - 2023

```text
Completed a Bachelor of Computer Applications (BCA) covering data structures, algorithms, database management, and statistics.
```

## Tech stack

- NumPy
- Pandas
- MySQL
- SQLite
- SQL
- Microsoft Fabric
- Factory

To contact Kumar, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Hima Sameera Munjampally](https://himalayas.app/@himasameeramunjampal): Data Analyst Intern, Caprus IT Inc
- [Arthi A](https://himalayas.app/@arthia): Remote Data Analyst, Codesizzler
- [Pratiksha Adlinge](https://himalayas.app/@pratikshaadlinge): Senior Engineer – Supply Chain & Analytics, Bosch India
- [bhavith shetty](https://himalayas.app/@bhavithshetty): Power BI, Fabric Developer, Brookfield Renewable
- [vedika hirwani](https://himalayas.app/@vedikahirwani): Data Analyst, Talentica Software
- [Abdullah Sher](https://himalayas.app/@abdullahsher): Business Intelligence Analyst, DCC Propane
- [Kratika Gupta](https://himalayas.app/@kratikagupta1): Senior Advisor, MIS & Reporting Operations, Concentrix
- [Balram Prajapati](https://himalayas.app/@balramprajapati): Manager, BI & Data Solutions, Teleperformance
- [Sheela K](https://himalayas.app/@sheelak): Data Analyst, Content Cabin
- [Abhi M](https://himalayas.app/@abhim1): Data Analyst Intern, Rows and Columns
