Yash Garg

About Yash Garg

A versatile and adaptive Business Analyst with diverse experience across the aviation and e-commerce sectors, specializing in data analysis, visualization, and business intelligence. I bring strong proficiency in SQL, Excel, and Power BI to build insightful business reports, interactive dashboards, and performance-tracking solutions.Due to an unexpected team restructuring and the unfortunate loss of a key team member, I stepped into a leadership role, now independently managing operations across 8 major sales channels—Flipkart, Amazon, Myntra, Nykaa, Company Website, Ajio, Tata Cliq, and Snapdeal. I also oversee monthly bank reconciliations and manage warehouse-level exceptions, including handling bad pairs and inventory mismatches.My core strength lies in transforming complex datasets into accessible, actionable insights to support strategic decision-making. I ensure timely, priority-based delivery of analytical reports and continuously identify opportunities for process optimization and operational efficiency. With hands-on experience in collaborating with platforms like Flipkart, Ajio, and Tata Cliq, I have consistently delivered high-impact insights that drive business performance.

Experience

1. Senior Analyst

   Campus Activewear Ltd

   Sep 2023 — Present · Gurugram, IN

   Client Interaction & Requirement Gathering:Act as the primary point of contact for stalkholders from Flipkart, Amazon, Myntra, Nykaa, Snapdeal Ajio, Tata Cliq, and the company website.Independently gather, analyze, and validate business requirements related to sales and return data through regular meetings and discussions.2. Data Analysis & Reporting:Analyze complex datasets using SQL and Python to identify trends, patterns, and anomalies in sales and returns.Generate insightful reports and visualizations to support strategic business decisions.3. Dashboard Development:Design and develop interactive dashboards in Power BI to present key sales metrics, return rates, and KPIs for each e-commerce platform.Ensure dashboards provide clear and concise information for stakeholders to make informed decisions.4. Process Improvement:Identify opportunities for process improvement in the sales and return workflows by analyzing current systems and data structures.Recommend actionable changes to optimize operations and enhance customer satisfaction.5. Independent Work:Take ownership of sales and return analysis projects, manage timelines, and work independently with minimal supervision to deliver high-quality results.6. Collaboration:Collaborate with internal teams, product managers, to ensure data accuracy and successful project execution.Work closely with the operations teams to align return policies with business objectives.7. Documentation & Reporting:Create clear documentation for project specifications, data sources, and methodologies to ensure transparency and clarity in sales and return analysis.8. Stakeholder Management:Communicate findings and insights to non-technical stakeholders and leadership from Flipkart, Ajio, Tata Cliq, and the company website.Ensure alignment with business goals by providing actionable insights and recommendations based on data analysis.

Education

• University of Delhi

  Bachelor of Science, Industrial Chemistry

• Lovely Professional University

  Master of Business Administration, Data Analytics

• Lovely Professional University

  Master of Business Administration - MBA, Data science & Business Analytics

• Delhi University

  Bsc industrial chemistry, Organic Chemistry