SUMMARY

• Sr. Business Systems Analyst with over 8+ years of diverse experience in investigating and gathering requirements for business processes in functional and technical roles in Property & Casualty Insurance, Health Insurance, and IT domains
• Extensive knowledge and working exposure in P&C (Property & Casualty) insurance Auto, Liability, Home and Marine Life Insurance/Annuities along with Health Insurance & IT domains
• Working experience with health insurance concepts such as HIPAA and FDA guidelines, Medicare and Medicaid, Electronic Health Records (EHR), Health Effectiveness data and Information Set (HEDIS) measures, Remote Patient Monitoring, Internet of Healthcare Things (IoHT), Monitoring devices, KPI tracking and Salesforce Health Cloud
• Exposure to ACORD Property & Casualty standards and ISO (Insurance Services Office) tools and conventions
• Profound understanding of other industry standard Software Development Life cycle methodologies such as Extreme Programming (XP), Rational Unified Process (RUP), Spiral, Kanban and Scrumban, proficient with STLC process
• Comprehensive working knowledge of various SDLC methodologies like Waterfall, Agile (Scrum), Water - Scrum-Fall (Agile Hybrid)
• Profound knowledge of Agile (Scrum) framework including Scrum ceremonies like Backlog Grooming, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective. Efficiently documented various Scrum Artifacts such as Product Backlog, Sprint Backlog, Information Radiators (Burn-up - Burn-down charts)
• Acted as a liaison between Business and Technical Stakeholders to elicit various Functional and Non-functional requirements through a variety of elicitation techniques such as Stakeholder Analysis, Interview, Brainstorming, JAD & RAD sessions, Requirements Workshop, Survey/Questionnaire, Document Analysis, Focus Groups etc.
• Efficiently converted the requirements into technical specifications and articulated across all the stakeholders
• Conducted multiple Feasibility studies, Risk Analysis, Cost Benefit Analysis, SWOT analysis and Impact Analysis to analyze the needs of a project and its execution. Performed GAP Analysis to understand AS-IS and TO-BE business processes
• Closely assisted the Product Owner in requirement elaboration and acted as a Proxy Product Owner as and when required
• Created multiple deliverables such as Business Requirements Document (BRD), System Requirements Specification (SRS), Functional Specification Document (FSD), Data Requirements Specification (DRS), Project Charter, Project Plan, RTM and RACI matrix thereby possessing broad knowledge of documenting and presenting deliverables at every milestone
• Improved the teams’ competencies by creating Work Breakdown Structures (WBS) and Critical Path Analysis (CPA)
• Managed Requirement Churn carefully and efficiently documented Change Management plan
• Highly proficient in creating Use Case Document and Unified Modeling Language (UML) diagrams like Use Case diagrams, Activity diagrams and Sequence diagrams using different versions of MS Visio and Lucid Chart
• By identifying various Entities and their Relationships, created Entity-Relationship Diagrams (ER) and the associated Conceptual and Logical Data Model to define the required objects accurately (without any redundancy) in the database. Helped understand anomalies in the database design and Normalization to address them
• Efficient in breaking down Epics into User stories keeping the INVEST criteria in acceptable limits. Experience in slicing the user stories using Horizontal and Vertical Slicing Techniques, prioritizing user stories using techniques such as MoSCoW, Kano and estimating user stories using techniques like Planning Poker, T-shirt Sizing and Relative Mass Valuation
• Proficient in creating Prototypes, drafting Mockups and Wireframes to visually present the requirements to the Stakeholders for better understanding the outcome and to accommodate any changes, using Lucid Chart and Balsamiq
• Skillfully supported the Product Owner to define Minimum Viable Product (MVP), Minimum Marketable Feature (MMF), Minimum Releasable Features (MRF), rigorous Definition of Done (DoD) and narrowed down the Acceptance Criteria for the user stories to be included in the development process
• Actively involved in creating and documenting various Test Artifacts like Test Plan, Test Data, Test Scripts, familiar with Black Box testing and experienced in conducting Smoke and Sanity Testing
• Carefully examined Triple Constraints pertaining to the project to maintain a balance in the Scope, Time, and Resources
• Proven expertise in performing Data Profiling to systematically assess the data and determine the scope for Data Migration
• Proficient in Source System Exploration, creating Migration Plan and Data Mapping
• Explicit insight and knowledge of various Data Warehousing Architectures like Enterprise Data Warehouse (EDW), Operational Data Store (ODS) and Data Marts. Efficiently identified Facts and Dimensions and designed Schemas
• Actively Participated in the Extraction, Transformation & Loading process and carried out Online Analytical Processing (OLAP) operations like Drill Down, Roll-Up, Slice & Dice, and Online Transactional Processing (OLTP) operations
• Harbored various conflicts which arose during the development process by effectively negotiating with developers, testers, architects, SMEs, business users, enterprise level management and all the stakeholders concerned with the project
• Actively involved in working with EDI translating tools to integrate EDI in the system and transmitting data to payers directly using the AS2 protocol as well as through Value-Added Network - VAN (Clearing house)
• Worked on various Guidewire integration concepts like Messaging, Batch Processes, Web Services
• Centralized the policy creation by integrating Guidewire Policy Center with Guidewire Claim Center, Billing System, and other existing system support operations
• Generated Use Cases for business process and captured User Stories for Guidewire Policy Center, worked on Commercial Auto, Workers’ Compensation, Business Owners Policy, and Commercial Property Package
• Experienced in documenting customization requirements, business rules & data migration requirements for implementation of Duck Creek Policy and Billing
• Thorough knowledge of DML, DDL and TCL SQL queries such as Joins, SELECT, Views, Order by, Group by, Relations, Triggers, Stored Procedures, Rollback, Commit and Aggregate functions such as Count, Min, Max
• Adept in Web Services such as Representational State Transfer (REST), Simple Object Access Protocol (SOAP), Extensible Markup Language (XML), JavaScript Object Notation (JSON). Documented multiple API’s using POSTMAN
• Well versed with system architectures like n-tier architecture and Service Oriented Architecture (SOA)
• By analyzing the requirement of the project, assisted in creating various Static, Ad-Hoc, Tabular Dashboards and Technical Reports
• Effectively utilized Project Management tools like JIRA, collaboration tools like MS SharePoint and Confluence, Business Presentation tools like Prezi, reporting tools like SQL Server Reporting Service (SSRS) and Tableau

