---
title: "Ansh Mattoo - Senior Data Analyst - Revenue Management in Commercial function. in Bengaluru East | Tal"
description: "Meet Ansh Mattoo, Serving Notice Period | Immediate Joiner | Strategy & Analytics @AirIndia, Senior Data Analyst | SQL · Python · Power BI · Databricks | Revenue & Business Analytics | Ex-Samsung(Cheil) based in Bengaluru East."
image: "https://tal.club/meet/ansh-6/share-image"
---

# Ansh Mattoo on Tal

## Headline

Serving Notice Period \| Immediate Joiner \| Strategy & Analytics @AirIndia, Senior Data Analyst \| SQL · Python · Power BI · Databricks \| Revenue & Business Analytics \| Ex\-Samsung\(Cheil\)

## About

Hi, I'm Ansh Mattoo, a data\-driven Data Analyst passionate about turning raw data into powerful business insights\. In my current role, I’ve: • I'm a Data Analyst with 1\.6\+ years of experience helping businesses make smarter decisions through data — whether that's optimizing revenue, improving campaign performance, or building dashboards that actually get used\. At Air India, I build data pipelines that process 10M\+ daily records, engineer revenue dashboards tracking 25\+ KPIs for leadership teams, and use pricing and inventory data to drive real business outcomes — including ₹12Mn\+ in quarterly revenue gains\. Before that, at Cheil India, I managed ₹4\.5Mn\+ in digital campaign budgets, used SQL and Power BI to improve funnel performance, and helped increase cart conversions by 26% without spending more\. I'm comfortable working across the full data stack — SQL, Python, Power BI, Tableau, and Databricks — and I can communicate findings clearly to both technical teams and business stakeholders\. Currently open to Data Analyst or Business Analyst roles \(0–3 years exp range\) where I can keep turning complex data into clear business wins\. Let's connect\! ✅ Skills: SQL \(Advanced\), Python \(OOP\), Tableau, Power BI, Adobe Analytics, Excel Automation, Social Media Analytics, Business Intelligence Reporting, MarTech, Aviation analytics, My mission? To unlock hidden opportunities from complex datasets and turn them into clear, data\-driven business wins\. Let's connect if you're looking for someone who can bridge the gap between data, marketing, and technology\!

## Location

Bengaluru East

## Work experience

Senior Data Analyst \- Revenue Management in Commercial function\. at Air India Limited, Feb 2026 \- Present · 5 mos, India, • Revenue data at Air India was fragmented across inventory, pricing, and codeshare systems — no single pipeline could process it reliably at scale\. Architected a production\-grade Databricks \+ Python solution processing 10M\+ daily records, cutting data processing time by 65% and giving the revenue team a live, trustworthy view of the business for the first time\. • Legacy SQL queries on 50M\+ transaction records were too slow for day\-to\-day analysis\. Rewrote and optimised the query and pipeline layer in Python \+ SQL, achieving 50% faster execution and enabling analysts to run ad\-hoc revenue analysis without waiting hours for results\. • The revenue data warehouse had no consistent structure — every report was built differently\. Implemented dimensional modelling standards and data modelling best practices that improved reporting accuracy by 35% and cut manual data preparation effort by 80%\. • Built comprehensive Power BI and Tableau dashboards tracking 25\+ KPIs — inventory utilisation, pricing elasticity, route profitability — now used by C\-suite executives for daily revenue decisions\. • Established CI/CD practices using Git/GitHub for automated dashboard monitoring and deployment, achieving 99\.5% uptime on critical reporting infrastructure serving senior leadership\. • Acted as the primary analytics liaison across Sales, Network Planning, Finance, and IT — translating business requirements into technical builds and ensuring every solution had real commercial relevance before going to production\.

