Gautham Mahadevan

Data Analyst โ€ข Product Analytics โ€ข Business Intelligence

5.5+ years delivering data-driven insights across SaaS, Quick Commerce, and Banking

Senior Data Analyst with 5.5+ years of experience driving growth and optimization across SaaS, Quick Commerce, and Financial Services. Prevented $22K+ in revenue loss, unlocked real-time visibility into $3M+ in monthly ad spend, and cut reporting time by 90%. Deep hands-on expertise in SQL, Python, Tableau, Airflow, and product analytics tools (PostHog, CleverTap). Specialized in SQL, Python, Excel, and Tableau.

๐Ÿ“Š Currently seeking: Data Analyst | Product Analyst | APM roles โ€” Open to remote & relocation
๐Ÿ“Š Transforming Data into Strategic Business Decisions
$22K+
Revenue Loss Prevented
90%
Report Time Reduction
$4M+
Ad Spend Visibility
gautham@data:~$ SELECT insights FROM chaos WHERE noise = '0';

Why Work With Me? ๐Ÿ’ก

Core competencies that drive results

Business Impact Through Data

Prevented $22K+ in revenue loss through proactive data auditing. Cut reporting time by 90% and unlocked real-time visibility into $3M+ in monthly ad spend.

Cross-Functional Collaboration

Partner with Product, Finance, Marketing, and Engineering teams to drive data-driven decisions. Built investor-ready dashboards and automated MIS reports for the CFO.

Analytics Velocity

Engineered dashboard ecosystems cutting daily report generation by 3+ hours (90% reduction). Deployed automated Airflow pipelines for ad spend ingestion across $4M+ in monthly ad spend.

Zero-to-One Builder

Built end-to-end data infrastructure from scratch at Zocket. Examined 5,000+ historical fraud cases to contribute to risk scoring models at HDFC.

Product Mindset

Leveraged CleverTap to map user conversion funnels, drove 4% improvement in paid conversion rate. A/B testing framework improved merchant retention by 15% and order volume by 10%.

Solo Builder

Building complex Products, SaaS & Mobile apps from scratch using Cursor, Gemini, Claude and much more. Mastering the art of AI-assisted development.

Domain Expertise ๐ŸŒ

Industry experience across high-growth sectors

๐Ÿฆ

Banking & Fintech

2 years at HDFC Bank

Fraud analytics, risk modeling, pattern recognition. Examined 5,000+ fraud cases, prevented losses exceeding Rs. 1 Crore, achieved 95% detection accuracy.

๐Ÿš€

Quick Commerce

1 year at Dunzo

A/B testing, attribution modeling, performance tracking. Optimized surge pricing increasing gross margin by 5%, improved merchant retention by 15%.

๐Ÿ’ผ

SaaS & Digital Marketing

2.5+ years at Zocket

Revenue analytics, subscription metrics, funnel optimization. Prevented $22K+ revenue loss. CleverTap implementation drove 4% paid conversion lift.

By The Impact ๐Ÿ“ˆ

Quantified results from real business challenges

$22K+
Revenue Loss Prevented
Wallet audit caught Stripe & Facebook API issues
90%
Report Time Reduction
Dashboard ecosystem via Tableau & Python/Streamlit
$4M+
Ad Spend Visibility
Airflow pipelines for Facebook & Snapchat
15%
Revenue Discrepancy Reduced
Revamped revenue calculation logic at Zocket
4%
Conversion Increase
CleverTap funnel optimization
80%
Slot Time Reduction
Optimized Tableau dashboard queries in GCP

My Data Philosophy ๐ŸŽฏ

The principles that guide my analytical journey

"Data is like garbage. You'd better know what you're going to do with it before you collect it."

โ€” Mark Twain (inspired)

Accuracy First

Clean data is the bedrock of every meaningful insight.

Automate Always

If it can be automated, it should be. Efficiency is key.

Visualize Deeply

A good chart tells the story that numbers can't speak.

Iterate Fast

Learning from data is a continuous, rapid evolution.

Raw
Clean
Insight
Turning Chaos into Clarity

Featured Work ๐Ÿš€

A collection of my work in data science, AI, and full-stack development

"Code is poetry, data is the story"

Featured Analytics & Data Science

Play Store NPS Analysis

