SUMMARY

• Over 10 years of Experience in the banking domain and software Testing(ETL Data warehouse Testing)
• Good exposure on Software testing life cycle and testing methodologies.
• Extensive experience in Functionality, Database, (Data warehouse) ETL testing.
• Leading, Tracking projects and coordinating offshore team from requirement phase to test closure phase.
• Monitoring and tracking project for ontime delivery.
• Preparing Estimation, Test strategy, Test planning (SITP & ITP) for projects and TD’s.
• Extensive experience in Data warehouse designing techniques like Star & Snowflake schema.
• Proficient in web based application testing & execution on micro strategy reports and dashboards.
• Extensive experience in validating the reports and drill down functionality on reports and dashboard.
• Proficient in SQL database using SQL queries and PL/SQL.
• Proficient in UNIX environment (AIX & Solaris).
• Proficient in executing abinitio jobs using wrapper scripts in Unix.
• Proficient in deriving test cases from System Requirement Specifications (SRS).
• Proficient in preparation of test specification.
• Experience in monitoring and Tracking of all the Test (Test Scenarios, RTM, Test cases, Test logs, Defect Logs)
• Extensive experience in RTM(Requirement Traceability Matrix), Test data preparation, Test Execution, Status Reports, Test Closure Report and Test Metrics preparations.
• Generate adequate test cases to ensure 100% coverage of testing.
• Involved in End to End Testcase preparation, Test Data Preparation, Testcase execution, Defect reporting, Tracking using Quality Center.
• Involved in Negative testing and END to END testing.
• Involved in installation of set - up within Testing Environment.
• Extensively involved in requirement analysis phase to Test closure activity phase.
• Extensively involved in client meeting on discussion for projects, Defect and Escalations.
• Preparation of Daily, Weekly and Monthly and status reports for management review.

TECHNICAL SKILLS

Operating System: Windows, UNIX(AIX & Solaris)

Language & Tools: SQL,PL/SQL, VB,QTP,Toad.

Database: Oracle 9i/10g, DB2, SQL server 2005.

Server: Solaris 10/AIX.

Defect Manager Tool: QC 10.0

PROFESSIONAL EXPERIENCE

Confidential

Test Lead

Responsibilities:

• Analyze and understanding the business requirement in discussion with the client.
• Preparation of Effort Estimations and Test Strategy for Module level for test execution phases.
• Prepare the ITP (Integrated Test Plan) and SITP (System Integrated Test Plan) Documents.
• Schedule the ITP review call with business people to discuss on Test plan.
• Preparing, reviewing & executing Test Scenario & Test cases.
• Preparing the Traceability matrix for the requirements using quality center (QC).
• Validating the source feed EOD(End of Day) and Intraday based on mapping.
• Validating the data in Staging, Warehouse and Mart tables and relatele
• Checking the data flow & functionality from Staging to Warehouse and to Data Mart.
• Involved in executing the abinitio graph through unix wrapper scripts.
• Involved in execution of PL/SQL procedures through unix wrapper scripts.
• Involved in testing the View & materialized view.
• Involved in execution of Report & Dashboard in web based micro strategy application.
• Involved in testing the application on different environments like SIT & UAT.
• Involved in testing the front end CCRS reports and validating the data in the backend.
• Logging defect and tracking the defects through QC.
• Involved in Test Closure activities till project or TD signoff’s.

Environment: Oracle 10g, UNIX & Abinitio

Confidential

DWH(Test Lead)

Responsibilities:

• Analyze and understanding the business requirement.
• Preparing the Test Artifacts and Test scenario and Test cases.
• Uploading the Test scenario and Test Case in Quality Center
• Preparing RTM (Requirement Traceability Matrix ) and executing the Test cases.
• Validating the source feed based on mapping.
• Checking the data flow & functionality from Staging Warehouse Data Mart.
• Involved in executing the abinitio graph through unix wrapper scripts.
• Involved in execution of PL/SQL procedures through unix wrapper scripts.
• Involved in testing the View & materialized view.
• Involved in testing the application on different environments like SIT & UAT.
• Preparing the Traceability matrix for the requirements using quality center.
• Logging defect and tracking the defects through QC (Quality centre).
• Involved in Test Closure activities till project or TD signoff’s.
• Handling Individual Module for Testing in multiple tracks and End to End Testing.

