SUMMARY:

• 10+ years of diversified experience as a Senior QA Analyst/QA Tester in testing Guidewire Products, Data warehouse, FileNet Document/Content/Record/Process Management, Web Based and GUI based client/server applications using Manual and Automated testing procedures.
• Experience in preparing Test Plans, Test Strategies, Test cases, Test Scripts, Test Reports and test documentation and can comply with your established processes, can maintain strict adherence to your guidelines, policies and procedures.
• Involved in Complete Software Development Lifecycle (SDLC) from Business Analysis to Design, Development, Testing, Deployment and Documentation.
• Experience in different verification processes like walkthrough’s, check lists, meetings and different validation techniques and SQA processes.
• Expertise in Agile methodology with Scrum Process for the product development.
• Good Expertise in Insurance, Banking and Telecom Domains.
• 4+ years of experience in Guidewire products on Property and Casualty Insurance domain.
• Extensive experience working with ETL tool like Informatica.
• Experience in testing Business Report developed in Cognos.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema and working with slowly changing dimensions Type I II and III.
• Extensively used Data warehouse ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica.
• Strong hands on testing experience with FILENET, FLEX, JAVA, J2EE, .NET, HTML, XML, ASP, JSP and VB Script applications.
• Expertise in Testing FileNet components Content Engine, Application Engine, Process Engine, Component Integrator and Process Analyzer.
• Experience in design, implementation, maintenance and execution and result analysis for Functional automation test scripts in HP Quick Test Pro (QTP)/UFT and extensive usage of HP Quality Center for test management and defect management.
• Experience in Descriptive Programming for developing QTP Scripts.
• Extensively used Application Lifecycle Mgmt. (ALM) for QA activities. Also used Rally for business document mgmt. and status reporting.
• Extensively Experience in performing different kinds of testing like Functional Testing, GUI Testing, Backend Testing, Regression Testing, User Acceptance Testing, Black-box testing and Compatibility testing.
• Extensive experience in Data Base testing using TOAD, SQL-Developer and Aqua Data Studio for Oracle, MS SQL Server and DB2.
• Good knowledge and experience in performing DB conversion testing.
• Excellent experience in backend testing on Oracle & MS SQL Server and written SQL/PL SQL queries.
• Experience in testing Web Services using iTKO Lisa and SOAP UI tool.
• Good experience with version controls such as VSS (Visual Source Safe) and Clear Case.
• Good experience of working with various bug tracking tools like HP Quality Center, Rational Clear Quest and JIRA and a very good understanding of the Defect Life Cycle.
• Excellent working knowledge of UNIX and Shell Scripts.
• Experienced in working with business analysts, development groups in analyzing business specifications and in Working with other testers to resolve technical and end-user issues.
• Good Communication, Interpersonal skills and strong Team player with proficiency at time management, multitasking, able to meet deadlines and handle changing priorities.

TECHNICAL SKILLS:

Languages: C, C++, Java, XML, Shell Scripts, SQL, PL/SQL.

Databases and Tools: Oracle, MS SQL Server, DB2, TOAD, Aqua Data Studio and SQL-Developer.

ETL & Reporting tools: Informatica 8.6.1/8.x, SSIS and Cognos

Web Service Tool: SoapUI and iTKO Lisa.

Testing Tools: HP Quick Test Pro/UFT, HP Quality Center, JIRA, Rational Clear quest

SDLC: Agile & Waterfall

ECM/BPM Technologies: IBM FileNet P8 Suite, FileNet- Share Point Integration

Web Technologies: JDBC, Servlets, JSP, Flex, VB Script, Java Script, .Net, ASP

Application Servers: IBM Web Sphere, BEA Web Logic, Apache Tomcat

Operating Systems: UNIX, HP Solaris, Citrix and WINDOWS

Configuration Mgmt tools: VSS and Rational Clear Case

PROFESSIONAL EXPERIENCE:

Sr. QA Analyst

Confidential, Tallahassee, FL

Responsibilities:

• Design Systems Test strategies, review and understand the Product Backlog items, design and execute the test cases using Product backlog (PBI) and Business requirements.
• Performed Sprint level testing, Functional, Systems Integration Testing and Regression Testing.
• Good Experience in Agile methodology with SCRUM Process for the product development.
• Performed testing on multiple Sprints. Participate in Daily standup SCRUM meetings, Sprint Planning Sessions, Sprint Review and Sprint Retrospective Sessions.
• Extensively used UX (User Stories, Workflows and Mockups) design documents in designing and implementing the Test Scenarios.
• Reviews/QA Validation of the test scenarios with BA.
• Prepared and provided status summary reports to the management on system status, system changes, problems and potential impacts.
• Develop Tractability Matrix and Test Coverage reports using HP Quality Center (ALM) 11.
• Created and executed the Test Strategy, Test Cases and End to End Test cases for all the modules and stored in HP Quality Center (ALM) 11.
• Design and manage the sprint test schedule and communicate testing progress to Project group (Scrum Master, Product Owner).
• Collaborating closely with business analysts, developers and testing groups to drive uniform testing processes and standards.
• Defects review and co-ordination with Developers.
• Performed Functional Testing, Regression Testing, Integration Testing, Stabilization Testing, Sanity Testing, Database Testing/Back-end testing and User Acceptance Testing.
• Worked on Property (Personal Lines and Commercial Line) applications using Guidewire Products.
• Performed on various major functionalities like Policy Submissions, Change, Cancels, Reinstate, Rewrites and Renewals.
• I worked on various document integrations such as Ephesoft, Alfresco and Thunderhead.
• Performed Policy and Billing Center Integration Testing on various Billing Instructions.
• Extensive hands on experience with Advancing Dates (moving clock) for future dated testing, like Policy Change, Rewrite, Reinstate, Policy Status, Renewal etc. in PC; Payment Plans, Invoice, Invoice due, Disbursements, Delinquencies, Commissions etc. in BC.
• Extensively involved in E2E (End to End) testing to verify the data flow and data validation in each system like Policy Center, Billing Center.
• Worked on PC to BC Integrations and tested the New Submission, Changes, Cancellations, Reinstatements and Renewal Billing Instructions.
• Worked on legacy policy Conversion (Migration) process, which involves comparing the data, validations, rating, status between legacy and Guidewire PC.
• Performed web services testing using Soap UI to test the Xml requests and the responses for legacy policy migration process.
• Performed the working of the Soap UI as in whether the policy conversion request sent across to PC is actually responsive.
• Involved in Database testing by writing & executing SQL queries to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.
• Involved in writing of SQL queries in DB Tool Aqua Data Studio.
• Design and development of automation test scripts by VB Scripts to the identified Regression Test Cases in Quick Test Pro (QTP) tool and executed the scripts in Regression phase.
• Executed all Automated Test scripts using ALM (Test Lab) for Regression Effort.
• Involved in Production support.
• Prepare status summary reports with details of executed, passed and failed test cases through HP Quality Center(ALM) 11/Rally.
• Worked with developers by updating the defects and resolving them and tracking the status.
• Experience in Defect Tracking, Report generation and requirement tracking throughout the test life cycle using HP Quality Center (ALM) 11.

Environment: SOAP UI, Rally, HP Quality Center11, Quick Test Pro 11/UFT, Guidewire Billing, Policy and Claim Center, Java, Gosu, DB2, MS SQL Server, Ephesoft, Alfresco, Thunderhead and Windows 7 Professional.

Sr. QA Analyst

Confidential, Madison, WI

Responsibilities:

