PROFESSIONAL SUMMARY:

• Overall 8+ years of experience in Supply chain and E - commerce domain working closely with business users, developers and subject matter experts through all phases of SDLC. Possess strong communication, analytical, problem solving, documentation and UML modeling skills
• Worked in all phases ofSoftware Development Life Cycles includesWaterfall, Agile (Scrum and Kanban) and Waterfall-Scrum Hybrid and good understanding of Spiral and XP methodologies
• Experienced in assisting & conducting Stakeholder analysis & identification,Risk analysis, Impact analysis, Gap analysis, Cost Benefit analysis, Strategic Planning, Feasibility analysis, SWOT analysis, PESTLE analysis, Porter’s Five Forces Analysis and Return on Investment (ROI) calculations
• Strong functional expertise in Procure to Pay (P2P), Procure to Order (P2O), In-house e-commerce application, Business to Business (B2B), Business to Consumers (B2C) scenarios, Account & Sales management, Order Management and Inventory Management in SCM and E-commerce domain
• Excellent domain knowledge of business processes in Material management (MM), Warehouse Management (WM), Production Planning (PP), Financial Accounting (FI), Sales, and Distribution (SD), Customer Relationship Management (CRM) and Content Management System (CMS)
• Analyzed website and mobile app performance through Google Analytics, Customer Acquisition & Retention rate, Search Engine Optimization (SEO) & Google AdWords strategies, Call to action (CLA), Customer Lifetime Value (CLV) and Net Present Value (NPV)
• Experienced in working with stakeholders to identify key performance indicators (KPI) and service level agreements (SLA) for Inventory management and Buyer-Supplier Relationship
• Exceptional ability to build Client relationships through meetings and gather requirements from Stakeholders by usingElicitation Techniquessuch as Interviewing, Surveys and Questionnaires, Brain Storming, Focus Groups, Document Analysis, Interface Analysis and Prototyping like mock up screens and wire framing
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business Groups, Joint Application Development (JAD) sessions, Conflict Management with Project team & stakeholders and Rapid Application Development (RAD) sessions to limit a projects exposure to the forces of change
• Assisted Project Managers in preparing Project Management Plan, Project Schedules, establishing Milestones, Network Diagrams, Work Breakdown Structure (WBS) and Communication plan (RACI)
• Extensive experience in creating various artifacts includingBusiness Requirement Document (BRD), Functional Requirements Document (FRD) and System Requirement Specification (SRS)
• Certified Scrum Master involved in conducting ceremonies of Agile Scrum process like Sprint Planning, Daily Stand up Meeting, Sprint Review, Sprint Retrospective Meetings and Backlog Grooming activity
• Adept in coaching teams and assisting PO in breaking Epics into features and User stories using Horizontal and Vertical slicing and encouraged team to adopt best engineering practices like BDD, TDD, ATDD with CI
• Competent in creating unified modelling language (UML) diagrams such as Use Case, Activity Diagrams, Class Diagrams and Sequence Diagrams by using Microsoft Visio, Smartdraw, draw.io and Lucid chart
• Experienced in test cycles like Unit Testing, System Integration Testing, User Acceptance Testing (UAT), Performance Testing, Regression testing, Ad-hoc testing and Testing Strategy like entry/exit Criteria
• Proficient in drafting Requirement Traceability Matrix (RTM), Test Scenarios, Test plans, Test procedures and Test cases 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 the Business Requirements
• Used SQL queries as a Data manipulation language (DML) to select and update the data including joins, order or group by functions to extract data by performing Data defining language (DDL) operations
• Experienced in conducting Data Analysis and generating reports using R, Tableau and Power BI
• Practical knowledge of Data Warehousing architecture, implementation approaches, Star & Snowflake schemas, dimensional modeling, data mapping and translating the requirements into different dimensions
• Expertise in assisting system architects to created ER diagrams & Data Models like Conceptual data model, Logical data model and Physical data model to capture requirements properly in the underlying database
• Deep understanding of service-oriented architecture (SOA), performed client-side validation & Web Service Testing of SOAP and REST APIs which used XML & JSON and API documentation

TECHNICAL SKILLS:

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

Operating Systems: Windows, Mac OS

Project Management tools: Microsoft Project, JIRA, Confluence, Greenhopper, Rally, TFS, Rational Requisite and HP ALM

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

