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
• 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 & Tests

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

Sr.ETL/SQL 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.
• Developed the scripts using Descriptive programming for critical functionality by using Quick Test Pro (QTP).
• 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 database testing by using SQL queries
• Extensively used Quick Test Pro for regression Testing for automation of multiple modules in the environments.
• Identify business rules for data migration and Perform data validations.
• 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.
• Ensured data integrity and verified all data modifications and calculations during database migration using ETL tools.
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Developed data quality test plans and manually executedETL and BI test cases.
• Involved in data warehouse testing by checking ETL procedures/mappings
• Worked in AGILE Methodology.
• 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
• Figuring out various error handling strategies to be adopted during cross system data migration
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata

Environment: ALM/HP Quality Center 11, Oracle, QTP, Informatica 9, Business Objects XI 3.1, Rational Requisite Pro, SQL, PLSQL, Unix, SQL Server 2008, XML, Agile

Confidential, Dallas, TX

ETL/QA Analyst

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.
• 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.
• Involved in writing test scripts and functions in Test Script Language using QTP for automated testing.
• Tested several data migration application for security, data protection and data corruption during transfer
• 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.
• Tested the Informatica Mappings to load data from Source systems to ODS and then to Data Mart
• 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
• Tested data migration to ensure that integrity of data was not compromised.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Extensively used Informatica power center for extraction, transformation and loading process.
• 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.
• 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.
• In the process of data migration, migrated data from an Oracle data source to Teradata.
• Tested data warehouse ETL process using SSIS (Integration Service).
• Involved with ETL test data creation for all the ETL mapping rules.
• 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: Informatica 9, SQL Server 2008, T-SQL,QTP, Business Objects, SQL, PL/SQL, Teradata V2R6, 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, Windows NT/XP//2003

Confidential, Chicago, IL

QA Analyst

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.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target
• 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.
• 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
• Developed automation scripts in Quick Test Pro (QTP) and Performance Center.
• Attending defect triage meetings.
• Control-M agent accounts, and trouble-shooting Control-M production errors and coordinating with vendor when necessary.
• Wrote PL/SQL /Complex SQL queries for system testing.
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.
• Used reusable actions with utilizing the flexible functionalities in Quick Test professional
• Configured Quick Test Professional with Quality center.
• 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: Informatica 8.6.1, HP Quality Center 9.2,HP QTP, Oracle 10g, SQL, PL/SQL, SSIS,SQL Server 2008, Quality Center 9.0,, DB2 8.x, IBM AIX 5.5, MVS, ISPF, VSAM Files, Flat Files, XML Files, Shell Scripting, PERL, XML, XSD, TOAD, WinSQL

Confidential, CT

QA Tester

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

QA Analyst

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