SUMMARY

• Over 7+ years of IT experience in Quality Assurance with Datawarehousing, ETL, Business Intelligence, Databases, DataMarts, Web - based and client-server applications
• Good experience with Data Analysis, Data Validation, Data Modeling, Data Migration, Data Profiling, Data Verification, Data Mapping, Data Loading and had Data Warehousing testing
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.
• Experience Extensive experience in drafting Test Flows, Test Plans, Test Strategies, Test Scenarios, Test Scripts, Test Specifications, Test Summaries, Test Procedures, Test cases & Test Status Reports.
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica, SSIS, DataStage
• Proficient in writing SQL queries to perform data driven tests and involved in front-end and back-end testing. Strong knowledge of RDBMS concepts. Developed SQL queries in Oracle databases to conduct DB testing. Having good knowledge on Oracle Data Integrator.
• Automated and scheduled multiple ETL jobs using UNIX Shell Scripting.
• Extensive experience in testing Business Intelligence (BI) reports using various reporting tools like Micro strategy (MSTR), Cognos Report Net and Business Objects
• Expert in writing complex SQL queries, PERL Scripts and UNIX Shell Scripting
• Efficiently performed Defect Tracking using various tools like Quality Center, Test Director, Rational Clear Quest, Remedy Tool, PVCS Tracker, and Bugzilla.
• Experience in User Acceptance Testing, Performance Testing, GUI Testing, System & Functional Testing, Integration Testing, Regression Testing, Data Driven, Keyword driven Testing
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within timeframe.
• Excellent analytical, multi-tasking, problem-solving, time-management & communication skills with particular emphasis on clearly communicating & documenting detailed Test Requirements & Tests

TECHNICAL SKILLS

Test Management: MS Project Test Scheduling, Test Director, Quality Center, Rational Quality Manager, Confidential DOORS Traceability Matrix for Requirements and Defects

Testing Methodologies: Object Oriented, Keyword Driven and Data Driven testing, Top to Bottom and Bottom to Top test methodology, Requirement based, Risk based, Priority based test methodology

Mercury Interactive: QuickTestPro9.5/9.2/8.0, Business Process Testing, WinRunner 9.2/9.0/8.0/7.5 , LoadRunner9.2/9.0/8.0, TestDirector9.0/8.0/7.5, Quality Center9.0/8.2

ETL Tools: DataStage 8.1, Informatica 7.1/8.1/8.6.1 , SSIS, Ab Initio (Co>Op 2.15, GDE 1.15)

BI Tools: Micro Strategy, Business Objects XIR3, Cognos Series 8.0

Bug Reporting: Rational Clear Quest, HP Quality Center, Test Director, MS Access, Bugzilla, Siebel Service Request

Scripting languages: TSL, SQA basic, Java script, VB Script, HTML, XML, Shell Scripting, PERL

Operating Systems: Windows XP/NT/2000, DOS, Mac 10.4, AIX UNIX, LINUX

Databases: Oracle 10g/9i/8i/7.3, MS SQL Server 6.5/7.0/7.5/2005/2008 , Sybase 12.5/12.0/11.0 , MS Access, Teradata 12.0

PROFESSIONAL EXPERIENCE

Confidential, Schenectady, NY

Sr. ETL QA Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Participated in fact and dimension table implementation in Star Schema model based on requirements.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using HP Quality Center 10
• Tested incremental iterative application releases using an Agile process (Scrum)
• Different Informatica components especially are used effectively to develop and maintain the database
• Verified the Target table inserts and updates that occurs based on different conditions mention in the mapping specification document
• Verified the data loads to critical and non-critical columns based on the ETL updates or inserts
• Created test plans and number of test cases and test scripts and executed the test scripts.
• Extensively tested various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy, and Joiner for data coming from various heterogeneous sources like Oracle, DB2, XML and Flat files to Oracle.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata and conducted data integrated testing by extensive use of SQL
• Extraction, Transaction and Loading was done using different Components and different expressions using Informatica to create test data.
• Write SQL statements that use joins or sub queries to combine data from multiple tables.
• Executed SSIS Packages and verified the results.
• Involved in extensive DATA validation using SQL queries and backend testing
• Wrote PL/SQL /Complex SQL queries for system testing.
• Tested for Type 2 slowly changing dimensions (SCD) in the warehouse. Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Raised numerous defects in the testing process. Identified bottlenecks through performance testing and suggested SQL performance tuning techniques to development and extensively worked with DBA’s to resolve performance and tuning issues.
• Extensively performed System testing, Integration Testing and Regression Testing.
• Extensively used Informatica for extraction, transformation and loading process.
• Tested Automated and scheduled Informatica jobs using UNIX Shell Scripting.
• Used SQL plus as a query analyzer to run queries against the warehouse to get a better understanding of the SQL produced by MicroStrategy, which greatly enabled in better data quality
• Worked with ETL group for understating SSIS.
• Enhanced QTP scripts by putting database checkpoints.
• Tested several complex reports generated by Microstrategy including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Extensively created test data to cover various scenarios and performed positive and negative testing on for validation purposes.
• Attended weekly status meetings with the manager and lead and updated the status of the team to the higher management.