• Reviewed and understand the User Stories/business requirement documents of various functionalities.
• Design and execute the Test Plans and Test cases using User Stories/Business requirements. Performed Sprint level testing, Functional, Systems Integration Testing and Regression Testing.
• Identified & organized the overall plan for test data, strategy and also identify the Scope of testing within the context of each Sprint.
• Good Experience in Agile methodology with SCRUM Process for the product development.
• Performed testing on multiple Sprints. Participate in Daily standup SCRUM meetings, Sprint Planning Sessions, Sprint Review and Sprint Retrospective Sessions.
• Created Test Cases and developed Tractability Matrix and Test Coverage reports.
• Prepared and provided status summary reports to the management on system status, system changes, problems and potential impacts.
• Interacted with developers, Business & Management Teams and End Users.
• Worked on Property and Auto applications using Guidewire Products.
• Created Homeowner policies and also Auto policies like Family Car, Cycle, Misc Vehicles, Watercraft and Motor Home.
• Performed on various major functionalities like Policy Submissions, Change, Cancels, Reinstate, Rewrites and Renewals.
• Worked with different integrations like Rating Service, Vehicle Service, Policy Services and Document & Forms Services.
• Performed on different integration applications (Systems) like CDH (Customer Data Hub) and Apex (Agent Desktop Application).
• Performed various discounts and Coverage’s for all Auto Policies.
• Extensively involved in E2E (End to End) testing to verify the data flow and data validation in each system like Policy Center, Billing Center, CDH (Customer Data Hub) and Apex (Agent Desktop Application).
• Performed Policy and Billing Center Integration Testing on various Billing Instructions.
• Generate Operations for the given WSDL and EndPoint. Setup Filters and Assertions for web service and web testing to capture and validate the response. Create test steps to validate WSDL definition.
• Create web service test scripts using RawSoap Request method. Pass the required input values through the request based on different test conditions. Capture the web service response and test for valid expected data. Compare the web service response with baseline data.
• Executed the web services in different environments using iTKO LISA.
• Worked with developers by updating the defects and resolving them and tracking the status.
• Expertise in Defect Tracking and Report generation throughout the test life cycle using JIRA.

Environment: iTKO LISA 5.0.22, SOAP UI, Rally, Harvest, JIRA, Guidewire Billing and Policy Center, Java, Gosu, Oracle H2 Server, TOAD, MQ and Windows XP Professional.

QA Analyst/ ETL Test Consultant

Confidential, San Francisco, CA

Responsibilities:

• Review the Functional Requirement Specification (FRS), Product Design Document (PDD). Analyze the requirement and design documents for creating the Test Strategy.
• Prepared detailed Test Plans and Test Cases which specify testing overview and testing approach depending on the Business and Technical requirements.
• Extensively used HP quality center to write test cases, executing them and to prepare Requirement Traceability matrix.
• Utilized process-based test management system HP Quality Center for organizing test requirement's documents, test plans and test lab.
• Written Test Cases for ETL to compare Source to Staging and Target database systems and check all the transformation rules.
• Identifying duplicate records in the staging area before data gets processed.
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
• Tested the different sources such as Flat files, Legacy Flat Files, SQL server and Oracle to load into the Oracle data warehouse.
• Responsible for verifying various reusable ETL Transformations and Business rules which facilitate Daily & Monthly loading of data into a Common repository.
• Perform the data load activities based on mapping specification document and data load from source System to Target system.
• Validate the DW/ETL daily jobs using the Informatica Power Center tool to monitor the job execution process raise the defects accordingly if any failures after analyze the root cause.
• Validate the ETL load process to make sure the target tables are populated according the data mapping from Source (ODS) to target, validation Field to Field verification.
• Validated the Mappings Using Transformations like Expression, Router, Filter, Normalizer, Sequence Generator, Joiner, Lookup, Sorter and Aggregator.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down, Drill Up and Pivot reports.
• Involved in the test enhancements, issues tracking and issues resolution fixes in the production environment.
• Performed Functional testing on various Flex components including Form containers with validation, File Upload, Data grid, Panel max, minimizes functionality.
• Have good testing experience on Releasing documents/images from Kofax, KTM Pro to File Net 4.5/3.5 P8 environment.
• Experience in Testing FileNet components Content Engine, Application Engine, Process Engine, Component Integrator and Process Analyzer.
• Performed of Functional Testing, Regression Testing, System Testing, Sanity Testing, Database Testing/Back-end testing, Black-box testing, UI Testing, Cross Browser testing and User Acceptance Testing.
• As a part of Database testing, extensively used SQL queries to verify database table in the backend using SQL Developer.
• Involved in creating and executing SQL using SQL Developer to create test data and validate the results at the back end.
• Experience in Defect Tracking, Report generation and requirement tracking throughout the Defect life cycle using HP Quality Center.
• Worked with UNIX shell scripts.
• Involved in Production Planning and Implementation check list meetings / reviews.
• Involved in GO-NO-GO meetings and presented the Issues/Defects list to management.

Environment: Quick Test Pro 10.0, HP Quality Center10, Clear Case, IBM FileNet, Share Point, PA Reports, JAVA, J2EE, Ajax, XML, Oracle10g, Flex 3.4 Sdk, Flash Player 10, UNIX, Web Logic Server, Kofax, SQL Developer, Apache Tomcat Server and Windows XP Professional.

