PROFESSIONAL SUMMARY:

• Around 7 years of Software Quality Assurance (QA) experience testing Data Warehouse, Database (ETL & BI), Web, Client - Server Systems and Applications for various Industries like Healthcare, Financial and Retail.
• Experience in defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC)
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Extensively strong on databases including Oracle 10g/9i/8i, MS SQL Server 2000/7.0 and DB2
• Extensive knowledge in regression testing and design documentation.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Automated and scheduled multiple ETL jobs using UNIX Shell Scripting.
• Extensive testing ETL experience using Informatica (Power Center/ Power Mart).
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame...
• Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Excellent Communication, Analytical and Interpersonal skills.

TECHNICAL SKILLS:

Database: Oracle 10g/9i/8i, SQL Server 2000/2006/7.0, IBM DB2, Teradata V2R7

Change Mgt Tools: Test Director 8.0, Quality Center 9.2/8.2

Data Warehouse Tools: Informatica 8.1/7.1/7.2/6.1, SSIS, MS DTS Packages

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

BI Tools: MicroStrategy 8.1, Business Objects

Languages: PL/SQL, T-SQL, SQL, XSLT, Visual Basic

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

Web Technologies: XML, HTML, JavaScript, VBScript

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Sr. Manual QA SQL Tester- Analyst / DWH

Environment: Manual Testing, Informatica Power Center (8.6), Tivoli(to run the job), Oracle 10g, TOAD, SQL,SSIS, Rational Clear Quest, HIPAA X12, Window, Unix.

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Involved in the creation of test plan, test cases, test procedure required for Manual testing and to initiate Automated testing.
• Responsible for Creating manual test scripts to include Functional Test, Regression Test, UAT, Migration Test and Study Configuration Test.
• Used HP Quality Center to perform Manual Testing and logging and tracking defect until the bug was fixed
• Created Manual Testing strategy and performed Database Testing using SQL Queries by retrieving data from Oracle Database
• Performed UAT (User Acceptance Testing) and executed to verify requirements, look and feel of the applications.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
• Used various checkpoints in the Informatica designer to check the data being transformed
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping, Designer and Transformation.
• Involved in creating and executing test plans, test cases, and test scenarios for User Acceptance (UAT), Functional, and Regression Testing.
• Manually tested the entire application before the tests were automated.
• Analyzed business requirements, system requirements, data mapping requirements, and functional requirements documents to understand the current process to implement.
• Tested ETL jobs as per data mapping requirements.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
• Tested OLAP cubes and SSRS reports for various business needs.
• Tested the created SSIS packages to transfer data from various sources like Oracle, Excel,
• Tested the ETL process for both before data validation and after data validation process.
• Wrote SQL Queries using TOAD to performed Backend testing.
• Used Rational Clear Quest to track the defect
• Worked for many DATA QUALITY (DQ) ticket issues by reviewing Unit Test (UTR) and validation.
• Extensively executed T-SQL queries in order to view successful transactions of data and for validating data in Sql Server Database.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Creation of test scripts in SQL based on published design documents
• Exported the results through SQL and documented the test results for test cases, suites executed.
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center
• 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.
• Executed Test Cases for batch programs. This testing involved running the shell scripts and executables at the command line and involved in UNIT testing.
• Create various test Batch jobs to run and monitor group of jobs with DataStage Director.
• Tested the SAS jobs in batch mode through UNIX shell scripts
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Involved with ETL test data creation for all the ETL mapping rules.
• Excellent Understanding of Service Oriented Architecture (SOA) on ESB.
• Clear understanding of SOA architecture
• Validated the SOAP output backend results by writing SQL queries and executing them in TOAD.

Confidential, Pittsburgh, KS

Sr. ETL/DW/Backend Tester

Responsibilities:

• Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Involved in writing the Test Plans based on Business Requirement and Functional Requirement documents.
• Involved in implementation of the Test plans, Test cases and Test Scripts.
• Created Test sets in Test Lab to move all the test cases from Test plan to execute the test cases.
• Tested the data and data integrity among various sources and targets.
• Developed and involved in both Manual Testing and Automation Test Scripts based on Use cases developed.
• Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate my test cases.
• Tested Business Objects reports and Web Intelligence reports.
• Managed user accounts and security using Business Objects Supervisor.
• Tested the universes and reports in Business Objects 6.0
• Extensively used Informatica power center for ETL process.
• Preparation of ETL mapping specifications.
• Worked with QTP for Regression Testing.
• Configured Quick Test Professional with Quality center.
• Executed of QTP Script for automation testing, analyzing the automation result
• Reviewed Informatica mappings and test cases before delivering to Client.
• Used all Teradata utilities including Fast Load, Multi Load, Fast Export, SQL Assistant, BTEQ & TPUMP
• Trained and coordinated with the offshore team members in understanding the requirements and test cases for UAT.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Involved in ETL Mapping Design and Performance tuning to Load mapping process.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Reviewed the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Involved in preparation of System Test Results after Test case execution.
• Experienced in writing UNIX script.
• Effectively coordinated with the development team.
• Created critical scenarios for each change request and defect request.
• Worked on HP Quality Center and updated defects status with appropriate information. Test cases and Test plans are managed and controlled using HP Test Director. And also used HP Test Director to manage and track defects.
• Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing, Parallel Testing, Performance Testing and Regression Testing.
• Used various SQL queries to validate the test case results for back-end test cases.
• Well exposed to Software Development Life Cycle and Test methodologies.
• Hands on experience with working on Autosys jobs and MQ’s. MQ’s are used for intermediate storage where the messages are stored for temporary purpose.
• Hands on experience working with SQL Server DTS Packages.

