SUMMARY

• More than 8 years of Industry experience in the field of Retail and E - commerce as a Business Analyst, working with the technical staff to implementing management and staff's business requirements into the software application.
• Good experience at Demand ware, ATG Dynamo B2B Commerce, ATG B2C Commerce, Shopping Cart, Product Catalog, Merchandizing, Catalog, Droplets.
• Extensive experience in full life Cycle implementations of Distribution & Supply chain Modules in a complex Multi Organizations.
• Experience in Oracle Retail Modules like Retail Merchandising System (RMS), Oracle Retail Invoice Matching (REIM), and Retail Price Management (RPM) and also has very good experience in Order Management Application.
• Working experience across Omni channel, Customer Order fulfillment, Product management, Inventory management, Forecasting and Replenishment.
• Experience on Retail / Supply chain domain with knowledge of standard business processes like Inventory Control, Procurement & Allocation, Merchandise Planning, Returns, Warehouse & transportation management process, knowledge on POS and Assortment Planning.
• Working experience with various E-commerce modules for electronic funds transfer, supply chain management, Internet marketing, online transaction processing, electronic data interchange (EDI), inventory management systems, and automated data collection systems. Conducted tech reviews for various modules for the team.
• Extensive experience with Business-to-consumer (B2C) sales of tangible goods and Business-to-business (B2B) scenarios.
• Experience in B2B, B2C and E-commerce portals and web applications.
• Excellent Retail e-commerce domain knowledge, with working experience in Sales Force commerce cloud (Demandware).
• Good working experience at Master Data Management (MDM), Identity data, Trade Promotions Management (TPM) and Point of Sales (POS).
• Experience working with Retail Oracle POS application, Payment processing (EMV).
• Strong Knowledge of second level operational support of Oracle SIM end-users stores and Store Operations RMS and Supply Chain end-users located at the central office.
• Experience with both functional and technical aspects of project design and implementation in Warehouse Management System (WMS/PKMS).
• Manage the product development of a proprietary EDI system enabling the integration of electronic invoicingwith billing systems and order fulfillment.
• Expert level working knowledge in different verticals and areas like Localization, Mobile-Commerce, SCM,Hybris and CRM.
• Experienced in SQL, Access, Excel and internally developed business data and marketing tools. Also experienced in UX design & testing.
• Proficient in using version control tools, Team Foundation Server (TFS), GITHUB and agile management tools like JIRA, RALLY.
• Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Stored Procedures.
• Experience in extracting UI based information by querying the Oracle database using SQL queries.
• Strong knowledge in SQL Server disaster recovery, backup/restore, migration and upgrade participated in disaster recovery drills.
• Highly Experienced in Microsoft Office Suite including MS Visio, Excel, PowerPoint, Word and Outlook.
• Worked with defect tracking tools like JIRA, and Quality Center.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Extensive Experience in Gap analysis to compare As Is with To Be business processes and offered solutions.
• Involved in Designing and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.
• Proficient in Technical and Business Writing, Business Process Flow, Business Analysis and testing various methodologies.
• In-depth knowledge of creating use cases, functional design specifications, activity diagrams, logical, component and deployment views to extract business process flow.
• Expertise in designing and developing Test Plans and Test Scripts.
• Experience testing implemented systems and system changes including liaising with QA teams to develop test cases, test plans, test scenarios, and generating test data and conducting manual testing.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases.

PROFESSIONAL EXPERIENCE

Confidential - New York, NY

Business Analyst

Responsibilities:

