IIT Bombay '25 · Business Analyst · Bangalore

Ajit Pal Singh

Data Analyst | Business Analyst | IIT Bombay Graduate

Turning business data into actionable insights through SQL, Excel, Power BI, Python, and automation.

EducationIIT BombayB.Tech (2021–2025)
Current RoleBusiness AnalystEmoha Elder Care
Core StackSQL & Power BIExcel, Python, Zoho
SpecializationLTV & MIS DashboardsReporting Automation
About Me

Bridging Business Context & Analytical Execution

I am an IIT Bombay graduate currently working as a Business Analyst in Bangalore. My core work revolves around analyzing complex business data, building interactive dashboards, and automating operational reporting.

In my day-to-day role, I go beyond merely reporting numbers. I explore data across customer funnels, marketing channels, and business units to find patterns, diagnose underlying issues, and deliver conclusions that lead to tangible improvements in business processes and sales workflows.

To keep operations agile, I actively leverage AI tools and automation (Copilot, ChatGPT, and Python scripts) to streamline repetitive reporting, consolidate multi-workbook Excel spreadsheets, and speed up data wrangling — freeing up time for deeper analytical problem-solving.

With a strong grounding in both analytical tools (SQL, Excel, Power BI, Zoho Analytics) and software engineering foundations (Python, Java, C++, APIs, and DSA), I build practical, reliable solutions that connect business questions with measurable outcomes.

📊

Business & Data Analysis

Sales funnels, revenue metrics, Customer Lifetime Value (LTV), and cohort retention — using data to guide real operational decisions.

⚡

Dashboard & MIS Automation

Automating recurring reports and building live executive dashboards in Power BI, Zoho Analytics, and Excel to monitor key KPIs.

🤖

AI-Assisted Productivity

Integrating AI tools for rapid data harmonization, SQL query structuring, and workflow automation to accelerate analytical output.

⚙️

Technical Foundation

Solid programming and systems background from IIT Bombay — Python, Java, C++, REST APIs, databases, and 300+ DSA problems solved.

Career Experience

Professional Experience

Delivering data-driven insights, automated reporting, and operational efficiency across business teams.

Business Analyst

Emoha Elder Care·Bangalore
December 2025 – Present
  • Analyze sales performance, lead conversion funnels, and revenue metrics across multiple business verticals to uncover growth trends and operational bottlenecks.
  • Design, build, and maintain automated MIS dashboards and reports using Advanced Excel, SQL, Zoho Analytics, and Power BI for real-time executive and operational monitoring.
  • Perform granular conversion rate and lead source attribution analysis to optimize marketing campaign spend and enhance sales team productivity.
  • Conduct in-depth Customer Lifetime Value (LTV) and cohort retention analysis across Business Units, regions, and campaigns to inform strategic customer acquisition and retention priorities.
  • Collaborate cross-functionally with Sales, HR, Finance, and Tech teams, delivering data-backed recommendations that improve business processes and daily workflows.
Tools:SQLAdvanced ExcelPower BIZoho AnalyticsPythonMIS ReportingLTV & Cohort AnalysisFunnel Analytics

Research Intern — Computer Vision

NCAIR·Mumbai
May 2024 – July 2024
  • Built real-time pose detection and tracking systems using YOLOv8, OpenCV, and deep learning algorithms.
  • Developed modular asynchronous data processing pipelines with batching and caching for high-throughput video feeds.
  • Integrated YOLOv8 and stereo-vision modules into an end-to-end pipeline, performing depth estimation and inference optimization on Linux.
Tools:PythonYOLOv8OpenCVNumPyStereo VisionLinuxData Pipelines
Featured Analytics Case Study

Customer Lifetime Value (LTV) & Retention Analysis

An end-to-end analytical study across customer segments, business units, and marketing channels that diagnosed retention patterns and reshaped field sales operations.

01 · The Problem⚠️

Lack of Systematic LTV & Retention Tracking

Customer Lifetime Value (LTV) was not being tracked systematically across customer touchpoints. Without a unified view of customer value and retention decay, business leadership lacked visibility into which acquisition channels delivered sustainable value versus high early drop-off.

02 · What I Did🔍

Multi-Segment Cohort & Lifecycle Modeling

Aggregated and modeled multi-source transactional, CRM, and campaign data using SQL, Advanced Excel, and Power BI. Sliced customer cohorts across Business Units, geographic regions, tier-wise cities, marketing acquisition campaigns, and product categories to map out cumulative revenue trajectories and churn inflection points.

03 · Key Insight💡

Retention as the Primary Growth Lever

Identified critical disparities in customer value across different channels and regions. Revealed that long-term customer retention — rather than purely top-of-funnel acquisition volume — was the primary determinant of overall customer lifetime value.

04 · Business Impact🎯

Reshaping Field BD & Account Prioritization

The analysis provided executive visibility into customer profitability and directly contributed to a new sales setup that restructured how Field Business Development teams prioritize high-value customer accounts and manage post-sales relationship touchpoints.

