Open to Data Analyst & Product Analytics roles · Chennai / Remote

Data tells stories. I make them legible.

I'm Gautham — a Data Analyst with 5+ years across banking, quick commerce and SaaS. I turn messy product, payments and growth data into trusted metrics, automated reporting and decisions teams can defend — then build the tools that make the work repeatable.

SQLPythonTableauPower BIAirflowPostHog

00 — How it all started

I wasn't supposed
to be an analyst.

Mechanical engineering degree, MBA in marketing & finance — then a risk desk at HDFC Bank, building fraud-trend decks and telling analysts which merchants to set alert rules on. One day it clicked: I was handing insights to analytics instead of being analytics. So I studied the craft, learned the role had a name, and switched sides.

01 — HDFC Bank · 2020–22

Fraud & risk
was the classroom.

Card, NetBanking and UPI fraud investigations — IP trails, device fingerprints, OTP logs, transaction velocity. Decision rules that cut false positives ~10%, 100% of cases resolved within TAT, and ₹1 Cr+ in loss prevention.

02 — Dunzo → Zocket · 2022–now

Then data became
the product.

A/B frameworks that lifted merchant retention 15%. BigQuery slot consumption cut 80%. Dashboards for 20+ stakeholders, Airflow ETL over $4M/month of ad spend, and a revenue-logic rebuild that corrected a 15% MRR overstatement.

03 — Nights & weekends · ongoing

Now I ship the tools
I wished existed.

Revenue analytics platforms, CRMs, statement parsers, schema visualizers, invoicing systems — 18 products built, several deployed and in daily use.

The receipts

Numbers don't flatter. They testify.

₹1 Cr+HDFC Bank · 2020–22fraud loss prevented — card, NetBanking & UPI investigation rules that cut false positives ~10%
$0KSQL auditrevenue recovered via reconciliation
$0M/moAirflow ETLad spend given live visibility
0%automationdaily reporting time cut — 3+ hrs back, every day
0%BigQueryslot consumption eliminated
0%A/B frameworkmerchant retention lift
0nights & weekendsproducts designed, built and shipped — several deployed and in daily use

Start with the proof

The stories behind the numbers.

Two investigations show how I work when the numbers cannot be wrong. Three builder stories show how those lessons became products.

Explore all five cases →
Analyst case · Zocket

The $22K wallet leak

Stripe and Facebook Ads were assumed to reconcile. A full-population SQL audit found two silent bugs quietly leaking revenue.

$22K recovered read the investigation →
Analyst case · Zocket

The 15% MRR mirage

Investor-facing revenue was overstated for months. Root-caused the calculation logic, rebuilt it, and reconciled reporting to actuals.

15% corrected read the investigation →
Builder case · Apex

Killing the board-meeting spreadsheet

Why I turned the month-end revenue ritual into one import button that outputs investor-grade MRR movements and cohorts.

Hours → minutes read why I built it →
Builder case · Statement Wizard

PDF parsers lie on page 40

Why I built a statement converter that treats the document's own totals as ground truth — and fails loudly instead of silently.

100% verified read why I built it →
Builder case · SchemaSight

Tribal knowledge, mapped

Why I built a tool that turns any database schema into an explorable relationship map nobody has to explain in a meeting.

Weeks → minutes read why I built it →

The toolbox

Fluent in the
whole stack.

8 domains · 45+ tools
5.5+ years sharpening them

daily drivers —

SQLPythonTableauAirflowPostHog

amber = domains · brighter stars = daily drivers · hover to spotlight a cluster

01 / SQL & databases

SQL — advanced queries Window functions · CTEs Query optimisation BigQuery Amazon Redshift PostgreSQL MySQL

02 / Python

Pandas · NumPy Matplotlib · Seaborn Streamlit API integration Web scraping Data cleaning & wrangling

03 / visualisation & BI

Tableau — Desktop · Server · Prep Power BI — DAX · Power Query LOD expressions Looker Studio Metabase Redash

04 / Excel

Advanced Excel XLOOKUP · INDEX-MATCH Pivot tables · slicers Power Query · Power Pivot Interactive dashboards

05 / product analytics

PostHog — events · replay · paths CleverTap — funnels · cohorts A/B testing Campaign analytics

06 / data engineering

Airflow — DAGs · ingestion ETL pipelines Data quality & validation Data & database modelling Git — GitHub · GitLab

07 / automation & reporting

Reporting automation Scheduled delivery · alerts n8n · Zapier · Make API & webhook workflows Cursor · AI Studio

08 / analytical techniques

MRR/ARR movements · cohorts Churn · LTV · AOV · GMV · NRR CPA · ROAS · CTR · attribution CAC-to-LTV Funnel & root-cause analysis Segmentation · activation

core = strongest, used daily

The road so far

Every day, a level up.

2014 — 2018

B.E. Mechanical Engineering

Panimalar Engineering College

Learned how machines work. Started wondering how decisions do.

2018 — 2020

MBA — Marketing & Finance

Anna University

The business lens: funnels, margins, markets — the questions data would later answer.

Aug 2020 — Feb 2021

