SUMMARY

• 8+ years of professional experience as a Business Analyst with a strong understanding of Business Analysis, System Analysis in Retail and E - commerce domain.
• Experienced working on Order Management System (OMS), Omni Channel Fulfillment, Retail Point of sales (POS) Applications, Store operations Customer Relationship Management (CRM i.e., Loyalty Program), Fleet management, Ecommerce platforms.
• Expertise in Software Development Life Cycle (SDLC) methodologies such as RUP, Agile / Waterfall methodologies with hands on experience in all of them.
• Experienced in Business Requirements gathering and writing skills with expertise in developing and documenting Business Requirement document (BRD), Functional Requirement Document (FRD), and Software Requirement Specification (SRS) across the deliverables of a project.
• Experienced in conducting JAD sessions with SME (subject matter experts), stakeholders, developers and end-user representatives to make sure all the stakeholders and developers are on the same page.
• Experienced in conducting Joint Application Development (JAD) sessions with end-users, expert team, development and QA team for project meetings, walkthroughs and customer interviews.
• Extensive knowledge of the E-commerce Retail Sales lifecycle and the Retail Ecommerce ecosystem, Order management system (OMS), Warehouse management system (WMS), Fulfillment, Trade Promotions Management (TMS) and Support.
• Extensive experience in Performing GAP analysis of software functionalities to select between multiple WMS (Warehouse Management system).
• Experienced in UML methodology to create UML Diagrams including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams (DFDs), ER Diagrams using Rational Rose and MS Visio and thus defining the Business Process Model and Data Process Model.
• Experienced in tracing requirements throughout the development process and verifying adherence using the requirements Traceability Matrix (RTM).
• Strong work experience on Ecommerce portals web application developments, Business (B2B) and Business to Customer (B2C), Online Retailing, and Content Management Systems (CMS) for Ecommerce like ATG.
• Solid understanding on various E-commerce tools such as Demandware,MagentoOpen Cart.
• Experienced working with Content Management Systems (CMS), Order Management System (OMS), Supply Chain Management and UX teams.
• Expertise in preparing strategies for Cross Channel/Multi-channel integration providing a consistent experience across the customer's preferred channels and platforms like Mobile and E-Commerce.
• Experienced on various Software and Customer Relationship Management (CRM) packages and Integration of merchandising systems with Warehouse Management Systems.
• Experienced working with Retail Oracle Point of sale (POS) application, Payment processing (EMV) and Knowledge of Web Services Description Language (WSDL), web services SOAP API.
• Experienced in Business Process Flow, Business Process Modeling, Business Process Re-Engineering Data Warehouse Data Analysis, Data Mapping, Data Modeling.
• Experienced in performing backend testing and writing SQL Queries for testing RDBMS such as SQL Server, Oracle, and Teradata for data integrity.
• Experienced in the Informatica/ ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Excellent understanding of Data Models, Master Data Management, Databases like Oracle, and sound skills in SQL.
• Expertise in problem solving, system analysis and strong analytical and product management.
• Strong experience in working with Business and Technology teams through collaboration tools such as Confluence, JIRA, etc.
• Expertise in Advanced MS-Excel (Gsuite, sheets), PowerPoint, spreadsheets (Pivot table & Pivot Charts, Macros, VLOOKUP).
• Proficient in the use of Visual Studio, MS Visio, MS Word, MS PowerPoint, MS Excel, as well as MS Project.
• Solid understanding of Test Plans, Test Strategies, Test Scenarios, Test cases by reviewing Business and Software Requirement specifications and creating Gap Analysis for test purpose.
• Experienced and complete understanding of QA Life Cycle, which includes Designing, Developing, Execution and Documentation of the Test Cases, Automated Test Scripts and Test Plans.
• Experienced in GUI Testing, UAT (User Acceptance Test), Manual, Functional Testing of Client/Server & Web based application.

PROFESSIONAL EXPERIENCE

Confidential - New York City, NY

Senior Business Analyst

Responsibilities:

