PROFESSIONAL SUMMARY:

• Over 8+ years of professional experience as a Business Analyst in Insurance environments with Guidewire, Property and Casualty, Personal (Auto, Dwelling, Homeowner), Commercial (Commercial Auto, Workers Compensation, General Liability, Business Owners Policy (BOP), Commercial Package Policy (CPP).
• Extensive experience in analysing and requirements gathering and writing system functional specifications.
• Experience in Guidewire suite (PolicyCenter, BillingCenter, ClaimCenter and ContactCenter) integrations.
• Experience in commercial Property and Casualty, Commercial Lines and Personal Lines Insurance, Underwriting, Rating and Guidewire experience with national carriers.
• Extensive experience in gathering requirements through Joint Application Development (JAD) sessions, Group Interviews and Use Case process document and managing business and functional requirements in the Property and Casualty Insurance including Risk, Policy Sales, Policy Administration System, Receivables and Payments, across personal and commercial lines of business.
• Involved in developing a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
• Expert in Writing SQL Queries on Oracle, Netezza, Microsoft SQL Server, Teradata, MS Access and DB2.
• Strong experience in RUP Business modelling process.
• Extensively worked on store procedures for new system changes and troubleshoot the existing store procedures to work more efficiently.
• Excellent knowledge and experience of creating source to target mapping, edit rules and validation, transformations, and business rules.
• Expertise in source to target mapping in Enterprise and Corporate Data Warehouse environments.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from an Operational Data Store to an Enterprise Data Warehouse
• Good command over Logical and Physical entity relationship data modelling using Erwin, Oracle Designer and Power Designer.
• Experience in Business Intelligence (BI) and Reporting technology, data analytics and KPI to provide pattern, trend, and insights for decision making.
• Familiar with Database maintenance, installation and support, Date mining, Data Warehousing, data repository, ETL.
• Experience in SQL and PL/SQL, and working skills in developing complex queries, stored procedures, cube and views.
• Extensive experience working in back - end tester by writing SQL Queries and PL/SQL scripts on large data warehouse systems involving Terabyte’s worth of data.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
• Expertise in Database Modelling, Data Mapping, ETL, Data Quality Management, Data Analysis, Requirement Analysis, Business Modelling, Data Migration, Data profiling, Dimensional Modelling, Entity Relationship Diagrams ERD, SQL and reporting process.
• Knowledge of all Commercial Insurance Rules and State Filing Requirements/ISO/NCCI.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Experience in conducting JAD (Joint Application Development) sessions for requirements gathering, analysis, and design.
• Expertise at developing Quality Assurance (QA) Test Plans, Test Case, Test Script, Test Schedules, defining testing strategies, executing test plans and Data Mapping.
• Proficient with MS Project to manage schedules, deadlines, and resources.
• Extensive worked on Traceability Matrix and Mapping between customer requirements and test cases.
• Extensive experience in Business Process Reengineering (BPR), e-filing process and Software Development with expertise in Analysis, Design, Development and Implementation.
• Extensive experience in reporting requirements gathering including writing BRD (Business Requirement documents), Custom Report Creation and Data Validation.
• Excellent technical skills in SQL to extract, transform and loading data to the database using tools such as Guidewire Data hub.
• Expertise in source to target mapping in Enterprise and Corporate Data Warehouse environments.
• Worked with defect tracking tools like JIRA, and QualityCenter.
• Highly effective management and organizational skills with ability to prioritize.

PROFESSIONAL EXPERIENCE

Confidential, Rockford, IL

Sr. Business Analyst

Responsibilities:

• Followed guidelines laid down by Rockford and utilized artifacts of the Agile-Scrum methodology to integrate, implement, and update the Guidewire PolicyCenter, BillingCenter and ClaimCenter in different sprints of the Software Development Life Cycle (SDLC).
• Performed on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Working on various components in Policy Admin such as Rating and Forms.
• Provided the UI Mock-ups for the user stories to the testing team and development team for the insurance Guidewire application.
• Gather business requirements through NCCI Manuals and ISO for the Workers Compensation for the specific state.
• Worked with ClaimCenter integration requirement with Docs and Forms, BillingCenter, Rating, Risk Report, Portfolio management, Policy Service, Analytical systems and Defining rules and requirements.
• Analyzed data to know the defects the production team is facing in policy renewals.
• Worked on various BillingCenter Integration User Stories (PolicyCenter - Get Payment Plans, Get Policy Contacts, Reinstatement, Renewal, Process Non-Pay Cancellation, Agency Sweep).
• Worked with Guidewire developers and production support team to understand various functionalities in Guidewire Policy and BillingCenter.
• Created product rules and gathered requirements for the implementation of discounts, rating inputs, and reports for implementing Guidewire PolicyCenter.
• Performed data analysis and documented Source to Target mapping, Data quality checks, Data sharing agreements and documents.
• Involved in developing all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
• Conducted controlled brainstorming sessions with project focus groups and documented business requirements with wireframes and mock-ups to explain in detail the business implications and impacts.
• Centralized the policy creation by integrating Guidewire PolicyCenter with Guidewire ClaimCenter Systems, Billing System and other existing system supporting operations.
• Worked on various Guidewire BillingCenter User Stories.
• Worked on Guidewire's UI testing in PolicyCenter and BillingCenter Screens for Personal lines of business
• Worked in the development a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
• Involved in developing SQL Joins, SQL queries, tuned SQL, views, test tables, scripts in development
• Involved in developing ETL processes using IBM DataStage to load data from disparate sources into data warehouse (Oracle 12g database) using various Database, Development/Debug, File and Processing stages
• Created data warehouse, data mart/repositories for clinical systems and data analysis stored procedures and generate KPIs and dimensional data.
• Utilized Oracle SQL queries to access data stored in the data warehouse for analysis and test the proper implementation of the database. Designed and implemented ETL processes for enterprise migration system.
• Gathered requirements and modelled the data warehouse and the underlying transactional database
• Involved in Data Modelling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
• Conducted JAD sessions, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications
• Worked as a liaison between product owners, project sponsors and project management and successfully deployed 90+ insurance products in Integrated Customer Platform (ICP) across USA.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Worked on Data mapping, logical data modelling, used SQL queries to filter data within database tables.
• Accept user stories as completed in JIRA upon code and test completion.
• Involved in developing QA Test Plan, test conditions and test cases, as well as assisted with QA team in System
• Testing using HP Mercury QualityCenter

Confidential

Business Analyst

Responsibilities:

• Analysis of Business requirements and preparing Business Requirement/Use Case scenario document.
• Work with the core development team to ensure the business requirements are understood and incorporated into the software development project.
• Responsible for rating multi-line policies. Manual rated Property, Liability, Auto and Workers Compensation policies. Conducted training classes for Auto and Workers compensation rating.
• During development sprint, documented user stories around Integration of Legacy application system with Guidewire ClaimsCenter.
• Facilitated requirements gathering and validation workshops for Guidewire ClaimsCenter.
• Extensive worked on policy, location and age group-based data mapping
• Performed JAD Sessions, walkthrough with Business, Legacy, Configuration/Interface Developers and ETL Team to provide comprehensive data.
• Elicited requirements from actuaries, Billing specialists and policy specialists.
• Performed analysis of published Circulars from ISO/NCCI and other regulatory Bureaus for system impact and prepared detailed business and functional requirements.
• Responsible for Data Manipulation and Data Validation using SQL queries in a MS SQL Server environment.
• Created the user story templates for storing it in Product Backlog also generated user stories around Integration of PolicyCenter with BillingCenter.
• Analyzed the as-is and to-be state of the project and performed Gap Analysis, Impact Analysis and SWOT Analysis for the legacy BillingCenter and PolicyCenter implementation to integrate with the Guidewire Claimcenter.
• Analysis of business requirements and system requirements of the client and also for Property and casualty modules
• Wrote SQL queries using joins, sub queries, and inline views to retrieve data from Oracle database.
• Involved with the technical team in understanding the XML file format required for Split loss process and Billing process.
• Extensively used SQL queries to check storage and accuracy of data in database tables.
• Prepared Source to Target mapping documents in Excel. Understanding of WSDL, XML, and XSD for creating the mapping documents for Guidewire-ESB layer-Vendor and vice versa.
• Created the DMD (Data Mapping Document) to specify the Data mapping from various data base sources to the target database and used Rational Rose for developing Unified Modelling Language (UML) diagrams like Use Cases diagram, Class diagram, Sequence and Activity based diagrams.
• Facilitated business requirements gathering sessions (JAD sessions) with the client/Technical team and overlooked the creation of Use Case scenario document.
• Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the Gaps between IT and Business.
• Various versions of the documents generated during the project were maintained and managed using Rational Clear Case and performed defect tracking using Rational ClearQuest.
• Involved in designing and developing new and enhanced existing ETL packages using SSIS for batch loads of the enterprise data warehouse, MDM system and related data marts used for retail sales analysis and marketing. Source data included flat files, database queries and XML files.
• Used JIRA to manage the requirements and Updated Documents in Confluence.

Confidential, Edwardsville, IL

Business Analyst

Responsibilities:

• Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Worked on Guidewire software, specifically with Guidewire PolicyCenter and Guidewire BillingCenter.
• Used Rational Clear Quest to track Project Status, monitor workload and detect issues for Prototyping Guidewire applications as per the requirements.
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Performed complex SQL queries for retrieving data from the database, generating ad-hoc reports, and conducting data validation testing.
• Also worked as an Enterprise Data Hub (EDH) Business Analyst and partnered with the EDH technical team and business partner teams in driving the requirements, design and development activities for several systems to be retired/archived within multi-node.
• Involved in developing Informatica Mappings to load data from Source Systems to EDH (Enterprise Data Hub) and then to Data Mart.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Worked on Guidewire software to track the claims of the policy holders.
• Worked along with several Architects to replace insurance system. Guidewire was used in the creation of a new portal (PolicyCenter). This portal was streamlined to guide customers (agents) through policy input, rating. state form review, issuance/renewal and policy print.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Involved in end-to-end requirement gathering and proposing best solution to simplify the implementation of Insurance product and Guidewire PolicyCenter and BillingCenter, Coordination & Management
• Identified "As is" process and "To be" process as parts of gap analysis for legacy PolicyCenter to Guidewire PolicyCenter.
• Prioritized the Guidewire PolicyCenter requirements based on actual business needs so as to align them with the project roadmap.
• Experience with complex SQL queries for data profiling for Data ETL Integration tool.
• Used Guidewire to upgrade the current Claim system to track the claim of the policyholders and third-party applications
• Verified the billing history events matched up with the user stories for Guidewire billing and policy generation suite.
• Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
• Worked on UAT testing and took signoff from the Commercial line of Property & Casualty business users.
• Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Extensive experience in extracting UI based information by querying the Oracle database using SQL queries.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
• Worked as an Interface between the Users and the different teams involved in the application development for the better understanding of the Business and IT Processes.
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
• Involved in the automation of Regression Test Cases by scripting.
• Used Test Director and Mercury QualityCenter for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Analyze and clarify business needs to create user stories in JIRA for agile sprint team developers.
• Performed Business Process Mapping and performed AS IS and TO BE analysis
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Prepared system Test Plan and scenarios for Test Scripts.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.

Confidential - Amelia, OH

Business Analyst

Responsibilities:

• Actively involved in brainstorming and JAD session with the client in order to identify all the business requirements for P&C project development.
• Successfully performed Requirements Gathering and Analysis, interviewed the SME (Subject Matter Experts), both personal and commercial, and ensured that contributors and all key stakeholders were motivated to complete assigned tasks.
• Effectively managed all the project lifecycle using RUP. Created the rules engine and the laid down the guideline for the smooth flow of the different project elements in P&C domain. The project involved parallel design, development, test case development and testing.
• Ensure timely and quality deliveries. Track and report project data/milestones. Additionally, work as a control owner for different Risk(s) Test Evidences and install processes under SOX compliance for MetLife Auto and Boat policy administration system (PAS) team.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence team to understand repository objects that support the business requirement and process.
• Create Functional Requirement Documents (FRD) along with helping on Technical Specification Document (TSD).
• Managed the Requirements (Business as well as System requirements), performed requirements analysis along with the creation of Use Case Scenarios. Modelling of the business and application using Rational Unified Processing (RUP) and Unified Modelling Language (UML).
• Analyzed the flow of data into downstream data warehouse which fed to data marts and end systems that support analytical and operational reporting.
• Primarily responsible for Documentation in each phase of RUP Methodology, Risk Assessment, and Validation & Verification process for capital asset and business owner insurance - commercial lines.
• Developed Process Work Flows, Functional Specifications, and responsible for preparing Software Requirement Specifications (SRS), Functional Specification Document (FSD).
• Performed Gap Analysis to identify the deficiencies of the current system and to identify the requirements for the proposed system for Treaty and Facultative Reinsurance.
• Queried database using SQL queries to ensure data integrity and to validate the inserted and updated data.
• Worked with the Project Manager on various Project Management activities like keeping track of Commercial line modules, Project Status, Deadlines, Environment Request, and Compliance Issues.
• Performed Defect Tracking and Change Control Procedures using Rational Clear Quest and Configuration Management and Version Control using Rational Clear Case.
• Involved in developing exceptions report which were then submitted to project lead and stakeholders on a regular basis (for both P&C commercial lines).
• Wrote SQL queries for data validation, analysis and manipulation, and maintaining the integrity of the database.
• Actively participated in the data conversion to a third-party vendor; completed within schedule and budget.
• Worked with the development team to make sure that they understood the user requirements for P&C insurance and that the system developed met those requirements.
• Actively participated in developing test plans and test procedure templates and guidelines to be used by the project team with detailed screen layouts with regards to various types of corporate actions.
• Involved in the development of Test Plans, Test Cases and Expected Results, and coordinated the tests with the QA team to verify implementation of new features and enhancements.

Confidential - Boston, MA

Business Analyst

Responsibilities:

• Gathered high-level requirement for all the external projects in a release.
• Organized the cross-functional JAD meetings, managed signoffs and ensured successful completion of quality gates.
• Worked on Commercial Lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Worked on Property and causality insurance, maintaining database, handling client and stakeholders at the same time.
• Extensively worked in all the phases of Rational Unified Process such as Inception, Elaboration, Construction, and Transition.
• Conducted GAP analysis of the system in terms of "as is" and "to be".
• Documented and prioritized BRD and FRS using Requisite pro.
• Created Requirements Traceability Matrix (RTM) and traced implementation of the requirements through various phases.
• Ensured that relevant UML diagrams and tools were used in all requirement documents and prepared business process models such as Use Case Models, Activity Diagrams, Sequential Diagrams in MS Visio.
• Involved in designing screen mock-ups and wireframes for web applications.
• Prepared documents such as Project Scope, Project Vision, Project Success, Business Requirements, Functional Specification, Data Warehouse Process Flow (SQL queries & Crystal Reports) using MS Office (Word, Excel, Visio) and dashboards.
• Involved in developing detailed source-to-target Data Mapping, Business Rules and Definition documents.
• Coordinated extensively between SME and product managers to ensure application covers all the requirements.
• Performed version control and defect tracking activities using Rational Clear Case and Rational Clear Quest.
• Used MS Visio for Process modelling and Business Process flow diagrams.
• Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
• Interacting with the developers on resolving the reported bugs and various technical issues.
• Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing.

Confidential - Austin, TX

Business Analyst

Responsibilities:

• Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
• Documented the Glossary terms
• Recorded Data Elements and Business Rules
• Created / updated the requirements for Rating worksheet, Quote Proposal, Quote Summary & Accord mapping.
• Gathered requirements for business process flow and on-screen flow for wizards driven products from products SMEs.
• Responsible for providing analytical support in the Design, Development and Implementation of Story cards.
• Collaborated with the business and technical stakeholders to accurately documents report, functional, non-functional and data requirements while ensuring compliance with corporate standards.
• Conducted scenario analyses of the requirements to align with the business objectives for effective testing of reports.
• Collaborated with business stakeholders and IT partners on assessing impacts of new initiatives and assisted in the development and execution of implementation plans, including the creation of backlogs, estimation of effort, and identification of tasks.
• Performed analysis to evaluate the associated benefit, considering both qualitative and quantitative factors, as well as the associated cost, risk and impact to business users, processes and systems.
• Assisted with the development of test plans and strategies, coordinated testing events, and executed test cases in support of changes to business systems.
• Maintained a requirements traceability matrix in order to keep the clients and all the teams up-to-date with the current progress of the project.
• Executed User Acceptance Testing (UAT) with the stakeholders and the business users, and fixed the errors discovered then verified via regression testing.
• Created and executed SQL queries to validate test data and automate validation of results at the Back end.
• Wrote complex SQL queries using joins to verify data.
• Reviewed test results and coordinated with testing and development team to correct the issues.