Business Analyst Resume
Appleton, WI
SUMMARY:
- Over 7+ years of IT and Management experience in Software Development Life Cycle (SDLC) and Project Life Cycle working as Business Analyst mainly in Property and Causality domain.
- Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems, Health Insurance, Auto Insurance Home Owner Insurance and Crop Insurance.
- Worked in a software development IT shop, created quality documentations such as Requirements Documents, Design Document, Test Plan and User Acceptance Test Plans. Self - starter with excellent time management skills
- Writing Use cases and producing Use Case Model, Analysis model, Behaviour diagrams (Sequence diagrams, Collaboration diagrams) and Class diagrams based on UML Methodology & Business process flow diagrams using Visio
- Hands on experience of Data manipulation, performance testing on My SQL and MS Access using SQL scripts.
- Strong knowledge of the Systems Development Life Cycle (SDLC) models such as Water Fall, Agile and RUP.
- Extensive experience in the field of Business Analysis, Data Warehouse, Business Modelling, Documents Processing, Process Re-engineering and Decision Support Systems.
- Experience in testing applications for Commercial Lines Insurance such as Ocean Marine, Other Liability, Commercial Automobile, General Liability and Commercial Property.
- Extensive experience in implementing QA Methodologies, Test Procedures, Test Plans, Test Cases, Scenarios and Test Deliverables.
TECHNICAL SKILLS:
Project Methodologies: Agile, Waterfall, UML, RAD
Business Modelling Tools: Rational Rose, MS Visio
Bug Reporting Tools: Rational ClearQuest, Quality Center, TestDirector
Requirement Management Tools: Rational RequisitePro
Defect Tracking Tools: Rational ClearQuest, TestDirector
Operating Systems: Windows NT/XP/2000, UNIX
Quality Assurance: Software Application Testing Life Cycle
Business Applications: MS Project, Microsoft Office Suite, MS Outlook
PROFESSIONAL EXPERIENCE:
Confidential
Business Analyst
Responsibilities:
- Design and develop the data load process using XML Style sheets and ACORD.
- Responsible for elaborating Billing Centre configuration user story such as Invoicing rules, Delinquencies, Policy Cancellation, Automated disbursements, Policy Rewrites, Policy Reinstatements, Billing Parameters, Fees, and Payment distribution rules, etc.
- Worked on Guidewire Policy Centre for Policy creation and maintenance using different Policy Transactions for Auto and Property (including Homeowners).
- Utilize the guidelines and artefacts of the Agile Methodology to develop a detailed implementation process Guidewire PolicyCenter Integration during different iterations and phases in Software Development Life Cycle (SDLC).
- Worked with developers in writing of complex SQL queries to resolve data issues in source system databases.
- Analyze and clarify business needs to create user stories in JIRA for agile sprint team developers.
- Develop source-to-target mapping documents by analyzing data content and physical data structures in the legacy and downstream applications. Develop mappings to enable data migration, application integration.
- Involved with the technical team in understanding the XML file format required for Split loss process and Billing process.
- Utilized Confidential developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
- Worked on Guidewire PolicyCenter with the Personal line, Test Definition workshop, Test Strategy, Test Planning using Insurance Test Framework for Guidewire.
- Created test plans and test cases for implementation testing of Guidewire PolicyCenter. Insurance program opportunities for reinsurance partners.
- Establish documentation for agile methodology for implementation with a very water-fall-centric development team.
- Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
Confidential, Appleton, WI
Business Analyst
Responsibilities:
- Worked on an end-to-end project which dealt with the enhancement and maintenance of the existing internal electronic enrolment platform and Policy System for providing better services to the customers. The new Policy centre implemented for the company had the purpose to migrate its legacy policy data to the policy centre module of Guidewire Insurance Suite.
- Worked extensively on the issue module of Homeowner, Dwelling Fire, Umbrella and Auto insurance by gathering requirements from the business underwriting department.
- Interacted with Product Owner & Agile Development Team on documenting Scrum artefacts like Product, Release & Sprint Backlog.
- Hands on experience with Guidewire PolicyCenter and ClaimCenter (Worker's Compensation Claims, General Claims) up gradation to v9.
- Experienced in Project Management Methodologies and Software Development Lifecycle (SDLC), CRM and Business Requirement and System Specifications Analysis.
- Generated business requirement documents, functional requirement documents and data mapping documentation.
- Performed migration from the in-house legacy based underwriting, policy centre, claims centre and billing centre applications to Guidewire
- Generated automated scripts for Guidewire Quick Quote, Application and Policy Binding Processes.
- Frequently used Requirements Traceability Matrix (RTM) for identifying and tracing the linkages among PolicyCenter and ClaimCenter.
- Uphold the principles of agile/scrum within the technical development team to maximize business value.
- Implemented ACORD standards to eliminate transfer of paper between medical vendor and the underwriting department.
- Involved in systems build preparation, SQL query optimization, peer reviews and preparation of test cases and unit testing.
- Captured User stories using guidewire template; few major stories worked on included Commercial Auto, Worker's Compensation, Business Owners Policy and Commercial Property Package.
- Generated data mapping documents from production databases to the warehouse and from the warehouse to the policy and claims marts.
- Organized and facilitated Agile and Scrum meetings, which included Sprint planning, Daily Scrums or stand-ups, Sprint Review and Sprint Retrospective.
Confidential, Boston, Massachuset
Business Analyst
Responsibilities:
- Executed all aspects related to employee health insurance, worker's compensation, life insurance, long/short term disability, employee discount/store benefits including company events coordination.
- Ensure comprehensive defect tracking and issue resolution using JIRA and Quality Center
- Performed routine checks on Property and casualty loan litigation and negotiation processing activities as well as received reports from team members on selected Policy applications.
- Worked on Regulatory Reporting RRD Data Warehouse for compiling Workers Compensation statistical reports to external regulators and states.
- Performed Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data
- Worked extensively on the issue module of Homeowner, Dwelling Fire, Umbrella and Auto insurance by gathering requirements from the business underwriting department.
- Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business. integration requirements
- Electronically and manually relate dwelling fire, umbrella, boat owners, inland marine and mobile home polices as requested.
- Used Customer Relationship Management (CRM) in order to meet customer expectation.
- Involved with the technical team in understanding the XML file format required for Split loss process and Billing process.
- Created defect tracking using HP QC and JIRA and reviewed them in subsequent iterations of the application development process.
Confidential, Hartford, CT
Business Analyst
Responsibilities:
- Performed the role of a primary Intermediary between the Subject Matter Experts, business user and technical SME's to identify the business needs, Business Rules, Business Processes & Interface Specifications for the New Policy module and Billing Assignment Module.
- Translated high level requirements into functional and technical user stories in JIRA.
- Facilitate meetings with the Guide wire Team elaborate numerous Billing Centre OOB functionalities such as Close Policy Date, Trouble tickets and Holds, Payment Requests, etc.
- Involve in analyzing defects that have been reported in the JIRA and sending them over to the developers for a fix.
- Hands-on experience with Guidewire PolicyCenter and ClaimCenter configuration.
- Speaking customers with inquiries and changes to homeowners and automobile insurance policies via telephone or written correspondence.
- Worked with Guidewire developers and prod support team to understand various functionalities in Guidewire Policy and Billing Centre.
- Developed Data Flow Diagrams and Data mapping agreement, illustrating the flow of data from the front end Guidewire Claim Centre into the Application database Tables.
- Analyzed the business rules for Auto claim assignments throughout the US, so as to have balanced work load for all the claims reps. The Guidewire Claim centre application uses Java to write data from Claim Centre to Staging Tables as part of Distributed Team
- Coached team members on how to effectively use Kanaban and Scaled Agile Framework values as a guide.
- Identified the organizational needs and provided suitable Agile system based solutions.
- Coordinated re-architect ring the existing VBA/Access system into ASP.net environment and existing table structure, stored procedures, and functions in MS SQL environment.
- Write and execute positive and negative test cases to ensure the data originating from the data warehouse Oracle dB is accurate through to the SQL dB in the applications.
- Document all data mapping and transformation processes in the Functional Design documents based on the business requirements