SUMMARY

• Extensive 8 years experience performing ETL/Data warehouse, Database testing And Web Testing.
• Hands on experience with ETL Testing BI Reporting tools, such as Business Objectsand Cognos.
• Expertise in writing Test Plans, Test Strategies, Test Cases, Test Scripts, Test Scenarios, Test Reports and Defect Metrics.
• Involved in various stages of Software Development Life Cycle (SDLC) implementing Waterfall, V - Model and Agile methodologies.
• Strong understanding of QA Principles, QA Process, Use Cases, and Software Development Life Cycle.
• Hands on experience with automation testing tools like QTP.
• Used Test Director for test documentation management and defect tracking.
• Extensive experience in developing Test Procedures and Test Strategy for Web and Client/Server applications.
• Sound knowledge of System, Regression, Integration, Functionality and User Acceptance Testing.
• Experience in testing on enterprise wide applications with multiple databases.
• Proven experience with the development, and implementation of large-scale, enterprise data warehouse and reporting solutions.
• Extensive experience in Test Director 7.2, Clear Quest, Clearcase.
• Experience in Business Intelligence in generating various reports using business Intelligence tool Business Objects XI R2/XI/6.5.
• Interacted with the developers on various technical issues and resolved the reported bugs.
• Well versed in testing Methodologies, Web testing, and software Deployment/Release processes.
• Very Strong skills, including the use of nested table expressions, unions, Multi-table joins and outer joins.
• Supported the defect resolution process by prioritizing the severity level of defects.
• Participation in design reviews with the Development team.
• Experience of ETL testing process including Type1 and Type2 and Type 3 changes
• Experience on Data validation, Data merging, Data cleansing and Data aggregaton activities.
• Execute theETLjobs sessions and workflows.
• Worked with SDLC process like water fall model, AGILE methodology
• Good experience in UNIX and Windows platform.
• Expertise in scripting using PERL.
• Created test plans, test data for extraction and transformation processes and resolved data issues following the data standards
• Worked with Database migration Testing experience in different versions of Informatica and SSIS.
• Good Experience in review of test cases and Preparing Test Reports

TECHNICAL SKILLS

Operating Systems: Windows 2003/2000/XP, UX-HP, MS DOS

Internet: ASP, HTML DHTML, XML, Web Services

Business Modeling Tools: Rational Rose, MS Visio

Languages: C#, C++, C, VBScript, JavaScript, VB 5/VB 6, SQL

Testing Tools: QTP8.x/9.2/9.5/10,Quality center, WinRunner 7.5/7.0/6.0, LoadRunner9.0/8.x, Test Director

Office Tools: MS Office, MS Project

Databases: MS SQL Server 2000, Oracle 8i/9i, TeradataV2R6/R5, DB2

ETL/ Reporting tools: Informatica, Datastage, Ab Initio, Crystal Reports

Configuration Management: MS Visual Source Safe, SOS, Clear Case, Share Point Portal, PVCS, Doors, Rational Test Manager

PROFESSIONAL EXPERIENCE

QA Lead

Confidential, NY

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.
• Completed Data migration test cases as well as web based test scripts.
• Data migration of raw data to excel documents for clients
• Used SSIS for the ETL of the data from various sources to the data marts.
• Created new mappings and modify existing mappings for the purpose of populating the Data Mart.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using SSIS and provide technical support and hands-on mentoring in the use of SSIS for testing.
• Extensively used SSIS for ETL process.
• Worked on different versions of Business Objects.
• Executed regression tests at each new build in QTP.
• Worked with Business analysis team to prepare a detailed Business Requirement document
• Involved in writing & implementation of the test plan, various test cases & test scripts.
• Performed Functionality, Stress, Security, GUI & Regression testing of web-based applications
• 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 excell,MS Access and Flat Files
• 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.
• Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.
• Based on the business requirements, created Test Plan, Test Cases, and Test Script documents to test the Business Objects reports
• 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.
• Used SQL queries and custom programs to perform data validation.
• Prepared test cases by understanding the business requirements, Data Mapping documents and technical specifications.
• 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: Informatica 8.1,Oracle 9i/10g, SQL, PL/SQL, Stored Procedures, HTML, Java Script, Oracle,Quick Test Pro 8.0, Quality Center 8.0, Points Portal, Autosys, MS Office Suite, Business Objects 4.1/5.1.5 /6.0 /6.1 b /6.5/XI R1/XI R2

Sr. QA Engineer

Confidential, New York

Responsibilities:

• Working with the business team to gather requirements.
• Creating and executing test cases based on test plans.
• Performed report validation of the securities system, which are generated, on Cognos8.0.
• Developing SQL scripts and used TOAD to run the SQL scripts from Oracle and SQL server databases.
• Experience in testing using Teradata utilities like BTEQ and exposure to FastLoad, MultiLoad, FastExport, Tpump, SQL Assistant, SQL Administrator.
• Extensively tested data from flat files, Oracle, Teradata database.
• Worked extensively with the Teradata Queryman to interface with the Teradata.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Monitored the Informatica workflows using Power Center monitor. Checked session logs in case of aborted/failed sessions
• Perform Functional, Data Validation, Integration, regression and User Acceptance testing.
• Used TOAD, DB Artisan tools to connect to Oracle Database to validate data that was populated by ETL applications.
• Involved in backend testing for different environments like System Testing and User Acceptance Testing.
• Perform Functional testing, System testing, Smoke testing and Regression testing.
• Developed automation scripts and executed them as a part of the regression testing using QTP.
• Followed the keyword driven methodology for the automation
• Documenting the test results.
• Creating and modifying UNIX shell scripts.
• Created T-SQL queries to retrieve the data the SQL Server database.
• Tested internal and high-level business reports.
• Running Sql queries to check if the data is loaded correctly into the database and into the reports subsequently.
• Checking the job flows in Informatica.
• Used Quality Center for executing the test cases and defects tracking.
• Scheduling Autosys jobs and running the job flows.
• Attended weekly status meetings for reporting the testing updates.
• Participating in review meetings on a periodic basis.

Environment: Quality Center 9.2, QTP 9.5, Oracle, SQL Server, Teradata V2R5, Toad, Informatica 8.1, XML, Java, Cognos8.0, MS Outlook, Autosys, MS Excel, MS word, Windows XP, Unix and DOORS.

Sr. QA Analyst

Confidential, Norton, Virginia

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• SQL queries were written to verify the data in both source and target schemas to validate the Data migration
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Involved in writing test scripts and functions in Test Script Language using QTP for automated testing.
• Automated detailed test cases by using Quick Test Pro.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Tested and supported several ReportNet Reports and Powerplay cubes.
• Involved in installation of Cognos Toolset and assisted in creating users and assigning them appropriate access rights for the entire testing team..
• Performed Functional, Regression, Data Integrity, System, Compatibility.
• Extensively executed T-SQL queries in order to view successful transactions of data and for validating data in Sql Server Database.
• Used VSTF to document issues found during the test automation process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Tracked and reported the bugs with Quality center.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS excell,MS Access and Flat Files
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Used T-SQL for Querying the SQL Server database for data validation.
• Writing the test scripts for manual testing.
• Involved with ETL test data creation for all the ETL mapping rules.
• Tested stored procedures & views in MS SQL 2000/2005.
• Performed Regression testing of the fixed issues in the new build until no new issues are identified.
• AutoSys is used in automated job control system for scheduling, monitoring, and reporting
• Preparing and supporting the QA and UAT test environments.
• Tested different detail, summary reports and on demand reports.
• Worked closely with the Business Analysts, Systems Analysts, Developers, and DBAs to solve the issues identified during the testing process in a timely manner.
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: Informatica 8.6, MS Sql Server 2008, SSIS, Cognos 8.0 report net,, Metal (Meta Data Driven ETL), MSaccess,MSexcell, Powerpoint, Windows XP/NT/2003, BI Reports,HP QTP 9.2, HP Quality center 9.2 Project Description:

QA Analyst

Confidential, IL

Responsibilities:

