SUMMARY:

• 8+ years of IT experience in Quality Assurance for ETL, Business Intelligence, Data Warehousing, Web based, Client/Server applications using Manual and Automated testing tools.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
• Gathered and articulated business requirements in order to oversee the development of test plans and test scripts.
• Extensive experience with test management and test automation tools like Quality Center Test Director, Quick Test Professional, and Rational Clear Quest
• Extensive experience in ETL and BI testing for many data extractions and data migration projects.
• Well versed with SQL, PL/SQL and can write complex SQL queries to validate the data conditions against any database including Sybase, Teradata, SQL Server, DB2 and Oracle
• Proficient in development, execution, maintenance of Test Plans, Test Cases, Test Scripts, Test Specifications, Test Scenarios and Traceability Matrix
• Solid analytical and dynamic troubleshooting skills
• Experience in complex Manual and Automation Testing of GUI and functional aspects of the client - server and web based applications in all phases of SDLC
• Experience in Functional, Regression, GUI, Usability, Integration, Exploratory, Smoke, Backend, ADHoc, Load, Performance, Black Box and White Box Testing
• Experience in Mainframe Testing
• Proficient in SQL queries.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• All testing engagements completed within project timelines and consistently met live-date project deadlines.
• Experience in writing test plans, defining test scenarios and test cases, developing and maintaining test scripts based on business and functional requirements, documented all phases of QA process.
• Strong in Web application testing and understand architecture in terms of functionality.
• Good experience in Authoring and Reviewing test cases.
• Involved in the Implementation of QA testing Process, and involved in documentation of Test Scenarios, Test Cases, and Test Scripts for Various Applications.
• Excellent Communication, Analytical and Interpersonal skills.

TECHNICAL SKILLS:

Database: Oracle, SQL Server 2005/2008, IBM DB2, Teradata, Sybase

Change Mgt Tools: Test Director 8.0, Quality Center, Rational Clear Quest

Data Warehouse Tools: Informatica, SSIS, MS DTS Packages, Ab Initio, Data Stage

Functional Test Tools: WinRunner 7.0, Quick Test Pro 8.2/8.0, Load Runner 8.0

BI Tools: Cognos 8.0 Series & Business Objects

Languages: PL/SQL, T-SQL, SQL, XSLT, Visual Basic, PERL, Shell Scripting

Office Tools: MS Office Suite, MS Project, Microsoft Share Point

Operating System: UNIX, LINUX, Windows, MS-DOS

Rational Tools: Requisite Pro, Clear Case, Clear Quest, Manual Tester

Standards: VSTF 2008, METAL, SQL Server Analysis Server

Tools: TOAD 9.2, Win SQL, Teradata SQL Assistant, SSAS, SSRS, XML Spy 2010

Web Technologies: XML, HTML, JavaScript, VBScript

PROFESSIONAL EXPERIENCE:

Confidential, Loss Angles, CA

Sr.ETL/QA Tester

Responsibilities:

• Analyzed business requirements, system requirements, and data mapping requirement specifications interacting with client, developers and QA team.
• Executed the Batch job in Autosys and validated the data.
• Worked on the Functional and Integration testing
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
• Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing.
• Prepared the guides for UAT
• Involved in Unit testing, Functional and Integration testing of Informatica mappings.
• Logged the defects in the Quality center
• 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
• Involved in coordinating and preparing Validation Test Plans, Test Methodology and Test cases as per Functional and Business requirement for System/Functional Test Specification and Unit/Integration Test specification set by the SOP's, Best practices, policies, and procedures of the company and FDA regulations
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Trained the users for the User Acceptance Testing (UAT) and explained about each link, tab and search functionalities to the users.
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD
• Generated testing reports and metrics, trend graphs according to the test plan
• Performed the data validation once the Batch Job execution is completed
• Involved in rigorous meetings with offshore testing team and DWH Lead to plan and implement the testing efforts.
• Involved in testing the UI applications.
• Extensively involved with backend testing by writing complex SQL queries.
• 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
• Testing of records with logical delete using flags.

Environment: Informatica 9.1, MS SQL Server, Cognos, MS Excel, MS Access, Teradata, Teradata SQL Assistant, Oracle 10g, MySQL, Windows, Quality Center 11/ALM, T-SQL, SQL, MOSS, TOAD, Flat Files

Confidential, Loss Angles, CA

ETL/QA BI Tester

Responsibilities:

• Attended meetings with the Business Team, and Build Teams to gather the information about the project and the design methodology and the testing requirements
• Maintained the Traceability Matrix between Requirements, Design Components, Test Cases and Defects.
• Participate in weekly meeting with the management team and walkthroughs
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Authored test plans and test cases based on Informatica Mappings and Data Analyst Mappings.
• Wrote the Insert, Update, Delete and Error Processing test cases in all the stages.
• Wrote PL/SQL stored procedures for certain data validations
• Used Quality Center for test planning and execution and Rational Clear Quest was used for defect tracking.
• Validated the interface from Frontend to backend tables
• Performed Sanity testing, Security testing, black box and white box testing, web testing and GUI testing
• Performed testing on Java, .NET and on web based applications
• Was involved in executing the Regression testing on new Builds
• Participated in various meetings and discussed Enhancement and Modification Request issues
• Developed SQL queries in Toad and DB Artisan to achieve the data transformations
• Used the ETL processes of Informatica tool to load data from MS SQL Server and Oracle, into the target Oracle database.
• Managed test environments and schedules
• Created, updated and ran the QTP scripts.
• Worked with Test Analysts to ensure that defects are tracked and documented and results communicated to developers and stakeholders.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Trained the users for the User Acceptance Testing (UAT) and explained about each link, tab and search functionalities to the users.
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD
• Generated testing reports and metrics, trend graphs according to the test plan
• Created and executed SQL queries in ORACLE and MS SQL server
• Performed tests on various browsers
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: MS SQL Server, Oracle 11g (SQL, PL/SQL), TOAD, MS Access, QTP, Informatica 9, HP Quality Center 11/ALM, Teradata 13.0, Cognos, XML, XSD, XML Spy, Rational Clear Quest

Confidential, Detroit, MI

ETL/QA Backend Tester

Responsibilities:

• Developed unit test cases, configured environments and prepared test data for testing.
• Wrote PL/SQL /Complex SQL queries for system testing.
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.
• Worked with various EDI transactions like 834,835,837,276,277in accordance with HIPPA standards
• Worked with Business analysis team to prepare a detailed Business Requirement documents.
• Involved in writing & implementation of the test plan, various test cases & test scripts.
• Performed Functionality, Stress, Security, GUI & Regression testing of web-based applications.
• As QA Tester, performing responsibilities with both the functionality and back end testing.
• Wrote SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Worked with Production environment to resolve several data issues.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Involved in testing the Cognos reports by writing complex SQL queries
• Tested several reports and automated using Quick Test Pro.
• Written several Stored Procedures and modified existing stored procedures.
• Involved with extraction routines to verify all the required data loaded into target systems.
• Extensively executed SQL queries in order to view successful transactions of data and for validating data.
• Extensively used Informatica tool to extract, transform and load the data from Oracle to DB2.
• Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.
• Loading Flat file Data into Teradata tables using Unix Shell scripts
• Created the test data for interpreting positive/negative results during functional testing.
• Involved in the whole testing life cycle covering the entire project from initiation to completion
• Clearly communicated and documented test results and defect resolution during all phases of testing.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity.
• Involved in testing Cognos Reports and closely worked with operations, and Release teams to resolve the production issues.
• Used SQL queries and custom programs to perform data validation.
• Prepared test cases by understanding the business requirements, Data Mapping documents and technical specifications.
• Developed and documented data Mappings/Transformations, and Informatica sessions as per the business requirement. Involved in the development of Informatica Mappings and also tuned them for better performance.
• Designs and directs the preparation of test data; prepares test data, documents detailed results, provides regular and ad-hoc test reports.
• Experience in data analysis and data testing. And verified fields present in the reports are as agreed in the ETL specifications.
• Extensively involved with backend testing by writing complex SQL queries.
• Worked closely with the development teams to replicate end user issues.

Environment: Oracle 10g, Teradata 12.0, SQL Server 2008, SQL, PL/SQL, Stored Procedures, HTML, Java Script, Quick Test Pro, HP Quality Center 10.0, Informatica Power Center, PERL, Cognos, HTML, JAVA, JSP, JavaScript, Rational Clear Quest, Clear Case, RUP, TOAD, Requisite Pro, Test Manager, Automation/Manual Testing, UNIX.

Confidential, Herndon, VA

Data Warehouse Tester

Responsibilities:

• Worked closely with the development teams to replicate end user issues.
• Performed functional test and load test on SQL queries, store procedures and forms.
• Modified the design as per the changes in requirements.
• Interacted with the client on a daily basis and attended status meetings.
• Worked with developer to improve database performance.
• Created and maintained development, QA and audit database environments
• Attended status meetings and sending team status reports.
• Use of TOAD to write SQL queries and validate the backend
• Documentation of Test Results, Test Reports and Test Summary Report.
• Performed Database Testing using SQL queries for testing reports.
• Defined QA procedures to plan, design, execute, evaluate and report results of software testing under minimal or no supervision.
• Worked with QA team members and application developers; quickly capture the major business functions and technology to design and implement tests of system functionality that exercise all critical intersystem integration points.
• Utilized mercury test suite for requirement management, test case creation, execution and defect tracking.
• Provided training and mentoring to offshore QA team.
• Executed Ab Initio ETL sessions in different stages Source to Stage & Staging to Data ware to Datamart and to Business objects.
• Tested many Ab Initio graphs and tested the functionality of ETL mapping rules.
• Wrote PL/SQL stored procedures for certain data validations

Environment: PL/SQL, SQL, Test Director, UNIX, Shell Scripting, Ab Initio (GDE 1.12, Co>Op 2.12), MVS, JCL, VSAM Files, XML Files, CSV, COBOL II, Copy Books, Autosys, Crontab, Oracle 10g, Sybase 12.3, Business Objects XIR2, TOAD, WinSQL