Sr. Guidewire Business Analyst Resume
Bloomington, IL
SUMMARY:
- 7+ years of experience as a Business Analyst in P&C (Property and Causality) with solid understanding and capturing Business Requirements, Business Process flow, Business Process Modelling, Data Analysis, SWOT analysis, and Business Analysis.
- 5+ years of experience in implementing the Guidewire PolicyCenter, ClaimCenter, BillingCenter for Auto and Property Casualty Insurance.
- Experience in Guidewire suite (PolicyCenter, ClaimCenter, BillingCenter and Contact Center) integrations.
- Experience in writing documents like Business Requirement Document (BRD), Functional Requirement Specification (FRS), Change requests, developed Use Case Diagrams, Activity Diagrams, and Business Flow Diagrams, Test confirmation criteria.
- Extensive experience in creating Work break down structure (WBS), Use Cases, process work flows, Use Case Scenario and Use Case Narrative, using the UML (Unified Modeling Language) methodologies.
- 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.
- In depth experience in Auto - General Liability, claims and property coverage life, property and casualty insurance lines of business.
- In-depth knowledge of SDLC methodologies like Waterfall, Rational Unified Process (RUP), Agile/SCRUM.
- Hands-on experience as Business Analyst in directing cross-functional teams of technical experts to analyze systems & processes and implement infrastructure improvements.
- Prepared use cases and user stories, Investigates, processes and manages worker's compensation claims and processed worker's compensation claims, consistently communicating with third party vendor.
- Expertise in the Property, Casualty, Annuities, Disability, and Supplemental Insurance policies and having good command on SWIFT messaging and commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
- Highly proficient in operating MS SQL Server 2012/2008 R2/2008 suite of products like SSIS, SSRS and SSAS.
- Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation for SIT and UAT to assure that all aspects of a Project are in Compliance with the Business Requirements.
- Involved in documenting customization requirements, business rules and data migration requirements for the Implementation of Guidewire ClaimCenter and PolicyCenter.
- Headed Vendor Management and procurement tasks such as Request for Proposal (RFP), Request for Information (RFI), Statement of Work (SOW), Service Level Agreements (SLA).
- Business domain knowledge of Property and Casualty Insurance including risk, Policy Sales, Policy Administration System, Receivables and Payments, across different lines of business.
- Experience in Data Warehouse applications testing using Informatica Power Center and Ab Initio on multiple platforms.
- Expert in Insurance Technology solutions like Guidewire suite and PEGA with in-depth knowledge in the Underwriting, policy administration, billing, rating, reinsurance and claims process.
- Extensively experienced in database activities like Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication.
- Expertise in understanding Policy Administration System using Guidewire PolicyCenter especially in Commercial Lines (Businessowners, Worker's Compensation, Business Auto).
- Experience working on post go-live stabilization team for product costing, controlling (profit-center accounting), capital/expense internal orders, fixed asset accounting and project systems.
PROFESSIONAL EXPERIENCE:
Confidential,Bloomington, IL
Sr. Guidewire Business Analyst
Responsibilities:
- Working as a Guidewire Business Analyst for the Advance Project in the Personal Lines PolicyCenter, which is a web-based policy administration system used for quoting and applications for all personal lines products.
- Worked on various Guidewire integration concepts like Messaging, Batch Processes, Web Services.
- Hands on experience with Guidewire PolicyCenter and ClaimCenter (Worker's Compensation Claims, General Claims) upgradation to v9.
- Conducted gap analysis and made As-is-to-be diagrams to understand new business requirements and challenges in implementing new modules of BillingCenter and Claim center over the existing billing and claim management systems.
- Configured screen layouts, business logic, business rules, and operation parameters such as roles, permissions, user attributes, and regions as well as created new screens in Guidewire Studio as needed.
- 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.
- Designed 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
- Involved in Guidewire Corporate Training on Guidewire PolicyCenter, Worked on Commercial Lines Property and Casualty Insurance.
- Performed JAD Sessions, walkthrough with Business, Legacy, Configuration/Interface Developers and ETL Team to provide comprehensive data.
- Validated policy and claim data to assure every details are populated correctly from the legacy system WINS to Guidewire ClaimCenter.
- Implemented integration with ClaimCenter to retrieve Policy Period payload and account invoice payloads from Billing Center to send Withdraw notices and Cancellation notices.
- Accurately performed initial risk analyses by monitoring files to obtain all needed underwriting information.
- Documented Business requirements in Business Requirements document (BRD) for Property & Casualty - Personal and Commercial insurance lines: Workers compensation, Homeowners, General Liability.
- Involved in driving the creation of Unified Modeling Language (UML) diagrams such as Activity Diagrams, Use Case Diagrams, Flow charts and Process Flow Diagrams.
- Actively participated in JAD sessions for overcoming project issues relating to data processing, user interface, and downstream system interactions.
- Performed complex SQL queries for retrieving data from the database, generating ad-hoc reports, and conducting data validation testing.
- Provided process improvement initiatives to promote efficiency within loan processing, underwriting, closing and meeting Service Level agreements.
Environment: Agile, Guidewire ClaimCenter v8, Guidewire Billingcenter v8, Guidewire Policycenter v9, Business Objects, Winsql, SAS,, Consensus, MetaCenter, Informatica, SOAP UI, Rally, Jira, MS Office, MS Visio, DB2, Oracle, MS Project, MS SharePoint, Windows XP.
Confidential,New York,NY
Guidewire Business Analyst
Responsibilities:
- Led requirement gathering elicitation through open-ended discussions, brainstorming, and prototyping for the development and implementation of a new Guidewire PolicyCenter 7.0.5 suite.
- Mainly responsible for working in migration from legacy system to Guidewire system.
- Utilized the guidelines and artifacts of the Rational Unified Process (RUP) to develop a detailed Implementation of Rational Unified Process effort for Guidewire ClaimCenter Integration in different iterations and phases of the Software Development Life Cycle (SDLC).
- Analyzed Business Requirements and created Use Cases, Use Case Diagrams, Navigation Flow, Business Flow Diagrams and Work Flow Diagrams for applications, created Activity Diagrams / State Chart Diagrams using MS Visio and created conceptual model, behavior diagrams using SharePoint.
- Worked with ClaimCenter integration requirement with Docs and Forms, BillingCenter, Rating, Customer Data Hub, Risk Report, Portfolio management, Policy Service, Analytical systems and Defining rules and requirements.
- Involved in the automated data collection and updation processes through SSIS packages for gathering data from different sources like SQL server, PostgreSQL and flat files.
- Mapped legacy data with PolicyCenter target tables in the required data dictionary and configured PolicyCenter with tight document/imaging support, new screens, revised assignment logic.
- Created product rules and gathered requirements for the implementation of discounts, rating inputs, and reports for implementing Guidewire PolicyCenter.
- Conducted controlled brainstorming sessions with project focus groups and documented business requirements with wireframes and mockups to explain in detail the business implications and impacts.
- Centralized the policy creation by integrating Guidewire PolicyCenter with Guidewire Claim Center Systems, Billing System and other existing system supporting operations.
- Performed system analysis on Guidewire Billing Center 8.0.3 based on each user story and presented results to SME's.
- Implemented UML, Use Case diagrams by using MS Visio in order to conduct a more effective and healthy communication with stakeholders and clients.
- Involved in interactions with Subject Matter Expert, Project Manager, Developers, and the end-users in more than one JAD sessions. MS Project proved useful in coordinating activities with project manager and various other team.
- Assisted underwriting, claims, audit and billing department in developing new or improved product for these LOBs
- Generated Use case for business process and User Stories for Guidewire PolicyCenter to understand the various possible scenarios and dependency among various line of Business (LOB).
- Captured User stories using guidewire template; few major stories worked on included Commercial Auto, Worker's Compensation, Business Owners Policy and Commercial Property Package.
- Obtained Data requirements, identified data sources, determined the content of data fields and created Data Mapping Documents and performed Data Extraction using SQL queries.
- Worked with SQL Server Integration Services in extracting data from several source systems and transforming the data and loading it into ODS.
- Analyzed existing reports, redundancy, data flows using ER diagram, SQL, data mart used and design future reports using BO.
- Conducted detailed and comprehensive business analysis using RUP methodology. Elicitation sessions included meetings with Stakeholders and end users in order to identify the new system and its operational requirements.
Environment: Windows, Guidewire (PolicyCenter, ClaimCenter, BillingCenter), MS Word, MS Powerpoint, MS Excel, MS Visio, MS Sharepoint, MS Project, Microsoft Team Foundation Server, Oracle, Rally, SQL, Agile, Microsoft Office suite, UML.
Confidential,Warren,NJ
Guidewire Analyst May
Responsibilities:
- Hands-on experience with Guidewire PolicyCenter and ClaimCenter (Workers Comp Claims, General Claims) configuration.
- Utilized the guidelines and artifacts of the Rational Unified Process (RUP) to develop a detailed Implementation of Rational Unified Process effort for Guidewire ClaimCenter Integration in different iterations and phases of the Software Development Life Cycle (SDLC).
- Developed business requirements documenting workflow and process, for migration of worker's compensation claims to Guidewire platform.
- Performed GAP analysis on the traditional claims system and newly integrated ClaimCenter and carefully elaborated application enhancement specifications detailing in scope/out of scope items, as-is/to-be process maps and critical test scenarios.
- Migrated SQL Server 2005 Data Transformation Services (DTS) packages from SQL Server Enterprise manager to SSIS 2008 Packages by using DTS Package Migration Wizard tool.
- Performed Integration testing with Guidewire Claims System and Guidewire Billing System.
- Effectively utilized Business Process Modeling techniques and enhanced the existing assembly to adapt to new process that involved GWBC Upgrade.
- Responsible for elaborating Billing Center integration user stories such as Integration to Agency Management system, Process commission payment via Enterprise Payment Services, Integration to commission management center, BC to PC custom integrations, etc.
- Established and maintained relationship between requirements for consideration during change management and requirements allocation using Team Foundation Server.
- Performed migration from the in-house legacy based underwriting, policy center, claims center and billing center applications to Guideware
- Actively conducted SCRUM meetings and ensured all Agile project techniques are used in accomplishing the tasks based on the dead-lines.
- Worked with SCRUM Master, Business Owners, Project Sponsor, SME and Guidewire Consultants to define Product Backlog, Sprint Backlog, estimate efforts for user stories.
- Worked with the business and developers to test End to End Commercial Lines business processes
- Designed and developed 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.
- Worked in Guidewire Claims Center Web Services, Event Messaging, XML parsing etc.
- Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
- Interacted with business heads to finalize the product backlog for the Guidewire application.
- Developed various documents using AIM including BR100s, mapping documents, MD50s and testing scripts while using Waterfall Methodologies.
Environment: Mainframe, DB2, VSAM, SQL Server, HP ALM, JIRA, SOAPUI, Guidewire Application suite(PolicyCenter, ClaimCenter, BillingCenter)
Confidential,Boston,MA
Business Analyst
Responsibilities:
- Gathered, analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders, thereby drafting the Technical Design Document (TDD) and System Specification Document (SSD).
- Hands on experience with Guidewire PolicyCenter and ClaimCenter (Workers Comp Claims, General Claims) configuration and implementation.
- Experience in configuration on Guidewire ClaimCenter including working on UI and Business, Data model.
- Worked with Technical and Business leads during Guidewire PolicyCenter implementation.
- Involved in designing, coding, testing and implementing integration programs that will integrate Guidewire software.
- Created and configured PCF pages, workflows, entities, type lists, etc using Guidewire Studio.
- Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing
- Prepared business requirements document and functional specification documents; created Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, and Screen mock-ups using Microsoft Visio
- Carried out defect tracking using Clear Quest, wrote Test Cases and performed User Acceptance Testing
- Wrote SQL Queries in Oracle for data manipulations and created Logical Data Models of the Database
- Manage software system development and integration projects through all phases of Project Life Cycle - analysis, design, development, testing, implement data, and post-production support.
- Interacted with Guidewire Development team on synchronizing the screens based on customizations.
- Designed and developed Use Cases and Use Case scenarios, Activity Diagrams, Sequence Diagrams, High Level and Low Level Process Flow Diagrams, OOAD using UML and Business Process Modeling.
- Conducted surveys, interviews, and JRP, JAR and JAD sessions and translated them into system Requirements.
- Responsible for preparing Business Requirement Document (BRD), Functional Requirement Document (FRD) and then translating into functional specifications and test plans.
- Assisted in the development of project definitions, project scope, cost/benefit and risk analysis, work plans, daily and weekly progress reports, and presentations.
Environment: Visual Studio.NET, SQL Server 2008, SSIS, SSRS, VSS, Crystal Reports, MS office 2008, Visio, Windows Server 2008