TECHNICAL SKILLS

Property & Casualty, Health Insurance Domain: Guidewire, ACORD, IFRS, Claims Processing, HIPAA, ICD 10 CM, Electronic Health Records, Health Information Exchange System

Software Development Life Cycle: Agile-Scrum, Scrum-Waterfall, Waterfall, XP, RUP, Spiral, Kanban, Scrumban

Business Skills: Change Management, Impact Analysis, Project Planning, Project Scheduling, Issue Management, Conflict Management

Business Modelling Tools: MS Visio, Lucid Charts, Balsamiq mockups

Project Management Tools: JIRA, HP ALM, MS SharePoint, Confluence

BI and Reporting tools: Tableau, MS Office Suite (Excel, Word, PowerPoint), Prezi, SQL Server Reporting Service (SSRS)

Testing Tools: Postman, SOAP UI, HP-QC/ALM, Selenium

Architecture/Framework: Service Oriented Architecture (SOA), 3-Tier Architecture, n-Tier Architecture

Technologies: Salesforce Health Cloud

Databases and ETL Tools: MySQL Server, Informatica PowerCenter, Oracle

Data Warehousing: Enterprise Datawarehouse, Data Marts, ETL, ELT, OLTP, OLAP

PROFESSIONAL EXPERIENCE:

Confidential, Harrison, NY

Sr Business Systems Analyst

Responsibilities:

• Performed GAP Analysis, understood AS-IS business flow and by using Prezi, facilitated TO-BE process
• Conducted Joint Application Design sessions, brainstorming sessions, group workshops, individual and small team meetings, and conference calls with the Scrum Team, stakeholders, and architects to gather functional and non-functional requirements
• Interviewed Subject Matter Experts (SMEs) and performed extensive Document Reviews to develop an in-depth understanding of Business Processes to aid Business Process Improvement (BPI)
• Assisted the Product Owner and the team closely to prioritize, slice and estimate the Product Backlog items and defining the Definition of Ready (DoR) and Definition of Done (DoD) to include these items into Sprint Backlog
• Drafted Process Workflow, Use-case diagram, and Activity Diagram (UML diagrams) using Lucid Chart
• Developed Conceptual and Logical ER diagrams for the database. Created Data Dictionary for data models
• Identified Source systems for financial data profiling
• Performed ETL mappings, analysis, and documentation of OLAP requirements
• Formulated ER diagrams of Property and Casualty data and data flow diagrams to interact with database developers
• Examined Key Performance Indicators (KPI) for Property & Casualty such as Loss Ratio, General Operating Expense Ratio
• Documented report layouts and report mapping documents for ad-hoc reporting based on teams’ needs
• Assisted with snowflake schemas in the Dimensional model
• Used Data Center to integrate Legacy systems and supported in decision making
• Assisted in increasing Data Integrity by performing Data Normalization by adding Data Verification and Validity to maintain accuracy and effectiveness of data
• Assisted the architects in creating Data Flow Diagrams and communicated with all the stakeholders
• Actively participated and conducted Scrum Ceremonies such as Backlog Grooming/Refinement, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective. Closely collaborated with the Product Owner to create User Stories and Acceptance Criteria using JIRA to validate Potentially Shippable Product Increment (PSPI)
• Assisted in creation of Test Cases, Test Plans and Test Scenarios and created Requirements Traceability Matrix (RTM)
• Performed Guidewire Integration testing
• Created product rules and gathered inputs and reports for implementing Guidewire Policy Center
• Facilitated in creating Staging Area, Sources, Target Databases for ETL and mapping using Informatica
• Assisted the team in preparation of modules, provided steps/tutorials to generate reports
• Assisted the Scrum Master to create and document deliverables like Information Radiators (Burn-up - Burn-down charts) to transparently communicate with all the Stakeholders and track the team’s progress
• Conducted User Acceptance Test (UAT), actively participated and facilitated Regression, Smoke Testing and Black Box Testing
• Actively involved in maintaining the agility board to track the different issues and bugs using JIRA
• Performed API Testing and validated the responses using Postman, involved in API documentation for REST services and documented JSON request and response
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries
• Involved in integrating Visualization and Reporting tools such as SQL Server Reporting Service (SSRS) to create customized dashboards, static reports as well as Ad-Hoc reports

Environment: Agile-Scrum environment, JIRA, Confluence, Prezi, Lucid Chart, Guidewire, Guidewire Cloud, MySQL, SSRS, MS Office, REST, JSON, Postman, Blue Prism, Data Warehouse, Service Oriented Architecture, MS Office

Confidential, Hartford, CT

Sr. Business Systems Analyst

Responsibilities:

• Elicited user requirements by conducting Interviews, Surveys and Questionnaires, created AS-IS workflow and by documenting the needs of the business, drafted TO-BE process and validated the GAP Analysis with various stakeholders
• Conducted JAD sessions, group workshops, individual and small team meetings, and conference calls with multiple teams, stake holders and developers to gather functional and nonfunctional requirements of the system including requirements and processes for life and annuity products
• Created Conceptual and Logical data models and assisted the technical team to design Physical Data model as a part of the Transformation Process
• Produced Unified Modelling Language (UML) diagrams such as Use-Case Diagrams and Sequence diagrams for business stakeholders and end users to get a better perspective on the flow of the system
• Extensively collaborated with Source System Experts to identify various data sources and its types
• Collaboratively formulated the Extraction plan and Automated Partial Extraction every month and based on the partial extraction plan, defined the granularity of the project
• Created Fact Tables and various Dimensions associated with the project and actively participated in the designing of Schema for easier and faster data retrieval
• Formulated the ER diagrams of Property and Casualty data and data flow diagrams to interact with database developers
• Implemented UML, Use Case diagrams by using MS Visio for effective and healthy communication with stakeholders and clients
• Decomposed the elicited requirements into user stories and conducted a session with all the major stakeholders to define a rigorous Definition of Done (DoD)
• Involved in sprint planning sessions, backlog grooming, sizing, sprint retrospectives and reviews, daily stand ups, user stories and acceptance criteria
• Created and prioritized the back log in JIRA, coordinated planning sessions and maintained user stories and acceptance criteria within SMART and INVEST
• Assisted the PO in determining the Cadence of the Sprint and actively contributed to the Release Planning
• Involved in data normalization process for eliminating data redundancy and faster query processing
• Helped PO populate and refine the Product Backlog, further slicing the PBIs into user stories and tasks to be included in the Sprint Backlog and eventually defining Acceptance Criteria for the user story
• As a part of collaborative team, sporadically acted as Proxy Product Owner during the Scrum Ceremonies
• Assisted in creating OLAP queries for report formatting and static report
• Created and managed Test cases, Test plan, Test Scenarios through HP ALM
• Assisted and directly involved with QA team in creation of Test Cases and Test Implementations
• Conducted User Acceptance Testing for all product lines and liaise with the business testers and IT with regards to Duck Creek monthly maintenance releases
• Worked with Duck Creek user interface including Duck Creek Billing and Policy Administration System
• Extensively worked BI /BOBJ for multidimensional expenses actual reports
• Documented report layouts and report mapping documents for ad hoc reporting based on the teams’ needs
• Involved in ETL process using the Informatica PowerCenter and performed transformation on the landing database. Logged the source table information and the target table information with transformation logic on the Source-Target document
• Performed RESTful API documentation and specification for request and response messages using POSTMAN
• Reviewed the licenses and used Confluence to log the business solution recommendations and integrated JIRA to log issues, manage defect and bug lifecycles and track team progress