Environment: Informatica Power Center 8.6, MicroStrategy, SQL, PL/SQL, SQL Server 2008, SSIS, Oracle10g, DB2, Teradata 12.0, Flat files, SQL plus, MS Access, TOAD, XML, HP Quality center v10, QTP 9.5, UNIX, Shell Scripting

Confidential, Wallingford- CT

ETL Tester

Responsibilities:

• Extensively worked with the Business Analysts in understanding the requirements and participated in HLD walkthroughs between Business Analyst and development teams.
• Involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts and using BRD, HLD documents.
• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Written Test Cases for ETL to compare Source and Target database systems and check all the transformation rules.
• Used UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed
• Assisted in kicking off Informatica ETL jobs using UNIX and analyzed the data in dimension and fact tables
• Tested several Informatica ETL jobs and ran on UNIX for loading purpose and checking the log files
• Coordinate and tested the deployment procedure for Micro Strategy changes to the Production
• Highly experienced in various features of MicroStrategy like managing multiple projects, project migration and defining standards, procedures for development, production environment
• Wrote SQL scripts and standard PL/SQL procedures in Oracle
• 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.
• Identify the primary key (logical / physical ) and put update or insert logic
• Deleting the target data before processing based on logical or physical primary key
• Preventing occurrences of multiple runs by flagging processed dates
• Testing of records with logical delete using flags
• Developed SQL queries/Unix Shell Scripts and JCL jobs.
• Written SQL scripts to test the mappings.
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.
• Tested several business reports including Score Cards, KPI's, Summarized, Master-Detailed and Drill Down reports developed by Microstrategy
• Tested Microstrategy reports and written test cases using Quality Center 9.2.
• Used HP Quality Center for Test Case management and defect tracking

Environment: Informatica Power Center, MicroStrategy, SQL, PL/SQL, UNIX, Shell Scripts, Quality Center 9.2, Mainframe, Oracle 9i, SQL Plus, MS Access, TOAD, XML, XML Spy.

Confidential, Timonium, MD

ETL Test Analyst

Responsibilities:

.

• Analyzed and evaluated the existing as-Is system, Business Process Improvements (BPI) incorporated and enhanced future (To-Be) system and developed the test requirements
• Written Test Cases for ETL to compare Source and Target database systems.
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Packages.
• Used Quality Center to create manual (IEEE format) and automated tests, build test cycles, run tests and report and track defects.
• Generated reports and graphs to review the progress of test planning, tests run and defects tracked.
• Tested several DataStage ETL jobs and ran on UNIX for loading purpose and checking the log files
• Tested both the Web Service Architecture and Service Oriented Architecture
• Supervising the QA team in accomplishing their tasks as per the deadlines.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Written XSLT scripts for various XML needs and used XPath, XQuery for data retrieval from XML documents.
• Ensured data integrity and verified all data modifications and calculations during database migration using ETL tools. Developed test cases to accomplish ETL data migration
• Extensively used DataStage tool to extract, transform and load the data from Oracle to DB2.Compared the actual result with expected results.
• Validated the data by reverse engineering methodology ie backward navigation from target to source.
• Worked with Username Token, Binary Tokens, XML Tokens and Timestamp
• Ensured that the mappings are correct
• Writing complex SQL queries for data validation for verifying the SSIS transformation and business Rules.
• Analyzed SQL code to ensure Business Objects queries the correct data from the database
• Testing the source and target databases for conformance to specifications
• Conditional testing of constraints based on the business rules
• Identify and request test resources like QA engineers, Software (SW) and Hardware (HW)
• Performed functional testing using QTP for end to end application testing.
• Create and execute load test plans and scripts using Load Runner
• Debugging the SQL-Statements and stored procedures
• Developed regression test scripts for the application
• Tested several business reports developed in Business Objects and Written test cases for same.
• Tested the Oracle PL/SQL testing programs
• Conducted review sessions on test case and regression test scripts in quality center