• Worked on User Requirements gathering by interacting with stakeholders and business users using JAD and One to One interview technique to get a better understanding of the domain and current system.
• Elicited and analyzed the business requirements of client implementing Customer relationship management (CRM) module to maintain records of customer data on a monthly basis.
• Performed GAP Analysis between the "AS-IS" model of the legacy system and "TO-BE" model to identify the project gaps.
• Worked on project management activities for client's requirements and authored Business process documentation, business requirement documentation (BRD) and customer requirement specifications.
• Converted Business Requirements into the Functional Specifications from UML and worked on changes with the help of Requirement Traceability Matrix and Impact Analysis.
• Worked on the entire Omni-channel strategy based on project goals with concerned stakeholders and amplify the details consisting of IBM Sterling Order management and fulfillment.
• Documented Omni-Channel reports which include daily dashboards, operational metrics reporting, ad hoc operational troubleshooting and strategic reporting.
• Involved in developing in-house OrderManagementSystem (OMS) for order entry and processing and also developing Distributed OrderManagement(DOM) software for Seamless Order Processing to improve efficiency.
• Involved in design and build of different OrderManagementSystem OMS modules - Order Capture, Order Processing, Order Promising & Fulfillment, Payment Processing, and etc.
• Involved with other team members to categorize, prioritize and resolve software application issues dealing with all levels of the Order management systems (OMS) and execution management systems (EMS).
• Worked on Order Management System (OMS) to ensure compliances with upgrade requirements, and generated documents for the workflow of exiting system and desired system that involve Cash Analysis, Portfolio Analysis, Order Initiation, Order Execution, Trade Clearing, and Booking, and performed GAP Analysis.
• Worked on Modification to host, Warehouse management system (WMS) and shipping systems to allow efficient processing of e-Commerce orders and client selected samples.
• Involved in the integration of the Warehouse Management System (WMS) with Logistics and other EDI enabled external systems.
• Worked on analyzing and creating reports, as well as gathered data from credible sources to support and enhance Omni-channel initiatives and performances.
• Worked onintegrating analytics for Omni channel campaigns with established data models.
• Involved in functionally validating Web services delivered in SOAP XML format as provided in specification document.
• Worked on outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and diligently consider deadlines.
• Involved in collecting, storing and analyzing data needed for supply chain metrics in identification of root cause for continuous performance improvement, and depicted this information as historical performance trends.
• Responsible for creating UML modeling plan, Use Cases, process flows, screen flows and business requirements documentation to model system development specifications, using MS Visio and Rational Requisite
• Used the Office Suite extensively which included MS Word, MS Excel, MS Access, MS Project, MS Visio for various documentation and analysis reports.
• Worked on Agile, Scrum methodology for development and Backlog documentation, wrote user stories based on INVEST criteria and documented the Sprint Backlog and technical backlog.
• Involved in creating Dashboards reports to support the end users and customers using Tableau Desktop.
• Defined user stories in JIRA by creating tickets and elaborated stories to offsite development and QA teams.
• Worked with the team designing and implementing SQL queries for QA testing and report / data validation.
• Executed SQL queries to test the database for records that detect pricing and product label filters.
• Worked closely with the development team to troubleshoot bugs using defect tracking tool JIRA.
• Involved during the User-Acceptance Testing with end-users, management and development team in order analyze the risk involved in the updating of the existing system.

Confidential - Richmond, VA

Sr. Business Analyst

Responsibilities:

• Conducted user interviews, gathered requirements, analyzed the requirements using agile methodology and documented the requirements using Rational Requisite Pro.
• Analyzed Business to Customer (B2C) and Business to Business (B2B) web properties and create new business plan, business requirements, and staffing requirements.
• Worked on web-based application and systems development project including customized Content Management System (CMS).
• Involved in Support Sales and Marketing to promote ecommerce programs through the number one revenue generating website.
• Involved in managing 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).
• Evaluated existing ecommerce applications to identify areas of improvement and carried out program enhancements and modifications.
• Conducted JAD sessions with internal and external stakeholders (Sales, Credit, Finance, IT, Ecommerce, Management, Marketing, and customers) to gather requirements.
• Worked on the Credit card/ EMV process for paying through the web or mobile application.
• Worked on ATG Software (B2C, B2B, Scenarios, BCC, Merchandising and CSC).
• Worked on analyzing, developing specifications & lead projects for ERP software applications in the areas of Mail Order, Website, Store Interface, CRM, Price\Cost Management, Purchase Order\Receiving, Warehouse management system & Order Tracking interface.
• Worked on PCI (Payment Card Industries) compliance to address security vulnerabilities to the Confidential ’s Online Stores thus enhancing the websites security.
• Worked on Merchandising, Point of Sale (POS) Systems, and Ecommerce and Supply chain systems.
• Worked on compiling and analyzed various reports: E-commerce internal support report (Excel, Access).
• Involved in designing the Database architecture and implementing stored procedures, functions, views, and scripts using SQL to build data processing modules.
• Worked on RTM Test Matrix, GAP analysis and SWOT analysis to check the compatibility of the existing system infrastructure with new business requirements.
• Involved in preparing SDLC Documents such as Business Requirement document (BRD), Functional Specification document (FSD), Test Plan, Test Report.
• Worked on Hybris e-commerce web platforms, Hybris Ecommerce framework, Order Management, Hybris product content module (PCM).
• Created user stories and documented in detail entire work flows in confluence, managed scrum master responsibilities with Sprint Span of two week.
• Create implementation and test plans for the CRM Marketing Email campaigns using Confluence.
• Worked onData CleansingorData Scrubbingconcepts to validate the corrupted data.
• Ensuring accuracy and integrity of ecommerce data through SQL queries which enhances the data quality as per business standard.
• Involved in defining technical goals and business processes for the ecommerce platform in ATG E-Commerce and Retail services.
• Responsible for working with customers to gather the requirements and created functional specifications and created the dashboards using Tableau.
• Created various Reports and Report folders to assist managers to better utilize Salesforce as a sales tool and configured various Reports for different user profiles based on the needs of the organization.
• Used MS Word, MS Excel, MS Access, MS Project, and MS Visio for documentation and analysis reports among other project management and reporting tools.
• Worked on SQL Queries for testing and data analysis of PL/SQL source code.
• Created Use Cases for the applications and facilitated QA group to develop Test Plan and Test scripts based on Used Cases.
• Involved with the QA team to conceptualize, determine and develop test approaches and methods for unit testing, integration and functional testing, load and usability testing according to the application complexity and test requirements.
• Documented and involved in User Acceptance Testing (UAT).
• Responsible for regularly updating the Test Plan and uploading on Confluence for sharing with the team and management.
• Worked with the testing team on the final application including Mobile Application for Usability testing to verify whether all the user requirements were catered to by the application.
• Involved in online store Production Support that included incident troubleshooting and resolving tickets.

