SUMMARY

• 8 + years of experience in Business Analysis, System Analysis in Retail and E - commerce domain.
• Experienced working with Data Analysis for JIRA data, assisted in cleaning up and organizing JIRA tickets for better tracking.
• Created detailed documentation of complex build and release process forDemandware, post release activities process, JIRA workflow and Release notes.
• Experienced in writing SQL Queries for testing RDBMS such as SQL Server, Oracle, and Teradata for data integrity.
• Experienced in Business Requirements gathering and writing skills with expertise in developing and documenting BRD, FRD, SRS across the deliverables of a project.
• Worked on all the phases of SDLC methodologies throughout the project life cycle using Agile methodology.
• Identified the missing functionality and fulfil the gap between the organizational requirements and COTS solutions.
• Experienced in working with key retail platforms like IBM Sterling Order Management system, Sterling Integrator, JDA, Magento.
• Experience on Supply Chain domain with strong knowledge of standardbusinessprocesses likeE-commerce, Inventory Control, Procurement & Allocation, Merchandise Planning, Pricing & Invoicing, Demand Planning & Forecasting, Returns, Warehouse & transportation management process, Accounting & financials. Good knowledge on POS and Assortment Planning.
• Assisted the QA team to design Test plans and Test Cases for User Acceptance Testing (UAT), Black box Testing, Functional Testing, various System Testing, Integration Testing, Regression Testing, Security Testing, Load/Stress Testing, and Performance Testing in both manual and automation testing environment and creation of Test plans, Test cases and Test scenarios for validating it againstbusinessrequirements document.

• Agile / Waterfall
• Software Development Life Cycle (SDLC)
• SAAS
• NetSuite ERP, CRM, Web Presence/E-Commerce, On-demand, Cloud Computing, SaaS, ASP, and Oracle Cloud Solutions.
• Informatica/ ETL (Extract, Transform and Load)
• SQL
• Sales Cloud, Marketing Cloud, and Service Cloud.
• 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, Chicago, IL

Sr Business Analyst

Responsibilities:

• Conducted user interviews, gathered requirements, analyzed the requirements using agile methodology and documented the requirements using Rational Requisite Pro.
• Worked on web-based application and systems development project including customized Content Management System (CMS).
• Worked on Support Sales and Marketing to promote ecommerce programs through the number one revenue generating website.
• Work on transitioning client requirements into technical design, design schemas implement custom extensions, integrate with search engines, unlocking the business value of hybris.
• 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 e-Commerce applications to identify areas of improvement and carried out program enhancements and modifications.
• Worked with DBA team to provide application support and troubleshoot any issues related to Oracle e-Business Suite.
• Facilitated JAD sessions with internal and external stakeholders (Sales, Credit, Finance, IT, Ecommerce, Management, Marketing, and customers) to gather requirements.
• Responsible for integrating ERP, Payment gateway, Tax System to Hybris as a part of ecommerce systems.
• Worked on the Credit card/ EMV process for paying through the web or mobile application.
• 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.
• Analyzed and Evaluated business requirements which needed configuration changes to various modules of ATG platform like ATG Business Control Center, Content Administration, Merchandising, Catalog Management and Personalization.
• Gathered requirements for Order management, Warehouse management system (WMS), E-commerce B2C and B2B portals.
• Troubleshoot Sterling Order Management system and its components
• Documented and analyzed the business process for receiving and processing customer sales based on "Opportunity to Order" and covers business-to-business (B2B) and business-to-consumer (B2C) sales.
• Handled order management system (OMS) such functions as order entry, sales analysis, inventory planning, and accounting, among others.
• Created system specification and application design document for OMS system for Retail fulfillment process across multiple releases
• Create Business Process Scenarios based on the OMS.
• Worked on e-Commerce solutions (Outlook, EDI/XML, SAP Email and Auto fax), utilizing e-Tools to improve business workflow and streamline processes
• Worked on PCI (Payment Card Industries) compliance to address security vulnerabilities to the Online Stores thus enhancing the websites security.
• Worked on Merchandising, Point of Sale (POS) Systems, 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.
• Participated in the Master Data Management (MDM) effort, provided technical advice and support toward the development of strategic and tactical plans for client master data management strategy, data inventories, data governance, data management, storage, and distribution alternatives in support of client MDM strategy.
• Worked on Data Cleansing or Data Scrubbing concepts 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.
• Worked on installing a Manhattan WMS (Warehouse Management System) in the DC to handle all the cross-docking messaging from Trends.
• Involved in the Implementation of Warehouse Management System (Manhattan WMOS) for e-commerce warehouses.
• Responsible for working with customers to gather the requirements and created functional specifications and created the dashboards using Tableau.
• Worked and reinforced scrum methodology and agile framework to team members and key stakeholders.
• 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.
• Provided guidance to development team required to complete transition from Broad vision to Hybris ecommerce platform.
• Identify the missing functionality and fulfill the gap between the organizational requirements and COTS solutions
• Involved in the preparation of Demo/POC by developing online B2B/B2Cstore applications using Hybris as Ecommerce platform and Rest/Soap functionalities.
• Involved in gathering data and conduct analysis with the goal of improving the organization's supply chain operations in logistics, sales.
• Defined Business Process Model with the help of Data Flow Diagrams DFDs, Entity Relationship Diagrams ERDs and Web Page Mock-Ups using Rational Rose and MS Visio.
• Used MS Word, MS Excel, MS Access, MS Project, 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.

