SUMMARY

• Around 7+ years of IT experience in Quality Assurance and Software Testing of various business applications in Client/Server environments and Data Warehousing solutions.
• Strong knowledge of SDLC and Software Test Life Cycle and highly proficient in SQA methodologies for Waterfall, Agile.
• Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases.
• Have solid experience on database query tools such as TOAD, SQL Navigator, and SQL Assistant.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Used Quality Center for defect tracking.
• Experience on UNIX commands and Shell Scripting.
• Experienced in Functional testing, Performance testing, Load testing, Integration testing, System Testing, Regression testing, Black Box testing, Stress Testing, Smoke Testing, Recovery Testing and GUI Testing.
• Strong experience in preparing documentation, preparing test environments, executing and analyzing the results.
• Involved in testing the batch jobs, using UNIX and Autosys.
• Have experience in testing reconcile (initial) and delta (daily) loads.
• Have tested several complex reports generated by Cognos, including dashboards, summary reports, master detailed, drill down and score cards.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Reports, and Weekly Status Reports.
• Experienced in using the Oracle SQL* Loader features for loading the data from Flat Files to Data Base tables for Bulk Loading.
• Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Confidential Quality Center/ALM, Clear Quest, TFS - Team Foundation Server, Rally.
• Expert in writing complexSQL queries for back-end testing.
• Experience in interacting with Clients, Business Analysts, UAT Users and Developers.

TECHNICAL SKILLS

QA Methodologies: Iterative, Agile, Waterfall and Spiral Methodology

QA Tools: Quality Center, Test Director

IBM / Rational: Clear Quest, TFS - Team Foundation Server

ETL Tools: Informatica Power Center 8.x/7.xAb Initio 2.1.x, Data Stage 7.x/8.x

BI/Reporting Tools: IBM Cognos, Business Objects BOXI, SSRS, Micro Strategy

DBMS Tools: TOAD, Rapid SQL, SQL Developer, SQL Navigator

Operating Systems: Microsoft Windows - Vista, XP, 2000, NT 4.0, OS/2

UNIX: Sun Solaris, Confidential -UX

Databases: Oracle 10g, 9i, 8i, Sybase

Microsoft: MS Access, SQL Server 2005/2008

IBM: DB2, DB2/UDB, Teradata V2R6, V2R5, Hadoop

Languages: SQL, PL/SQL UNIX Shell Scripts, VB Script, COBOL, Java, CVersion Control Tools Clear Case, DOORS, Requisite Pro

PROFESSIONAL EXPERIENCE

Confidential, Boston MA

Sr. ETL QA Tester

Responsibilities:

• Analyzed the Requirements from the client and developedTest cases based on functional requirements, general requirements and system specifications.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in Confidential Quality Center
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Analyzed the requirements for the project from DOORS requirements/version control tool.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Verified the logs to identify the errors occurred during the ETL execution.
• Written several complex SQL queries for data verification and data quality checks.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.
• Tested theETLInformatica mappings and otherETLProcesses (DW Testing).
• Effectively coordinated with the development team for closing a defect.
• Tested Cognos reports to check whether they are generated as per the company standards
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
• Have tested reconcile and incremental ETL loads for the project.
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• Exclusively used test plan module to write and test lab module to execute the test cases in Confidential Quality Center/ALM.
• Exclusively used requirement module for requirement and defect module for entering the defects in Confidential Quality Center/ALM.
• Involved in testing the batch programs by using the Autosys tool.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
• Tested data migration to ensure that integrity of data was not compromised.
• Involved in validating SSIS and SSRS packages according to data mapping specifications.
• Wrote complex SQL queries for extracting data from multiple tables and multiple databases.
• Execution flows and Loading data to Netezza Data mart through NZLOAD utility.
• Used Rational Clear Quest as defect tracking tool.
• Before the Load is accepted to test, have performed the smoke or shake-out test.
• Validated various transformations of SSIS data flow and control flow.
• Developed UNIX Shell Scripts for scheduling variousdata cleansingscripts and loading process.
• Involved in testing the Cognos reports by writing complex SQL queries
• Provided the management with weekly QA documents like test metrics, reports, and schedules.

