SUMMARY

• 8+ Years of Professional Experience as Business Analyst in Retail, E - Commerce, and Supply Chain Environments.
• Excellent team player works in conjunction with testing, development and other teams in validation and testing complex scenarios and projects and in the maintenance of Quality Standards in Projects.
• Experienced in cloud technology and on premise infrastructure integration for Salesforce.com
• Experience in industry standard methodologies like Software Development Life Cycle (SDLC), Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP), CMM (Capability Maturity Models) and Six Sigma and Rational Tools used during various phases of RUP.
• Excellent track record for meeting deadlines and submitting deliverables on time using AGILE/SCRUM methodology.
• Extensive experience in Gathering Requirements, Scoping Requirement and creating Business Requirement Documents, User Requirement Specifications, Functional Requirement Specifications, System Requirement Specification, Test Plan, analyzing and Creating Use Cases, Use Case Diagrams, Activity diagrams, System Workflow Diagrams, Data Flow Diagrams, Business Flow Diagrams.
• Expert in documenting project plan, Business Requirements Document (BRD), Test Plans, Use Case Specifications, Functional Specifications (FSD) and Systems Requirements Specification (SRS).
• Good experience at B2B, B2C and Ecommerce portals web application developments and CRM.
• Expert understanding of Electronic Data Interchange EDI Process, standards, and transactions.
• Good working experience at Master Data Management (MDM), Identity data, Trade Promotions Management (TPM) and Point of Sales (POS).
• Experience in Gap analysis and implementing updates for the Data Warehousing Applications.
• Experience in 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.
• Experience in facilitating Joint Application developments (JAD) and Joint Requirement planning sessions (JRP), End user interviews, workshops, and requirement elicitation sessions, providing production support, interacting with the business customer to resolve issues during UAT.
• Extensive experience working with FMCG (Fast-moving Consumer Goods) / CPG (Consumer Packaged Goods) clients.
• Expert in business process engineering and software development life cycle methodologies i.e., Waterfall, RUP, Agile, Scrum, and Prototype., including analysis, design, development, gap analysis testing and implementation of software applications.
• Strong working knowledge with ATG Dynamo B2B Commerce, ATG B2C Commerce, Shopping Cart, Product Catalog, Merchandising, Droplets.
• Expert level working knowledge in different verticals and areas like Localization, Mobile-Commerce, SCM and CRM.
• Experience with multiple WMS systems and IT technologies related to WMS systems in a high-volume retail warehouse.
• Experience in Oracle Retail Modules like RMS and RPM and has very good experience in Order Management Application Sterling WMS.
• Extensive experience with MS Visio for drawing flow charts and screen mock ups and MS Project for status reporting and planning.
• Extensive experience in Unit testing, Platform Testing, Acceptance Testing, Functional, Module, Black-box, Integration.
• Excellent communication skills, Interpersonal skills, interacting with team members, leadership qualities, mentoring, ability to work independently.
• Well versed in using project management tools for managing and facilitating the development process using Jira, MS Project, Visual Studio Online.

PROFESSIONAL EXPERIENCE

Sr Business Analyst

Confidential - Cincinnati, OH

Responsibilities:

• Served as primary contact between retail locations and Headquarters in IT POS application issues.
• Developed business requirement updates while working with different user groups to define priorities concerning project development.
• Conducted brainstorming and JAD sessions with stakeholders and end-users for requirement analysis and documented the same.
• Provide support in developing and maintaining ETL processes that extract data from multiple SOR's residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.
• Involved in E-Commerce POS testing Product Search, Payment System, Online transaction process.
• Assisted eCommerce and POS team to clean up backlogs by referencing BRD’s, identified gaps from customer and business perspective & addressed through ambiguity documents.
• Analyzed trends in customer perception, preferences, and behaviors across the ecommerce/website channel through full shopping cart life cycle and customer order history using Omniture system.
• Gathered requirements for a Merchandise Assortment planning tool created for Retail Business that created worksheets of merchandise assortments that were based on location that provided retail stores laid out the detail diagrams.
• Provided daily user support of the WMS Functional modules during implementation.
• Determined the process and wrote unique T-SQL scripts for non-standard data imports for the Merchandising.
• Involved in developing estimates, project plans (Microsoft project), training material, BI reports using Micro-strategy.
• Performed testing on a data warehouse platform, including data integrity and data validation.
• Involved in developing business solutions through implementation of Business Requirement Gathering, Business Process Flow Analysis and Business Process Modeling by utilizing Calibers well as Scenario Based Requirements processes (SBR).
• Used UML during requirements gathering and created Use Case Models and Use Case Diagrams for the purpose of stakeholders in the project to help them understand the workflow of the system associated with the requirements.
• Worked with Scrum Masters (Agile), Product Owners, and Scrum team members to ensure success of Programs, Releases and Sprints.
• Managed primary supply chain interface with warehouse management system (WMS), engineering management & commodity management.
• Analyzed, coordinated, documented, and managed project requirements, project processes and procedures and its changes throughout the software development lifecycle.
• Worked with Multi-Channel Fulfillment & Inventory Management, Order Management and Omni channel retailing
• Performed Requirements Analysis and traceability using Test Director and MS Word.
• Involved in developing prototypes to demonstrate the new UI for stakeholders.
• Involved in writing test plans, defining test cases, test scenarios and data sets.
• Worked with Subject Matter Experts (SME), project team members (business and technical), to define technology application for the business and system requirements.
• Also worked with the QA Team Lead to develop QA standards and ensured compliance with all regulatory requirements.
• Involved in developing several MS Excel spreadsheets and applications to automate manual calculations and optimize reporting structure.
• Extensively used MS Project for status reporting and planning throughout the project lifecycle.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes and participated in Stakeholder Management to communicate effectively with them.
• Involved in SQL queries to filter data and reviewed TSQL/SQL queries and stored procedures to process, analyze and implement data integrity initiatives for various business units.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution. Tracked change requests and monitored workload and schedule.
• Worked closely with SAP, ERP, Tally, Oracle software, WMS.
• Documented detailed level requirements in the form of User Stories for various functionalities like Promotions, Product Detail Page, Shopping Cart and Checkout.
• Worked comprehensively in the industrial environment in Supply Chain Management, Procurement, Planning, Logistics, Commercial Operations, Distribution, Warehouse & Freight Management and Budgeting.
• Involved in defect review, checkpoint and root cause analysis meetings and tracked defects in the Quality Center.

Sr Business Analyst

Confidential - Atlanta, GA

Responsibilities:

• Gathered detail level business requirements through open-ended discussions, brainstorming sessions, and requirement workshops.
• Involved in developing several detail and summary reports including line and pie charts, trend analysis reports and sub reports according to business requirements.
• Gathered requirements for both B2B and B2C parts of the project. Analyzed B2C and B2B web properties and created new business plan, business requirements, and staffing requirements.
• Performed data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Worked on TSYS applications for credit card processing catalogues, search tools, checkout and payment gateways
• Support major effort to improve the Warehouse Management System (WMS) capabilities of Supply Chain.
• Responsible for providing analytical support to Sales Support/marketing and internal sales group clients of WMS.
• Investigated and resolved issues within Supply Chain module as well as WMS (Warehouse Management System)
• Performed end to end system testing of the customized ATG BCC tool. Preparation and execution of business scenarios to validate the implementation of the ATG ecommerce suite.
• Analysis of the workflows and use cases demonstrated by the third-party vendors as part of the vendor selection.
• Involved in creating business processes and modeling diagrams using MS Visio.
• Created Mock-up forms in MS Excel for better visualization and understanding of the software solution.
• Tracked change requests and monitored workload and schedule.
• Facilitated JAD sessions with management, development team, users, and other stakeholders to refine functional requirements.
• Worked with Business to suggest different configuration in DOM (Manhattan Distributed Order Management) with POS / WMS (Manhattan Warehouse Management System) for handling orders better and to increase sales and to provide better customer experience.
• Used SQL, Data Warehousing and Data Cleansing for the arrangement of customer data. Used Data mapping for collecting the data.
• 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.
• Updated reports, queries, stored procedures using Visual Studio, SQL Server and SQL Server Reporting Services.
• Support WMS users in their daily business solutions including system training and production issue troubleshooting.
• Documented the processes of Regional Distribution for the B2B and B2C System.
• Scheduled meetings with developers, System Analysts, and testers to collaborate resource allocation and project completion.
• Authored progress and completion report which were then submitted to project management on a weekly basis.
• Analyzed and triaged defects for System Integration Testing and end-to-end testing.
• Assisted Testing Team on preparing the test cases and expected results for System Testing and Unit Integration Testing.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Involved in execution of test cases manually for various job submissions in batch processing by using the Test Director/Mercury Quality Center
• Consolidated the meeting minutes and the open issues tracker.
• Involved in developing various interfaces and Reports using AS400 technology across different modules like Picking, Packing, and shipping modules of WMS and Order Management module for Retail domain.
• Maintained and kept track of business requests for enhancements and changes.
• Verified the functional aspect as per the Business Process and validated the interfaces with the other systems and data conversion from the legacy system.
• 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 ecommerce suite.
• Created and managed project templates, use case templates, requirement types and traceability matrix in Requisite Pro.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.

Business Analyst

Confidential - Cincinnati, OH

Responsibilities:

• Interfaced with the client as part of the Requirements Engineering team to finalize the project scope.
• Interacted with Business Owners, Users, and Stakeholders to identify Business System Needs, evaluated solutions for business problems, and prepared Business Requirements Document (BRD) and later translated them into Functional Requirements Document (FRD).
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Developed prioritized high level requirements matrix for both B2C and B2B that detailed current and future state needs.
• Worked on ATG merchandising, Carrier delivery management, Inventory Management, for e-commerce application enhancements and designings.
• Partnered with Hybris, an industry leader with expertise in both B2B and B2C ecommerce.
• Assisted the PM in developing Use Cases and project plans and managed changes to the scope of the project.
• 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.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project life cycle.
• Used Unified Modeling Language (UML) for process modeling and use cases.
• Prepared user training manual for merchandising team on managing commerce assets through ATG BCC (Business Control Centre).
• Developed Software Development Life Cycle documentation SDLC (testing, technical and functional documents)
• Conducted user interviews, gathered Requirements, analyzed the Requirements, and managed changes using Rational Suite.
• Involved in Implementing, enhancing and support solutions to meet client's needs using demandware ecommerce platform.
• Reinterfaced between Business new product builders and System platform builders.
• Worked with systems area to translate business needs into system requirements.
• Assisted QA team in performing Unit testing, System Integration Testing (SIT), End to End testing (E2E) and User Acceptance Testing (UAT).
• Experience working as Joint Application Development (JAD) facilitator and meetings coordinator with excellent interpersonal skills.
• Responsible for all Distribution Center and Inventory Control projects from initiation to implementation.
• Analyzed and make sure the test cases and test process guarantee accountability to business and systems requirements.
• Involved in all phases of the SDLC, SQL, Agile, perform UAT testing. Translated, communicated business requirements into detailed technical system specifications, developed use cases.
• Involved in implementation of data governance, master data management, ETL, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modelling.
• Conducted review sessions on a regular basis with QA and development teams for preparing status, delivery report and client reporting.
• Conducted interviews with end-users to collect requirement and business process information.
• Maintain, extract, review and analyze data from various data sources like Data Warehouse and WMS systems to ensure correctness, completeness, and integrity using SQL and Tableau.

Business Analyst

Confidential - Carmel, IN

Responsibilities:

• Prepared questionnaire based on the System Analysis performed for all entities.
• Involved in developing 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 Salesforce Commerce Cloud (demandware) and SAP Hybris capabilities.
• Involved in E-Commerce POS testing Product Search, Payment System, Online transaction processing.
• Involved in enhancing and supporting solutions to meet client's needs using demandware ecommerce platform.
• Considered Unified Dimensional Model (UDM) using views, Unified Modeling Language (UML) and object-oriented design.
• Participated in design and build of different OMS modules - Order Capture, Order Processing, Order Promising & Fulfillment, Payment Processing and Reverse Logistics etc.
• Responsible for generation of project artifacts such as Charter, Business Case, Detailed (Functional/Non-Functional) Requirements, SharePoint documentation.
• Responsibility to map and test data requirements for futures, options and other derivative instruments into existing trade order management system and back-office accounting.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Collaborated with Order Management (OM) and Supply Chain Management (SCM) team members.
• Conducted extensive Joint Application Development (JAD) sessions for all business-related issues.
• Maintained records and statistical information for E-Commerce managers, E-Commerce personnel, other departments and outside vendors
• Determined project scope and engineering requirements, estimated schedules, tracked item completion, certified milestones and maintained project documentation and corporate e-commerce web site Testing.
• Established connectivity to all major buy-side vendor order management systems (OMS).
• Involved in project scope meetings with the Pricing manager to understand the type of requests and issues handled by the pricing team and documented the high-level business requirements to the product backlog using JIRA Agile.
• Prepared High Level Logical Data Models and BRD's (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Identify customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
• Responsible for importing the data from Crystal reports by using Business Objects Live office into Microsoft Excel and Word.
• Provided data modeling support for numerous strategic application development projects.
• Involved in the process of QA Life Cycle, which includes Designing, Developing, Execution and Documentation of the Test Cases, Automated Test Scripts, Test Plans and UAT.
• Involved in implementation of data governance, master data management, ETL, data warehouse, data marts, reporting, dashboard and analytics
• Used MS Visio to create Flow diagrams and Use Case Diagrams.
• Created and executed detailed test cases for testing the application on Android and iPhone.
• Created test scripts for all the test cases in PL/SQL.

Business Analyst

Confidential - Atlanta, GA

Responsibilities:

• Worked closely with technology and business user staff to complete workflow improvement and document functional specifications for systems
• Maintained and updated all the POS related FSD (Functional specification document) at the end of every release
• Involved in requirements gathering and system analysis through RUP of an online portal to provide visibility to corporate customers.
• Developing Use Case Models, Entity Relationship Diagrams (ERD), Activity Diagrams, State Diagrams and Data Flow Diagrams (DFD).
• Facilitated collection of functional requirements from system users and preparation of business requirement documents using Rational Requisite Pro.
• Involved in MDM to help the organization with strategic decision making and process improvements.
• Involved in working on initial solution design using IBM Infosphere MDM software.
• Followed agile methodologies in executing the project with daily standups, discussing roadblocks, documenting issues with JIRA tickets and updating the status
• Distributed Agile assigned tasks among the development team, liaised with clients to better understand their needs and present solutions using a structured SDLC approach.
• Worked on the Data Modeling, Entities and Attributes of the Data points and Templates.
• Involved in preparing interview questionnaires for the clients to gather requirements and prepared Functional Specifications and User Requirements.
• These specifications included UML-based use case models and activity diagrams, and usability analysis/user interface specification including wireframes and usability analysis.
• Prepared for each sprint, ensuring all stories are fully defined with user journeys, user stories
• Involved in developing business requirements documents (BRD), User stories, User requirements and functional requirements.
• Prepared Use Case Models based on Business Requirement documentation gathered through interaction with users.
• Automated sales reporting using MS Excel queries, SQL in Teradata, and MS Access.
• Produce performance reports and implement changes for improved reporting. Interface with internal customers
• Involved in working on SQL Server and T-SQL in constructing triggers, tables, indexes, user profiles, relational database models, data dictionaries, and data integrity
• Prepared Flow Diagrams, Sequential Diagrams in MS Visio.
• Conducted Previews and User Acceptance Test (UAT) sessions with the marketing team.