Tools & Techniques Used:
SQLAdvanced ExcelPower BIPythonCohort ModelingSegmentation
Skills & Toolkit

Technical Skill Set

Specialized in data analytics, business intelligence, and reporting automation, backed by a rigorous computer science foundation.

Primary Focus

Data & Analytics

Core analytical stack for querying, modeling, and executive dashboarding

SQLAdvanced ExcelPower BIPythonZoho AnalyticsData AnalysisDashboard DevelopmentMIS ReportingLTV AnalysisCohort RetentionA/B Testing
Business Acumen

Business & Strategy

Translating ambiguous operational questions into structured evidence and workflows

Business AnalysisBusiness Problem SolvingData-Driven Decision MakingProcess AnalysisReporting AutomationFunnel OptimizationSales Performance AnalysisKPI Definition
Technical Depth

Software & Engineering

Solid computer science and backend engineering foundation

JavaC++REST APIsGit & GitHubBackend DevelopmentDSAOOPPytest / Automated TestingFastAPI
Infrastructure

Databases & Tools

Data storage, transformation engines, and developer environment

MySQLPostgreSQLDuckDBSQLite (WAL)Power QueryLinuxDocker
Productivity & Automation

Practical AI & Workflow Automation

I leverage AI as a force multiplier for productivity — eliminating repetitive manual reporting, cleaning messy spreadsheets, and accelerating analysis without replacing rigorous critical thinking.

⚡Workflow Automation

Automating Repetitive Reporting

Automated routine MIS reports and daily metrics compilation using AI-assisted scripts, eliminating manual copy-pasting and repetitive workbook updating.

PythonExcel AutomationAI Scripting
📊Data Wrangling

Multi-Sheet Excel Consolidation

Used Microsoft Copilot and automated scripts to fetch, parse, and harmonize disparate data from multiple Excel workbooks into unified structured datasets for reporting.

CopilotAdvanced ExcelPower Query
🧹Analytics Productivity

Data Cleaning & Transformation

Leveraged generative AI to rapidly generate complex SQL queries, formulate regex patterns for messy CRM strings, and build exploratory visualization prototypes.

SQLPythonChatGPTPandas
⏱️Operational Efficiency

Hourly Operations & Tracking

Used AI tools to streamline high-frequency hourly operations reporting and format ad-hoc analytical summaries for rapid stakeholder decision-making.

ChatGPTMIS DashboardsExcel
🛠️Technical Acceleration

Code Debugging & Software Optimization

Utilized AI models to assist with code reviews, debug backend logic, scaffold automated tests with Pytest, and optimize SQL query execution plans.

PythonPytestGitAI Coding
💡Analytics Productivity

SQL Synthesis & Query Tuning

Employed LLM prompts to rapidly construct complex multi-table joins, window functions, and CTEs, accelerating ad-hoc data investigations and query tuning.

SQLWindow FunctionsCTEsLLM Prompting
Updated Oct 4, 2026

Latest News

A concise feed of technology, business, India, world and science developments I'm tracking. Every story links directly to its source.

TechnologyOct 3, 2026

AI investment race accelerates as companies chase new productivity gains

Massive spending on AI infrastructure is reshaping the technology economy, while analysts debate how quickly the investment can translate into durable productivity and revenue.

TechnologyOct 3, 2026

US appoints Jay Clayton to lead new AI task force

The administration has created a new task force focused on coordinating federal AI initiatives and assessing risks and opportunities around advanced AI.

BusinessOct 4, 2026

OPEC+ keeps November oil-production targets steady

OPEC+ agreed to keep November production targets unchanged, with the group signaling that larger policy adjustments are unlikely until later.

BusinessOct 4, 2026

Revolut reaches $115 billion valuation

The fintech has emerged as Europe's most valuable startup as it expands beyond foreign exchange into a broader financial-services model.

IndiaOct 4, 2026

India sees protests over election-roll revisions

Protests took place in Delhi and Mumbai over voter-roll changes; the Election Commission and BJP reject claims that the revisions are politically motivated.

IndiaOct 4, 2026

India completes Asian Games campaign in fourth place

India finished the 2026 Asian Games with 85 medals, including 21 golds, according to Indian Express reporting.

Indian ExpressRead source
WorldOct 4, 2026

Brazil votes in a closely watched presidential election

Brazilian voters went to the polls in the first round of a competitive election shaped by economic concerns, corruption allegations and foreign-policy debate.

WorldOct 4, 2026

Bosnia votes in election with EU membership in focus

Voters in Bosnia and Herzegovina are choosing representatives in an election closely watched for its implications for the country's European Union path.

WorldOct 4, 2026

Heavy rain and flooding hit Spain's Catalonia

Authorities reported two deaths and one person missing after heavy rains caused flooding across parts of Catalonia.

TechnologyOct 4, 2026

South Korea orders probe into financial-sector data leaks

President Lee Jae Myung ordered an investigation into recent personal-data leak incidents involving banks, financial companies and public agencies.

WorldOct 4, 2026

Germany pledges fresh military and energy support for Ukraine

