SUMMARY

• 8+ years of strong experience in software Quality Assurance Analysis with Functional & Automation testing of web, client/server.
• 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 and Crop Insurance.
• Excellent knowledge of various policy administration & industry standard tools such as Guidewire PolicyCenter, Guidewire ClaimCenter, Guidewire BillingCenter.
• Strong experience in reviewing and understanding business, testing requirements, and writing detailed Test Plans, Test Cases, Test Scripts and Test Summary Report
• Strong Experience in Test Management Tool Quality Center, HP ALM and Defect Management Tool Bugzilla.
• Strong knowledge in web development technologies including HTML, JSON, CSS, JavaScript, AJAX and XML
• Experience in Commercial lines Property and Casualty P&C Insurance including both policy and claim processing and reinsurance
• Extensive Data Warehousing experience using Informatica as ETL tool on various data bases like Oracle, SQL Server, Teradata, MS Access.
• Experience in handling onsite/offshore coordination. Excellent Organization, Analytical and Problem - Solving skills and ability to quickly learn new technologies
• Extensive experience in defining and managing requirements, Automated Testing tools like Win Runner, QTP, Load Runner and Rational Robot for testing client/server, web-based n-tier applications
• Extensively worked on database testing (Oracle, SQL Server, MS Access, and DB2) and validating the applications against the database using SQL queries.
• Skilled on Automation tools like Selenium Web Driver (Functional & Regression Testing), Cucumber, TestNG, Rest Assured, JDBC, Eclipse, Maven, Jenkins for testing Web based Applications.
• Experience in using Manual Testing for creating Test Plans, Executing Test Cases, Data Driven Testing, Back End Testing and Data Integrity Testing.
• Experience in Functional testing and Database testing for Guidewire Applications.
• Extensive experience with Web service (SOAP, JSON, REST) API Testing.
• Extensive experience of analyzing complex IT projects throughout SDLC - from scope definition to successful implementation using Waterfall and Agile framework
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in developing QA test cases, test scenario and leading towards UAT and Beta Testing for ensuring the application’s successfulness.
• Experience in writing SQL and PL/SQL scripts, Stored Procedures, Functions, Packages, Triggers and Cursors for MS SQL and Oracle server.
• Good understanding of different types of testing like GUI and Functionality Testing, Load Testing, Stress Testing, Performance Testing, Smoke Testing, Unit Testing, Integration Testing, Regression Testing, Volume Testing, Sanity Testing, Positive Testing, Negative Testing, Black Box Testing, White Box Testing, User Acceptance Testing, Beta Testing for Subject Matter Testing (SME) and Back End Testing using SQL Queries.
• Excellent skills in client relationship management, interaction with business partners, subject matter experts, portfolio architects and technology partners.
• Experience in Reviewing and selected risks to maintain a profitable book of business for Personal Lines Auto, Home, Dwelling Fire and Excess lines of business.
• Skillful implementation of different requirements elicitation and validation techniques such as walk through, interviews, brainstorming, presentation and storyboarding.
• Experience in Scrum Process and thorough understanding of Extreme Programming (XP), Agile Software
• Created test documents like QA Status Report, QA Summary Reports, QA Test Logs, Test sign-off, Maintain issue and defect databases.
• Excellent verbal and written communication skills to deal with all levels of management
• Quick starter, Self learner and a good team player with excellent leadership abilities

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. QA Analyst /Tester

Responsibilities:

• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Performed Integration testing, System testing, Regression testing and Performance testing of BillingCenter, PolicyCenter and Payment manager in Guidewire application based on the business requirements.
• Performed various tests like unit testing, Acceptance testing, UAT, Integration etc.
• Involved in creation and execution of manual test cases in Mercury Test Director, automated Test Cases in QTP, and analyzed the Test Results.
• Analyzed results of Regression Testing as performed by Testers using QTP and held meetings with Developers and Testers.
• Worked on conducting User Acceptance Testing (UAT) and documenting test cases in both personal commercial line of property and casualty insurance
• Executed SQL Queries to retrieve data from tables and to perform back end testing. Creating Test Cases after analyzing the BRD's. Performing Functional and GUI testing on Facets.
• Worked on reporting and estimates for Property & Casualty on Guidewire ClaimCenter implementation.
• Interacted with various stakeholders to elicit and document business data.
• Created translation document for requirements between PolicyCenter and BillingCenter systems
• Conducted data analysis to draw conclusions from data collected.
• Worked on creating and setting up the Test environment in Selenium WebDriver for Automation testing.
• Performed onsite-offshore coordination for multiple projects to perform test related activities.
• The Data Warehouse was created around the Accord Messaging Standard with extensions where necessary (Workers Compensation, Commercial and Personal Lines Auto).
• Worked on documenting customization requirements, business rules and data migration requirements for the Implementation of Guidewire ClaimCenter and PolicyCenter.
• Tracked bugs and reported issues and defects using JIRA.
• Involved in every Sprint that covered Elaboration, Configuration and Testing of the Guidewire Policy Center following AGILE approach
• Test Guidewire's BillingCenter UI (Screen), including Rules and Authority Limits
• Assigned tasks among development team, monitored and tracked progress of project following Agile methodology
• Worked on custom reports testing and provided scenario-based SQL queries to test entirety of a report
• Identified and communicated implications from data and conducted risks Analysis (SWOT) as well as possible solutions.
• Worked on Requirement analysis with business analysts and attending Agile/Scrum model meetings to review the requirements and scope
• Used Selenium core to quickly record and play back the tests in the actual environment that they will run the web browser.
• Understand all required area and generate business complex testing scenarios and perform UI and Regression verification using Silk Test.
• Produced professional quality outputs and artifacts as needed (e.g. tables, graphs, presentations as appropriate).
• Created various test sets for different test cycles within Test Lab module of Quality Center and perform the test case assignment within Quality Center for offshore QA testers.
• 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.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Reviewed reported defects and determine the defects category (missed requirement vs. Enhancement requirement vs. Defect).

Confidential, Mayfield, OH

QA Analyst /Tester

Responsibilities:

• Created test plans and wrote test cases for manual execution
• Work closely with members of the SCRUM team to translate the customers' business needs or Business Cases to a technical solution
• Use agile systems and strategies to provide quick and feasible solutions, based on agile system, to the organization
• Performed routine checks on Property and casualty loan litigation and negotiation processing activities as well as received reports from team members on selected claims applications.
• Used HP ALM to document issues found during the test automation process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team.
• 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
• Mentor entry level Testers on reviewing requirement, preparing and executing test cases, and report software defects.
• Performing database testing using SQL Queries for data validation
• Involved in developing automated tests using Selenium WebDriver with developers for Continuous regression and reducing manual testing using Selenium, TestNG
• Preparing and executing test cases for functional, integration, UAT and regression testing
• Involved in preparing Test Plan and Test Cases based on business requirements.
• Authored, maintained and updated integration test procedures
• Worked on UAT phase1 & 2, developed UAT test cases, test data, mentored the QA team before execution, and documented the test result / reports through QC
• Develop detailed test scenarios and test scripts derived from defined business requirements and supported the QA manager to coordinate test plans across multiple parties
• Actively participate throughout all phases of the ticket test life cycle, from development to deployment, following agile process
• Created and maintained SQL Scripts and Unix Shell scripts to perform back-end testing on the oracle database
• Worked on writing SQL Queries for verifying the data in database and for creating the different policies used for testing claims projects scenarios.
• Collected project information and submitted all reports to project manager and lead developer
• Isolated, replicated, and reported defects and verified defect fixes using JIRA
• Demonstrate adeptness in using ALM and SharePoint
• Supporting the offshore QA team by giving them knowledge transfer and helping them with closure of the defects
• Coordinate with developers to resolve identified defects, and applied regression testing to validate that bug fixes do not break other parts of the program
• Developed test scripts for data driven testing using parameterization in QTP by using Excel sheet for test data and database queries based on the functionality
• Converted manual test scripts to automated test scripts in Quick Test Professional, enhanced the scripts by adding user-defined functions
• Working closely with Off-shore testing team on creating and executing test cases and test data
• Created various test sets for different test cycles within Test Lab module of Quality Center and perform the test case assignment within Quality Center for offshore QA testers.
• Attending Stand up, planning meeting, reviews and other project and QA related meetings
• Created defects and verified corrections using JIRA.
• Extensively used the ALM/Quality Center tool for all the test management activities like Release Planning, Test Planning, Test case Execution, Requirement Traceability and Reporting.
• Experience in performing end-to-end User Acceptance Testing (UAT).
• Conducted System Testing, Regression testing, GUI Testing and Cross browser compatibility testing during the releases and interacted with the developers to resolve any technical issues
• Created test cases manually to perform different types of testing such as positive/negative, functional/regression, interface, batch testing, screen navigational testing, smoke/sanity testing, exploratory testing or Backend testing

