Sanyam Pandey
Jersey City,NJ
Summary
Customer driven Business Analyst dedicated to analyzing complex business processes and requirements, identifying gaps, and developing effective IT solutions to improve efficiency and drive growth.
Overview
6
6
years of professional experience
Work History
Business Analyst
Wiley
2023.07 - Current
- Worked with cross functional digital marketing teams to identify, define, and refine business needs and requirements in JIRA for prioritization across Adobe stack.
- Led Wiley's business requirements for creating email campaigns in Adobe Campaign, web experience in Adobe Experience Manager and subsequent dashboards requirements in Adobe Analytics.
- Deployed adequate requirement analysis within Agile environment and tools to deconstruct complex business/product requirements into actionable capability needs for program planning.
- Led Q2 and Q3 digital marketing program planning and martech projects to deployment and testing with offshore teams.
- Liaised with multiple technology teams to educate, validate, optimize, and streamline incremental delivery over the course of the multi-phase and multi-platform migration.
- Led daily agile meetings to provide effective communication and alignment across relevant stakeholders.
- Led User Acceptance Testing and product demos for stakeholders at the end of sprint.
Lead Business Analyst
Phillips-Van Heusen Corp
2022.04 - 2023.03
- Led stakeholder meetings as part of marketing technology team to elicit functional requirements aimed to improve Tommy Hilfiger and Calvin Klein Ecommerce website and increase customer retention in Salesforce Marketing Cloud
- Developed product feeds and mapping documents from source systems to downstream systems for data ingestion in Salesforce Marketing Cloud, Salesforce Commerce Cloud and Acquia
- Created user stories in JIRA for migration of product data feeds in Calvin Klein ecommerce website from WebSphere to Salesforce Commerce Cloud (SFCC)
- Developed workflows in MS Visio for enhancing AI based email product recommendations data model via Salesforce Marketing Cloud using Einstein AI for Calvin Klein and Tommy Hilfiger
- Created product feeds and customer feeds for Blue Core for ingestion to send product recommendations to customers
- Led bi-weekly backlog grooming sessions, project demo, project review and retrospective meetings at end of every sprint
- Worked with CRM team to update duplicate customer contacts in Salesforce Commerce Cloud and provide resolution on customer management
- Managed product data feeds in Salesforce Commerce cloud to support customer journeys and campaign journey requirements for ecommerce team stakeholders
- Created user stories in JIRA for tracking customer sign ups in Salesforce Marketing Cloud from Salesforce Commerce Cloud through Salesforce Marketing Cloud connector
- Documented gaps and provided recommended fixes to business rules adopted in Identity Resolution Engine
- Led incident management and support resolution process in Acquia for Customer Data Platform production issues in ServiceNow for Customer Rewards Redemption, Loyalty, Identity Resolution Engine, front end and POS system
- Worked in two-week sprints to help deliver end to end testing of CDP enhancement projects
- Managed product backlog for 2 applications including discovery, prioritization and execution in JIRA
- Created dashboards in JIRA to report the sprint progress to business on a biweekly basis
- Created UAT test cases in JIRA and assisted business teams testing coordination with offshore QA team.
Senior Business Analyst
Express Clothing
2021.12 - 2022.04
- Led stakeholder meetings to elicit requirements with product engineering and marketing team to improvise customer match rate in customer data hub
- Led requirements to capture demand data of orders placed from Order Management System in Salesforce Commerce Cloud
- Created user stories to automate and generate automated daily feeds that show orders placed in real time vs shipped orders from source Order Management System in Salesforce Commerce Cloud to help business make decisions based on data as close to real time as possible
- Developed file feed requirements to generate automated daily feeds from source system Salesforce Commerce Cloud to downstream customer data hub
- Created data mapping document to identify customer data attributes in file feed format for data ingestion requirements in Adobe Campaign and Blue Core
- Loaded source-to-target table customer attributes in Power BI using data visualization to support to data feeds requirements
- Created mapping workflows in MS Visio and spreadsheets to finalize business fields in daily inbound reports and customer feeds for CRM team
- Led meetings with stakeholders to ensure inbound and outbound data requirements are signed off
- Summarized customer data requirements in BRD for business stakeholders for final approval and sign off
- Created technical design document for development team to support development in production
- Created Requirements Traceability Matrix to map detail requirements, design and test cases to track requirements
- Maintained RAID log to call out issues and risks, through their timely capture and accurate identification
- Defined project requirements by identifying project milestones, phases and tasks for scrum team
- Acted as Scrum master leading daily stand-up meetings and created weekly status dashboards in JIRA
- Lead sprint planning and sprint retrospective meetings to ensure prioritization of tasks
- Created test cases to lead user acceptance testing with business stakeholders to ensure user acceptance criteria is documented and executed during testing.
Business Analyst /Project Lead Consultant
Coca-Cola, BODYARMOR Sports Drink
2021.06 - 2021.12
- Created user stories and use case scenarios in JIRA to support Electronic Data Interchange (EDI) business requirements for Store Operations, Inventory Management and CRM team
- Created user stories to enhance front-end web payment applications STORD and STAMPLI used by finance and accounting team stakeholders
- Created dashboards in MS Power BI by loading monthly invoice data to support automated reports in STAMPLI
- Led IT automation projects to reduce manual inbound and outbound transfers of raw materials and finished goods with supply chain team and store operations team
- Acted as point of contact for automation projects on applications for vendors and third-party applications
- Worked closely with ETL developers, application team and business to incorporate requested changes
- Conducted application gap analysis (Current vs Future), identified improvements and documented steps to remediate gap
- Managed vendors contacts in Salesforce CRM post Electronic Data Interchange (EDI) migration
- Created business flow diagrams and training materials in Lucid chart and MS Visio for scrum team
- Created training documents for newly designed business processes and applications
- Worked closely with Finance, HR, and Customer Service team on designing Business Continuity Plan in MS Visio
- Created Quality Assurance test cases with QA team as well as supported system regression testing
- Created test cases for user acceptance testing of integration of web payment application STAMPLI
- Led planning and go live dates of Electronic Data Interchange (EDI) transfers of raw materials with True Commerce application portal
- Managed and communicated project plans with EDI vendors and warehouses to onboard on Electronic Data Interchange (EDI) functionality.
Senior Business Analyst
Wiley
2020.07 - 2021.05
- Led gathering requirements sessions, documented requirements and created epics and user stories in JIRA to implement product pricing in SAP Vistex
- Constructed workflow diagrams and pivot tables in Excel to support system and pricing team requirements of SAP Vistex for annual pricing of their products
- Created requirements for custom product catalog page to enhance user interface for browse/search feature per pricing requirements
- Created wireframes in MS Visio to support new layout requirements in SAP Vistex for pricing team
- Supported Product Data and Pricing team to understand pain points and issues and develop new processes and insights
- Worked closely with ERP Pricing Product Owner to approve UI/UX design decisions aimed to automate pricing application in SAP Vistex
- Worked closely with Pricing team to realize solutions, conducted periodic review of implementations, and escalate issues and send weekly status reports to senior management
- Analyzed the annual pricing reports from the ERP system and created mapping for reports being migrated to MS Power BI
- Maintained program backlog and reporting on a weekly basis to senior management
- Created UAT planning document and test scenarios for end users
- Tracked progress of bugs during UAT with QA team and business stakeholders to ensure they were closed before Go-live date.
Business Systems Analyst
Bed Bath & Beyond
2017.09 - 2020.07
- Created User Stories in JIRA and led migration of web applications to Office 365 suite from Lotus Notes
- Created wireframes in MS Visio and user stories in JIRA to support UI design of website per rebranding of company legacy company logo in SFCC Business Manager
- Actively worked as a scrum master & product owner to monitor and prioritize product backlog on an ongoing basis to meet release timelines and value to the business
- Conducted user validation and testing of Lotus Notes applications that needed to be migrated to MS SharePoint
- Championed adoption of Office 365 with departments to help implement applications as appropriate for our business
- Created training guides and manuals to support business stakeholders post O365 applications migration
- Facilitated iteration planning meetings, lead work within individual sprints and coordinate retrospectives and demos
- Led scrum events with like daily standup call, backlog grooming session, project demo, project review and retrospective meetings
- Collaborated with IT security team, networking, and messaging team to facilitate effective issue resolution from tickets in ServiceNow
- Monitored and tracked user incidents to deliver consistent results for incident management and problem escalation using ServiceNow
- Organized and performed functional and regression testing in TFS as well as support for User Acceptance Testing (UAT).
Education
MBA -
State University of New York
01.2015
Skills
- User Experience Optimization
- Ecommerce/Retail Systems Analysis
- Requirements Gathering
- IT Solution Implementation
- Stakeholder Management
- Gap Analysis (Current vs. Future)
- Business Process Automation
- Quality Assurance and Testing
- Data Mapping and Data Analysis
- KPI Development
- SQL Queries & Data Extraction
Timeline
Business Analyst
Wiley
2023.07 - Current
Lead Business Analyst
Phillips-Van Heusen Corp
2022.04 - 2023.03
Senior Business Analyst
Express Clothing
2021.12 - 2022.04
Business Analyst /Project Lead Consultant
Coca-Cola, BODYARMOR Sports Drink
2021.06 - 2021.12
Senior Business Analyst
Wiley
2020.07 - 2021.05
Business Systems Analyst
Bed Bath & Beyond
2017.09 - 2020.07
MBA -
State University of New York
Similar Profiles
Meer Mehtaab HussainMeer Mehtaab Hussain
Specialty Account Manager- Corporate & Healthcare at WileySpecialty Account Manager- Corporate & Healthcare at Wiley
Bethany LynchBethany Lynch
Editorial Assistant at WileyEditorial Assistant at Wiley
Eranga GunasekaraEranga Gunasekara
Senior Business Analyst - MarTech at WileySenior Business Analyst - MarTech at Wiley