Retail Credit Risk — Location Manager

HDFC Bank

Credit risk across the full retail loan range — document verification, multi-disbursement flags, recovery.

Feb 2021 — Aug 2022

Payments Risk — Location Manager

HDFC Bank

Fraud patterns from thousands of transactions → decision rules. ₹1 Cr+ prevented, false positives cut ~10%, 100% cases within TAT.

Aug 2022 — Jul 2023

Analyst

Dunzo · Quick Commerce

A/B framework → retention +15%, order volume +10%. BigQuery slots cut 80%. Dashboards that boosted tele-caller productivity 20%.

Aug 2023 — now

Data Analyst II

Zocket · SaaS, AI Marketing

Reporting cut 90%. Revenue logic rebuilt (15% MRR overstatement fixed), $22K recovered, funnel work that lifted paid conversion 4%, Airflow ETL over $4M/mo spend.

01 / Data & Analytics

The day job,
done properly.

Dashboards, cohort engines, sentiment pipelines and revenue analytics — the analyst work comes first.

Flash.co NPS Tableau dashboard
Python + Tableau

Flash.co NPS Analysis

Scraped and sentiment-analyzed 1,000+ Play Store reviews in Python, then built a Tableau dashboard tracking NPS trends so the team could act on what users actually said.

Anime recommendation system built in Tableau
100% Tableau

Anime Recommendation System

A working recommendation engine built entirely inside Tableau — no code, pure LOD expressions and parameter actions.

Private build

Apex — SaaS Revenue Analytics

One upload → investor-grade metrics: MRR movements (new, expansion, churn, reactivation), cohorts, new-vs-repeat revenue. The manual reporting grind becomes an import button.

GitHub ↗

SaaS-Dash

Client-side revenue analytics: drop a payments CSV, get MRR, cohorts, refund bridge and geo splits. The file never leaves your browser.

Private build

Bacon Product Analytics

Postgres + PostHog + Stripe + Meta Ads unified: DAU/MAU, ROAS, cohorts, credit consumption — with automated re-engagement triggers on drop-off.

Private build

Payments & Ad-Spend BI

Flask BI dashboard for multi-currency ad-spend and payments analytics across platforms.

Classic analyses

Pipelines & automation

02 / SaaS Products

Built, shipped,
in production.

Tools born from real analyst pain — revenue, reconciliation, schemas, invoices.

● Live

Brandos CRM

Kanban pipeline with probability-weighted MRR, founder dashboards (ARR, ACV, CaC, win rate), one-click WhatsApp & email outreach with auto-logging.

● Live

Bizeract

Agency platform: 3D scroll site, blog engine, lead pipeline, Razorpay payments — plus a full internal CRM with WhatsApp campaigns.

Private build

Statement Wizard

Bank & credit-card PDF statements → clean Excel with reconciliation built in. Reliable on the large multi-page files where AI parsers fall over.

Private build

SchemaSight

Paste a schema, instantly map every relationship, key and column type — so anyone can understand a database without a walkthrough.

Private build

UPI Collect

GST invoicing → IRN → Tally XML sync → UPI QR → automatic bank-statement reconciliation. Integer-paise money math end to end.

● Live

WowWrite

AI writing suite: content detector, humanizer, and 50+ writing tools.

Private build

SubTrack

SaaS subscription discovery and spend management.

GitHub ↗

Taxera

Marketing site for Indian business-registration and legal services.

03 / Apps & Experiments

Because shipping
is a habit.

Games, extensions, native apps — the playground where the product instincts come from.

Flutter · iOS + Android

Wake Me

Destination alarm that wakes you before your stop. Zero-API-key map stack (MapLibre + OSRM + Photon), battery-adaptive GPS, rings through silent mode.

PWA + Android

HueHunt

The daily color-memory challenge that sharpens your eye and tests your recall.

Swift · macOS

Parallel (App Cloner)

Run multiple isolated instances of the same macOS app side by side. Native Swift.

Gemini AI

CineSage

AI movie recommendations that actually get your taste.

Chrome extension

Hide Numbers

Masks numbers and sensitive data for safe screenshots — built by an analyst who shares dashboards all day.

Gemini AI

GitFolio AI

Turns any GitHub profile into portfolios, case studies and career-gap analysis. This site's spiritual ancestor.

Web · Android · iOS

Color Flip

One-tap color-matching arcade game — three platforms, one codebase.

Gemini AI

Cosmos

AI astrology across Western, Tamil and Telugu traditions.

Gemini Vision

Nutriscan

Snap food, get calories and macros.

Vercel

Language Box

All-in-one AI language toolkit.

Chrome + Firebase

Task Recorder

Interval nudges to log what you're working on.

GitHub ↗

GitHub Line Counter

Gamified total-lines-of-code counter with milestone badges.

Go deeper

Read the case studies.

Five deep dives — the $22K wallet leak, the 15% MRR correction, and why I built Apex, Statement Wizard & SchemaSight.

case studies →

The full catalog

Browse every project.

30+ builds and analyses with the why, what, how and who-it-helps for each.

all projects →