SUMMARY

• 7 years of experience as Sr.QA Engineer and QA Engineer involved test design, test development and implementation of test procedures in manual and automation testing.
• Expertise in ETL testing for a Data Warehouse build projects using Informatica with Oracle and DB2 connections.
• Expertise in manual testing with Requirements Analysis, Test plan preparation, Test script development, Results documentation and Traceability Matrix.
• Experienced in automated testing using Quick Test Professional (QTP)
• Designed and Developed Automation Framework for the commercial Banking application - TIGER and Honda web application for enrolling new customer
• Experience in working with open source toolsSelenium (Selenium IDE, Selenium Web river),TestNg,Eclipseand preparation of automation test framework.
• Experience in testing web services using SOAP UI tool
• Experience in testing the ETL tool Informatica Mappings, Sessions, Workflows and tasks.
• Tested various maps for Extraction of Data from various source systems and loading into Target SQL server Data warehouse.
• Understanding the Data warehouse Concepts/ETL functionality built inInformatica.
• Experienced in test management and defect tracking tools HP Quality center/ALM(Application Lifecycle Management) and TORO
• Extensive experience in developing SQL queries using SQL Developer, TOAD and IBM Data Studio to validate actual test results
• Report generation and validation in OBIEE(Oracle Business Intelligence Enterprise Edition)Reporting Tool
• Experience in test data creation and validation using SQL in Oracle database
• Developed and executed SQL Statements to check for data integrity in Oracle database.
• Proficient in writing VB Script for test script development in QTP
• Well versed in Software Development Life Cycle and Software Testing Life Cycle
• Experience in software development methodologies including both Agile and Waterfall models
• Extensively worked in all phases of testing includes Functional, Regression, Ad-hoc, Sanity/Smoke, Negative and User Acceptance Testing
• Comfortable working as a member of integrated team as well as independently

TECHNICAL SKILLS

Tools: & Technologies: Informatica 9.1/8.6, OBIEE, SQL Developer, TOAD, IBM Data Studio Selenium IDE & Web driver, QTP V10, SOAP UI and WEB services

Languages: SQL, Java - Basics

Databases: Oracle, SQL Server

Test Management: HP Quality Center/ALM 11.x, TORO/ETrack

Operating Systems: UNIX and Windows

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr.QA Engineer

Responsibilities:

• Extensive experience in smoke testing, functional testing, regression testing, back-end testing and browser compatibility testing on Windows.
• Documenting the test scripts in HP ALM, mapping the business requirements/rules to the test scripts and updating test progress
• Tested multi browser compatibility on Firefox, Chrome, IE and Opera by using Selenium Web Driver for TIGER application.
• Used Firebug Tool to identify the Object’s id, Name, XPath, link in the application.
• Prepared and Execution of test scripts using Selenium Web Driver and added annotations to the test (selenium)
• Recorded and plays back test in Fire fox using Selenium IDE.
• Developed and maintained automated regression test cases in Selenium Web Driver using Java programming language.
• ConductedFunctionalandRegressiontesting of the application usingSelenium.
• Engaging with the business analyst to understand the requirement for sourcing, provisioning, data quality reporting, etc,.
• Developing test scenarios based on the data element mapping specification and other supporting documents
• Documenting the test data requirements and requesting the environment management team to load the data
• Checking for the test data availability and integrity in source database executing SQL queries
• Validating the file feeds for layout conformance and data issues using the excel spreadsheets
• Executing the Informatica Workflow using Informatica Workflow Manager
• Tracking workflow progress and status Informatica Workflow Monitor and troubleshooting environment and data related failures using session logs.
• Test ETL maps correctly move data from Source to target.
• Experience in testing the ETL tool Informatica Mappings, Sessions, Workflows and tasks.
• Validation of the data loaded in Target Oracle stage and warehouse tables executing SQL queries using Toad to check whether the data is transformed correctly based on the Business Rules and without any data loss or corruption.
• Extensively involved in writing SQL queries to pull the data from Data warehouse and check for data validation
• Comparing the loaded data to reference dataset if available
• PerformedUATtesting in theUATenvironment prior to notify LOB to provide the Sign-Off for Production Implementation.
• Participated in team meetings, conference meetings with various vendors to understand and meet their expectations.
• Defect reporting and tracking the status of the defect in ALM
• Creating the traceability matrix for the requirements and the test scripts
• Responsible for Daily status reporting of testing progress

Environment: Informatica Power Center 9.1, Oracle, SQL Server, DB2, Toad, IBM Data studio, CSV files, Selenium Web driver and TestNG, Eclipse IDE, Mozilla Fire Bug, Google chrome, IE 7,8, Firefox, ALM/QC 11.5

Confidential, Torrance, California

QA Engineer

Responsibilities:

• Participating in Requirement gathering meeting and prepare the test plan.
• Developing test scenarios for the assigned modules based on the Use case document and SRS document and data element mapping documents
• Documenting the test scripts in HP ALM, mapping the business requirements/rules to the test scripts and updating test progress
• Documenting the test data requirements and requesting the environment management team to load the data
• Checking for the test data availability and integrity in source DB2 database executing SQL queries using IBM DataStudio.
• Executing the Informatica workflow in workflow manager and troubleshooting environment and data related failures using Informatica Workflow Monitor session logs.
• Validation of the data loaded in Target Oracle Data warehouse executing SQL queries using SQL Developer to check whether the data is transformed correctly based on the Business Rules and without any data loss or corruption.
• Extensive Backend testing by writing Complex SQL Queries.
• Involved in generating a report/analysis (Eg. Vehicle Contact/Incident history Report)based on the business requirement using OBIEE(Oracle Business Intelligence Enterprise Edition) Tool
• Tested multi browser compatibility on Firefox, Chrome, IE and Opera by using Selenium Web Driver.
• Developed and maintained automated regression test cases in Selenium Web Driver using Java programming language.
• ConductedFunctionalandRegressiontesting of the application usingSelenium.
• Prepared and Execution of test scripts using Selenium Web Driver and added annotations to the test (selenium)
• Recorded and plays back test in Fire fox using Selenium IDE.
• Used Firebug Tool to identify the Object’s id, Name, XPath, link in the application.
• Testing the Web Service using SOAP UI tool, providing the input data in request XML and validating the output in response XML
• Interact with the third parties who provide services that need to be integrated with the telematics unit
• Have conducted User Acceptance Test(UAT)with business users and customers and wrote issues log based on outcome of UAT.
• Kept track of the bugs/defects, decided their priority and then assigned them to different developers using standard Excel spreadsheet and defect module in Quality Center.
• Participated in team meetings, conference meetings with various vendors to understand and meet their expectations.

Environment: Informatica PowerCenter 9.1, Oracle, DB2, SQL Developer, IBM Data studio, Telematics control unit environment, OBIEE Reporting Tool, ALM/QC 11.5, SOAP UI and Web Services, Selenium Web driver and TestNG, Eclipse IDE, Mozilla Fire Bug, Google chrome, IE 7,8, Firefox

Confidential, Somerset, NJ

QA Engineer

Responsibilities:

• Involved in gathering critical business requirements from Business Analysts and development team
• Analyzed application design document, Use Case document and prepared test cases and test plan
• Converted Business requirements and design documentation into test design products: Test Scenarios, Test Cases and Test Scripts
• Developed the various test cases based on the business requirement to validate the source to target mappings.
• Testing the ETL Mapping documents according to the Business Requirement.
• Worked with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation (detecting and rejecting bad data) and actual ETL(Informatica) functionality (properly processing good data, i.e., transformations)
• Running Jobs(Workflow) in Informatica workflow manager for extracting the data from Database to Testing region to make the data available for Testing
• Verified the job status(Success or Failed) in Informatica Workflow Monitor
• Write and execute SQL queries to validate actual test results and match expected results in target DB without any data loss and data corruption
• Responsible to check the data is transformed correctly based on the Business Rules into the Data warehouse
• Performed Database Validation and manipulations using SQL
• Created manual test cases and identified the test cases to automate
• Created a report/analysis based on the business requirement and used column properties. Checked against the Database using OBIEE
• Extensively used test management tools like Quality Center to carry out test case documentation, execution, and defect logging.
• Defect reporting and tracking the status in QC and Prepared various QC reports for meetings
• Prepared test data as per design of test cases and executed and logged the defects
• Responsible for Daily status to show the Progress of the testing effort.
• Involved in detailed test analysis and summary report preparation.

Environment: Informatica 8.6, Oracle, OBIEE Reporting Tool, Windows, Unix, Quality Center, TOAD, QTP V10

Confidential

QA Engineer

Responsibilities:

• Collection of the reviews and issues reported for Confidential products from Amazon and CNet sites
• Preparation of Test cases based on the reported issues and new features added in the Confidential Products and Tools - SymNRT, SymNRA
• Execution of regression testing to capture the before and after patch view of the functionalities not modified but impacted by the patch planned.
• Executing the Build Acceptance testing for the Confidential Products - Norton Antivirus, Norton Internet Security and Norton 360.Also for Confidential support tools.
• Patch Posting: Posted the patches to CRT server for patch testing.
• Creation of test cases for Ad-hoc testing, Negative testing and Regression testing
• Executed Build Acceptance testing, Functional, Sanity testing of the product
• Executed the test case that related to all the components in Confidential Products across windows Operating System with different languages.
• Track test execution progress and capture the test result in test case management tool - TORO as per the Confidential standards.
• Logging and tracking the defect in defect tracking tool - Etrack, with the necessary error logs and snapshots.
• Reporting execution metrics and coordination with various groups from initial finding of defects to final resolution
• Coordinate with Base team to get the information about the product and test cases
• Plan and Conduct project induction to the new members in the team

Environment: Windows Xp, vista, Win 7, Etrack (Defect Management Tool), Toro(Test Case Management Tool) and Ghost Images of the Os.