Environment: Agile-Scrum Environment, SaaS, JIRA, Confluence, Lucid Chart, Balsamiq, HP ALM, Informatica PowerCenter, SharePoint, Enterprise Data Warehouse, MySQL, Oracle, Duck Creek, Postman, MS Office

Confidential, Bay Area, CA

Business Systems Analyst

Responsibilities:

• Studied existing system requirements, environment, and operation by interacting with Technical and Business team members
• Involved in project scope meetings and documented high level business requirements to product backlog using JIRA
• Gathered requirements from collection, claims, billing, and insurance appeal departments
• FacilitatedJADsessions with business SMEs and analyzed the functional requirements and documentedUse Cases, Process Maps, Wireframes & Prototypes
• Documented business requirements, and communicated these requirements to the development team for the design and implementation of business solutions
• Created a Release Planning Document with high-level overview of all the requirements to be released in the upcoming sprint and assisted in creating a pre-defined release schedule
• Extensively involved in gaining knowledge of HIPAA and Electronic Data Interchange (EDI) industry specific organizations to analyze current applicability and risk associated in implementing this project
• Conductedwalkthroughof requirements to technical team and helped resolve outstanding issues
• Actively participated in all the Scrum Ceremonies (Backlog Refinement, Sprint Planning, Daily Standups, Sprint Review and Sprint Retrospective)
• ManagedChange Request Processand performedImpact Analysisfor several changes
• Clarified QA team issues and reviewedtest plans and test scriptsdeveloped by QA team to make sure that all requirements will be covered in scripts and tested properly
• Involved inPerformance Measurementto develop measurable indicators that can be systematically tracked to assess the progress made in achieving predetermined goals
• Participated in thebug review meetings, updatedrequirements documentas per business user feedback and change in functionality of the application
• Facilitated and performed User Acceptance Test (UAT) by working with internal and external users/customers and obtaining delivery approval for the project
• Maintainedad hoc report requestsfor the clients as per requirements. CreatedSQLqueries to fetch complex data from different tables in remote databases

Environment: Agile-Scrum Environment, HIPAA, EHR, JIRA, Confluence, Tableau, MS Office, Lucid Chart, Balsamiq, SOAP UI, HTML, Postman, MySQL

Confidential

Business Systems Analyst

Responsibilities:

• Worked on an application that took care of online account services which include bill paying, checking the bill history, changing customer profile, ordering auto insurance ID cards, worked on Commercial Lines on both policy and claim processing
• Gather business requirements through interviews, JAD sessions and observations and created the Business Requirements documentation for building UI for viewing data through Guidewire Policy Centre
• Responsible for reviewing requirements, analyzing the requirements to implement them using Guidewire Policy Center either by using out-of-box solutions in Guidewire Platform or by providing custom solutions on case-to-case basis
• Created a business process model using MS Visio for better understanding of the system and presented it to Project Manager and other team members for validation
• Developed Data Flow Diagrams and Data mapping agreement, illustrated the flow of data from the front-end Guidewire Policy Center into the Application Database Tables
• Created a Deployment plan by closely analyzing the characteristics of the production environment and saw the project to “Go-Live”
• Actively took part in determining the cadence for the sprint based on the Capacity of the team and participated in Scrum Ceremonies
• Coordinated with development team to conduct Daily Scrum meetings and Sprint Planning meetings which involved creating user stories for chosen sprint backlog
• Worked on Guidewire Policy Center with the Commercial Line, Test Definition workshop, Test Strategy, Test Planning using Insurance Test Framework for Guidewire
• Involved in Policy Center customization with SMEs and validating them in accordance with the company’s norms
• As a functional consultant, implemented Guidewire Policy Center through an Agile Scrum development model
• Managed General Liability, Commercial Property, Commercial Package, Commercial Auto and Workers’ Compensation
• Evaluate Property and Casualty Insurance functionalities, coverage and implement the changes in the software
• Involved in migration process from Mainframe, policy legacy systems to Guidewire applications
• Acted as primary liaison between the client departments and the IT department to perform analysis, review, and estimation of client requests, prepared and reviewed requirements and client documentation for Property and Casualty business
• Assisted the Technical team to identify the source and the target of the data for an efficient data migration through ETL process using Informatica PowerCenter
• Created defect tracking using HP QC and JIRA