E-commerce tools: Google Analytics, Google Adwords, SEO and Salesforce

Database/ ETL: MS Access, Oracle DB, SQL Server, Informatica Power Center, SAP HANA, Master Data Management and SSIS

Testing Tools: HP QC, Cucumber, Bugzilla, HP UFT, Swagger, Postman and Soap UI

Data Warehousing: Data Modeling, Data Marts, OLTP, OLAP, Data Mining, Slicing/Dicing, Roll Up/Drill Down and Pivot

Business Modeling Tools: MS Visio, Balsamiq, Lucid Chart and Smart Draw

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

Miscellaneous: Mockup Screen, Microsoft Office, Adobe Photoshop and Draw.io

Language: JAVA, C++, SQL, XML, HTML and JSON.

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 of Marketing, Pricing Strategy (3 C’s), Economic order quantity, Bullwhip effect and White board animation

PROFESSIONAL EXPERIENCE:

Sr. BusinessSystem Analyst

Confidential, Richfield, MN

Responsibilities:

• Interviewed Regional Plant, Supply Chain, and Finance Managers to gather System Requirements and Conducted JAD sessions withstakeholders to gatherrequirements for B2C & B2B applications
• Assisted in Project Planning & implementation, for bringing productive results and drafted all necessary documentation including Project Charters, Business requirement specification (BRS), System requirement specification (SRS), RTM, Communication Plan and Risk Register
• Translated high-level business requirements into UML diagram such as Use Case Scenarios, Data Flow models using Visio, developed and published the requirements Specifications to all stakeholders
• Mapped BAPI of Purchase Requisitions (PRs), Purchase orders (POs), Change Requests (CRs) with APIs of Advance Shipping Notice (ASN), Invoice, Shipping Status, and Bill of Lading from AribaNetwork Adapter
• Completed required object and data mapping betweenSAPECC, SAP PI, and SAP Ariba to trigger IDOC generation for outbound/inbound replication of data, and generation of RFCs and BAPI
• Configured and Modified Sourcing and Contract Templates based on Business Rule and Requirements
• Managed Relationships with outside business, internal teams, development teams to ensure that the solution is matching with the business needs, meeting the Scope, and on track with the Timeline
• 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 properly without any defects or errors
• Assisted in designing data models for Normalization and De-Normalization of data as per the Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) frameworks
• Prepared Test scenarios, Test Plans, Test cases and assisted to write test procedures for performing System Testing, Smoke Testing, Interface testing using HP Application life cycle management/Quality Center
• Integrated and migrated data from various OLTP to OLAP by using Informatica Power Center as an ETL tool
• Developed Reports with multiple Data Connections, performed data Blending, and created different Visualizations like Bar Charts, Tree Maps, Bubble Charts using complex joins with Tableau
• 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 the business and security
• Used Postman to Test and Document SOAP & REST APIs using GET/POST/DELETE methods

Environment: Waterfall-Scrum Hybrid, SAP Ariba, SAP ECC 6.0, SAP PI, HP ALM/QC, Postman Microsoft Team Foundation Server (TFS), JIRA, Greenhopper, SharePoint, Tableau, Informatica, HTML, cXML, Microsoft SQL Server, Visio, PowerPoint

Sr. Business Analyst

Confidential, Melville, NY

Responsibilities:

• Conducted Interviews, JAD and JRP sessions with Project Managers, Executives, Developers, end-users, and subject matter experts to gather requirements and document the requirements to add to the product backlog
• Conducted GAP analysis for AS-IS and TO-BE process for current and future business state and wrote Business Requirement Document (BRD), Functional requirement Document (FRD) to create features and user stories
• Used MS Visio to carry out business modeling, data modeling (ER Diagrams), Screen Prototype, Object modeling (use case) to develop business architecture for rapid and controlled Application development
• Performed Document analysis, GAP analysis and Interface analysis for various Line of Businesses to analyze problem of forecasting demands, supplies, and logistical processes reducing result of Bullwhip effect
• Managed various Service Level Agreements (SLAs) between vendors, supplier and customers
• Created and maintained project work break down structure and project schedule using Microsoft Project to manage deliverables, assign resources, allocate budget, project completion date and identify critical path
• Assisted in Integrating Mulesoft as an enterprise service bus (ESB) to provide bi-directional communication and execute any standard and custom BAPI in SAP so that Salesforce and SAP ERP is linked properly
• Assisted Product Owner to slice user stories and prioritize them using Kano Model and Business value
• Used Informatica Power Center Designer to integrate and migrate data from various OLTP databases to allow data exchange safely and to review and validate errors during data mapping by using SQL queries
• Assisted in Data mapping, Logical and Physical data modeling, created class diagrams and entity relationship (ER) diagrams and used SQL statments to select and filter data within the database
• In charge of conducting the UAT with the Business users, and gathering feedback and baselined document to share it with the Development team and quality assurance team to remove defects and map them
• Performed manual and automated tests related to the graphical user interface (GUI), functional and nonfunctional testing, security testing, and testing related to data extraction from server
• Created ad-hoc reports on Microsoft Excel using graphs, Pivot tables & Lookup functions for calculations
• Performed SOAP API testing using SOAP UI and validated the data and creating artifact which included use of SOAP API to create, retrieve, update or delete records, such as accounts and leads

