E-commerce Sales MIS: Amazon & Flipkart

Built a reusable MIS that merges Amazon and Flipkart seller reports. Cleaned and mapped SKUs, then built pivots, an Excel SKU report (SUMIFS, data bars, return-rate flags) and a dashboard for net sales, channel mix, AOV and returns. It surfaced the top SKU, the best week and high-return products like Cotton T-Shirt (9.2%). Replaces manual consolidation with one refreshable format. (Sample data.) Skills: Data Analysis, Dashboard Design, KPI Reporting Tools: Microsoft Excel, Pivot Tables, Google Sheets