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, SybaseChange

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, 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

Confidential, Atlanta, GA

ETL/SQL Analyst

Responsibilities:

• Used TOAD to write SQL and validate the backend
• Used SQL Teradata Assistant for data retrieval from Teradata
• Identified bugs and interacted with team lead and developers to resolve the bugs
• Used Back-end testing using SQL queries to validate the data in the back-end Oracle Database
• Test several ETL Ab Initio graphs against ETL transformation rules.
• Maintained the test matrices and reported bugs using Rational Clear Case
• Created Test Strategy and Test plan for the testing effort
• Conducted Smoke, Non Functional, Functional, System and Integration testing.
• Developed SQL and Stored procedures to achieve the data transformations
• Performed back-end testing on the Oracle database by writing SQL queries
• Conducted backend testing using Toad
• Participated in weekly meetings with the management team
• Involved in the Implementation of QA testing Process, and involved in documentation of Test Scenarios, Test Cases, and Test Scripts for Various Applications.
• 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.

Environment: Ab Initio (GDE 1.12, Co>Op 2.12), Autosys, SQL, Business Objects, SQL, SQL Server 2000/2005, Teradata V2R4, Test Director, MS Office Suite, IE, ASP, Crystal Reports,, HTML, JAVA, JSP, JavaScript Windows NT/XP/2000, Rational Clear Quest/Clear Case