SUMMARY

• Over 7+ years of extensive experience in Information Technology with emphasis on Quality Assurance, Data warehousing Testing, Manual testing of Web, and Client/Server based commercial applications.
• Experience in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data
• Verification, Data Loading, Data Warehousing/ETL testing and BI Reports testing thorough understanding various Requirements, Analysis and Design.
• Extensive experience in testing ETL data from multiple sources into Data warehouse using Informatica.
• Experienced in Preparation and Execution of Test Strategy, Test plan, Test Scenarios, Test Cases, Test Procedures, Test Scripts, Test data for SIT and UAT.
• Well versed with Software testing concepts, SDLC, Agile and Waterfall methodologies
• Implemented various Test cases for the Functional Testing, Regression Testing, Configuration Testing, Performance Testing, Back - End and User Acceptance testing (UAT)
• Used Quality Center / Rational Clear Quest / Jira for Maintaining the Test Plans, Test Cases, Test Execution, Defect management, and Bug Reporting.
• Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries, PL/SQL to perform back-end testing on databases like Oracle, SQL Server.
• Extensive ETL testing experience using Informatica Power Center 9.x/8.x/7.1/6.1 components (Designer, Workflow Manager and Workflow Monitor)
• Knowledge of Data modeling, E/R diagrams, normalization and de-normalization.
• Experienced in Creating and maintaining SQL Scripts Experience in working with business analysts, development groups in analyzing business specifications and in working with other testers to resolve technical and end-user issues.
• Excellent communication skills, ability to work as part of a team and on own. Versatile team player with interpersonal, technical documentation skills and efficiently handling multiple projects simultaneously.

TECHNICAL SKILLS

Mercury Interactive: Quality Center 10/9.0/8.2, TestDirector9.0/8.0/7.5

ETL Tools: Informatica Power Center 9.x, 8.x, 7.1, 6.1 (Designer, Workflow Manager, Workflow Monitor) Abinitio GDE, Toad, SQL Developer

IBM Rational Suite: Rational Functional Tester 8.0/7.0

Bug Reporting: Bugzilla, Jira

Version Control: PVCS Tracker, Rational Clear Case 7.1/7.0.1/7.0.0 , Visual Source Safe 2005, Control Version System CVS

Programming/Scripting Languages: SQL, PL/SQL, XSLT, HTML, XML

Operating Systems: Windows XP/NT/2000, Windows Server 2008, Unix

Databases: Oracle 10g/9i/8i, MS SQL Server 2000/2005, Sybase12.0/11.0, MS Access

Reporting Tools: Crystal Reports, Cognos 8.x

PROFESSIONAL EXPERIENCE

Confidential, NY, NY

ETL Test Engineer

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Interacted with senior peers or subject matter experts to learn more about the data.
• Validating the Workflows and running them using Workflow Manager.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL Informatica tool.
• Written Test Cases for ETL to compare Source and Target database systems.
• Executed the developed Test Cases and Test Plans.
• Responsible for creating Test Strategy for the Data Warehouse.
• Reported the Bugs/Defects using Quality Center 10 defect management tool.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Tested different detail, summary reports and on demand reports. Extensively used Cognos for report generation.
• Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Ensured data integrity and verified all data modifications and calculations during database migration.
• Performed Manual Functional testing with QC.
• Exported Manual Test Cases from MS Excel template directly to QC and executed the Test Cases in Test Director with Pass/Fail/Blocked status.
• Worked with Production environment to resolve several data issues.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Involved in Unit testing and integration testing of Informatica mappings.
• Performed Functional testing, System testing, Regression testing and Back end testing.
• Most of the part involved in Query execution whenever needed as per the requirement.
• Coordinated with the developers to resolve defects.
• Involved in documentation in order to maintain and run scripts for future enhancements.

Environment: Informatica Power Center 9.1, Oracle 10g, SQL, PL/SQL, Excel Files, Windows NT & UNIX, Quality center 10, Cognos8.4

Confidential, Newark, DE

QA / ETL Tester

Responsibilities:

• Involved in reviewing/analyzing Business Requirement Documents/Functional specifications/use cases.
• Worked with Business Analysts, developers while reviewing the Business Requirement Documents and when there are enhancements in the applications.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Peer reviewed test cases developed by QA team members and advice/point/discuss possible complex scenarios and make sure requirements are completely covered.
• Supported and provided test cases for UAT, staging and production Participated in review meetings and attended training sessions to understand various business concepts.
• Prepared Entry and Exit criteria for Testing cycles, review with functional leads and PMO.
• Exported Requirements, test plans and test cases to QC 9.2.
• Responsible for verifying the log files using UNIX and database for the submitted application
• Created Traceability Matrix to ensure that all requirements are covered in test cases.
• Develop Risk-based Test Strategy whenever required, to save time and to determine which test activities to carry out and created complexity matrices.
• Prepared Kickoff meeting PowerPoint and gave presentation on testing activities for each cycle of testing and for different releases.
• Conducted Defect meetings on daily bases to track defects status with functional leads and to speed up resolution process at end of each cycle.
• Interacting with developers, business analysts to communicate the defects.
• Bug reporting and Bug tracking using HP Quality Center.
• Involved in UAT process before rolling out to production when required. Participated in debugging prod issues along with support team.
• Worked in Agile methodology during application development and participated in daily scrum meetings.
• Developed user defined functions, created objects where required and used descriptive programming to automate.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Developed and ExecutedSQL statementsinToadto retrieve data and to validate data.
• Tested data migration to ensure that integrity of data was not compromised.
• Validated the data thru various stages of data movement from staging to Data Mart to Data Warehouse tables.
• Responsible for documentation of test results, test matrix,andparticipated in daily/weekly QA meetings.
• Used Quality Center for logging the defects.
• Conducted down test and up test for release builds pushed to UAT and to Production.

