Data Analyst → Business Analyst → Analytics Manager - Cars24 Services Pvt. Ltd.
(2021-10 - 2025-05)
Stakeholder & Business Analysis: Worked with C2B Pricing, Supply Chain, Procurement & Logistics, and Customer Care teams to gather requirements, define KPIs, and deliver analytics presented directly to senior leadership and C-suite.
- Wrote BRDs and FRDs for the CPI (Cost Per Inspection) tracker, Car Jockey Manager incentive platform, and car-level margin dashboard, covering business context, metrics, data sources, and acceptance criteria.
- Partnered with the PM pre-launch to define the problem statement, GA4 event tracking plan (slot selected, form step completed, booking confirmed), and success metrics before development began.
- Set up A/B test tracking and built a dashboard showing completion rate, drop-off, and Turn-Around Time (TAT) per variant, enabling data-backed ship/rollback decisions.
- Owned the CPI P&L view across zones, tracking gross and net cost per inspection by type (Car Jockey, Car Jockey Manager, Tele-caller) and zone to surface cost drivers for leadership.
- Built a multi-tab CPI dashboard with zone and process-level drill-down, replacing blended averages that were masking real performance gaps.
- Developed executive MIS reports, financial dashboards, and KPI scorecards to monitor revenue, profitability, sourcing costs, and operational efficiency for leadership decision-making.
- Performed financial forecasting, trend analysis, and scenario-based planning using historical performance and demand patterns to improve forecast accuracy.
- Conducted variance analysis between Budget, Forecast, and Actuals, identifying key revenue/cost drivers and recommending corrective actions.
- Redesigned the CJ incentive model by analyzing payout patterns and zone performance gaps; proposed tier structure was adopted across regions, improving field output.
- Built a dynamic incentive tracker with automated payout logic and email-triggered reports, reducing manual processing to near-zero and eliminating calculation errors.
- Managed Car Health Report (CHR) sales KPI tracking and reporting, monitoring ₹2.5+ Crore in collections.
- Automated the Competitor Pricing Dashboard (Apps Script), cutting reporting effort by 60%.
- Integrated Claude AI with Power BI via MCP to auto-generate DAX measures, achieving 70% faster measure creation.
- Automated C2B Salesforce workflow (Bangkok on-site), reducing manual entry by 40%.
Analytics Manager - Cars24 Services Pvt. Ltd.
(2025-07 - 2026-06)
Rejoined
Senior Data Analyst - FabHotels.com
(2019-10 - 2021-10)
Worked with Revenue Management, Cluster Ops, and Finance to build a transaction-level master data file — the single source of truth for company-wide reporting.
- Tracked booking funnel (listing, search, click, confirmation) and GA channel performance (sessions, bounce, conversion by source) at daily and weekly cadence; flagged drop-off points and channel ROI findings to product and revenue teams.
- Monitored non-funnel KPIs — revenue per property, occupancy rate, cluster health score, and agent conversion rate — delivered in MTD, weekly, and monthly cadence for 100+ properties.
- Built city-level occupancy and growth forecast models at 95% accuracy; automated weekly report distribution via R, saving 5+ hours per week.
- Developed and maintained Inside Sales agent-level performance dashboards to track productivity, call volume, conversion rates, adherence, and overall KPI achievement.
Data Analyst - Bharti Airtel Pvt. Ltd.
(2019-02 - 2019-10)
Collaborated with Product, Sales, Finance, and Merchant Operations to gather requirements and build SQL-based reporting solutions in Oracle and SQL Server, using self-joins, correlated subqueries, and CTEs across digital payments data.
- Built and distributed daily, weekly, and MTD transaction reports covering transaction count, average transaction value, wallet balance trends, and active user volumes for Finance and Ops.
- Reported product-level sales performance across Insurance (policies sold, premium collected), Recharge (prepaid top-up volumes), and Bill Payments (count, value, success rate), broken down by agent, region, and channel.
- Tracked merchant onboarding funnel (lead → KYC submitted → activated → first transaction) at weekly cadence; identified pipeline bottlenecks and reported conversion summaries to sales leadership.
- Surfaced customer behavioral patterns from payments transaction data — frequency, preferred categories, UPI drop-off — used by the product team for feature prioritization.
Senior MIS Executive - ANI Technologies Pvt. Ltd. (Ola Cabs)
(2015-02 - 2019-02)
Prepared daily, weekly, and monthly MIS reports for management, tracking trips, revenue, and cab utilization across cities and cab categories.
- Monitored acceptance rate and driver performance metrics, and prepared incentive and scheme performance reports for field teams.
- Created End-of-Day (EOD) reports for management and maintained operational data accuracy in Excel before stakeholder distribution.
- Performed ad-hoc analysis based on business requirements, comparing performance across cities, teams, and cab categories to identify gaps and share insights with management.
