SUMMARY

• Over 10 years of Experience in teh 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 teh 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 teh 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 wifin 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 teh business requirement in discussion wif teh client.
• Preparation of Effort Estimations and Test Strategy for Module level for test execution phases.
• Prepare teh ITP (Integrated Test Plan) and SITP (System Integrated Test Plan) Documents.
• Schedule teh ITP review call wif business people to discuss on Test plan.
• Preparing, reviewing & executing Test Scenario & Test cases.
• Preparing teh Traceability matrix for teh requirements using quality center (QC).
• Validating teh source feed EOD(End of Day) and Intraday based on mapping.
• Validating teh data in Staging, Warehouse and Mart tables and relatele
• Checking teh data flow & functionality from Staging to Warehouse and to Data Mart.
• Involved in executing teh abinitio graph through unix wrapper scripts.
• Involved in execution of PL/SQL procedures through unix wrapper scripts.
• Involved in testing teh View & materialized view.
• Involved in execution of Report & Dashboard in web based micro strategy application.
• Involved in testing teh application on different environments like SIT & UAT.
• Involved in testing teh front end CCRS reports and validating teh data in teh backend.
• Logging defect and tracking teh 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 teh business requirement.
• Preparing teh Test Artifacts and Test scenario and Test cases.
• Uploading teh Test scenario and Test Case in Quality Center
• Preparing RTM (Requirement Traceability Matrix ) and executing teh Test cases.
• Validating teh source feed based on mapping.
• Checking teh data flow & functionality from Staging Warehouse Data Mart.
• Involved in executing teh abinitio graph through unix wrapper scripts.
• Involved in execution of PL/SQL procedures through unix wrapper scripts.
• Involved in testing teh View & materialized view.
• Involved in testing teh application on different environments like SIT & UAT.
• Preparing teh Traceability matrix for teh requirements using quality center.
• Logging defect and tracking teh 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 teh user requirements from System Requirement Specifications (SRS) document.
• Involved in teh creation and execution of test cases
• Gathering teh test data and creating teh test scenario
• Preparing teh test reports and test results
• Reporting teh issues and defects in teh QC bug Tracking System.
• Preparing teh Sign-Off wif complete information.
• Attended weekly status meeting and provide detailed status report.
• Involved in teh Production Implementation at clients co -location place.
• Coordinating wif Development Team to discuss about defects and verified fixes and closed bugs during regression test cycle.
• Document teh 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 teh user requirements from System Requirement Specifications (SRS) document.
• Involved in Sanity Testing, Regression Testing, Functional testing and System testing.
• Involved in teh creation and execution of test cases
• Gathering teh test data and creating teh test scenario
• Preparing teh test reports and test results
• Document teh defects using Defect Tracking System (DTS) and review of customer documentation
• Reporting teh issues and defects in teh QC bug Tracking System.
• Preparing teh Sign-Off wif complete information.
• Attended weekly status meeting and provide detailed status report.
• Coordinating wif 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 teh Test requirements.
• Design teh Test Scenarios and Test Cases.
• Prepare teh test data for test execution.
• Involved in Sanity testing.
• Involved in teh test case execution.
• Identified teh issues and interact wif developers to resolved issues.
• Involved in Retesting and Regression Testing.
• Database verification by executing SQL queries.
• Preparation of test reports on Daily basis.
• Maintaining teh time sheet

Environment: ASP.Net, SQL Server 2005, XML

Confidential

Responsibilities:

• Analysis teh Test requirements.
• Design teh Test Scenarios and Test Cases.
• Prepare teh test data for test execution.
• Involved in Sanity testing.
• Involved in teh test case execution.
• Identified teh issues and interact wif developers to resolved issues.
• Involved in Retesting and Regression Testing.
• Database verification by executing SQL queries.
• Preparation of test reports on Daily basis.
• Maintaining teh 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 teh test cases based on teh criticality
• Ensured teh coverage of teh test cases through traceability matrix
• Functional test execution
• Verification of teh migrated customers, accounts, deposits and GLs to teh enhanced version including teh verification of teh interest accruals and liquidations

Test Engineer

Responsibilities:

• Reviewing teh 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 wif 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 teh records
• Quality Center used to maintain test cases and test execution status wif and test results.
• Responsible in providing regular test reports to teh QA lead and Project Manager.
• Attend project meetings, daily status, and defect scrub meetings, and provide test status.
• Tracked all defects in teh Test Director and update status test life cycle and disposition
• Developed Defects, Test Status reports wif Charts from Test Director and provide to team
• Production test data created early, for teh production test case execution.