PROFESSIONAL SUMMARY:

• Business Systems Analyst with 8+ years of experience in Business Development Process, System and Data analysis.
• Experience in E - commerce and Supply Chain.
• Have extensive experience with the entire (SDLC) that included Requirement Gathering Elicitation, Analysis, Design & Development and change management through all the phases.
• Have hands on Experience on Methodologies Waterfall, Agile Scrum Waterfall-Scrum Hybrid, Kanban, Extreme programming,
• Excellent Analytical, Problem solving, Communication and Documentation skills. Dedicated & Self- motivated, Proven leadership capabilities and Time management skills. A proactive and dedicated team player, with proven track record in producing high quality work under tight deadlines and multi-tasking to meet business goals. Experience in scheduling meetings, negotiating and co-ordination with Developers, Application Architects, Subject Matter Experts and business users.
• Strong functional expertise in Procure to pay(p2p), procure to order(p2o), order to cash(OTC), Business to Business(B2B), Business to Consumer(B2C), Order & Inventory Management, & Supply chain Management.
• Excellent understanding of business process in Material management(MM), Warehouse Management(WM), Production Planning(PP), Financial Accounting(FI), Sales and Distribution(SD), customer relationship management(CRM) and Content Management (CM).
• Experienced in working with stakeholders to identify key performance indicator (KPI), and service level agreements (SLA) for Inventory management, Buyer-Supplier Relationship.
• Assisted in maintaining Compliance requirements for varying and changing regulations such as serialization/ePedigree, RoHS, WEEE, REACH and others. And tracking transaction in compliance with NACHA operating rules.
• Proficient in networking with individuals at various levels while organizing, conducting and facilitating Elicitation sessions such as survey/questionnaires, Interviews, Brainstorming, Focus group, interviews, Requirement workshops, Interface analysis, Document analysis, prototyping (like wireframes and mockup).
• Facilitated Joint Application Development (JAD) sessions, Conflict Management with project team & stakeholders.
• Created and Maintained work break down structure(WBS), project schedules, Project Management Plan using Microsoft Project to manage deliverables, assign resources, allocate budget, project completion date and identify critical path.
• Extensive years of experience in Business process re-engineering, Business process improvements, Historical Data Reports Analysis and creating Business Requirements documents (BRD), and System Requirements Specifications (SRS), Functional Requirement Specification (FRS).
• Certified Scrum Master (CSM) with proven ability to work with self-organizing and cross-functional teams. Facilitated Sprint Ceremonies (Backlog grooming, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective) for Agile Scrum Methodology as Scrum Master. Experienced in writing User stories and handling the Requirement Churn.
• Efficient in performing, prioritizing techniques, MoSCoW, KANO and Business Value Based. Experience in Using Estimation techniques, Planning Poker, T-shirt sizing, Relative mass evaluation.
• Well acquainted with workflows and Unified Modeling Language (UML) diagrams including Use Cases, Activity Charts, Sequence Diagrams, Data Flow Diagrams, and ER Diagrams using Visio.
• Experience supervising Black-box Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load/Stress Testing, Performance Testing, Smoke testing and Sanity testing using HP Quality center/ HP ALM.
• High experience in tracing requirements throughout the development process and verifying to Requirement Traceability Matrix (RTM) and drafting Test plans, Test cases, Test procedures and Test Scenarios and involved in Test Planning, Test Preparation, Test execution, Issue Resolution and Report Generation to assure that all aspects of a project are in Compliance with Business Requirements.
• Executed SQL Statements, created views, joins and stored procedures for backend operations to make sure the data is mapped properly without any defect or error.
• Extensive implementation knowledge of Databases, Data Table structures, star and snowflake Schemas, Data Marts. Integrated OLTP and OLAP operations such as Roll-up, Drill-down, slice and dice and pivot by using SSIS/SSAS as an ETL tool and used SSRS as reporting tool. Also maintained the Bill Inmon and Ralph Kimball Paradigms.
• Involved with extensive client interactions and converting Business functionalities into Service Oriented Architecture (SOA) models across heterogeneous IT environments.
• Deep understanding of three-tier architecture and performed web service testing using SOAP UI and documenting XML and JASON, and automation of SOAP and REST API with methods such as GET/POST/PUT/DELETE
• Experienced in conducting Data Analysis & generating reports using R, Tableau, Power BI & JIRA.
• Analyzed performance of website through Google Analytics, Customer Acquisition & Retention rate, Search Engine Optimization(SEO) & Google AdWords strategies, Call to Action(CLA), and Net Present Value(NPV).
• Good Understanding of Project Management activities, proficient with Project Management Tools, testing tools & defect reporting tools. Possess good knowledge of validation scripting like JavaScript, HTML5, CSS3.

