SUMMARY

• Over 7+ years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Client - Server and Legacy Mainframe applications and Data Warehousing.
• Worked with IT Operations to ensure test environment readiness.
• Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and validation of fixed bugs
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Well versed in GUI application testing, Database testing and Front-end testing.
• Have knowledge on the web services
• Extensive experience in Data centric testing.
• Experience in Retail, Financial, Banking, Brokerage, and Securities industries.
• Experience with Agile, waterfall Methodologies.
• Experience in testing and writing SQL and PL/SQL statements.
• Extensive experience in testing Business Intelligence reports generated by various BI Tools like OBIEE, Cognos and Business Objects
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management. f latest trends in Quality Assurance processes and methodologies.
• Excellent analytical, multi-tasking, problem-solving, time-management & communication skills with particular emphasis on clearly communicating & documenting detailed Test Requirements & Test

TECHNICAL SKILLS

Data Warehousing: Datastage8.0,7.X/6.X (Manager, Designer, Director, Administrator), Ab Initio CO>Op 2.15, GDE 1.15, Informatica 8.6/8.1/7.1/6.1 , SSIS,SSRS,SSAS Data Stage 8.x

Reporting Tools: OBIEE, Business Objects XIR 2/6.5.1/6.0/5.1. x/4.0 (Supervisor, Designer, Reporter), Cognos, Web Intelligence

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Testing Tools: HP ALM 11.0, Test Director, HP Quality Center10, Rational Clear Quest, HP QTP 9.2

RDBMS: Oracle 10g/9i/8i/7.x, MS SQL Server 2008, UDB DB2 9.x, Sybase 12.5, Teradata V2R6, MS Access 7.0

Programming: UNIX Shell Scripting

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Novell NetWare, Win 3.x/95/98, NT 4.0

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. ETL QA Tester

Responsibilities:

• Prepared Test Plan from the Business Requirements and Functional Specification.
• Involved in reviewing and analyzing the functional requirement documents with the Business Analyst & stakeholders.
• Developed test strategy & test plan and reviewed with all stakeholders, Development team, Infrastructure team and other teams.
• Testing of Business Objects and Reports which Includes, Database Connectivity, Tested objects in the Universe to ensure the correct mapping of the objects, tested the Universe s Structure to ensure that tables are properly uploaded. Tested the aggregate Universe to ensure the query is pulling correct level of Aggregation.
• Tested jobs and used Ab Initio as an ETL tool to load the final loads. Created ETL test data for all ETL mapping rules to test the functionality of the Ab Initio graphs
• Extensively worked Agile Scrum methodologies of the application and involved in System Integration testing, Smoke, Functional, Regression and User Acceptance Testing.
• Created test design by using Quality Center test Management tool and tracked the defects and reported the defects to the concerned persons
• Performed data centric backend testing of applications using UNIX and SQL scripts.
• Performed database testing by using SQL queries
• Extensively used Quick Test Pro for regression Testing for automation of multiple modules in the environments.
• Involved in testing XML Messages generated thru ETL tool for legacy Mainframe data.
• Performed consistency and quality checks on data centric processes on the client data warehouse.
• Used QTP for Checkpoints, Regular Expression and Accessed Data Tables for multiple applications.
• Coordinate & schedule the defect triage meetings with the development team and business to discuss about the open issues reported using ALM/ Quality Center.
• Set up Requirements Traceability Matrix with all the testable Business scenarios.
• Created different Traceability views to maintain the Traceability of the requirements and test cases
• Frequently updated the requirements and defect status as per the current status of the testing project.
• Planned and worked flexibly to meet the dead lines.
• Prepared Execution procedure document format to prepare the Test cases based on mapping document.
• Initiated and developed new techniques to improve the testing process and improve the performance of the test scripts.
• Developed SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, Nulls/Defaults/Trim spaces rules as per the design specifications.
• Tested ad hoc and canned reports for Business objects.
• Coordinated execution of System Testing, regression and integration testing with multiple departments.
• Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.
• Performed Regression testing of the fixed issues in the new build until no new issues were identified.
• Ran Ab Initio graphs for both GDE and UNIX Korn shell/command line for testing needs
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Created xml schema definitions (XSDs) with XMLSPY tool and converted into Informatica metadata.
• Involved in writing and execution of test cases for data centric testing.
• Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio
• Designed and kept track of Requirement Traceability Matrix in Quality Center and test cases creation, loading and writing Test Plan and executing Test Cases and printing status report for the team meetings and defect tracking
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.

