SUMMARY

• Close to 7 years of diverse experience in Information Technology with emphasis on Quality Assurance for the implementation of User/Business/Functional requirements to enable the product as a defect free product. Expertise in (Manual/Automation) Testing of Client/Server, ETL, Business Intelligence, Mainframe and Web based applications.
• 7 years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications
• Experience using query tools for Teradata, Oracle, IBM DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Strong experience in Banking, Financial, HealthCare, Insurance, Education and Manufacturing domains.
• Extensive experience in MANUAL and AUTOMATED testing using automation testing tools, Test Management Tools (Mercury Quality Center, Test Director, Clear Quest) and Functional testing tools (Quick Test Professional, Win Runner, Rational Robot, Silk Test) and Performance testing tools (Performance Center, Load Runner).
• Represent QA in all phases of product development including requirement, Analysis, design, construction, testing, implementation, code reviews and support.
• Proficient in writing SQL queries to perform data driven tests and involved in front - end and back-end testing. Strong knowledge of RDBMS concepts. Developed SQL queries in Oracle databases to conduct DB testing.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos 8.0 Series and Business Objects XI R2
• Strong in writing UNIX shells scripting. Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Experience in working as a liaison between the team members and the manager.
• Expertise in writing SQL queries, PL/SQL Stored Procedures and Triggers
• Experience in testing/validating the Source, Stage and Target (End-to-End).
• Expert in analyzing the error caused to failure of the ETL load with reference to the log file and report them to the corresponding team to get it rectified.
• Strong knowledge of working with Data Marts (Star Schema and Snowflake Schema).
• Worked with PERL for file manipulations
• Converted SQL queries results into PERL variable
• Experience with Mentoring and Coordinating a team of QA resources, Identifying and Managing Risks, Estimating Work, Resource sharing between the projects, tracking project progress, Delivering projects as per the deadlines.

TECHNICAL SKILLS

ETL Tools: Data Stage 8.1/8.0/7.X/6.X (Manager, Designer, Director, Administrator), Parallel Extender, Data Mining,), EME, Data Profiler, SSIS, Ab Initio, (GDE 1.14, Co>Op 2.14)

Test Mgmt Tools: Test Director, HP Quality Center, Rational Quality Manager

Mercury Interactive: QuickTestPro9.5/9.2/8.0, WinRunner 9.2/9.0/8.0/7.5, LoadRunner9.2/9.0/8.0, TestDirector9.0/8.0/7.5, Quality Center9.0/8.2

IBM Rational Suite: Rational Performance Tester 8.0/7.0, Rational Clear Quest 7.1/7.0.1, Rational Clear Case 7.1/7.0.1/7.0.0

Bug Reporting: Rational Clear Quest, Test Director,, MS Access, Bug zilla.

Programming Languages: SQL, PL/SQL, T-SQL, XML, XSLT, PERL, Shell Scripting.

Operating Systems: Windows Vista/ XP/NT/2000, AIX UNIX, LINUX

Databases: Oracle 10g/9i/8i/7.3, MS SQL Server 6.5/7.0/7.5/2005, IBM DB2, Teradata V2R6

Web Development: HTML, XML, VBScript, Java Script, XSLT

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

SQL/ETL/ Data Warehouse Tester

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Create DataStage Parallel Jobs to extract, transformation and loading of the data using DataStage design toll in the parallel processing mode. .
• Created test plan and test cases from the business requirements to match the project’s initiatives in Quality Center.
• Work with source system personnel on source data delivery issues .Interacted with DBA for setting up test environment.
• Used DataStage to move data to the warehouse using the stored Procedure thereby enabling faster moment of data.
• Developed UNIX scripts and AUTOSYS scripts to load extract files in to staging tables using sqlldr.
• Executed SQL queries using TOAD to find useful test data to verify various functionalities of the application and also done the back-end verification.
• Tested PL/SQL Packages to transform/load the staging data into schema using business logic.
• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
• Performed database validation according to the business logic by comparing the source to the target in Spreadsheet.
• Interacted with developers & various members of team to discuss and resolve defects and their priorities.
• Written Complicated SQL queries in IBM DB2 for Update Dimension Tables, Export Data from Target tables etc.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Attended Bi-Weekly Defect Review and Defect Status meeting. Provide update to management on testing status and some other issues.
• Was involved in design part for Extracting data from different source systems into the target database using IBM Data stage Server 8.1.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Worked with Users to develop Test cases for user acceptance testing.
• Maintained the test logs, test reports, test issues, defect tracking using Quality Center.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA Report using Quality Center
• Perform Data Quality integrity testing (completeness, conformity, consistency, accuracy, duplicates).
• Used SQL for Querying the UDB DB2 database in UNIX environment
• Verified the data in DW tables after extracting the data from source tables by writing SQL queries using TOAD
• Tested SQL queries, PL/SQL scripts to validate the data and performance of the database.
• Understand business /transformation rules which are involved in developing the source to target mappings, write Complex SQL queries to reflect those rules and be able to validate the mappings by running these test scripts and checking if the data in target table populates correctly by writing complex SQL queries..

