SUMMARY

• 9.5 Years of Extensive experience in IT Industry with emphasis on Quality Assurance & Software Testing.
• 6 years of experience in Data Warehousing/ ETL Testing within the environment of Oracle, SQL Server and 3 years of experience in manual testing on web based, Client/Server and data warehousing applications.
• Expertise in writing SQL Queries using Oracle, SQL Server and Teradata in validating data into Data Warehouse/ETL applications.
• Strong working experience in the Data Analysis, Data Verification and Validation of an ETL Applications using Backend/Database Testing.
• Experience with Testing mobile(iOS, Android, Windows)applicationsoverdifferent platforms.
• Experience with working tools like MS SQL Server Management studio, SQL Developer, Win SQL, Teradata for creating and executing SQL Queries.
• Experienced in complete Software Testing Life Cycle (STLC) and Defect Life Cycle.
• Extensive experience in Black Box Testing, Smoke testing, Functional Testing, Integration Testing, System Testing, Regression Testing, End - to-End Testing, User Acceptance testing (UAT)
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Involved in preparation of Test Data to test the functionality of ETL Sources, Mappings and Targets.
• Worked under Testing methodologies like Agile-SCRUM and Waterfall Model.
• Involved in Testing of Business Objects reports by executing the SQL Scripts.
• Expertise in Defect management, Bug tracking, Bug Reports and generating the graphs using Test Management Tools such as HP Quality Center ALM & TFS (Team Foundation Server).
• Involved in preparation of Traceability Matrix based on High/Detail requirements and Test Cases to ensure comprehensive test coverage of requirements.
• Experience in maintaining support documents, QA Sign off Documents and maintaining Weekly Status Reports.
• Have been trained in Automation Testing and Selenium tool.
• Having hands-on experience in ETL tools such as Informatica and Datastage.
• Worked and reviewed along with Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications.
• An effective communicator with strong analytical abilities combined with skills to plan, implement & presentation of projects.

TECHNICAL SKILLS

• Teradata, Sybase Oracle
• MS SQL Server, DB Visualizer
• Windows XP, Vista, 7
• Unix, Linux
• SQL and basics of C, Java
• HP Quality Center 11.52 ALM, SQL Developer
• Oracle Data IntegratorFitnesse tool
• Talend, Beyond Compare, Oracle Express
• Win SQL, Informatica, DataStage, Selenium, JIRA

PROFESSIONAL EXPERIENCE

Confidential

Test Lead

Responsibilities:

• Analysis of business and functional requirements with team and getting all the queries clarified
• Identifying the Test scope
• Preparation of Test Strategy and Test Plan documents
• Reviewing the Test Strategy and Test Plan documents with Solution team, Business Team & Project team and getting it signed off
• Organizing required KT and trainings for team members
• Preparation of Test Readiness sheet
• Reviewing the Test cases with Solution team, Business Team & Project team and getting it signed off
• Maintaining Test cases in ALM
• Co-ordinating with team members in preparing the Test data, Test execution
• Maintaining the defects in ALM and tracking the same
• Leading the daily Defect Triage calls with all supplier teams, Solution team, Business Team & Project team
• Sending Daily Test Execution Reports and Defect Summary Reports
• Reviewing Test cases and Test execution results with clients
• Defect closure and Test Summary report preparation
• UAT support for Business team
• Identifying the scope for automation and developing the automated test scripts

Technical Platform: MPS systems, POS systems, Ingenico Devices, PIE system, Common Object. Technical Knowledge on other systems such as EPP, Tempus, TeleCheck, BCssP, BAMS, MNP, BCssP

Confidential

ETL Test Lead

Responsibilities:

• Analysis of business and functional requirements
• Preparation of Test Strategy and Test Plan documents
• Test data preparation and writing test cases.
• Validation of business rules on data by writing SQL queries using inner, outer joins, subselects, etc for both historical and incremental load
• Co-ordinating with offshore team
• Reviewing test cases and test execution results with clients
• Defect closure and Test Summary report preparation

