Skip to main content
Ayush GumgaonkarAG
Looking for a job

Ayush Gumgaonkar

@ayushgumgaonkar

Business analyst at NEWME who built a launch tracker that lifted sell-through from 40% to 48%.

India
Message

At NEWME, I built a D7/D14/D20 lifecycle tracker in SQL and Metabase that flags the bottom 10% of launches by D14. It replaced a process with no early performance check, helping merchandising make restock, markdown, and retire decisions sooner as sell-through rose from 40% to 48%.

At NEWME, I also broke down order mix, AOV, and item-level revenue by category for BNM, exposing a 12% AOV gap that shifted merchandising priorities. My age and ASP segmentation found that customers aged 25 to 34 spend 18% more per order, informing their pricing and promo plan.

At Tata CLiQ, I built an 80:10:10 CRM holdout test that showed reported lift was overstated by 30%, leading to corrected GMV reporting. I also moved three brand pipelines from S3 to Redshift with Python and Boto3, cutting ingestion time by 40% and enabling same-day Power BI reports.

My projects include a Python fraud detection model and Power BI dashboard, as well as a customer churn risk analysis using Python and SQL across 64K+ records. I work across analytics, experimentation, and data pipelines to help teams make decisions from their data.

Experience

Work history, roles, and key accomplishments

NE

Business Analyst

Newme

Aug 2026 - Nov 2026 (3 months)

Built a D7/D14/D20 lifecycle tracker in SQL and Metabase, improving sell-through from 40% to 48%. Analyzed order mix, AOV, and customer segmentation to inform merchandising and pricing decisions.

SQLMetabase
Data Analysis
Customer Segmentation
Average Order Value Analysis
Pricing Strategy
Tata CLiQ logoTC

Data Analyst Intern

Tata CLiQ

Jul 2025 - Apr 2026 (9 months)

Built an 80:10:10 holdout test that corrected overstated CRM lift by 30%. Migrated brand pipelines from S3 to Redshift, reducing ingestion time by 40% and enabling same-day reporting.

Education

Degrees, certifications, and relevant coursework

Marwadi University logoMU

Marwadi University

B.Tech, Computer Science

2022 - 2026

Grade: 7.12/10

Pursued a B.Tech in Computer Science, achieving a GPA of 7.12/10. Coursework included Advanced Computational Methods, Statistics, and Data Lifecycle Management.

Interested in hiring Ayush?

You can contact Ayush and 600K+ other talented remote workers on Himalayas.

Message Ayush

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 1,000,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan