SUMMARY

• Extensive working knowledge of all the phases of Software Development Life Cycle (SDLC) and have hands on experience working in waterfall; agile methodologies Scrum, Kanban & Scaled Agile Framework (SAFe 4.0); hybrid methodologies Water - scrum-fall, Scrumban. Knowledge of Extreme programming (XP), Spiral methodologies.
• Highly skilled in structured planning methods for project evaluation like GAP Analysis, SWOT Analysis, Cost-benefit Analysis, Feasibility Analysis, Risk Analysis to assist Project Manager in Release Planning & Product Owner in setting good stakeholder expectations.
• Specialized in developing and executing IT and business strategies for Lean manufacturing, Demand Forecasting and SKU rationalization processes in areas like warehouse-slotting, Transportation management & vendor analysis, Order & Inventory management, Workforce & Labor Management and Customer Relationship Management to produce value to the business customers.
• General knowledge in operations of lean methods, waste elimination, 5S, Total Productive Maintenance (TPM), flow and error proofing (poka-yoke) by performing root-cause analysis and value stream mapping.
• Led Kaizen or Continuous Improvement events for improving teams and lean manufacturing techniques and performed Cost Benefit project reporting analysis, Project Charter, Work breakdown Structure, Project planning (PMO) on Six Sigma development projects.
• Diligently worked on technologies like Salesforce CRM, Manhattan WoMS, MULE ESB’s integration with SAP ERP, and Amazon Web Services platform & its components in various projects related to supply chain planning.
• Skilled in conducting and facilitating Requirement Gathering Activities to gather SMART (Specific, Measurable, Attainable, Realistic and Timely) requirements using diverse elicitation techniques including, but not limited to Interviews, Requirement Workshops, Prototyping, Survey/Questionnaire, JAD Sessions and Brainstorming.
• Excellent Business writing skills in drafting High Level Document (HLD) like Business Requirements Document (BRD), Functional Requirement Document (FRD); and Low-Level Documents (LLD) like Functional Specifications, Systems Requirements Specification (SRS), Data Specification Document, Workflows, and User Story.
• Assisted PM in preparing Project Schedules, establishing Milestones & creating Work Breakdown Structure (WBS).
• Detailed understanding of RACI chart to manage overall project risks & mitigation plans, prepared Requirement Traceability Matrix (RTM) to map requirement with its origin throughout the process to verify adherence.
• Assisted Product Owner in defining minimum viable product (MVP) features of the application under development.
• Excellent knowledge of Unified Modeling Language (UML) diagrams including Activity Chart, Use Case Diagram, and Sequence Diagram to support business process flow around entities and in identifying primary actors.
• Experienced in creating Wireframes and Mock-Up Screens to visualize Graphical User Interface (GUI) as to understand the layout of the interface using tools like Balsamiq, Lucid Chart, and MS Visio and get them validated.
• Strong experience in Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services. Utilized different ETL tools like Informatica power center, SSIS. Designedand implementedSQLqueries, stored procedures; utilized joins,unions,group byandaggregatefunctions to extract data.
• Assisted Data Architect in creating Data Models like Conceptual data model and logical data model in the form of entities and relationships to capture the user requirements properly in the underlying database.
• Practical knowledge of Data Warehousing architecture, implementation approaches, dimensional modeling and translating the business requirements into various types of dimensions like snowflake schema, star flake schema and galaxy schema, and performed source to target mapping and created Data Mapping Specification Document.
• Performed Rollup, Drill down, Pivot, Slice and Dice operation on OLAP cubes to provide timely, accurate insights.
• Experience in implementing Service Oriented Architecture (SOA) using Web Services (SOAP, REST, XML, JSON)
• Documented requirements for API development i.e. was responsible for technical writing of both XML and JSON utilizing API. Used SOAP UI and Postman for API testing. Used Swagger tool for API documentation.
• Proficient at supervising Manual Testing, Automation testing, Black-box Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, Security Testing, Load/Stress Testing and Performance Testing along with User Acceptance Testing (UAT) and helped in designing and developing test plans
• Exposure to Web Analytics for e-commerce website using Google Analytics, Einstein Analytics and Adobe Analytics for intelligent data collection and analysis.
• Comprehensive experience and knowledge in using Data Modeling and Business Intelligence tools IBM Cognos, TABLEAU, Microsoft SSIS, IBM Infosphere MDM.

TECHNICAL SKILLS

Requirement Management: Atlassian-JIRA, CA Agile (Rally), HP-ALM, iRise and VersionOne

Project Management Tools: Microsoft Office: Excel, Word, Lotus, VISIO, MS Project, PowerPoint, Web conferencing, Confluence

Business Modeling tools: Oracle Enterprise Report Builder, COGNOS BI, Informatica Power Center 8.x/9.x, SSIS

Modeling Tools: MS Visio, Draw.io, Google Drawings, iRise

Testing Tools: HP Quality center, Selenium, Load Runner, Cucumber, Swagger, SoapUI

Web Service: SOAP, REST, AJAX, XML, JSON, WSDL, WADL, XSD, DOM

Reporting Tools: Tableau, MS office suite, Google Analytics, Oracle BI

Languages: C, C#, SQL, CSS, XML, HTML5, JAVA, JAVAScript.

Databases: MySQL Server, DB2, Oracle Developer, PL/SQL, SAP HANA DB, SQL Server 2000.

PROFESSIONAL EXPERIENCE

Sr. Business System Analyst

Confidential, Menomonee Falls, Wisconsin

Responsibilities:

• Performed AS-IS & TO-BE business process utilizing Visio, GAP analysis, created business process model (BPM)
• Documented the Functional and Technical Specifications requirements based on the business flow for Material Management and Inventory Management in the existing Legacy systems.
• Conducted several workshops with the business team to understand and document the business purpose and data owners of all the attributes and developed business rules for systems integration.
• Assisted Product owner for end to end deliverable of Project Plan, POC, created wireframes and mock-up screens utilizing Balsamiq and got them validated by stakeholders.
• Actively assisted the product owner in prioritizing the product backlog as per the maximum business value, grooming User Stories in planning activities using INVEST criteria and prepared the test cases.
• Utilized Mulesoft ESB for SAP ERP and WMS Integration to fetch the data and send to related systems to automate business process like order to cash and source to pay.
• Participated in various Scrum ceremonies like Sprint Planning Meeting, Daily Stand-up Meeting, Sprint Review Meeting, Sprint Retrospective Meeting, and Backlog Grooming and achieved towards a release goal.
• Extensively used JIRA while assisting PO & Scrum Master to record and maintain the artifacts such as Product backlogs, Sprint backlogs, user stories
• Impediments list, tasks, defects, and issue tracking using in JIRA issue tracking tool.
• Worked with master data management (MDM) which include data collection, data transformation, normalization, data consolidation, data storage, data distribution, data classification as per Online Analytical processing (OLAP)
• Extensively worked on identifying data sources and enabled the data cleansing and profiling to avoid data complexity, data duplication and data redundancy.
• Extensively used AWS Glue for extraction, transformation and loading process from ERP and WMS data sources to S3 buckets and further to Redshift.
• Performed SQL validation using AWS Atana to verify the data extracts and record counts in the database.
• Prepared testing schedules and coordinated testing activities and worked closely with internal business groups and third-party vendors to ensure the successful implementation of new modules.
• Managed the testing process of the application with the client and vendor resources. Documenting positive and negative test scripts/cases, tracking & managing resolution issues, executing test scripts and documenting results.
• Used HP Quality Center 11.5 for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
• Worked with Integration Test Lead to develop test scenarios and test cases; Conducted Integration Testing and Interface Testing for Make to Deploy (QM/PP), Procure to Pay (MM/SRM), Plan to Schedule, Order to Cash (SD), Hire to Retire (HR), Record to Report (FI) and Lead to Customer (CRM) business processes (BPs).
• Involved in providing Production Support, User Training, and problem resolution in almost all areas of SD, MM, PP, ME, FICO Modules and Cross-Functional Applications.
• Involved in systems integration testing, web services API testing using SOAP UI and Postman API testing tools. Assisted in development of end-user documentation with user manual.

Environment: Scrum, JIRA (v.7.0), Confluence (v.6.4), Mulesoft ESB (v.3.7), AWS QuickSight, Amazon Forecast, Amazon Glue, UML, Balsamiq, HP Quality Center (v.11.5), S3 Buckets, Redshift.

Sr. Business System Analyst

Confidential, Greensboro, North Carolina

Responsibilities:

• Conducted requirement walkthrough to understand the benefits of the new system being implemented.
• Performed GAP analysis by creating AS-IS & TO-BE documents to identify existing system, current business process, methods to identify deficiencies, areas for Process improvement & enhancements
• Carried out Cost Benefit analysis to check the net benefit and the feasibility of the project.
• Analyzed the changes performed in CRM application for marketing, sales etc, translated them to business & functional requirements for Sales and Service Cloud in Salesforce Development Cycle (SFDC).
• Executed a Salesforce automation program with various modules like leads module, commission module and a forecasting module for boosting the product sales of the organization and its management.
• As a Business Analyst, I determined system and integration configurations, performing configurations, set-up changes, and worked with users to provide training troubleshoot and assist in problem resolution.
• Created Users, Roles, Public group, implemented role hierarchies & record level permissions to manage sharing access among different users on marketing cloud in SFDC.
• Responsible for creating & documenting user stories, business rules, workflow diagrams & business process modeling (BPM), Change Management for the proposed functionality.
• Assisted in adding new custom objects, assigned fields, designed pages, components & custom reports in SFDC.
• Captured user requirements in the form of User stories and defined Acceptance criteria for each of them.
• Closely worked with scrum master in creating burn down chart, task board updates & Product Backlog.
• Expert in design, configuration, testing, and debugging of SAP Inventory management and Warehouse management modules. Understood the integration points between the SAP MM/PP/PM modules and inter-dependencies.
• Attained understanding of SAP ABAP development in SAP PP, FI/CO, SD, MM, QM areas with Full cycle implementation and maintenance projects, and have experience of SAP ERP and HANA system.
• Facilitated meetings with Salesforce Admin, developers, architect to determine the data dat should be integrated into salesforce platform, as it was used for powerful data integration of OMS and IMS.
• Involved in identification and documentation of salesforce API’s like REST, SOAP, BULK, Analytical API’s.
• Used Mulesoft’s Anypoint Platform for Salesforce Integration to simplify the process of merging data, updating Salesforce with ERP data in real time, ensuring data consistency across Salesforce instances.
• Creating and integrating API’s dat pulled data from multiple systems; and reviewed Test case, Test data & Test Scenario to make sure tests should perform properly.
• Closely monitored & performed Smoke tests, Facilitated UAT sessions, worked on defect life cycle using JIRA.
• Created various Reports & Dashboards with Tableau to assist managers to better utilize Salesforce components like Sales Cloud, Marketing Cloud, Service Cloud & Analytics Cloud.

Environment: Scrum-SAFe(v.4.0), Jira(v.7.0), Confluence(v.6.4) Salesforce, SAP S/4 HANA, SAP ERP, SAP PI, SAP ABAP, Sales cloud, Analytics Cloud, Chatter, Einstein analytics, Fishbowl Demand Planning Tool, Windows 10, MS Office(2016), Tableau (v.10.0), Selenium (v.3.5), Swagger(v.3.0), MuleSoft ESB(v.3.7), SOAPUI.

Business System Analyst

Confidential, Richfield, Minnesota

Responsibilities:

• Analyzing customer ‘AS IS’ business process and mapping ‘TO BE’ business processes.
• Prepared Business Requirement Document (BRD) from the elucidated requirements and helped the Product Owner and Development Team in writing User Stories by using Three C’s and make stories to meet INVEST criteria.
• SAP Configuration of MM-IM requirements, including Plants, Storage Locations, MRP and Forecasting data. As well, the Purchasing requirements for internal sources (Stock Transfer Orders), including Purchasing Groups. Developed mock-ups and wireframes along with the screen designs to make better UI designs.
• Helped the team to split user stories into tasks meeting the SMART criteria. Values of collaboration and agile principles and explained the team how important was to operate as a self-organizing entity.
• Gathering MM, TM, FM and WM business process procedures (BPP) documentation for preparing Test Plan.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Assisted Data modeling process by creating conceptual and logical ER diagrams and designing database schemas like snowflake schema and galaxy schema to help development of an accurate Data Warehouse Structure.
• Assisted core team members for designing and configuration of SAP MM, WM, and SRM modules- Warehouse goods receipts and issues, cycle counting process, warehouse replenishment, WM interface to QM and configuration of master data including material master, and bins/warehouses/storage locations.
• Guided large development teams, including Backlog Refinement, Sprint Planning, Daily Stand Up, Retrospectives, Management Reporting, and presentation of Sprint results to the Client
• Actively involved in the Testing functionality of Purchase Requisitions, Shopping Carts and Purchase Orders in DEV/ QA instances before Migrating to UAT and PROD Instances.
• Working with Integration Testing Lead to developing Testing scenarios; String testing, Integration Cycle Testing and Interface Testing for Make to Deploy (QM/PP), Procure to Pay (MM/SRM), Plan to Schedule, Order to Cash (SD), Hire to Retire (HR), Record to Report (FI) and Lead to Customer (CRM) business processes (BPs).
• Used Postman to Test and Document SOAP & RESTful using GET/POST/UPDATE/DELETE methods.
• Involved in providing Production Support, User Training, and problem resolution in almost all areas of SD, MM, PP, FICO Modules and Cross-Functional Applications.

