SUMMARY:

• Over 7 years of IT and Management experience in Software Development Life Cycle SDLC and Project Life Cycle working as Business Analyst.
• Extensive understanding & experience of migrating insurance suite solutions to Guidewire solutions
• Experience working on Guidewire Claim Center, Policy Center and Billing Center
• Analyze the feasibility of and develop requirements for enhancements and defects related to the current Guidewire claims system
• Developed Training Strategies, Training Manuals, Process flows and Job aides on Guidewire projects.
• Knowledge of Guidewire integration framework and various integration methods like Web service APIs, Plugins, Messaging code, Guidewire XML models, templates etc.
• Worked on the Guidewire Policy Center 8.0, Billing Center 7.0, Claims Center 8.x/7.x
• Prepare presentations for business to explain plans, architecture and alternatives
• Conduct requirement - gathering sessions, interviews and Joint application Development (JAD) sessions among a diverse group of cross-functional stakeholders in a lead capacity
• Experience with Fixed Income instruments, Bonds and Derivatives. Conversant with the front, middle and back office of the trade order management systems (TOMS)
• Work on database marketing engagements and enhancements including loyalty programs, marketing campaigns and CRM systems
• Strong knowledge of RDBMS Concepts and Data Warehouse Techniques - ETL process, data modeling, performance tuning - and Business Intelligence (BI) Concepts.
• Experience writing and executing test cases and test scripts, based on requirements documentation provided by another resource or business user using HP Quality Center and QTP
• Expertise in preparing Test Strategy, Test Plan, Test Summary Reports, Test Cases and Test Scripts for Automated and manual testing.
• Experienced in functional, Integration, database and regression testing
• Experienced in using Agile Methodology including creating product / sprint catalogs, active participation in Scrum, Sprint planning and exit meetings.
• Experience in Workers Compensation and Personal Insurance modules in Guidewire Policy Center.
• Experience with Claims Management Module of the Guidewire software application.
• 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.
• Prepared Business process document, process flow diagrams, sequence diagrams, context diagrams. Knowledge of BPMN and UML.
• Experience working on Guidewire Claim Center, Policy Center and Billing Center. Experience working on Guidewire Policy Center Integrations and Configuration User Stories.
• Analyze the feasibility of and develop requirements for enhancements and defects related to the current Guidewire policy system.

PROFESSIONAL EXPERIENCE:

Sr. Guidewire Analyst

Confidential, Amelia, OH

Responsibilities:

• Worked on an end-to-end project which dealt with the enhancement and maintenance of the existing internal electronic enrollment platform and Policy System for providing better services to the customers. The new Policy center implemented for the company had the purpose to migrate its legacy policy data to the policy center module of Guidewire Insurance Suite.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Responsible for elaborating Billing Center configuration user story such as Invoicing rules, Delinquencies, Policy Cancellation, Automated disbursements, Policy Rewrites, Policy Reinstatements, Billing Parameters, Fees, and Payment distribution rules, etc.
• Facilitate meetings with the Guide wire Team elaborate numerous Billing Center OOB functionalities such as Close Policy Date, Trouble tickets and Holds, Payment Requests, etc.
• Worked with the business users and product owners to modify/add requirements to address multiple enhancements that are needed to fix any issues with previously implemented functionality in Billing Center
• Analyzed automobile dealerships to increase dealer efficiency, productivity, and profitability by 15% using integrated company designed software.
• Interact with the Guide wire team to modify the Out of the Box logic based on business needs
• Participate in the development of Guidewire Billing Center, Billing Center-Policy Center User Stories
• Design and Develop application flow as per business requirement
• Conduct demo/conference pilot sessions to present both custom and Out of the box Billing Center functionality to business
• Implemented standard guidelines in writing Gosu code in PCF files, Libraries and Rule sets across the project.
• Created data mapping between new Personal Lines Policy System and ISO reporting.
• Configuring SOA composite application resources, Configuring JMS Server and its modules on SOA and OSB.
• Managing and monitoring service engines, and updating the state of SOA composite applications.
• Tuning and configuring Oracle SOA Suite 11g environment for high availability and load balance.
• Calculate premiums,refunds, commissions, adjustments, and new reserve requirements, using insurance rate standards
• Request, analyze and take action on property inspection reports to ensure property rating and underwriting quality.
• Create process flowcharts for various issues in Billing Center functionality and help perform gap analysis
• Worked with Guidewire developers and prod support team to understand various functionalities in Guidewire Policy and Billing Center.
• Helped gain real-time visibility on business operations and receive continuous feedback loops to improve process performance using Appian BPM suite.
• Design and implementation of the process in Appian.
• Involved in flow diagrams using Visio, interpretation of complex flow shapes for business scenarios.
• Reports were displayed and derived through the use of .NET technology (ASP and VB), Crystal Reports, AS/400, SQL, and Excel spreadsheets.
• Worked with key stakeholders to understand and document the current data governance model associated business processes, and data remediation processes
• Worked with Data Governance Program Management to develop a target data governance model along with a road map
• Created .NET Reports which are used to present the data in different views and are effectively consumed using Crystal Reports.
• Developed .Net desktop applications using VS 2008 and SQL Server.
• Web Applications and Web Services using .Net technologies and SQL Server.
• Experience in working with J2EE and Weblogic based systems
• Actively managed Microsoft Active Directory, DNS, DHCP, WINS, Group Policy.
• Preparing BRD, Functional Requirement Document (FRD, Business Cases, and presentation to the clients, Business Re-engineering proposals.
• Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.

Guidewire Analyst

Confidential, Charlotte, NC

Responsibilities:

• Reviewed the Project Vision document and specified the Scope, Stakeholders and the High Level Business Requirements.
• Communicated extensively with users to define key requirements which included Operational and managerial reporting needs, Workflow management, Quoting and marketing needs, Policy life cycle, Claims management, Disaster recovery procedures.
• Preparing exposure data, analyzing and interpreting Cat risk associated with General Property, Onshore Energy, Power Utility and Construction accounts.
• Worked with DBA's to develop and implement a workflow process from Data Mart to populate Qlikview dashboards. Utilized best practice methodologies.
• Modeled use-case diagrams in Rational Rose to show end-user interaction with the personal information, loan information property information modules.
• Extensively used Tableau features like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions, Maps etc.,
• Prepared sequence diagrams, class diagrams and activity diagrams to elaborate the behavior, structure and process flow for the use-case models.
• Architected and deployed High Availability Clustered QlikView Shared Platform in all environments for the entire organization together with QlikTech.
• Worked on reporting and estimates for Property Casualty P C on Guidewire ClaimCenter implementation and interfaced with the client as part of the Requirements Engineering team to finalize the project scope.
• Identified and developed quality management plans, test scenarios, and test scripts for user acceptance based on system requirements.
• Identified, tested, and resolved database performance issues monitoring and tuning to ensure database optimization with also created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.
• Worked on reporting and estimates for Property Casualty P C on Guidewire ClaimCenter implementation.
• Performed sanity checks to ensure security and validation of online submissions. Included features to display contextual help in each section of the process.
• Conducted interviews with users to elicit requirements test strategy pertaining to Navigability, User-Interface Design, transaction processing and workflow.
• Developed test cases and for use-case models for the reports interface.Used Clearquest to report bugs and defects during UAT.
• Assisted the technical writers to prepare user manual and online help giving an end-user perspective.
• Ensuring Adherence to Standards and quality process set Creating schedules and monitoring progress to ensure quality timely deliveries .
• Participated in GAP analysis around the identification of business rules and system process flows, user administration, requirements and assumptions.
• Assisted Scrum Master to facilitate scrum meetings such as Sprint Planning meeting, Daily Scrum meeting, Sprint Review meeting, Sprint Retrospective meeting, and Backlog Refinement meeting.
• Effectively used Object Oriented Analysis and Design OOAD to categorize and structure the requirement into logical grouping to avoid redundancy.
• Analysis of data received through the broker for Commercial Property Insurance for General Property, Onshore, Power and Utility, Construction and Offshore line of business.
• Application of limits and deductible when account is bound for all Lobs in Open Xposure OX and OPUS Open Property Underwriting Software software.
• Analyze business requirements for a complex a Data integration Platform, working along with Stakeholders to identify and fill requirements gaps and manage documentation and hand-over to design team.
• Exposure refine: Includes Refinement / Enhancement of key loss factors and attributes of Lloyd's Market data i.e. including the occupancy profile of the insured and the core construction of the. Property henceforth Insure under Policy with the help of Exposure Source Database ESDB of RMS, GDT, Sanborn and other similar data sources.
• Identified and documented issues, risks and gaps, their descriptions, their impact and provided recommendation and alternatives to develop the application to meet the user requirements.
• Created data mapping templates and aided the development team to reduce the bandwidth of the project. Participated in User Acceptance Testing and Business-to-Business Transaction testing.
• Synchronized and prioritized relevant defects and enhancement/system requests based on business requirements

Guidewire Business Analyst

Confidential, West Trenton, NJ

Responsibilities:

• The project was to upgrade legacy back-office systems with Guide Wire to streamline operations in billing, processing claims, and managing insurance policies and develop automated processes to reduce the cost of operations, increase employees' productivity, and enhance customer relationships. These improvements span the organization to enhance the management and maintenance of policies, including billing, simple and complex changes, regulatory compliance requirements, and policy holder communication.
• 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.
• Conducted walkthrough of BRD in the JAD Sessions with users and developers. Collected specific information to include in the Functional Requirements Document FRD .
• Involved in creating data models for the data warehouse and specify data mapping documents from specific data sources.
• Proposed and prepared a template for storing e-mails exchanged by the Product Analysts, Underwriters, Business Analysts for easy reference and retrieval of information in preparing requirements document.
• Monitored claims operations metrics to ensure the operational effectiveness of the captive insured's business units and stakeholder medical malpractice claims operations.
• Coordinated with QA team in preparing for compatibility testing of Guidewire solution
• Designed and documented workflows and research metrics driving outcomes.
• Developed tactical and strategic metric reports to measure and track trends to make timely appropriate recommendations to support corporate initiatives and enhance results.
• Worked with catastrophic risk assessment models, property exposure and loss data along with other general insurance aspects.Uses the Guidewire Claim Center for the claim management system for property and casualty insurance.
• Managed/coordinated key claims operations projects including creating and maintaining project plans and schedules from concept to final implementation.
• Acted as claims operations liaison to IT/Decision Support Services DSS .
• Created test plans and executing testing for application enhancements for captive claims operations.
• Created objects from XML documents. Involved in Logical Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
• Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
• Compared Mainframe Output with Dragon Output for both Homeowner and Auto Insurance.
• Developed Data Flow Diagrams and Data mapping agreement, illustrating the flow of data from the front end Guidewire Claim Center into the Application database Tables.
• Preparing and updating functional requirement specification document for Guidewire Claim Center 7.2 configuration on the out of box functionality.
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Interacted extensively with Under Writers on training them and getting their requirements.
• Developed comprehensive system test scenarios and test scripts. Responsible for performing back-end analysis and testing using SQL queries
• Analyzed and documented Reinsurance Claims, Billing Collections, and Accounting modules of the application.
• Partnered with the technical areas in the research and resolution of system and process problems especially related to Power Builder platform.
• Provided customer service and support for Property Casualty risk management needs