The Client
[cite_start]The client is a high-velocity Quick Commerce leader operating in a landscape of immense transactional complexity[cite: 181]. [cite_start]With millions of orders processed daily, managing payment integrity across diverse networks like Visa, Mastercard, RuPay, and Amex is a critical pillar for maintaining bottom-line health[cite: 187, 197].
The Business Need
[cite_start]In high-volume businesses, payments often leak silently[cite: 227]. [cite_start]The client faced a "Black Box" challenge where accepting settlement reports as truth led to compounded variances[cite: 226].
The Challenge
[cite_start]Manual reconciliation processes struggled with a T+30 delay, leaving the organization reactive rather than proactive[cite: 194].
-
[cite_start]
- Network Overcharges: Unauthorized MDR hikes of +0.12% during peak hours led to ₹74 Lakhs in leakage over just 2 months [cite: 253-254]. [cite_start]
- Compliance Risks: Systematic undercharging on RuPay transactions created ₹0.63 Cr in hidden retroactive liability [cite: 188-190, 266]. [cite_start]
- Data Fragmentation: Managing inconsistent inputs ranging from RuPay’s 18 columns to Amex’s 40+ column reports[cite: 292].
The Solution
[cite_start]We implemented an automated BI framework designed to transform chaotic transaction data into a unified financial language[cite: 181, 281].
Phase 1: Python Data Normalization
[cite_start]We developed a Python-based engine to handle high-velocity ingestion and standardization[cite: 289]:
-
[cite_start]
- Dynamic Mapping: Automatically detecting card types and mapping Merchant Discount Rate (MDR) slabs in real-time[cite: 290]. [cite_start]
- Unified Language: Normalizing fragmented files from multiple networks into a single, standardized output[cite: 292]. [cite_start]
- Validation Logic: Comparing expected MDR against actual MDR to identify Basis Point (BPS) variances[cite: 293].
Phase 2: Power BI "Decision System"
[cite_start]A real-time dashboard provided finance ops with actionable intelligence to manage payments as a business unit[cite: 194, 358].
-
[cite_start]
- T+1 Velocity: Accelerated reconciliation from month-long delays to next-day visibility[cite: 192, 194]. [cite_start]
- Variance Control: A routing feedback loop that identified late-night Amex surcharge spikes and corrected routing rules immediately [cite: 314, 334-342]. [cite_start]
- Network Summaries: prioritized intervention through net-variance tracking across all card networks[cite: 298].
Value Delivered
[cite_start]Automating the invisible protected the bottom line and transformed payment reconciliation into a revenue recovery engine[cite: 195, 360, 366].