Environment: ALM/HP Quality Center 11, Ab Initio CO>Op 2.15, GDE 1.15, Oracle, QTP, Autosys, Business Objects XI 3.1, Rational Requisite Pro, SQL, PLSQL, UNIX, Teradata, Teradata SQL Assistant, SQL Server 2008, XML, XSLT, Agile

Confidential, Eden Prairie, MN

ETL/QA Tester

Responsibilities:

• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Used import and export facilities of the application to download/upload XMLs of failed test cases so as to re-verify.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Experience with onsite -offshore Co-ordination.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Created resource forecast, ramp up plans, & resource utilization plans.
• This work will include loading of historical data onto the Teradata platform, as well as reference data and metadata.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Ab Initio.
• Involved in writing test scripts and functions in Test Script Language using QTP for automated testing.
• Experience in generating XSD’s for related XML for setting up generic model.
• Tested Business Objects reports and Web Intelligence reports.
• Co-ordinate with offshore counterpart’s to make sure they have the knowledge of the Business requirements and mentored for Test preparation.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Review the test cases written based on the Change Request document.
• Based on the business requirements, created Test Plan, Test Cases, and Test Script documents to test the Business Objects reports
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Performed Datacentric testing using advanced SQL skills.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Experienced in translating requirements into tasks, milestones, and timelines to ensure project completion in accordance with specified deliverables.
• 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.
• Tested Ab Initio test environment for loading data from different source systems.
• Responsible for Creating and maintaining the development of excel, Access and power point
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Used T-SQL for Querying the SQL Server database for data validation.
• Writing the test scripts for manual testing.
• Used Rational Clear Case for version controlling.
• Tested data warehouse ETL process using SSIS (Integration Service).
• Involved with ETL test data creation for all the ETL mapping rules.
• Tested the data load process using the Ab Initio
• Preparing and supporting the QA and UAT test environments.
• Tested different detail, summary reports and on demand reports.
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: SQL Server 2008, T-SQL,QTP, Ab Initio CO>Op 2.14, GDE 1.14,Business Objects, SQL, PL/SQL, Teradata, SSAS, TOAD 9.2, Oracle 9.2, XML, XML Spy 2008, HP Quality Centre 10.0, Autosys, BI Reports, MS Access, MS Excel, MS PowerPoint, Microsoft Share Point, Unix Shell Scripting

Confidential, Richmond, VA

QA Analyst/ETL tester

Responsibilities:

• Interacting with Business Analysts and Development teams to understand the business requirements and giving the estimates from testing prospectus
• Test plan preparation, preparing daily status reports and defect reports.
• Involved in prioritizing the requirements according to business needs and putting all the requirements in QC.
• Create custom built reports from the Control-M batch server.
• Involved in writing and executing the test cases and involved in Defect reporting and verification.
• Involved in identifying the cause of Defect and reporting the same to developers.
• Validating the data between Oracle Tables and SQL Server Tables by using SQL Statements.
• Testing the data present in fact tables and dimensions tables.
• Involved in HUT (Hard unit testing), SIT (System Integration Testing) and WIL (Week in Live Testing) Testing.
• Used Ab Initio to extract, transform and load data from multiple input sources like flat files, Oracle 10g database to the Teradata database.
• Tested all the entities like customer records, payment records have been loaded target database according to its own table structure during the migration process.
• Tested database integrity referential integrity and constrains during the database migration testing process
• Mapped the original loan data to XML script data in the file.
• Attending defect triage meetings.
• Control-M agent accounts, and trouble-shooting Control-M production errors and coordinating with vendor when necessary.
• Used SQL for Querying the DB2 database in UNIX environment
• Wrote PL/SQL /Complex SQL queries for system testing.
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.
• Developed/Modified test graphs based on business requirements using various Ab Initio Components like Filter by Expression, Partition by Expression, reformat, join, gather, merge rollup, normalize, denormalize, replicate etc.
• Used reusable actions with utilizing the flexible functionalities in Quick Test professional
• Configured Quick Test Professional with Quality center.
• Worked with XML Sources files were loaded to Third Party tools.
• Tested data warehouse ETL process using SSIS (Integration Service).
• Documenting test procedures, test plans, test cases and test results.
• Wrote complex SQL syntax using case, having, connect by etc

