Sr.business Analyst Resume
4.00/5 (Submit Your Rating)
Frankenmuth, MI
SUMMARY
- A dedicated result driven professional with 8+ years of information technology consulting experience that has extensive Insurance background of Property & Casualty experience which includes Claims, Products and Pricing.
- Experience as a Business Analyst and System Analysis,with expertise in business process analysis, business process modeling, business requirements, database design, strategic planning, and business analysis in the field of Insurance.
- Experience in commercial Property and Casualty, Commercial Lines and Personal Lines Insurance.
- Experience in working on Policy Administration System (PAS) system for P&C onDuckCreekTechnology.
- Experience working on Guidewire Claim Center, Policy Center and Billing Center.
- Experience working on Guidewire Policy Center Integrations and Configuration User Stories.
- Experienced in documenting customization requirements,businessrules and data migration requirements for the Implementation ofDuckCreekPolicy and Billing.
- Expertise inInsuranceDomain and using policy center product developed byGuidewire.
- Experience in defining Integration and SIT (System Integration Testing) strategy and approach by acting as a Program Test Lead for Guidewire Claims Center and Guidewire Policy Center implementations.
- Extensive experience in gathering system requirements, definingbusinessprocesses, UML modeling, sequence diagram and activity diagram.
- Possess Knowledge and Experience with Personal and Commercial Lines of Insurance, including Auto and Home Insurance.
- Knowledge of policy ratings, investigating claims, negotiating settlements, and authorizing payments.
- Experience inGuidewireconfiguration and integration experience with Claim Center, Policy Center and Billing Center.
- Worked with Technical Writers to decide manual Guide wire policy ratings for claims and loss controls.
- Experienced in complete WATERFALL, AGILE, RUP, SDLC, Client /server architecture providing a well balanced understanding ofbusinessrelationships,businessrequirements, worked for financial and technical solutions and helped the teams at all levels until final product release.
- Experience working with User Stories and Design Specifications based on Functional Requirements for Guidewire owned Policy Center Application.
- Experienced Microsoft Office Suite including Excel, PowerPoint, Word and Outlook, and othervarious claims systems such as Claims Outcome Advisor (COA), (DM),Guidewire, and ClaimCenter.
- Experience in applying Rational Unified Process (RUP) methodology using Modeling and requirement documentation tools such as MS Office, MS VISIO, and MS Project.
- Experience in conducting JAD Session and communicated with Stakeholders, Development team, SMEs, System Analyst, Business Analystand Project Manager.
- Involved in customization of UI ofGuidewirePolicy Center, Claim Center and Contact Manager.
- Involved in integration of Policy Center, Claim Center and Contact Manager.
- Proficient in transforming business requirements into functional specifications, focusing on workflow analysis and design, business process reengineering, user interface design, portal design, and process flow modeling.
- Excellent analytical skills for understanding thebusinessrequirements,businessrules,businessprocess and detailed design of the application.
- Excellent skills inBusinessAnalysis, requirement analysis,Businessmodeling and Use Case development using UML Methodology.
- Expertise in property, casualty insurance which involve PAS system scenario based quote shell creation, end to end system testing, letter binding, policy coverage's, policy ratings and data mapping comparison fromDuckCreekto shredding system.
- Created User Requirement Specification (URS), Functional Requirement Specification (FRS), business process flow System, change control & configuration management documents.
- Facilitated JAD sessions withbusinessowners, IT team & Users to drive out detailedbusiness requirements
- Experienced in Systems Testing, Integration Testing, and Software Quality Standards, Training, Documentation and implementation in abusinessenvironment.
- 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 experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
- Knowledge of SQL and experience of writing SQL commands.
- Expertise in writing SQL queries in MS SQL Server.
- Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Stored Procedures.
- Experience in extracting UI based information by querying the Oracle database using SQL queries.
- Extensive process analysis, data analysis and analytics, data mapping and data modeling skills (ERD) to develop solutions to complex application,businessand operational problems, and by performingbusinessprocess re - engineering and process improvements where necessary.
PROFESSIONAL EXPERIENCE
Confidential - Frankenmuth, MI
Sr.Business Analyst
Responsibilities:
- Created several documents and gathered requirements from the responsible Stakeholders and SME's.
- Worked on theBillingIntegration which included writing thebusinessrequirements for integrating the existingBillingsystem with the new Policy Admin system.
- Acted as a liaison with operational and financial management, systems support and sales to identify business opportunities. Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for Personal Lines of Business.
- Worked on Configuration/Businessprocess End to End user stories for Policy center (Policy Administration system) andBillingcenter (Account receivable and commission system).
- Worked on NewBusiness, Policy change, Reinstatement, PC to CC integration, NewBusinessDEC package, Policy Documents, Policy Hold and Suspense Payment inBillingCenter.
- Guidewire: Chiefly responsible for working in migration from legacy claims system to Guidewire claim center.
- Data Mapping: Expertly analyzed data sets for different auto insurance policies like liability coverage, personal injury protection and uninsured motorist protection coverage.
- Collaborated with Guidewire billing center and policy center teams at Frankenmuth.
- Hugely followed the migration rubric prepared for billing and policy center migration.
- Elicited requirements from actuaries, billing specialists and policy specialists.
- Conducted JAD sessions and one-on-one meetings with the Stakeholder's and SME's.
- Played a key role in claims transformation project using my knowledge of Guidewire Claim Center forbusinessprocess re-engineering, system requirement gathering and testing phases of this project.
- Assisted the Project Manager to create a Project Plan.
- Assisted the PM in establishing rules to allow permissible changes to be made to a claim without the assistance of the IT team.
- Established rules for the Straight-through invoice processing on Claim Center. These rules guided in the automatic paying of invoices.
- Assisted in creating scripted messages through the Claim Wizard to integrate with new rental car vendors, roadside assistance and repair vendors.
- Performed GAP Analysis and Root Cause Analysis between the source database and destination database. Then mitigated the issues from this Analysis.
- Created Process Flows in Visio and Lucid Chart.
- XML processed in Mainframe from the front-end system using Guidewire working with SQL server data.
- Experience with Integration- Data mapping work from Guidewire to various external systems.
- Participated in JAD for user interviews to gather requirements.
- Performed GAP Analysis for new functionality requirements and prioritized them based on thebusinessneeds.
- Participated in writingBusinessRequired Document (BRD) as well as write supporting document containing essentialbusinesselements, detailed definition and description of the relationship between the actors.
- Worked on Guidewire's UI testing in Policy Center andBillingCenter Screens for commercial linesbusiness.
- Involved in doing the smoke test for Policy Center,BillingCenter, Claim Center and Contact Manger.
- Assisted in producing and adjusting the Functional Specifications Document (FSD), Data Mapping Documents and the Requirements Traceability Matrix (RTM).
- Participated in conducting data analysis with the Dataanalystin defining data sources.
- Published functional requirements, screen prototypes on portal for access by all project participants.
- Created screen designs in VISIO for each step of system including all what if scenarios.
- Worked on Property and Casualty insurance company as an Underwriter.
- Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
- Maintained key records for purposes of Compliance review and/or regulatory inquiry. Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
- Involved and reviewed TSQL/SQL queries and stored procedures to process, analyze and implement data integrity initiatives for various business units.
- 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.
- Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
Confidential - Worcester, MA
Sr. Business Analyst
Responsibilities:
- Supported Gateway portal for Agents implementation (multiple sprints) at client site.
- Facilitated and conducted various working and review sessions with client SMEs and spoke to agents while gathering requirements for Gateway portal for Agents.
- Worked withDuckCreekUser Interface includingDuckCreekBilling and Policy Administration System.
- Preparation ofDuck-creekdetail requirement docs, Screen field Design Doc, Preparation of Application Work Flow.
- Performed Requirements Analysis and Design using Rational Rose, analyzed and documentedBusinessrequirements using Requisite Pro for the requirement tracking.
- Involved in creating manual test scripts for Functional and Regression testing of migrated P&C - Personal and Commercial Insurance policies for policy rating inDuckCreek.
- Developed end to end integration points between ClaimCenter and BizTalk middleware.
- Provided functional and testing support on the various user stories and discussion items on agent portal implementation.
- Documented User stories i.e. storing documents to GWPC, GWBC and ePresentment application (which is part of Customer Portal) with OnBase to retrieve and display Guidewire ingested documents.
- Using SharePoint access, conducted document analysis before requirement workshop (Onboarding documentation, inception documentation, Implementation documentation, Staffing document).
- Followed guidelines laid down by Guideone Insurance and PwC and utilized artifacts of the Agile-Scrum methodology to integrate, implement, and update theGuidewirePolicyCenter, BillingCenter and ClaimCenter in different sprints of the Software Development Life Cycle (SDLC).
- Work on Commercial line property insurance in Safe Agile methodology. Conducting grooming sessions, and facilitated daily scrum calls.
- Gathering requirements for Commercial Line Transformation Product and Pricing - Interface team.
- Independently conducted requirement gathering workshops withbusinessstakeholders (billing supervisors, disbursement specialists, account specialists, admin specialists, claim specialists) product owner, scrum master, lead developer, implementation partner, andGuidewireconsultants to document functional requirements using user stories for the new billing and claims module.
- Create and maintain Data model standards, including master Data management (MDM).
- Involved in extracting the Data from various sources like Oracle, SQL, Teradata, and XML.
- Conducted and led JAD sessions, group workshops, individual and small team meetings, and conference calls with Property Casualty FP&A teams, stake holders and developers to gather functional and non-functional requirements of the system including requirements and processes for life and annuity products.
- Implemented the development and training ofGuideWire-ClaimCenter within the claims. department. Wrote and maintained Claim Center training manuals.
- Developed use cases from requirements and created UML diagrams such as use case diagrams, activity diagrams, and sequence diagrams.
- Examined automobileinsuranceclaims for both Personal and Commercial policy holdersincluding coverage, liability investigations, and damage evaluations.
- Conducted gap analysis and made As-is-to-be diagrams to understand newbusinessrequirements and challenges in implementing new modules of BillingCenter and Claim center over the existing billing and claim management systems.
- Maintained Plan data loader andGuidewiretransition documents to keep track of changes in different project stages.
- Rate and Issue complex General Liability, Commercial Automobile, Property and Workers' Compensation policies as directed by Senior Underwriters and UW Manager.
- Work closely to define and develop requirements with various stake holders (Lines ofBusiness Product Directors and Underwriters,Businessusers), this entails reading and interpretingISO Circulars,ISOManuals to document as-is/to-be IT System orBusinessProcess.
- Created user stories by actively interacting with SME's, Account specialists, Claim Specialists, Billing supervisors, claim adjusters,Guidewirespecialists.
- DevelopedDatamappingdocuments between Legacy and User Interface Systems.
- Created UML diagrams including Activity and Sequence diagrams.
- Actively participated in JAD sessions for overcoming project issues relating to data processing, user interface, and downstream system interactions.
- Participated and assisted the scum master in conducting daily Scrum meetings and Sprint review meetings to ensure development goals are met within four sprints.
- Executing test cases, test scripts and test plans. Collaborate with SharePoint admin, SQL admin, SharePoint developer and project management teams from the design to the delivery of SharePoint applications and portals.
- Assisted QA team in developing test strategy, and test cases and actively monitored various types of testing - functional testing, Progression testing, system testing, load testing, smoke testing, and regression testing.
- Collaborated with the development team in validating requirements for out of box requirements.
- Involved in managing the defect lifecycle - conducting daily defect tracking meeting, reporting and reviewing the defects, assigning the open defects to developers, and re-testing the fixed defects.
- Managed Requirement Traceability Matrix to ensure test cases are traceable to requirement specifications.
- Actively facilitated complete UAT process - creating UAT schedules, testing guidelines, managing feedback, follow-up, and resolving open issues.
- Performed complex SQL queries for retrieving data from the database, generating ad-hoc reports, and conducting data validation testing.
- Assisted in development ofGuidewiretraining and transition documents documents for the upgraded version of the existing system technology and process improvements.
Confidential - Jacksonville, FL
Business Analyst
Responsibilities:
- Using SharePoint access, conducted document analysis before requirement workshop (Onboarding documentation, inception documentation, Implementation documentation, Staffing document).
- Worked on GPA web portal using web services, helped with mapping and process flow diagrams,
- Coordinated daily Meetings (Agile methodology), Project Planning, sprint planning, sprint review and sprint retrospective.
- Created various use cases related to GPA functionalities for business users (agents) ; new claims, quotes, access to updated business products.
- As the only CBAP in the team, independently conducted requirement gathering workshops with business stakeholders (billing supervisors, disbursement specialists, account specialists, admin specialists, claim specialists) product owner, scrum master, lead developer, implementation partner, and Guidewire consultants to document functional requirements using user stories for the new billing and claims module.
- 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.
- Periodically updatingISOcircularchanges to rates, forms and rules for compliance withISO.
- Proficient inDuckCreekSession XML and Data Model for Commercial Auto, Commercial Property and General Liability.
- Addressed all aspects of the claim processing lifecycle, starting from identifying a claim right up to closure
- Created and maintainedBusinessRequirements document and System Requirements document. In addition, was responsible for getting appropriate sign-offs and approvals.
- Maintained Plan data loader and Guidewire transition documents to keep track of changes in different project stages.
- Created user stories by actively interacting with SME's, Account specialists, Claim Specialists, Billing supervisors, claim adjusters, Guidewire specialists.
- Worked with requirements management, workflow analysis, sourcedataanalysis,datamapping, Metadata management,dataquality, testing strategy and maintenance of the model.
- Documented both out of box and customized requirements.
- Worked on reporting and estimates for Property & Casualty (P&C) on Guidewire ClaimCenter implementation.
- Created UML diagrams including Activity and Sequence diagrams.
- Worked with Rating team to gather requirements for Rating Engine (rate books, rating table, rate parameters, versioning, rating routine, rating worksheet, import and export of XML and correcting per specifications.
- Actively participated in JAD sessions for overcoming project issues relating to data processing, user interface, and downstream system interactions.
- Managed the Code Merges after major, monthly and emergency releases of Guidewire Suite Applications for all centers in production, including Quote and Bind Portal Application.
- Participated and assisted the scum master in conducting daily Scrum meetings and Sprint review meetings to ensure development goals are met within four sprints.
- Assisted QA team in developing test strategy, and test cases and actively monitored various types of testing - functional testing, Progression testing, system testing, load testing, smoke testing, and regression testing.
- Collaborated with the development team in validating requirements for out of box requirements.
- Involved in managing the defect lifecycle - conducting daily defect tracking meeting, reporting and reviewing the defects, assigning the open defects to developers, and re-testing the fixed defects.
- Managed Requirement Traceability Matrix to ensure test cases are traceable to requirement specifications.
- Actively facilitated complete UAT process - creating UAT schedules, testing guidelines, managing feedback, follow-up, and resolving open issues.
- Performed complex SQL queries for retrieving data from the database, generating ad-hoc reports, and conducting data validation testing.
- Developed test strategies documentation, and tested various functions within a Claim Management and Billing software application. This application serviced Worker'sCompensationclaims. This was practiced in an Agile Software Development environment.
- Assisted in development of Guidewire training and transition documents for the upgraded version of the existing system technology and process improvements.
- Frequently presided over the BA touchpoint meetings and BA team meetings to listen to open concerns, document them and solution them.
Confidential -Pekin, IL
Business Analyst
Responsibilities:
- Analyzed clients systems and business processes.
- Provide support across different domain areas such as Auto Assignment, Payments, Claims Data and Appointment Logs, Auto Estimations, Fire Claims etc.
- Worked on different modules of Web based application which wasportalfor Agents such as Insurance Application, Declarations, Discounts, ID Cards, and Various Endorsements Form Order Testing etc.
- Analyzed thebusinessrules for Auto claim assignments throughout the US, so as to have balanced work load for all the claims reps.
- Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker's Compensation, Umbrella,BusinessOwners Policy, Commercial Output Policy, and Commercial Property Package.
- Created and maintainedBusinessRequirements document and System Requirements document. In addition, was responsible for getting appropriate sign-offs and approvals.
- Involved in developing front-end production entry screen and batch interfaces between remote AS/400s and the corporate mainframe.
- Responsible for elaborating Billing Center integration user stories such as Integration to Agency.
- Worked as a Personal line of Property and Casualty Expert for interface to InsurerBusinessPartner on all facets of system design.
- Implement and maintain Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
- Analyze the business requirements and translating them into technical requirements and preparation ofDataMappingspecifications.
- Involved in testing the conversion of the application into web application using XML web services.
- Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
- Conducted demo/conference pilot sessions to present both custom and Out of the box Billing Center functionality to business.
- Created process flowcharts for various issues in Billing Center functionality and help perform gap analysis.
- Wrote various SQL queries and statements for data reconciliation for Policy Administration System.
- Created workflow scenarios, designed new process flows and documented theBusinessProcess and variousBusinessScenarios and activities of theBusinessfrom the conceptual to procedural level.
- Working with clients to better understand their needs and present solutions using structured SCRUM approach.
- Using Shared Containers and creating reusable components for local and shared use in the ETL process.
- Established aBusinessAnalysis methodology around the Rational Unified Process.
- Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
- Worked extensively with MS Excel and MS access.
- Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
- Responsible for process modeling from inception through implementation and post implementation optimization along with associated UI design.
- Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
- Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
- Assisted in building aBusinessAnalysis Process Model using Rational Rose and Visio.
- Performed extensive Requirement analysis and developed use cases and workflows.
- Developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD.
- Worked on National workers compensation guidelines.
- Responsible for developing annual and mid-year operating budgets by underwriting departments and on a consolidated basis for review by reinsurance group senior management.
- Documented and delivered Functional Specification Document to the project team.
- Conducted JAD sessions for communicating with Stakeholders and Project directors.
- Developedbusinessrequirement specification documents as well as high-level project plan.
Confidential - Honolulu, HI
Business Analyst
Responsibilities:
- Gathered user and business requirements through interviews, surveys and prototyping. Stored and modified requirements in MS Word.
- Primary responsibility includes writingbusinessrules and creating system requirements by setting up meetings with project managers, architects, developers, testers,business, designers, legal, and other stakeholders. It also includes creating and updating user stories.
- Discuss out of the box (OOTB) features withbusinessand development team. Proposed and implemented minimal changes to save development time and satisfybusinessneeds.
- Worked on coverages and exposures pertaining to dwelling, personal property, other structures, loss of use, content, etc. relating to Homeowners Policy.
- Discussed incident story cards for Homeowners policy like personal property incident, dwelling incident and liability incident.
- Worked inGuidewirepolicy center projects both in integration and configuration.
- Worked on several critical Billing Center modules including but not limited to disbursements, payments, commissions, trouble tickets, payment plans and billing plans.
- Having served onbusinessas well as technology teams, gives me an added advantage of understanding both sides and makes me an excellent liaison.
- Discuss and document any system related issues and resolved any open issues by conducting meetings regularly. Responsibility also included working on change requests.
- Proactively identify inefficiencies in system and proposed changes to increase system accuracy and cost effectiveness.
- Working on understanding "as is" processes and helped to define "to be" processes to streamline the processes and make them more effective.
- Validated web services manually and through automation using SOAP UI (XML).
- Associated with Managing the portfolio forDuckCreekPolicy administration system implementation.
- AuthoredBusinessRequirement Documents that enhanced base functionality ofDuckCreekP&C Policy Administration System.
- Liaison betweenbusinessusers and project team for requirements management for Commercial, Personal,WorkersCompensation, and Specialty insurance; documented "AS-IS" and "TO BE"businessprocess across various line ofbusiness.
- Performed the GAP Analysis and Impact Analysis for allbusinessrequirements having an impact on the existing application.
- Analyzed the different excel spreadsheet raters and prepared analysis documents and data documents to specify the fields and field functionalities for theDuckCreekSystem.
- Worked withDuckCreekversion control tools like TFS (Team Foundation Server).
- Coordinated User Acceptance Testing for all product lines and liase with thebusinesstesters and IT with regards toDuckCreekmonthly maintenance releases.
- ReviewingISOcircularsfor any changes and update needed to existing product.
- PerformedDatamapping, logicaldatamodeling, created class diagrams and ER diagrams and usedSQLqueries to filterdata.
- Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
- Conducted Change Analysis for the improvement of the existing system and recommended the required changes using Rational Clear Case.
- Worked in an agile environment in the billing center team to gather business and system requirements. Elicited requirements from subject matter experts from billing, commercial lines, policy, customer care and legal.
- Analyzed and prioritized user andbusinessrequirements as system requirements that must be included while developing the software.
- Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using Rational Rose.
- Scheduled meetings with developers, systemanalystand testers to collaborate resource allocation and project completion using MS Project.
- Involved in the entire project life cycle (SDLC) from evaluation, installation, configuration and development of end user reports.
- Defined data requirements and elements used in XML transactions.
- Gathered and analyzed thebusinessreporting requirements with the existing Data source and suggested the changes in the data source.
- Created the universes based on the user classes and their hierarchy in the organization at different aggregations.
- Specified the standards for universes, Classes, Aliases, Help text, Simple and complex objects.
- In Info View, implemented customized logins at application level and provided password reset options to the users.
- Created user groups and managed access privileges usingBusinessObjects Supervisor.
- MaintainedBusinessObjects universes.
- Created the Test cases and SQL scripts to verify the results and performed bug tracking using Clear Quest.