SUMMARY

• Over 7 years of extensive experience working as a Sr. QA Tester in Insurance and Finance Industry, with solid experience in Quality testing experience in Manual and Automation Testing on Client/Server, and Web Based applications.
• Extensive experience working as a QA Tester in Guidewire, property and Casualty Insurance domain.
• Proficient experience in Manual and Automated Testing of GUI and functional aspects of the Client - Server and Web based Applications on multiple levels of SDLC and Testing Life Cycle (STLC).
• Experience in writing automated scripts, designing Test procedures, Manual Test cases and preparing Quality feedback to QA team & manager.
• Hand on experience to develop/enhance and document automated testing methodology.
• Hand on experience and Knowledge of VBScript and Quick Test Professional (QTP), Automated Testing Tool used in various software development environments using different technologies.
• Experience and expertise testing complex, data intensive enterprise applications using QTP and other scripting languages.
• Experience on Web services to combine component-based development and Internet standards and protocols that include HTTP, XML, SOAP and Web services Description language.
• Ability to conduct all types of application testing as needed using Selenium and other tools and scripts (i.e. integration, system, regression, load/Performance, security, negative and acceptance testing.)
• Strong experience withGuidewireand Insurance/Finance tools in Property and Casualty domains.
• Experience in architect and design test automation frameworks in collaboration with the Testing team and Development teams in QTP & Quality Center workflow.
• Expertise in using defect-reporting tools like HP ALM/ Quality Center, and Jira.
• Strong skills in backend testing on Relational database. Writing SQL queries, generating reports to ensure data integrity and validating business rules.
• Working experience of PerformanceTesting using HP LoadRunner and NeoLoad.
• Experience with AGILE / SCRUM methodologies and techniques: continuous integration, automated or Unit test, pair programming, test driven development, design patterns, domain-driven design, code refactoring.
• Strong experience in Guidewire Insurance Suite (PolicyCenter,BillingCenter, ClaimCenter).
• Hands on experience in Guidewire products like Policy andBillingCenterApplications.
• Experience in developing Selenium scripts using Java.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall, Scrum and Agile.
• Extensive experience in Manual Testing using both Waterfall and Agile testing methodologies.
• Extensive experience in creating and execute test cases manually; involve in executing automated test cases to verify Guidewire PolicyCenterandBillingcenterapplications.
• Expertise in performing various data setup activities for Load, UAT and Security testing using Selenium.
• Ability to drive and direct testing activities to allow applications to meet business requirements and systems goals, fulfilling end-user requirements, and identify and resolve systems issues.
• Extensive experience in manually executing the test cases to perform application functional testing of PolicycenterandBillingcenter.
• Expertise in review, maintain and improve current automated software test methodologies and processes.
• Expertise to analyze formal test results in order to discover, document and resolve defects, bugs, errors, configuration issues, and interoperability flaws.
• Experience in designing and developing project document templates based on SDLC methodology.

TECHNICAL SKILLS

Tools: UML, Microsoft Visio, XML, JIRA, Quality Center, Selenium, HP ALM, Test Director, QTP, TOAD, Clear Case, Load Runner, Neoload, IBMRational Functional Tester

Modeling: Use Case Modeling, UML -Use case, Sequence diagram, Activity Diagram.

Methodologies: SDLC, RUP, UML, Agile, Waterfall

Operating System: MS-DOS, UNIX, Linux, Windows 98/XP/ME/NT

Languages: SQL, C++, C# Java, HTML, VB, Ruby, XML

Databases: MS SQL server, Sybase, DB2, Oracle 8i/9i

MS Office suite: Word, Excel, PowerPoint, Project, Visio

PROFESSIONAL EXPERIENCE

Confidential, New York

QA Analyst

Responsibilities:

• Maintained and kept track of stakeholders requests for enhancements and changes using Rational ClearQuest;
• Manually verified the validity of the failed test cases. Performed Positive, Negative and Black box testing on the application
• Conducted Black Box Testing on the application and validated the data flow in the application.
• Prepared Test Plans for each release, written Test Cases and executed them as part of Functional Testing. Prepared Test Reports and Deliverables and submitted for version releases.
• Modified and Executed automated and manual test scripts for different modules using QTP.
• Involved in writing Test Plans and Test Scripts for Manual and Automation Testing.
• Responsible for Manual and Automated Testing of GUI and functional aspects of the Client-Server and Web based Applications on multiple levels of SDLC and Testing Life Cycle (STLC).
• Throughout the project, was involved in giving clarifications on domain and product functionality for the team.
• Performed Black Box testing and conducted Functionality and Regression testing on various phases of the Management software
• Created ETL test data for all ETL mapping rules to test the functionality of the ETL Mapping.
• Tested the ETL mappings and other ETL Processes (Data Warehouse Testing).
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Wrote extensive SQL queries for data validation, analysis and manipulation, and maintaining the integrity of the database.
• Verified Informatica session logs to identify the errors occurred during the ETL execution.
• Extensively used SQL for backend testing.
• Upgraded the existing Test Scripts and created new scripts for client application to be able to work for new versions and patches, which improved product quality.
• Responsible for analyzing Functional Requirement Specifications (FRS) and conversant with System Design Specifications (SDS).
• Reviewed System,Functionaland design specification for all the enhancements and releases.
• Prepared Test Plans for each release, written Test Cases and executed them as part of Functional Testing.
• Extensively involved in analyzing Business Specifications and developTestPlans,TestCases andTest Scripts and execute them.
• Wrote Test plan and Test cases for the Integration testing and system testing.
• Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
• Designed and implemented SQL queries for QA testing.
• Prepared user manual and performed user acceptance testing.

Confidential, MA

Datawarehouse QA

Responsibilities:

• Manually execute the test cases to perform application functional testing of PolicycenterandBillingcenter.
• Worked on Test Definition workshop, Test Strategy, Test Planning using Insurance Test Framework forGuidewire.
• Wrote Test plan and Test cases for the Integration testing and system testing.
• Involved in discussions with the Team on Quality Analysis, Manual Testing,Automated Test Toolsand Defect Tracking Tools.
• Involved with ETL team to implemented ETL process to load and extract data using Informatica.
• Involved in ETL process testing using Informatica ETL tool. Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• 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 using LISA.
• Performed manual front-end testing to check all functionalities of different modules.
• Created and maintained SQL scripts/queries for Data Migration, conversion, mapping, validation and data verification at the backend testing on the oracle database.
• Source to target requirements, ETL map specifications and business requirements were referred to write precise test cases
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data and finally load it into the Multi-dimensional data warehouse.
• Verified the ETL transformation logic by creating test SQL's and running them against the source and target entities
• Created dashboards, reports and inquiries for all JIRA related administrations.
• Performed Manual and Automation Selenium testing of web based application.
• Performed database testing for checking Data Validation and Data Integrity using SQL queries.
• 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 using LISA.
• Involved in writing Test Plans and Test Scripts for Manual and Automation Testing.
• Implemented Load testing using Soap UI and Load UI tools.
• Analyzed the responses of the web service using SOAP UI and validating the data in backend
• Involved in the setup of Continuous integration by mapping the script with Jenkins to run in predefined time
• Created new/modified test scenarios, test cases, Test Metrics and test approach strategies for this project.
• Wrote Test Cases in HP Quality center that would test various Test scenarios.
• Utilized JIRA to manage defect tracking, bug fixes, test scripts, and report defect.
• Prepared user manual and performed user acceptance testing.
• Wrote SQL Queries to retrieve and validate the data.
• Developed Test Plans, Test cases, Test Scripts, Test strategy, Test Scenario, Test Reports.
• Did Integration Testing, Soap GUI testing, Smoke and Sanity Testing, and Acceptance testing in the new builds for Basic Functionality Checking.
• Write SQL queries to automate data integrity and to verify the UI data against the real data.
• Designed and implemented SQL queries for QA testing.
• Prepared user manual and performed user acceptance testing.

Confidential, Tallahassee, FL

Quality Analyst

Responsibilities:

• Analyzed and defined testable requirements created and implemented test plans.
• Developed Test Cases/Conditions for manual and Automation testing of the above Applications and Reports.
• Gathered requirements from the users and analyzed the requirements.
• Involved in performing functional, application, integration, system, and regression Testing.
• Involved in creating the Traceability matrix based on Functional requirement in each module.
• Loaded the Test Data into the HP ALM to prepare for the execution of Test Cases.
• Planned and reviewed the Test Cases and Test Scripts for Unit, Integration, Functionality, System, Regression, Database and User Acceptance Testing.
• Performed Smoke, Sanity, Positive, Negative, Security, Backend testing manually.
• Responsible for inserting Check points to verify Functionality of the application using HP ALM.
• Maintain a log of all defects found during testing and send updates using HP ALM.
• Wrote test cases in HP ALM derived from the Design documents and generated a Traceability Matrix for testing purposes.
• Sole performance of API testing with different sub-systems as a part of Back-end test.
• Involved in testing Web services andXMLusing SOAPUI. Verified the response received by updating the requestXML.
• Extensively worked on all kind of joins and operators to fetch data from multiple tables.
• Performed back-end testing by extensively using SQL commands to verify the database integrity.
• Created and maintained SQL Scripts and UNIX to perform back-end testing on the oracle database.
• Performed manual testing in the UNIX environment.
• Performed manual testing to conduct backend testing using UNIX shell scripts and SQL Queries.
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.

Confidential, Erie, PA

Sr. QA/ETL Tester

Responsibilities:

• Involved in implementing insurance claims applications using Guidewire Claim Center Product.
• Performed Data Validation Testing, Functionality Testing, Defect retesting and Regression Testing.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Was responsible for back-end system replacement of the policy processing &billingsystems, changing from a proprietary back-end system to "Guidewire" a pre-built solution.
• Worked on Test Definition workshop, Test Strategy, Test Planning using Insurance Test Framework forGuidewire.
• Create and execute test cases manually; involve in executing automated test cases to verify Guidewire Claimcenter and Billingcenter applications.
• Automate existing manual test cases with Selenium in collaboration with QA team members.
• Performed backend testing using SQL queries to validate data.
• Wrote complex SQL queries in TOAD to perform Backend testing.
• Evaluate, plan, design, develop, and maintain test scripts using a framework for new applications, products, and/or enhancements to existing applications throughout their development/product lifecycles.
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Coordinated with team leads to determine needs and how best to implement JIRA within department.
• Write SQL queries, analyze the data, and perform data migration processes.
• Conducted manual ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data and finally load it into the Multi-dimensional data warehouse.
• Created ETL test data for all ETL mapping rules to test the functionality of the ETL Mapping.
• Tested the ETL mappings and other ETL Processes (Data Warehouse Testing).
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Tableau reports.
• Worked on the Enhancement of Cognos reports
• Involved in preparing the Test Scenarios for ETL Testing
• Creating Test Cases after analyzing the BRD’s.
• Involved in requirement gathering and performed ETL process.
• Tested the ETLInformaticsmappings and other ETL Processes.
• Involved in testing and validating data cleansing, data mapping, and data profiling, performed under ETL process using Informatica.
• Responsible for manual testing of both web and stand-alone applications (Agile/Scrum development) - majority testing: System Testing, Functional Testing, and Integration Testing.
• Worked with Data Completeness, Data Transformation, Data Quality, Integration, UAT testing and Regression testing for ETL and BI group.
• Managed Jira users and created workflows, issues types, fields in production.
• Used SQL to validate the new system staging data with existing production data.
• Developed reusable SQL scripts that can be used for regression testing.
• Used Selenium WebDriver API to automate tests on cross browser and cross platform environment.
• Created new/modified test scenarios, test cases, Test Metrics and test approach strategies for this project.
• Manually tested the whole application before automation of the tests. Helping development team in defining the scope for Unit testing.
• Wrote Test Cases in HP ALM that would test various Test scenarios.
• Wrote Test plan and Test cases for the Integration testing and system testing.
• Designed and implemented SQL queries for QA testing.