We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume

Brea, CA


  • 8+ Years of experience as a Business Systems Analyst in Personal Property Casualty with solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling, Data Analysis, Data Mapping and Business Analysis.
  • Worked on various products like Auto, Renters, Condominium and Homeowners, Specialty insurance including General Liability, Inland Marine and Property.
  • Experience in documentation of online web - portal used for submitting New business Application, Policy change, pay online, submit claims and Express Apps
  • Experience in Guidewire Insurance Suite for Personal and Commercial Autos, Workers Compensation, General Liability, Inland Marine, and Personal Liability.
  • Expert in Insurance Technology solution like Guidewire with in-depth knowledge in the Underwriting, policy administration, billing, rating and claims process.
  • Experience in implementing the Guidewire PolicyCenter, ClaimCenter and BillingCenter for Auto and Property Casualty Insurance.
  • Experience in Guidewire configuration and integration experience with ClaimCenter, PolicyCenter and Billing Center.
  • Involved in developing a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
  • Knowledge of custom based portals integration framework and various integration methods like Web service APIs, Plugins, Messaging code, XML models, templates etc.
  • Extensive understanding & experience of migrating insurance suite solutions to Guidewire solutions.
  • Extensive experience in conducting Feasibility Studies, Data Analyses, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, and Risks Analyses
  • Experience of Migrating Insurance Suite Solutions to Guidewire Solutions & Experienced in Implementing Guidewire PolicyCenter and ClaimCenter Application as Per the Client.
  • Well versed in service-oriented architecture, XML schema design and generation.
  • 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 member
  • Extensive experience in gathering business and application requirements, business processes, identifying risks, impact analysis, UML modeling, Sequence and Activity Diagrams using Rational Rose and Microsoft Visio.
  • Facilitated and managed JAD sessions with committee of SMEs from various business areas including auto insurance, homeowner’s insurance etc.
  • Proficient in creating tailor-made Business Requirement Documents (BRD), Functional Requirement Documents
  • Proficient in Guidewire platform workflow, Claim, Billing, and PolicyCenter.
  • Excellent skills in writing Business Requirement Documents, Functional Requirement Documents, System Design Specification, Workflows and diagramming skills for drawing UML diagrams such as activity diagram, sequence diagram, use case diagram, and class diagrams.
  • Proficient in documenting ETL specification and Data Mapping document.
  • Well versed in SQL queries, OLTP, and OLAP system for Data Mining and Data Profiling.
  • Developed efficient business relationships with various client teams in order to process and support requirements, develop tactical and strategic plans to implement technology solutions, and effectively managed client expectations.
  • Team player and self-starter with excellent communication, coordination, documentation, project planning, and interpersonal skills.
  • Extensive experience in elaborating, developing, and testing various functionalities in GuideWire products Billing enters and Claims enter. Fair understanding of PolicyCenter functionality and experience in elaborating Policy Cancellation and Policy Renewal related user stories
  • Good understanding of Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, and Agile.
  • Strong experience with QA team in developing Test Scripts, Test Cases and Test Plan for User Acceptance testing.


Confidential, Brea, CA