Environment: Oracle 10g, UNIX, Informatica & Abinitio

Confidential

Database testing

Responsibilities:

• Involved in understanding the user requirements from System Requirement Specifications (SRS) document.
• Involved in the creation and execution of test cases
• Gathering the test data and creating the test scenario
• Preparing the test reports and test results
• Reporting the issues and defects in the QC bug Tracking System.
• Preparing the Sign-Off with complete information.
• Attended weekly status meeting and provide detailed status report.
• Involved in the Production Implementation at clients co -location place.
• Coordinating with Development Team to discuss about defects and verified fixes and closed bugs during regression test cycle.
• Document the defects using Defect Tracking System (DTS) and review of customer documentation

Environment: Oracle 10g, UNIX, Quality center 10.0.

Confidential

Database Testing

Responsibilities:

• Involved in understanding the user requirements from System Requirement Specifications (SRS) document.
• Involved in Sanity Testing, Regression Testing, Functional testing and System testing.
• Involved in the creation and execution of test cases
• Gathering the test data and creating the test scenario
• Preparing the test reports and test results
• Document the defects using Defect Tracking System (DTS) and review of customer documentation
• Reporting the issues and defects in the QC bug Tracking System.
• Preparing the Sign-Off with complete information.
• Attended weekly status meeting and provide detailed status report.
• Coordinating with Development Team to discuss about defects and verified fixes and closed bugs during regression test cycle.

Environment: Oracle 10g, UNIX, Quality center 10.0.

Confidential

Responsibilities:

• Analysis the Test requirements.
• Design the Test Scenarios and Test Cases.
• Prepare the test data for test execution.
• Involved in Sanity testing.
• Involved in the test case execution.
• Identified the issues and interact with developers to resolved issues.
• Involved in Retesting and Regression Testing.
• Database verification by executing SQL queries.
• Preparation of test reports on Daily basis.
• Maintaining the time sheet

Environment: ASP.Net, SQL Server 2005, XML

Confidential

Responsibilities:

• Analysis the Test requirements.
• Design the Test Scenarios and Test Cases.
• Prepare the test data for test execution.
• Involved in Sanity testing.
• Involved in the test case execution.
• Identified the issues and interact with developers to resolved issues.
• Involved in Retesting and Regression Testing.
• Database verification by executing SQL queries.
• Preparation of test reports on Daily basis.
• Maintaining the time sheet

Environment: ASP.Net, SQL Server 2005, XML

Confidential

Test Engineer

Responsibilities:

• Handled of CASA, Deposits and Clearing modules
• Preparation of business scenarios, test scenarios and test cases
• Prioritization of the test cases based on the criticality
• Ensured the coverage of the test cases through traceability matrix
• Functional test execution
• Verification of the migrated customers, accounts, deposits and GLs to the enhanced version including the verification of the interest accruals and liquidations

Test Engineer

Responsibilities:

• Reviewing the business requirements document, and technical specifications document.
• Created all requirements in Test Director from Requirements finalized doc.
• Written SQL and PL/SQL statements for data validation.
• Developed Test Estimations to develop test cases and execution.
• Test Case status reports and defects reported weekly in Daily Project status meetings.
• Involved in Developing Test Cases, Test conditions and strategy.
• Traceability Matrix developed to map Requirements with Test cases.
• Involved in Unit, GUI, Functional, Integration, System, and Compatibility Testing.
• Performed Regression, and end to end business scenario testing.
• Developed SQL Queries for database validations for insert update, delete of the records
• Quality Center used to maintain test cases and test execution status with and test results.
• Responsible in providing regular test reports to the QA lead and Project Manager.
• Attend project meetings, daily status, and defect scrub meetings, and provide test status.
• Tracked all defects in the Test Director and update status test life cycle and disposition
• Developed Defects, Test Status reports with Charts from Test Director and provide to team
• Production test data created early, for the production test case execution.