Environment: IBM Data Stage 8.1/8.0/7.X/6.X (Manager, Designer, Director, Administrator), Parallel Extender, Data Mining, OLTP, OLAP IBM DB2, SQL Assistant, BTEQ, FLOAD, FEXPORT, MLOAD, SQL Assistant 6.0, SQL Server 2005, MVS, COBOL II, ISPF, VSAM, Copy Books, JCL, HP Quality Center 9.2, SQL/PLSQL, Cognos 8.0, TOAD, XML, XSLT, XML Spy 2008, Korn Shell Scripts, UNIX, Windows XP

Confidential, Minneapolis, MN

Data Warehouse/ETL Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Write SQL queries to validate that actual test results match with expected results
• Check the naming standards, data integrity and referential integrity.
• Responsible for monitoring data for porting to current versions.
• Analyzed and tested various Hyperion reports for Hierarchies, Aggregation, Conditions and Filters.
• Checked the reports for any naming inconsistencies and to improve user readability.
• Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Used Clear Quest for defect tracking and reporting, updating the bug status and discussed with developers to resolve the bugs.
• Interacted with Business Analyst, Database Administrators, development team and End Users. Performed Load and Performance testing using Rational Performance Tester.
• Conducted Stress testing using Rational Performance Test.
• Conducted Performance testing under off load and peak load conditions.
• Lead test case review sessions
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Validated format of the reports and feeds.
• Effectively communicate testing activities and findings in oral and written formats.
• Worked with ETL group for understanding Ab Initio graphs for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Extracted certain column of data from a number to files using PERL.
• Used PERL for automating all the types of modules at a time and Responsible for testing the reports according to client’s requirement using Business Objects 6.5.1.
• Validated cube and query data from the reporting system back to the source system.
• Used Rational Clear Case for version controlling
• Extensively involved with backend testing by writing complex SQL queries.
• Worked closely with the development teams to replicate end user issues.

Environment: Oracle 9i/10g, SQL, PL/SQL,, Quick Test Pro 8.0, VSAM, COBOL II, Copy Books, Quality Center 8.0,Business Objects 6.5.1,Ab Initio (GDE 1.14, Co>Op 2.14), IBM Mainframe, PERL, TOAD, Rational Performance Tester 7.0, Rational Clear Quest 7.0.1,Rational Clear Case 7.0.

Confidential, NY

ETL/SQL Test Engineer

Responsibilities:

• Created Test Case documents in MS Excel template from the Test Plan, and the Business Requirements documents.
• Experience in ETL Data Warehousing, database testing using DataStage for Workflow process.
• Testing ETL sessions and PL/SQL scripts for multiple feeds and multiple LOBS’.
• Exported Manual Test Cases from MS Excel template directly to Mercury Test Director and executed 100% of the Test Cases in Test Director with Pass/Fail/Blocked status.
• Performed database integrity check using SQL and Unix Shell Scripts
• Updated QA Manager and Lead weekly with the testing status, which included Test Task Plan, Defect Management, and Test Metrics
• Executed SQL queries to verify the number of records and validated the referential integrity rules as per the design specifications.
• Verified correctness of data after the transformation rules were applied on source data.
• Coordinated execution of User Acceptance Testing, regression and integration testing with multiple departments.
• Identified appropriate test data in relevant source systems and incorporated this data into test scripts.
• Worked on DataStage Version Control Tool for Migrating jobs from one environment to another environment.
• Used Mercury Quality Center to document issues found during the test automation process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team
• Participated in frequently held Defect Meetings which included Project Management, QA, Development, and Business Line teams and submitted weekly defect and test status updates during the Defect Management meetings
• Performed Functional, Regression, Data Integrity, and User Acceptance Testing including GUI testing
• Executed test cases for data validation, link verification, and content verification.
• Scripts have been written for both Batch mode which will write results to the individual called test and Interactive (non-batch) mode which will write to the main test
• Performed the back end testing by using SQL Queries and verified the data integrity.
• Coordinated with the developers to resolve defects.
• Involved in documentation in order to maintain and run scripts for future enhancements.
• Participate in weekly meeting with the management team and walkthroughs.

Environment: Data Stage 8.0/7.X/6.X,Windows NT/XP/2000, XML, XSLT, XSD, Autosys, SQL Server 2000, Test Director, Clear Quest, MS Office Suite, SQL,PER

Confidential, Minneapolis, MN

ETL/SQL Test Engineer

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Developed separate test cases for ETL process (Inbound & Outbound) and reporting
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results
• Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation
• Involved in Manual and Automated testing using QTP and Quality Center.
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
• Defects tracking, review, analyzes and compares results using Quality Center.
• Participating in the MR/CR review meetings to resolve the issues.
• Defined the Scope for System and Integration Testing
• Document and publish test results, troubleshoot and escalate issues
• Preparation of various test documents for ETL process in Quality Center.
• Involved in Test Scheduling and milestones with the dependencies
• Functionality testing of email notification in ETL job failures, abort or data issue problems.
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule
• Created and executed test cases for ETL jobs to upload master data to repository.
• Responsible to understand and train others on the enhancements or new features developed
• Conduct load testing and provide input into capacity planning efforts.
• Provide support to client with assessing how many virtual user licenses would be needed for performance testing, specifically load testing using Load Runner
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Windows XP, Informatica Power Center 6.1/7.1, QTP 9.2, Quality Center 9.0, Load Runner7.0, Oracle 10g, Unix AIX 5.2.