Environment: HP Quality Center 9.2,HP QTP 9.2, Ab Initio GDE 1.15, Co-Op 2.15,Oracle 10g, SQL, PL/SQL, SSIS,SQL Server 2008, DB2 8.x, Autosys, IBM AIX 5.5, MVS, ISPF, VSAM Files, Flat Files, XML Files, Shell Scripting, PERL, XML, XSD, TOAD, WinSQL

Confidential

ETL Test Engineer

Responsibilities:

• Gathered user requirements from each Business Units for test.
• Interacted with the Business users to identify the process metrics and various keys dimensions and measures.
• Designed and developed Test Plans and Test Cases and executed them.
• Involved in implementation of the Test plans, Test cases and Test scripts.
• Involved in the error checking and testing of the ETL programs using Informatica session log and workflow logs.
• Involved in ETL Mapping Design and Performance tuning to Load mapping process.
• Organized sessions in a batch to run the sessions in a batch in sequential order or start them concurrently by the server.
• Initial testing was conducted manually and later phase was executed using Mercury Tools
• Validated the front end reporting components created using OBIEE Reports as well as performed back end testing, making sure that the correct data for a specific report are being pulled out from the Data Warehouse.
• 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.
• Developed Automated Test Scripts using Win Runner.
• Designed process performance loading strategies. And also wrote the optimizing techniques to improve the process loading time within the streamline using Server Manager to load the data into the Target Database.
• Tested the reports like DrillDown, DrillUp and Pivot reports generated from OBIEE.
• Involved in writing Test cases and Test plans which are managed and controlled using HP Test Director. Also used HP Test Director to manage and track defects.
• Documented defects accurately and with sufficient information to enable developers to analyze and reproduce the defect using Test Director’s defect reporting tool.
• Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing and Performance 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.

Environment: Informatica Power Center 8, Oracle, OBIEE, SQL, PL/SQL, UNIX Shell Scripting, XML, TOAD, HP Test Director

Confidential, Jersey City, NJ

QA Tester/SQL Tester

Responsibilities:

• Performed an active role in comparing front end data with the data stored in backend.
• Executed and written SQL queries for data comparison.
• Reviewed and analyzed user requirement documents (URD), software requirement specification document (SRS) and prepared System test plan by dividing the application into manageable units
• Interacted with Business Analysts and System Engineers while writing the test plan and test cases.
• Created and executed manual test cases and reviewed test cases developed by others.
• Maintained requirements and created Traceability Matrix between Requirements and Test Cases using Test Director.
• Performed functional and regression testing of the application manually and also automated.
• Performed Data-Driven Testing to read test input data from an Excel File so as to test the application with different Positive and Negative Data.
• Performed cross-browser testing to verify if the application provides accurate information in different (IE, Netscape, AOL) browsers.
• Used Test Director to generate Reports, manage Defects and track them to completion.
• Reported the bugs to the developers and made sure that the bugs were fixed by performing regression testing.
• Documented all the high-level test conditions, test cases and test steps using MS-Excel.
• SQL queries were implemented to validate the data.

Environment: Test Director, Windows, Java, Servlets, Oracle,SQL Html, JavaScript and UNIX

Confidential

QA Test Engineer

Responsibilities:

• Identified the test requirements based on application and business requirements.
• Analyzed business, functional and technical specification documents to write test cases.
• Performed manual testing and maintain documentation on different types of Testing viz., Positive, Negative, Regression, Integration, System, Black Box.
• Involved in doing System testing of the entire applications along with team members.
• Developed Test scenarios, Test Scripts and scheduled them for execution.
• Performed Database testing, Wrote SQL queries to validate data.
• Documented errors and implemented their resolutions.
• Developed Test Objectives and test Procedures.
• Submitted status reports weekly to QA lead
• Participated in team training for career development.
• Participate in Defect Status calls.

Environment: Oracle, MS Office, Visual Basic, HTML, JavaScript, Windows 95, Web Logic, UNIX, IE, Test Director.