TECHNICAL SKILLS:

Methodologies: Waterfall, Spiral, Agile, SCRUM, Scrum-Waterfall Hybrid, Kanban and SAFe 4.0

Ecommerce tools: Google Analytics, Google AdWords, SEO and Salesforce

Supply Chain tools: SAP ERP, SAP R/3, SAP SD, MM, PP and FI

Project Management Tools/Methodology: Unified Modeling Language (UML), MS-Project, MS Share Point 2013, Rally, JIRA, Agile-Scrum, Waterfall-Scrum, Waterfall, Kanban and SAFe4.0

Requirement Management: MS Office, JIRA, Confluence, HP ALM 11.5.

Reporting Tools/BI: IBM Cognos, Tableau, Power BI, R studio and MS Excel

Database/ETL: MS-Access, SSIS, SQL Server 2000/2005, MySQL, Oracle, Informatica.

Testing Tools: HP QC, HP ALM 11.5, Cucumber, HP UFT postman, SOAP UI, Gherkin, Bugzilla.

Languages: XML, JASON, HTML5, CSS3, Java

Data Warehousing: Data Marts, Data Modelling, OLTP, OLAP, Data Mining, Slicing/Dicing, RollUp/Drill Down.

Business Skills: Change Management, Conflict Management, Impact Analysis, Project Planning, Project Scheduling, Budgeting, Root-Cause Analysis, GAP Analysis, SWOT Analysis, CLV, Value Proposition, Bounce Rate, Porters Five Forces, PESTLE Analysis, Value Chain Analysis, ROI, 5 P s pf marketing, Price strategy (3 C s), Economic order quantity, Bullwhip effect and white board animation.

WORK EXPERIENCE:

Confidential, Richfield, Minnesota

Senior Business Systems Analyst

Responsibilities:

• Worked on hybrid Waterfall-Scrum project with demanding standards for requirements gathering. Communicated project status to internal IT and business teams. Elicited requirements from Business users through JAD sessions, Surveys/Questionnaire’s, Interview’s, Focus Groups and analyzed feasibility.
• Assisted in Project Planning & implementation for bringing productive results and drafted all necessary documentation that includes Project Charter, Business Requirement document(BRD), Functional Requirement specification, system requirement specification(SRS), communication Plan and Risk Register. Conducted GAP Analyses by understanding the AS-IS business process and TO-BE business process. Assisted in identifying risk needed to develop Risk analysis.
• Conducted User Story Writing Sessions to decompose BRD into User Stories and determine Acceptance Criteria for Potentially Shippable Product Increment.
• Highly proficient in creating User stories, Use Case, Activity, Sequence, and Class Diagrams using MS Visio etc.
• Worked closely with ABAP Developers. Assisted in Integrating CRM Middleware as an ESB to provide bi-directional communication and execute any standard and custom BAPI in SAP so that SAP ECC 6.0 and SAP CRM are linked properly.
• Managed SAP Reporting project by successfully implementing 10 new reports for SAP SD, MM, PP-PI and QM and identified reporting requirements and coordinated the reports creation with ABAP developers to create ABAP Query reports and conducted testing and training. Communicated with ECC team, SME’s and support specialist on the stream of Request/Response APIs (IDoc to XML) flow so that all are aligned with need of the business and security.
• Assisted in performing Data Mapping, Logical and Physical data modeling, created entity relationship (ER) diagrams and used SQL statements to select and filter data within database.
• Designed data models and conducted normalization and de-normalization of data to fit OLTP and OLAP frameworks, slicing and dicing of data marts for analytical decision-making support.
• Responsible for verifying browser interactions with database using SQL statements creating views, joins and stored procedures for back-end operations to make sure the data is mapped without any defects or errors.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements. Manual testing using Selenium.
• Designed Test Cases, Test Plans, Test Scripts, and Test Scenarios to perform Functional Testing, and Regression Testing and logged down defects using JIRA. Logged and tracked the defects using HP ALM and created an error repository and managed the testing process with the QA team. Defined Requirements to perform User Acceptance Testing.
• Used postman to Test and Document SOAP & REST APIs using GET/POST/DELETE methods in XML/JASON format.
• Performed SOAP API testing using SOAP UI and WSDL file to validate the data and creating artifact which included use of SOAP API to create, retrieve, update or delete records, such as accounts and leads. Worked on (SOA). conducted due diligence of our suppliers and utilize analytics to obtain additional insights on supplier financial viability, contract compliance to service level agreements (SLAs), and third-party affiliations
• Assisted in the creation of deployment flow chart in conjunction with development, infrastructure, and network teams containing information for maintaining Application.
• Created ad-hoc reports on Microsoft Excel using graphs, pivot tables & Lookup functions for calculations.

