SUMMARY

• Self - reliant and goal-oriented professional with cross-functional and diverse problem solving and technical abilities. Skilled at streamlining the business process flow. Specializing in Property & Casualty Insurance domain. An effective liaison with experience in bridging the gap of understanding between business users and technology.
• Over 8+ years of experience as Business Analyst in the Information Technology industry.
• Adept in workflows of insurance industry including Property & Casualty Insurance. Competent in Policy Administration, Claims, Billing, Underwriting Activities, Quote and Bind operations performed in the Insurance domain.
• Knowledge on various insurance regulating compliances which include National Association of Insurance Commissioners (NAIC), Financial Industry Regulatory Authority (FINRA), National Insurance Producer Registry (NIPR), Association for Cooperative Operations Research and Development (ACORD) and National Council on Compensation Insurance (NCCI).
• Extensive knowledge on Guidewire Insurance Suite Policy Center, Claims Center and Duck Creek Claims.
• In depth knowledge and involvement in Software Development Lifecycle process which includes Waterfall, Agile Scrum, Scrum-Waterfall Hybrid and knowledge on Scaled Agile Framework (SAFe 4.0), Kanban, Rational Unified Process (RUP), Scrumban, Spiral, Extreme Programming (XP).
• Facilitated requirements elicitation by using different techniques which include Interviews, Brainstorming, Focus Groups, Document Analysis, Requirement Workshops, Observations, Prototyping and Joint Application Development (JAD) Sessions with end users, SMEs and stakeholders.
• Expertise in “As Is” and “To Be” process design by performing GAP Analysis, SWOT Analysis, Impact Analysis, Cost Benefit Analysis and Feasibility Study.
• Involved in development of thorough documentation for capturing business and technical details like Business Requirements Document (BRD), Functional Requirements Document (FRD), System Requirements Specification (SRS), Requirements Traceability Matrix (RTM) and assisted the Project Manager in creation of the Project Charter, Project Management Plan (PMP) and Work Breakdown Structure (WBS).
• Experience in Change Control Management, Defect Management and Project Management.
• Created UML Diagrams including Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams and ER Diagrams using Rational Rose and MS-Visio thus defining the Business Process Model and preparing complex functional requirements document.
• Created Mockups, wireframes and prototypes by using Balsamiq to gather the User Interface requirements.
• Performed retrieval and validation of data by using Data Definition Language (DDL), Data Manipulation Language (DML) and Data Query Language (DQL) to perform CRUD operations on the database.
• Knowledge of working with query languages by performing aggregate functions which include min, max, count, sum, avg etc., joins, unions, group by, order by and sub queries which were useful in extracting data from different types of data sources like MYSQL Server, Oracle database, MS SQL Server and MS Access.
• Involved actively in Data Mapping process by analyzing the attributes and the types of the attributes and identified the mapping rules to be applied for the data migration process along with the data analysts. Knowledge of Data Migration and data mapping to carry out data profiling and data integration.
• Created Conceptual data models, Logical data models by using Erwin data modeler and assisted in the creation of physical data models.
• Extensive knowledge of Data Warehouse implementation including Dimensional Modelling (Star & Snowflake Schema), Data marts, ETL process using tools like Informatica for filter, router, joiner, aggregator and expression transformations for data modification and meta data management services.
• Knowledgeable in OLAP analysis (MOLAP and HOLAP) and operations like Roll up, drill down, slicing, dicing and pivot.
• Cultivated experience in working with web services using WSDL, SOAP, REST and JSON under various architectures like Three tier architecture, Service Oriented Architecture (SOA) with knowledge of Micro Services.
• Assisted in API testing to check their reliability, functionality and security by using postman and SOAP UI tools. Even involved API documentation by making use of Swagger tool.
• Assisted in creation of Test Plans, Test Cases, Test Scenarios and Test data and collaborated in performing different types of testing User Acceptance Testing (UAT), Functional Testing, Unit Testing, System Testing, Integration Testing, Black box testing, Smoke testing and Regression testing.
• Knowledge of Test-Driven Development (TDD), Acceptance Test Driven Development (ATDD) and Behavior Driven Development (BDD).
• Defects tracking prioritize outstanding defects in reporting system, coordinate between development team and management team to resolve any conflicts/defects in terms of requirements.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Hybrid (Waterfall-Scrum), Agile Scrum, SAFe Framework, Kanban, RUP

Process Modelling Tools: MS Visio, Mockup Screens, Smart Draw, Balsamiq, Lucid Charts

Requirements & Project Management: MS Project, Rally (CA Agile Central), JIRA (v. 6.3, 7.2, 7.3), HP QC/ALM (v. 11.5), Confluence (v. 6.6, 6.5, 6.4), SharePoint Server (2013, 2016), MS Office

Testing Tools: HP QC (v 11, 12), Postman, Selenium, Cucumber and Swagger

ETL Tools: Informatica

