SUMMARY

• Business Analyst with 8 years of IT Experience while working in all phases of SDLC converting technical and business requirements into software application. Excellent analytical and problem - solving skills in designing, developing, and implementing innovative business processes and providing system solutions using new approaches while having working knowledge of the concepts and workflows of Domain included Health Care, Insurance (Health Insurance, Property & Casualty Insurance, Auto Insurance, Reinsurance).
• Experience handling multiple projects in a fast-paced cross functional environment, efficient team player with strong leadership skills, excellent interpersonal skills and strong verbal and written communication.
• Proficient in working with different Software Development Life Cycle (SDLC) forms like Waterfall, Agile methodologies like Scrum, Scrum-Waterfall (Hybrid), Kanban as well as Scaled Agile Framework (SAFe).
• Well versed in claim management i.e., FNOL, Claim Setup, Payment & Recovery, Fraud Detection Tools, Litigation, Subrogation and Salvage and HIPAA Compliances (837, 835, 834, 820, 270, 271, 276, 278, 997).
• Proficient in documenting customization requirements, business rules and data migration requirements for the implementation and integration of Guidewire Claim Center, Guidewire Policy Center and Billing Center.
• Expertise in Claims Processing, Billing, Quote and Bind operations, Quality Management and Risk Management and profound knowledge in Claim management (FNOL, Payment and recovery, fraud detection tools, Salvage) and experienced in Data Visualization, Data Analysis and business intelligence. Rendered Business and Functional Specification, Technical Specification, Testing Plans and Reporting.
• Authored Business Requirement Documents (BRD) and Functional Specification Document (FSD), System Requirement Specification (SRS), Project Management Plan (PMP) and helped in the creation of the Project Charter.
• Participated in various Scrum Ceremonies like Sprint Planning, Sprint Review and Sprint Retrospective and Daily Stand-up with the Scrum Master with understanding in different development techniques such as TDD, BDD and ATDD.
• Experienced with Project Collaboration tools like JIRA and HP-ALM, assisted in writing Epics, User Stories and helped in handling the Requirements Churn. Efficient in facilitating prioritization techniques like Moscow, KANO Model and Estimation techniques like Planning Poker, T-shirt Sizing, Relative Mass Evaluation.
• Involved in the end-to-end processes Prototyping, User interfaces using Wireframes and Mock-Ups.
• Created Unified Modeling Language (UML) diagrams like Use Case, Activity and Sequence Diagrams using Lucid charts.
• Drafted Entity Relationship (E-R) Diagrams with conceptual and logical data modelling using Microsoft Visio.
• Worked on data migration from on-prem legacy database to cloud-based database with MySQL engine.
• Frequently used Data Definition Language (DDL), Data Manipulation Language (DML) in SQL to perform CRUD operations on the database including Joins, Aggregators, Views Triggers and Stored Procedures.
• Perform the data profiling to identify the redundancy in the data using complex SQL queries (Select, Insert, Update, Delete).
• Knowledge of OLAP operations like slice & dice, Rollup, drill down, Pivot and Data Warehouse design.
• Formidable using Informatica for Extraction, Transformation and Loading (ETL), expert in source to target transformation.
• Sound understanding towards different architectural implementation such as n-tier architecture, SOA, IaaS, PaaS and SaaS and implementation approaches like Dimensional Modeling translating the requirements into Star, Snowflake and Galaxy Schema generating Data Lineage Reports to maintain Referential Integrity during the mapping of the process.
• Implemented appropriate API request and response call for Business requirements using SOAP, REST, AJAX, JSON, and XML.
• Documented HTTP verbs (GET, POST, UPDATE, DELETE) using MuleSoft API Manager, Swagger Editor, Swagger UI, Codegen.
• In-Depth knowledge of User Acceptance Testing (UAT), with experience in creating test cases and test plans. Served the Quality Assurance (QA) team to perform Black-Box Testing, GUI Testing, Functionality, Regression, System, Unit, Web Service and Volume Testing in tools such as Cucumber and Selenium.
• Have Knowledge about Guidewire Policy Center, Guidewire Claim Center and Billing center in Policy Info, Person Info, Losses and Violations, Coverage’s, Risk Analysis Customizations.

TECHNICAL SKILLS

Requirement management: JIRA (v.6.3, 7.0), HP ALM (v.11.5), HP-QC (v.11, 12), MS Project (2010, 2013), MS SharePoint (2010, 2013), Confluence (v.6.4, 6.3, 6.2)

Modeling Tools: MS Visio (v.14, 15, 16), Balsamiq Mockups, Lucid Chart, Draw.io

BI/Reporting: Tableau (v. 9.3, 10.0, 10.1), Kibana, MS Office Suite (Excel, Word, PowerPoint) (2010, 2013, 2016), Prezi, MicroStrategy, Power BI, QlikView, Cognos

ETL Tools: Informatica Power Center (v. 9.5, 9.6.1), Glue, Pentho MS SQL Server (2012, 2014), My SQL, and Cloud

API: SOAP, REST, XML, B-PIPE, STML, WSDL

Testing Tools and Defect Management: Cucumber (v3.0), POSTMAN (v.3, 4, 5, 6), SWAGGER (v.2.0, 3.0), SOAP UI, HP-QC, Junit

Databases and Cloud Technologies: MYSQL Server, Teradata, MongoDB, Salesforce, Guidewire

PROFESSIONAL EXPERIENCE

Confidential - Cary, NC

Business Systems Analyst

Responsibilities:

• Conducted the HIPAA Compliant X12N 837 transaction testing. Worked on EDI transactions 270,271, 834, 820, 835 and 837 to identify key data set elements for the designated record set. Interacted with Claims, Payments and Enrollment and thus analyzing requirements and creating detailed specifications.
• Identified the scenarios based on business requirements and HIPAA compliances for each transaction such as the 837 (claim transaction) and 276 (claim status inquiry)/277 (claim status response).
• Performed GAP analysis to identify the As-Is and To-Be process vision to understand the deficiency of the current application and the intended application. Captured the non-functional requirements and documented them.
• Designed high fidelity and low fidelity Mock-up Screens and Wire Frames for applications using Balsamiq. Created activity, use case and sequence to view the system from different perspectives using Lucid Charts.
• Gathered business requirements through JAD sessions and one-on-one interviews with the stakeholders.
• Understood the business process that includes Sales processes, Rating methodology, Different products, Eligibility and enrolment processes as well as responsible for interacting with client requirements gathering.
• Worked with Product Owner and development team in negotiating and deciding Definition of Ready (DOR), Definition of Done (DOD) and Acceptance Criteria for user stories during the backlog grooming meetings
• Helped the Project Owner to create as well as breakdown the epics into user stories using Vertical, Horizontal and Vertical-Horizontal hybrid slicing. used project collaboration tools like JIRA to manage the User Stories, actively participated scrum ceremonies while assisting in prioritization of the Product Backlog Items (PBIs) using MoSCoW method.
• Assisted the Product Owner in writing Acceptance Criteria utilizing the Gherkin format using Cucumber to make sure that they are ready for execution when needed. Assisted in testing member enrollment, eligibility enquiry, eligibility response, claim status enquiry, claim status response and conversion of financial claims.
• Helped and coordinated with the ETL team to construct OLAP queries through ETL packages for the processing of the multidimensional encrypted data from the data warehouse to decrypt, analyze and format a report.
• Incorporated the migration process by identifying the data sources and transferring the data from RDBMS to salesforce cloud.
• Executed sample queries in the PostgreSQL database using joins unions and conditional statements to validate the extraction of the data from the MongoDB database to the PostgreSQL database.
• Used MuleSoft API manager as Any-Point of Exchange to integrate current system with Salesforce CRM by making the REST’s Bulk API calls to upload the data and Lightning Bolt to the fetch the data from Salesforce.
• Assisted the admin in using the Einstein Analytics to create application dashboards and pre-built data sets in the salesforce, lenses to explore the data sets within Salesforce.com (SFDC).
• Assisted in documenting the tickets generated by Einstein Bot and making sure they are recorded in the Service Cloud, analyzed the reports generated in the Sales Cloud regarding the customer service experience.
• Collaborated with QA team in designing test plans, test cases and test scripts and schedule UAT managed feedback, aided them in performing Unit Testing, Integration Testing, System Testing. Responsible for creating business workflows and processes and creating management reports based in the analysis.
• Created API Documentation using Swagger and performed API testing using POSTMAN to check if the API is returning the data in XML, JSON format as specified in the API documentation for the information flow.
• Responsible for reporting status ensuring accurate coverage of requirements and business rules.

Environment: Agile-Scrum, MS Visio (version 16.0), MS-Project, MS Office Suite, JIRA (version 7.4), Confluence (version 6.2), Informatica PowerCenter (version 9.6.1), Cucumber (version 3.0), Salesforce, Kafka connect, HDFS, SQL, Kibana, Prezi.

Confidential, Charlotte, NC

Sr Business System Analyst

Responsibilities:

• Adopted Agile Process and its best practices as the process product for implementing the project.
• Act as the liaison between business, developers and project management. Working with the business owner, project manager and technical team to document the products vision and establish the project scope.
• Performed GAP analysis and interacted with SME’s, project managers, developers for solving open and pending issues.
• Updated the existing business process diagrams and created new business process diagram.
• Elicited information from end users and senior management to display requirements in a format that allows for easy review, approval and implementation. Documented business scripts after understanding the system thoroughly and translating them to the developers to help in corporate the features into the future system.
• Analyzed the business rules for Auto claim assignments throughout the US, so as to have balanced work load for all the claims reps. The Guidewire Claim center application uses Java to write data from Claim Center to Staging Tables as part of Distributed Team.
• Hands on experience with guidewire policy center and claim center(workers compensation claims, General claims) upgradation to v9
• Performed migration from the in house legacy based underwriting, policy center, claims center and billing Centre applications to guidewire
• Gathered requirements developed process model and detailed business policies. Elicited information from end users and senior management to display requirements in a for easy review, approval and implementation.
• Created High Fidelity and Low Fidelity UI wireframes and mock-ups using Balsamiq.
• Documented business scripts after understanding the system thoroughly and translating them to the developers to help in corporate the current system features into the future system.
• Helped to breakdown epics into user stories, used project collaboration tools like JIRA to manage the User Stories assisted in prioritization of the Product Backlog Items (PBIs) using MoSCoW.
• Aggressively participated and assisted the Scrum Master in various Scrum Ceremonies like Sprint Planning, Daily standup, Sprint Review and Sprint Retrospective.
• Frequently used Requirements Traceability Matrix (RTM) for identifying and tracking the linkages.
• Collaborated with QA team in designing test plans, test cases and test scripts and schedule UAT managed feedback, aided them in performing Unit Testing, Integration Testing, System Testing. Responsible for creating business workflows and processes and creating management reports based in the analysis.
• Documented the API using Swagger and performed API testing using SOAPUI to check if the API is returned in the required JASON and XML format and communicated it with the development team.

Environment: Agile-scrum, MS Office (MS Word, MS Excel, MS PowerPoint), MS SharePoint, MS Visio, JIRA, Balsamiq, Swagger, SoaPUI, Guidewire

Confidential - Seattle, WA

Business System Analyst

Responsibilities:

• Conducted JAD sessions, requirement workshops and interviews with stakeholders and Guidewire consultants to document the requirements using user stories for the Guidewire Customer Engage suite to be implemented.
• Responsible for developing a survey of a large sample of certified internal users to establish risk assessment guidelines.
• Identified gaps in existing policy administrating systems and Guidewire Policy Center and designed the AS-IS and TO-BE process, the scope and out of scope documents.
• Create use case diagrams for claim filing journey and developed UML diagrams like Use Case diagrams, Sequencediagrams and flow diagrams using Rational Rose.
• Responsible for the Source system exploration and analysis, Data transformation logics by creating Data Mapping
• Document, performing the data mapping and validating the Data Marts using the Informatica PowerCenter.
• Performed data integration and data mapping and extraction management along with data cleansing while migrating data from legacy system to Guidewire Claim Center and Guidewire Data Hub.
• Helped the Product owner in finalizing the Minimum viable product (MVP) and maintaining the Product Backlog and the Sprint Backlog by assisting the Product owner in prioritization and estimation of Product Backlog Items.
• Assisted the Scrum Master to maintain the Sprint/ Release Burn-up and Burn-Down charts, Velocity Chart in JIRA.
• Managed sprints artifacts i.e. burndown charts, project velocity, sprint backlogs and product backlogs using JIRA, managed and shared these artifacts using Confluence tool.
• Performed data integration and data mapping management along with data cleansing while migrating data from legacy system to Guidewire Policy Center.
• Worked with QA team to design and develop Test Plan, Test Scenarios and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing and maintained the report for the test results.
• Analyzed the data in the data warehouse using Tableau.
• Actively involved in product release and deployment phase to end-users after development and testing of the product and assisted the team in preparing training material for Underwriters, agents and Claims staff.