• Conducted JAD (Joint Application Development) Sessions and RAD (Rapid Application Development) Sessions with stakeholders.
• Interacted with the PM in managing the Agile Scrum process to ensure smooth delivery of projects.
• Identified internal and external system requirements, design and configuration set-up, also created User Documentation and conducted training class.
• Also involved in E-Commerce POS testing Product Search, Payment System, Online transaction processing.
• Performed Data Profiling of current state of data in the Data Warehouse by doing Data Analysis using SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same.
• Performed GAP Analysis of business rules, business and system process flows, user administration, and requirements. Ensured POS PCI compliance requirements were met.
• Analyze the current Supply Chain Management from receiving an order in OMS (Order Management System), WMOS (Warehouse Management Open System) and complete processing till final delivery to customer and suggest best remedial methods.
• Analyzed B2C and B2B web properties and create new business plan, business requirements, and staffingrequirements.
• Provided practical and strategic subject matter experience for the DemandWare E-commerce portal.
• Worked with various e-commerce modules for electronic funds transfer, supply chain management, Internet marketing, online transaction processing, electronic data interchange (EDI), inventory management systems, and automated data collection systems. Conducted tech reviews for various modules for the team.
• Worked on the up gradation of e-commerce web site engine by managing resources and responsible for installing new software version to increase site uptime.
• Assist the business reporting and scrum teams to understand the ecommerce, inventory and Store operations data and business process.
• Involved in designing automated POS system using involving monthly import of POS excels files into a database using SSIS packages. Created templates for power users to create their own SSRS reports.
• Worked with supply chain methodology and wholesale distribution processes.
• Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the Gaps between IT and Business.
• Performed end to end system testing of the customized ATG BCC tool. Involved in preparation and execution of business scenarios to validate the implementation of the ATG ecommerce suite.
• Support for an inventory management value assessment to improve financial performance and the customer experience by reducing working capitals and supply chain costs, and improving on shelf availability.
• Responsible for addressing, diagnosing, and resolving issues that arise on a day to day basis for the team. Also responsible for documenting the causes, analysis and final resolution to the issues/errors.
• Checked to make sure orders from customers are accurate and free of any variance by working closely with the sales, shipping department and warehouse.
• Responsible for addressing, diagnosing, and resolving issues that arise on a day to day basis for the team. Also responsible for documenting the causes, analysis and final resolution to the issues/errors.
• Involved in implementing (POS) Point Of Sale system and Point Of Commerce for US retail/Online stores.
• Worked as Business Analyst for collecting customer requirement for managing supply and delivery translating the requirements into documentation for effective process flow mapping.
• Conducted interviews with key business users to collect requirement and business process information.
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD using UML.
• Experienced with content management, e-commerce and order management.
• Worked with information architects and creative groups in detailing the wireframes and depicting GUI design.
• Coordinated testing efforts across multiple supply chain and retail applications including allocations and replenishment.
• Tested the web application components of Content Merchandising System, Oracle RMS, WebSphere commerce functionality on various web browsers as part of UI testing.
• Participated in requirements analysis using a Use case driven approach and produced detailed use cases and functional specifications for all the interfaces.

Confidential - Minneapolis, MN

Business Analyst

Responsibilities:

• Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
• Co-authored business requirements document with project teams. Extracted, discussed, and refined business requirements from business users and team members.
• Act as a resource in understanding how IS systems carry out business functions and assists in ensuring the timely and effective implementation.
• Worked on developing UI wire-frames, utilized SAP Hybris for search and merchandising, content management, Order management, product information management and digital asset management.
• Effectively managed live eCommerce clients of mid-sized B2B and B2C eCommerce websites integrated with the company's existing ERP software and Shipping Software in a Content Managed System (CMS).
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Business Process Models.
• Supervised and managed project throughout SDLC to ensure that project management methodology based on RUP is followed during the project lifecycle using MS Project and NIKU Workbench.
• Used Rational Tools for creating use cases, version control and defect tracking, monitoring. Use Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC).
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Was involved in the creation of new E-Commerce Products (Arrival Notices and Customized Reporting).
• Worked on reporting of Installation Manhattan WMS (Warehouse Management System) in the DC to handle all the cross-docking messaging from Trends.
• Maintain accurate records for all deposits and debit card payments; Perform audits of accounts and follows basic inventory management disciplines for managing book of business.
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Gathered requirements for the integration of POS system with the supply chain system.
• Performed the requirement analysis and documented the requirements using Rational Requisite Pro.
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Designed flexible project foundation enabling rapid implementation of e-commerce website capabilities.
• Custom tools upgrade client had created marketing, merchandising product tools to support their custom web application which needed to be re-architected to work with ATGs E-Commerce suite.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Tracked change requests and monitored workload and schedule.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.
• Used Rally tool for requirements management and tracking user stories in a sprint and product backlog.
• Tracking business reporting issues on JIRA by creating problem statements that help breakdown the underlying issue.
• Worked on developing customized SQL reports and queries for management decision-making and operational management.
• Involved in developing strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing)
• Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing using Mercury's WinRunner.
• Suggested measures and recommendations to improve the current application performance.
• Assisted with the development of test plans and strategies, coordinated testing events, and executed test cases in support of changes to business systems.
• Participated user acceptance testing cycle; worked withbusinessusers to definebusiness scenarios, user acceptance test cases and user acceptance criteria.
• Conducted user interviews, gathered requirements, and analyzed the requirements using-Rally.