Confidential, Dallas, TX

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.
• Facilitated JAD sessions with internal and external stakeholders (Sales, Credit, Finance, IT, Ecommerce, Management, Marketing, and customers) to gather requirements. The project includes implementing the Trade Promotions Management (TPM), Supply chain management and Order management (OMS), Inventory management system and Supply chain groups to work together to address critical dependencies between processes like demand, supply, tooling and warehousing. It has been implemented for maintaining the Demand, Production, supply, Shipping, Logistics and purchase order processes.
• 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.
• Involved with Category Development Managers (CDM) with the input of their annual trade plans in the Trade Promotions Management (TPM).
• 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).
• Worked on business process assessments across demand planning and Trade promotion management (TPM) involving SAP APO, SAP CRM which led to a phased roll-out to enhance Demand Planning functionality, data management, and reporting.
• 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 Eliciting, analyzing, documenting and validating business requirements and user stories, process flows for the new ATG e-Commerce Platform spanning all aspects of browsing and purchasing hardware and services.
• Involved in providing general/ ad hoc data and analytical support to Category Development Managers (CDM), Trade Marketing Manager, Sales and Finance.
• Involved with the developers in developing E-Business Suite programs for databases supporting supply chain management (SCM), order management, inventory, warehouse management system, purchasing, and Procurement.
• 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.
• Worked closely with the sales and marketing team to customize lead management by utilizing sales cloud using salesforce.com
• Worked on the Enterprise Meta data repositories for updating the metadata and also involved in Master Data Management MDM.
• Involved in Implementing Hybris multi - channel with Hybris functional analysis, e-commerce system design, configuration, customization and testing and support.
• Involved in developing UI wire-frames, utilized SAP Hybris for search and merchandising, content management, Order management, product information management and digital asset management.
• Created the campaign in SAP CRM using the target group created in the Hybris.
• Gathered requirements to customize ATG provided solutions, services, and ongoing guidance to power a more relevant and personal e-commerce.
• Responsible for implementation of SAP system Hybris across along with creation of backward compatible functionality for end users (i.e., reporting, workflow creation, date views, system automation.)
• Worked on SAP Hybris once implemented to answer customer emails and phone calls to deliver exceptional customer experience and track all bugs and issues they may be experiencing.
• Worked on SAP Hybris back office and product cockpit to create customer accounts, add images for products, run cron jobs, track order statuses and information, and more.
• Involved in the inventory replenishment process and analyze changes to inventory levels based on historical data and input from sales.
• Facilitated Scrum Ceremonies - Sprint planning, daily stand-ups, Sprint review, Sprint retrospective sessions and educated the team on agile and scrum practices
• Worked on Informatica PIM and Print solutions - sometimes enhanced with DAM solutions like Celum, Adobe or OpenText.
• Used Tableau to generate final reports to study and analyze the current and future business performance.
• Maintained documents and collaborated with the team by extensive use of SharePoint.
• Created detailed documentation of complex build and release process for Demandware, post release activities process, JIRA workflow and Release notes.
• Worked on sprints i.e., burn down charts, project velocity, sprint backlogs and product backlogs using JIRA.
• Involved in Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• 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.
• Worked on UML notations and methodology in developing models that accurately represent the business process and workflows and clearly communicate them to the stakeholders.
• 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.
• Involved in performing version control and defect tracking activities using Rational ClearCase and Rational ClearQuest.

