SUMMARY

• Over 9 years of experience in Software Testing - Manual, ETL, Cognos.
• Have a very good exposure and understanding of Software Development Life Cycle.
• Proficient in product life cycle of Quality Assurance - Integration Testing, Regression Testing, Functional Testing and System Testing
• Strong with data models, Extraction and transformation rules
• Well versed with Cognos, Oracle SQL Developer, Toad, Teradata
• Strong identification and mitigation of existing data defects and errors
• Excellent in writing complex queries for testing Extraction, transformation rules as part of ETL testing
• Strong in understanding the source to target data mapping based on LLD
• Detail focused approach
• Writing, Reviewing, and Executing Test cases, plans and scripts.
• Experience in onshore offshore model with time management and delivery excellence.
• Experience in Working with Quality Center/ALM.
• Adherence to different phases of Defect Life Cycle to ensure quality of software.
• Experienced in meeting deadlines and delivering high quality work.
• Superior ability to collaborate with all stakeholders
• Strong time-management and organizational skills
• Good Project Management and Excellent Communication Skills
• Highly analytical with strong critical-thinking and problem-solving abilities

TECHNICAL SKILLS

Document Management Technologies: Documentum, Team space

Systems: MODELN, Veeva, IDD, Javelin, Cognos

Test Management Tools: HPQC, ALM

Database: Oracle, SQL Server, MS Access, Teradata, Toad

Operating Systems: Windows 7/ Vista/ XP/ 2000/ NT/ 8.1, Unix

PROFESSIONAL EXPERIENCE

Confidential

ETL Test lead

Responsibilities:

• Draft scenarios based on requirement documents
• Estimated resource and time effort required for all testing activities
• Review requirements against design document for accuracy
• Lead the effort of creating dual purpose test scripts(OQ’s) for System Integration Test (SIT) and User Acceptance Testing (UAT)
• SME Review scripts written by team members for accuracy and satisfactory testing of the requirements
• Dry run the test scripts in Dev environment and then perform formal execution in Test environment
• Facilitate the calls with QA team to get the review and pre- validation approval done.
• For data coming in from external vendor mock up/modify input files for different testing scenarios
• Update data for incremental load scenarios by running Insert, Update or Delete queries.
• Coordinate the entire formal test execution effort
• Create Traceability Matrix & Co-authored the Test Plan
• Getting necessary pre and post validation approvals
• Trained new team members on ETL concepts and basic understanding on writing SQL queries.
• Report and follow-up on bugs found
• Lead the defect triage calls with Development, business team and stakeholders
• Assist in post-validation review of the validation effort
• Development summary reports review and follow ups for approval from QA team
• Good understanding on ETL and DWH concepts.
• Some amount of understanding on Unix concepts (used Putty).

Tools: Used: SQL, Teradata, ALM, Putty

Confidential

ETL Test Lead

Responsibilities:

• Draft test cases based on UAT scenarios
• Estimated resource and time effort required for all testing activities
• Meet all the downstream application owners to confirm if they would be ready/available to participate in E2E testing
• Gather the system requirements for all the downstream applications and pass on to offshore team for test preparation
• Lead the effort of creating dual purpose test scripts(OQ’s) for E2E and User Acceptance Testing (UAT)
• SME Review scripts written by team members for accuracy and satisfactory testing of the business scenarios
• Dry run the test scripts in Dev environment and then perform formal execution in Test environment
• Facilitate the calls with QA team to get the review and pre- validation approval done.
• For data coming in from external vendor mock up/modify input files for different testing scenarios
• Update data for incremental load scenarios by running Insert, Update or Delete queries.
• Coordinate the entire formal test execution effort
• Create Traceability Matrix & Co-authored the Test Plan
• Getting necessary pre and post validation approvals
• Report and follow-up on bugs found
• Lead the defect triage calls with Development, business team and stakeholders
• Assist in post-validation review of the validation effort
• Development summary reports review and follow ups for approval from QA team
• Good understanding on ETL and DWH concepts.
• Some amount of understanding on Unix concepts (used Putty).

Tools: Used: SQL, Teradata, ALM, Putty

Confidential

ETL Tester

Responsibilities:

• Effort estimation and obtaining required approvals
• Status updates to the stake holders and the Senior Management
• Effective resource utilization among projects.
• Facilitating KT session with on-shore team and client interaction for clarifications
• Review of test strategy, test plan and test execution plan
• Reviewing Test cases and resolving all the Teradata queries related issues.
• Getting clarifications from TA and helping team members in implementing those in Test Scripts.
• Understanding the requirements and writing test scripts for System integration testing.
• Writing Test specification documents for the Integrations, which outlines the various validations we are going to do in order to test the Integration thoroughly.
• Responsible for doing SME review for all the scripts related to Customers module of Master data.
• I lead in the box sessions for SIT Scripts approval. Basically my role is to explain TAs, BAs & Compliance people on how we have covered the requirement in our test cases.
• Direct interaction with Technical Architect on issues or Defect closure.
• Responsible for Handling defect Pre-triage calls for defect
• Responsible for reviewing the post execution run before assigning it to compliance for L1 approval.
• Once the testing is over and all the Defects are closed, I’m responsible for creating Test Summary Report and getting that approval from Compliance.
• Responsible for writing End to End test cases for Customers module.
• Involved in identifying test scenarios to be created as per functional requirements.
• Involved in authoring test case scenarios, test cases, developing and maintaining functional test scripts.
• Involved in peer review of all scripts authored by other team members
• Involved in execution of test scripts.
• Involved in reporting the defects through defect tracking tool in eRoom.
• Involved as project POC and SME for interaction with onshore client
• Estimating and planning effort for all new releases
• Analyzing the requirements
• Discussing the functionality of application with the programmers.
• Involved in preparing and reviewing test cases
• Executing test cases
• Raising defects
• Maintaining Bug Track.
• Sending Status report to the stake holders through Emails and Conference
• Single point of contact between onsite and offshore team
• Assigning work among the team members
• Migrating pages to Country specific page.
• Perform Internal QA for all the pages done by the team.

Tools: Windows XP, Vignette CMS and SM.