SUMMARY

• Over 8+ years of professional experience as a Business System Analyst in Insurance environments with jira, Property and Casualty, Reinsurance, 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.
• Experienced in Guidewire suite (PolicyCenter, BillingCenter, ClaimCenter and ContactCenter) integrations.
• Expert in implementation insurance Technology solutions like Guidewire includes Personal P&C and Commercial Automobile Product knowledge with in - depth knowledge in the Underwriting, policy administration, PolicyCenter, ClaimCenter BillingCenter, Data Warehouse, Rating, Reinsurance and Claims process.
• Experienced in Providing complete Assumed and ceded Reinsurance processing of pro-rata and excess of loss.
• In-depth knowledge of USA Property & Casualty Insurance Market, Reinsurance market, Large Account Risk Pricing Tools, Business reporting (both Facultative and Treaty), Ceded - Assumed, Retro Business, Reinsurance Accounting, CAT Bonds, ART (Alternative Risk Transfer) Tools.
• Knowledge in the Underwriting, Policy Administration, PolicyCenter, ClaimCenter, BillingCenter, Data Warehouse, Rating, Reinsurance and Claims process.
• Accomplished professional with diverse business analysis, quality assurance, financial reporting, insurance, and reinsurance experience in search of next challenge.
• Experience in Reporting and addressing various Insurance industry issues as they arise and the point person for the development and adoption of the ACORD xml standards.
• Extensive experience in gathering requirements through Joint Application Development (JAD) sessions, Group Interviews and Use Case process document and managingbusinessand functional requirements in the Property and Casualty Insurance including Risk,PolicySales,Policy Administration System, Receivables and Payments, across personal and commercial lines ofbusiness.
• Involved in developing a file of ACORDFormsused as the standards in all Property and Casualty markets, for both Personal and Commercial Lines ofBusiness.
• Expert in Writing SQL Queries on Netezza, Microsoft SQL Server, Teradata, MS Access and DB2.
• Strong experience in RUP Business modelling process.
• 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 CorporateDataWarehouse environments.
• Experience inBusinessIntelligence(BI) and Reporting technology,dataanalytics and KPI to provide pattern, trend, and insights for decision making.
• 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.
• 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.
• Exposure to ACORD Property and Casualty Standards and ISO (Insurance Services Office) tools and conventions.
• 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.
• Excellent technical skills in SQL to extract, transform and loadingdatato the database using tools such as Guidewire Datahub.
• Expertise in source to target mapping in Enterprise and CorporateDataWarehouse environments.
• Worked with defect tracking tools likeJIRA, and QualityCenter.
• Highly effective management and organizational skills with ability to prioritize.

PROFESSIONAL EXPERIENCE

Confidential - Ewing Township, NJ

Sr. Business Analyst

Responsibilities:

• Followed guidelines laid down by Confidential 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 asRatingand Forms.
• Worked on Commercial lines P&C Insurance including both policy and claims processing and reinsurance.
• Managed the implementation of Image Right (a paperless solution) for the Reinsurance Claims Division -- oversaw and planned the "Go Live" process training.
• Analyzed and documented Reinsurance Claims, Billing Collections, and accounting modules of the application.
• 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 inpolicyrenewals.
• Serve as Property & Casualty Insurance SME, reporting to the President, addressing various Insurance industry issues as they arise and the point person for the development and adoption of the ACORD xml standards.
• Act as a BA for integration of Guidewire Policy and BillingCenter for Personal Auto LOB. Responsible for integration points including ClaimCenter, OFAC, VIN lookup, ISO reporting, PeopleSoft Financials, Check printing, documents management printing/archiving, claims retrieval from legacy system, SIS, telephony to name a few.
• Worked extensively on Statistical and financial reporting piece of the project ISO and WC reporting.
• Analysis of the Business requirements and Performance requirements of the medical instruments and associated software, validating their functional performance according to FDA, ISO 9000, IEEE, and Corporate Standards.
• Worked on various BillingCenter Integration User Stories (PolicyCenter- Get Payment Plans, GetPolicyContacts, Reinstatement, Renewal, Process Non-Pay Cancellation, Agency Sweep).
• Worked with Guidewire developers and production support team to understand various functionalities in GuidewirePolicyand BillingCenter.
• Created product rules and gathered requirements for the implementation of discounts, rating inputs, and reports for implementing Guidewire PolicyCenter.
• Involved in developing all the ETL processes developed for fetchingdatafrom OLTP systems to the target MarketDatawarehouse 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 ofBusiness.
• Involved in developing SQL Joins, SQL queries, tuned SQL, views, test tables, scripts in development
• Map actuarial concepts (annuities valuation, reserving, reinsurance) to data model structures: identification of existing, or creation of new business terms their descriptions and sourcing
• Documented the current state Reinsurance business process flows for Facultative and Treaty Reinsurance business lines. This involved understanding of their Proportional and Non-proportional Reinsurance Contracting for Treaty Reinsurance business.
• Utilized Oracle SQL queries to accessdatastored in thedatawarehouse 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
• Conducted JAD sessions, created Use Cases, workflows, 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.
• Collectedbusinessrequirements to set rules for properdatatransfer fromDataSource toData Target inDataMapping.
• Worked onDatamapping, logicaldatamodelling used SQL queries to filterdatawithin database tables.
• Accept user stories as completed inJIRAupon 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 - Westfield Center, OH

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 ClaimCenter.
• Facilitated requirements gathering and validation workshops forGuidewire ClaimCenter.
• Extensive worked onpolicy, location, and age group-based data mapping
• Performed JAD Sessions, walkthrough with Business, Legacy, Configuration/Interface Developers and ETL Team to provide comprehensive data.
• Implemented Certificate Management System CIMS, Aviation Logistics eAviaL and Accident Autopsy Systems AAIS.
• Elicited requirements from actuaries, Billing specialists andpolicyspecialists.
• Responsible forDataManipulation andDataValidation 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 ofPolicyCenterwith BillingCenter.
• Implemented SEI CMM, ISO and IEEE standards throughout the Quality Assurance Life Cycle and documented the entire Testing Process in MS Word.
• Analyzed Workers Compensation ISO circulars and wrote requirements.
• Analyzed ISO rules and rating for Commercial Auto and General Liability.
• Expertly 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.
• Created test plans and test cases for implementation testing of Guidewire PolicyCenter 3. insurance program opportunities for reinsurance partners.
• Created technical impact documents, data mapping documents and defines ACORD mappings for various interfaces based on knowledge of business needs and working closely with senior department managers and key department members with limited supervision.
• Communicate with Customer Service on ACORD Forms design and other technical problems.
• Responsible for managing communication and expectations of system vendor, the former parent company IT and business departments, and Allied Worlds various business units (underwriting, claims, reinsurance, actuary, accounting, and IT).
• Developed and facilitated reinsurance training for field claims professionals.
• Expertly 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.
• Involved in identifying new commercial insurance program opportunities for reinsurance partners.
• Analyse and recommend procedures and guidelines for Fully Insured and Reinsurance products for the entire organization.
• Wrote SQL queries using joins, sub queries, and inline views to retrievedatafrom 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 ofdatain database tables.
• Facilitatedbusinessrequirements 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 andBusiness.
• 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.
• Performed Business Process Mapping and performed AS IS and TO BE analysis.
• Performed complex SQL queries for retrievingdatafrom the database, generating ad-hoc reports, and conducting datavalidation testing.
• Worked on Comprehension of ISO manuals.
• Assured and controlled quality according to Standard for Financial Services Messaging ISO 20022.
• Involved in extensiveData validation using SQL queries and back-end testing.
• Worked on Guidewire software to track the claims of the policy holders.
• Developed departmental reporting process for tracking monthly reinsurance claims activity.
• Responsible for creating Bordereau report monthly for reinsurance broker.
• Responsible for special projects requested by company management or reinsurance broker involving analyzing underwriting revenue and financial performance for company's reinsurance broker.
• Involved in end-to-end requirement gathering and proposing best solution to simplify the implementation of Insurance product and GuidewirePolicyCenterand BillingCenter, Coordination & Management
• Identified "As is" process and "To be" process as parts of gap analysis for legacyPolicyCenterto GuidewirePolicyCenter.
• Prioritized the GuidewirePolicyCenterrequirements based on actualbusinessneeds to align them with the project roadmap.
• Experience with complex SQL queries fordataprofiling forDataETLIntegration tool.
• Used Guidewire to upgrade the current Claim system to track the claim of the policyholders and third-party applications
• Involved in Reinsurance system implementation (FRS) including setup of Treaty &, Facultative contracts, System data table.
• Responsible to document feature enhancements identified by Actuary Analysts, Underwriters and System Users
• Documenting business rules updates in policy, assumed, retro and accounting modules of reinsurance system.
• 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.
• 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.
• 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.
• Analyzed and clarifybusinessneeds to create user stories inJIRAfor agile sprint team developers.
• 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 - Boston, MA

Business Analyst

Responsibilities:

• Gathered high-level requirements 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 P&C Insurance including both policy and claim processing and reinsurance.
• Worked on P&C 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 preparedbusinessprocess 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,DataWarehouse Process Flow (SQL queries & Crystal Reports) using MS Office (Word, Excel, Visio) and dashboards.
• Involved in developing detailed source-to-target Data Mapping,BusinessRules 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 - Amelia, OH

Business Analyst

\Responsibilities:

• Actively involved in brainstorming and JAD session with the client to identify all thebusinessrequirements 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.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence team to understand repository objects that support the business requirement and process.
• Managed the Requirements (Businessas well as System requirements), performed requirements analysis along with the creation of Use Case Scenarios. Modelling of thebusinessand 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 andbusinessowner insurance - commercial lines.
• Developed Process Workflows, 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.
• Facilitate information gathering sessions with Corporate CFO, Chief Actuary, Investments VP and Line of Business CFOs to define financial business processes.
• Queried database using SQL queries to ensuredataintegrity and to validate the inserted and updateddata.
• 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 fordatavalidation, 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.
• 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.