Environment: Oracle 11g, Informatica Power Center 9.1 (power exchange, Informatica DVO), Clear Case, Cognos 8.0 Series, Teradata SQL Assistant, Clear Quest, SQL, PL/SQL, TOAD, UNIX, TFS, Putty, SharePoint, Flat files, XML files, DB2, Netezza, Confidential Quality Center/ALM, Autosys, SQL Server 2008.

Confidential, Orange County, CA

Sr. ETL QA Tester

Responsibilities:

• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.
• Worked with business team to test the reports developed in Cognos
• Responsible to translate business requirements into quality assurance test cases.
• Review of test scenarios, test cases and Data warehouse Test Results.
• Developed test scripts using SQL queries to validate data.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Testing the ETL data movement from Oracle Data mart to Netezza Data mart on an Incremental and full load basis.
• Responsible in testing Initial and daily loads of ETL jobs.
• Interacted with design team to decide on the various dimensions and facts to test the application.
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports andSQAReport.
• Manually tested the applications and handled Test Cases through Test Management tool Quality Center/ALM.
• Analyzed Test Results and generated Defect Reporting and tracking via Quality Center/ALM 11. Consolidated and presented regular updates to project team management.
• Generated Test Execution and Defect Summary reports from Quality Center to the management and Product owners
• Involved in testing the Cognos reports by writing complex SQL queries
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Executed automated test scripts using QTP for Regression testing.
• Created test cases and Scripts to test the Performance of the application using Load Runner.
• Reviewing the test activities through daily Agile Software development stand-up meetings.

Environment: Confidential Quality Center/ALM, Informatica 8.6.1/8.1, Cognos 7 Series, Rational Clear Case, Rational Clear Quest, Teradata SQL Assistant, Teradata V2R6, Rational RequisitePro, Netezza, Autosys, Rally, TOAD, QTP, Perl, Putty, Web logic, Oracle 11g/10g, QL Server 2005, SSIS, SSRS, TIBCO, PL/SQL, Linux, Win XP

Confidential, Westfield Center OH

ETL QA Tester

Responsibilities:

• Analyzed business requirements and module-specific functionalities to identify test requirements and formulate an effective master test plan.
• Responsible for review of Functional Requirement Specification and System Design Specification documents for testing.
• Used DOORS for reading/analyzing the requirements for the project.
• Performed extensive manual testing on critical functionalities of the application.
• TestedETLmappings to extract and load data from different databases such as Oracle, SQL Server and flat files and loaded them in to Oracle.
• Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
• Involved in running various informatica workflows and mappings to validate them according to functional specifications.
• Used Rapid SQL tool to query the DB2 data and verified the results.
• Tested reports in Cognos using Analysis studio, Report studio and query studio.
• Experienced in analyzing the issue by checking the log files in the AIX environment.
• Used Mercury Quality Center for Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result
• Extensive querying using TOAD to run SQL queries and monitor quality & integrity of data.
• Actively participated in creating requirements Traceability matrices and Test plans
• Performed Unit and functional testing for all the Mappings and Sessions.
• Implemented automated Processes & scheduling using Autosys.

Environment: Informatica, Oracle 9i, SQL Server 2005, SSIS, SSRS, SSAS, DOORS, SQL, PL/SQL, Autosys, TOAD, IBM AIX, Teradata SQL Assistant, Teradata V2R6, MS Access, DB2, Rapid SQL, Cognos, Unix, TIBCO, Mercury Quality Center

Confidential, Georgia, GA

QA Analyst

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Created test data for testing specific Membership functionality..
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Assisted in System Test and UAT testing scenarios as required
• Created user defined functions to test the specific test cases for windows applications using QTP.
• Extraction of test data from tables and loading of data into SQL tables.
• Design and build efficient SQL queries, analyze query cost comparison, use indexes efficiently
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Used Quality Center for Bug reporting, tracking & generation of Test Metrics
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Informatica 7.x, MVS, UNIX (K-Shell Script),Agile, Quality Center, QTP, Oracle, SQL Server 2005, DB2, Business Objects, Windows 2000 Pro, SOA, SOAPUI, XML, XSLT, XSD, Rapid SQL, PL/SQL, TOAD, Dat Files, XML Files, AutoSys