1. Discount Rule Validation:
- Validated system-configured rules against requests from BM, identifying critical discrepancies.
- Conducted post-launch validation of Nykaa-funded and brand-funded promotional rules to ensure discount integrity.
- Validated ~1,000 rules monthly across 500,000 orders. Representing 10 crores in revenue.
- Performed monthly reconciliation between brand-funded discounts and vendor recovery to ensure financial accuracy.
2. Commission and Margin assurance:
- Executed end-to-end validation of agreement components (commission, margin, shipping, late fees, marketing) between the system and legal for all vendors.
- Conducted monthly audits through 3-way reconciliation across VPS, Legal, and Payout platforms to ensure financial integrity.
- Implemented an automated stakeholder notification system for margin changes, accompanied by detailed audit trails.
- Led a comprehensive one-time cleanup of 80% of vendors, reconciling system data against legal documentation, and escalating discrepancies to business leaders.
3. Billing validation:
- Evaluated sample transactions against 15 critical criteria including High Value Orders, significant discounts, zero-bill orders, return patterns, etc. to detect anomalies.
- Developed targeted sampling methodology to maximize coverage of potential revenue leakage points across the transaction lifecycle.
- Conducted thorough checks on billing components to ensure accuracy without variances.
- Executed 3-way reconciliations between vendor-posted payments, invoices, and GRN/POs to ensure transaction accuracy.
- Verified alignment across vendor invoices, debit notes, and RTV notes to prevent financial discrepancies.
- Monitored order-to-cash cycle integrity through cross-system validation between technical platforms and ERP.
- Produced quarterly valuation reports for COGS and inventory, identifying potential adjustments, and financial impacts.
Key achievements :
- Identified 8 incorrectly configured promotional rules using PACA methodology, preventing 35 lakhs in potential losses.
- Rectified margin configurations for 15 new brands, contributing to a projected revenue of approximately 4 Cr.
- Discovered a systematic shipping fee discrepancy in mixed international and domestic orders, recovering 40 lacs in unbilled revenue.
- Eliminated duplicate refunds for same cancellation requests, preventing losses of 6 lacs.