SUMMARY

• Over 8+ years as Business Analyst in Retail & Ecommerce with experience in various phases of software development life cycle (SDLC) including requirements gathering, use casing, functional specifications, development and testing.
• Strong understanding of and hands - on experience in capturing business requirements (user stories) with Agile, Waterfall Processes & methods, including Scrum.
• Extensive knowledge of the E-commerceRetailSales lifecycle and the Retail Ecommerce ecosystem, OMS, WMS, Fulfillment, TMS and Support Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups, SMEs and other project stakeholders.
• Experience in Oracle Retail Modules like Retail Merchandising System (RMS), OracleRetailInvoice Matching (REIM), and Retail Price Management (RPM) and also has very good experience in Order Management Application.
• Experience working with Retail Oracle POS application, Payment processing (EMV).
• Experience with both functional and technical aspects of project design and implementation in Warehouse Management System (WMS/PKMS).
• Experienced and have detailed knowledge about Order Management System, Retail POS Applications, Customer Relationship Management, Fulfillment, TMS and Support.
• Working experience across Omni channel, Customer Orderfulfillment, Product management, Inventory management, Forecasting and Replenishment.
• Expertise in BusinessProcess Analysis & Product management for Global Retailers inOmniChannel Fulfilment using Sterling commerce order management.
• Good experience at B2B, B2C and Ecommerce portals web application and CRM.
• Solid understanding ofsupplychain, project management, logistics with saving in budget.
• Experience in Analytical, methodical and process-centric approach towards the problems, identifying the root causes, corrective actions to meet short term as well as long-term business requirements.
• Expertise with Supply Chain Management (SCM), supply chain strategies/vendor manufacturing process methods to determine level of procurement and strategic sourcing strategies/plans and worked with vendors/peers to determine lead times, schedules and cycle counts, established requirements needs.
• Good experience at Demandware, ATG Dynamo B2B Commerce, ATG B2C Commerce, Shopping Cart, Product Catalog, Merchandizing, Catalog, Droplets.
• Experience using Salesforceand helpedcustomers to implement and operate their online store without the requirement to arrange dedicated hardware and hosting for their website.
• Manage the product development of a proprietary EDI system enabling the integration of electronic invoicing with billing systems and order fulfillment.
• Proficiency in apply Supply chain Management (SCM) methodologies to ensure coordination in the supply chain.
• Experience in performing Analysis, Project & Process Management, Facilitation, Retail Systems & Operations, Multilingual Retail Operations, Logistics, International Growth / Global Operations, Customer Experience.
• Good working experience at Master Data Management (MDM), Identity data, Trade Promotions Management (TPM) and Point of Sales (POS).
• Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a data analysis methodology for application functionality designs using IBM's Rational Rose.
• Experience in writing and executing SQL Queries for Databases such as Oracle, and MySQL.
• Experienced in troubleshooting and performance tuning of reports and resolving issues within Power BI and Tableau Reports.
• Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Stored Procedures.
• Highly Experienced in Microsoft Office Suite including MS Visio, Excel, PowerPoint, Word and Outlook.
• Experience in UAT and of QA Life Cycle, which includes Execution and Documentation of the Test Cases, Automated Test Scripts and Test Plans, also experience with HP Quality Center for bug and defect tracking and reported issues using JIRA,
• 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.

PROFESSIONAL EXPERIENCE

Confidential, Grapevine, Texas

Sr. Business Analyst

Responsibilities:

• Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational.
• Translated business requirements to technical specifications for Hybris/SAP/Sterling Integrator development team and maintains work backlog.
• Worked on Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Conducted JAD sessions which include the management, development and user teams for clarifying requirements and facilitating better communication.
• Involved in Development E-Business Suite programs for databases supporting supply chain management (SCM), order management, inventory, warehouse management system and purchasing.
• Worked on 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.
• Rewrite existing requirements, breakout into new requirements, and create additional documentation where appropriate.
• Provided recommendation for use of ATG Commerce for B2B and B2C business.
• Designed workflows and allocated permissions within SharePoint.
• Involved in Designing merchandising and marketing databases; developed stored procedures and reports to automate reoccurring tasks using SQL Server.
• 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.
• Worked with designer, developer, tested ETL code and implemented International facilities into Oracle EBS.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Perform Gap Analysis of the processes to identify and validate requirements.
• Apply UML notations and methodology in developing models that accurately represent the business process and workflows and clearly communicate them to the stakeholders.
• Used Agile/SCRUM requirements management tool Rally for managing story cards, efforts, and preparing burn-down charts and velocity charts.
• Designed and developed Activity Diagrams, and Sequence Diagrams utilizing MS Visio.
• 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.
• 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.
• Created and maintained user stories in JIRA for better understanding of the requirements for the development team. Also use JIRA for bug tracking.
• Review the Test Plan developed by the testing team for testing the application.
• Created Test Scripts & Test Scenarios to check report content, layout, and parameters.

Confidential - Jacksonville, FL

Sr. Business Analyst

Responsibilities:

• Worked with the team part of 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.
• Identified the retail procedures for emerging retail chain.
• Involved in creating physical inventory process for retail stores, consisted of data integration and inventory processes with third party vendor.
• Worked on the tasks assigned among development team, working with clients to better understand their needs and present solutions using structured SDLC approach.
• Worked on gathering user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
• Worked on the user requirements Analyzed and prioritized them and converted them as system requirements that must be included while developing the software.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Worked on creating Mock-up forms in MS word for better visualization and understanding of the software solution.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Involved in using MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Worked with multiple project teams of technical professionals through all phases of the SDLC using technologies including Data Stage, Data Warehousing.
• Worked on performing extensive data modeling to differentiate between the OLTP and Data Warehouse data models
• Involved with the experts in development of High-level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Involved in Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter the data.
• Involved in Creating and managing project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Worked with the development and maintaining sales reports using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting. Interface with internal customers.
• Worked on the progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Worked with the team on the up gradation e-commerce web site engine by managing resources and responsible for installing new software version to increase site uptime by 3%.
• Worked on identifying various frequently used modules within the application as well as the peak user volume for load testing purposes.
• Worked on analyzing the test results from QA teams using Performance Studio Analysis to create various scenarios.

Confidential, Manhattan, New York

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 the creation of new E-Commerce Products 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.
• Modeled AS IS and TO BE processes using MS Visio.
• 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.
• Documented the evaluation of various reporting tools like Oracle Analytics/Business Objects, made recommendations about the product depending on the reporting requirements
• 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.
• Applied Supply chain Management (SCM) methodologies to ensure coordination in the supply chain.
• Involved in the creation of new E-Commerce Products (Arrival Notices and Customized Reporting) and worked with Front-end and Back-end systems.
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• 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)
• 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, New York, NY

Business Analyst

Responsibilities:

• Led efforts to elicit business requirements for a web content management system (CMS) that will be employed to support the production of the agency's primary website.
• Interfaced with the client as part of the Requirements Engineering team to finalize the project scope.
• Collaborated with theSAPimplementation team to correctly define the requirements and ensure they tie to the correct process areas.
• Facilitated JAD Sessions and gatheredBusinessRequirements
• Assisted with the BRD for the POS implementation project. Managed changes to the POS system
• Define and document CRM specifications for Confidential 's ERP system (NetSuite) for customer support, sales orders and offshore helpdesk
• Create Standard Operating Procedures (SOPs) for use of the ERP System (NetSuite) sales ordering process, logistics and inventory management, RMAs & support call logging.
• Helped in configuringNetSuiteout of box functionality and developing screens and flows inNetSuite to fulfill the requirements of the stakeholders.
• Analyzed current "AS-IS"businessprocesses for potentialbusinessprocess changes as a result ofSAP
• Established average cost methodology utilizingNetSuiteincluding inventory valuation and accurate reporting.
• Assisted the PM in developing Use Cases and project plans and also managed changes to the scope of the project.
• Functioned as the primary liaison between thebusinessline, operations, and the technical areas throughout the project life cycle.
• 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)
• Helped in designing new Web Content Management Repository by analyzing requirements; constructing workflow charts and diagrams; studying system capabilities; writing specifications.
• Prepared reports on analyses, findings, and project progress, and presented results to management and customer personnel for E-Commerce applications.
• Cleaned various documents before sign offs were commenced such as API Specs and BRD's.
• Created complicated use cases to test the current system which led to various defects in the mobile site this gave way to more specific goals for the project's needs.
• Assisted withmerchandisingand marketing tools such as Content Management, Promotions Engine, Search, and Data Feeds.
• Performed extensive Requirement Analysis including data analysis and gap analysis.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
• Involved in inception phase and prepared vision and supporting documents that contained essential businesselements, BRD, and detailed definitions.
• Participated in the logical and physical design sessions, assisted and developed high and low level design documents.
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
• Assisted the PM in performing Risk Assessment, Management and Mitigation.
• Assisted QA testing in formulating the test plans, reviewed QA test plans for appropriate test coverage and managed the Change request documentation for Change management processes.

Confidential - Irvine, CA

Business Analyst

Responsibilities:

• Worked with the agile team to create high level approach/design for solutions.
• Defined detailed business requirements by gathering input from vested business and technical parties to create a BRD and user stories using Excel Sheets.
• Prioritized user stories from product backlogs and helped generate sprint backlogs with Excel.
• Designed the point of sale relevant development for Confidential retail stores. Gathered requirement for the POS software needs for the physical store locations.
• Understood and assisted with merchandising and marketing tools such as Content Management, Promotions Engine, Search, and Data Feeds.
• Generated analysis of product productivity based on position within site, produce reports on position productivity.
• Developed specifications for reporting of ecommerce conversions, engaged visitors, readers, calls of actions, bounce rate, social engagement tracking and email tracking based on Google Analytics
• Participated and assisted with the test teams in deliverable testing and quality assurance review to ensure that all the business requirements have been satisfied.
• Worked with the marketing team to test positions and strategies for driving increases in specific product or category sales.
• Helped create analysis of within site search productivity and make recommendations on improvements which can drive sales increases.
• Assisted in creating weekly checkout funnel analysis to identify opportunities and obstacles to the checkout process.
• Generated cross-sell/up-sell analysis with the marketing team to identify selling opportunities.
• Helped in providing sales, margin and ROI analysis for proposed direct-to-consumer initiatives, and productivity of online destinations and merchandise positions.
• Provided input to IT project plans in areas of high level requirements, approach to testing and release/ implementation planning.