Environment: Scrum Hybrid, ASAP Methodology, SAP systems, SD, MM, PP, ME, FICO, components and tools: SAP ERP R/3, SAP Solution Manager, HP Quality Centre (v.11.4), IBM Rational Functional Tester, Load Runner, Jira (v.7.0)

Business Analyst

Confidential

Responsibilities:

• Followed a structured approach to gathering and formalizing business requirements expressed by managers, process owners and operational users of the information system in Water Scrum Fall environment.
• Analyzed inventory requirements from B2B & B2C clients and based on sales developed a process to optimize orders dat 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.
• Led, developed and implemented process improvement tools to maintain optimal inventories throughout the supply chain process by researching and validating order management, fulfillment & distributed inventory processes.
• Gatheird and implemented requirements around reporting and dashboards of key Supply chain KPI’s based on product offerings, historical sales data, order history and partner fulfillment data across key business groups.
• Conducted JAD sessions with end-users to identify user requirements and to collaborate with developers for application development and was involved in designing user interfaces for developing prototypes
• Captured system requirements by writing Use Cases developed procedures for processing of data and made process flow diagrams involved in reviewing Entity Relationship Data Flow, State transition and class diagrams.
• Developed Test Cases to validate the requirements and documented the Requirement Traceability Matrix for keeping track of all the Test cases and user requirements till they are executed.
• Interfaced with developers to identify and resolve technical issues and bugs in the software and also validated requirements with development, testing & production teams concerning release management policies & procedures.

Environment: Water-scrum-fall Methodology, HP ALM (v.12), NetSuite ERP (2010), SAP Power Designer (v.16), Microsoft office (2010), MS Project (2010), MySql (v.5.6), MS Visio (v.1.4), Selenium (v.2.22), Tableau (v.7.0)

Business Analyst

Confidential

Responsibilities:

• Involved in creating the Project initiation document (PID)
• Was responsible for Cost benefit analysis, Risk assessment, and SWOT analysis.
• Conducted GAP Analyses by understanding the AS-IS business process and TO-BE business process.
• Helped the Product owner to come up with the requirements in the form of user stories
• Wrote Business rules pertaining to shipping functionality.
• Participated all the scrum ceremonies, namely: Sprint Planning meeting, Daily Scrum Meeting, Product backlog refinement meeting, Sprint Review meeting and Sprint Review meeting.
• Was Responsible for creating use case diagrams, activity diagrams and sequence diagrams.
• Used Web Services to connect the shipping services to the existing system with SOAP API.

Environment: Agile-Scrum, Oracle, Java, XML, Java Script, Oracle Warehouse Builder, Rally, TFS, MS Access, MS EXCEL, MS Word.

QA Tester

Confidential

Responsibilities:

• Worked closely with the Functional Team and the Development Team in understanding the Functionality and the Design Document of the Application.
• Involved in the creation of Test Scripts, executing tests and tracking defects
• Involved in developing test cases for Smoke, Integration, System and Regression testing
• Performed backend Testing using multiple SQL queries.
• Writing and Executing the positive and negative test cases based on the functional specification document
• Validated the functional scenarios based on business scenarios
• Performed Manual testing for the test cases
• Responsible for updating and maintaining Quality Center for all the defects found during functional and regression testing and follow up the bug life cycle
• Attended daily defect status meetings and weekly team status meetings for reporting testing status and shared ideas for improved testing efforts.
• Tracking defects and assigning bugs to developers for fixing.

Environment: Waterfall, Oracle, Java, XML, Java Script, MS Access, HP Quality Center, MS Excel.