Data Analyst · SQL · Python · MIS Automation · Mumbai

Yatharth
Singh

Data Analyst with 1+ year of experience translating complex datasets into strategic decisions. Specialised in scalable MIS systems, KPI reporting, and customer analytics — with a measurable record of reducing costs, improving accuracy, and driving revenue.

Open to opportunities
📍 Mumbai, India  ·  B.Tech Computer Science · VIT Bhopal · 2024
SQLPython Data AnalysisMIS Reporting KPI DashboardsBusiness Intelligence RFM SegmentationCohort Analysis Data AutomationETL Pipelines Behavioral AnalyticsCampaign Optimization Product AnalyticsAI-Augmented Analytics SQLPython Data AnalysisMIS Reporting KPI DashboardsBusiness Intelligence RFM SegmentationCohort Analysis Data AutomationETL Pipelines Behavioral AnalyticsCampaign Optimization Product AnalyticsAI-Augmented Analytics
80%
Gain in cross-platform reporting accuracy via dynamic SQL validation
4–5 hrs
Saved daily by automating MIS pipelines with Python & Apps Script
20%
Uplift in campaign conversion via RFM-driven customer segmentation
50+
SQL & Python analyses delivered across product, marketing & business

About
Yatharth

Results-driven Data Analyst with 1+ year of hands-on experience in the financial services industry, specialising in SQL-based data engineering, Python automation, MIS reporting, and customer analytics. Currently contributing to the Product & Business Intelligence function at Axis Securities Limited, Mumbai.

I combine strong technical skills with business acumen — translating complex datasets into actionable insights that inform product decisions, optimise marketing spend, and improve operational efficiency. Experienced in collaborating cross-functionally with product managers, marketing leads, and senior stakeholders to deliver analytics that create measurable impact.

What sets me apart: a forward-leaning approach to AI-augmented analytics — leveraging tools like Claude AI, Gemini, and ChatGPT to accelerate SQL development, automate repetitive workflows, and prototype solutions faster than traditional methods.

Education
B.Tech — Computer Science & Engineering
Vellore Institute of Technology, Bhopal  ·  2020–2024
Industry Experience
Financial Services · Stockbroking
Axis Securities Limited, Mumbai  ·  May 2024–Present
Domain Strengths
Product Analytics Business Intelligence Data Engineering Marketing Analytics Fintech & BFSI AI-Augmented Workflows

Professional
Experience

MAY 2024 — Present · Full-time
Axis
Securities
Limited
Data Analyst — Product & Business Intelligence · Mumbai

Axis Securities is one of India's leading full-service stockbroking firms. Embedded in the Product team, I own the end-to-end analytics lifecycle — from pipeline engineering and data quality to stakeholder dashboards that directly drive product strategy and revenue decisions.

SQL
Python
Google Apps Script
CleverTap
Netcore
Advanced Excel
01 Re-engineered platform data tagging logic using dynamic SQL validation frameworks, resolving systemic inconsistencies across revenue, trading volume, and UTC metrics — improving cross-platform reporting accuracy by 80%.
02 Designed and deployed a fully automated MIS reporting system (SQL + Python + Google Apps Script) with dynamic architecture that auto-onboards new platforms — eliminating manual maintenance and enabling real-time business visibility.
03 Built and maintained production KPI dashboards tracking Unique Login Count (ULC), Unique Trader Count (UTC), net revenue, and trading volume — the primary data source for product managers and senior leadership decision-making.
04 Conducted 50+ exploratory data analyses (EDA) across product, marketing, and business verticals — identifying user behaviour patterns, engagement drop-off points, and platform performance gaps using SQL and Python (Pandas, NumPy).
05 Automated end-to-end reporting pipelines in Python, reducing manual reporting effort by 80% and reclaiming 4–5 person-hours daily. Leveraged AI-assisted query optimisation (Claude AI, ChatGPT, Gemini) to reduce development and debugging cycles by 50%.
06 Built customer segmentation and behavioural analytics models (RFM, cohort, migration analysis), improving customer retention by 10–15% and enabling data-driven campaign strategies that lifted conversion rates by 20% across targeted user segments.

Skills &
Expertise

01
Programming & Data Engineering
SQL Python Pandas NumPy Data Cleaning Data Modeling ETL Pipelines Query Optimisation Data Automation Google Apps Script
02
Analytics & Business Intelligence
KPI Reporting MIS Reporting Business Intelligence Customer Segmentation RFM Analysis Cohort Analysis Campaign Analytics Behavioural Analytics Exploratory Data Analysis Data Storytelling
03
Tools, Platforms & AI Stack
Advanced Excel CleverTap Netcore ChatGPT Claude AI Gemini AI Figma AI Grok Prompt Engineering AI-Augmented Analytics

Projects &
Outcomes

01

RFM Customer Segmentation Model

Python · SQL · Pandas · Customer Analytics · Behavioural Segmentation

Developed a Recency-Frequency-Monetary (RFM) segmentation model on live trading and revenue data. Engineered percentile-based scoring to classify users across high-value, loyal, at-risk, and dormant segments. Delivered actionable segment profiles to the marketing team, enabling precision-targeted retention campaigns that improved conversion rates by ~10% over broad-cast strategies.

+10%
Campaign
Conversion Rate
02

User Migration Analytics Algorithm

Python · SQL · Product Analytics · Behavioural Tracking · User Journey Analysis

Designed and implemented a behavioural tracking algorithm to monitor user migration patterns between trading platforms, using rolling 3-month activity windows, trade volume trends, and recency scoring. Classified users into migrated, partial adopter, and dormant cohorts — enabling the product team to deploy targeted re-engagement interventions that improved platform adoption by ~15% and reduced churn-related drop-offs.

+15%
Platform
Adoption Rate
Actively Seeking New Opportunities Available immediately · Mumbai (On-site / Hybrid) & Remote
Data Analyst
Product Analyst
Business Analyst
Analytics Engineer
04 — Get In Touch

Ready to
make data
work harder.

I'm actively looking for my next role — a team that values rigorous analysis, clean data infrastructure, and analysts who think like product stakeholders. I bring proven impact, a strong technical foundation, and the initiative to build things that last. If that fits what you're looking for, let's connect.