NLP

Sentiment analysis and Net Promoter Score tracking from Play Store reviews using NLP techniques to categorize user feedback.

Roller Coaster EDA

Python

Statistical deep-dive into coaster specs to identify trends in engineering and design record-breakers.

Flipkart Scraper & Analysis

Web Scraping

Custom scraping pipeline to extract and analyze mobile pricing data from Flipkart listings.

Used Car Price Predictor

ML

Price prediction model trained on diverse market data using regression algorithms.

Center Point Analytics

Geospatial

Tool for calculating and visualizing central points of geographic data clusters.

Full Stack Products

Tools & Developer Utilities

GitHub Line Counter

Python

Simple utility to calculate total lines of code across all public repos in a GitHub profile.

Mercury Automation

Automation

Scripts for automating workflows and data processing on the Mercury platform.

Experimental & Fun

Hangman Solver AI

Python

Intelligent algorithm for solving Hangman word puzzles using frequency analysis.

Game Automation Bot

Python

Automated scripts for solving logic games and competitive browser environments.

Chess Integration

TypeScript

Tooling for generating detailed reports and analysis from online chess matches.

Abacus Generator

Education

Automated problem generator for mental arithmetic and abacus training exercises.

My Toolbox ๐Ÿ› ๏ธ

Technical Expertise & Tools

SQL

Expert ยท 5.5+ years

Advanced queries, Window functions, CTEs, Query optimization โ€” MySQL, PostgreSQL, BigQuery.

Tableau

Advanced ยท 4+ years

Dashboards, LOD expressions, Calculated fields, Parameters, Performance optimization, Actions, Data blending.

Python

Intermediate ยท 3+ years

Pandas, NumPy, Matplotlib, Seaborn, Streamlit, API integration, Web scraping.

Excel

Advanced

Advanced Excel, XLOOKUP, INDEX-MATCH, Pivot tables, Slicers, Power Query, Power Pivot, Interactive dashboards.

CleverTap

Advanced

User journey mapping, funnel analysis. Drove 4% conversion increase and 20% user acquisition improvement.

BigQuery

Expert

Schema design for analytics, cost optimization, derived tables. Reduced cloud spend by 80%.

Looker Studio

Intermediate

Interactive reports and blended data visualization for cross-functional stakeholders.

Power BI

Intermediate

Dashboards, Power Query, DAX, Data cleaning and Transformation, Data Modelling.

PostHog

Intermediate

Product analytics, Session replay, HOGQL, A/B testing, User path analysis, Behavioral cohorts.

Airflow

Intermediate

DAG development, Data ingestion, Pipeline monitoring. Git (GitHub, GitLab), Data and Database Modelling.

Automation Tools

Advanced

N8N, Zapier, Make, Cursor, AI Studio โ€” Automating workflows and data processing.

Key Achievements ๐Ÿ†

Quantified Impact

โšก
80%
Slot Time Reduction
Optimized Tableau dashboard queries in GCP
โฐ
20+
Hours Saved Weekly
Automated manual reporting processes
๐Ÿ“ˆ
15%
Discrepancy Reduced
Revenue calculation logic overhaul at Zocket
๐ŸŽฏ
90%
Report Time Reduction
Dashboard ecosystem with Tableau & Streamlit
๐Ÿ’ฐ
$22K+
Revenue Loss Prevented
Wallet audit & API integration issue detection
๐Ÿ›ก๏ธ
95%
Detection Accuracy
Precision in fraud identification
โšก
100%
TAT Adherence
Metric-driven operational excellence
๐Ÿ’ผ
10+
Products Managed
Cross-functional risk oversight

Work Experience ๐Ÿ’ผ

Professional Experience

Data Analyst II