Confidential, Reading, MA

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.
• 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 creating processes and methods to gather supply chain management data and implement supply chain optimization project (e.g., warehouse-slotting, route planning).
• Involved in developing in-house Order Management System (OMS) for order entry and processing and also developing Distributed Order Management (DOM) software for Seamless Order Processing to improve efficiency.
• Involved in design and build of different Order Management System 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 Master Data Management (MDM) technology, tools to create and maintain consistent and accurate lists of Master Data. Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Worked on analyzing and creating reports, as well as gathered data from credible sources to support and enhance Omni-channel initiatives and performances.
• Documented Omni channel requirements for OMS in collaboration with business stakeholders including logistics and supply chain management teams and with Manhattan OMS development team to successful rollout BOPUS and BOSTS orders.
• Worked on integrating analytics for Omni channel campaigns with established data models.
• Involved in creating custom Magento extensions and template integration in E-Commerce tool Magento OpenCart to enhance the functionality of the website.
• Involved in Integrating Magento with SAP system to get live inventory data updates while customer is attempting to finish his order through a WS call using SOAP.
• Involved in functionally validating Web services delivered in SOAP XML format as provided in specification document.
• Involved in project management, systems analysis and requirements for proprietary ERP system enhancements (Comprehensive Commerce Suite), including User Stories and wireframes.
• Involved in Salesforce Sales, Service & Marketing Cloud and guiding clients on CRM solution for sales, marketing and services teams in the Ecommerce-Digital Marketing.
• Performed GAP Analysis between the "AS-IS" model of the legacy system and "TO-BE" model to identify the project gaps.
• 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.
• Utilized AGILE, Scrum methodology for product development and Product Backlog documentation, wrote User Stories based on INVEST criteria and documented the Sprint Backlog and technical backlog.
• Involved in the formulation of Test Plan that contained test scenarios for all the phases of quality testing including functional, navigation, security, recovery, regression, acceptance and performance testing.
• 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.
• Managed all the requirements in JIRA, making requirements available to all team members.
• 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, Coraopolis, Pennsylvania

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.
• Performed business analysis of eCommerce sales and operations to improve overall business performance.
• 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.
• Worked on Agile scrum methodology and interviewed the front, middle, and back-office users for the requirements.
• Involved in Backlog grooming sessions, helped scrum master in conflict and resolution management.
• Worked on SQL for data mapping and analysis, experience in describing XML file structure through DTD.
• Documented the “AS-IS” Business Workflows adhering to UML standards. Conducted JAD sessions to define requirements and finalize the Functional Requirement Document (FRD
• Prepared Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio.
• Interfaced with team leaders, identify and analyze the given information, procedures and decision flows, evaluated existing procedures, methods and technical documentation. Communicated with executives, managers and other stakeholders regarding project scope
• 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.
• Lead the User Acceptance Testing efforts to verifying that the developed reports meet the requirements
• Involved in developing the test strategy and helped in developing QA Test plans for Functional, Integration and System Testing.

Confidential, Jacksonville, FL

Business Analyst

Responsibilities:

• Reviewed business and overall functional requirements by conducting detailed interviews with business users, stakeholders, and Subject Matter Experts (SME's)
• Led and implemented the entire agile methodology of application development with its various workflows and activities.
• Gathered the requirements for the desired system and reviewed a GAP analysis report as to the difference between the AS and TO-BE system.
• Created Use case and User stories as part of the functional specification document.
• Conducted weekly status meetings after collecting status of the project.
• Included the 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 in order to maintain detailed verbal description of the project.
• Facilitated meetings and detailed communication with developers, system analyst and testers to collaborate resource allocation and project completion using MS Project.
• Involved in Designing and implemented basic SQL queries for QA testing and report/ data validation.
• Validated the business, user and functional requirements as the current project went along.
• Reviewed and validated BRD (Business Requirements Document) and convert business requirements into FSD (Functional Specifications Document)
• Conducted Joint Applications Requirements Capturing Session (JAR) and Joint Application Development (JAD) sessions to understand, capture and confirm requirements and resolve cross-functional issues.
• Participated in data analysis and documentation, and got involved in business test cases and expected results.
• Created functional requirements document for technical team as per the business requirements.
• Involved in the web parts to make sure that the documents are easily available to sales teams & senior management.