Environment: Informatica Power Center 8.1,Cognos, SQL, PL/SQL, SQL Server 2000/2005, Unix Shell Scripting, XML, XML Spy 2008, XSLT, TOAD 9.2,Oracle 9.2, SOA, SOAP UI, REST Teradata, HP Quality Center, Rational Suite, DB Artisan 8.5.2, Autosys, MQ’s

Confidential, Ann Arbor, MI

Sr. Data Warehouse/SQL/Manual Tester -EDW

Environment: Oracle 10g/9i, SQL Server 2000, SOA,SOAP,SQL, PL/SQL, Stored Procedures, HTML, Java Script, Quick Test Pro 8.0, Quality Center 8.2, Points Portal, Autosys, MS Office Suite, HTML, JAVA, JSP, JavaScript, Rational Clear Quest, Clear Case, RUP, TOAD, Requisite Pro, Test Manager, Automation/Manual Testing, UNIX.

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 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 writing test scripts and functions in Test Script Language using QTP for automated testing.
• Manually tested the application functionality and developed Automation test scripts to perform functional and regression testing and prepared automation test scripts, Methods and functions in QTP.
• Manually performed GUI and Functionality testing of the Application front end.
• Analyzed Manual Test Cases with QA Team for most important & high priority Requirements for conversionto Automated Test Scripts using HP Quick Test Professional (QTP)
• Prepared and contributed in creating Test plan and Test Strategy along with arranging and executing TestCases for Manual and Automated Testing
• Attend weekly meeting with team leads, manager, and developers to discuss the issues found during the creation of the test cases/scripts.
• Used Test Director as the defect-tracking tool to enter defects regarding the issues found during testing.
• 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.
• 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.
• Tested the data coming out of the Master Queues and Ab Initio Queues.
• Execute SQL Queries in TOAD to validate back end information and compare it with the information retrieved from Data warehouse Ab-Initio
• Development Designs and directs the preparation of test data; prepares test data, documents detailed results, provides regular and ad-hoc test reports.
• Extensively worked in using Batch Processing Techniques for highly centralized client data Processing
• Executed UNIX Shell Scripts for Batch Job Execution.
• 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.
• Tested both the Web Service Architecture and Service Oriented Architecture
• Worked with SOAPUI for testing Web Services
• Responsible for Creating manual test scripts to include Functional Test, Regression Test, UAT, Migration Test and Study Configuration Test.
• Performed Stress, load, and Performance testing using Load Runner.
• Created DB Queries using SQL, manually tested them and documented them in the test plan for testing the Excel Based Application.
• Extensively Queried through SQL to check the database records
• Developed SQL scripts to perform Backend Testing.

Confidential, Seattle, WA

Manual/SQL/ETL Tester

Environment: Informatica Power Center, SQL, Business Objects 7.1,T-SQL, SQL Server 2000, Oracle 8, Teradata V2R7, Test Director, Clear Quest, MS Office Suite, IE, ASP, Crystal Reports,, HTML, JAVA, JSP, JavaScript Windows NT/XP/2000.

Responsibilities:

• Created Test Case documents in MS Excel template from the Test Plan and the Business Requirements documents.
• Responsible for Creating manual test scripts to include Functional Test, Regression Test, UAT, Migration Test and Study Configuration Test.
• Created DB Queries using SQL, manually tested them and documented them in the test plan for testing the Excel Based Application.
• 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.
• Wrote, prepared and executed Manual TestCases based on Requirements and Use Cases, and Automated Test Scripts throughout Software Development Life Cycle (SDLC.
• Developed, executed, and maintained TestPlans, TestCase, TestScripts, and Test Data for manual testing approaches using track & defect management tool HPQuality Center (QC).
• Prepared TestCases & Scenarios by studying & reviewing through the Design Documents and SRS.
• 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 the error checking and testing of the ETL procedures and programs Informatica session log.
• Use Business Objects OLAP Intelligence to natively access and analyze OLAP servers. OLAP Intelligence tool helps to Slice, dice, and drill directly on multidimensional sources and deliver workflows via the Web, Windows, and Microsoft Excel.
• Tested ad hoc and canned reports for Business objects.
• Wrote and ran UNIX Scripts for batch jobs.
• Ran UNIX shell scripts to count the records for EDW source to staging tables.
• Ran SQL queries to verify the number of records and validated the referential integrity rules as per the design specifications.
• 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.
• 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.
• Did the Data Migration from various source systems (DB2 UDB, Siebel, Oracle) to central oracle data base which is used to business users for easy access of the data.
• Experience in Integrating SQL Server and Oracle.
• Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting
• Created Manual Testing strategy and performed Database Testing using SQL Queries by retrieving data from Oracle Database
• Involved in documentation in order to maintain and run scripts for future enhancements.