Summary
Overview
Work History
Education
Skills
Timeline
Generic

Swarnima Rastogi

New Delhi

Summary

Passionate Data Analyst with 10+ years of cross-functional experience in data analysis, business operations, merchandising, and e-commerce. Skilled in transforming raw data into actionable insights through SQL (joins, subqueries, window functions), advanced Excel automation, and data visualization using Tableau and Power BI. Proven track record of delivering KPI dashboards, cost analysis, forecasting models, and process optimizations that support strategic decision-making across retail, supply chain, and export sectors. Experienced in MIS reporting, stakeholder communication, and cross-functional collaboration, with hands-on involvement in requirement gathering, technical documentation, and mentoring small data teams. Adept at simplifying complex datasets to drive clarity, alignment, and results for business leaders. Actively seeking to contribute to a data-driven, growth-oriented team while continuing to evolve as a business-savvy data analyst.

Overview

13
13
years of professional experience

Work History

Data Analyst – Reporting Merchandiser & E-commerce

Fabindia Pvt Ltd
05.2021 - 10.2024
  • Developed and maintained interactive Tableau dashboards to visualize key performance indicators such as sell-through rates, vendor lead times, and catalog engagement metrics, enabling faster business decisions and cross-functional reporting.
  • Queried and analyzed large datasets using SQL (PostgreSQL/MySQL) to identify bottlenecks in order processing; implemented insights that led to an 18% reduction in operational delays.
  • Built and managed KPI trackers (PPC performance, web metrics, vendor SLAs, production cycle) using SQL for data extraction and Excel for dynamic reporting, supporting 120+ SKUs and improving compliance tracking.
  • Performed customer behavior analysis on B2B transactional data using SQL and Excel, generating actionable category-level insights that influenced assortment strategy on the CASA portal.
  • Partnered with marketing and operations teams to develop Excel-based financial models for price sensitivity, markdown optimization, and regional performance analysis—helping guide pricing and promotion strategies.
  • Redesigned legacy product cataloging workflows by implementing automated Excel templates with VLOOKUP, data validation, and macros, resulting in a 35% increase in accuracy of product uploads for third-party franchisees.
  • Automated weekly and monthly reporting processes using advanced Excel functions (Pivot Tables, VLOOKUP, INDEX-MATCH) and integrated SQL-based data pipelines, cutting manual reporting time by 60%.

Reporting Merchandiser

William E Connor & Associates
02.2019 - 06.2020
  • Collaborated with cross-functional stakeholders (sourcing, operations, vendors, and clients) to gather reporting requirements and translate them into structured data solutions, improving delivery visibility across teams.
  • Designed and automated Excel dashboards integrated with SQL queries to track KPIs like vendor SLA compliance, sample approval rates, and production exceptions — reducing manual reporting time by 60%.
  • Led stakeholder communications across sampling, production, and shipment functions by delivering weekly data insights, sharing root cause reports, and supporting decision-making with structured, data-backed presentations.
  • Wrote technical documentation for reporting processes, SQL logic, and tracker workflows, ensuring consistency and easy knowledge transfer across teams and future analysts.
  • Extracted and transformed large datasets using SQL (JOINs, CTEs, aggregations) from MIS, EDI, and Supplier Connect platforms to build consolidated production and order management reports — resulting in 18% faster exception resolution.
  • Created costing analysis models and pricing trackers used in vendor negotiations; enabled margin visibility and reduced pricing discrepancies by 30%, directly supporting the finance and procurement teams.
  • Improved data accuracy by 35% in internal product upload workflows by redesigning Excel tools using data validation, lookup logic, and standardized input fields.
  • Reduced shipment delays by 20% through SQL-based forecasting models that flagged orders at risk of missing deadlines based on historical delivery trends.

Reporting Merchandiser

