Sujeet Kumar

Senior Business Analyst with 11+ years of experience across mobility, automotive, fintech, and hospitality. I enjoy turning messy business problems into clear decisions - designing KPI frameworks, tracking product performance with GA4 and custom events, running A/B tests, and writing BRDs that reflect what the business actually needs. Comfortable moving between stakeholder conversations, funnel deep-dives, and SQL in the same afternoon.

Recently using AI tools to speed up analytics workflows and cut time-to-insight on complex requests.

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.

MBA - Information Technology - Swami Vivekanand Subharti University

B.A. - Economics & Political Science - Swami Vivekanand Subharti University