Environment: Scrum, Jira, Confluence, MS Excel, MS Office, MS Visio, iDoc, ABAP, Salesforce, SAP ERP, Mulesoft, SQL, SOAP API, XML, MySQL, Postman, SOAP UI, JDBC, MS Project, Cucumber and Gherkin

Sr. Business System Analyst/Scrum Master

Confidential, Charlotte, NC

Responsibilities:

• Conducted meetings will various stakeholders in the organization by utilizingElicitation Techniquessuch as Interviewing, Brain Storming, Focus Groups, Job Shadowing and Interface Analysis to create user stories
• Performed GAP analysis to define gaps between As-Is and To-Be processes and understood the business requirements of the system, developed the process maps for better understanding and defined KPIs
• Gathered technical and functional client requirements and manage those requirements through clear and documented them into technical requirement document (TRD) and functional requirement document (FRD)
• Supported ERP system users by providing troubleshooting, report generating, SQL query writing and system analysis services and recommending business process improvements to leverage system features & functionality and updated documentation for SAP ERP 6.0 including SD, PP, FI and MM modules
• 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 tasks using SMART criteria, defined Acceptance criteria, and used Estimation and Retrospective techniques like Planning Poker, T-shirt size, Relative mass valuation, ORID, silent writing and speed dating
• Executed SQL queries to select, retrieve and updatedata 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
• Performed Root Cause Analysis (RCA) for repetitive problems and with suggestions for resolution
• Conduct pre-implementation testing and data validation in system test environments by working with key system users to ensure system setup and configurations meet end user specifications and escalate programming errors found during testing for resolution prior to implementation
• Lead regular User Acceptance Testing (UAT) sessions with stakeholders using HP Quality Center
• Designed and implemented 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

Environment: Scrum, SAP ERP, SAP MM, PP & SD, Rally, SOAP UI, WSDL, SharePoint, Tableau, HTML, HP ALM/QC, Microsoft SQL Server, Visio, PowerPoint

Sr. Business Analyst

Confidential, Salem, OR

Responsibilities:

• Analyzed the various ODOT Highway Systems, processes, databases and document by GAP Analysis to find AS-IS and TO-BE business processes and technology
• Collaborated with legacy system business users to understand business process flow, business logics to assess records and pitfalls in the system using interviews, brainstorming sessions, focus group sessions, joint application development (JAD) sessions and Joint requirement sessions (JRP) and documented the requirements
• Helped in preparing Business Requirement Document (BRD/HLD), Functional Requirement Document (FRD/LLD) and software requirement Specification (SRS) to enable developers understand requirements
• Collaborated with Technical Service Branch customers about their needs, requirements and recommended design solution alternatives to ODOT’s Information Technology team and Technical Services Leadership team
• Provided project and maintenance work effort and build test cases, test scenarios and performed UAT support
• Created various Use-cases & flow-charts from Functional & Non-Functional requirements using Smartdraw
• Provided ODOT Technical services business opportunity assessments by discovering and documenting customer concepts of potential systems in the future
• Applying Master Data Management (MDM) concepts for data alignment, maximizing analytics and business intelligence promoting corporate objectives and initiatives and performed data analysis and ETL techniques for loading high volumes of data and smooth structural flow of the data from Disparate sources
• Diligently analyzed the existing database and extracted the data from it using R studio and performing different data analysis and updated the database by using MySQL resulting in creating more significant reports
• Participated in Data Analysis, Data Dictionary and Metadata Management by Collaborating with Business Analysts, subject matter experts (SMEs), Data warehouse (ETL) Developers, Data Quality Analysts and Database Administrators for design and implementation of Data Model
• Provided support in developing and maintaining ETL processes that extract data from multiple SOR's residing on various technology platforms then load the data to various data marts and data warehouses
• 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 and White box testing using HP QTP
• Generated reports and created dashboards using Power BI to study trends, patterns, and forecasting expenses to facilitate expenditure tracking for budget approvals and perform data analysis on various business operations