Environment: Agile-Scrum, Guide Wire Data Hub, MS Visio, SQL, MS Excel, MS PowerPoint, Mock-Up Screens, MS Office Suite, JIRA, JENKINS, MS-SharePoint, MS SQL Server, Oracle, MS Access, MS Project, Cucumber, Tableau, Informatica PowerCenter.

Confidential, Boston, MA

Business Analyst

Responsibilities:

• Conducted interviews with project managers, SMEs business users to collect requirement and business process information and reviewed the Business Requirement Document (BRD), System Specification Document (SRS) to understand the stakeholder’s requirements from testing perspective.
• Created, Maintained and Mapped the Requirement Traceability Matrix (RTM) to track the requirements with their test cases, to ensure all the requirements are defined for the system.
• Mapped organization business process to Salesforce functionality. Carried out data mapping from source repositories to Salesforce application.
• Designed Use Case Diagrams and Use Case Specification documents based on requirements gathered. Derived Functional Requirement Specifications (FRS) based on User Requirements Specification.
• Perform detailed analysis of business and technical requirements and worked with the development team to design the solution by customizing various standard objects.
• Involved in the implementation of Salesforce Chatter by designing a central platform for information sharing and tracking updates on objects and records by Salesforce users.
• Worked with the development team to designed page layouts, search layouts to organize fields, custom links, related lists, and other components on a record detail and edit pages.
• Worked with development team to create workflow rules and defined related tasks, time triggered tasks, email alerts, field updates to implement business logic and business rules.
• Used Tableau for creating various Reports (summary reports, matrix reports, pie charts, dashboards and graphics) and Report Folders to assist managers to better utilize Salesforce as a sales tool and configured various Reports for different user profiles.
• Created Mockups and Wireframes using Balsamiq for the UI requirements.
• Performed Performance (Load/Stress) testing and Volume testing using HP LoadRunner.
• Conducted Integration Testing, Functional Testing and Regression testing for the application.
• Responsible for collecting the defect details, logging the defects and coordinating with the team for defect resolution and maintain the report to track defects to closure using issue tracking in HP-ALM.
• Involved in backend testing for the data validation in reports using complex SQL queries and functions.
• Assisted in preparation of UAT test plan, Test Cases, Testing Cycle, Test Scenarios and implemented them with QA team. Created custom reports and dashboards using Tableau and reported them to the stakeholders.

Environment: Agile/Scrum, JIRA, Balsamiq, HP LoadRunner, HP QC, MS SQL Server, MS Visio, MS Office (MS word, MS power point, MS excel), Confluence, Tableau, Salesforce platform, Apex language, Visual Force, Sandbox data loading, Windows XP, UML, Visio, Oracle CRM 12 suite.

Confidential

Jr Business Analyst

Responsibilities:

• Worked in Waterfall Methodology environment and extensively involved in Software Testing Life Cycle (STLC) phases Requirement Analysis, Test Planning, Test Case Development, Environment Setup, Test Execution and Test cycle closure.
• Defined Entry and Exit criteria for all STLC phases and prepared the Requirements Traceability Matrix artifact.
• Studied the requirement from testing point of view to identify the testable requirements by interacting with the various stakeholders.
• Identified test requirements from specifications, mapped test case requirements and designed test coverage plans.
• Develop, document and maintain functional test cases and other test artifacts like test data, data validation, harness scripts and automated scripts using HP QC and actively involved in Defect Life Cycle Management and assisted in creating Issue Tags
• Helped in creating Review artifacts for the corresponding change request and assisted in making the review artifact signed off.
• Identified potential quality issues per defined process and escalated quality issues immediately to management using Prezi presentation.

Environment: Waterfall model, HTML, CSS, SharePoint, SQL, SWOT, MS Excel 2010, MS PowerPoint 2010, HP QC, Prezi Business Presentation, Confluence.