Ansh Mattoo

Business Analyst

Hyderabad, Telangana, India1 yr 3 mos experience
AI EnabledAI ML Practitioner

Key Highlights

  • Achieved 9.9% CTR, outperforming industry benchmarks.
  • Drove 26% increase in cart additions through optimization.
  • Automated dashboards, reducing decision-making time by 30%.
Stackforce AI infers this person is a Data Analyst specializing in MarTech and Business Intelligence.

Contact

Skills

Core Skills

Data AnalysisBusiness IntelligenceMarketing Analytics

Other Skills

A/B TestingAdobe AnalyticsAdvanced Excel (VLOOKUP, Pivot, Macros)Artificial Intelligence (AI)Big DataBusiness AnalyticsBusiness Intelligence (BI)Business Intelligence ReportingBusiness MetricsBusiness StrategyClient CommunicationCommunicationCustomer Relationship Management (CRM)DCLDDL

Experience

Cheil india

Data Analyst

Dec 2024Present · 1 yr 3 mos · India · On-site

  • 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%.
SQLPower BIPythonAdobe AnalyticsExcel AutomationBusiness Intelligence Reporting+2

Education

SRMIST, Kattankulathur, Chennai ,Tamil Nadu

Msc — Data science

Jul 2023Apr 2025

University of Jammu

Bachelor's of Computer Application — Computer Science

Aug 2019Aug 2022

Stackforce found 100+ more professionals with Data Analysis & Business Intelligence

Explore similar profiles based on matching skills and experience