SUMMARY

• 8+ years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering in Confidential insurance domain, Business Process Mapping, Evaluating Data Sources, Translating Requirements into Specifications and Application Design in Insurance domain, Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems.
• Good Knowledge on Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Proficient in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project follow the Business Requirements
• Experience in testing implemented 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.
• Experience 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.
• Experience working on Project Management tools (MS Project, Rally).
• Experience in Re - Insurance claims/Policy, banking applications, Personal Auto Insurance claims, Workers Compensation Insurance claims, General Liability claims, Property Claims.
• Extensive knowledge of Policy Admin system and related operations like New Business, Endorsements, Billing and Claims in property and casualty - Personal Lines.
• Strong knowledge of Property and Casualty terminology and extensive experience working on Insurance projects.
• 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.
• Well versed knowledge in SQL queries, OLTP, and OLAP system for Data Mining and Data Profiling.
• Expertise in UML (Context diagrams, Use Case Diagrams, State diagrams, Sequence diagrams, activity diagrams) as a business analysis methodology for application functionality designs using IBM’s Rational Rose.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Proficient working with multiple Agile and Scrum teams in continuous delivery approaches and best practices, and supporting scaled agility guiding Scrum, Kanban teams.
• Excellent in developing Use cases, User Stories and Conceptual Data Models.
• Extensive experience in conducting Data Analyses, Data Mapping, Data Profiling, Gap Analysis
• Having strong knowledge of 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.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various complex data driven methodologies including rendering the ACORD Forms for commercial lines integration with Documentation.
• 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.
• Experience in various Insurance Policy Administration Systems (PAS).
• Strong Experience in managing requirements discovery sessions with SMEs from various business areas including Policy Quote, Policy Issuance, and Policy Administration for Commercial, Personal, Workers Compensation, and Specialty insurance.
• Experience working on Guidewire Claim Center, Policy Center and Billing Center. Experience working on Guidewire Policy Center as well Duck Creek Integrations and Configuration User Stories.
• Good 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).
• Extensive understanding & experience of migrating insurance suite solutions to Guidewire, Duck Creek solutions.
• Excellent in Working closely with production underwriters to review commercial property insurance renewal and new business opportunities to ensure proper risk identification, analysis and assessment and the development and growth of a profitable portfolio of business.
• Hands on experience in versions of Guidewire Claim Center and Billing Center.
• Expertise on thorough elaboration of change request story cards for both GuideWire Policy Center and GuideWire Portal (GPA) on Commercial Auto and Workers Compensation LOB's.
• Proficient with defect tracking tools like JIRA, and Quality Center.
• Deep understanding of DevOps and SRE practices.
• Experience in developing business user friendly workflow designers and orchestrators, preferably based on BPMN standard and open source
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Hands on experience in Working extensively on Data hub and Info center of the Guidewire portal.
• Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Store Procedures.
• Experienced Microsoft Office Suite including Excel, PowerPoint, Word and Outlook, and other various claims systems such as IBM Document Manager (DM) and Claim Center.
• In-depth knowledge of conducting User Acceptance Test (UAT), data quality checks using SQL, gap analysis and Requirement Traceability.
• Extensive Experience in Gap analysis to compare As Is with To Be business processes and offered solutions.
• Major experience in Insurance suite product(s) like Guidewire, Duck Creek and with other proprietary insurance applications.

PROFESSIONAL EXPERIENCE

Confidential, El Paso, TX

Sr. Business Analyst

Responsibilities:

• 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.
• 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, and Guidewire consultants to document functional requirements using user stories for the new billing and claims module.
• Worked on Data mapping, logical data modeling used SQL queries to filter data within database tables.
• Strong understanding of rating in Property and Casualty, worked on business and functional requirements to identify potential enhancements to AWD and develop requirements/specifications for testing AWD implementation.
• Worked on Property and Casualty insurance company as an Underwriter. Strong understanding of rating in Property and Causality.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Provided daily support to Scrum and Kanban teams in the areas of functional and non-functional requirements gathering and analysis, clarifying requirements and issues to remove any ambiguity, establishing documentation for integrated applications
• Involved in coaching application developers on proper DevOps techniques for building scalable applications in the microservices paradigm
• Collaborated withUI/UX, API and System teamsto support development initiatives Knowledge ofJSONinvolved.
• 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.
• Mentored and trained staff on Process Modeling, Process Simulation Workflow Role Participation in the BPMN
• Verified & validated the data-mapping by verifying various accounts details in various banking mainframe regions using test scripts in Quality Centre & filling defect logs if any.
• 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.
• 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, accounting, and IT).
• Responsible for analyzing the business process, creating requirements documents, maintaining vision documents, supplementary specification documents, and developed use cases.
• Established a RUP (Rational Unified Process) centric business analysis methodology.
• Worked on Developing RUP analysis model using object-oriented design concepts that include entity classes, use Case diagrams and Sequence diagrams using rational Rose to enable developers and stakeholders for a clear comprehension of the business process.
• Involved in Designing business requirement & systematic approach based on project scope and SDLC.
• Performed Analysis of business requirements and system requirements of the client and also for Property and casualty modules.
• Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
• Performeddatamapping anddataextraction management along withdatacleansing while migratingdatafrom legacy system to Guidewire Policy Center with GuidewireDataHub.
• Closely worked with Design and development of the data load process using XML Style sheets and ACORD.
• Translated business requirements into functional requirements and prepared an extensive project plan to reduce inter-company transactions in equity derivatives and foreign exchange trades.
• Definition of the golden sources for all employee data to con of project aims at modernizing Policy Admin systems and Billing system environment and gain increased flexibility in the policy admin process, by implementing Guidewire Policy Center and Billing Center from Guidewire.
• Exposure to ACORD Property and Casualty Standards and ISO (Insurance Services Office) tools and conventions.
• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Prepared High Level Logical Data Models and BRD's (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Conducted JAD sessions allowing different stakeholders to communicate their perspective with each other and resolving issues to come to a quicker agreement.
• Facilitated JAD sessions with end users, development and QA teams. Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Full responsibility of maintaining and filing the company reinsurance claims and providing a financial report to the management team.
• Responsibility included modifications to a customer's mainframe system to support new product features or regulatory requirements and, in some cases, involved a system upgrade.
• Reviewed reinsurance contract and amendment language for accuracy and appropriateness
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Analyzed and recommended procedures and guidelines for Fully Insured and Reinsurance products for the entire organization.

Confidential, Benbrook, TX

Sr. Business Analyst

Responsibilities:

• Successfully performed complex analysis and broke down to a simple requirement to be able to capture in the system.
• Conducted scenario analyses of the requirements to align with the business objectives for effective testing of reports.
• Participated in requirements workshop for implementing policy and billing modules of Duck Creek.
• Worked on Duck Creek Session XML and Data Model for Commercial Auto, Commercial Property and General Liability.
• Analyzed and reviewed the Issued Policy in Duck creek systems and rate the policy to ensure premium consistency.
• Assisted with business analysis and converting the business requirements to system requirements in Property, Auto and General Liability lines of business.
• Worked on quick quote user stories for Homeowners and Commercial Property policies.
• Worked as gathering business requirements for Duck creek, PEGA, .NET, Angular JS, EXT JS and mainframe applications, based front end and back-end application, client/server architectures, legacy and web-based system.
• Maintained a requirements traceability matrix to keep the clients and all the teams up-to-date with the current progress of the project.
• Developed use cases reports, user interface prototypes, BPMN and workflow diagrams using Visio.
• Worked with Kanban teams in aligning Infrastructure Kanban Backlogs and defining structure for prioritizing work.
• Involved in analysis and underwriting for Property Casualty Insurance, claims which offers personal lines auto, homeowners.
• Used Rally tool for requirements management and tracking user stories in a sprint and product backlog.
• Tracking business reporting issues on JIRA by creating problem statements that help breakdown the underlying issue.
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing)
• Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing using Mercury's WinRunner.
• Worked closely with Engineering Feature teams to provide DevOps support as needed in Azure Cloud.
• Suggested measures and recommendations to improve the current application performance.
• Assisted with the development of test plans and strategies, coordinated testing events, and executed test cases in support of changes to business systems.
• Participated user acceptance testing cycle; worked withbusinessusers to definebusiness scenarios, user acceptance test cases and user acceptance criteria.
• Used JAD sessions, brainstorming sessions and personal interviews to acquire business requirements from business users and stakeholders.
• Generated financial forecasts for the given project by using the scope of the system.
• Conducted Visio to develop use case model. Produced a development plan for the overall project and prototypes.
• Created UML diagrams including activity and sequence diagrams by using MS Visio.
• Determined the functional requirements, non-functional requirements and user stories.
• Created business requirements document and functional requirements document.
• Worked intensively on data warehouse and mart design sessions for both Logical and Physical design.
• Produced professional quality outputs and artifacts as needed (e.g. tables, graphs, presentations as appropriate).
• Assisted the Team in determining if and how new systems may improve process flow and business function.
• Prepared and maintained weekly status reports regularly to communicate project status to key stakeholders.
• Prepared and reviewed test plans and facilitate test execution to ensure the system meets requirements.
• Prepared and documented the Test Scripts and User Training documents.
• Reviewed reported defects and determine the defects category (missed requirement vs. Enhancement requirement vs. Defect).
• Worked on data analysis of the survey created in the application using SQL and JSON structure.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Worked in mainframe environment and used SQL to query various reporting databases.
• Created Tabular Reports, Matrix Reports, and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Liaison for projects with other corporate departments, including Executive (Underwriting, Billing, Accounting), BusinessIntelligent, as well as vendor relationships.
• Collaborated with business stakeholders and IT partners on assessing impacts of new initiatives and assisted in the development and execution of implementation plans, including the creation of backlogs, estimation of effort, and identification of tasks.
• Performed analysis to evaluate the associated benefit, considering both qualitative and quantitative factors, as well as the associated cost, risk and impact to business users, processes, and systems.
• Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
• ElicitedBusinessrequirements andbusinessneeds as part of an Agile Scrum team.
• Collaborated with various levels of stakeholders, engaging them in constructive discussion, driving consensus, and managing conflicts and negotiating requirements in relation to priorities.
• Collaborated with the business and technical stakeholders to accurately documents report, functional, non-functional and data requirements while ensuring compliance with corporate standards.

Confidential, Fort Worth, TX

Business Analyst

Responsibilities:

• Understood the Business Logic, User Requirements and test-objectives to develop Use Case Scenarios
• Expertise in facilitating and conducting Joint Application Development (JAD) sessions with Business Clients to identify business rules, functional and non-functional requirements
• Assisted end-users in articulating business requirements and coordinated workshops and brain storming sessions.
• Worked on UAT testing and took signoff from the Commercial line of Property & Casualty business users.
• Successfully migrated terabyte data from different legacy source systems. And built one centralized data hub.
• Provided input and technical help to Product Management for the upcoming base product for Guidewire suite of application.
• Involved in designing business requirement collection approach based on the Agile SCRUM SDLC Methodology.
• Provided input and technical help to Product Management for the upcoming base product for Guidewire suite of application.
• Successfully coached the development team in adoption of SCRUM as a process skeleton, so as to enable team deliver higher quality, higher value software faster thus, improving time to market.
• Coached and motivated the team to be self-organizing while enforcing best engineering practices thus, improving time to market and reduced defect count.
• Tracked team velocity and Sprint progress using Sprint burn down chart and Release burn down chart and conducted time boxed Daily SCRUM meeting and resolved impediments with assistance of Product Owner.
• Involved in mentoring specific projects in application of the new SDLC based on the RUP, especially from the project management, requirements and architecture perspectives.
• Provided data workflow, including legacy system profiling, mapping of data, documentation of business rule validations, and reconciliation of historical claims data for an enterprise integration of Guidewire Claim Center.
• Involved on management of a reconciliation project with as main objective: detect, log and resolve the differences between all the employeedatasystems used by the bank.
• Documented business processes using business process modeling notation (BPMN) to transfer business knowledge and requirements into technical specifications for building and adapting systems utilizing Appian's BPM Software Suite
• Improvement of employeedataquality with process review and sourcing analysis.
• Definition of the golden sources for all employeedatato con the project aims at modernizing Policy Admin systems and Billing system environment and gain increased flexibility in the policy admin process, by implementing Guidewire Policy Center and Billing Center from Guidewire.
• Document software defects, using a bug tracking system, and also report defects to software developers Involved in Planning, analyzing bugs, Execution and Bug Tracking.
• Monitor bug resolution efforts track successes. Identify, analyze, and also document problems with program function, output, online screen, or content.
• Evaluate or recommend software for testing or bug tracking Utilized Test Director for defect tracking, Excel for managing the test scripts.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Primary activities includedataanalysis identifying and implementingdataquality rules in IDQ and finally linking rules including Address Doctor to Power Center ETL processes and delivery to MDMDataHuband otherdataconsumers.
• Actively participated in enhancement meetings to investigate software bugs and interacted with developers to resolve technical issues.
• Organized Joint Application developments (JAD), Joint Application Requirements sessions (JAR), Interviews and Requirement Elicitation sessions.
• Provided key initiatives in working with users in defining project and system requirements.
• Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc.
• Analyzed the business and functional requirements of the application and developed detailed test plans, test cases in Test Director.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Responsible for the development of a Data Warehouse for personal lines property and casualty insurance
• Conducted JAD sessions with CRM SMEs, system architects, technical teams and other stakeholders for open and pending issues.
• Created data mapping documents to map the data fields, which assist the middleware team to route and parse interface messages between different applications.
• Extensively used Test Director to review and update the status of entire testing process.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Developed automated Test Scripts in Win Runner using Test Script Language (TSL) for Functional Testing, Regression Testing, Data Driven Testing, Usability Testing, and Verifying Specific content through using Checkpoints
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD using UML.
• Performed requirement analysis, went through all the use cases and issue logs.

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Created Tabular Reports, Matrix Reports, and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Have sizeable adequate hands-on exposure in Workers Compensation, Commercial Insurance as well as Property & Casualty Insurance & its various intricacies.
• Worked on AWD to monitor the dashboards and analytical reports which provide the real-time access to mission-critical data.
• Worked on Property and Casualty insurance company as an Underwriter with Solid understanding in Property and Causality.
• Worked with developers in writing of complex SQL queries to resolve data issues in source system databases.
• 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.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Create business-process diagrams using MS Visio (according to BPMN)
• 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.
• 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 in development of Guidewire training 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.
• Interacted with the client departments and the Information systems IT department to perform analysis, review, and estimation of client requests, prepared and reviewed requirements and client documentation for Personal Lines Property and Casualty business.
• Communicate with Customer Service on ACORD Forms design and other technical problems.
• 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.
• Aligned with the Guidewire Policy Center work stream and worked closely with Billing Center, Integration, Rating, Claim Center, Data Hub.
• Work closely with production underwriters to review commercial property insurance renewal and new business opportunities to ensure proper risk identification, analysis and assessment and the development and growth of a profitable portfolio of business.
• Created technical impact documents, data mapping documents and defines ACORD mappings for various interfaces based on knowledge of business needs and working closely with senior department managers and key department members with limited supervision.
• Involved in migration process from Mainframe, Policy legacy systems to Guidewire applications.
• Worked with requirements management, workflow analysis, source data analysis, data mapping, Metadata management, data quality, testing strategy and maintenance of the model. Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• 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 on Property and Casualty insurance company as an Underwriter. Strong understanding of rating in Property and Causality.
• Managed and enhanced a system aimed at maintaining and enhancing a web based high performance personal Auto claim handling process.
• Worked on various policy administration & industry standard tools such as Guidewire Policy Center, Billing Center, and Claim Center and ACORD standards with insurance laws, regulations and company policies.
• Involved in documenting customization requirements, business rules and data migration requirements for the Implementation of Guidewire Claims Center and Policy Center.
• Worked on GPA web portal using web services, helped with mapping and process flow diagrams.

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Liaison between business users and project team for requirements management for Commercial, Personal, Workers Compensation, and Specialty insurance; documented "AS-IS" and "TO-BE" business process across various line of business.
• Responsible for analyzing the business process, creating requirements documents, maintaining vision documents, supplementary specification documents, and developed use cases.
• Established a RUP (Rational Unified Process) centric business analysis methodology.
• Involved in Designing business requirement & systematic approach based on project scope and SDLC.
• Worked on analysis of business requirements and system requirements of the client and also for Property and casualty modules.
• Conducted User Interviews and Work Shops to gather accurate Business Requirements.
• Utilized JIRA to communicate constantly changing functional and design requirements with business users and developers.
• Involved in DevOps migration processes for build and deploy systems.
• Responsible for acting 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 both Personal and Commercial Lines of Business integration requirements with Guidewire Billing Center and Claim Center.
• Worked closely with integration requirement with Docs and Forms, Policy, Rating, Customer Data Hub, Risk Report, Portfolio management, Policy Service.
• Identified Use cases from the Functional requirements and wrote Use Case Specifications and created business process workflow diagrams (Activity diagrams, Sequence diagrams, Collaboration diagrams).
• Worked on GAP analysis on the traditional claims system and newly integrated Policy Centre.
• Conducted JAD sessions allowing different stakeholders to communicate their perspective with each other and resolving issues to come to a quicker agreement.
• Analyzed bulk JSON data in Tableau and MS-Excel.
• Worked with underwriters, actuary to determine the rating algorithms for TO BE system.
• Involved in documenting customization requirements, business rules and data migration requirements for the Implementation of Guidewire Claims Center and Policy Center.
• Created technical impact documents, data mapping documents and defines ACORD mappings for various interfaces based on knowledge of business needs and working closely with senior department managers and key department members with limited supervision.
• Worked on Property and Casualty insurance company as an Underwriter.
• Performed Integration testing, System testing, Regression testing and Performance testing of Billing Center, Policy Center and Payment manager in Guidewire application based on the business requirements.
• Full responsibility of maintaining and filing the company reinsurance claims and providing a financial report to the management team.
• Reviewed reinsurance contract and amendment language for accuracy and appropriateness.
• 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.
• Helped in implementing Guidewire Policy Center through an Agile Scrum development model.
• Involved and reviewed TSQL queries and stored procedures to process analyze and implement data integrity initiatives for various business units.
• Worked on MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint MS Project for data migration in to the CI System Knowledge Database in Microsoft SharePoint.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Worked as Business Analyst for the project on Workers Compensation line of business to gather and document as is flow and future business flow using Guidewire Policy Center.
• Involved with the technical team in understanding the XML file format required for Split loss process and Billing process.
• Created detailed Use cases, BPMN flows, Functional Specifications, UML diagrams to remove ambiguity of the requirements communicated by clients or SMEs.
• Wrote SQL queries to retrieve and validate data, prepared for data mapping document.
• Worked on SharePoint to maintain up to date changes to any artifact, version controlling and controlling duplication of effort.
• Assisted QA team in executing Test plans and wrote Test Cases.
• Verified various accounts details in various banking mainframe regions using test scripts in Quality Centre& filling defect logs if any.
• Worked 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.
• Collaborated with quality assurance/quality control to ensure that the final product met all the requirements.
• Cooperated with various teams during the user acceptance testing (UAT) of the final product.
• Reviewed and approved Test plans and Scripts for accuracy