Kumar Ayush

Results-driven Data Analyst and Power BI Developer with 3+ years of experience designing dashboards, semantic models and ETL pipelines that turn raw operational data into decisions for finance, procurement and operations leadership. Deep hands-on expertise in Power BI, DAX, Power Query and Microsoft Fabric, paired with Python and SQL for statistical modeling, time-series forecasting and predictive analytics.

Microsoft

Certified in Fabric analytics engineering (DP-600); passionate about transforming complex datasets into strategic, decision-ready reporting.

Data Analyst at Ucare.sa (2024-06 – Present)

Riyadh-based e-commerce retailer — skincare, haircare, cosmetics & healthcare products (Hatim Al-Riadia Holding)

• Design and own 15+ Power BI Dashboards and semantic models (star-schema, DAX) with real-time refresh, tracking $4M+ in monthly procurement spend across 200+ suppliers and 10,000+ SKUs
• Engineer Python and Power Query ETL pipelines processing 100K+ daily transactions at 99.8% accuracy, cutting weekly data-prep time from 4 hours → 1 hour
• Deliver Self-Service BI infrastructure to 50+ stakeholders across procurement, finance and operations, sharply reducing recurring manual MIS reporting
• Partner with the engineering team to optimise SQL queries and semantic model design, reducing report load times, and maintain a Data Governance Framework with automated validation for executive reporting
• Apply Python (Pandas, NumPy) and SQL for vendor-performance modeling and contract analysis, contributing $50K+ in annual savings through pricing optimisation
• Build Regression and Time-Series Forecasting models that lifted demand forecast accuracy by ~40%, supporting a markdown strategy that cleared $75K of aged inventory
• Use AI-assisted, MCP-integrated workflows (Claude + Power BI) to automate dashboard development — new-vendor data analysis, SKU classification and DAX measure creation — cutting manual dashboard-build effort by ~75%

Data Analyst at Ganesh Timber (2023-07 – 2024-05)

Timber trading and processing business

• Managed end-to-end procurement of raw and processed timber, coordinating with vendors on pricing, lead times and quality checks
• Tracked stock levels and movement across warehouse locations, maintaining inventory records and flagging reorder points to reduce stockouts
• Coordinated sourcing, warehousing and dispatch to streamline the supply chain from vendor order to customer delivery, building the reporting discipline carried into later analytics roles

Bachelor of Computer Applications in Computer Applications – Maharaja Agrasen Himalayan Garhwal University (2020-07 – 2023-06)