Data Analysis / Reporting: Tableau, AWS QuickSight, QlikView

Databases: Microsoft SQL Server (2012, 2014), Oracle 10g, 11g, MS Access

Data Modelling: Logical/Physical/Dimensional/E-R, Star/Snowflake Schema

Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, Data Mining, Slicing/Dicing, Drill Down/Roll Up

PROFESSIONAL EXPERIENCE

Confidential, Springfield, IL

Business Analyst

Responsibilities:

• Responsible for capturing the requirements for Publish/Subscribe System (PUBSUB) responsible for enabling real time communication/data transfer between the systems throughout the Organization.
• As part of PUBSUB gathered the list of events that can be published by each system which includes, the agent system, customer system, payment processing system, Policy Center, Billing Center and DMS by organizing meetings with the tech leads and BA’s from each stream.
• Established a common JSON message structure which shall be used by each system in order to communicate through PUBSUB by collaborating with the enterprise architects and tech leads.
• Identified and captured the publisher rules and subscriber rules for CDMS by organizing meetings with the developers.
• Involved in capturing requirements for integrating CDMS with Legacy System to enable synchronization between the two systems by organizing regular interviews with the Legacy team.
• Responsible for capturing the storage and retrieval requirements for the DMS which will be used across different systems in organization to store, retrieve and search the documents.
• Responsible for capturing the data requirements for each document that is generated as part of quote, issuance, invoice or cancellation.
• Responsible for capturing the data mapping requirements which includes the transformation rules between Policy Center/ Billing Center and DMS thereby enabling successful communication of data that needs to be printed on the documents.
• Assisted the QA team in creating the test cases, test scenarios and test execution and assisted the developers in performing unit testing.
• Assisted the Scrum Master & Product Owner in Creating User Stories, Backlog Grooming, Sprint Planning and breaking down user stories into tasks by using the Rally tool.
• Responsible for creating the Mock Up screens for the search application that will be used by the stakeholders to search for client and policy data by consulting the business.
• Participated in the defect triage meeting with the QA team to prioritize the defects and even analyzing and assigning the defects to the team members.

Environment: Agile Scrum, MS Excel, Rally, SharePoint, GuideWire PolicyCenter, BillingCenter, ClaimsCenter, SOAP UI, HP ALM, Amazon Kinesis, Amazon Elasticsearch service, Amazon Simple Queue Service (SQS), Amazon Dynamo DB, Amazon API Gateway and Amazon CloudWatch.

Confidential, Brenham, TX

Sr. Business Systems Analyst

Responsibilities:

• Captured and documented the business requirements for Client 360 application that will be used by the customers to view and edit their personal information and policy information.
• Identified the different screens that will be part of the Client 360 application and the requirements for navigating between the screens.
• Elicited the requirements for the data elements that need to be part of the screen from the Product Owner and SME’s.
• Created the mockup for each screen along with the data elements on the screen using Balsamiq.
• Created the data mapping documents for mapping the data from party and policy systems to the client 36- application along with the transformation rules to be applied for the data to be printed on the screen as per the requirements defined.
• Interacted with policy process experts to understand the life cycle process including policy quote, bind, issue, underwriting and cancellation.
• Created future state work flows in MS Visio and performed GAP analysis between the current and future state.
• Captured the requirements specifying the conditions under which errors needs to be generated that should be manually resolved by the underwriter during the quote process.
• Captured the requirements for system generated triggers to notify the document management system for generating the quote, declaration and policy documents.
• Identified transition requirements, data and user requirements to maintain interoperability between the systems and seamless integration between the old and new system.
• Created UML diagrams including Use Case Diagrams, Data Flow Diagrams and Activity Diagrams using MS Visio. Designed use case modelling originating from Quote to Policy Issuance/Policy Cancellation.
• Assisted the Product Owner in the creation of Epics and conducted story writing workshops to ensure the stories meet the INVEST criteria and assisted in prioritizing the product backlog.
• Developed conceptual data models and logical data models using Erwin Data modeler.
• Used JIRA tool for project management including activities like issue/defect tracking, managing user stories and impediments, prioritizing and estimating the user stories.
• Assisted the QA team in creation of test plans, test scenarios and test cases to ensure that the functional performance and usability requirements have been satisfied.
• Involved in using REST API and SOAP API for data communication between AWS Redshift and Guidewire applications and even for communication among the Guidewire applications.
• Assisted in creating API documentation using Swagger to check whether the data is communicated in JSON, XML format.

Environment: Scrum, Amazon Redshift, Informatica Cloud, EC2, S3, Lambda, Elastic bean stalk, SQS, SES, QuickSight, Guidewire 8.0 Policy center, Billing center, Claims center, JIRA 7.0, Selenium, Erwin, Balsamiq, Postman.

Confidential

Business Systems Analyst

Responsibilities:

• Actively participated in identifying the data sources and data elements that are needed to generate reporting capabilities for the business along with the Data Analysts.
• Assisted in performing data profiling by identifying incorrect, inconsistent and missing data and deciding the default values to be passed for the incorrect or missing data.
• Identifying the Key Performance Indicators which will help generate valuable insights for the business like Premium Growth Rate, Attrition Ratio, Loss Ratio, Policy count, and new business policy sales.
• Assisted the data analyst team in generating reports using Tableau tool based on the requirements of the business including premium revenue across line of business, policy count for LOBs, claims payments across all lines of business etc.
• Gathered requirements from business owner and relevant stakeholders from Underwriting and Claims department by conducting Interviews, Document Analysis, JAD Sessions to gather the Business requirements.
• Responsible for capturing the integration requirements for integrating Duck Creek with third party Document Management System, Legal Bill System, Medicare and other medical vendors.
• Actively participated in Program Increment Planning meetings along with the entire team to plan the features for the next quarter and estimate and prioritize the features as well.
• Assisted the Product Owner to efficiently reprioritize and groom the Product backlog for maximizing business value or return on investment (ROI) on the development effort based on the MoSCoW and KANO model.
• Actively involved in all the Scrum meetings such as Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospectives.
• Used Jira and Sharepoint to maintain the project artifacts and kept the information radiators updated.

Environment: Agile Scrum, Jira 7.0, MS SharePoint, MS Visio, Salesforce CRM, Balsamiq, MS SQL Server 2016, Tableau, Selenium Web-Driver, SOAP API, Swagger, SOAP UI, Duck Creek v 7.0.

Confidential

Business Systems Analyst

Responsibilities:

• Involved through various stages of System Development Life Cycle (SDLC) in Waterfall Methodology.
• Identified and analyzed needs for various functionalities of the portal by using various techniques such as Document Analysis, SWOT Analysis, Requirements Workshops and Interviews with SMEs, Business Owners, Business Sponsors and project stakeholders.
• Investigated, understood and analyzed the current underwriting and disparate manual sales process. Examined various bottlenecks and points for automation to streamline the underwriting process.
• Prioritized the development of missing content in the existing framework by performing the GAP Analysis and then conducting Risk Analysis and Impact Analysis. Developed a high-level Business requirement Document (BRD) and Functional Requirements Document (FRD) and SRS baselined it with business owners and sponsors.
• Worked with GUI Development team to create the UI wireframes and mockups. Developed Mockup screens and prototypes for the applications home page from the requirements document.
• Developed Logical and Conceptual data models that capture current state and future state data elements and data flows using Erwin.
• Created use case document by specifying actors, normal flow and alternative flows for all cases. Extensively used MS SharePoint for team collaboration and version control. Created activity diagrams to represent current state business process and data flow of the systems and sequence diagrams for the order of interactions.
• Analyzed requirements from black box testing perspective. Reviewed test strategy and plans to ensure that test cases reflect user needs for functional, performance, usability and security requirements.
• Responsible for testing the Quote & Purchase for Auto Insurance of the customers. Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
• Involved in API documentation for SOAP, REST and documented XML requests and responses from the client and server using Swagger tool also performed API testing by using Postman tool.

Environment: Waterfall, MS Sharepoint 2010, HTML, CSS, JavaScript, Python, MS Project, MS Access, HP QC, Balsamiq, Oracle SQL Server, Postman, Swagger

Confidential

Business Analyst

Responsibilities:

• Extracted the business requirements during various sessions with business leads and tagged all requirements in, tracing them all the way to the stakeholder requirements.
• Responsible for acting as a liaison with operational and financial management, systems support and sales to identify business opportunities.
• Responsible for testing the Quote & Purchase for both Auto and Home Property Insurance of the customers.
• Identified/documented data sources and transformation rules required for populating and maintaining data warehouse content.
• Gathered user and business requirements through surveys, prototyping and observing from managers and User Interface (UI).
• Involved in generating test cases for Property & Casualty Insurances for different levels of business.
• Development of Sequence Diagrams, Process flow diagrams using UML modelling tools such as MS Visio.

Confidential

Jr. Business Analyst

Responsibilities:

• Worked with requirements gathering team and produced initial requirement data to produce User Interface and Business Process Requirements.
• Analyzed the life insurance application process including underwriting and proposed changes to make the process more effective.
• Designed the business requirement collection approach based on the project scope and System Development Lifecycle Methodology (SDLC) and documented the same in the Business Requirements Document (BRD).
• Employed Waterfall Methodology to conduct the system development.
• Facilitated and managed meeting sessions with committee of SME’s from various business areas.
• Developed project document templates based on SDLC Methodology.
• Planned and refined the system requirements to narrative Use Cases and Use Case Scenarios using the UML Methodologies. Created Use Case Diagrams, Activity Diagrams and Flow Diagrams in MS VISIO.
• Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas.

Environment: Waterfall, MS Visio, UML, MS Word, SQL Server 2005, Load Runner, QTP, .Net, HP QC.