---
title: "Ayush Gumgaonkar - Data Analyst Intern in Mumbai | Tal"
description: "Meet Ayush Gumgaonkar, Data Analyst | Python · SQL · Power BI | ETL Pipelines · AWS Redshift | BI Dashboards · Marketing Analytics based in Mumbai. AI stack includes aistudio, cursor, and notion."
image: "https://tal.club/meet/ayush-gumgaonkar/share-image"
---

# Ayush Gumgaonkar on Tal

## Headline

Data Analyst \| Python · SQL · Power BI \| ETL Pipelines · AWS Redshift \| BI Dashboards · Marketing Analytics

## About

I build the data infrastructure that makes business decisions possible — not just reports that describe what already happened\. At Tata CLiQ Fashion, I spent 10 months embedded with the CRM team doing end\-to\-end data work: engineering Python/Boto3 ETL pipelines that cut ingestion latency by 40%, designing an 80:10:10 holdout framework to measure true GMV lift from marketing campaigns, and building a live Power BI dashboard that tracked Burn Efficiency and Revenue Per Visit — so stakeholders stopped relying on one\-off analyst pulls\. We moved the team from descriptive to diagnostic analytics, cutting manual data wrangling by 60%\. Before that, at Infotact Solutions, I queried and analyzed 10M\+ records in Python and SQL to surface emerging tech trends that fed directly into strategic roadmap planning — and automated recurring data workflows that cut manual processing time by 50%\. Outside of internships, I've built a fraud detection classifier on 500K\+ transactions \(99\.7% accuracy, <2% false\-positive rate\) and a 3\-tier churn risk model across 64K\+ customer records — both designed to translate patterns into revenue protection, not just model metrics\. My stack: Python \(Pandas, Boto3, Scikit\-learn, NumPy\) · SQL · R · Power BI · Tableau · AWS S3 · Amazon Redshift · BigQuery · ETL Pipelines · A/B Testing · Statistical Modeling I'm looking for full\-time roles in Data Analytics, Business Intelligence, Data Engineering, or Product Analytics where I can work close to the business — not just the notebook\.

## Location

Mumbai

## AI stack

aistudio

cursor

notion

openai

## Work experience

Data Analyst Intern at Tata CLiQ Fashion, Jul 2025 \- Apr 2026 · 10 mos, Mumbai, Maharashtra, India, \-\-> ETL & Data Engineering Built Python/Boto3 ETL pipelines that moved transactional data across multiple retail brands from AWS S3 into Amazon Redshift — cutting ingestion latency by 40% and giving the CRM team a reliable, trusted data foundation\. \-\-> Marketing Analytics & Experimentation Designed a custom 80:10:10 holdout framework to measure true GMV lift from marketing campaigns — because the business needed actual numbers, not what the platform reported\. \-\-> Identity Resolution & Customer Data Used a Customer Data Platform \(CDP\) to unify disjointed customer records from multiple retail brands into a single "Golden Record" per customer — improving targeting accuracy for CRM campaigns\. \-\-> Business Intelligence Built a live Power BI dashboard tracking Burn Efficiency and Revenue Per Visit \(RPV\), used directly by the CMO and CEO for campaign decisions — eliminating ad\-hoc analyst requests entirely\. \-\-> Process Optimization Transitioned the team from manual, descriptive reporting to diagnostic analytics — reducing data wrangling time by 60%\.

Data Analyst Intern at Infotact Solutions, Jan 2025 \- Mar 2025 · 3 mos, Bengaluru, Karnataka, India, \-\-> Data Analysis at Scale Queried and analyzed 10M\+ records in Python and SQL to identify emerging technology trends — findings fed directly into strategic roadmap planning\. \-\-> Tool Evaluation & Validation Assessed 4\+ analytical tools against performance and volume benchmarks, documenting gaps and confirming production readiness before rollout\. \-\-> Workflow Automation Automated recurring data transformation and storage workflows in Python — cutting manual processing time by 50% across the team\.

## Education

Bachelor of Technology, Computer Engineering, Marwadi University

Marwadi University

[View the original profile](https://tal.club/meet/ayush-gumgaonkar)

```json
{
  "@context": "https://schema.org",
  "@graph": [
    {
      "@type": "Person",
      "@id": "https://tal.club/meet/ayush-gumgaonkar#person",
      "name": "Ayush Gumgaonkar",
      "url": "https://tal.club/meet/ayush-gumgaonkar",
      "image": "https://tal.club/meet/ayush-gumgaonkar/profile-photo.jpg",
      "description": "Meet Ayush Gumgaonkar, Data Analyst | Python · SQL · Power BI | ETL Pipelines · AWS Redshift | BI Dashboards · Marketing Analytics based in Mumbai. AI stack includes aistudio, cursor, and notion.",
      "jobTitle": "Data Analyst Intern",
      "worksFor": {
        "@type": "Organization",
        "name": "Tata CLiQ Fashion"
      },
      "hasOccupation": {
        "@type": "Occupation",
        "name": "Data Analyst Intern"
      },
      "homeLocation": {
        "@type": "Place",
        "name": "Mumbai"
      },
      "alumniOf": [
        {
          "@type": "EducationalOrganization",
          "name": "Marwadi University"
        },
        {
          "@type": "EducationalOrganization",
          "name": "Marwadi University"
        }
      ],
      "knowsAbout": [
        "aistudio",
        "cursor",
        "notion",
        "openai"
      ],
      "mainEntityOfPage": {
        "@id": "https://tal.club/meet/ayush-gumgaonkar#webpage"
      }
    },
    {
      "@type": "ProfilePage",
      "@id": "https://tal.club/meet/ayush-gumgaonkar#webpage",
      "url": "https://tal.club/meet/ayush-gumgaonkar",
      "name": "Ayush Gumgaonkar on Tal",
      "description": "Meet Ayush Gumgaonkar, Data Analyst | Python · SQL · Power BI | ETL Pipelines · AWS Redshift | BI Dashboards · Marketing Analytics based in Mumbai. AI stack includes aistudio, cursor, and notion.",
      "dateModified": "2026-07-21T18:50:46.866Z",
      "isPartOf": {
        "@id": "https://tal.club/#website"
      },
      "mainEntity": {
        "@id": "https://tal.club/meet/ayush-gumgaonkar#person"
      },
      "primaryImageOfPage": {
        "@type": "ImageObject",
        "url": "https://tal.club/meet/ayush-gumgaonkar/profile-photo.jpg",
        "contentUrl": "https://tal.club/meet/ayush-gumgaonkar/profile-photo.jpg",
        "caption": "Ayush Gumgaonkar profile photo on Tal"
      },
      "inLanguage": "en-IN"
    }
  ]
}
```