Environment: SDLC, waterfall Scrum - Hybrid, MS project, MS Office, JIRA, SAP ECC 6.0, SAP CRM, SAP GUI(html), ABAP, SOAP, XML, API, Share Point, Visio, iDoc, HP ALM, JAVA, MS Visio, Risk Management.

Confidential, Ada, MI

Senior Business Systems Analyst

Responsibilities:

• Provided clear and consistent information about project status both internally to IT team and stakeholders. Conducted Joint Application Development (JAD) sessions with Subject Matter Expert (SME).
• Elicited business requirements for the project using interviews, document analysis, surveys, site visits, use case scenarios and also used standard template of the organization to develop requirements.
• Analyzed and gathered functional and technical requirements for preparation of Business Requirement Document (BRD), Functional Requirement Document (FRD) and System Requirement Specification (SRS).
• Prepared Requirement Traceability Matrix and interacted with QA team to ensure quality of software.
• Incorporated Scrum Events Backlog refinement, Sprint Planning, Stand up meeting, Sprint Review and Sprint Retrospective.
• Assisted while integrating the Mulesoft to provide communication and execute any custom and standard BAPI in SAP so that two systems are linked properly.
• Facilitated various scrum ceremonies like Backlog refinement activity, Sprint planning meeting, Daily Scrum meeting, Sprint review meeting and sprint retrospective meeting using various techniques.
• Encouraged team to adopt engineering practices such as Test-driven development(TDD) and Acceptance Test Driven development (ATDD) along with Continuous Integration(CI) and regression testing (RT).
• Coached teams to use behavior driven development (BDD), write effective user stories using INVEST criteria, and task using SMART criteria, defined Acceptance criteria and used Estimation and Retrospective technique like planning poker, T-shirt size, Relative mass valuation, ORID and silent writing.
• Prepared Business process models; used Visio to create process flow diagrams for management and mapping the logical aspects of the process. Used SQL queries to select retrieve and update data from SQL Server and create business reports.
• Established migration and testing of Master Data Migration from legacy to SAP-ERP system.
• Translated Business Requirements into Logical and Physical Data Models and worked with Data Scientist and data analyst for Data profiling, data mapping, data cleaning.
• Conducted pre-implementation testing and data validation in system test environments by working with key system users to ensure system setup & configuration meet end user specifications & escalate programming errors found during testing for resolution prior to implementation.
• Lead regular User Acceptance Testing (UAT) sessions with stakeholders using HP Quality Centre.
• Designed and implementation automatic Consignment Fill-up process in SAP Sales and Distribution(SD) module resulting in increased accuracy of customer inventories.
• Performed API testing with SOAP UI and postman, enhanced Test harness and developed suites using XML.
• Utilized MS SharePoint to centrally store, manage and access business artifacts across all platforms.
• Maintained and build relationships with stakeholders to ensure their performance management and business analysis needs are understood and supported. Understood Shipping Process and gathered requirements in reference to Omni-Channel system.

Environment: SCRUM, SAP ERP, Rally, SOAP, WSDL, SharePoint, Tableau, HTML, HP ALM/QC, Microsoft SQL Server, Visio, MuleSoft ESB SharePoint.

Confidential, Greensboro, NC

Business Systems Analyst

Responsibilities:

• Analyzed the prior documentation and business processes for full understanding of the project. Interviewed area experts, asking detailed questions and carefully recording the requirements hereby building a bridge between the business and technical people. As a BSA, developed good understanding of sourcing, contracts, supplier management, and spend analysis.
• Conducted JAD sessions, Document analysis and one-on-one Interviews with the stakeholders for the requirements elicitation.
• Conducted GAP Analysis for AS-IS and TO-BE process for current and future business system and drafted Project Charter, Business Requirement document(BRD), Functional requirement Document(FRD), communication plan and Risk Register.
• Created and Maintained work break down structure(WBS) and project schedule using Microsoft Project to manage deliverables, assign resources, allocate budget, project completion date & identify critical path.
• Translated high-level business requirements into UML diagram such as Use case Scenarios, Data flow models using Visio, developed and published the requirements Specification to all stakeholders.
• Assisted Global sourcing/procurement team. Mapped BAPI of Purchase Requisitions(PRs), Ps, Change Requests(CRs) with APIs of Advance Shipping Notice(ASN), Invoice Shipping Status, and Bill of Lading from SAP/PI Adaptor.
• Completed required object and data mapping between SAP ECC, SAP PI and coupa to trigger IDOC generation for outbound/inbound replication of data and generation of TFCs and BAPI.
• Responsible for verifying browser interactions with Database using SQL statements, creating views, joins and stored procedures for backend operations to make sure the data is mapped properly without any defect or error.
• Assisted in designing data models for Normalization and De-Normalization for data as per the Online Transaction processing(OLTP) and Online Analytical processing (OLAP) frameworks. Integrated and migrated data from various OLTP and OLAP by using Informatica Power Center as an ETL tool.
• Developed Reports with multiple Data Connections, performed data Blending, and crested different visualization like Bar Charts, Tree maps, Bubble Charts using Complex joins with Tableau & maintained all the versions of the documents on SharePoint.
• Provided On-Site support after every deployment to address problem faced by E-commerce Development Team and created complex dashboards using Tableau and published it to Stakeholders for report and spend analysis.
• Communicated with ECC team, SME’s and support specialists on the stream of Request/ response APIs (IDoc to XML) flow so that all are aligned with the need of business and security.
• Designed Test Cases, Test Plans, Test Scripts, and Test Scenarios to perform System Testing, smoke testing, system testing, interface testing and HP Application life cycle management/quality Centre and logged down defects in JIRA
• Automation testing on MM modules using QTP and Cucumber.
• Managed Relationships with outside business, internal team’s development to ensure that the solution is matching with the business needs, meeting the scope, and on track with the Timeline.

Environment: Waterfall-Scrum Hybrid, Coupa, SAP ECC 6.0, SAP PI, HP ALM/QC, postman Microsoft Team Foundation Server (TFS), JIRA, Share Point, tableau, Informatica, HTML, XML, Microsoft SQL Server, Visio.

Confidential, Trenton, NJ

Business Systems Analyst

Responsibilities:

• Interacted with users and stakeholders to Identify business needs, evaluated solutions for business problems. Gathered business requirements by participating in JAD sessions, interviewing business users and stakeholders, conducting one to one sessions and consulting existing systems documents. Understood problem definition through one to one meetings with Data architect, Enterprise architect and Solution advisors.
• Drafted Business Requirement Document (BRD/HLD), Functional Requirement Specification (FRS). Analyzed, modified & validated these documents. Understand the Software Development Life Cycle and experience in system architecture mapping.
• Used MS Visio for Process modeling, Process mapping & Business Process flow diagrams.
• Prepared Logical, physical and conceptual ER diagrams. Designed all Use Cases and UML models using MS Visio.
• Integrated various OLTP to the OLAP by using SSIS/SSAS as an ETL tool and used SSRS as reporting tool. Also maintained the Bill Inmon and Ralph Kimball Paradigms. Used ETL to map data and assemble data repository and created data marts.
• Assisted in increasing Data Integrity by performing Data Normalization & adding Data Verification & Validity to maintain accuracy and effectiveness of data.
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity. Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping. Assisted in the implementation of Enterprise Data Warehouse with individual data marts to address areas of business interest.
• Assisted with SNOW-flake schemas in the Dimensional model architects providing business rules.
• Applying Master Data Management(MDM) concepts for data alignment, maximizing analytics and business intelligence promoting corporate objectives and performed data analysis and ETL technique for loading high volumes of data and smooth structural flow of the data from Disparate sources.
• Diligently analyzed the existing MySQL database by using resulting in creating more significant reports.
• Participated in data analysis, data Dictionary and Metadata management by collaborating with Business Analysts, subject matter experts (SME’s), Data warehouse(ETL) Developers, data quality Analysts and Database Administrators for design and implementation of Data model.
• Provided support in developing and maintaining ETL process that extract data from multiple SOR’s residing on various technology platforms then load the data to various data marts and data warehouses.
• Provided project and maintenance work effort and build test cases, test scenarios and performed UAT support.
• Involved in Test Data Creation from the front end using HP QTP for End to End testing and also involved in performing Regression testing, Black box testing and White box testing using HP QTP.
• Developed timelines for project delivery, and managed projects and resources to successful completion.

Environment: SDLC, Waterfall, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS Project, MS SQL 2008, SSIS, SSRS, SSAS.

Confidential

Business Systems Analyst

Responsibilities:

• Worked on Waterfall project and had a deep understanding about the requirement gathering. Provided clear and consistent information about project status internally to both IT team and stakeholders.
• Interacted with users and stakeholders to Identify business needs, evaluated solutions for business problems.
• Gathered business requirements by participating in JAD sessions, interviewing business users and stakeholders, conducting one to one sessions and consulting existing systems documents.
• Drafted Business Requirement Document (BRD) and Systems Requirement Specification (SRS),
• Understood problem definition through one to one meetings with Data architect, Enterprise architect and Solution advisors.
• Created Conceptual and Logical ER diagrams for the database and also created Data Dictionary for the data models.
• Analysis, Development and Delivery of important integration layer between SAP and salesforce using informatica cloud.
• Supported ERP system users by providing troubleshooting, report generating, SQL query writing and system analysis services and recommending business process improvements to leverage system feature & functionality and updated training documentation for SAP ERP 6.0 including SD, PP, FI and MM modules.
• Assisted extensively to pull the data from cloud applications on Informatica Cloud tool.
• Integrated various OLTP to the OLAP by using SSIS/SSAS as an ETL tool and SSRS as reporting tool. Maintained the Bill Inmon and Ralph Kimball Paradigms. Performed Data Mining to find pattern in existing data and constructed SQL queries.
• Assisted in increasing Data Integrity by performing Data Normalization & adding Data Verification and Validity to maintain accuracy & effectiveness of data. Assisted in increasing Data Integrity by performing Data Normalization. Assisted with SNOW-flake schemas in the Dimensional model architects to providing business rules.
• Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
• Build REST (XML/JSON, JSON/RPC, or SOAP) service integration using a simple form. The service offers a WSDL or Swagger interface document, the Service Connector can be created by importing the interface document.

Environment: SDLC, Waterfall, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS SQL 2008, SSIS, SSRS, SSAS, Service Now.

Confidential

Business Systems Analyst

Responsibilities:

• Performed GAP Analysis between the current As-Is processing to frame the new To-Be process.
• Drove meetings for gathering and documenting business requirements to develop appropriate system development opportunities, through interviewing key business customers.
• Assisted digital Marketing team to implement new SEO strategies by properly optimizing Google AdWords and Analytics and also by improving retargeting through emails and implementing social media marketing.
• Proactively identified potential problems, risk and issues and demonstrated course correction response utilizing Lean-Agile principles and Practices to improve the implementation of the framework and improve workflow.
• Interviewed SME’s and stakeholders to create detailed step by step use cases for functionality and process flow.
• Supported Product owner in their efforts to manage product backlog and guided the team and facilitate a healthy intra-team dynamic with respect to priorities and scope. Developed and Maintained appropriate documentation in the form of business and functional requirements, release notes, Kanban board status update as requested by the Team Lead.
• Documented business rules to analyze Omni Channel and to implement various online payment gateways to the payment system such as O2C, PayPal pro version and authorized.net.
• Created Electronic Funds Transfer(EFT) reports to support team in case of discrepancies.
• Developed and Maintained dashboards based KPI reporting to make recommendation based on data.
• Contributed to Make-buy decision in order to improve the current system and increase savings and Negotiated with suppliers to improve the logistics and ensuring JIT delivery and documented SLA’s for different suppliers.
• Performed testing, developed steps for User Acceptance Testing plans and Test scenarios with QA Team. Developed the test plan, test conditions and test cases for testing based on business requirements, technical specifications and/or product knowledge. Assisted in creating A/B testing reports to improve the success of web-based marketing campaigns.
• Identified, logged and tracked software application problems to develop and verify Test Plans and strategies and engaged with the customer to demonstrate and test the iterative work product while making sure along the way that the development meet their needs by conducting Manual Testing at various phases. Performed extensive testing on API for ensuring accuracy.
• Involved in developing product road map for building and testing web page functionalities like shopping-cart, check-out process, and shipping and payment gateways, registry/wish list application using ATG.
• Developed reports and dashboards using MS Excel that needs of the management and BI team.

Environment: Scrum, Kanban, MS Excel, MS Office, SOAP API’s, XHML, JavaScript, MySQL, Google analytics, Google AdWords.

Confidential

Junior Business Analyst

Responsibilities:

• Communicated, collaborated and trained team members to keep in accordance with SDLC, documented requirements by Interviews and Focus groups, redesigns as necessary, and the highest quality standards. Was involved in creating the Project initiation document (PID). Involved in the Change Management Process and created Change Request documents.
• Facilitated meeting and arranged JAD sessions with business users for requirement gathering.
• Was responsible for creating and reviewing business requirements, functional specifications documentation.
• 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.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams. and data transaction information related to OLTP, OLAP
• Assisted in preparation of test plan, Test Cases, Testing Cycle schedules, Test Scenarios with QA team.
• Was also directly reporting to the Program Manager by submitting weekly reports regarding the progress of the project. Worked with the Business users, tech Lead and 3 rd. party vendors in gathering their requirements.

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