Confidential - St. Louis, MO

Business Analyst

Responsibilities:

• Worked on converting and documenting business requirements into BRD, User Stories and SRS.
• Used Use Cases, User Stories, Flow Charts, Process maps and Workflows Diagrams to supplement the planning phase.
• Worked with IT team members and stakeholders about requirement changes and updates.
• Involved in all phases of the SDLC, Agile, perform UAT testing. Understand, translate, communicate business requirements into detailed technical system specifications, and develop use cases.
• Obtained business requirements from business users and stakeholders using JAD sessions, brainstorming sessions, focus groups and personal interviews on AGILE/ SCRUM methodology.
• Drafted User Stories and Use Cases and Identified User Story points with the Developers and assigned user stories to Sprints in Agile Methodology.
• Provided recommendation for use of ATG Commerce for B2B and B2C business.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Worked on various tools and techniques including market research, industry analysis, shipping cost analysis, sales and marketing initiatives, refer-a-friend, loyalty programs to increase and improve visitor traffic, site sales and functionality, etc.
• Worked on documented project and communicated with cross-functional partners to create and maintain standardized Omni-Channel reporting which includes daily dashboards, operational metrics reporting, ad hoc operational troubleshooting and strategic reporting.
• Worked in high volume of Retail Systems with Knowledge on POS (Point of Sale), Merchandising, Inventory Management, Order Management, Gift / Merchandise Cards.
• Determined, diagnosed and proposed solutions to problems with the system's functions through data analysis.
• Attended interviews and JAD sessions with stakeholders and other key decision makers in order to identify requirements and business-related information.
• Assisted with the BRD for the POS implementation project.
• Worked with developers to simplify checkout process, such as reducing time and procedures for returning customers to complete prior saved shopping carts.
• Involved in Data Mapping Documents, data flow description document and attribute description document for the development team's simplicity.
• Involved in maintaining project progress and status through MS Project. Extracted periodic/ monthly status reports to the Project Manager to serve as the team's assessment of the project and its schedule.
• Worked on Traceability Matrix table to uniquely identify and trace the business requirements to general design to testing as to prove that the requirements have been developed into a solution and that it has been tested and tracked.
• Communicated with data analyst team to design data models and create data mapping documents for data analysis and created reports adopting business objects.
• Used Agile/SCRUM requirements management tool Rally for managing story cards, efforts, and preparing burn-down charts and velocity charts.
• Designed merchandising and marketing databases; developed stored procedures and reports to automate reoccurring tasks using SQL Server.
• Worked with requirement documentation used for Data Extraction, Data Transformation and Loading process as a part of data mapping procedures.
• Involved in training materials and interface requirements, adhered them to project management methodology.
• Assisted Test Lead, Testers understanding business process and helped them for successful completion of Unit Testing, Integration Testing and Requirements Testing.
• Involved in test cases and participated in UAT (User Acceptance Testing).

Confidential - Duluth, MN

Business Analyst

Responsibilities:

• Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
• Responsible for business analysis, requirement specifications and identifying the resources and implementation of the project.
• Gathered high level requirements and developed scope of the project for the implementation of NetSuite’s CRM.
• Developed a consolidated and prioritized high level requirements matrix for both B2C and B2B that detailed current and future state needs.
• Investigated and resolved issues within Supply Chain module as well as WMS (Warehouse Management System) software.
• Create Standard Operating Procedures (SOPs) for use of the ERP System (NetSuite) sales ordering process, logistics and inventory management, RMAs & support call logging.
• Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud.
• Worked with warehouse personnel to develop a program using Microsoft Excel in which purchase orders are closely monitored and invoices are reviewed.
• Aligned withWMSteam and development team based on requirements and mapping.
• Performed Black Box testing and conducted Functionality and Regression testing on various phases of the Management software.
• Interacted with stakeholders and gathered requirements as per the business needs.
• Involved in preparing project plans and identifying major milestones for each stage as per the SDLC model (Agile Methodology).
• Responsible to perform analysis and present results using MS SQL, Excel & Power BI.
• Created a task plan for the team identifying the key deliverables and the respective deadlines.
• Analyzed business requirements for the POS retail system, process flow and gap analysis, and writing test cases for the QA team. (Used Visio, Crystal reports, Word).
• Gathered analyzed and documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Analyzed and reporting of the utilization of Rational & Clear Quest Defect Tracking System (CDTS) for Defect Tracking.
• Gathered requirements for the integration of POS system with the supply chain system.
• Using Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Worked with business/SME to identify requirements and gaps for migration from custom legacy order management system to Sterling based order management.
• Made weekly deposits and ordered change needed for the week
• Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology.
• Conducted gap analysis and made As-is-to-be diagrams to understand new business requirements and challenges in implementing new modules.
• Project resulted in significant increase in order fulfillment productivity while reducing database impact on the WMS.
• Primarily responsible for reporting of End to End integration of merchandising systems (ORMS) with the Warehouse Management systems (ORDM and PKMS), Direct to Customer systems (CWD), Allocation Systems (SIMS), Point of Sale (POS).
• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
• Responsible for second level operational support of Oracle SIM end-users stores and Store Operations RMS and Supply Chain end-users located at the central office.
• Reviewed the Joint Requirement Documents (JRD) with the cross functional team to analyze the High Level Requirements.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application.
• Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.
• Conducted weekly meetings for deciding the Policies and Procedures to be followed while constructing new sites.
• Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.
• Designed and developed Activity Diagrams, and Sequence Diagrams utilizing MS Visio.
• Documented the server farm requirements and requirements related to security within Share Point.
• Created Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor.
• Maintained key records for purposes of Compliance review and/or regulatory inquiry. Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data Involved and reviewed TSQL/SQL queries and stored procedures to process, analyze and implement data integrity initiatives for various business units.
• Performed complex SQL queries for retrieving data from the database, generating ad-hoc reports, and conducting data validation testing.
• Designed merchandising and marketing databases; developed stored procedures and reports to automate reoccurring tasks using SQL Server.
• Performed Unit Testing and User Acceptance testing and documented detailed results.
• Provided input (scope, goals, risks, constraints, timelines and interfaces) to PM for project planning and control.
• Assisted QA team in developing test strategy, and test cases and actively monitored various types of testing - functional testing, Progression testing, system testing, load testing, smoke testing, and regression testing.
• Managed Requirement Traceability Matrix to ensure test cases are traceable to requirement specifications.
• Actively facilitated complete UAT process - creating UAT schedules, testing guidelines, managing feedback, follow-up, and resolving open issues.

Confidential - Portland, TN

Business Analyst

Responsibilities:

• Acted as a liaison between business users and technical department managing a team of subject matter experts for E-Commerce user acceptance testing efforts.
• Developed documentation for POS Systems including Corporate Policies.
• Recognized the key points in Creation of Sales, Item interfaces between RMS, POS and Essbase (a multi-dimensional database and reporting tool).
• Worked in tandem with the development and quality assurance teams and supervised change management using Rational Clear Quest/Clear Case. Analyzed and prepared Change Requests (CRs) for bridging the gaps due to change in requirements.
• Worked closely with the system integration team in managing timelines, resources, and tasks ensuring successful project implementation via MS Project. Prepared and maintained the systems analysis artifacts in Rational DOORS. Responsible for project updates in high level project meetings and prepared Weekly Status/Progress Reports.
• Participated in development of E-Business Suite programs for databases supporting supply chain management (SCM), order management, inventory, and warehouse management system and purchasing.
• Assisted with the BRD for the POS implementation project.
• Involved in the support for a major effort to improve the Warehouse Management System (WMS) capabilities of supply chain.
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Participated in design and build of different OMS modules - Order Capture, Order Processing, Order Promising & Fulfillment, Payment Processing, and etc.
• Worked with Development to figure out the different Activities OMS does for inter Applications data transfer with CRM in Java.
• Conducted AS-IS and TO-BE for understanding the problem statement for up gradation of existing E-commerce solution.
• Project resulted in significant increase in order fulfillment productivity while reducing database impact on the WMS.
• Acted as a main point of contact between the client and technical teams to deliver high quality, crisp requirements for the implementation of a complete end-to-end E-commerce application utilizing ATG (Oracle Web Commerce).
• Was involved in the creation of new E-Commerce Products (Arrival Notices and Customized Reporting).
• Responsible for requirements gathering, analysis, detailed process flow design, user acceptance testing and rollout of new & modified feature functionality deployed on the E-commerce website applications.
• Worked with systems and client professionals of a complex, global company encompassing all facets of retailing including catalog ordering, shipping, warehouse inventory management, purchase ordering, retail sales and customer services.
• Define and document CRM specifications for Coach's ERP system (NetSuite) for customer support, sales orders and offshore helpdesk.
• Responsible for analyzing the business process, creating requirements documents, maintaining vision documents, supplementary specification documents, and developed use cases.
• Provided subject matter expertise for functional and technical aspects of the DemandWare E-commerce platform.
• Involved in Designing business requirement & systematic approach based on project scope and SDLC.
• Gathered and validated requirements, resulting in detailed business rules, functional requirements and process design.
• Was also involved in Implementation, enhancement and support solutions to meet client's needs using Demandware ecommerce platform.
• Created different Experienced in User experience (UX) definition and User Interface (UI) design for project as well as prototypes and wire frames.
• Created datasets for Omni channel reporting project that incorporates email, marketing, and member interaction data.
• Conducted User Interviews and Work Shops to gather accurate Business Requirements.
• Successfully collected, analyzed and documented requirements from the business for a new Shareowner Services Web Portal.
• Developed a consolidated and prioritized high level requirements matrix for both B2C and B2B that detailed current and future state needs, along with a gap analysis against Demandware and their legacy system.
• Gathered requirements from business owners perform system analysis & created business and functional requirement documents /user stories in Rally for the Change Request/Enhancements.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Participated in Daily Agile Scrum "Stand-up", Biweekly Sprint Planning and Retrospective Sessions and update the team on status of upcoming User Stories.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Interacted with the PM in managing the Agile Scrum process to ensure smooth delivery of projects.
• Made sure developers completed unit testing and created production forms.
• Created technical design documentation for the data models, data flow control process, metadata management.
• Utilized JIRA to communicate constantly changing functional and design requirements with business users and developers.
• Use of MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint MS Project for data migration in to the CI System Knowledge Database in Microsoft SharePoint
• Worked on SharePoint to maintain up to date changes to any artifact, version controlling and controlling duplication of effort.
• Also involved in E-Commerce POS testing Product Search, Payment System, Online transaction processing.
• Assisted QA team in executing Test plans and wrote Test Cases
• Collaborated with quality assurance/quality control to ensure that the final product met all the requirements.
• Cooperated with various teams during the user acceptance testing (UAT) of the final product.