Data Analyst\(Digital\) at Cheil India, Dec 2024 \- Jan 2026 · 1 yr 2 mos, India, • Managed and analysed ₹4\.5Mn\+ campaign budgets across multi\-channel digital campaigns, SQL\-based performance reporting, delivering 118\.4Mn impressions and an overall 9\.9% CTR/VTR, outperforming industry benchmarks \(2–3%\)\. • Unlocked 660 cart additions through Power BI\-driven insights and SQL\-backed funnel optimization, by improving top\-to\-mid funnel engagement \(₹3\.1Mn spend, 98\.6Mn impressions, 7% C2V\), impacting business conversions\. • Enhanced YouTube campaign ROI by realigning ₹1\.4 million spend, driving 54\.2% VTR, 62\.8K visits, and incremental conversions through high\-intent audience cohorts\. • Maximized retargeting ROI on the Display channel through precision spend of ₹11\.9K, contributing to 86\.1% C2V \(Click\-to\-Visit\), 9\.9K clicks, and 8\.5K site visits, demonstrating high campaign profitability\. • Collaborated with product and marketing teams to drive 26% higher cart adds \(660 ➝ 832\) in the Fold\-Flip cohort without increasing budget, strengthening ROAS, and lowering acquisition costs\. • Automated Sprinklr and Excel dashboards to track real\-time campaign KPIs, empowering cross\-functional teams with faster insights and cutting decision\-making time by 30%\.

## Education

Msc, Data science, SRMIST, Kattankulathur, Chennai ,Tamil Nadu

Bachelor's of Computer Application, Computer Science, University of Jammu

[View the original profile](https://tal.club/meet/ansh-6)

```json
{
  "@context": "https://schema.org",
  "@graph": [
    {
      "@type": "Person",
      "@id": "https://tal.club/meet/ansh-6#person",
      "name": "Ansh Mattoo",
      "url": "https://tal.club/meet/ansh-6",
      "image": "https://tal.club/meet/ansh-6/profile-photo.jpg",
      "description": "Meet Ansh Mattoo, Serving Notice Period | Immediate Joiner | Strategy & Analytics @AirIndia, Senior Data Analyst | SQL · Python · Power BI · Databricks | Revenue & Business Analytics | Ex-Samsung(Cheil) based in Bengaluru East.",
      "jobTitle": "Senior Data Analyst - Revenue Management in Commercial function.",
      "worksFor": {
        "@type": "Organization",
        "name": "Air India Limited"
      },
      "hasOccupation": {
        "@type": "Occupation",
        "name": "Senior Data Analyst - Revenue Management in Commercial function."
      },
      "homeLocation": {
        "@type": "Place",
        "name": "Bengaluru East"
      },
      "alumniOf": [
        {
          "@type": "EducationalOrganization",
          "name": "SRMIST, Kattankulathur, Chennai ,Tamil Nadu"
        },
        {
          "@type": "EducationalOrganization",
          "name": "University of Jammu"
        }
      ],
      "mainEntityOfPage": {
        "@id": "https://tal.club/meet/ansh-6#webpage"
      }
    },
    {
      "@type": "ProfilePage",
      "@id": "https://tal.club/meet/ansh-6#webpage",
      "url": "https://tal.club/meet/ansh-6",
      "name": "Ansh Mattoo on Tal",
      "description": "Meet Ansh Mattoo, Serving Notice Period | Immediate Joiner | Strategy & Analytics @AirIndia, Senior Data Analyst | SQL · Python · Power BI · Databricks | Revenue & Business Analytics | Ex-Samsung(Cheil) based in Bengaluru East.",
      "dateModified": "2026-07-18T10:54:53.235Z",
      "isPartOf": {
        "@id": "https://tal.club/#website"
      },
      "mainEntity": {
        "@id": "https://tal.club/meet/ansh-6#person"
      },
      "primaryImageOfPage": {
        "@type": "ImageObject",
        "url": "https://tal.club/meet/ansh-6/profile-photo.jpg",
        "contentUrl": "https://tal.club/meet/ansh-6/profile-photo.jpg",
        "caption": "Ansh Mattoo profile photo on Tal"
      },
      "inLanguage": "en-IN"
    }
  ]
}
```