Home

Kishan Patel - Sr. Business System Analyst

[email protected]

Location: Kingston, Pennsylvania, USA

Relocation: yes

Visa: h1b

Well-accomplished object-oriented Business System Analyst/Business Analyst with 8 years of experience in stakeholder management, leading cross-functional teams in product development, documentation, delivery of process innovations, and accomplishing the business goals. A passionate and highly motivated professional who has contributed to transforming organizational practices into fresh, cost-effective solutions leading to more efficient operations. Exceptional work ethics and analytical skills coupled with excellent communication, written and interpersonal skills. Around 8 years of experience in the implementation of the Software Development Life Cycle (SDLC) using various methodologies and frameworks like Agile SAFe, Agile Scrum and Waterfall. Comprehensive domain knowledge and experience in Lead flow Management, Healthcare Insurance Claims Management, Healthcare Enrollment Management, Mortgage Loan Origination Process, and Inventory Management System. Good understanding and hands-on working experience with standards of EDI 270 & 271, 276 & 277, 834, 835 & 837,820 and 814. Skilled in gathering requirements using different Elicitation Techniques like Document Analysis, Brainstorming Sessions, Focus Group Sessions, Individual/Group Client Interviews, Interface Analysis, Reverse Engineering, and JAD Session. Extensively experienced in Requirement Documentation and Management using various tools like, JIRA CONFLUENCE, and MS SharePoint to have better traceability throughout the software development lifecycle. Possess exceptional Business Documentation Skills required for recording Business Requirements, including Functional Requirements (FR) and Non-Functional Requirements (NFR). Extensively experienced in performing Requirement Analysis using BPMN Diagrams and UML diagrams including Use Case Diagrams, Activity Diagrams, and Sequence Diagrams using MS Visio tool. Expertized in creating artifacts such as, Business Requirement Document (BRD), Functional Requirement Document (FRD), and System Requirement Specification (SRS). In-depth understanding and experience in performing different analysis techniques such as GAP analysis (As-Is and To-Be process of the business entity), Impact Analysis, Stakeholder Analysis, SWOT Analysis, Cost-Benefit Analysis, and Root Cause Analysis to frame a business strategy. Excelled in facilitating Joint Application Development (JAD) sessions with Subject Matter Experts (SME's) and Scrum Team to convert Functional Requirements into Technical Requirements. Facilitated and engaged in all scrum ceremonies like Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective, and Backlog Refinement sessions. Good experience in writing User Stories using INVEST criteria and authored Acceptance Criteria for the same. Proactively briefed Team's progress to the Product Owner using Key Performance Indicators (KPI's) integrated into JIRA and Rally such as Burn-up Chart, Burn-Down Chart, Bug Resolution Time Chart, and Velocity Chart. Excelled in handling Change Requests and implemented the change request effectively by following change management protocol designed by Change Control Board (CCB). Proficient in developing and executing Test Plans, Test strategies, Test Scenarios, and Test Cases based on the User Stories and Acceptance Criteria defined according to the business requirements. Tremendous experience in formulating the Requirement Traceability Matrix (RTM) integrated into the JIRA to validate all the test cases' requirements. Experience in business analysis, systems analysis and design in large-scale projects across multiple organizations In-depth experience in leading User Acceptance Testing (UAT) and guiding business stakeholders by providing User Guides to Validate and Verify both functional and technical requirements of the application. Proactively collaborated with the Solution Architect Team in implementing APIs, Web services, and Microservices to the Enterprise technical architecture, thereby increasing business agility. Amplified technical architecture by validating Web Services, API's, using Soap UI and Postman tool to authorize its functionality to satisfy the business requirements. Good knowledge in performing Extract Transform Load (ETL) process to migrate data from OLTP Database to OLAP Data warehouse and Data Marts, which involved Data Mapping based on the elicited Transformation Rules. Proficient in executing SQL queries to perform Data Validations in Data Warehouse and Data Marts. Methodologies Agile, Waterfall Framework SAFe, Kanban, Scrum BI Tools Tableau, Power BI, Crystal report, MS Visual Studio Modeling Tools MS Visio, Rational Rose, Lucid Charts, Balsamiq Databases MS SQL Server, MongoDB Dev. Environments / Protocols SOA, CI-CD, Dev Ops, TDD, ATDD, BDD Documentation Tools MS Office Suite, SharePoint, Confluence, MS Access, MS Excel Web Technologies XML, JSON, HTML, SOAP, RESTful Project management tools Rally, Version One, JIRA, MS SharePoint, Confluence, Azure DevOps Testing tools HP ALM, Soap UI, Postman, Jenkins, Selenium, Swagger Client: New York City, Department of Buildings Aprill 2022-Present Role: Sr. Business System Analyst Project: Zoning Challenge and Appeal Worked with the Product Manager in illustrating Work Breakdown Structure, Project Roadmap, and its Milestones to articulate Strategic Thinking while considering desired Project Goals. Performed Document Analysis to understand the Legacy System's As-Is Process by referring legacy System's Business Requirement Document (BRD), Organization Process and Procedure Documents, Request for Proposal (RFP), and System Defect Report. Created different Business Requirements Documents such as, Business Requirement Document (BRD), Status Matrix, Email Matrix, Alert & Notification Matrix to help the team to understand the requirements. Worked with Stakeholders to gather the Requirements for the Project and to discuss the BRD and other key Documents Such as DD (Data Dictionary), Email matrix, Alert & Notification Matrix and Status Matrix after gathering the Requirements. Analyzed the Requirement document provided by the business and Created Data Dictionaries for all the forms needed for the Business requirements. Created User stories and Features on the Azure DevOps from the business requirements and track down the progress of these stories and features and Sprint using the Burn- up and Burn down charts. Helped the training team to understand the Workflow of the new Business requirements and assisted them to create the Training manual for these new Business Requirements. Executed GAP Analysis to identify Legacy System by defining the As-Is and To-Be process from the gathered business requirements and recorded the Action Plan that should be implemented while upgrading the software. Performed various analyses like Impact Analysis, ROI Analysis, and Root Cause Analysis to validate the feasibility of Decision and Strategies framed by the business entity. Proactively tracked the Project and Team s Progress using ADO KPI s like Burnup Charts, Burndown Charts, Cumulative Flow Charts and shared the Weekly Progress Reports to the key stakeholders. Assisted in creating Test strategies, Test Plans, Test Cases, and Test Scenarios based on the User Stories and Acceptance Criteria defined according to the business requirements. Created UML diagrams such as Activity flow diagram, Sequence Diagram and Data flow diagram as per different functionalities requirement for Dev. Team. Worked on and tested Interface/API functions Screen, Window, Webpage technical process flow - menu structuring and route from screen to screen Documented all the UAT remarks, ensuring all the Bugs/Defects are added in the TFS tool, raised as a ticket, and resolved immediately using the Requirements Traceability Matrix (RTM) to locate the errors precisely. Facilitated a sprint retrospective session to understand team satisfaction and figure out better ways to meet the sprint goals by conducting an Agile Retrospective Game called Lean Coffee. Written the Client-side validations, Server-side validations, and Database validations for the system. Conducted Functional Testing and Smoke Testing regularly to ensure the basic functionalities of the system are working properly. Environment: Hybrid (Waterfall/ Agile), MS Visio, MS Office Suite, TFS, SharePoint, BRD, Business Requirements Documentation. Client: Assurant, Atlanta, GA July 2021-March 2022 Role: Sr. Business System Analyst Project: ADT DF Integration Executed GAP Analysis to identify Legacy System by defining the As-Is and To-Be process from the gathered business requirements and recorded the Action Plan that should be implemented while upgrading the software. Proactively engaged in Agile ceremonies, including Sprint Planning, Daily Stand-Up, Sprint Review, Sprint Retrospective, and Backlog Refinement Sessions. Performed Due Diligence in converting Elicited Requirements into User Stories in accordance to INVEST Criteria. Extensively involved in calculating Capacity and Velocity of the scrum team which helped in determining Team Readiness and sprints required to develop all the gathered Business Requirements. Lead story point estimation session by following the Planning Poker Technique using Fibonacci Series with the scrum team to assign story points for the User Stories in the product backlog. Lead Backlog Refinement Session with Product Owner and Scrum Team to refine the User Stories, Prioritized the user stories in the product backlog using MoSCoW Technique according to the Project Roadmap, and worked on Spike Stories by analyzing feasible techniques with SME s to execute it in future sprints. Proactively tracked the Project and Team s Progress using ADO KPI s like Burnup Charts, Burndown Charts, Cumulative Flow Charts and shared the Weekly Progress Reports to the key stakeholders. Assisted to create Test strategies, Test Plans, Test Cases, and Test Scenarios based on the User Stories and Acceptance Criteria defined according to the business requirements. Assisted in API testing using Postman to check if the APIs are returning the data in JSON, XML format as defined in the API documentation along with automating the workflows. Worked on and tested Interface/API functions Screen, Window, Webpage technical process flow - menu structuring and route from screen to screen Conducted review session of Data modeling with DBA to have best fit physical Model indexex for better DB performance. Documented all the UAT remarks, ensuring all the Bugs/Defects are added in the JIRA tool, raised as a ticket, and resolved immediately using the Requirements Traceability Matrix (RTM) to locate the errors precisely. Facilitated a sprint retrospective session to understand scrum team satisfaction and figure out better ways to meet the sprint goals by conducting an Agile Retrospective Game called Lean Coffee. Used the UDDI registry to look up existing web services and WSDL to identify the request and response parameters for defining web methods while also identifying and creating the Service Level Agreements (SLAs) for 3rd party vendors (Third-party vendors) and integration teams when required. Used SQL to retrieve information from the Database and identified the Primary Key and Foreign Key relationship between various items in the database tables. Written the Client-side validations, Server-side validations, and Database validations for the system. Environment: Agile- Scrum, (HTML/CSS, Java, SQL), MS Visio, MS Office Suite, Azure DevOps, SharePoint, Web Services, API, Microservices, AJAX, JSON, Postman, RESTful Services. Client: Bankers Healthcare Group, Davie, FL January 2021-June 2021 Role: Sr. Business System Analyst Project: Salesforce Integration (Lead flow) Executed GAP Analysis to identify Legacy System by defining the As-Is and To-Be process from the gathered business requirements and recorded the Action Plan that should be implemented while upgrading the software. Performed various analyses like Impact Analysis, ROI Analysis, and Root Cause Analysis to validate the feasibility of Decision and Strategies framed by the business entity. Proactively engaged in Agile ceremonies, including Sprint Planning, Daily Stand-Up, Sprint Review, Sprint Retrospective, and Backlog Refinement Sessions. Performed Due Diligence in converting Elicited Requirements into User Stories in accordance to INVEST Criteria. Extensively involved in calculating Capacity and Velocity of the scrum team which helped in determining Team Readiness and sprints required to develop all the gathered Business Requirements. Lead story point estimation session by following the Planning Poker Technique using Fibonacci Series with the scrum team to assign story points for the User Stories in the product backlog. Lead Backlog Refinement Session with Product Owner and Scrum Team to refine the User Stories, Prioritized the user stories in the product backlog using MoSCoW Technique according to the Project Roadmap, and worked on Spike Stories by analyzing feasible techniques with SME s to execute it in future sprints. Proactively tracked the Project and Team s Progress using JIRA KPI s like Burnup Charts, Burndown Charts, Cumulative Flow Charts and shared the Weekly Progress Reports to the key stakeholders. Effectively managed CI/CD pipeline with the help of DevOps Engineers to ensure efficiency in lead time by measuring performance with certain metrics like Bug Resolution Time, Lead Time, and Bottlenecks. Assisted in API testing using Postman to check if the APIs are returning the data in JSON, XML format as defined in the API documentation along with automating the workflows. Worked on and tested Interface/API functions Screen, Window, Webpage technical process flow - menu structuring and route from screen to screen Used SSIS to create ETL Package to Validate, Extract, transform and load data into Data warehouse and data marts. Facilitated the User Acceptance Testing (UAT) session before every release with the UAT Execution plan by inviting the right stakeholders to work on developed software to check its Capability to handle the Real-World Organizational Scenarios that reflects the organizational goals. Documented all the UAT remarks, ensuring all the Bugs/Defects are added in the JIRA tool, raised as a ticket, and resolved immediately using the Requirements Traceability Matrix (RTM) to locate the errors precisely. Facilitated a sprint retrospective session to understand scrum team satisfaction and figure out better ways to meet the sprint goals by conducting an Agile Retrospective Game called Lean Coffee. Used the UDDI registry to look up existing web services and WSDL to identify the request and response parameters for defining web methods while also identifying and creating the Service Level Agreements (SLAs) for 3rd party vendors (Third-party vendors) and integration teams when required. Used SQL to retrieve information from the Database and identified the Primary Key and Foreign Key relationship between various items in the database tables. Written the Client-side validations, Server-side validations, and Database validations for the system. Conducted Functional Testing and Smoke Testing regularly to ensure the basic functionalities of the system are working properly. Environment: Agile- Scrum, (HTML/CSS, Java, SQL), MS Project, MS Visio, MS Office Suite, JIRA, SharePoint, Confluence, Web Services, API, Microservices, AJAX, JSON, Postman, RESTful Services. Client: Centene Corporation, St. Louis, MO July 2019-December 2020 Role: Sr. Business System Analyst Project: Enhancement of Claim Adjudication system Coordinated with Product Owner, Claims Managers, Claim Processing Agents to bring all processes to a level of execution to mitigate any impact to the Claim Adjudication Process under the HIPAA 5010 Omnibus Rule and HITECH Act. Performed Document Analysis to understand the Legacy System's As-Is Process by referring legacy System's Business Requirement Document (BRD), Organization Process and Procedure Documents, Request for Proposal (RFP), and System Defect Report. Executed GAP Analysis to identify Legacy System by defining the As-Is and To-Be process from the gathered business requirements and recorded the Action Plan that should be implemented while upgrading the software. Performed various analyses like Impact Analysis, ROI Analysis, and Root Cause Analysis to validate the feasibility of Decision and Strategies framed by the business entity. Created Business Process Model and Notation (BPMN) and Unified Modelling Language (UML) based diagrams using Microsoft Visio to create Use Case Diagrams, Activity Diagrams, and Sequence Diagrams to render Business Requirements into Business Process Flow and performed requirement analysis to validate elicited requirements. Proactively engaged in Agile ceremonies, including Sprint Planning, Daily Stand-Up, Sprint Review, Sprint Retrospective, and Backlog Refinement Sessions. Performed Due Diligence in converting Elicited Requirements into User Stories in accordance to INVEST Criteria. Worked on Medicare Advantage (A, B, C), Medicare Part D, Medicaid Options (Under 65 and Over 65), and Managed care. Analyzed the change requirements for Providers, Contracts, and Claims processing modules configuration in facets system for Medicaid and Medicare Advantage plans. Tested claims adjudication process for the new Medicare advantage members. Lead story point estimation session by following the Planning Poker Technique using Fibonacci Series with the scrum team to assign story points for the User Stories in the product backlog. Lead Backlog Refinement Session with Product Owner and Scrum Team to refine the User Stories, Prioritized the user stories in the product backlog using MoSCoW Technique according to the Project Roadmap, and worked on Spike Stories by analyzing feasible techniques with SME s to execute it in future sprints. Proactively tracked the Project and Team s Progress using Rally KPI s like Burnup Charts, Burndown Charts, Cumulative Flow Charts and shared the Weekly Progress Reports to the key stakeholders. Analyzed and validated the data provider to determine Business-to-Business (B2B) patient data transactions in HL7 standards by obtaining FHIR RESTful web services. Designed prototype of Asynchronous Orchestration Processes in MS Visio by invoking respective Web Services and API s to validate batch processed insurance claims in Facets. Collaborate with UI/UX, API and System teams to support development initiatives Knowledge of JSON involved. Performed Data Mapping to identify and standardize data from the OLTP to OLAP database in various distributed systems during Extract Transform Load (ETL) processes by applying transformational rules using Informatica PowerCenter. Created Test strategies, Test Plans, Test Cases, and Test Scenarios based on the User Stories and Acceptance Criteria defined according to the business requirements. Facilitated the User Acceptance Testing (UAT) session before every release with the UAT Execution plan by inviting the right stakeholders to work on developed software to check its Capability to handle the Real-World Organizational Scenarios that reflects the organizational goals. Documented all the UAT remarks, ensuring all the Bugs/Defects are added in the Rally tool, raised as a ticket, and resolved immediately using the Requirements Traceability Matrix (RTM) to locate the errors precisely. Ensured the software is compliant with the Regulatory Rules of HIPAA by performing Audit Trial to figure out Technical and Operational Gaps to resolve the issues priorly. Used the UDDI registry to look up existing web services and WSDL to identify the request and response parameters for defining web methods while also identifying and creating the Service Level Agreements (SLAs) for 3rd party vendors (Third-party vendors) and integration teams when required. Conducted Functional Testing and Smoke Testing regularly to ensure the basic functionalities of the system are working properly. Environment: Agile- SAFe (Scaled Agile) Framework- (HTML/CSS, Java, SQL), MS Project, MS Visio, MS Office Suite, Rally, SharePoint, TFS, Informatica PowerCenter, Web Services, API, Microservices, AJAX, JSON, Postman, RESTful Services. Client: Silicon Valley Bank, Tempe, AZ Jan 2018- June 2019 Role: Business System Analyst Project: Enhancement of Mortgage Loan Origination System Elicited Business Requirements by conducting detailed Interviews and Focus Group Sessions with Business Users, Stakeholders, and Subject Matter Experts (SME s) like Confidential Servicers, Underwriters, Credit Analyst to define the Financial Projections and Cost-Benefit Analysis. Worked closely with the Product Owner to elicit Business requirements from the stakeholders and assisted the Product Owner in developing user stories and Acceptance Criteria into the Product Backlog. Coordinated with Residential Underwriter, Mortgage loan servicer, Credit Analyst, and Compliance Professionals to determine the Business rules concerning Fixed-rate mortgage loan, Adjustable-rate mortgage loan, Government-Insured Mortgages, Jumbo Mortgages, and Conventional Mortgages. Documented the gathered requirements in BRD and facilitated the JAD session where Requirement Modeling was done by drafting UML diagrams and BPMN Diagrams to identify the area where the Customization is needed. Performed GAP analysis As-Is and To-Be for the elicited requirements to analyze if the Loan Origination System is capable to meet the business requirements. Engaged in all scrum ceremonies like Sprint Planning, Daily Stand-up, Sprint Review, Sprint Retrospective, and Backlog Refinement sessions. Authored User Stories and Acceptance Criteria for the business requirements using INVEST criteria pertaining to the ATDD approach. Managed team to build-up their velocity and manage performance using Agile KPIs like Velocity chart, and Burnup chart in Jira Tool. Defined and suggested SOAP, XML based Web services, and Application programming interfaces (API) based on languages such as (C#, JAVA) which would be compatible with the As-Is and To-Be state of the business process. Worked closely with the development team to verify that business needs are Fulfilled, and Deliverables are produced within the specified Budget, Quality, and Time. Facilitated UAT sessions and developed Test Plans and Test Cases for verification and validation of requirements at all levels. Actively trained business users involved in Sprint Review and Demonstrated the configured application to validate on agreed requirements as per the defined Definition of Done (DOD) criteria expected by the Product Owner and business stakeholders. Hands-on experience in Star schemas, Snowflake schemas, Dimensional modeling and Reporting tools, Operations Data Store concepts, Data Marts and OLAP technologies. Extensive experience in Relational Database Management System including developing optimized SQL queries, Stored Procedures, User-defined Functions, and Transactions. Experience in Normalization and De-Normalization techniques for OLTP and OLAP systems in creating Database Objects like Tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes. Worked with UI/UX team to introduce JavaScript to add user interaction to enrich the user experience. Ensured the application is compliant with all TRID regulations, AML laws, and OFAC BSA, FINCEN, HMDA regulations. Environment: Agile- Scrum Framework- (HTML/CSS, Java, MS SQL Server 13.0), MS Project, MS Visio, MS Office Suite, Jira, Tableau, Web Services, API, Microservices, AJAX, RESTful Services, SharePoint, TDD Client: United Healthcare Group, Hartford, CT June 2017 December 2017 Role: Business System Analyst Project: Enhancement of Enrollment Management system Elicited Business Requirements by conducting detailed Interviews and Focus Group Sessions with Business Users, Stakeholders, and Subject Matter Experts (SME s). Developed solid documentation by analyzing As-Is processes and designed Business Processes Model and Notation (BPMN) and Unified Modelling Language (UML) diagrams to draft Object-Oriented Design to demonstrate the To-Be process in Walkthrough Session. Performed GAP analysis on the current state of the business process (As-Is) and documented the Action Plan and (To-Be) state from the gathered requirement to Fill the Gap in the process of LOS. Engaged in all scrum ceremonies Sprint planning, Daily stand up, Sprint review, Sprint retrospective, and Backlog refinement. Served as project lead on large scale technical projects, such as curriculum reconfiguration, development of a parent portal and online application evaluation software. Participated in requirement gathering sessions for identifying and validating best practice requirements for large-scale automated systems. Ensured Healthcare Interoperable data flow between Enrollment Management application and other Lines of Business (LOB) are e-PHI format as per HIPAA regulations by integrating HL7 s FHIR API. Ensured the application is compliant with HIPAA, and HL7 Standards, laws throughout the project lifecycle. Worked closely with the End-Users and Stakeholders to develop a detailed understanding of the requirements and transformed them into User Stories and made sure they met the Definition of Ready using INVEST criteria. Validated the Web Service request and response payloads and assisted the developers in API documentation using the Postman. Facilitated bug triage meetings in every sprint to review the Defects/ Bugs and Prioritized it with the help of the test lead in resolving it. Coordinated with database administrators/ SQL developers in improving backend performance by participating in conceptual re-design and logical redesign of the existing database Facilitated User Acceptance Testing (UAT), and guided business users by providing User Manual Guides to Validate and Verify the business requirements of the developed application under business scenarios. Environment: Windows (7/Vista/8), MS Office Suite (Word, PowerPoint, Excel, Outlook), MS Project, Visio, UML, SQL Server Services SSRS, SSIS, SSAS, Mockup Screens. Client: Flipkart, Bangalore, India July 2015- Dec 2016 Role: Business System Analyst Project: Enhancement of Inventory Management System Gathered Requirements through different elicitation techniques such as, Document Analysis, Brainstorming, Interviewing, and conducting JAD sessions with designers, developers, business users, and SME s. Documented gathered requirements in Business Requirements Document (BRD), Functional Requirements Documents (FRD), Non-functional Requirements Document (NFRD) and System Requirements Documents (SRD). Conducted Gap analysis of the current state of the system and future state of the system, SWOT analysis to identify the areas of improvement and feasibility analysis of the proposed enhancements Created and maintained Narrative Use Cases (Business Use Cases, System Use Cases) and modeled Use Case Diagrams, Activity Diagrams, Data Flow Diagrams using Microsoft Visio Used SQL queries to compare the database and the periodic reports generated by the application at various levels Performed Requirement Analysis by gathering both functional and nonfunctional requirements based on interactions with the process owners & stakeholders and document analysis, represented them in Requirements Traceability Matrix (RTM) Prepared test cases and test scenarios, identified and established Positive and Negative test cases and coordinated other QA s in executing the test plans. Conducted User Acceptance Testing (UAT), beta testing, and involved in code review sessions to ensure that the functionality of the system aligned with the business requirements specified in the BRD. Environment: Waterfall Methodology (HTML/CSS, Java, SQL), MS Visio, SQL Server, MS Office suite, MS Project Professional, Mockup screens, HTML, XML, SharePoint Certification SMAC - Scrum Master Accredited Certification IBM SQL for Data Science Education Master s in Engineering Technology Management, Bowling Green State University, Ohio. Bachelors in Automobile Engineering, India Keywords: cprogramm csharp continuous integration continuous deployment quality analyst user interface user experience business intelligence database information technology hewlett packard microsoft Arizona Connecticut Delaware Florida Georgia Missouri