SUMMARY:

• Around 8+ years of experience in IT Industry with excellent knowledge of the SDLC process and STLC.
• Experience in creating and executing Test Cases, Test Scripts and Test Plans from Business Requirements Document. Participated in testing life cycle from Requirements phase to Implementation phase
• Participated in Testing documentation reviews and walkthroughs, including Test strategies, Test plans, Test cases, Test Summary Reports.
• Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
• Expert in the Property, Casualty, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims, pensions and CMS.
• Analyzed system requirements and developed Test Plan, test cases and traceability matrix for various applications.
• Experienced with testing tools such as HP Quality Center, Quick Test Professional (QTP) SOAPUI and SQL Management Studio Tool 2008
• Extensive experience using manual testing to troubleshoot systems integration, GUI, Compatibility, User Acceptance Testing (UAT), SOA Testing using web services, functionality, Database and regression testing.
• Good Expert on Tools like HP ALM QTP, HP Quality Center .
• Experience in setting up HP - QC custom rules for Test Plan, Test Lab, and Defects
• Worked with Guidewire developers and prod support team to understand various functionalities in Guidewire Policy and Billing Center.
• Estimated work effort for various tasks in the testing process.
• Devised test procedures, bug tracking mechanism, review and analysis of user and business requirements.
• Developed test scripts for automation testing web-based applications.
• Involved in backend testing by writing SQL Queries to validate records in different tables.
• Extensively involved in System, Regression, Unit testing and UAT.
• Experience in Guidewire ClaimCenter, Rational LTS (RUP, RequisitePro, ClearQuest), MS Visio, Quality Center, and various open source tools for Issue Management and Documents Management
• Knowledge of claims Guidewire systems and policy administration system.
• Tracked, analyzed, and documented defects using HP Quality Center.
• Worked closely with the project team in planning, coordination and implementing QA methodology.
• Competent using SoapUI to test Web Services.
• Facilitated UAT(User Acceptance Testing) with the stakeholders and the business user.
• Experience in working in Water flow and Agile Methodologies.
• Experience of working in Client-Server, Web based applications.
• Competent with SQL and PL/SQL programming. Used SQL queries for data integrity.
• Strong knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Proficient with Automation tool Quick Test Professional (QTP) and the Test management tool HPQuality Center.

TECHNICAL SKILLS:

Testing Tools: Quick Test Professional (QTP), HP Quality Center/ALM, SoapUI

Programming Languages: SQL, Visual Basic

Databases: Oracle, SQL Server 2010, MySQL and MS Access.

OS/Platforms: Windows, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Keene, NH

QA Analyst

Responsibilities:

• Gathered Requirement Specification Document and Manuals to understand the system and rating rules with extensive interaction with the business users.
• Provide customer service and support for Property & Casualty risk management needs
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Analysis of business requirements and system requirements of the client and also for Property and casualty modules
• Explained Property & Casualty terms, Insurance Rules, Workers Compensation, Claims Process to the Dev. team
• Involved in developing Test Plan, Test Scripts and Test Cases.
• Engaged in writing Functionality, GUI, Navigation and Scenario test cases for New Business, Endorsements, Cancellation and Reinstatement.
• Performed Smoke Testing for both Auto and Homeowners Insurance.
• Attended Project Change Request (PCR) meetings and performed PCR testing.
• Assisted in the documentation of requirements for the Guidewire Claim Center claims management system as a business analyst.
• Analyzed the objectives and scope of each stage of testing process from the test plan on Guidewire.
• Integration Testing of Guidewire Policy Center with Claim and Billing Systems.
• Expertise in developing Automation Frameworks for Web Applications using QTP.
• Preparing & updating functional requirement specification document for Guidewire Claim Center 7.2 configuration on the out of box functionality. Coordinated with QA team in preparing for compatibility testing of Guidewire solution.
• Reviewed client business requirements to identify product gaps in the Guidewire product
• Compared Mainframe Output with Dragon Output for both Homeowner and Auto Insurance.
• Review the automation framework for the Dragon Application.
• Tested Application functionality, business flow and Database Driven Testing using QTP.
• Involved in Parameterization, by replacing fixed values with parameters, check the application performs the same operations with multiple sets of data.
• Experience in using ETL tools like Informatica, DataStage for Data Integration and tested the Data Migration from source to target using complex SQL queries.
• Developed Test Plans, Test cases using ALM.
• Testing and Regression Testing, Selenium, Cucumber, Calabash, Groovy, EMV, Scripting, Python, Ruby.
• Configured Selenium Web Driver, Ant tool and created selenium automation scripts in java using Junit prior to agile release.
• Experience in ETL Testing/Data warehousing testing /Data Quality testing.
• Source to Target Mapping (STM) in the system integration, data warehouse, and data migration projects.
• Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed reports out of the consolidated data warehouse for the business users using MS SQL Server Business Intelligence Development Studio.
• Created different SSRS Reports based on the user's requirements, such as Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using SQL Server Reporting Services 2012.
• Worked in different automation tools QTP, Rational Robot, Selenium, JMeter, and Neoload.
• Extensively worked with Jmeter in analyzed applications performance for varying Loads and Stress conditions.
• Tested compatibility of application for dynamic and static content under various cross browsers using HTML IDs and XPath in Selenium.
• Created automation scripts in SOAP UI using Groovy Script for web services testing.
• Interacting with the stakeholders to get a better understanding of client business processes and gathered documented the business requirements.
• Identified SMEs (Subject Matter Expert) and drove the requirements gathering Worked on High Level Requirements with SME’s, Developers and Stakeholders for different applications.
• Exported Test case Scripts (Java-Selenium Web Driver) in Eclipse IDE and modified the Executed SOAP based web services for APItesting (Java client and SoapUI).
• Developed test code in Java language using Eclipse IDE.
• Automated web application using Selenium-RC and Java.
• Worked on Selenium IDE, and Web Driver. Made, and checked the Java codes as per requirement.
• Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines
• Preformed regular sittings with stakeholders modeled business requirements through JAD/JAR sessions and maintained project stakeholder request baselines.
• Generated the detailed reports of the Bugs, Pass-Fail report and Assigned defects using QC
• Participated in Triage Meetings, weekly status meetings with IT and business people.

