SUMMARY

• Sr. Business Systems Analyst wif 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 noledge and working exposure in P&C (Property & Casualty) insurance Auto, Liability, Home and Marine Life Insurance/Annuities along wif Health Insurance & IT domains
• Working experience wif 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 wif STLC process
• Comprehensive working noledge of various SDLC methodologies like Waterfall, Agile (Scrum), Water - Scrum-Fall (Agile Hybrid)
• Profound noledge 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 teh requirements into technical specifications and articulated across all teh stakeholders
• Conducted multiple Feasibility studies, Risk Analysis, Cost Benefit Analysis, SWOT analysis and Impact Analysis to analyze teh needs of a project and its execution. Performed GAP Analysis to understand AS-IS and TO-BE business processes
• Closely assisted teh 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 theirby possessing broad noledge of documenting and presenting deliverables at every milestone
• Improved teh 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 teh associated Conceptual and Logical Data Model to define teh required objects accurately (wifout any redundancy) in teh database. Helped understand anomalies in teh database design and Normalization to address them
• Efficient in breaking down Epics into User stories keeping teh INVEST criteria in acceptable limits. Experience in slicing teh 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 teh requirements to teh Stakeholders for better understanding teh outcome and to accommodate any changes, using Lucid Chart and Balsamiq
• Skillfully supported teh Product Owner to define Minimum Viable Product (MVP), Minimum Marketable Feature (MMF), Minimum Releasable Features (MRF), rigorous Definition of Done (DoD) and narrowed down teh Acceptance Criteria for teh user stories to be included in teh development process
• Actively involved in creating and documenting various Test Artifacts like Test Plan, Test Data, Test Scripts, familiar wif Black Box testing and experienced in conducting Smoke and Sanity Testing
• Carefully examined Triple Constraints pertaining to teh project to maintain a balance in teh Scope, Time, and Resources
• Proven expertise in performing Data Profiling to systematically assess teh data and determine teh scope for Data Migration
• Proficient in Source System Exploration, creating Migration Plan and Data Mapping
• Explicit insight and noledge 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 teh 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 teh development process by effectively negotiating wif developers, testers, architects, SMEs, business users, enterprise level management and all teh stakeholders concerned wif teh project
• Actively involved in working wif EDI translating tools to integrate EDI in teh system and transmitting data to payers directly using teh 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 teh policy creation by integrating Guidewire Policy Center wif 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 noledge 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 wif system architectures like n-tier architecture and Service Oriented Architecture (SOA)
• By analyzing teh requirement of teh 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 wif teh 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 teh Product Owner and teh team closely to prioritize, slice and estimate teh Product Backlog items and defining teh 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 teh 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 wif 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 wif snowflake schemas in teh 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 teh architects in creating Data Flow Diagrams and communicated wif all teh stakeholders
• Actively participated and conducted Scrum Ceremonies such as Backlog Grooming/Refinement, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective. Closely collaborated wif teh 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 gatheird inputs and reports for implementing Guidewire Policy Center
• Facilitated in creating Staging Area, Sources, Target Databases for ETL and mapping using Informatica
• Assisted teh team in preparation of modules, provided steps/tutorials to generate reports
• Assisted teh Scrum Master to create and document deliverables like Information Radiators (Burn-up - Burn-down charts) to transparently communicate wif all teh Stakeholders and track teh team’s progress
• Conducted User Acceptance Test (UAT), actively participated and facilitated Regression, Smoke Testing and Black Box Testing
• Actively involved in maintaining teh agility board to track teh different issues and bugs using JIRA
• Performed API Testing and validated teh 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 teh needs of teh business, drafted TO-BE process and validated teh GAP Analysis wif various stakeholders
• Conducted JAD sessions, group workshops, individual and small team meetings, and conference calls wif multiple teams, stake holders and developers to gather functional and nonfunctional requirements of teh system including requirements and processes for life and annuity products
• Created Conceptual and Logical data models and assisted teh technical team to design Physical Data model as a part of teh 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 teh flow of teh system
• Extensively collaborated wif Source System Experts to identify various data sources and its types
• Collaboratively formulated teh Extraction plan and Automated Partial Extraction every month and based on teh partial extraction plan, defined teh granularity of teh project
• Created Fact Tables and various Dimensions associated wif teh project and actively participated in teh designing of Schema for easier and faster data retrieval
• Formulated teh ER diagrams of Property and Casualty data and data flow diagrams to interact wif database developers
• Implemented UML, Use Case diagrams by using MS Visio for effective and healthy communication wif stakeholders and clients
• Decomposed teh elicited requirements into user stories and conducted a session wif all teh 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 teh back log in JIRA, coordinated planning sessions and maintained user stories and acceptance criteria wifin SMART and INVEST
• Assisted teh PO in determining teh Cadence of teh Sprint and actively contributed to teh Release Planning
• Involved in data normalization process for eliminating data redundancy and faster query processing
• Helped PO populate and refine teh Product Backlog, further slicing teh PBIs into user stories and tasks to be included in teh Sprint Backlog and eventually defining Acceptance Criteria for teh user story
• As a part of collaborative team, sporadically acted as Proxy Product Owner during teh 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 wif QA team in creation of Test Cases and Test Implementations
• Conducted User Acceptance Testing for all product lines and liaise wif teh business testers and IT wif regards to Duck Creek monthly maintenance releases
• Worked wif 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 teh teams’ needs
• Involved in ETL process using teh Informatica PowerCenter and performed transformation on teh landing database. Logged teh source table information and teh target table information wif transformation logic on teh Source-Target document
• Performed RESTful API documentation and specification for request and response messages using POSTMAN
• Reviewed teh licenses and used Confluence to log teh 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 wif Technical and Business team members
• Involved in project scope meetings and documented high level business requirements to product backlog using JIRA
• Gatheird requirements from collection, claims, billing, and insurance appeal departments
• FacilitatedJADsessions wif business SMEs and analyzed teh functional requirements and documentedUse Cases, Process Maps, Wireframes & Prototypes
• Documented business requirements, and communicated these requirements to teh development team for teh design and implementation of business solutions
• Created a Release Planning Document wif high-level overview of all teh requirements to be released in teh upcoming sprint and assisted in creating a pre-defined release schedule
• Extensively involved in gaining noledge of HIPAA and Electronic Data Interchange (EDI) industry specific organizations to analyze current applicability and risk associated in implementing dis project
• Conductedwalkthroughof requirements to technical team and halped resolve outstanding issues
• Actively participated in all teh 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 teh progress made in achieving predetermined goals
• Participated in thebug review meetings, updatedrequirements documentas per business user feedback and change in functionality of teh application
• Facilitated and performed User Acceptance Test (UAT) by working wif internal and external users/customers and obtaining delivery approval for teh project
• Maintainedad hoc report requestsfor teh 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 teh 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 teh Business Requirements documentation for building UI for viewing data through Guidewire Policy Centre
• Responsible for reviewing requirements, analyzing teh 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 teh system and presented it to Project Manager and other team members for validation
• Developed Data Flow Diagrams and Data mapping agreement, illustrated teh flow of data from teh front-end Guidewire Policy Center into teh Application Database Tables
• Created a Deployment plan by closely analyzing teh characteristics of teh production environment and saw teh project to “Go-Live”
• Actively took part in determining teh cadence for teh sprint based on teh Capacity of teh team and participated in Scrum Ceremonies
• Coordinated wif 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 wif teh Commercial Line, Test Definition workshop, Test Strategy, Test Planning using Insurance Test Framework for Guidewire
• Involved in Policy Center customization wif SMEs and validating them in accordance wif teh 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 teh changes in teh software
• Involved in migration process from Mainframe, policy legacy systems to Guidewire applications
• Acted as primary liaison between teh client departments and teh IT department to perform analysis, review, and estimation of client requests, prepared and reviewed requirements and client documentation for Property and Casualty business
• Assisted teh Technical team to identify teh source and teh target of teh 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 teh Requirements Documents such as Business Requirements Document (BRD), Functional Requirements Document (FRD) and Systems Requirements Document (SRS)
• Created teh 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 teh Analysis report wif all teh Business Stakeholders
• Identified various Goals, Milestones, Scope, Constraints and documented teh Project Charter (PC), created teh Work Breakdown Structure (WBS) and Gantt Chart
• Collaborated wif developers and communicated teh 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 wif 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 teh offshore and End to End Integration/ Regression Test Team
• Responsible for integrating HIPAA, Medicare solutions, Facets in teh manual of every employee associated wif teh project
• Analyzed data architecture, documented, and delivered data mapping, performed risk analysis
• Managed daily meetings and ensured that quality standards were enforced as per teh 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 teh organization as a Management Trainee and advanced to teh 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 teh Entry and teh Exit criteria for all teh phases in Software Testing Lifecycle
• Developed and executed Manual test cases for functional testing of various modules of teh 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 teh code
• Involved in tracking, reporting defects and responsible for communicating teh status to teh development team
• Participated in determining efforts and cost estimates and baselined teh 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 teh client applications to determine teh impact of HIPAA rules and defined teh changes wifin HIPAA compliance
• Monitored teh STLC process and logged any issue in teh 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