SUMMARY

• Over 8+ years’ experience as Business Analyst in directing cross - functional teams of technical experts to analyze systems & processes and implement infrastructure improvements. Familiar with Prototyping, RUP and SDLC methodologies.
• 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, policy center, claim center, billing center, data warehouse, rating,reinsuranceand claims process.
• Insurance business knowledge with project experience in various LOB's such as Personal (Auto, Dwelling, Homeowner) and Commercial (Commercial Auto, Workers Compensation, Commercial Property, General Liability, Business Owners Policy (BOP), Commercial Package Policy (CPP).
• Excellent knowledge of various policy administration & industry standard tools such asGuidewire Policy Center,Guidewire Claim Center, GuidewireBilling Center.
• Expertise in understanding Policy Administration System usingGuidewirePolicy Center especially in Commercial Lines (Businessowners, Worker's Compensation, Business Auto).
• Executive responsible forBOP, CMP-Middle Market, Commercial Auto, Workers Comp, Farm, Umbrella (Personal & Commercial), Personal Auto, Homeowners, and Dwelling Fire products
• Experiencein working with fiveunderwritingbusiness units and the National Services Department (Centralized Ops)to determine business needs and system requirements for various commercial insurance products.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Worked on Property and Casualty insurance company as an Underwriter. Strong understanding of rating in Property and Causality.
• Hands on experience and expertise in Guidewire Policy Center implementation and integration by leveraging Agile Methodology.
• Experience in Statistical Analysis and predictive modelling of large datasets.
• Work closely with production underwriters to review commercial property insurance renewal and new business opportunities to ensure proper risk identification, analysis and assessment and the development and growth of a profitable portfolio of business. proficient in writing SQL queries and conduct data analysis using SQL and Good working knowledge of MS Excel
• Experience using database query tools for Oracle, SQL and UNIX.
• Performed Data mapping, logical data modeling, involved in creating class diagrams and ER diagrams and used SQL queries to filter data.
• Extensively involved in the modeling and development of Reporting Data Warehousing System
• Experience in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center.
• Experience working with Guidewire for Claims, Billing and policy management.
• Excellent business writing skills in writing Preliminary Investigation Report, System Requirements document, Systems Design Specification and System Requirement Change Request.
• Experience working with Guidewire for Claims, Billing and policy management.
• Experienced withACORDStandards, Implementing, and Mapping, Documenting various XML integration projects, across diverse property and casualty insurances lines of business.
• Experiencein Analyzing and redesign of existing procedures (EDI, SOP, onboarding, etc.) to reduce process inefficiencies.
• Experience on Guidewire's UI testing in Policy Center and Billing Center Screens for Personal lines business Defined the page layouts, reports templates and dashboard layouts for reservation monitoring and for gathering usage statistics.
• Strong Knowledge in developing a file ofACORDForms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
• Experience in designing processes & sub-processes & confirming it against the functional requirements by following the Agile SDLC methodology.
• Extensive knowledge of Policy Admin system and related operations like New Business, Endorsements, Billing and Claims in property and casualty - Personal Lines.
• Strong Knowledge in SQL query skills (Oracle and TSQL) in analyzing and validating SSIS ETL database data warehouse processes.
• Strong Knowledge in SDLC, Business analysis, GAP analysis and Quality Assurance of application software in Agile framework.
• Working knowledge in the Enterprise Data Warehousing (EDW) and ETL (Extract, Transform and Load) of data into a data warehouse/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence) and QlikView.
• Experienced in creating Data Flow Diagrams, Use Cases, Use Case Diagrams, Activity diagrams, Entity Relationship Diagrams, Data Mapping, Data Integration.
• Experience in Functionality Testing, User Acceptance Testing, Database Testing, Regression testing and Risk Based Testing.

PROFESSIONAL EXPERIENCE

Confidential -Houston, TX

Sr. Business Analyst

Responsibilities:

• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Worked in Guidewire Claim Center is the project which was undertaken to upgrade the current Claim System to track its claim for both their owned Policy holders and third-party applications.
• Documented Business requirements in Business Requirements document (BRD) for Property & Casualty - Personal and Commercial insurance lines: Workers’ compensation, Homeowners, General Liability.
• Assisted the creation of Agile story backlogs for various Personal lines and commercial lines projects in Guidewire.
• Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker’s Compensation, Umbrella, Business Owners Policy (BOP), Commercial Output Policy (COP), and Commercial Property Package (CPP).
• Prepared and updated functional requirement specification document for Guidewire Claim Center configuration on the out of box functionality.
• Performed migration from the in-house legacy-based underwriting, policy center, claims center and billing center applications to Guidewire.
• Established a RUP (Rational Unified Process) centric business analysis methodology.
• Work closely with production underwriters to review commercial property insurance renewal and new business opportunities to ensure proper risk identification, analysis and assessment and the development and growth of a profitable portfolio of business.
• Acted as a liaison between client and internal Developers to design software applications for Commercial Line Insurance such as Workers Compensation, Commercial Property, General Liability and Commercial Auto.
• Extensively worked on Workers Comps Proof of Coverage (POC)/Bureau reporting, FTP/XML/JSON file validation, Policy Rating, Product Model, Data Model, Data Analysis, Data Conversion, PCF, XML's, Messaging, ID Cards, Endorsement, Declarations, Notices, Exclusions and supporting documents for Commercial & Personal Auto, GL,BOPand WC LOB's.
• Performed Integration testing, System testing, Regression testing and Performance testing of Billing Center, Policy Center and Payment Manager in Guidewire application based on the business requirements using LISA.
• Review reinsurance contract and amendment language for accuracy and appropriateness
• Involved in Designing business requirement & systematic approach based on project scope and SDLC.
• Involved in automated policy management processes and streamlined core functions of the policy lifecycle including product definition, underwriting, quoting, binding, endorsements and renewals.
• Translated business requirements into functional requirements and prepared an extensive project plan to reduce inter-company transactions in equity derivatives and foreign exchange trades.
• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Verify & Validate the data-mapping by verifying various accounts details in various banking mainframe regions using test scripts in Quality Centre & filling defect logs if any.
• Conducted User Interviews and Work Shops to gather accurate Business Requirements.
• Prepared High Level Logical Data Models and BRD's (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Facilitated JAD sessions with end users, development and QA teams. Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Worked on Developing UML Use Case models using Rational Rose, workflow and Screen Shots for the application.
• Assisted QA team in executing Test plans and wrote Test Cases.
• Worked on Developing RUP analysis model using object-oriented design concepts that include entity classes, use Case diagrams and Sequence diagrams using rational Rose to enable developers and stakeholders for a clear comprehension of the business process.

Confidential -Pekin, IL

Business Analyst

Responsibilities:

• Gathered requirements for the Guidewire Workers Compensation, Personal Auto and Commercial property in Claims Center.
• Configured Guidewire Policy Center to fulfil client requirements for the Auto and Property personal lines ofbusiness.
• Elicited and gathered user and business requirements through open-ended discussions, brainstorming and storyboarding/prototyping for Guidewire claim center.
• Generated User Stories, Business Rules, and Storyboards to develop and enhance a web portal and to integrate it with the Guidewire claim center.
• Worked in property and casualtyinsurancein Commercial Auto, Workers Compensation and Umbrella Policy and Business Owners Policy (BOP).
• The Data Warehouse was created around the Accord Messaging Standard with extensions where necessary (Workers Compensation, Commercial and Personal Lines Auto).
• Worked on conducting User Acceptance Testing (UAT) and documenting test cases in both personal commercial line of property and casualty insurance.
• Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker’s Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Translated stakeholder requirements into different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.
• This involved managing life and disability insurance policies during theunderwritingprocess.
• Worked on Requirement analysis with business analysts and attending Agile/Scrum model meetings to review the requirements and scope.
• Assisted in writing BRD for the Regulatory Reporting Unit under the system streamlining, followed the Agile Methodology for the entire SDLC.
• Worked on compliance with GAAP. Also developed Data standards to be compliant withACORD.
• Responsible for Data Manipulation and Data Validation using SQL queries in a MS SQL Server. Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing andreinsurance.
• Collaborated with the business team in the creation and completion of project charters and project scope for Guidewire Policy Center and Claim Center.
• Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
• Obtained, analyzed, and prepared third party documents for theunderwritingprocess.
• Worked on workflow analysis toward automated disability claims process. Detailed comparison of two competing proposals, including HR interfaces. Facilitated requirements definition for new system.
• Completed the documentation of Claims Scenario's for the source system.
• Worked on Using JIRA for User Story requirements management throughout the Agile Sprints and development life cycle.
• Participated user acceptance testing cycle; worked withbusinessusers to definebusiness scenarios, user acceptance test cases and user acceptance criteria.
• Worked closely withbusinesspartners, SMEs and product owners to understand the process.
• Involved in project planning, coordination and QA methodology in the implementation of the Facets in theEDItransaction of the claim’s module.

Confidential, Worcester, MA

Business Analyst

Responsibilities:

• Gathered the high-level business needs from the directors and prepared the High-level Business Needs.
• Worked on Commercial Lines Property and Casualty Insurance including both policy and claim processing andreinsurance, Life insurance policies, Nationwide annuities (Variable, fixed, Immediate, fixed indexed).
• Involved in identifying new commercial insurance program opportunities for reinsurance partners.
• Reinsurancesystem implementation (FRS) including setup of Treaty & Facultative contracts, System data table configuration; loading Premium and Loss data extracts; running test calculation cycles, and validation of ceded results.
• Developed business requirements documenting workflow and process, for migration of worker's compensation claims to Guidewire platform.
• Used business analysis techniques, documented business requirements to be readily used by Guidewire configuration analysts and worked on Property and Auto products using Guidewire Application.
• Involved in developing SQL queries to interact with the lifecycle database and provide monthly capacity reports reflecting on the utilization ofEDIinfrastructure.
• The Data Warehouse was created around the Accord Messaging Standard with extensions where necessary (Workers Compensation, Commercial and Personal Lines Auto).
• Analyzed Business Requirements and segregated them into high level and low-level Use Cases, Activity Diagrams/State Chart Diagrams (UML).
• Involved in business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC.
• Gathered Requirements and documented the process flows/changes required to facilitate the entire migration of the Policy Billing administration from Mainframes to the Guidewire system.
• Involved in documenting customization requirements, business rules and data migration requirements for the Implementation of Guidewire Claim Center and Policy Center.
• Reviewing data model proposed by upstream systems to ensure that it is feasible to extract the data; and framing logic for each field requested by Business to be present in the report.
• Worked on various Guidewire integration concepts like Messaging, Batch Processes, Plugins, Web Services.
• Worked on JIRA for tracking the issues and defects during the process of Implementation.
• Actively involved in resource/project planning and estimations for existing and upcoming projects.
• Actively participated in developing test plans and test procedure templates and guidelines to be used Identify customer-marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
• Coordinated with internal departments to assist policyholders in maintaining their enrollments when outside limitations of theEDIfile.
• Followed agile methodology, being Business Analyst as Product Owner for better Collaboration among Scrum Master, Scrum Team and Business Stakeholders.
• Involved in Research and recommend tools for Agile process management. Mentor business analysts on agile processes and traditions.
• Worked on User Story’s based on the discussions with SMEs for the customization of Guide wire Product for the Policy Center application.
• Involved in QA review allEDIbasics programming and maps changes before they are move to production.

Confidential -Dallas, TX

Business Analyst

Responsibilities:

• Responsible for interacting with Business and end users to gather analyze and flesh out business requirements and take those requirements to create Use Cases.
• Developed the BRD (Business Requirement Document) and wrote insurance policies.
• Actively participated with analyst team that gathered Requirements for Reports Generation from Guidewire Policy/Billing center for analysis by the General Accounting Team.
• Used Guide Wire to upgrade the current Claim system to track the claim of the policy holders and third-party applications.
• Worked on Designing the High-Level Functional Requirement Document and experienced in business tools like Business Objects.
• Involved in a project, which dealt with the Production Stabilization and Defect Tracking of the newly migrated Guidewire Billing Center.
• Involved in Designing and developing project document templates based on SDLC methodology.
• Involved in the analysis of the existing data mapping phase according to functionality and data conversion procedure.
• The Data Warehouse was created around the Accord Messaging Standard with extensions where necessary (Workers Compensation, Commercial and Personal Lines Auto).
• Implement and maintain Property Insurance (e.g., bug fix, data integration, version release) rating systems of assigned customers.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Created and participated in JAD sessions to analyse and prioritize competing business needs.
• Requirement analysis with business analysts and attending Agile/Scrum model meetings to review the requirements and scope.
• Participated in the migration and implementation of both new and modifiedworkflowdesigns and business rules into QA and production environments.
• Involved in the system flow diagrams for the application including the activity diagrams, data flow diagrams and use case diagrams using Rational Rose and MS Visio.
• Analysed and optimized the process. Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification and Technical Specification using Rational RequisitePro.
• Involved in Developing an Analysis Model that includes entity classes, use case diagram, sequence diagrams, object collaboration diagram that provide the development team a view of the requirements for Construction phase activity using Rational Rose and MS Visio.

Confidential -Erie, PA

Business Analyst

Responsibilities:

• Worked on Visio process flowcharts for the enhanced Customer Complaint Handling System. Prioritize documentation schedule for multiple projects.
• Involved and Reviewed complex integration diagrams (Sequence, Component & Activity) to visualize Business Process and their interaction with interfacing systems.
• Conducted Joint Application Development (JAD) sessions with IT teams to identify changes and participated in Stakeholder Meetings to communicate the same.
• Involved in designing, coding, testing and implementing integration programs that will integrate Guidewire software.
• Worked with business to gather and analyze requirements, create user stories, coordinate with multiple teams to capture dependency details.
• Involved in configuration on Guidewire Claim Center including working on UI and Business, Data model.
• Worked along with Lead the migration initiatives (From Legacy to Guidewire products) right from inception phase till production deployment with hands on development.
• Involved in the project following Agile Scrum SDLC methodology.
• Provided assistance to the team to created daily, weekly and monthly reporting packages using Business Objects XI and Crystal Reports.
• Involved in Collecting the business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• Worked with the PMO to Create, Baseline and manage other projects within the Smart Grid Initiative
• Prepare data models and perform data analysis. Document metadata, including domains, definitions, and business rules.
• Responsible for making data model, Use Case Diagrams and Class Diagrams using UML.
• Created Use Cases, Workflows, and Screen Shots for the Application
• Involved in Project Status metrics for weekly evaluation of Project Status and impact of the Change Request on the Timeline.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Used MS Visio for Process modeling and Business Process flow diagrams.