SUMMARY

• More than 8 Years of experience as a Business Analyst (P&C) with solid understanding of Business Requirements Gathering, Business Process Mapping, Evaluating Data Sources, Translating Requirements into Specifications.
• Proficient Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems.
• Hands on Experience working on Guidewire Claim Center, Policy Center and Billing Center.
• Experience working on Guidewire Policy Center Integrations and Configuration User Stories.
• Proven Insurance business knowledge with project experience in various LOB's such as Personal (Auto, Dwelling, Home owner) and Commercial (Commercial Auto, Workers Compensation, Commercial Property, General Liability, Business Owners Policy (BOP).
• Deep knowledge & understanding of Policy Admin system and related operations like New Business, Endorsements, Billing and Claims in property and casualty - Personal Lines.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Proficient in Technical and Business Writing, Business Process Flow, Business Analysis and Testing various methodologies.
• Efficient in Designing and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Extensive experience in gathering requirements through Joint Application Development (JAD) sessions, Group Interviews and functional requirements in the Property and Casualty Insurance including Risk, Policy Sales, Policy Administration System, Receivables and Payments, across personal and commercial lines of business.
• Efficient in documenting customization requirements, business rules and data migration requirements for the Implementation of Guidewire Claim Center and Policy Center.
• Experience in creating functional design document for User Interface, Insurance Forms and Underwriting Rules.
• Excellent Communications & Analytical skills to understand various Business Models, Processes, and Requirements & transform them to various Requirements Artifacts like Business Requirements Document (BRDs), Functional Specification/Requirements Documents GUI Prototypes, Flow Diagrams (UML), and Report Mockups.
• High Experience in Gap analysis to compare As Is with To Be business processes and offered solutions.
• Experience in Insurance suite product(s) like Guidewire and with other proprietary insurance applications.
• Phenomenal in managing requirements discovery sessions with SMEs from various business areas including Policy Quote, and Policy Administration for Commercial, Personal, Workers Compensation, and Specialty insurance.
• Master on 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.
• Great expertise in writing SQL queries in MS SQL Server.
• Skilled in SQL Server Reporting Service (SSRS), Executing Queries and Running Stored Procedures.
• Skillful in extracting UI based information by querying the Oracle database using SQL queries.
• Experienced Microsoft Office Suite including Excel, PowerPoint, Word and Outlook, and other various claims systems such as Confidential Document Manager (DM) and Claim Center.
• Worked with defect tracking tools like JIRA, and Quality Center.
• Strong Experience in using different requirement management and testing tools including Confidential Rational Requisite Pro, JIRA, HPALM/QC.
• Proficient in business process modeling, documentation, and testing using Rational Suite (Rational Rose, RequisitePro, SoDA, ClearQuest, Robot) as well as MS Visio and MS Project in combination with UML diagramming techniques.
• Highly Capable 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.
• Capable of testing & implementing systems and system changes including liaising with QA teams to develop test cases, test plans, test scenarios, and generating test data; and conducting manual testing.
• Professional in Facilitating Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project follow the Business Requirements.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.

PROFESSIONAL EXPERIENCE

Confidential, Flint, MI

Sr. Business Analyst

Responsibilities:

• Analyzed Business needs and objectives to improve Property & Casualty products, contracts and processes.
• Collaborated with the business team in the creation/completion of project charters and project scope for Guidewire Policy and Billing Center.
• Involved in the project to enhance/replace the existing policy system including: product definition, quoting, binding, endorsements, and renewals.
• Collaborated with stakeholders in defining and developing billing center requirements for property and casualty products, disbursements, invoices, transactions, billing plans, delinquencies, and common documents.
• Conducted requirements workshops with product owner, scrum master, lead developer, subject matter expert, billing supervisor, policy supervisor, underwriters, admin specialist, Guidewire consultant and implementation partners.
• Worked with SCRUM Master, Business Owners, Project Sponsor, SME and Guidewire Consultants to define Product Backlog, Sprint Backlog, and estimate efforts for user stories.
• Obtained knowledge and wrote specifications for configuring business rules and functionalities in Guidewire.
• Interacted with Business as the Project Manager or Lead of BI reporting for the projects in BI scope
• Wrote specifications for tasks, activities, and Guidewire Contact Center.
• Designing and customizing data models for Data warehouse supporting data from multiple sources.
• Worked in accordance with the Agile/Scrum methodology for various phases of the business and created business vision, business architecture documents and mock reports.
• Integrated Claim Center documents management system with Thunderhead for easy access of documents.
• Involved in Configuration of Thunder Head to design templates for all different letters and establish security systems to the electronic documents so that clients can generate documents.
• Delivered best-in-class capabilities in Thunderhead for commercial policy life cycle using Electronic Document Management especially in forms management.
• Kept track of all requested services until completion in order to star the Billing Process in excellence.
• Implemented the rules for Payment Acceptability, Payment Request, Billing Instructions, Policy Period, Suspense Payment and Disbursements.
• Identified "As is" process and "To be" process as parts of gap analysis for legacy to current policy center.
• Prioritized the Guidewire policy center requirements based on actual business needs so as to align them with the project roadmap.
• Implemented Plugins to, generate Policy/Account Number in Policy Center, retrieve document template list and to generate Adhoc documents using Thunderhead, validate address in Policy Center, upload/search/view documents, send email notifications and connect to integration database.
• Gathered requirements in excel based templates for configuration for rating, underwriting, claims and billing configuration.
• Worked with stakeholders, subject matter experts, process owners and users to elicit and document needs, expectations, constraints and external interfaces using various methods.
• Captured business requirements in the form of user stories using JAD sessions, brain storming sessions, focus groups and personal interviews and ensured coverage on business values, story points and acceptance criteria.
• Identified inconsistencies and gaps within a business process description and collaborated with stakeholders to clarify and simplify complex processes.
• Followed the Agile (SCRUM) methodology throughout the project. Analyzed all the functional and technical requirements and put it together in Rational Requisite Pro to convert them into Requirements Document
• Successfully completed data mapping and workflow analysis for underwriting and claims.
• Conducted workshops with regional unit heads managing the various processes of underwriting, claims and billing.
• Interacted with Business Teams to understand what needs to be visualized.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Developed Systems Specifications document to define the impact of the new requirements on the existing system.
• Worked extensively with MS Excel and MS access.
• Involved in Performance Measurement to develop measurable indicators that can be systematically tracked to assess progress made in achieving predetermined goals.
• Set up definitions and process for Scoping, document test cases, test phases included integration testing, end to end testing and user acceptance test (UAT) and documenting the results.
• Facilitated the Post Production Validation and actively participated in production call support whenever necessary and ensure smooth running of the system in real time.
• Involved in Analyzing, manipulating and updating Database using SQL.
• Extracting data by accessing Mainframe systems to make sure Oracle Ins bridge rating premiums values are same as Mainframe.
• Utilized JIRA to communicate constantly changing functional and design requirements with business users and developers.
• Created test scripts for all the test cases in PL/SQL.
• Involved in creating test plans and testing with the QA team. Executed system test cases in collaboration with test team and used QC to assign defects and keep track of the defects.
• Collaborated with QA team on test cases, test plans and defects and requirements clarifications.
• Clarified QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested properly.
• Coordinated User Acceptance Testing - provided guidance for system behavior, identified testing scenarios, reviewing test scripts and objectives, creating UAT plans, presenting and reviewing the results with business teams.
• Created guides, assisted in deployment with step-by-step instructions and created appropriate GUI screenshots.

Confidential, Wooster, OH

Business Analyst

Responsibilities:

• Created several documents and gathered requirements from the responsible Stakeholders and SME's.
• Worked on the Billing Integration which included writing the business requirements for integrating the existing Billing system 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/Business process End to End user stories for Policy center (Policy Administration system) and Billing center (Account receivable and commission system).
• Worked on New Business, Policy change, Reinstatement, PC to CC integration, New Business DEC package, Policy

  Documents, Policy Hold and Suspense Payment in Billing Center.

• 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 for business process 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 the business needs.
• Participated in writing Business Required Document (BRD) as well as write supporting document containing essential business elements, detailed definition and description of the relationship between the actors.
• Worked on Guidewire's UI testing in Policy Center and Billing Center Screens for commercial lines business.
• Involved in doing the smoke test for Policy Center, Billing Center, 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 Data analyst in 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, Columbus, OH

Business Analyst

Responsibilities:

• Elicited, documented and created requirements for projects, new features, enhancements and defects.
• Maintained and updated the Data Dictionaries and Data Models for all of the Data Warehouses and Reporting Layers.
• Performed Root Cause Analysis on issues found in production, tracking the data flow to identify where the issue is occurring.
• Documented changes needed to vendor system to convert legacy internal billing data into the vendor system.
• Worked with Billing Center data panels, location groups, workflow activities and contact configuration.
• Worked in an agile environment in the billing center team to gather business and system requirements.
• Performed system analysis on Guidewire Billing Center based on each user story and presented results to SME's.
• Analyzed information garnered within billing cycle and provided billing related information to project stakeholders though reports and other communications.
• Conducted Gap Analysis to gather the requirements, by comparing existing Legacy billing center and Guidewire Billing center.
• Involved extensively in the inception phase for understanding the Scope of the Project, feasibility of the implementation and define the risk factors involved in the project.
• Participate in meeting with system administrators, project managers and technical teams for requirements gathering, analysis, process augmentation and resolving issues.
• Organized requirement gathering sessions and walkthroughs with development teams, testing teams and business stakeholders to review Functional, Technical and Business Requirements.
• Created Procedure Announcements, Release Notes and Bulletins, which were distributed company wide and updated the end-users on changes implemented.
• Worked with offshore and onsite programmers/testers to ensure project expectations, scope and requirements were understood. Also tracking and documenting their deliverables, timelines and status.
• Followed the RUP based methods by using Visio to create UML Diagrams such as Use Case, Activity and Swimlane Diagrams.
• Conduct FRD (Functional Requirements Document) walkthroughs to Product team, Development team and QA team and obtain FRD sign-off. In corporate FRD feedback provided by various stakeholders.
• Completed Unit Testing as well as verification of the XML.
• Closely worked with SMEs and Identified, researched, analyzed, and defined key issues of the Business flow of current underwriting system.
• Involved in the implementation of IT systems, application integration and Electronic content management tools such as SharePoint and Documentum.
• Worked on Documentum for Version Controlling to maintain up to date changes in the Electronic documents.
• Implemented Batch Processes to generate Policy Forms using Documentum in both Policy Center and electronically generated documents in Billing Center.
• Wrote Business Cases for the Stakeholders to understand the functioning of the new Underwriting System.
• Performed Gap Analysis, conducted walkthroughs and acted as a liaison between the business users, Customer's and the team to perform requirements, quality and risk analysis.
• Developed QA Test Plan, test conditions and test cases, as well as assisted with QA team in System.
• Testing using HP Mercury Quality center.
• Worked on the As Is system and develop the To Be system concept and also prepare the System Process Maps.
• Reviewed Test Plan and Test Cases of Guidewire billing center provided by Testing Team.
• Conducted Gap Analysis, and Gathered User Requirements by Interviews, user meeting, JAD session, and Requirement Elicitation Sessions.
• Created Use Cases, Use Case diagrams for process flows and documented the same in the Functional Requirements Document (FRD).
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Collected and documented business processes as well as Business Rules and then translate to the Business Flow Chart
• Created User Stories to effectively communicate functional requirements with business leaders and executives.
• Coordinated User Acceptance Testing - provided guidance for system behavior, identified testing scenarios, reviewing test scripts and objectives. Creating UAT plans, presenting and reviewing the results with business teams.

Confidential, Des Moines, IA

Business Analyst

Responsibilities:

• 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.
• Frequently presided over the BA touch point meetings and BA team meetings to listen to open concerns, document them and solution them.
• 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.
• Worked with Business Owners, Project Sponsor, SME and Guidewire Consultants to define Product Backlog, Sprint Backlog, and estimate efforts for user stories.
• Integrated Claim Center documents management system with Thunderhead for easy access of documents.
• Involved in Configuration of Thunderhead to design templates for all different letters and establish security systems to the electronic documents so that clients can generate documents.
• Delivered best-in-class capabilities in Thunderhead for commercial policy life cycle using Electronic Document Management especially in forms management.
• Kept track of all requested services until completion in order to star the Billing Process in excellence.
• Implemented the rules for Payment Acceptability, Payment Request, Billing Instructions, Policy Period, Suspense Payment and Disbursements.
• Identified As is process and to be process as parts of gap analysis for legacy policy center to current policy center.
• Conducted gap analysis and made As-is-to-be diagrams to understand new business requirements and challenges in implementing new modules of Billing Center and Claim center over the existing billing and claim management systems.
• Worked with requirements management, workflow analysis, source data analysis, data mapping, Metadata management, data quality, testing strategy and maintenance of the model.
• Collaborated with the development team in validating requirements for out of box requirements.
• Documented both out of box and customized requirements.
• Worked on reporting and estimates for Property & Casualty (P&C) on Guidewire Claim Center 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.
• Worked on the development of Tableau Dashboard reports for Key Performance Indicators for the top management.
• Created Prototypes for webpages using iRise Visualization tools.
• Created various Reports and Dashboard with Tableau and Power BI to gain and gather insights.
• Assisted in development of Guidewire and transition documents for the upgraded version of the existing system technology and process improvements.
• Performed complex SQL queries for retrieving data from the database, generating ad-hoc reports, and conducting data validation testing.
• 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.
• 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.

Confidential, Fairfield, OH

Business Analyst

Responsibilities:

• Assisted in requirements elicitation including interviews and meetings with Business stakeholders and established requirement specification.
• Bugs were tracked and problems were reported using JIRA.
• Planned documents used in Guidewire production that promoted the end-to-end phase of end-to-end subscription and policy administration.
• Supported the team in evaluating whether and how new systems could enhance the flow of processes and the functioning of business.
• Then Data Warehouse was built with extensions around the Accord Messaging Standard where possible (Workers Compensation, Commercial and Personal Lines Auto).
• Manage current customer loyalty, peer-level customer relationships and provide the customer with day-to-day project communication.
• Implement and manage assigned customers' rating systems for Property Insurance (e.g. bug-fix, data integration, version release).
• Using Rational Rose and MS Visio, the system flow diagrams for the application were created, including operation diagrams, data flow diagrams and use case diagrams.
• Integration testing, system testing, regression testing and performance testing of the Guidewire application by Billing Center, Policy Center and Payment Manager based on business requirements
• The Test Scripts and User materials were prepared and registered.
• Checked reported defects and assessment of the type of defects (missed requirement vs. Enhancement requirement).
• The BRD (Business Requirement Document) was created and insurance policies were written.
• The high-level Functional Requirement Document was developed and observed in business instruments such as Business Objects.
• Examination of requirements with market analysts and attending model meetings with Agile/Scrum to review the requirements and scope.