Environment: Informatica Power Center 8.6(Repository Manger, Designer, Server Manager), Oracle 10g, MS SQL, HP Quality Center 10.0/9.2, TOAD, MS Excel, UNIX.

Confidential, GA

ETL - QA Analyst

Responsibilities:

• Analyzed the Business Requirements and Rules and worked with Business Analyst and Business Users.
• Gone through the Functional Specifications and implemented their technical aspect In Functional Testing, System and Integration testing (SIT).
• Preparation and Execution of Test Plans, Test Cases for the mappings developed through the ETL Informatica 8 tool in the QA environment.
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Developed and documented data Mappings/Transformations, and Informatica sessions as per the business requirement.
• SQL queries used to validate source data versus data in the data warehouse including identification of duplicate records.
• Tested data warehouse ETL process using SSIS (Integration Service).
• Analyzed the Business requirements of the project by studying the Business Requirement Specification document.
• Strong in writing complex SQL queries to profile and analyze the data in Oracle 10g.
• Used SQL queries & Join operations to Test database tables.
• Knowledge of moving application packages from Dev to QA and Production.
• Used different Querying tools like SQL Developer, Toad 9 to query different databases.
• Reviewed the Functional specifications, requirements document to determine the functionality of the application.
• Created Test Plan, wrote Test Cases and executed them.
• Used HP Quality center to maintain requirements, Test Plan, Test Cases and to Log Bugs identified during testing of the application.
• Coordinated with Business, UAT, development and production support teams to oversee Test Execution.
• Used status reports, Test Summary reports and Test Progress report with various test metrics.
• Actively involved in conducting defect review meeting with Developers and Business Users.
• Involved in Signoff meetings and go or no go meetings with Business Users.
• Involved in preparation of Test data.
• Used Waterfall SDLC model.
• Performed Functional, String, Integration, Regression, Performance, System and Usability testing of the application.

Environment: Informatica Power Center 8, SSIS, Oracle 10g, PL/SQL, SQL*Plus, HP Quality Center 10.0, Toad, SQL Developer.

Confidential, Detroit, MI

QA / ETL Tester

Responsibilities:

• Worked alongside with Business Analyst and Technical Architects in Analysis of Business and Functional requirements.
• Attended Client meetings to gather the requirements and fill in the gaps in present requirements.
• Delegated QA meetings with the team and Project Management.
• Developed test plan and Responsible for creatingTest Strategyfor the Data Warehouse.
• Written manytest casesandtest proceduresusingMS Excel.
• Initiated the QA process in the project along with team lead and acted as QA point of contact to the team.
• Performed different phases of testing like Smoke testing, Functional testing, UI testing, Integration (End-to-End) testing, Regression testing and UAT testing.
• Rigorously performed Regression testing for every modification/enhancement of the project.
• Strong in writingcomplex SQL queriesto profile and analyze the data inOracle 10g.
• UsedInformatica Power Center 8.5 toanalyze the mappingsand sometimes even debug them to compare the code with respect to the requirements specification, also usedWorkflow Manager,Workflow MonitorinInformaticato run the ETL and monitor the ETL jobs along with reading the log files to find out the errors.
• Used different Querying tools likeAdvanced Query Tool, Toad for Oracle 10g to query different databases.
• Tested ETL’s to ensure that the source and the target are mapped as per the Requirements/specifications.
• Helped loading the test data in testing Environment to ensure the tests are done with no data issues.
• Logged numerous defects for the project in to Clear quest.
• Initiated Defects review meetings with Developers and communicated with them for whole defect life cycle until the logged defect is closed and verified.
• Mentored new QA resources to understand the business process and our test methodologies.

Environment: Informatica Power Center 8.5, MS SQL 2000, Oracle 10g, TOAD, Windows XP and 2000, IBM Clear Quest, Quality center 8, Confidential Compare.

Confidential

DWH Tester/ ETL QA

Responsibilities:

• Tested business rules to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
• Developed Test Cases to cover overall quality assurance testing.
• Performed manual testing on different modules of the application.
• Developed, tracked and managed Issues Log created during the test phase using Excel.
• Performed data integrity testing by executing SQL statements and manually verifying the contents.
• Used SQL on Windows platform to perform Backend Testing on databases.
• Developed deployment instructions to support the deployment of data marts and reports.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Prepared Test Plan from the Business Requirements, detected defects tracked and reported bugs using Test Director.
• Involved in writing testing methodology by following standards for test documentation, test requirements and test procedures.

Environment: Informatica Power Center 7.1.2, Oracle 9i, PL/SQL, TOAD, SQL*Loader, XML, SQL, PL/SQL, HTML, Windows NT/2000