SUMMARY:

• 8 Years of professional experience in IT services.
• Have extensive experience in ETL, Report, MDM, Database, data centric, Functional, Regression, Sanity, Integration and End to End Testing.
• Have been involved in activities such as preparation of test plan, test strategy, test cases, and test status reports.
• Have experience of planning, designing, executing, monitoring and controlling test activities.
• Have experience in following domains - Banking and Finance, Healthcare, Security, civil, Logistics.
• Experience of working in a role where interacting with customers on the business requirements and transforming the same to functional specifications.
• Good analytical, presentation, communication and interpersonal skills.
• Have been worked in multi-vendor environment.

TECHNICAL SKILLS:

Operating Systems: Windows, Unix

Languages: C, SQL

Database: Teradata, Oracle, DB2, SQL server

Business Intelligence Tools: SAP BO, Cognos, Tableau, SSIS

Other Tools: QC, Informatica, Autosys, QTP

SDLC Models: Agile/ Scrum, Waterfall Methodology

Domain: Banking and Finance, Healthcare, Civil, Logistics.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Testing Engineer

Responsibilities:

• Requirement Analysis
• Preparation of test cases and test data for ETL Data Validation, data centric and Report testing
• Performed Functional, Regression, Data Integrity, System Compatibility.
• Tested the ETL Informatica mappings, transformation, workflows.
• Tested the Cognos report with database testing
• SQL writing for ETL and report testing
• Defect Management
• Status Report Preparation

Confidential

Test Lead

Responsibilities:

• Requirement Analysis
• Coordinating offshore and onsite teams
• Preparation of test cases and test data for ETL Data Validation, data centric and Report testing
• Performed Functional, Regression, Data Integrity, System, Compatibility.
• T SQL, PL/SQL writing for ETL and Cognos reports
• Validation of informatica workflow, transformation, mappings
• Master Confidential MDM, informatica dvo validations
• Tested the Cognos report with database testing
• Defect Management
• Status Report Preparation

Confidential

Test Lead

Responsibilities:

• Co-ordination with different Vendors.
• Onshore-Offshore Team Management
• Test Management (Test environment readiness, Project Planning, co-ordination with different Project teams)
• Resource Planning and allocation
• Preparation of Test Plans and Test strategies
• Preparation of DSR and WSR
• Project Planning and Estimations
• Managing deliverables for different Test Phases
• SQL writing for ETL and SAP BO report testing
• Teradata BTEQ scripts validation
• Source and target data validation, data centric testing
• Defect Management
• Co-ordination for UAT and Go Live support

Confidential

Sr. Testing Engineer

Responsibilities:

• End to End testing, Requirement Analysis, Writing High level scenario, Test case
• Test execution- System Testing
• Interacting with business stakeholders’
• Extensively involved in Test Preparation, planning for Test Specification and Test execution.
• Understanding the (Use cases, etc) and the requirements
• Identification of all End to End scenarios for System Integration test, test data preparation
• Preparing detailed scenarios, test cases and requirements provided.
• Creation of Functional and System test cases.
• Regression and System testing of the system.
• Preparation of Test log and Defect log
• Peer reviews, preparation of DSR, WSR.
• Onshore offshore management

Confidential

Module Lead

Responsibilities:

• End to End testing, Requirement Analysis, Writing High level scenario, Test case
• Test execution- System Testing
• Interacting with business stakeholders’
• Extensively involved in Test Preparation, planning for Test Specification and Test execution.
• Preparation/Identification of all template and tailoring the template as per project requirement
• Understanding the (Use cases, etc) and the requirements
• Identification of all End to End scenarios for System Integration test, test data preparation
• Preparing detailed scenarios, test cases and requirements provided.
• Creation of Functional and System test cases.
• T SQL, PL/SQL query writing for pre aggregator and post aggregator report
• Workflow, Transformation testing for Informatica
• MDM Master Confidential validations
• Package testing for SSIS
• Source and target data validation, data centric testing
• Regression and System testing of the system.
• Preparation of Test log and Defect log
• Peer reviews, preparation of DSR, WSR.
• Onshore offshore management
• Preparation and providing signoff documents

Confidential

Sr. Testing Engineer

Responsibilities:

• Extensively involved in Test Preparation, planning for Test Specification and Test execution.
• Preparation/Identification of all template and tailoring the template as per project requirement
• Understanding the (SRS, Use cases, etc.) and the requirements
• Identification of all End to End scenarios for System Integration test, test data preparation
• Preparing detailed scenarios, test cases and requirements provided.
• Creation of Functional and System test cases
• T SQL, PL/SQL query writing for factors of rating methodology template
• Regression and System testing of the system.
• Preparation of Test log and Defect log
• Peer reviews, preparation of DSR, WSR.
• Interaction with counterparts at onsite, BA and Design Team.

Confidential

Sr. Testing Engineer

Responsibilities:

• Requirement Analysis
• Preparation of test Data
• Designing test cases
• PL/SQL query writing for module data verification
• Executing Functional and Regression testing
• Defect management
• Status Report Preparation