· Worked with business line and development teams to understand data mapping documents, requirements and design.

· Scheduled and prioritized work and activities to meet target schedule, quality, scope, and cost objectives.

· Hands on experience on UNIX and Create, execute complex SQL queries to perform data completeness, correctness, data transformation and data quality testing for source to target mapping within the data warehouse

· Worked and verified the data moving between Ready API, Hive, HDFS and Cloudant.

· Written SQL queries including complicated joins to verify proper mapping of data elements.

· Tracked quality assurance metrics such as test execution, defect densities and open defect counts.

· Strong debugging, problem solving and investigative skills. Ability to assimilate disparate information (log files, error messages etc.) and pursue leads to find root cause problems.

· Reported the status of test planning, defects and execution activities, including regular status updates to the project team using quality metrics

· Leading the team and reporting testing status to client on daily basis and highlighting the issues/impediments in the meetings.

· Ensured all sign offs on deliverables (overall test strategy, test plan, test cases, etc.) and that testing meets governance requirements

· Communicated and managed expectations of the senior management team and affected stakeholders during the planning and roll out of project releases

Environment: Rally, DB Visualizer, Hive, Ready API,Hadoop, HDFS, Cloudant, Moba Xterm, Unix, Internet Explorer, Windows 10

· Developing and executing detailed testing plans, mapping test cases to business requirements.
Responsible for end to end testing of software products.

· Validating source files received from the source systems and creating test data to cover all negative and positive test scenarios.

· Writing complex SQL queries for verifying the target tables with business rules.

· Doing the root cause analysis and backtracking the issue up to the source data if any discrepancy found in data.

· End to End reconciliation of data from source to target.

· Bug fixes verification and validations.

· Designs software QA methods and procedures for use by QA and development staff to ensure all information systems meet minimum company standards and end user requirements.

· Develop QA test plans and project staffing estimates.

· Work closely with the other members of the Development Team to review the designs of systems, implement test plans, and test the quality of software products.

· Leading the team and reporting testing status to client on daily basis and highlighting the issues/impediments in the meetings.

· Being a team lead helping the new team members in resolving their queries/doubts and grooming them.

Environment:HP Quality Center, Toad for Oracle, SQL Server, Informatica 9.1, Unix,Internet Explorer, Windows 10/7

· Analyzed the Business Requirement Documents, Functional Requirements and Database Design Document to better understand the actual application functionality.

· Analyzed the Test plan, which detailed the testing scope, strategy, test requirements and necessary resources

· Analyze the Source to Target Mapping and Release Notes Documents

· Validate the Transformation Rules based on the Source to Target Mapping

· Validated structure of the Target Database as specified according to Mapping Document.

· Validated data availability in the Target Database (Netezza) based on the Release Notes.

· Written SQL Queries to extract data from various database tables for testing purpose

· Validated the Transformation Rules based on the Target to Data Mapping Document.

· Validated structure of the Database as specified according Mapping Document.

· Tested the ETL Informatica/Datastage mappings and other ETL Processes (Data Warehouse Testing)

· Created Test Data to test different scenarios after a thorough analysis of the applications

· Participated as a key member with the UAT Team for Regression testing where day-to-day bugs were monitored

· Coordinated with developers and the testers for resolution of the problems reported

· Reporting bugs in the HP Quality Center.

· Attended daily status/ defects review meetings

· Extensively involved in User acceptance Testing (UAT).

Environment:HPQuality Center, Toad for Oracle, SQL Server, Toad for Data Analysis(Netezza), Informatica 9.1,Datastage,Unix,Internet Explorer, Windows 10/7

· Analyzed the Business Requirement Documents, Functional Requirements to better

understand the actual application functionality.

· Participated in various phases of the Software Life Cycle and performed Manual Testing on different modules of the application

· Analyzed the Test plan, which detailed the testing scope, strategy, test requirements and necessary resources

· Performed sanity testing, functional testing, integration testing, system testing and Data base testing through different iterations.

· Written SQL Queries to extract data from various database tables for testing purpose

· Tested the ETL Informatica/Datastage mappings and other ETL Processes (Data Warehouse Testing)

· Created Test Data to test different scenarios after a thorough analysis of the applications

· Participated as a key member with the UAT Team for Regression testing where day-to-day bugs were monitored

· Coordinated with developers and the testers for resolution of the problems reported

· Reporting bugs in the HP Quality Center.

· Attended daily status/ defects review meetings

· Extensively involved in User acceptance Testing (UAT).

Environment:HPQualityCenter,SQLServer2005/2008,Datastage,Informatica9.1,Progress 4GL,HTML,Unix,Internet Explorer, Windows XP

· Analyzed requirements and Database Design Document.

· Involved in Requirements review meetings.

· Worked with end users to get the requirements.

· Prepared test plan and get approved by Client.

· Prepared estimation for test design and execution phases.

· Transfer the application and business knowledge to team members.

· Prepare the Clarification notes if have any quires in the document reviews

· Analyze the Source to Target Mapping and Release Notes Documents

· Validate the Transformation Rules based on the Source to Target Mapping

·Validated structure of the Target Database as specified according

Mapping Document.

·Validated data availability in the Target Database (MDM) based on the Release

Notes.

· Prepared the SQL queries against Source Database.

· Validated the Transformation Rules based on the Target to Data Mapping Document.

· Validated structure of the Database as specified according Mapping Document.

· Validated data availability in the Data in Database based on the Release Notes.

· Prepared SQL Queries against Target Database.

· Prepared Traceability matrix for ETL Testing.

· Log the defects in the Defect Tracing Tool QC

· Support the UAT users and clarify the questions.

Environment: HPQuality Center, MS SQL Server2005/2008,Datastage,Informatica 8.6/9.1,Toad, Oracle 10G,HTML, Unix,Internet Explorer, Windows XP

• Attended Pre Project Planning (PPP) meeting to provide estimations.
• Responsible for identifying dependencies, interfaces between applications.
• Analyzed Client request and requested the developers for the design change by considering both positive and negative scenarios of business logics and developed test case accordingly.
• Responsible for identifying testing scope, approach & right tools based on technology.
• Involved in testing the layout of various Extension screens as per design specifications
• Executed the test cases for both functional and GUI analysis in the Regression suite.
• Documented the errors and tracked them to completion.
• Participate in review meetings, suggest analysis process, and establish guidelines.
• Interact with users and document any changes in business requirements.

· Coordinate with SMEs to identify risks, dependencies, define entry and exit criteria. .

• Coordinate with Development teams and Software management teams for Code deployment.
• Responsible for tracking and closing defects during SIT/UAT.
• Coordinate with Business Partners for user signoff before handing over to production teams.

Environment:Toad for Oracle, MS SQL Server2000/2005, HTML, Internet Explorer, Windows XP