Sr. Business Systems Analyst


  • Gather requirements through workshops and interviews with SMEs
  • Ensure requirements adhere to program guiding principles
  • Preparing interface requirement document for Thunderhead integration with PolicyCenter for Forms inference and Letter creations.
  • Involved in developing portal ACORD XML template requirements for Commercial Auto, Garage, Commercial Property, Commercial General Liability, Commercial Umbrella, BOP, Crime and Personal Auto.
  • Helped in satisfying insurance regulatory requirements by completing various data calls to statistical agents (ISO) and insurance regulators
  • Responsible for writing Functional Requirement Specification (FRS) and User Requirement Specification (URS) and ISO reporting.
  • Effectively ensured all insurers to comply with insurance departments' regulatory requirements and ISO's statistical plans requirements
  • Assisted in building a Business Analysis Process Model using Rational Rose and Visio. Used Castor to create objects from XML documents. Involved in Logical & Physical Data Modeling.
  • Used Altova XML Spy to generate the XSLT by graphical mapping of upstream and downstream system XSD files.
  • Integrated with vendor applications using web services and XML to send data files.
  • Conducted functional and technical requirement gathering sessions for BRD and FSD docs with Stakeholders, Underwriting Managers and Operations Analysts for the Policy, and Claims related modules.
  • Identified system requirement for Thunderhead document management tool (for document integration with Guidewire System.
  • Analyze and determine the ACORD, ISO or Proprietary form requirements applicable for the insurance product being implemented and help in creation of the product backlog
  • Work with the product team to document the inference rules for the forms scoped.
  • Work along with the PolicyCenter and Integration teams. Attend walk through and review UI story cards and use cases to understand the process and data flows and determine the impact to forms
  • Writing Guidewire forms inference rules and patterns and review the requirements with Product, Compliance and Legal team
  • Involves in planning and implementing both high-level and detailed system and integration test plans
  • Perform overall Requirements Management and built the Requirements Traceability Matrix.
  • Facilitate customer meetings and Business design walkthroughs data definition and GUI design.
  • Created use cases diagram for better understanding for developer and tester.
  • Working on production and pre-production defects analysis and fixation with testing and development teams.
  • Create Software Requirements Specifications, use cases, and wireframes for Guidewire
  • Used Agile SDLC to ensure new business processes and system changes are documented, developed, tested, and promoted successfully
  • Worked closely with development and Testing Team to iteratively implement and deliver functional modules throughout the duration of the project.
  • Working with the Project Manager on various Project Management activities like keeping track of Project Status, Deadlines, Environment Request, and Compliance Issues
  • Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Business Process Management (BPM)
  • Documented and reviewed business process changes throughout the organization with Functional leads
  • Responsible for assisting in testing of web releases on an as needed basis when requested.
  • Executed and wrote SQL statements to make sure the successful transaction of data from front-end to back-end database.
  • Analyze and test forms to evaluate areas for improvement, testing failures, and to improve customer ease of reading and use.
  • Support UAT (User Acceptance Testing) sessions
  • Performed data integrity testing by extensive use of SQL queries and executed
  • Performed Data mapping, Business Unit mapping, and verified data structure by using SQL queries.
  • Used Test Director, PL/SQL for testing the application
  • Worked with the Application Delivery team to ensure Test Use Cases are current and correct for existing and new processes

Confidential, Chicago, IL

Business Systems Analyst


  • Created functional related deliverables and/or work products as assigned for Guidewire-PolicyCenter functionalities: New Policy Submissions and Policy Changes for Auto and Property. This includes a focus on gathering relevant data, understanding issues and problem identification, use case development & data modeling, issue ownership and tracking to resolution.
  • Gather business requirements and break them down into relevant accurate and detailed functional requirements and user stories.
  • Organizing the project inception and brainstorming session between all the project stakeholders in starting of the project.
  • Creating features based on project inception output and dividing into the User story.
  • Facilitating the scrum ceremony (sprint planning, daily stand-up, sprint review, sprint retrospective, and backlog grooming) in team
  • Analyzed the XML feeds using XML Spy to determine universe of data.
  • Used XML Spy for Data Mapping and Data Modeling for large scale System Integration with Partner Applications.
  • Involved in designing the user story and adding wireframes and acceptance criteria in it.
  • Working with product owner (PO) for user story priority and reprioritize based on PO decision.
  • Working with developer and tester for the three-way handshake of user story before and after completing the user story making sure all are in the same page for business requirements
  • 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
  • Interact with the Guidewire team to modify the Out of the Box logic based on Mercury's business needs
  • Participate in the development of Guidewire Billing Center, Billing Center - PolicyCenter User Stories
  • Participated in backlog grooming sessions to identify user stories for future sprints. Analyzed the backlog in order to place all user stories in most effective and accurate sequence
  • Followed SDLC in RUP environment to work on the Policy Admin System, and Business to Business (B2B) system
  • Interacting with Business Users, Hyland Software Inc. (the developer of the enterprise content management (ECM) and process management software suite called OnBase) and SME's on configuration/Integration work flows to create story cards (new).
  • Prioritized the Back Log in JIRA, involved in Planning Sessions and maintained User Stories and Acceptance Criteria
  • Worked on JIRA for continues update with project schedules, quality, issues and managing resources.
  • Worked closely with developers and testers to elicit, translate requirements using user stories.
  • Prepared Application FRD / User stories / BRD / Reports / Presentations for the project.
  • Conduct demo/conference pilot sessions to present both custom and Out of the box Billing Center functionality to business
  • Create process flowcharts for various issues in Billing Center functionality and help perform gap analysis
  • Conduct Agile Scrum Meetings to review the day to day progress when Scrum Master is out of office
  • Worked with the Billing Representatives team on various customizations on the Billing Screen
  • Participate in requirement walkthroughs with the Dev and QA teams with the aim to develop testing strategies and test plans such that test cases reflect user needs
  • Extensive use of SQL to perform data integrity testing.
  • Tested the database at the backend with various SQL.
  • Assist the QA team by reviewing test cases and clarifying requirements to ensure complete coverage of requirements
  • Execute smoke testing and review results to ensure the major functionality is working as per the requirements

Confidential, Columbus, OH

Business Systems Analyst


  • Established a RUP (Rational Unified Process) centric business analysis methodology.
  • Elicited requirements for various Claims Integrations with PolicyCenter and BillingCenter on activities like Policy and Billing Status retrieval, Checks Issued and Void Processes for Claims etc.
  • Working on various components in Policy Admin such as Rating and Forms.
  • Analyse and determine the ACORD, ISO or Proprietary form requirements applicable for the insurance product being implemented and help in creation of the product backlog
  • Helped in satisfying insurance regulatory requirements by completing various data calls to statistical agents (ISO) and insurance regulators
  • Responsible for writing Functional Requirement Specification (FRS) and User Requirement Specification (URS) and ISO reporting.
  • Effectively ensured all insurers to comply with insurance departments' regulatory requirements and ISO's statistical plans requirements
  • Work along with the PolicyCenter and Integration teams. Attend walk through and review UI story cards and use cases to understand the process and data flows and determine the impact to forms
  • Writing Guidewire forms inference rules and patterns and review the requirements with Product, Compliance and Legal team
  • Interacted with Guidewire team and providing requirements for Forms data based on out of box feature of Guidewire.
  • Involved on requirement gathering for New rate Filling, Forms & Legal Notices, OIR Checklist etc of legacy system
  • Worked on implementing features such as BOP-Quote application, Forms, Policy change, Product model, client contacts, and policy cancellation.
  • Worked with Underwriters, Product Development Business Units to determine the rating requirements for accurate premium calculations.
  • Documented Business requirements in Business Requirements document (BRD) for Property & Casualty - Personal and Commercial insurance lines: Workers’ compensation, Homeowners, General Liability.
  • Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
  • Used MS SharePoint for the purpose of managing documents and for hosting websites which were used to access shared work spaces and documents.
  • Used GuideWire to upgrade the current Claim system to track the claim of the policyholders and third-party applications
  • Used Rational Clear Quest to track Project Status, monitor workload and detect issues for Prototyping Guidewire applications as per the requirements.
  • Involved with the testing team to check the augmentations done previously using Guidewire
  • Worked in a fast-paced atmosphere SCRUM and studied business processes, legacy application, and the corresponding Guidewire functionality and conducted requirements sessions.
  • Also responsible for managing communication and expectations of system vendor, the former parent company IT and business departments, and Allied Worlds various business units (underwriting, claims, reinsurance, actuary, accounting, and IT)
  • Created User Stories, Test Cases utilizing Target Process Agile methodology tool
  • Performed extensive Data mapping between source files and target fields in the backend database.
  • Used Agile SDLC to ensure new business processes and system changes are documented, developed, tested, and promoted successfully
  • Performed data analysis and data mapping between legacy systems and new system to output spread sheets identifying needed set of elements for target application. Validated the data mapping in the new system using SQL queries in TOAD
  • Helped design scope documents and the Request for Proposal (RFP) after extensive ROI analysis and coordinated with top management for the approval process.
  • Worked extensively with MS Excel
  • Submitted defects and monitored the reviews using JIRA as well as report usability issues and recommendations.
  • Have worked with OnTime, Track Record, JIRA, Quality Center to create Test cases and Report bugs.
  • Assisted in presenting reports and analysis to help guide the management.

Confidential, Catonsville, MD

Business Systems Analyst


  • Developed business requirements documenting workflow and process, for migration of worker's compensation claims to Guidewire platform.
  • Responsible for elaborating BillingCenter 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.
  • Worked with SCRUM Master, Business Owners, Project Sponsor, SME and Guidewire Consultants to define Product Backlog, Sprint Backlog, estimate efforts for user stories.
  • Documented IT report template to track the number of documents ingested through Guidewire and Non- Guidewire ingestion sources based on the application in terms of weekly monthly and yearly Report formats.
  • Created the workflow for Delinquency Process in BillingCenter, assignment/Trouble ticket assignment in BillingCenter.
  • Provided guidance for project team to transition from Waterfall to Agile for software development engineering projects.
  • Customized Charge Invoicing process in BillingCenter and update Renewal Process in PolicyCenter. Provide officially update logic in PolicyCenter.
  • Conducted walkthrough of BRD in the JAD Sessions with users and developers and collected specific information to include in the Functional Requirements Document FRD.
  • Implemented third party encryption system in both Billing and PolicyCenter also Mainly responsible for working in migration from legacy system to Guidewire system.
  • Performed data integration and data mapping and data extraction management along with data cleansing while migrating data from legacy system to Guidewire PolicyCenter with Guidewire Data Hub.
  • Worked on Guidewire in PolicyCenter and BillingCenter Screens for Personal lines business Defined the page layouts, reports templates and dashboard layouts for reservation monitoring and for gathering usage statistics.
  • 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.
  • Worked as a Business Analyst for Guidewire PolicyCenter Implementation and integration of PolicyCenter with legacy systems, document output management systems.
  • 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 all Software Development Life Cycle (SDLC) Phases such as Requirement gathering, analysis, Design, Development, Testing and Deployment.
  • Responsible for rating multi-line policies. Manual rated Property, Liability, Auto and Workers Compensation policies. Conducted training classes for Auto and Workers compensation rating.

Confidential, Madison, WI

Business Analyst


  • Gathered user and business requirements through surveys, prototyping and observing from portfolio managers and UI (User Interface)
  • Responsible for Data Manipulation and Data Validation using SQL queries in a MS SQL Server environment. Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance knowledge of Personal and Commercial Auto including risk, Policy Sales, Policy Administration and Rating
  • Involved in designing and working on successfully developing web applications that allow independent sales agents and underwriters for quoting, rating, processing and tracking applications
  • Work closely between Ex stream Dialogue Developers, Data Managers, and Project Managers to ensure timely changes are met
  • Stored and modified requirements in MS - Word and using Test Director
  • Involved in Inception Phase and prepared Logical Data Models that contains set of diagrams and BRD (Business Requirement Documents) supporting documents containing the essential business elements, detail definitions, and descriptions of the relationships between the actors to analyse and document business data requirements.
  • Participated in full responsibility of maintaining and filing the company reinsurance claims and providing a financial report to the management team
  • Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
  • Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio
  • Used SQL for Data manipulation and data analysis
  • Suggested measures and recommendations to improve the current application performance
  • Performed Business Process Mapping and performed AS-IS and TO BE analysis
  • Modified System flow diagrams using SDLC
  • Involved in creating Mock-up forms in MS Access for better visualization and understanding of the software solution.
  • Involved in developing strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing)

Hire Now