Sumit Singh

About Sumit Singh

Data Analyst with significant experience developing ETL solutions, analyzing & …

Experience

1. Data Analyst

   Bm2k Global Enterprises Pvt. Ltd

   Jan 2025 — Present · Noida, IN

   Data Analyst | BM2K Global (Subway US Account)At BM2K Global, I support 162 Subway stores in the U.S, working with internal teams and third-party partners such as DoorDash, Uber Eats, ezCater, Grubhub, and Adyen. I use SQL and Excel to transform data into strategic insights that improve operations, financial accuracy, and menu performance.Key Responsibilities & Contributions:Chargeback Analysis: Prepare and analyze monthly scorecards from Adyen, identifying dispute patterns and supporting resolution efforts.Sales Reconciliation: Reconcile daily and monthly sales across banks and third-party platforms, ensuring alignment for over $2M+ in monthly revenue.Performance Scorecards: Design actionable scorecards for 10+ Area Coaches to track store KPIs and support coaching decisions.Inventory Reporting: Develop inventory usage reports to identify waste trends and optimize ordering practices across all locations.Menu Strategy Support: Prepare data-driven recommendations and insights to guide menu strategy decisions, including pricing, product availability, and third-party listing optimization.Tools Used: SQL for data extraction and analysis; Excel for reporting, dashboards, and reconciliation models.My work ensures that Subway’s franchise network operates efficiently, remains financially accurate, and is guided by smart, data-backed strategy.