SUMMARY

• Around 6 years of experience in manual testing on web based, Client/Server and data warehousing applications.
• Well - versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Professional experience in Integration, Functional, Regression, System Testing, UAT Testing, Black Box and GUI testing.
• Experience in Web based applications like online banking, transactions applications.
• Experience in SQL scripting
• Sound Knowledge in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Tested teh ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Experience in creating Requirement Traceability Matrix (RTM) documents.
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Experience in Automation using Mercury Interactive Tools such as Win Runner, QTP, Load Runner and Test Director.
• Experience in using Bugzilla, Test Director and HP Quality Center for Bug Tracking and Defect Reporting.
• Experience in working with Software Development team in resolving Defects, presenting teh Defect Status reports, resolving requirement, and observed design inconsistencies.
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Sever using SQL, PL/SQL for data integrity.
• Strong working experience in Windows NT/2000/XP and UNIX environments
• Clear understanding of business procedures and ability to work as an individual and as a part of a team.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/2000/NT/XP, UNIX, Linux

o/Languages: C, C++, Java, SQL, PL/SQL, UNIX Shell Scripting

Testing Tools: WinRunner 8.2, QTP9.2, Load Runner

Bug Reporting: Mercury Test Director 8.0, HP Quality Center11.0

Databases: Oracle 9i/10g/11g, SQL Server 2005/2008

ETL Tools: Informatica Power Center 8/7.1.2/5.1.1/5.0.

Database Tools: TOAD 4.5, SQL Navigator 4.0Web Design HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

ETL Tester

Environment: HP Quality Center, Oracle, Informatica, SQL, UNIX, Quick Test Pro 8.0, Test Director, Windows NT/2000.

Responsibilities:

• Worked with Business Analysts to define testing requirements to satisfy teh business objectives.
• Involved in gathering requirements and analysis for applications.
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes..
• Involving in Functional Testing & Regression Testing
• Performed Integration, End-to-End, system testing
• Used Informatica as an ETL Tool for Developing teh Data Warehouse.
• Created Test Cases in Quality Center and mapped Test Cases to Requirements in Req Pro.
• Used teh Informatica for extracting, tr Performed Integration, End-to-End, system testing.
• Involving in Functional Testing & Regression Testing ansforming, integrating and loading data into data warehouse database.
• Involving in writing complex SQL queries to verify data from Source to Target.
• Performed data validation testing writing SQL queries
• Tracked teh defects using Clear Quest and Quality Center and generated defect summary reports
• Prepared status summary reports with details of executed, passed and failed test cases
• Interacted with developers, Business & Management Teams and End Users
• Participated in regular project status meetings related to testing

Confidential ., Jersey City, NJ

ETL Tester

Environment: HP Quality Center, Informatica, Oracle10g, QTP, SQL, PL/SQL, DB2, SQL*Plus, UNIX

Responsibilities:

• Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
• Responsible for reviewing Functional specs, user documentation and use cases and developing manual test cases out of it.
• Responsible for planning and directing Quality Assurance and Software change control policies.
• Study and analysis of teh mapping document indicating teh source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
• Coordinated in setting up Test Environments and Test Plan needs with team members.
• Developing various Test Scripts, Test Execution using Quality Center based on teh Functional Specifications.
• Executed Test Cases using positive and negative data in Quality Centers Test Lab and reported results and defects using Quality Centers Defects tool.
• Involved in validating teh Data mart tables as per teh business logic applied to teh staging tables.
• Executed teh test scripts against Teradata source and validated teh rules according to mapping documentation.
• Testing and validation of teh developed Informatica mappings.
• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
• Validated teh source system data with teh staging data using SQL and Pl/SQL scripts.
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
• Expertise with System Testing, Functional Testing, Regression Testing.
• Prepared Traceability Matrix with requirements versus test cases.
• Identifying teh defects and developed Defect Tracking report using Mercury Quality Centre which involved Bug life cycle.
• Provided daily and weekly status reports.

Confidential . Sacramento, CA

ETL Tester

Environment: Quality Center 9.0, Informatica Power Center 7.1.3/8.1, Ms Excel, Oracle 10g/9i, SQL, PL/SQL, UNIX, Windows 2000

Responsibilities

• Involved in understanding teh Requirements of teh end Users/Business Analysts and Developed Strategies for ETL processes.
• Performed teh Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Experience in ETL Data Warehousing, database testing using Informatica for Workflow process.
• Prepared extensive set of validation test cases to verify teh data
• Tested different detail, summary reports and on demand reports.
• Tuned ETL jobs/ SQL queries to improve teh system performance
• Worked as ETL Tester responsible for teh requirements / ETL Analysis, ETL Testing and designing of teh flow and teh logic for teh Data warehouse project.
• Processed a query to update a field in an Oracle database, to ensure that debt payments are allocated.
• Performed Functional Testing and Back-end Testing using teh database comparable results Manually
• Worked on Informatica Power Center 7.1.4 tool - source analyzer, warehouse designer, mapping designer, workflow manager, mapplets, and Reusable Transformations.
• Extensively worked in teh Unix Environment using Shell Scripts.
• Created test plans and performed unit testing for teh Informatica mappings.
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Involved in functional, exploratory and Integration testing.
• Performed Data validity testing for reports and feeds based on client's requirement.
• Created an induction manual for teh ETL process.