Sunny Mashih

Assistant Manager – Business Analytics

PAYTM PAYMENTS SERVICES LIMITED (PPSL)

Feb 2023 - Apr 2026

Owned end-to-end analytics for 70L+ merchant QR and EDC network, tracking onboarding TAT, bind rate, transaction velocity, and revenue contribution at regional and national level. Wrote complex SQL queries using CTEs, Window Functions (RANK, ROW_NUMBER), Multi-table Joins and Subqueries in Starburst, MySQL and BigQuery to extract and transform millions of merchant transaction records for sales, onboarding, and revenue reporting. Built reusable SQL query templates and views in Starburst, MySQL and BigQuery used by the MIS team for daily merchant onboarding tracking, activation reporting, and sales transaction trend analysis — also optimized slow-running queries, improving dashboard data refresh speed by 40%. Developed 15+ Power BI and Looker Dashboards with custom DAX measures and Row-Level Security (RLS) to track KPIs such as Sales reports, FTD/MTD revenue, MoM growth, merchant bind rate, and onboarding TAT, reducing manual reporting effort by 50%. Applied data warehousing concepts and data modeling techniques to build scalable reporting solutions, standardize KPIs, and improve data consistency, enabling reliable enterprise-level Power BI reporting. Designed interactive sales dashboards using Power BI, Excel, and Google Data Studio, improving leadership visibility into revenue, product performance, and operational KPIs. Built customer analytics models including Cohort, CLV, CAC, and RFM analysis, improving retention campaign performance and increasing customer retention by 15%. Conducted structured competitive pricing analysis across 10+ e-commerce competitors in the German Indian grocery market: comparing 500–1,000 SKUs and building dynamic pricing comparison reports in Excel, supporting category managers in setting optimal price and driving 20% MoM revenue growth for Germany's #1 Indian grocery brand. Delivered Sales Forecasting and Trend Analysis models to enhance revenue predictability and support data-driven procurement planning. Collaborated with Customer Support to analyze product issue trends, reducing repeat complaints by 3% and contributing to improved customer ratings, helping the company achieve strong market positioning in Germany. Built inventory health tracker in Excel monitoring stock ageing, near-expiry risk, and replenishment cycles reducing stock-out incidents and minimizing wastage losses through data-driven procurement planning.

Data Analyst

JAMOONA.COM

Jun 2020 - Jan 2023

Prepared Daily, Weekly, and Monthly performance reports (WTD, MTD, YTD) to support leadership reviews and operational decision-making. Conducted outlet-level sales reconciliation across Cash, Card, Paytm, PhonePe, Pine Labs, and BijliPay to identify and resolve variance discrepancies. Automated outlet-wise variance reporting, enabling each outlet to receive its specific wastage and variance reports on a weekly and monthly basis, reducing report preparation time from 2–3 hours to just 20–30 minutes. Developed analytical reports including discount analysis, growth & productivity tracking, Pareto analysis, and AOP performance reports to monitor business performance. Coordinated with the Asset Team for daily updates and operational alignment through structured reporting and communication. Integrated multi-source data pipelines supporting 50+ daily reports. Tracked multi-branch lead-to-conversion funnel, delivering Daily, weekly and monthly performance MIS for 3+ branch locations. Consolidated branch-level sales data into unified dashboards, improving management reporting speed by 40%. Coordinated with branch teams to ensure smooth day-to-day operations and reporting alignment.

MIS Analyst

BIRYANI BLUES – THEA KITCHEN PVT. LTD.

Nov 2018 - May 2020

Recognized for improving retail sales reporting efficiency by 30%. Awarded for leadership in data management and stakeholder collaboration.

MIS Executive

MEDHALOGY COACHING PVT. LTD

Aug 2017 - Nov 2018