Mano Ranjan Sahoo

E-commerce professional with 2+ years of experience in category operations, merchandising, and campaign execution at Flipkart Internet Private Limited. Skilled in driving GMV, improving AOV, and executing high-impact promotional strategies. Strong analytical mindset with hands-on experience in Excel, dashboards, and performance tracking. Proven ability to collaborate across teams to optimize category performance and customer experience.

Operations Executive - Flipkart Internet Private Limited - Bangalore

(2023-11)

• Executed and optimized promotional constructs such as Extra Saver, Re.1 deals, DOTD, and PBRO offers, contributing to improved attach rate and AOV growth.
• Managed end-to-end campaign readiness including assortment planning, deal activation, and inventory alignment for major events (BBD, Payday, Big Bachat Sale).
• Created and optimized category storefronts with structured collections (Top Picks, Value Packs, New Launches), improving CTR and conversion rates.
• Tracked and analyzed key metrics including GMV, AOV, CTR, and OPD to drive daily and campaign-level performance.
• Built and maintained dashboards using Google Sheets and Excel for performance monitoring and decision-making.
• Identified performance gaps and conducted RCA (Root Cause Analysis) to improve category outcomes.
• Monitored stock levels, DOH, and demand trends to ensure high in-stock availability during campaigns.
• Coordinated with planning and supply teams to raise POs and prevent stock-outs for high-demand SKUs.
• Worked closely with marketing, analytics, and finance teams to improve visibility, automate reporting, and enhance campaign execution.
• Supported execution of marketing initiatives such as push notifications, WhatsApp campaigns, and hoardings.
• Implemented new widgets on Grocery CLP, improving customer engagement and discoverability.
• Led onboarding and training new team members on reporting, merchandising checks, and execution workflows.
• Managed real-time deal execution and midday changes with high accuracy during live campaigns.

Reporting Analyst - Sri Sai Balaji Packers & Movers - Odisha

(2020-12 - 2023-09)

• Analyzed and processed large datasets to generate actionable insights for business operations
• Performed data cleaning, validation, and reporting using advanced Excel functions (VLOOKUP, Pivot Tables)
• Built dashboards and summary reports for tracking daily performance and operational efficiency
• Improved data accuracy and reporting consistency through structured validation processes
• Trained team members on reporting tools and data handling best practices

Graduation - Arts Hons. - Utkal University (2018)

Intermediate - Arts - Nimapada Autonomous College

High School - Nimapada High School