Environment: Oracle 9i, SQL Server 2005, ETL SSIS/DTS, SQL, PL/SQL, DataStage 7.5, Flat Files, Windows XP, QTP 9.0, XML Files, XSD, XQuery, XML Spy 2008, TOAD, Quality Center 9.0, Business Objects XIR2, PERL, UNIX, Shell Scripting

Confidential, Naples, FL

QA Tester

Responsibilities:

• Responsible for creating Test plans, designing test harnesses and test cases, and executing the test cases.
• Performed Web Application and Web Services testing in the Banking and Financial Domain.
• Performed Smoke test, System test, Functional, Integration, End to End, User Acceptance testing and Regression testing activities in Test environment and Production support environment.
• Created bank setup for the bank account and performed Electronic (ACH), Wire, and
• Check transfers, deposits via Web app and Back Office System, and verified those transactions in the downstream systems like BOS, AOM, and in the back-end database.
• Used DataStage Director to run and monitor the ETL job status.
• Extensively worked on creating the XML's files and VSAM Files from Mainframe
• Executed backend data-driven test efforts with a focus on data transformations between various systems and a data warehouse.
• Responsible for testing all new and existing ETL data warehouse components.
• Experienced at testing ETL's and flat file data transfers without relying on a GUI layer.
• Tested several dashboards and deployed them across the organization to monitor the performance. Conducted Data Migration and Data Cleansing
• Performance tuning ofDatamigrationtransformation and load processes
• Implemented various integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.
• Identified and tracked the slowly changing dimensions/mini dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Testing DataStage ETL jobs using complex SQL queries.
• Wrote SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Reviewed log files for ETL jobs in DataStage Director.
• Tested data feeds from XML to Database
• Written complex UNIX Shell scripts for several scenarios including Cleanup, file manipulation, job scheduling, data parsing, connecting to the database and text processing.
• Involved in testing the Cognos reports by writing complex SQL queries
• Have experience in validating the business transformations by writing complex SQL queries. Coordinated with the Back Office system team i.e. QA team to generate the XML's based upon the account criteria.
• Communicated with Manager, Team lead daily for testing efforts and sent Status Reports as needed like Daily and Weekly.
• Performed Back end testing by writing SQL statements like Join, Inner Joins, Outer joins and Self Joins used TOAD and SQL Developer
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Tested Cognos Reports including Cascade, KPI’s, Dashboards, Master-Detailed, Summarized and Aggregated Reports.
• Test Management tool --Quality Center 9.0 is used to prepare test cases, for test execution and to extract testing status and Defect tracking.
• Responsible to tactfully communicate with project managers, development managers, release managers and developers to ensure comprehensive test planning and execution.

Environment: Ascential DataStage 7.0, SQL, PL/SQL, Oracle 9i, SQL Server 2000, Cognos 7.0 Series, DTS, Quality Center 9.0, WinSQL, TOAD, XML, JAVA, JDBC, Mainframe, VSAM Files, UNIX

Confidential

Test Engineer

Responsibilities:

• Involved in Design and development of test plans based on high-level and detailed designs.
• Analyzed the use cases given by the business analysts and developed test cases using them.
• Worked with the team lead to coordinate the test case turnover process proceeding each cycle and selectively executed the test cases to verify that they are kept current.
• Performed black box/functional testing, regression testing on Application Under Test
• Performed manual testing on various modules of the Application.
• Generates functional test cases that capture actual code behavior as a deployed application is exercised
• Written complex SQL queries to validate the front-end screens.
• Front-end testing includes Functionality, navigation, Alignments, links validation,
• Session management, cookies, Authentication, company specific colors, privacy policy using different web browsers for eight different web sites.
• Executes the test suite to identify regressions and unexpected side effects
• Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources)
• Monitors test coverage and achieves high coverage using branch coverage analysis
• Tests individual methods, classes, or large, complex applications
• Tracks how test results and code quality change over time
• Conducted performance and load testing using Load Runner
• Analyzed, reported and kept track of defects using Test Director.
• Provided testing results and weekly status report to the QA lead, provided test summary report once project was fully completed.

Environment: Windows NT, MS-Office Tools, Manual Testing, Test Director 7.5, Oracle 8i, Java, Servlets and Java Script.