Zocket (SaaS - AI Marketing) August 2023 - Present
๐Ÿ† Key Wins
$22K+ Revenue Loss Prevented 90% Report Time Cut $4M+ Ad Spend Visibility Automated Airflow Pipelines
  • Engineered a dashboard ecosystem using Tableau and Python/Streamlit, cut daily report generation time by 3+ hours (90% reduction), and provided real-time KPI visibility to 20+ stakeholders across product, marketing, and leadership teams.
  • Prevented $22K+ in revenue loss by auditing wallet balances and spotted critical Stripe and Facebook API integration issues that caused duplicate entries and incorrect spending limits.
  • Revamped revenue calculation logic and reduced discrepancies by 15%, ensuring accurate financial reporting for investor relations and executive decision-making.
  • Leveraged CleverTap to map the user conversion funnel, identified critical drop-off points including mid-signup abandonment and payment page friction, enabling the product team to address these gaps and drive a 4% improvement in paid conversion rate.
  • Built a comprehensive PostHog analytics dashboard for Bacon integrating PostHog event data, database, and Meta campaign data to track DAU/MAU, ROAS, cohorts, credit consumption, and tool usage patterns enabling the team to identify drop-off points and trigger targeted re-engagement notifications automatically.
  • Deployed automated Airflow pipelines for Facebook and Snapchat ad spend ingestion, delivering real-time visibility into $4M+ in monthly ad spend, eliminating 3+ hours of weekly manual data collection, and enabling the team to identify high-spend customers for targeted upsell campaigns to higher-tier plans.

Analyst

Dunzo (Quick Commerce - B2B) August 2022 - July 2023
๐Ÿ† Key Wins
15% Merchant Retention โ†‘ 5% Gross Margin โ†‘ 20% Productivity Boost 80% Slot Time Reduction
  • Designed and executed A/B testing framework for promotional campaigns (coupons, banners), measured campaign effectiveness, and improved merchant retention by 15% and order volume by 10%.
  • Developed attribution model for B2B operations that calculated session losses due to weather and curfew constraints, optimized surge pricing which increased gross margin by 5%.
  • Established automated performance tracking dashboard for 30+ sales and tele-callers, delivered 20% productivity boost, and reduced manual reporting time by 12 hours/week through KPI monitoring dashboards.
  • Optimized Tableau dashboard queries in GCP and achieved 80% reduction in slot time by optimising the joins and tables which also slashed the query run time by over 4 hours.

Location Manager - Payment Frauds

HDFC Bank February 2021 - August 2022
๐Ÿ† Key Wins
โ‚น1Cr+ Saved 10% Reduced False Positives 95% Detection Accuracy
  • Examined 5,000+ historical fraud cases to contribute to build risk scoring models and rule-based detection systems, prevented losses exceeding Rs. 1 Crore, and reduced false positive rates by 10% through data-driven pattern recognition.
  • Conducted trend analysis and demographic segmentation on cybercrime incidents (phishing, account takeovers, unauthorized transactions) across South India, created weekly and monthly Excel dashboards, and delivered data-driven insights to senior management and stakeholders across risk, compliance, and banking operations.
  • Analyzed and contributed to data-driven alert mechanisms that processed millions of daily transactions, which achieved 95% accuracy in suspicious activity detection with sub-2-minute response time, and prevented Rs. 1.2+ Crore in potential losses.
  • Investigated daily card, NetBanking, and UPI fraud cases by piecing together IP locations, device fingerprints, SMS OTP logs, and merchant transaction trails โ€” resolved 100% of assigned cases within TAT.

Location Manager Risk - Retail Assets

HDFC Bank August 2020 - February 2021
๐Ÿ† Key Wins
Managed 10+ Products Portfolio Quality Monitoring
  • Managed risk assessment for 10+ banking products (Personal Loans, Auto Loans, Credit Cards) with ticket sizes up to Rs. 50 lakhs. Created data presentations and reports tracking portfolio quality metrics, early mortality rates, and collection trends to inform risk mitigation strategies.

Education ๐ŸŽ“

Academic Background

Jul 2018 - Jun 2020

Master of Business Administration (MBA)

Anna University

Specialization in Marketing & Finance โ€ข Grade: 7.4

Jul 2014 - Apr 2018

Bachelor of Engineering (B.E.)

Panimalar Engineering College

Stream: Mechanical Engineering โ€ข Grade: 7.4

2014

Higher Secondary (12th)

Velammal Matriculation

Computer Science & Maths โ€ข 95.3%

2012

Secondary School (10th)

SDCVV

Science & Maths โ€ข Grade: 8.8

Let's Connect! ๐Ÿค

Get in Touch

Location

Chennai, India

Open to Remote & Relocation

Best Contact

gautham2597@gmail.com

Availability

Immediate

LinkedIn

Connect with me