PROFESSIONAL SUMMARY:

• Extensive experience of over 8 years working in IT industry as Business Systems Analyst specializing in Supply Chain Industry with various SDLC methodologies from project inception to deployment. Hands on experience in Waterfall and Agile - Scrum, Scrum-Waterfall Hybrid. In depth knowledge of others such as Kanban, SAFe 4.0
• Excellent in Vendor Selection, Vendor Negotiation, Contracts and Vendor Management, presentations with the pre-sales teams to gain future contracts and maintaining excellent stakeholder relationships.
• Strong project management skills from requirement analysis, process mapping and documentation. Hands-on experience on tools like Rally, JIRA, MS-Project, Confluence for collaboration and tracking.
• Self-starter, problem solver, with excellent presentation, co-ordination, conflict resolution, project planning, estimation, budget planning, risk planning, scheduling, organizational and stakeholder handling skills.
• Adept in coordinating with stakeholders, SME's, and end users to elicit information using various techniques like Brainstorming, Interviews, Focus groups, Joint Application Design (JAD), GAP analysis, SWOT analysis, Document analysis and AS-IS & TO-BE analysis.
• Experienced in preparing Project Deliverables as Project charter, Business cases, Work breakdown structure (WBS), Project Initiation document, Business requirement document (BRD), Functional specification document (FSD), Service Level Agreements (SLA's).
• Experience in Oracle ERP systems, Salesforce CRM, Informatica ETL tools, Product catalogue and Web analytics.
• Concrete understanding about Supply chain management, Inventory control, Quality management, Risk management, Order management, ERP, P2P, P2O, Warehouse management, Sales, General ledger concepts.
• Understanding of Multi-channel fulfillment & warehouse management (WMS) and omni-channel retailing.
• Sound experience in optimizing Process flow, Improving performance, End-End flow from suppliers to customers.
• Excellent in analyzing and cresting Use-cases, various UML diagrams like Use case diagram, Activity diagram, E-R diagrams, Data flow diagram (DFD’s) using MS-Visio, Balsamiq, mock-ups.
• Adept breaking Epics into features and further into User stories using Horizontal and Vertical slicing based on business value and encouraged team to adopt best engineering practices like BDD, TDD, ATDD along with CI.
• Certified Scrum Master deft with scrum ceremonies like Product backlog grooming, Sprint planning meeting, Daily scrum, Sprint review, Sprint retrospective meetings.
• Skilled in helping product owner with prioritization and estimation using various techniques like Planning poker, T-shirt sizing with MoSCoW model, KANO model.
• Proficient in gathering SMART (Specific, Measurable, Attainable, Realistic, Timely) requirements to write user stories meeting INVEST (Independent, Negotiable, valuable, Estimable, small, Testable) criteria having Acceptance criteria (A.C.), setting Definition of done and Definition of ready.
• Facilitated all scrum ceremonies and maintained all Scrum artifacts such as Impediment lists, Sprint Burn-up, Burn-down charts, Release burn-down and burn-up charts.
• Proficient in drafting Requirement Traceability Matrix (RTM), Data Mapping document, RACI matrix, Test Scenarios, Test plans, Test procedures and Test cases, Issue resolution.
• Experienced in Service oriented architecture (SOA), Web services (SOAP, WSDL), validations on client/server side, API's- SOAP, REST, XML, JASON.
• Experienced in various Retrospective techniques like Sail boat, Star fish, Glad sad mad, silent writing.
• Handled regression testing, black-box testing, smoke testing, sanity testing, end-user testing along with UAT.
• In-depth experience in Data warehousing concepts, Data table structures, Data marts, ETL, end-user reporting,
• Service Oriented Architecture, N-tier Architecture, XML parsers, SAX, DOM, XPath, SOAP & REST web services.
• Hands on experience of using DDL, DML in SQL to perform CRUD operations, nested queries on databases including Joins, Triggers, Stored procedures and Data Mapping on Oracle & Microsoft SQL Server Databases.
• Designed various BI reports, Dashboards, ad-hoc reports on various parameters using Tableau, Cognos, SSRS.

TECHNICAL SKILLS:

Methodologies: Waterfall, Agile- SCRUM, Scrum-Waterfall Hybrid, SAFe 4.0.

Business Skills: Change management, Impact Analysis, Cost-Benefit analysis, ROI Analysis, Conflict resolution, Risk assessment, JAD sessions, SWOT analysis, Report generation.

Operating Systems: Windows, Mac OS

Project Management tools: MS-Project, JIRA, Rally, TFS, HP-ALM, Confluence, MS-Office.

Database/ ETL: MS Access, Oracle DB, SQL Server, Informatica- Power Center, Data Quality, MDM.

Defect Tracking/ Testing Tools: HPUFT, Load Runner, Cucumber, JIRA, Gherkin, HP QC, Soap UI, Swagger.

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

Business Modeling Tools: MS Visio, Balsamiq, Lucid Chart, Wireframes.

Reporting/ BI: Tableau, SSRS, Microsoft Power BI, IBM Cognos, IBM SPSS

Miscellaneous: Microsoft Office, Adobe Photoshop, RedHat JBOSS BPM suite, Draw.io, Oracle Crystal Ball, Google Analytics, MS-Excel, Altova XML spy, Salesforce CRM.

Language: HTML, XML, SQL, JSON.

PROFESSIONAL EXPERIENCE

Sr. Business System Analyst

Confidential - Estero, FL

Responsibilities:

• Conducted a high-level requirement gathering session with portfolio managers, business owners, to understand business needs, requirements.
• Performed Document analysis and Interface analysis for various segments ERP system to analyze problem of forecasting overall demands, supplies, and logistical processes reducing result of Bullwhip impact.
• Participated in various Scrum Ceremonies like Sprint Planning, Sprint Review, Sprint Retrospective and Daily Scrum.
• Helped in preparing Business Requirement Document (BRD/HLD), Functional Requirement Document (FRD/LLD) and Software Requirement Specification (SRS) to enable development team understand business requirements.
• Created DFD's and Activity diagrams to map data from multiple databases to staging area to integrated warehouse.
• Created and maintained project scheduled using MS-Project (v16) to manage deliverables, assign resources, allocate budget, project completion date, identifying critical path.
• Managed various Service Level Agreements (SLAs) between vendor, supplier and customers to optimize downstream and upstream of cash flows.
• I acted as a liaison between the Business and IT by gathering all the designs, business, functional & technical requirements. Helped Project manager to do Impact Analysis.
• Coached teams to write effective user stories using INVEST criteria, and tasks using SMART criteria, defined Acceptance criteria, and Definition of Done used various Estimation, Planning and Retrospective techniques such as Planning Poker and Star Fish, ORID, and Mad Sad Glad.
• Helped Product owner prioritize product backlog items for developing tasks based on business value.
• Worked on data profiling & various data quality rules development using Informatica Data Quality.
• Used Informatica Power Center Designer to check the errors in mapping while creating Golden copy.
• Worked on data cleansing and standardization using Cleanse Adapter's in Informatica MDM.
• Created various Mock-up screens using UI components for Inventory analysis, fulfillment status for client verification using MS-Visio, Balsamiq, wireframes.
• Involved in Technical writing and API documentation for REST and SOAP API using JSON and XML.
• Assisted Quality Assurance team in black box testing, User Acceptance Testing (UAT), Alpha-Beta testing, writing test cases, test plans using feature files in Gherkin’s format on Cucumber.
• Used Confluence for managing resources across organization and JIRA for drafting user stories and tracking sprint.
• Was a part of API testing for JSON and XML and measured the data flowing between request and response.
• Involved in Data Mapping Documentation for Source to Target data and using REST based API via JSON.
• Encouraged team to adopt Test driven development (TDD) and Behavior Driven development (BDD) using Cucumber along with Continuous Integration (CI) using Jenkins.
• Extensively involved in the User Acceptance Testing phase to ensure the requirements and functionality of the system was in accordance to the users and their feedback was incorporated.
• Used Tableau and Excel (Pivot tables, Look-ups, & macros) for reporting and analyzing portfolio performance, Net Present Value (NPV), Sales record, Demands, cash flows, Profits.
• Used Swagger for documenting and testing both SOAP and REST APIs. Worked with development team to provide swagger JSON files for REST API calls. Also, documented XML and JSON request & responses.

ENVIRONMENT: Waterfall-Scrum Hybrid, MS-Office 2016, Oracle R12, Informatica-Power center, Informatica-Data Quality, MS Visio 2016, Balsamiq, Wireframes, RedHat JBOSS BPM Suite, SOA, Gherkin, Cucumber, MS Project 2016, Confluence, JIRA 7.2, Wildfly (RedHat JBOSS Application server), Jenkins, MS-EXCEL 2016, Tableau 10.1.4, Swagger, HP QC v11.0, HTML 5, CSS3, Eclipse, Oracle 11g, Apache Derby.

Business System Analyst

Confidential - Menomonee Falls, WI

Responsibilities:

• Collaborated with classic system business users to understand business process flow, business logics to assess client’s records, retail channel records, supply records and pitfalls in the system doing 1-1 interviews, feasibility study, gathering functional and technical requirements.
• Coordinated with systems partners to finalize designs and formalize requirements Utilized Story. Sizing and Planning Poker techniques as needed based on the length of the backlog and priorities.
• Involved in Business Process Reengineering (BPR) by conducting Business Process Modeling, SWOT analysis, Document analysis, and GAP analysis to analyze As-Is business process and the To-Be system.
• Assisted in documenting Business requirement document (BRD) along with Functional requirement document (FRD).
• Successfully conducted JAD sessions with Subject Matter Experts (SME's) and Project Manager for Lightning project designing solution working closely with Stakeholders, Architects and Deployment teams.
• Organized various story writing sessions to analyze the requirements and writing user stories. Assisting the teams in creating clear and concise epics and further breaking them into user stories meeting INVEST criteria.
• Assisted Product Owner and tech lead in defining Acceptance Criteria (A.C.), Definition of Done (D.O.D.) and Definition of Ready (D.O.R.). Helped Organizing and facilitating Scrum ceremonies including Product Backlog Grooming, Sprint Planning, Daily Scrum meetings, Sprint Review meeting, and Sprint Retrospective meetings.
• Created various UML diagrams like Use Case diagram, Activity Diagram and Sequence diagram using Mock-up screens and MS-Visio for developers to understand User Interface (UI) components.
• Created various workflow rules like sales cloud implementation, service cloud module, client interfacing, company-wide discussions using developer toolkit- apex classes, apex triggers to help develop business logic with developers.
• Worked on Schema builder and mapped Look-up and Master detail relationships among objects. Also, involved in setting page layout, adding various validation rules.
• Extensively used JIRA for creating product backlog, writing user stories, tracking sprint progress, allocating tasks, and calculating velocity and capacity of the team.
• Integrated the SOAP and REST based Web Services for extracting the data from legacy systems to display in the pages of salesforce.com (SFDC). Worked on REST, SOAP, XML and JSON.
• Designed workflow to determine most popular items, customers by age range, geography, profession and other parameters to make decisions based on inventory.
• Prepared Test cases, Test plans and Test scenarios to perform system Testing, Smoke Testing, Interface testing, along with various kinds of performance testing like Load, Stress, volume using Load runner, SOAP UI.
• Created Test cases and RTM using HP-QC & tracked requirements using JIRA.
• Provided user support and coordinated resolution of issues to include change management, root-cause analysis, and appropriate escalation as needed
• Supervised the use of Cucumber for Behavior driven development (BDD) using Maven and JENKINS for CI.
• Extensively used SSIS & SSAS for integrating data from multiple sources and analyzing them.
• Used Confluence to keep track of the time for development and maintaining tickets.
• Involved in API technical writing for both SOAP and REST. Documented XML and JSON request and responses using MS-Excel. Drafted test result reports using LoadRunner.
• Created customized reports and Dashboards using Lightning report builder with option of excluding confidential information using Salesforce CRM lightning version.
• Involved in Beta testing, User Acceptance testing (UAT) and resolving found issues.

Environment: Waterfall-Scrum Hybrid, Salesforce CRM, JIRA, MS Visio, Mock-up screen, SOAP, REST, LoadRunner, SOAPUI, HP QC, Cucumber, Maven, JENKINS, SSIS, SSAS, Confluence, TFS, MS EXCEL, MS-Office, Tableau, Oracle DB, Balsamiq, Apex classes, Apex Triggers, Eclipse.

Sr. Business System Analyst

Confidential - Richfield, MN

RESPONSIBILITIES:

• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Conducted GAP analysis for AS-IS and TO-BE process for current and future state processes and wrote Business Requirement Document (BRD), Functional requirement Document (FRD) as per business flow.
• Documented the changes required in design, raised issues and did impact analysis on system design and delivery using MS Excel, MS Office.
• Developed WBS, assigned resources, resolved over allocations, estimated project completion date, critical path, deliverables using MS-Project.
• Conducted User Story Writing Sessions to decompose BRD into User Stories and determine Acceptance Criteria for
• Potentially Shippable Product Increment, Facilitated Backlog Grooming, Sprint planning, Sprint Review meetings, Sprint retrospectives and Daily scrums.
• Drafted Use cases, UML diagrams like Activity diagram, sequence diagram using MS-Visio.
• Integrated Red Hat JBOSS Business Process Management (BPM) suite combining BPM with Business Rule Management (BRM) using Rest API's in XML format. Involved in Technical writing for SOAP and REST based for XML.
• Created RTM linking Business requirements to Functional requirements to tasks using HP QC.
• Involved in integrating Point of sale (POS), Oracle Retail Merchandising system (RMS) and Oracle Order Management system (OMS) set-up to match functional needs of organization.
• Responsible for verifying browser interactions with DB using SQL statements, creating views, joins and stored procedures for back-end operations using JDBC.
• Identified and categorized all relevant stakeholder and did impact analysis using RACI matrix.
• Removed Impediments and worked with teams to deliver Potentially shippable product Increment (PSPI) by the end of Sprint to meet Goals.
• Extensively used Rally for creating User stories, requirement traceability, tracking Velocity, capacity. Analyzed Burn-up and Burn-down charts and prepared status reports.
• Drafted WSDL for request and responses from web service API's to address stock issues and processing customer orders to expedite delivery.
• Extensively used TFS for repository management and collaboration.

Environment: Waterfall-Scrum Hybrid, TFS, HTML 5, CSS3, WSDL, MS Excel, MS Office, MS Visio, Balsamiq, RedHat JBOSS BPM Suite, Rest API’s, XML, HP QC, MySQL, JDBC, MS Project, Rally, Cucumber, Jenkins, Gherkins, PowerBI, Eclipse IDE.

Business Analyst November

Confidential, San Antonio, TX.

RESPONSIBILITIES:

• Facilitated Joint Application Development (JAD) sessions, conducted group and interviews using laddering technique to identify problems and need for Enterprise Data Warehouse (EDW) to scale process.
• Performed Document analysis, Interface Analysis, employed Observation technique on the existing process to identify GAP and assist Project manager in planning the transition.
• Involved in designing Star schema and extracting data from various sources. Documented data migration prototype for process approval from sponsors.
• Integrated numerous data sources by Extracting, transforming and loading data by mapping them using Informatica Power center (PC). Created Data Mapping document on MS-Excel to track end-to-end systems.
• Created Data Flow Diagrams (DFDs), Sequence diagram, Activity diagrams for mapping data transfer using MS-Visio.
• Responsible for Data mapping with XML and Restful APIs to integrate with different web services.
• Worked with Data Scientist, Data analyst for Data profiling, Data mapping, Data cleaning using Informatica Data Quality (DQ). Assisted Data modelling process by creating conceptual and logical E-R diagrams.
• Integrated various OLTP to OLAP by using Informatica as an ETL tool maintaining Bill Inmon paradigm.
• Managed & tracked entire project requirements using HP ALM through application life cycle.
• Increased data integrity by Normalizing the data in various normal forms.
• Drafted test strategy, test plans, test cases, to perform Data completeness, Data Accuracy, Data transformation and Data Quality testing.
• Generated reports using Tableau to study trends, patterns, and forecasting expenses and to facilitate expenditure tracking for budget approvals.

Environment: Waterfall, MS Office (MS Word, MS Excel, MS PowerPoint), MS-Visio, Tableau, Informatica PC, Informatica DQ, MS Project, HP ALM, Oracle 9i, Wireframes, UML, SQL.

Business Systems Analyst

Confidential

RESPONSIBILITIES:

• Identified scope and business rules of the project by working closely with clients.
• Hosted JAD sessions with stakeholders, Subject Matter Experts (SME’s) & management personnel to reduce the time spent on gathering requirements. Helped in creating BRD & FRD.
• Based on Business value vertically sliced Epics into user stories during Product Backlog Grooming sessions.
• Extensively used INVEST criteria to write User stories along with Product owner, development team and Scrum master. Also wrote Acceptance criteria for each user story. Participated in various scrum ceremonies like Product Backlog grooming sessions, Sprint planning meeting, Daily Scrum, Sprint review meeting, Sprint retrospective.
• Liaised between product development team, cross-functional units, Project management team and finance department identifying business process gaps to manage risk ensuring project success.
• Created Mock-up and wireframes using UI components for enhancing customer experience using MS-Visio.
• Used SQL select, update, delete queries to retrieve, update and remove data from databases to verify browser interaction with Database.
• Worked on SOAP, XML and created API gateway for payments in Service oriented architecture (SOA).
• Assisted User acceptance testing (UAT) with Sr. Business Analyst in environment setup, identified stakeholders, defined acceptable criteria for scripts to pass. Worked on HP- UFT.
• Tracked entire project using Rally, kept track of team involved in each phase, communicated defects to team involved and made sure tickets raised are resolved.
• Prepared test reports, success criteria and bugs report using MS-EXCEL, MS-Office.
• Worked on functional side with Salesforce business team to identify and capture customers.
• Assisted in creating various Tablix, Matrix, snapshot reports using SSRS for analytics and management reports.
• Creating different types of SSRSreports like Parameterized, Drill through, Drill down,sub reports using tables, cross tabs and charts.
• Applied various SSRS expressions like aggregate functions etc. to apply custom logic to meet the requirements

Environment: Waterfall-Scrum hybrid, Rally, MS-Visio, SQL, LoadRunner, MS Office suite 2010, HTML 5.1, CSS, SQL Server, Wireframes, REST, SOAP, SOA, XML, SSRS, Salesforce CRM, HP-UFT.

Jr. Business Analyst

Confidential

RESPONSIBILITIES:

• Interviewed Business and I.T. stakeholders and SMEs to gather requirements to reengineer existing application.
• Conducted planning sessions, Interviews, did feasibility studies to recognize and eliminate high-risk areas and developed Risk assessment reports by running Monte Carlo analysis.
• Analyzed current operations, processes and problems to identify areas for improved workflow for scaling up the operations. Performed Cost/Benefit analysis and GAP analysis using Market survey results.
• Created various Use-cases and flow-charts from Functional & Non-Functional requirements using MS-Office suite.
• Helped formulating business rules/logic based on requirements to implement workflows to generate order receipts, assigning deliveries, tracking orders, handling payments with order fulfillment. Maintained project schedule.
• Drafted Activity & Sequence diagrams using MS Visio for normal & alternate flows to represent business process and communicated them to stakeholders.
• Created (RTM) using HPQC, interacted with Quality Assurance team to ensure quality of the product.
• Created ad-hoc reports on MS-Excel using Pivot tables & Lookup functions for calculations.
• Worked with Q/A team to develop Test scenarios, Test plans and Test cases to be used based on Business Requirement Document (BRD), Technical specification document (TSD).
• Used IBM Cognos for reporting various modules.
• Advised Senior architect determining database structures based on requirements, operations, and applications.
• Developed flow charts based on access techniques, coordination actions and designed Database based on proposed system, Integrated business processes with objectives, performing critical path analysis, created ER diagrams to map data into databases.
• Resolved application development problems by using Triggers to implement business logic and auditing changes to critical tables. Optimized query performance by creating indexes
• Collaborated with Developers writing SQL scripts for data massaging and loading.
• Created Views & stored procedures to make it easier for generating reports for management to view data.
• Extensively used Joins and sub-queries to simplify complex queries involving multiple tables.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL server 2005.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL joins and Statements for Applications.

ENVIRONMENT: Waterfall, MY SQL server (v10.0), MS Office suite (2007), Windows 2005/2003, MS Access.