Rohit Kumar

Analyst — Business Analytics

Bengaluru, India 2+ yrs exp 88 · Excellent

About

Analyst with 3 years analysing customer funnel, traffic, and pricing data to support merchandising and growth decisions, across 3 global e-commerce and D2C engagements at Synaptic. Builds data dashboards and applies SQL and Excel-based analysis to identify pricing and discounting opportunities. Working knowledge of SQL, Excel, Power BI, and GA4. PGDM in Business Administration from MDI.

Skills & Expertise (12)

Google Analytics 4 Intermediate

8.0/10

Years Exp

Power BI Intermediate

7.5/10

Years Exp

Looker Studio Intermediate

7.5/10

Years Exp

Core SQL Intermediate

7.0/10

Years Exp

Python Intermediate

7.0/10

Years Exp

Cross-Functional Collaboration Intermediate

7.0/10

Years Exp

stakeholder communication Intermediate

7.0/10

Years Exp

Google Cloud Platform Intermediate

6.5/10

Years Exp

ROAS SEM Advanced Excel BigQuery

Work Experience

Analyst I

Synaptic

Jul 2024 - Apr 2026

Worked with business stakeholders to understand customer behaviour and pricing priorities, scoping analysis before any work began. Queried and validated traffic, pricing, and category data in Google Cloud Platform (BigQuery) for consistency issues before it fed any dashboard or analysis. Conducted various analyses including Customer Funnel Analysis, Pricing & Discounting Analysis, Campaign & Marketing Analytics, and Category Trend Analysis. Collaborated cross-functionally with category, finance, and analytics stakeholders to align pricing and traffic-growth recommendations with business priorities. Built data dashboards in Power BI and Looker Studio tracking traffic, conversion, and pricing performance for stakeholders. Automated repetitive reporting tasks in Python, reducing manual effort on recurring reviews.

Summer Intern

ICICI Bank

May 2023 - Jun 2023

Analysed branch-level transaction patterns and product uptake trends, then compiled the findings into a structured report for the operations and relationship teams. Shadowed relationship managers and documented observations on client workflows and reporting processes.

Associate Data Analyst

PAL Marble

Jul 2021 - Jun 2022

Pulled sales numbers in Excel, spotted pricing gaps, and flagged revenue leakage to the dealer network team. Built recurring MIS reports for finance and operations that lifted reporting accuracy by around 35%.