SUMMARY

• Over 5 years of experience in manual testing on web based, Client/Server and data warehousing applications.
• Well - versed wif 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 the 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 wif Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies.
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Server 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

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

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

PROFESSIONAL EXPERIENCE:

Confidential, OH

ETL Tester

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

Responsibilities:

• Worked wif Business Analysts to define testing requirements to satisfy the 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 the Data Warehouse.
• Created Test Cases in Quality Center and mapped Test Cases to Requirements in Req Pro.
• Used the 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 the defects using Clear Quest and Quality Center and generated defect summary reports
• Prepared status summary reports wif details of executed, passed and failed test cases
• Interacted wif 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 wif 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 the mapping document indicating the 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 wif team members.
• Developing various Test Scripts, Test Execution using Quality Center based on the 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 the Data mart tables as per the business logic applied to the staging tables.
• Executed the test scripts against Teradata source and validated the rules according to mapping documentation.
• Testing and validation of the developed Informatica mappings.
• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
• Validated the source system data wif the staging data using SQL and Pl/SQL scripts.
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
• Expertise wif System Testing, Functional Testing, Regression Testing.
• Prepared Traceability Matrix wif requirements versus test cases.
• Identifying the 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 the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.
• Performed the 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 the data
• Tested different detail, summary reports and on demand reports.
• Tuned ETL jobs/ SQL queries to improve the system performance
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the 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 the 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 the Unix Environment using Shell Scripts.
• Created test plans and performed unit testing for the 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 the ETL process.

Confidential, Cincinnati, OH

Environment: Windows XP, ASP.NET, SQL Server and Quality Center V 10.0

QA Tester

Responsibilities:

• Developed and executed Test Cases for Functional, Regression, and System Testing.
• Extensively used Quality Center for executing test cases and logging defects
• Interacted wif developers on various issues relating to software defects.
• Interacted wif end users and managed requests for change
• Validating the reports by writing SQL queries using SQL Server.
• Conducted manual testing and report/track defects using bug tracking tool Test Director.
• Participating in team meetings to discuss work related issues, and progress reporting
• Responsible for daily and weekly status updates showing the progress of testing.