Confidential

QA Analyst /Tester

Responsibilities:

• Used Guidewire to upgrade the current Claim system to track the claim of the policy holders and third-party applications.
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Conducted scenario analyses of the requirements to align with the business objectives for effective testing of reports.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables
• Responsible for coordinating Integration testing, UAT and Regression testing with Business Consultants and Offshore team members, as applicable.
• Performed cross browser testing on multiple browsers like Safari, Chrome, IE & Firefox using Selenium across different operating systems like Windows and Linux.
• Selenium automation started in place of UFT to cover latest/most browser versions and worked closely with development team (Agile) to create Selenium WebDriver automation scripts.
• Followed Agile methodology and worked along with Product Owner for better Collaboration among Scrum Master, Scrum Team and Business Stakeholders
• Coordinating with offshore team to communicating the customer requirements.
• Used Quick Test Pro’s Data Table, to manipulate the data sets and create multiple test scenarios.
• Enhanced the job properties for performance tuning.
• Worked on Guidewire PolicyCenter for Policy creation and maintenance using different Policy Transactions for Auto and Property (including Homeowners).
• Worked on Guidewire software to track the claims of the policy holders.
• Backend testing team performs the API testing of REST Web services using tools like Soap-UI and Poster. API testing validates the JSON output with the expected output, and also compares the JSON output with XML input.
• 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.
• Assisted with the development of test plans and strategies, coordinated testing events, and executed test cases in support of changes to business systems.
• Extraction of test data from tables and loading of data into SQL tables.
• Maintained a requirements traceability matrix in order to keep the clients and all the teams up-to-date with the current progress of the project.
• Worked on Research and recommend tools for agile process management. Mentor business analysts on agile processes and traditions.
• Defined epics and user stories created user story elaboration documents including defining business rules, user interface, integration requirements, and user acceptance criteria.
• Participated user acceptance testing cycle worked with business users to define business scenarios, user acceptance test cases and user acceptance criteria.
• Worked closely with business partners, SMEs and product owners to understand the process.
• Conducted Acceptance review with Product owners for the developed functionality.
• Used Rally tool for requirements management and tracking user stories in a sprint and product backlog.

Confidential, Greenville, SC

QA Analyst

Responsibilities:

• Developed Data Flow Diagrams and Data mapping agreement, illustrating the flow of data from the front-end Guidewire ClaimCenter into the Application database Tables.
• Involved in creating test plans, test strategy and executing test cases for rating used for premium calculation.
• Analyzed and documented performance/security/User Interface Branding requirements for the application.
• Worked on coverages and exposures pertaining to dwelling, personal property, other structures, loss of use, content, etc. relating to Homeowners Policy.
• Involved in gathering requirements for both Personal and Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Responsibility to identify new commercial insurance program opportunities for reinsurance partners.
• Onsite Offshore coordination and team activities tracking.
• Worked on documenting Master QA Strategy. Defining the QA tasks for Java and data intensive projects. Customizing the scope of various QA activities based on nature of projects.
• Involved in Configuring Selenium WebDriver, TestNG and created Selenium automation scripts in java using TestNG prior to agile release.
• Prepare Test Strategy, Test Plans, and Test Cases based on client's user stories on Guidewire ClaimCenter application.
• Automating the manual test cases using Selenium Web Driver, QTP and VBScript.
• Followed Agile methodology, being Business Analyst as Product Owner for better Collaboration among Scrum Master, Scrum Team and Business Stakeholders
• Present Guidewire functionality demo to Information Technology and Claims group (about 50 people or so) and answered questions in the town hall meeting at the end of each sprint.
• Discussed incident story cards for Homeowners policy like personal property incident, dwelling incident and liability incident.
• Used Guidewire to upgrade the current Claim system to track the claim of the policy holders and third-party applications.
• Analyzing the ETL process created in Informatica, developed SQL queries and tables which replicated the ETL, and compared the SQL results with the Informatica tables
• Analyzed and documented requirements for Quote possesses for a Commercial Auto Policy
• Proactively identify inefficiencies in system and proposed changes to increase system accuracy and cost effectiveness.
• Analyzed user requirements, attended change request meeting to document changes and implemented procedures to test changes.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Captured various step in FNOL process for Homeowners policy.
• Working on understanding "as is" processes and helped to define "to be" processes to streamline the processes and make them more effective.

Confidential, New York city, NY

QA Analyst

Responsibilities:

• Identified new commercial insurance program opportunities for reinsurance partners.
• Communicated with reinsurance brokers to obtain information necessary for processing claims.
• Involved in analysis of Department of Insurance filings and prepared documentation on the impact on rating.
• Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker’s Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Analyze the functional requirements, writing test cases for each and every object. Using test specs and test frames created, automated the test cases using Test Director.
• Worked closely with Customer Portfolio, Forms team to test the integration between these services.
• Responsible for the configuration of rates and rating algorithm in Personal Automobile and Home insurance products rating engine.
• Involved in rigorous meetings with offshore testing team and DWH to plan and implement the testing efforts.
• Involved in coordinating with the database design team, using SQL to Query databases and providing inputs in finalizing the data model, report layouts.
• Developed the systems implementation project management plan with milestones and steps from procurement of vendors to project implementation and maintenance.
• Prepared all SDLC documents for projects.
• Worked closely with Regulatory and Filings (RAF), product teams in various insurance operations like Premium Survey, Rating Examples and Market conducts.
• Authored progress and completion reports, which were then submitted to project management on a weekly basis.
• Collaborated with the development team to monitor and track progress of project following Agile methodology.
• Collaborated with various teams during the user acceptance testing (UAT) of the final product.
• Designed and reviewed different comprehensive data reports using MS Access and MS Excel.
• Conducted due diligence for searches, generating reports, proposals and constructing presentations for financial advisors to present their clients.

Confidential, Atlanta, GA

QA Analyst

Responsibilities:

• Performed Functional Test on GUI of Various Modules and documented the Actual Result.
• Extensively worked on SQL Queries to perform Database Testing.
• Responsible to prepare Use case document and Test Plan Document.
• Managing simultaneous projects with multiple clients, through full system development life cycle, ensuring delivery success using Agile/Scrum methodology and Team Foundation Server (TFS).
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Performed various tests unit testing, Acceptance testing, UAT, System Testing, Integration testing and regression testing etc.)
• Worked with project manager and Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Involved in Designing and Executed Test Plans, Test Cases and Test Procedures.
• Involved in Analyzing Software Requirements documents and Business Requirements documents to get a better understanding of the system on both Technical and Business perspectives.