Royal Exports Pvt. Ltd.
12.2017 - 09.2018
  • Managed data-driven product lifecycle tracking for 100+ SKUs across fashion categories, using SQL (joins, subqueries, window functions) and Excel automation to track development timelines, costing, vendor performance, and on-time delivery for key retail clients like H&M and Future Group.
  • Designed and maintained interactive dashboards in Tableau, Power BI, and Excel (Pivot Charts, Slicers, Conditional Formatting) to visualize sample status, production readiness, vendor SLA metrics, and pricing variance - enabling faster decision-making across teams.
  • Collaborated with international vendors and cross-functional teams (design, sourcing, production) to create real-time trackers for sampling stages (Fit, Strike-Offs, PP, Photoshoot), reducing turnaround delays by 25% through improved visibility and exception flagging.
  • Developed margin analysis and costing models by extracting BOM and pricing data via SQL from MIS/ERP systems; created scenario-based tools in Excel to support product pricing, vendor negotiations, and cost optimization efforts.
  • Built structured product catalogs and upload templates in Excel using macros, data validation, INDEX-MATCH, and conditional formatting, reducing upload errors by 35% and ensuring consistent metadata for analytics and listing.
  • Created visual trend analysis reports combining internal product performance and external market insights, helping the design and buying teams align assortments with consumer behavior and seasonal forecasts.
  • Led a small team of 2 junior analysts, overseeing data extraction tasks, SQL query reviews, and Excel-based reporting, while upskilling the team on visualization best practices and dashboard storytelling.
  • Owned MIS reporting for product readiness, costing, and production timelines, delivering actionable insights to senior leadership through weekly performance dashboards and data packs - increasing visibility across departments and aiding roadmap planning.

Merchandiser

SGGN Exports Pvt. Ltd.
03.2015 - 05.2017
  • Supported data-driven decision-making for e-commerce sales by tracking SKU-level performance, pricing trends, and online customer behavior using Excel reports and product data analysis.
  • Created and managed product catalogs for online platforms, utilizing structured Excel templates and product metadata to ensure consistency and speed in uploads.
  • Coordinated with marketing and production teams, maintaining production trackers and delivery logs to monitor sampling cycle efficiency and stock availability for U.S. markets.

Merchandiser

MLK Exports Pvt. Ltd.
04.2012 - 08.2014
  • Used ERP systems to manage product lifecycle data, including style creation, BOMs, and production timelines; ensured accurate data entry and reporting for cross-functional planning.
  • Built Excel-based costing and approval trackers, automating calculations and reducing manual errors in sample development and budget estimation workflows.
  • Monitored T&A (Time & Action) plans through production databases and internal dashboards, identifying deviations and flagging delays through exception reporting.

Education

Master's Degree - Fashion Retail Management

NIFT Bangalore
Bangalore, India
10.2018

Bachelor's Degree - Fashion Design & Technology

Amity University
Lucknow, India
12.2012

Skills

  • SQL
  • Power BI
  • Tableau
  • KPI Dashboards
  • Advanced Excel
  • JIRA
  • SAP MM
  • ERP
  • MIS
  • Data Cleaning
  • Data Visualization
  • Strategic Merchandising
  • Data analysis
  • Strategic planning
  • Database management
  • Statistical analysis

Timeline

Data Analyst – Reporting Merchandiser & E-commerce

Fabindia Pvt Ltd
05.2021 - 10.2024

Reporting Merchandiser

William E Connor & Associates
02.2019 - 06.2020

Reporting Merchandiser

Royal Exports Pvt. Ltd.
12.2017 - 09.2018

Merchandiser

SGGN Exports Pvt. Ltd.
03.2015 - 05.2017

Merchandiser

MLK Exports Pvt. Ltd.
04.2012 - 08.2014

Master's Degree - Fashion Retail Management

NIFT Bangalore

Bachelor's Degree - Fashion Design & Technology

Amity University

Similar Profiles

  • Swarnima Rastogi

    Swarnima RastogiSwarnima Rastogi

    Production Merchandiser at Fabindia Pvt LtdProduction Merchandiser at Fabindia Pvt Ltd

  • Ajith Kumar V

    Ajith Kumar VAjith Kumar V

    Customer Relationship Executive & VM at Fabindia Pvt Ltd.Customer Relationship Executive & VM at Fabindia Pvt Ltd.

  • Rudna Sabherwal

    Rudna SabherwalRudna Sabherwal

    Senior Merchandiser/ Store In charge for British clothesline by the name of EAST at Fabindia Overseas Pvt LtdSenior Merchandiser/ Store In charge for British clothesline by the name of EAST at Fabindia Overseas Pvt Ltd

  • Kiran Malhotra

    Kiran MalhotraKiran Malhotra

    Manager Sales (B2B Sales – US Process) at RASA GROUPManager Sales (B2B Sales – US Process) at RASA GROUP

  • ANJALI SINGH

    ANJALI SINGHANJALI SINGH

    Admin at Kotak Mahindra BankAdmin at Kotak Mahindra Bank

CREATE PROFILE
Swarnima Rastogi