Environment: Agile-Scrum, Data Migration, HP QC, JIRA, Postman, Tableau, Guidewire, SharePoint, MS Office, Confluence, MS Visio, Informatica PowerCenter, Lucid Chart, My SQL

Confidential

Business Analyst

Responsibilities:

• Conducted Document Analysis, Interviews, lead diverse Focus Groups to elicit various Functional and Non-Functional requirements and to understand Stakeholders’ Vision
• Assisted Sr. Business Systems Analyst to create the Requirements Documents such as Business Requirements Document (BRD), Functional Requirements Document (FRD) and Systems Requirements Document (SRS)
• Created the Concept Proposal (CP) document to realize and make a note of high-level Vision and Mission statements
• Conducted Cost Benefit Analysis, Market Research, Feasibility study, Risk Analysis and efficiently documented and communicated the Analysis report with all the Business Stakeholders
• Identified various Goals, Milestones, Scope, Constraints and documented the Project Charter (PC), created the Work Breakdown Structure (WBS) and Gantt Chart
• Collaborated with developers and communicated the Data requirements and assisted in creating Data Requirement Sheet
• Created UML diagrams such as use case, activity, sequence, class, and component diagrams using Microsoft Visio
• Interacted with healthcare clients to gather requirements, objectives, input and output requirements
• Analyzed data architecture, documented, and delivered data mapping, performed risk analysis
• Provided management support to the offshore and End to End Integration/ Regression Test Team
• Responsible for integrating HIPAA, Medicare solutions, Facets in the manual of every employee associated with the project
• Analyzed data architecture, documented, and delivered data mapping, performed risk analysis
• Managed daily meetings and ensured that quality standards were enforced as per the build-release schedule

Environment: Waterfall, HIPAA, HTML, XML, MS SharePoint, MS Excel, MS PowerPoint, MS Visio, SQL, User Acceptance Testing (UAT).

Confidential

Jr. Tester

Responsibilities:

• Joined the organization as a Management Trainee and advanced to the role of a Manual Tester
• Worked in Waterfall Methodology environment and was involved in Software Testing Lifecycle (STLC) phases
• Updated Requirements Traceability Matrix (RTM) and extensively involved in defining the Entry and the Exit criteria for all the phases in Software Testing Lifecycle
• Developed and executed Manual test cases for functional testing of various modules of the application
• Executed and evaluated GUI Testing, User Acceptance Testing and Manual testing
• Actively worked on Smoke & Sanity testing to analyze critical functionalities before and after updating the code
• Involved in tracking, reporting defects and responsible for communicating the status to the development team
• Participated in determining efforts and cost estimates and baselined the Test Plan document after reviewing Test Strategy
• Assisted Sr. Quality Assurance Analyst to prioritize testing objects, to document test environment details and to carry out Automation Feasibility Analysis
• Developed, documented, and maintained functional test cases and other test deliverables like Test Data, Data Validation and Test Scripts using HP Quality Center and actively involved in Defect Lifecycle management
• Analyzed the client applications to determine the impact of HIPAA rules and defined the changes within HIPAA compliance
• Monitored the STLC process and logged any issue in the Issue Log document and assisted in prioritizing these issues

Environment: Waterfall, UML, HTML, CSS, MS Visio, SharePoint, SQL, MS Excel, MS PowerPoint, HP QC, Jenkins, HIPAA