Sumagna Nanda

CLIENT – Flipkart & Myntra

• Served as Agile Business Analyst and Scrum Master for Flipkart’s Accounting MEC project and Oracle Fusion integration for Myntra, ensuring adherence to Agile Delivery and Scrum frameworks.
• Managed a cross-functional team of six Data Analysts and Data Engineers, delivering 140+ reports with on-time completion and strict SLA compliance.
• Performed requirements elicitation, prepared Business Requirement Documents (BRDs), and created detailed User Stories with Acceptance Criteria aligned to the Definition of Ready (DoR).
• Conducted and facilitated all Agile ceremonies—daily scrums, sprint planning, refinement, reviews, and retrospectives—to drive continuous improvement and sprint efficiency.
• Utilized Jira for backlog management, epic tracking, sprint analytics, and burn-down/burn-up chart monitoring.
• Designed and optimized SQL-based validation frameworks using CTEs, sub-queries, and data flow diagrams (DFDs) to enhance data quality checks, minimize data loss, and optimize performance.
• Collaborated with 10+ stakeholders across Tech, Product, and Finance to define functional and non-functional requirements, manage dependencies, and ensure complete traceability through the SDLC.
• Partnered with Solution Architects to validate integration logic and ensure seamless system interaction and 100% integration success.
• Developed and maintained API documentation and Confluence project documentation to ensure effective knowledge transfer and version control.
• Leveraged Tableau, MS Excel, and Metabase for KPI tracking, reporting, and data visualization, improving transparency and business decision-making.
• Collaborated with end users to review Functional Specification Documents (FSDs), ensuring 100% UAT coverage and successful deployment.
• Contributed to data governance enhancements, ensuring regulatory compliance, data safety, and alignment with organizational standards.

• Led a cross-functional Agile team of three Data Analysts, leveraging Scrum methodologies to deliver data-driven insights from market research data, enabling data-backed decision-making for Marketing and NPD teams and improving reporting turnaround by 15%.
• Developed and maintained cross-channel KPI dashboards using SQL and Tableau, translating complex business requirements into actionable insights that improved customer engagement metrics by 8% and provided real-time visibility to leadership.
• Partnered with business, CRM, and product stakeholders for requirements elicitation, backlog management, and functional specification definition; automated recurring reporting workflows via optimized SQL queries, reducing manual effort by 25% and increasing delivery efficiency.
• Spearheaded data modeling and governance frameworks for new analytical initiatives, ensuring data quality, traceability, and compliance with SDLC and Agile Delivery standards, supporting scalable analytics and sustainable data architecture.

• Led the CRM transition initiative from an internal platform to LeadSquared as Program Manager and Agile Business Analyst, driving requirements elicitation, stakeholder alignment, and backlog management, resulting in a 7% improvement in lead utilization and enhanced sales visibility.
• Spearheaded the analytical transformation program, implementing Tableau as the organization’s primary business intelligence and reporting tool, replacing legacy Google Sheets and Excel dashboards, and improving reporting efficiency by 35%.
• Implemented a data quality assurance framework by developing and deploying SQL-based validation scripts leveraging CTEs and sub-queries, ensuring accuracy, consistency, and integrity of customer and operational data across systems.
• Collaborated with cross-functional stakeholders in Tech, Product, and Compliance teams to strengthen data governance, contributing to ISO 27001 information security standard implementation and ensuring alignment with non-functional requirements and organizational data policies.