Quick Commerce Profitability Optimizer
Budget: ₹12,500 – ₹37,500 INR
Quick Commerce Profitability Optimizer | Data Analyst | GitHub
• Analyzed end-to-end order and payment data for a quick-commerce business to identify revenue leakages and low-margin orders, creating a clear AR-style view of billings, collections, and adjustments across cities.
• Reconciled invoice value vs. realized cash per order (after discounts, delivery fees, and rebates), flagging unprofitable transactions and proposing minimum basket-value thresholds and revised fee structures to protect approximately ₹4.22M in at-risk revenue annually.
• Designed city-level performance dashboards in Excel/BI tools to track aging of unprofitable orders, highlight unapplied/under-recovered charges, and support month-end reporting and decision-making for internal stakeholders.
• Analyzed end-to-end order and payment data for a quick-commerce business to identify revenue leakages and low-margin orders, creating a clear AR-style view of billings, collections, and adjustments across cities.
• Reconciled invoice value vs. realized cash per order (after discounts, delivery fees, and rebates), flagging unprofitable transactions and proposing minimum basket-value thresholds and revised fee structures to protect approximately ₹4.22M in at-risk revenue annually.
• Designed city-level performance dashboards in Excel/BI tools to track aging of unprofitable orders, highlight unapplied/under-recovered charges, and support month-end reporting and decision-making for internal stakeholders.