Ayush Gumgaonkar profile photo 1 on Tal

Ayush Gumgaonkar

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

Mumbai

< 1 year of work experience

Tata CLiQ Fashion
Jul 202510 mosApr 2026

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%.
Infotact Solutions
Jan 20253 mosMar 2025

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.

Ayush’s AI Stack

aistudio
aistudio
cursor
cursor
notion
notion
openai
openai

Education

Marwadi University

Bachelor of Technology, Computer Engineering

Marwadi University

20224 yrs2026
Marwadi University

Marwadi University

20224 yrs2026

Join Ayush and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

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