
A competent professional experience in E-commerce domain, with skills in supply chain & demand planning management, sales and marketing & Vendor management practices.
Program Management
Problem solving
MS office
Process Analysis
Business Intelligence
Operation efficiency
Selection:
‣ Scaled up diverse workstreams including onboarding over 30+ vendors (Direct Fulfillment + Fulfillment Center) in the Beauty and Luxury Beauty segment during FY'23, overseeing the entire process from commercial close to successful business establishment at Amazon; consistently outperformed BA goals by +3.68% (Q2), +5.56% (Q3), and +6.89% (Q4).
‣ Enhanced FTAC (Fast Tracking ASIN Count) efficiency by coaching vendors to optimize advertising investments and secure compelling promotional offers on targeted products, driving sustained improvements in conversion and FTAC performance. Achieved FTAC performance above OP2 by +4.02% (Q2), +3.61% (Q3), and +4.86% (Q4), while maintaining performance within 1.39% (Q2), 0.94% (Q3), and exceeding by 0.76% (Q4) against IOP targets.
‣ Negotiated vendor transitions effectively between Direct Fulfillment (DF) and Fulfillment Center (FC) models, including onboarding new vendors and converting existing ones between DF and FC, ensuring seamless operational execution and business scalability. Successfully managed transitions 3.1k products in Q2, 4.1K in Q3, and 4.8K in Q4, driving supply chain efficiency and sustained business growth.
Image Competitor Pricing Compliance (ICPC%)
Developed a Power BI dashboard to monitor Image Competitor Pricing Compliance (ICPC%) across brands and ASINs using daily competitor pricing feeds, enabling rapid identification of pricing gaps, analysis of Glance View (GV) impact, and data-driven price matching decisions based on profitability, inventory, and competitive benchmarks.
P&L:
• Presented vendor-level Month-To-Date (MTD) and Estimated-To-Date (ETD) Profit & Loss (P&L) and CCOGS for the Luxury Beauty segment, providing financial visibility across the portfolio and consistently delivering ETD/MTD P&L performance of +1.0% (100 bps) versus OP2 and +0.2% (20 bps) versus IOP.
• Identified vendor-level P&L gaps through detailed cause-and-effect analysis, partnering with Account Managers to develop data-driven recovery plans that accelerated vendors' path to profitability and improved overall portfolio health.
• Designed and managed an automated dilution tracker updated twice daily for top products, enabling proactive burn-rate monitoring and recovering more than 1.5% (150 bps) of P&L through timely corrective actions and profitability interventions.
• Automated daily dilution and MTD P&L reporting processes, improving team productivity by approximately 2–3 hours per day while enhancing reporting accuracy and decision-making speed.
• Monitored vendor-level Average Selling Price (ASP) trends, proactively identifying pricing declines and escalating risks to Account Managers, helping protect margins and maintain profitability targets across key vendors.
Automation:
• Developed and implemented automated workflows using Python and Power Automate to distribute detailed sales, inventory, and input metric reports to 40+ vendors, eliminating manual reporting efforts and saving 2–3 hours daily (~15 hours per week) while improving accuracy and consistency in vendor communications.
• Automated the generation of custom vendor-level input and output metric reports for internal Weekly Business Reviews (WBRs), reducing report preparation time by over 85% by automating metric data preparation, saving individual metric owners approximately 1–2 hours per reporting cycle and enabling faster, data-driven business decisions.
• Created VBA Macros in Excel to automate repetitive operational and analytical tasks, including extracting basic business details and streamlining recurring processes, saving approximately 2–3 hours per task depending on work complexity while minimizing manual effort and reporting errors.
• Designed and maintained an automated daily dilution tracker for P&L analysis, providing near real-time profitability insights to Account Managers, enabling recovery of over 1.5% (150 bps) in P&L through proactive corrective actions and pricing interventions.
Amazon Now channel Assortment Optimization:
• Designed and implemented a data-driven assortment optimization framework for the Amazon Now channel, leveraging McKinsey's Analytical Assortment Optimization methodology, Bain's SKU rationalization principles, and a custom 9-box ABC-XYZ model. Built a scalable decision engine to evaluate SKU productivity across sales, profitability, inventory health, fill rate, demand variability, and competitive coverage metrics, enabling informed assortment decisions across thousands of products.
• Developed an automated SKU classification and risk-scoring model that assessed products based on contribution (ABC), demand stability (XYZ), inventory health (DOH), margin performance, fill rate, and category coverage gaps. Created recommendation logic to identify SKUs for retention, expansion, delisting, replacement, or watchlisting, helping optimize assortment productivity while balancing selection, profitability, and inventory efficiency.
>Travelling
>Watching scifi movies/Tv series