QA Tester

Confidential, Chicago, IL

Responsibilities:

• Analyzed the System Requirements, Functional requirements and Business Requirement Documents.
• Involved in the development and implementation of Test plans, Test cases, Test data and Test scripts according to requirements in the Use Case and Requirement documentation and Test execution on both Test Environment as well Production Environment.
• Attended meetings with Business Users, Business Analysts, and Developers.
• Involved in Estimation of the Testing efforts based on the duration and Risk Areas of the project.
• Performed Manual testing extensively using Positive and as well as negative scenarios.
• Developed test data depends on the Test Scenarios as per the functionality of the application.
• Involved in writing of SQL queries in DB Tool TOAD.
• Involved in Back-End testing for Oracle as a part of Parallel Test and written SQL queries to extract and validate the data.
• Proficient in performing of Functional Testing, Regression Testing, System Testing, Sanity Testing, Database Testing/Back-end testing, Black-box testing and User Acceptance Testing.
• Executed SQL queries to validate the Data tables, which hold the customer information using TOAD Tool.
• Design and development of automation test scripts by VB Scripts to the identified Regression Test Cases in Quick Test Pro (QTP) tool and executed the scripts in Regression phase.
• Automated the test scripts for the GUI, Functional and Regression testing using Quick Test Professional.
• Plan and Execution of Test Cases, Automated test scripts, Test Metrics and reporting bugs.
• Execution of automation test scripts in batches using Quick Test Pro Batch Runner.
• Expertise in Defect Tracking, Report generation tracking throughout the test life cycle using Rational Clear quest.

Environment: Quick Test pro (QTP), Rational Clear quest, Java, JSP, XML, EJB and Oracle10g, Web Logic Server, JavaScript, TOAD, Apache Tomcat Server and Windows 2000/XP/VISTA.

Technical Associate

Confidential

Responsibilities:

• Designed the efficient manual test cases based on analysis of Business Requirement documents, SRS, Functional Specs, Technical design documents, Use Cases, supporting documents.
• Writing test cases for testing the functionality of various modules (Olympia, CCC eBilling -Temporary Password Reminder, eBilling Admin Tool and eBilling Paper free Opt out).
• Performing Regression testing for various modules of Billing (F&F (Friends and Family), VMB (View my bill), PMB (Pay my bill), Agent Admin, CCRA (continuous card recurring authority), BTBA (BT Business analyst), OBP (One Bill Plus), PAB (Personal address book)) all releases in each environment (FT, and Live).
• Maintained Traceability Matrix to ensure all conditions are covered in the Test Cases.
• Executed SQL queries to validate the Data tables, which hold the customer information using TOAD Tool.
• Involved in Functional testing, Regression Testing, Data base testing, Sanity testing, DR testing, Post live testing, Compatibility testing.
• Worked on Agile Methodology framework with respect to the change in application requirements so as to achieve the target in stipulated time.
• Responsible for the execution of manual test cases.
• Performed Manual testing extensively using Positive and as well as negative scenarios.
• Involved in test data setup preparation for testing purpose as BT.com database is migrated from CSS to one view.
• Responsible for maintain System Test Cases from System Test Scenario Matrix and incorporated by using HP Quality Center.
• Responsible for defect management using HP Quality Center (defect logging, defect tracking, defect triaging, status updating and defect reports).

Environment: J2EE, JSP, Servlets, Java, Struts1.2, Oracle, TOAD, HP Quality Center, Windows 2000 Prof with IE 6.0 SP1.

Test Engineer

Confidential

Responsibilities:

• Designed the efficient manual test cases based on analysis of Business Requirement documents, SRS, Functional Specs, Technical design documents, Use Cases, supporting documents.
• Understanding the business requirements and developed test cases to test the complete functionality of the application.
• Maintained Traceability Matrix to ensure all conditions are covered in the Test Cases.
• Executed test cases and analyzed the test results.
• Responsible for performing Functional testing, Regression testing and sanity testing.
• Coordinating with on site persons regarding documents, requirements, and discussions about the functionality.
• Executed test cases before and after bug fixes for each build for User acceptance testing.
• Expertise in Defect Tracking and Report generation throughout the test life cycle using JIRA

Environment: EJB, JSP, JMS, Servlets, Java Script, JIRA and Oracle, Web logic server, WindowsNT/2000.