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.
• Strong experience in Guidewire Insurance Suite (PolicyCenter,BillingCenter, ClaimCenter).
• Hands on experience in Guidewire products like Policy and Billing Center Applications.
• 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.
• 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.

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, Brea, CA

Sr. ETL Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering. Responsible for understanding the ETL data mapping document.
• Tested UNIX shell scripts as part of the ETL Informatica process to automate the process of loading, pulling the data for testing ETL loads.
• Prepared Test Plan for the project.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Reported bugs and tracked defects using HP QC.
• Tested the web based application which was developed with the use of Guidewire Claim center tool for customer claim management system
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Involved in data warehouse testing by checking ETL Informatica procedures. Performed the tests in both the SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Integrating Guidewire Claim Center to Mainframe application for database conversion.
• Performed the Data warehouse Extract Transform and Load (ETL): source to target, utilizing Informatica Power center and Data Validation Option (DVO).
• Worked on functional Testing, Regression, Data driven testing in Both SOAP and Restful API.
• Strong ability in developing advanced and complex SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Involved in SOAP and Restful web services using SOAP UI.
• Tested several data migration application for security, data protection and data corruption during transfer
• Tested the ETL Informatica process for both before data validation and after data validation process.
• Integrating Auto Data and Property Data from CLUE to Guidewire Claim Center
• Analyzed the Data warehouse ETL Informatica DVO design documents to understand the logic
• Tested with Front-end functionality for the entire application
• Tested the data load process using the Informatica ETL tool.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Performed Functional Testing, System Testing, User Acceptance Testing (UAT) in Agile SDLC Environment
• Worked as liaison between support team, business and development team for resolving multiple issues during test execution and data loading.
• Highly experienced in various features of Micro Strategy like managing multiple projects, project migration and defining standards, procedures for development, production environment
• Worked with Data Conversion projects for testing data quality after migration.
• Used Teradata SQL Assistant for data retrieval and querying.
• Tested Micro strategy reports for Report layout, Attributes/Metrics, positions, Totals & Grand Totals, Drilling options, Metric Calculations, Drill Maps, and Security filters
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Written several UNIX scripts for invoking data reconciliation.
• Validated documented user requirements.
• Involved in extensive DATA validation using SQL queries and back-end testing. Validated business reporting requirements with internal and external customers.
• Used SQL for Querying the DB2 database in UNIX environment
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Validated the reports to make sure all the data is populated as per requirements.

Confidential, Indianapolis, IN

ETL Tester

Responsibilities:

• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Understanding integration requirements of Accurint from LexisNexis to GWCC to Guidewire Claim Center
• Worked closely with business during UAT testing to create defects found during UAT testing.
• Created temporary tables for validations after understanding the transformation logic.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Tested complex mappings using mapplets and reusable transformations.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
• Worked on testing of Integration Mapping between Guidewire PolicyCenter/Guidewire ClaimCenter and Guidewire PolicyCenter/Guidewire BillingCenter
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Involved in testing data reports. Written several SQL queries for validating the front-end data with backend.
• Conducted back to back meetings with developers and discussed about all open issues.
• Conducted test case reviews to ensure scenarios accurately capture business functionality.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports

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, 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.