SUMMARY:

• Around 5+ years of experience in Data Warehouse testing, Business Intelligence reports, ETL applications in various domain.
• Having extensive experience in backend testing, starting from project initiation activities till closure and exhibited great capabilities across each phase of the lifecycle.
• Have worked in different domains and domain knowledge has never been a hurdle through quick grasp and adaptability in the projects
• Key activities include test strategy, planning, estimation, test case design, test execution (defect management) & traceability matrix
• I have profound knowledge in entire testing life cycle process and played pivotal role in establishing process for new assignments.
• Having strong knowledge on demonstrating good skills of evaluating testing process, performing gap analysis and provides suitable recommendations across multiple QA areas.
• Expertise in Functional Testing, System Testing, Regression Testing, Backend Testing, ETL / Report Testing and UI Testing.
• Expertise in testing ETL tool like Informatica, DataStage.
• Having experience in Ab Initio.
• Conducted Defect Triage meeting and driven Retrospective meetings (Test phase summary review)
• Expertise in Test management tools - HP ALM 11.5, Quality Center 10.0, Test Director.
• Conducting Scrum meetings to make sure deliverables are made at right time
• Validated reports developed in OBIEE, and Crystal report.
• Good knowledge and working experience in using UNIX commands and VI Editor
• Having extensive Years of experience in validating ETL, PL/SQL, UNIX batch jobs scheduled using Autosys
• Very good working knowledge of water fall and Agile Software Development Life Cycles and good experience in working fast paced agile environments.
• Very good knowledge in various data warehouse built on Oracle, SQL Server, Teradata
• I have been a quick learner with the ability to make solution-oriented, creative and innovative contributions in highly demanding situations and also good in process documents and has been trained to handle process audits.
• Excellent communication, technical skills and very good team player.

TECHNICAL SKILLS:

ETL Tools: IBM DataStage version 7.5, 8.1 & 9.1 Informatica 7.1.3 & 8.6.0,Ab Initio

Reporting Tools: OBIEE 11.1.1.6.9 Reports

Databases: Oracle 11g, SQL Server 2005,Netezza

Test Management Tools: ALM Quality Center 11/ 10.0 & Mercury Test director

Defect Management Tools: ALM Quality Center & Mercury Test director

DB Query Tools: Toad 9.7, SQL Developer-3.2, SQL * Plus

Tools: Oracle SQL Developer, Toad version 9.5 & SQL developer

Operating Systems: Windows NT/2000/XP/7

Programming Language: PL/SQL, SQL

Other Tools: Putty & WinSCP

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Environment: Datastage, WinSCP, HP ALM 11.5x, UNIX, OBIEE 11g, Java, Autosys, Putty & WinSCP

ETL Tester/ Data Analyst

Responsibilities:

• Understand the priority of testing from the Business perspective & Conceptual understanding of the testing lifecycle.
• Involved in Effort estimation and tracking of the project plan for QA activities
• Preparing QA Test Strategy, test plan and impact analysis document for new project / change request (CR).
• Involved in creating the test cases based on Functional requirements, Business requirements, Mapping specifications, Entity relationship documents
• Used Datastage Director to execute the Sequence/Parallel jobs. Debugging any issues in job using Datastage designer addressing exact issue while raising defects.
• Performing Backend testing and ETL testing
• Performing data validation in ETL code, batch jobs scheduled using Autosys
• Designed mock up test data using excel to test the application with positive and negative scenarios.
• Used SQL Developer to run SQL queries to check data is populating as expected from tables.
• Validating the custom reports and ad hoc reports built in OBIEE
• Validated the slowly Changing Dimension type IV based on the requirement
• Performing in data validation, data profiling, data scrubbing, and data frequency analysis
• Managed the defect tracking process using QC & conducting defect triage meeting on daily basis to prioritize the defects.
• Effective execution of test cases, Responsible for system testing.
• Uploaded test cases into ALM Quality Center and executed them in test lab
• Involved in testing reports and closely worked with Release team, Development team to complete the SIT phase
• I will prepare test phase summary report and send to business approval.
• Root-cause analysis and co-ordination meetings and also participates in quarterly process audits

Confidential, Atlanta, GA

Environment: Datastage, Informatica, Teradata, ORACLE,Netezza, SQL Server & DB2, OBIEE 11g

ETL Tester/ Data Analyst

Responsibilities:

• Involved in Effort estimation and tracking of the project plan for QA activities.
• Prepared Test Plan and the Test Strategy based on requirement documents
• I am responsible for Environment setup for Informatica based on ST available database.
• Ability to analyze and make corrections in testing plan strategies
• Involved in all phases of Agile Development Methodology.
• Extensive experience of testing with agile process.
• We have tested more than 250+ jobs from Informatica to Datastage conversions in this project
• Ability to audit proposed test coverage, test cases/scripts, test design and test techniques
• Prepared & reviewed Test scenarios, Test cases and Test Data, Test case Design, Execution
• Created traceability matrix to map Test cases against Requirements using Quality Center.
• Involved in reviewing and modifying test cases & scripts after initial iterations of testing phases to account for changes in project scope.
• Developed SQL queries for complex data validations for ETL jobs, PL/SQL & OBIEE reports.
• Validated whether Source to Target ETL mappings are according to transformation rules and Business Rules.
• Verified the ETL mappings and boundaries of each field to find any database limitations.
• Used Informatica workflow manager to execute the workflows and Informatica workflow monitor to monitor the status of the workflows.
• Prepared complex SQL scripts for functional and data validation of ETL applications
• Extensively worked on SQL for checking backend validations of the applications and carried out End-to-End Testing.
• Managed the defect tracking process using QC and conducted defect triage meeting on daily basis to prioritize the defects.
• I will prepare test phase summary report and send to business approval.
• Interacting with business team for discrepancies in data between Informatica and Datastage and sending details to email for business approval.

Confidential

Environment: Forms D2k, Oracle PLSQ & Mercury Test director.

Responsibilities:

• Creating Master Test Plan, Creating test scenarios and Test cases.
• Effective execution of test cases, Responsible for system testing.
• Managed the defect tracking process using QC.
• Prepared the Daily Status Report (DSR) and Weekly Status Report (WSR) and Monthly Status Report (MSR) for internal audit.
• Responsible for gathering Business Requirements and Functional Requirements
• Prepared & reviewed Test scenarios, Test cases and Test Data, Test case Design & Execution
• Tested the Data Validations in application using the SQL Queries in TOAD
• Involved in ETL testing using Oracle SQL Developer & UNIX batch jobs scheduled using Autosys
• Performed recon validation against report vs. tables
• Effective execution of test cases, Responsible for system testing.
• Involved in batch testing using Toad

Confidential

Environment: Visual Basic 6.0, SQL Server 2000, SQL, PL/SQL, Crystal Reports 8.5

Database Tester

Responsibilities:

• Creating test scenarios and Test cases
• Involved in Database testing and flat file data transfers with relying on a GUI layer
• Effective execution of test cases, Responsible for system testing.
• Tested the Data Validations in application using the SQL Queries.
• Involved in batch testing using SQL queries.
• Validate at the lowest granular level possible for field level
• Managed the defect tracking process using Mercury Test director.