Environment: QTP, QC, Oracle, SQL, Java, JavaScript, HTML, Windows NT/2000, UNIX HP, UNIX Shell Script

Confidential, Columbus, Ohio

QA Manual Tester

Responsibilities:

• Help review and contribute to product documentation
• Work closely with development team to resolve various issues.
• Worked on a UNIX platform and experience in backend testing by executing SQL queries
• Manually tested the web application to ensure the flow of the application functionality
• Developed and maintained Test & Traceability Matrices
• Created complex SQL scripts and embedded them into the UNIX Shell scripts to automate the Back-End testing
• Performed backend testing using UNIX shell scripts
• Extensive use of UNIX shell scripts to perform the database/backend testing
• Performed Sanity and Smoke Testing manually
• Enhanced use of Shell Scripts
• Performed backend testing to validate the data using SQL queries
• Performed negative and positive testing using SQL queries
• Quality Center was used to create the test plan, store test cases and run the test sets.
• Interacted with developers to report and track bugs using Quality Center.
• Detected and reproduced the defects, and logged defects using Mercury Quality Center.
• Generated the test execution report in Mercury Quality Center to be reviewed by the QA Manager and development team.
• Used shell scripting to run the scripts as a part of creation of test environment and then validate the data.
• Extensive use of lengthy and repetitive UNIX scripts into a single, simple command
• Detected and reported bugs using Mercury Quality Center to be reviewed by the QA Manager and development team.

Environment: Load Runner, Mercury Quality Center, Windows 2000, Oracle/Unix, SQL, XML, HTML.

Confidential, Barrington, IL

QA Analyst

Responsibilities:

• Knowledge of Agile/Scrum methodology.
• Written Test Plan and Test Cases by going through the Design, Functional Requirements.
• Used Quality Center for Test Planning, Test Execution and Defect Tracking.
• Executed test cases and logged defects using Jira and RallyDEV
• Reviewed the test cases with various groups and verified it covered the definition of done for the user story.
• Used SOAP UI for the Webservice testing
• Performed integration testing for the following.
• Metro reports
• ISO
• Other internal Web Based Systems
• Performed Claims testing for the following.
• New Claims Process
• FNOL
• Reserve
• Check
• Tested the database integrity by writing SQL Queries using SQL Management Studio.
• Tested production defects
• Created Traceability between Requirements and Test Cases.

Environment: Quality Center, JAVA JDK1.6, Guidewire Claim Center 7.0, Windows7 Enterprise, XML, HTML, SQL Server, IE

Confidential

Business Analyst

Responsibilities:

• CNA is the 7th largest U.S. commercial insurer and the 13th largest U.S. Property & Casualty insurer.
• I led a team of Developers, Data Analysts, ETL and Quality Assurance Testers through the sprint process to analyze, build and demonstrate a web application called CNA starts which enable the Underwriters obtained Submissions and Quote/Bind information from their producers as well as ensuring continuous delivery of the projects on time and on budget.
• Interviewed Business users to gather requirements and analysed the feasibility of their needs by coordinating with the project manager and technical lead.
• Utilized corporation developed Agile SDLC methodology.
• Conducted extensive requirement analysis using Rational requisite pro
• Assisted the developers in performing data modeling, data validating and data mining using Cognos.
• Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
• Worked on Document for Version Controlling, to maintain up to date changes in the Documents.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules.

Confidential

Software Tester

Responsibilities:

• Involved in Manual testing of the application
• Responsible for writing test cases based on the user requirements and design documents
• Executed Test Scripts for functional and regression testing using Test Director
• Generated Test Data for Manual Testing and verified the results against expected results
• Used Test Director for planning, running tests and tracking defects
• Review and Analyze User Requirements and specifications
• Developing system test scenarios and Regression scenarios
• Execution and review of test execution results.
• Defect Management using Test Director 7.6
• Managing the team as back-up Team Lead.
• Communicating with the development team, creation and distribution periodic status/defect reports
• Preparation and circulation of Defect Log and Defect Report
• Collect Testing Metrics and doing Casual Analysis for Defects

Environment: Microsoft Visio, Microsoft PowerPoint & Paint, Test Director, ASP. Net, MS SQL 2005, HTML