• Wrote Test Plans and Test Cases pertaining to data validation and integrity testing for data loading, data validation and integrity check testing.
• Wrote test cases and executed them on the Billing System.
• Developed a detailed Test Plan for the testing effort of the User Interface
• Involved in requirement analysis
• Performed security testing manually and writing sql queries against the database
• Maintained requirement traceability matrix.
• Extensively used Mercury Quality Center (TEST DIRECTOR) and Created Test Cases in the TEST PLAN according to the specifications.
• Used TEST LAB to run the Test cases.
• Reported Defects and prioritized outstanding defects using Test Director/Quality Center.
• Ran the Informatica ETL Sessions for Claims in different stages Source to Stage & Staging to Data mart and Data mart to Business Objects and BO to Dashboard using Informatica Server Manager
• Maintain Object repository
• Created TSL Scripts files as per the test plan requirements.
• Tracked the defects in Test Director.
• Validated data feed into the data warehouse for DWH implementation and also tested front end application where massaged data was presented in report formats.
• Involved in Integration testing, UI, User Acceptance Test (UAT), Functionality testing & Performance testing.
• Performed database testing to verify the rates as per the large accounts
• Executed SQL Queries to verify the dataflow from the backend
• Involved in validating the reports, both Data and their layouts
• Bug reporting, tracking and documentation on the Bug tracking System using Test Director
• Weekly Status meeting with Development and Management teams to discuss bugs and other issues.

Environment: Test Director 7.2, QTP 8.2, Flat files, Ab Initio, SQL Loader, Oracle 8i/9i, TOAD, UNIX, Windows

QA Analyst/ Tester

Confidential, FL

Responsibilities:

• Analyzed Business requirements Documents Lower Level documents and higher level documents.
• Developing and executing test cases and test scripts for interfaces, in bound and out bound of the Firewalls, and Credit Card Processing Security.
• Created test steps for each test case and wrote the expected results for each step.
• Executed the test cases and reported the defects if any in Test Director.
• Involved in testing star schema.
• Created and tested Database connections to Informatica Repository and configured the components.
• Extensively involved in testing ETL process with Informatica Power center 7.1.2.
• Executed test cases for complex Mappings that involved Expression, Filter, aggregate, join, lookup, Router, Sequence, Update etc... transformation (business rules) procedures for new functionality.
• Created sessions and batches to transform and load data into oracle in QA environment.
• Created SQL scripts based on the mapping document to test the Dimension tables, Fact tables, Aggregates and MV's between source and target systems
• Created test sets using Test Director by selecting from the database to achieve a specific goal.
• Created and completed regression test cases.
• Created Sql scripts to extract data based on requirements.
• Involved in Technical and User documentation of the mappings and Loads.
• Created Test Case documents in MS Excel template from the Test Plan, and the Business Requirements documents.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings.
• Used multiple data providers, Master/Detail, cross tab, Charts.
• Created several Ad-hoc reports in Business Objects XI R2 to validate the data
• Testing ETL sessions and PL/SQL scripts for multiple feeds and multiple LOB's.
• 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.
• Configured Quick Test Pro with Quality Centre and Maintained the project information in Quality Centre.
• Called WinRunner scripts into Quick Test Pro.
• Extracted Data from Teradata using Informatica PowerCenter ETL, and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• 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.
• Worked with Quality center to document test results and validate test scripts. Used Quality Center in routing defects, defect resolution and assigning business cases to business users.
• Ran 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.
• 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, System, Compatibility, and User Acceptance Testing including GUI testing
• Executed test cases for data validation, link verification, and content verification.
• Involved in backend testing with SQL, check the data integrity and referential integrity.
• 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: Win Runner 7.0 Test Director 7.2, Informatica 7.1.2, Toad, Java, JSP, HTML, XML, SQL, Oracle 8i, Unix, MS Word, MS Excel.

QA Analyst / Tester

Confidential - Manassas Park, Virginia

Responsibilities:

• Involved in writing the Test Strategy Document, QA testing criteria, Use cases, Test Cases and Test Scenarios based on BRS/BRD on V&V Methodology guidelines
• Created a strategy document that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required to conduct the effort.
• Involved in development of test plans, test schedules, test cases based on high-level and detailed designs for open registers, price override and gift certificate.
• Conducted database verification testing by using different SQL queries.
• Interacted with application users (end-users) and performed User Acceptance Testing (UAT).
• Used Test Director for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Participated in weekly project status meetings and updated the process accordingly.

Environment: Test Director, JAVA, JSP, EJB, IBM AS400, JDA, SPUFI, QMF, SQL, PL/SQL, HTML, Windows NT, 2000, XP