SUMMARY

• 7 years of experience in IT Testing.
• Well versed in Software Development Life Cycle and Software Testing Life Cycle
• Experience in software development methodologies including both Agile and Waterfall models
• Expertise in manual testing includes Requirements Analysis, writing Test plans, Test Cases and Requirements Traceability Matrix.
• Expertise in automated testing using Quick Test Professional (QTP) in performing Smoke Test, Regression Test and Functional Test
• Extensively worked in all phases of testing includes Functional, System, Regression, Sanity, Ad - hoc, Smoke, Negative and Build Acceptance
• Proficient in using SQL, PL/SQL and VB Script
• Having well experienced in test management tools Quality center and TORO
• Good experience with Automation Testing Tools using Quick Test Professional (QTP)
• Experience in Database Management System.
• Create and execute SQL queries to retrieve the data from database
• Analyzed business requirements, software requirement specification to create test plan and test case from manual and automation testing
• Experience in using Informatica for Extracting, Transforming and Loading data
• Developed and executed SQL Statements to check for data integrity in Oracle database.
• Having experience in writing test cases, Test Case Execution, Generate the Test Reports
• Experience in execution of test cases and monitor all problems detected during execution and track the issues through Defect tracking systems i-e Quality Center and ETrack ( Confidential Internal Tool).
• Experience in creating the Test data for execution
• Comfortable working as a member of integrated team as well as independently.
• ISTQB(International Software Testing Qualification Board) Certified Tester - ISTQB Fundamentals in 2011

TECHNICAL SKILLS

Operating Systems: UNIX and Windows

Bug Tracking Tool: HP Quality Center, ETrack, Toro

Tools: & Technologies: Informatica, QTP, SQL Developer, SOAP UI and WEB servicesIBM Database Studio, SQL

PROFESSIONAL EXPERIENCE

Confidential, Torrance, California

QA - Test Engineer /ETL Tester

Responsibilities:

• Actively participated in Requirement gathering meeting
• Responsible for writing test scenarios for the assigned modules and testing topics by using black box technique.
• Involved in analyzing the user requirements by interacting with Business Analyst, developers, business usersand executed the test scripts manually.
• Developed and executed SQL Statements to check for data integrity in Oracle database.
• Running Jobs in Informatica for extracting the data from Database to Testing region to make the data available for Testing
• Testing the ETL Mapping documents according to the Business Requirement.
• Extensively involved in writing & execution of SQL statements for back-end testing
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Involved in end to end Testing, Integration Testing, Functional Testing, and Regression Testing.
• Create and execute the SQL queries to insert and retrieve the data from database
• Validate the expected data in Database
• Involved in Manual Test Case Preparation and Test Case Execution using Quality Center
• Designed and developed automation test scripts using Quick test Professional and managed testing activities using HP Quality Center.
• Developed and exported test cases to Quality Center and mapped all test cases to the business requirements/rules
• Defect reporting and tracking the status of the defect in Quality Center
• Responsible for Daily status to show the Progress of the automation testing effort
• Interact with the third parties who provide services that need to be integrated with the telematics unit
• Monitor all problems detected during execution and track the issues through Defect tracking systems i-e Quality centre
• Oversee all aspects of testing and re-evaluate after each iteration on how to improve process
• The testing module we are being incorporated is Agile process
• Involved in defect tracking, reporting and coordination with various groups from initial finding of defects to final resolution

Environment: Informatica, SQL Developer, Telematics control unit environment, IBM DB2 studio, Quality Center, XML, SOAP UI and Web Services, QTP.

Confidential, Somerset, NJ

QA-Test Engineer/ETL Tester

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 and reviewed test cases source to target mappings .
• Performed Database Validation and manipulations using SQL
• Write and execute SQL queries to validate actual test results and match expected results
• Performed Sanity testing on the application to decide whether to accept or reject the build.
• Responsible for Validating Staging Data before and after ETL Data loads
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs
• Created manual test cases and identified the test cases to automate
• Testing the ETL Mapping documents according to the Business Requirement.
• Involved in Manual Test Case Preparation and Test Case Execution using Quality Center
• Extensively used test management tools like Quality Center to carry out test case documentation, execution, and defect logging.
• Developed and exported test cases to Quality Center and mapped all test cases to the business requirements/rules
• Defect reporting and tracking the status in QC and Prepared various QC reports for meetings
• Prepared the documents related to the framework and coding standards
• 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 automation testing effort.
• Played a key role in process improvement and innovative idea generation.
• Involved in detailed test analysis and summary report preparation.
• Involved in defect tracking, reporting and coordination with various groups from initial finding of defects to final resolution.

Environment: Informatica, Oracle, Windows, XML, Quality Center, SQL Developer, UNIX, QTP

Confidential

QA-Test Engineer

Responsibilities:

• Each Customer issue will be considered as a separate project. So there will be dynamic changes in the work.
• Involved in preparation of Test cases based on the new features added in the Confidential Products and Tools - SymNRT, SymNRA
• Collect the reviews about the Confidential products from Amazon and CNet sites
• Performed Patch Testing: A patch is a small piece of software designed to fix problems with or update a computer program or its supporting data. This includes fixing security vulnerabilities and other bugs/enhancements, thereby improving the usability or performance. Patch consists of Data and configuration files.
• Patch Posting: Posted the patches to CRT server for patch testing.
• Executed the Build Acceptance testing for the Confidential Products - Norton Antivirus, Norton Internet Security and Norton 360.Also for Confidential support tools.
• Created 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.
• Log defects and retest the defects on new build
• Updated the test result in test case management tool - TORO as per the Confidential norms.
• Raised the defect in defect tracking tool - Etrack. Collect the necessary error logs and snapshots.
• Involved in defect tracking, reporting 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
• Had given Knowledge Sharing session on STAF-Software Testing Automation Framework tool.
• Also performed Ad-hoc, Regression testing and added the Ad-hoc test cases for feature testing.
• Coordinating with Clients regarding clarifications

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

Confidential

QA-Test Engineer

Responsibilities:

• Developed Test Cases and Test Matrix.
• Developed and executed Test Cases to perform Regression testing using different operating system and browser combinations.
• Performed Functional Test and Pre Acceptance Test.
• UsedSQL queriesto run Comparison testing to compare data in database and data displayed on front-end.
• Executed alltest casesin the plannedtest cyclesand log and track defect resolution for test cases.
• Implemented Regression Tests for every modified build.
• Performed Positive and Negative testing for this application.
• Worked closely with developers and other staff members to form a unified team.

Environment: Win2000, IE 6.0, SQL Server