German Chancellor Friedrich Merz announced additional military and energy-infrastructure support during a visit to Kyiv.

BusinessOct 2, 2026

US jobs report points to a softer labour market

September payroll growth came in below expectations, while unemployment rose to 4.2%, influencing expectations around the Federal Reserve's next rate decision.

News is for informational purposes. Sources retain their own reporting and publication dates.

Technical Portfolio

Featured Projects & Software Systems

Practical applications spanning analytics frameworks, modern data pipelines, automated backend systems, and AI tools.

Analytics & GrowthFeatured

SaaS Unit Economics & Churn Diagnosis Engine

A B2B SaaS financial modeling and churn diagnosis engine tracking MRR/ARR waterfalls, Net Revenue Retention (NRR), CAC payback, and triangular cohort retention decay.

💡 Key Concept:Cohort Retention Analysis: Groups customers by signup month and tracks their retention over time to see whether newer cohorts stay longer than older ones.
PythonPandasStreamlitPlotlyCohort Analysis+2
GitHub
Analytics & GrowthFeatured

Growth Funnel & A/B Experimentation Framework

An experimentation and growth analytics platform for multi-step e-commerce checkout funnel drop-off analysis, Two-Proportion Z-tests, Welch's T-tests, and statistical sample size planning.

💡 Key Concept:Statistical Hypothesis Testing: Determines with mathematical confidence whether a conversion difference between two user groups is a genuine improvement or random chance.
PythonSciPyStatsmodelsStreamlitPlotly+3
GitHub
Engineering & SystemsFeatured

Modern Data Stack (MDS) E-Commerce Pipeline

A dimensional data warehouse pipeline using Kimball star-schema modeling, modular staging/marts SQL transformations with DuckDB, automated schema quality tests, and rolling Z-score anomaly alerting.

💡 Key Concept:Dimensional Data Modeling (Star Schema): Organizes business data into 'facts' (measurable events like orders) and 'dimensions' (context like customers and products) for blazing-fast analytics queries.
DuckDBModular SQLPythonData QualityZ-Score Anomaly Detection+2
GitHub
Engineering & SystemsFeatured

Automated Flight Price Monitoring & Alert System

An automated price tracking engine that queries flight APIs, stores historical prices in MySQL, detects price drops using statistical baselines, and dispatches automated email alerts.

💡 Key Concept:Automated Polling & Alerting Pipeline: Continuously monitors external data streams, evaluates conditions against historical statistical baselines, and triggers proactive notifications.
PythonMySQLStreamlitPlotlySMTP+2
GitHub
Journey

Career Timeline

From engineering foundations at IIT Bombay to business analytics in high-growth operational environments.

2021

IIT Bombay

B.Tech — Metallurgical Engineering and Materials Science

2023

Leadership at Scale

Institute Indian Games Secretary · Marketing Manager

Led 36 conveners, managed institute events with 1,000+ participants, and coordinated marketing for the 56th Inter-IIT Sports Meet across 23 IITs.

2024

NCAIR Research Intern

Computer Vision · Deep Learning

Real-time pose detection with YOLOv8, stereo vision, and asynchronous data processing pipelines.

2025

IIT Bombay Graduation

Data Analytics · Backend Systems · Open-Source Projects

2025–Present

Business Analyst

Emoha Elder Care · Bangalore

Sales & revenue analytics, automated MIS dashboards, lead funnel optimization, and Customer Lifetime Value (LTV) cohort modeling.

Leadership & Initiative

Campus Leadership & Stakeholder Management

Leading cross-functional student teams, managing operations, and executing institute-scale events at IIT Bombay.

Institute Indian Games Secretary

IIT Bombay

April 2023 – March 2024
36
Conveners Led
10+
Events Organized
1,000+
Participants
IIT Bombay
Campus Leadership
  • Managed budget and operations for institute-wide athletic and sports events.
  • Organized 10+ events with 1,000+ participants and led a team of 36 student conveners.
  • Managed institute Kabaddi/Kho-Kho teams and spearheaded the formation of IIT Bombay's first girls' Kabaddi team.
  • Launched digital outreach initiatives including a YouTube channel reaching 13K+ views.

Marketing Manager

56th Inter-IIT Sports Meet

June 2023 – December 2023
2,500
Athletes
18K+
Footfall
23
IITs Coordinated
National
Inter-IIT Event
  • Led marketing and operational coordination for a national event hosting 2,500 athletes and 18,000+ footfall.
  • Coordinated cross-functional stakeholders across 23 IITs to ensure seamless execution.
Milestones

Academic & Professional Anchors

IIT Bombay

Graduate

B.Tech Class of 2025

98.03 %ile

JEE Mains

Top 2% Nationwide

95.3 %ile

JEE Advanced

Top Engineering Entrance

300+

DSA Solved

Algorithmic Problems

Excellence

Research Award

NCAIR

Open to Opportunities

Let's Connect & Build Together

I am actively exploring roles in Data Analytics, Business Analysis, Product Analytics, and BI / MIS.