Sunil Chauhan

Experience

1. Deputy Manager (Category Commercial & Margin Analyst)

   More Retail Private Limited

   Oct 2024 — Present · Mumbai, IN

   Prepare monthly margin MIS dashboard ( Supermarket and Hypermarket) that displays category wise performance to make informed decision about the pricing, inventory management and costing.2. Prepare and upload the margin related provision entry in the books.3. Validation of DN working pertaining to Promo recovery, off-invoice, APMC, Visibility and listing and share it with AR team to raise the debit notes on monthly basis to ensure timely collection and adjustment with the outstanding amount.4. Prepare the accrued income schedule on monthly basis to ensure accurate financial reporting.5. Prepare the quarterly margin schedule to share with auditors to ensure timely closure of audit.6. Reconcilation of books vs MIS on monthly basis and resolve the discrepancy (if any).7. Validate and compile the data to upload TCI at location-item in Redshift for all the stores and institutional locations to review the performance at item and region wise. Prepare the channel wise margin splits (online, offline and omni) that displays the margins earned by a buisness through different channel to review the performance and make informed decision about profitability, Supply chain efficiency and customer experience.9. SOP audit - Store visit to conduct the SOP audit (Visibility execution at end caps and side-caps, SEL, pricing talkers, Plano and inventory management, Shrinkage posting, Near expiry stocks self execution, cash til and back office management etc.)

Education

• Punjab Universty

  Bachelor in Commerce from Punjab University, Chandigarh., Commerce.

  2008 — 2011