Environment: Waterfall, Rally, SharePoint, R studio, MS Outlook, Power BI, HP UFT/QTP, Talend, Microsoft SQL Server, Visio, Smartdraw, PowerPoint and SSRS

Business Analyst

Confidential

Responsibilities:

• Performed GAP Analysis between the current As-Is processing to frame the new To-Be process
• 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
• Supported Product Owner in their efforts to manage the product backlog and guided the team and facilitate a healthy intra-team dynamic with respect to priorities and scope
• Interviewed SME’s and Stakeholders to create detailed step by step use cases for functionality and process flow
• Created Electronic Funds Transfer (EFT) reports to support team in case of discrepancies
• Developed and Maintained dashboard based on 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
• Assisted in creating A/B testing reports to improve the success of web-based marketing campaigns
• Monitor the effectiveness of change plans and strategies, recommending improvements to management to gain maximum benefit and also notify the manager of any risks that may negatively impact the scope or schedule
• 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
• 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 developments meet their needs by conducting Manual testing at various phases
• Performedextensive testing on APIfor ensuring accuracy of backend services
• Developed reports and dashboards using MS Excel that meets the needs of the management and BI team

Environment: Scrum, Kanban, MS Excel, MS Office, Balsamiq, SOAP API’s, XHML, Javascript, MySQL, Google Analytics, Google AdWords

Business Analyst

Confidential

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
• Responsible for Requirement Gathering, Process and System Design, End user and assisted quality assurance team to perform UAT
• Drove meetings for gathering and documenting business requirements to develop appropriate system development opportunities, through interviewing key business customers and use cases
• Worked collaboratively with managers, users, IT, and vendor teams to analyze requirements, document their processes and procedures, propose, execute, and support new solutions.
• Worked on SAP to support a prestigious retail store chain to maintain the quality of operations to enhance in-store sales system and improve logistics in the decentralized system to maintain optimum safety stock
• Analyzed end to end process after understanding the business needs from the client in the field of SAP Supply Chain Management and SAP Materials Management
• Managed SAP Reporting project by successfully implementing 10 new reports for SAP SD, MM, PP-PI and FI and identified reporting requirements and coordinated the report creation with ABAP developers to create ABAP Query reports and conducted testing and
• Written and executed complex SQL queries using SQL Server Studio for back end data validation and testing
• Collaborate withUI/UX, API and System teamsto support development initiatives with working knowledge ofXML and JSON

Environment: SAP SD, MM, PI, FI, SQL, ABAP, Workflow Builder, XML Publisher, MS Excel, Microsoft Office

Jr. Decision Scientist

Confidential

Responsibilities:

• Used data and statistical methods to analyze the data and formulate insight into the business
• Responsible for gathering requirements from the Clients, analyzing the business problem and coming up with a detailed methodology for solving the problem for a large US based retailer
• Completed ad-hoc requests from the client for analyzing similar datasets daily and generated reports and dashboard to solve the problem and present the output in a way that will be consumable by the business
• Generating Excel based Reports for the Retail Transformation and providing them with insights on how to develop a Streamlined Process Framework using applications like Hive, thereby affecting all facets of a Supply Chain Management business like pricing, promotional planning, planograms and customer fulfilment
• Designed a reporting solution to give the client capabilities to leverage and exceed customer expectations, generated data visualization using R and developed an Excel based Scenario Planning tool to pace and sequence their product launches
• Develop hypotheses, and test these hypotheses based on Exploratory data analysis techniques using SQL programming
• Extracted and analyzed structured data using SQL and advanced Excel scaling up to 5 million rows as a part of biweekly deliverable

Environment: Microsoft Office, Microsoft SQL server, SQL, Hive, Google Analytics, R, Microsoft Excel