Confidential - Grovetown, GA

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.
• Applied Supply chain Management (SCM) methodologies to ensure coordination in the supply chain.
• Aligned withWMSteam and development team based on requirements and mapping.
• 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).
• Created a task plan for the team identifying the key deliverables and the respective deadlines.
• Gathered analyzed and documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Gathered requirements for the integration of POS system with the supply chain system.
• Assisted with the BRD for the POS implementation project.
• 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.
• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
• 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.
• Followed a systematic approach to eliciting, organizing, and documenting requirements of the system.
• Created Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor.
• Rewrite, Add and Define, Rewrite existing requirements, breakout into new requirements, and create additional documentation where appropriate.
• Designed workflows and allocated permissions within SharePoint.
• 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.
• Facilitating workshops, JAR/JAD sessions, during the inception of the new web-based application for the Portfolio Information.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Worked on User Manuals, and Training Manuals as per Project Specifications and timelines.
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.

Confidential - Chicago, IL

Business Analyst

Responsibilities:

• Worked on requirements gathering by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro.
• Facilitated JAD sessions which includes the management, development and user teams for clarifying requirements and better communication.
• Worked on all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle using agile methodology.
• Worked on Trade Promotions Management (TPM) by interacting with different sources of information and provide a unified view of information to all the stakeholders.
• Worked with Category Development Managers (CDM) to accurately document promotional events communicated to customers and enter promotional events into the Trade Promotions Management system (TPM).
• Involved in creating processes and methods to gather supply chain management data and implement supply chain optimization project (e.g., warehouse-slotting, route planning).
• Involved in gathering data and conduct analysis with the goal of improving the organization's supply chain operations in logistics, sales.
• Analyzed inventory requirements from Business to Business (B2B) & Business to customer (B2C) clients and based on sales developed a process to optimize orders that needed to be fulfilled based on SKU dimensions, pallet sizes, customer requirements and delivery requirements; followed the Omni channel fulfillment strategy for tracking inventory and sales.
• Involved in implementing the Trade and Logistics functional area of Microsoft Dynamics CRM.
• Maintained documents and collaborated with the team by extensive use of SharePoint.
• Created detailed documentation of complex build and release process forDemandware, post release activities process, JIRA workflow and Release notes.
• Worked in mainframe environment and used SQL, PL/SQL to query various reporting Databases.
• Involved in developing PL/SQL procedures for creating/dropping of table and indexes of performance for pre and post session management
• Involved in organizing requirements into high level Use Cases and low-level Use Case Specifications and modeled them into UC, Activity and Sequence Diagrams using Rational Rose and MS Visio.
• Involved in reporting bugs/defects in JIRA while doing exploratory testing in the testing phase.
• Involved in creating test Scripts & test Scenarios to check report content, layout, and parameters.
• Involved in user experience (UX) and user Interface (UI) design for project as well as mockups, prototypes and wire frames.
• Review the test plan developed by the testing team for testing the application.

Confidential - Atlanta, GA

Business Analyst

Responsibilities:

• Gathered detailed business and technical requirements and participated in the definitions of business rules and data standards
• Facilitated functional requirement gathering from system users and prepared business requirement documents (BRD).
• Worked on Waterfall methodology to configure and develop process, standards, and procedures.
• Worked on coordinating in store operations and administration including scheduling, reports, inventory, and customer service
• Documented the Process Flows for B2C and B2B in the High-Level Requirements Document
• Worked on analyzing the business capabilities and IT applications for retail Commercial, Space-Range Display, Vendor purchasing, Store Ordering, Distribution and Store Operations.
• Involved in the Point of sales (POS) update which was done remotely and observed remote update process and made sure that the session is terminated after the process ends.
• Involved in draft modified specifications for ‘Suggestive Sales’ to create add-on sales at POS.
• Worked on MS-Visio for flow-charting, Use- Case process model and architectural design of the application
• Implemented the Rational Unified Process (RUP) methodology guidelines with its various workflows and artifacts in Requirements Management and Development.
• Prepared Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio.
• Worked on Traceability Matrix to ensure that all functional requirements are addressed at the use case level as well as the test case level.
• Involved in identifying use cases, actors and writing use case narratives. Created use case diagrams and activity diagrams using MS Visio.
• Created JIRA tickets for defect logging & tracking. Interfaced with developers, analysts, customers and project managers to discuss requirements and recommended solutions, to help resolve issues.
• Involved in developing the test strategy and helped in developing QA Test plans for Functional, Integration and System Testing.