Ayush Kar

About Ayush Kar

TATA Technologies | Design Engineer • Applied DMAIC principle of Six Sigma in…

Experience

1. Associate Manager

   Gap Inc.

   Dec 2023 — Present · New Delhi, IN

   Data Analytics | Dashboarding | Data Structuring | Supply Chain• Spearheaded KPI dashboard development for sourcing at Gap Inc, enabling strategic decision-making across vendor performance, cost, and capacity• Partnered with business leaders and project owners to implement analytics solutions, ensuringalignment with procurement goals• Enhanced AI-based Q&A visual in Power BI by refining synonyms and cognitive capabilities, enabling natural language querying of procurement datasets• Designed, developed, and optimized Power BI and Tableau dashboards for sourcing KPIs, applyingadvanced DAX calculations, nested functions, and parameters for deep analytics• Conducted procurement diagnostics using techniques like ANOVA, regression, and correlation analysisto evaluate drivers like shipment timelines, vendor rating, and costs• Applied predictive analytics using Python and XGBoost to forecast capacity and identify high-performing vendor-mill combinations, supporting AI-based vendor recommendations• Modeled complex datasets with dimensional modeling principles (star schema) for high-performance reporting and governed data access using Row-Level Security (RLS) in Power BI Service• Collaborated with leadership to define analytical approaches, standardized data cleaning and normalization using Python/Alteryx• Conducted import duty rate variation analysis, improving trade compliance and reducing risk exposure• Automated ETL workflows via Alteryx and optimized DAX queries, reducing dashboard latency by 40%.• Used SQL for data extraction from internal ERP systems to support cost and spend analysis• Designed scalable data architectures aligned with modern data warehousing principles to support commercial analytics• Led cross-functional teams and delivered cost-saving strategies by identifying inefficiencies using operational benchmarking and predictive insights, leading to 15% average savings

Education

• Indian Institute of Management Rohtak

  PGDM, Business Administration and Management, General

  2018 — 2020

Skills

• Manufacturing
• Catia
• Product Development
• Cad
• Product Design
• Automotive
• Geometric Dimensioning & Tolerancing
• Fmea
• Autocad
• Engineering