Technical Platform: HP Application Lifecycle Management(ALM), Oracle Express, Win SQL, Business Objects

Confidential

Test Lead

Responsibilities:

• Worked withBusiness Analyststo define testing requirements to satisfy the business objectives.
• Responsible for creating completetest cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Experience inSDLCand Agile methodologies such as SCRUM and KANBAN
• Analyzing requirements and creating and executing test cases
• Analyzing requirements, Creation and execution of test cases
• Performed Integration, End-to-End,systemtesting.
• Involved inFunctional Testing & RegressionTesting
• Used Quality Center for creating and documenting Test Plans and Test Cases and registering the expected results.
• Preparation of Weekly status report and Monthly status report
• Involved in testing web-based applications which are used to submit the health Claims and Benefits.

Technical Platform: HP Application Lifecycle Management(ALM), NaviLink, iServices, MERLIN, Teradata

Confidential

ETL Test Analyst

Responsibilities:

• Analysis of business and functional requirements
• Test case preparation and writing test scripts.
• Validation of business rules on data by writing SQL queries using inner, outer joins, subselects, etc
• Validation of reports from business objects
• Reviewing test cases and test execution results with clients
• Validation of Historical and Incremental data

Technical Platform: HP Application Lifecycle Management(ALM), Oracle Express, Win SQL, Business Objects

Confidential

Test Analyst

Responsibilities:

• Gathering the requirement from client
• Analysis of the business functionality of MediaPad Application
• Testing the functionality of the application
• Validation of business rules/transformation logics
• Data validation using Beyond Compare tool
• Contribution for Process Improvement team towards Cycle Time reduction
• Test Cases/Execution results review with Clients
• Raising and Tracking Defects daily
• Sending daily status reports. Weekly status reports to clients
• Testing of Singapore, Australian applications

Technical Platform: MediaPad application(Singapore & Australia), HP Quality Center, Beyond Compare, Talend

Confidential

ETL Test Analyst

Responsibilities:

• Analysis of business and functional requirements
• Test case preparation and writing test cases.
• Validation of business rules on data by writing SQL queries using inner, outer joins, subselects, etc
• Test execution using Fitnesse tool and HP Quality Centre
• Reviewing test cases and test execution results with clients
• Raising and Tracking Defects
• Legacy System comparison
• History Data Validation
• Eventing console and Sync Testing
• Supported other teams such as NBI and AD-VOD programs

Technical Platform: DB Visualiser, HP Quality Centre, Fitnesse(Semi-automated tool for testing), Oracle Data Integrator(ODI), Eventing Console, Beyond Compare

Confidential

ETL Test Lead

Responsibilities:

• Gathering the requirement from client
• Analysis of the business functionality
• Test Strategy Preparation
• Test plan Creation
• Validation of data for mapping/business transformation logics
• Data comparison using Fitnesse and Beyond Compare
• Task Allocation to the team members
• Test Case Creation / Review
• Test Execution Review
• Raising and Tracking Defects using Hp-Quality Center
• Documentation
• Responsible for all the test deliverables related to MCH-NCS

Technical Platform: DB Visualiser, Quality Centre, Fitnesse, ODI

Confidential

ETL Tester

Responsibilities:

• Requirements collection and analysis
• Prepare and analyze the design, which would help throughout the software development life cycle.
• Coordinating with the Operations, Network, Database and QA teams on a regular basis and brain storm on solutions.
• STLC
• Analysis, Estimation
• Test Strategy Preparation
• Test Plan, Design and Execution with review
• Defects and Metrics Reporting
• Test Summary and Sign Off
• Supporting Quality Assurance Activities
• Integration Testing Activities with UP and DOWN Stream systems
• SQL queries and Stored Procedures for huge Data validations.
• Augment the testing process by generating test cases for the specified rules.
• Prepare and analyze the causal analysis report for defects found and to resolve it.
• Job Scheduling in a Special Control M Application.
• Following the TCS Quality process for the deliverables

Technical Platform: DB Visualiser, Quality Centre, Fitnesse(Semi-automated tool for testing)