SUMMARY

• 7.1 years of experience in ETL Testing and Reports Validation.
• 2+ years of experience in leading the testing team.
• 2 years of experience in Product/Web Application testing.
• Experienced in creating complex SQL test scripts. Expertise to work on Teradata, Oracle & Mysql databases.
• Experience in debugging the complex issues and providing RCA to the client.
• Experience to work on Linux platform.
• Experience in Agile Methodology.
• Experience in writing Test strategy, Test Plan design, Test case Execution and preparing Test Summary Reports.
• Experience in preparing estimates and metrics.
• Experience in Interacting with clients for addressing their issues and Change requests.
• Experience in providing KT sessions to product support team with required documentation.
• Involved in Recruitment and training activities.
• Received many outstanding performance s as token of appreciation. Also received Team s, incentive & Long service s.
• Got client appreciations for most of the projects on successful completion under tough time lines.

TECHNICAL SKILLS

Testing: ETL Testing, Data base Testing, Manual/functional Testing.

Tools: HP Quality center, Rally, JIRA

RDBMS: Toad for Oracle, MySQL

Operating Systems: Unix, Linux, Windows.

PROFESSIONAL EXPERIENCE

Confidential

Team Lead

Environment: Toad for Oracle, HP ALM, Autosys and HADOOP.

Responsibilities:

• Participated in planning sessions, grooming sessions and retrospectives.
• Extensive onsite interaction to understand requirement analysis, formulating solutions.
• Understood the highly complex requirements for transformation of data in a format suitable for downstream platform and validated the business rules to ensure data is successfully submitted to AML.
• Involved in providing the estimates for the project.
• Designing and executing reusable global backend Test Scripts (SQL Scripts) to validate the data.
• Lead the team of 8 members and was involved in code review, test preparation, test planning, test execution.
• Was single point of contact for the offshore testing team and effectively passed on the information to the team by attending the late - night defect triage calls and other status meetings.
• This was an ongoing project with many phases and with target release date of 2020 and I was involved only in the phase 1 of this project.
• Efficiently allocating work and monitoring effectively of all the work performed by the team.
• Setting up the environment and running the Autosys jobs in testing environment.
• Preparing set of User acceptance scripts and validating data loaded to target tables.
• Participating in product demos.

Confidential

Team Lead

Environment: Toad for Oracle, HP ALM, Autosys.

Responsibilities:

• Participated in planning sessions, grooming sessions and retrospectives.
• Extensive onsite interaction to understand requirement analysis, formulating solutions.
• Understood the highly complex requirements for transformation of data in a format suitable for downstream platform and validated the business rules to ensure data is successfully submitted to GRRP.
• Involved in providing the estimates for the project.
• Designing and executing reusable global backend Test Scripts (SQL Scripts) to validate the data.
• Lead the team and was involved in code review, test preparation, test planning, test execution.
• Was single point of contact for the offshore testing team
• Efficiently allocating work and monitoring effectively of all the work performed by the team.
• Setting up the environment and running the Autosys jobs in testing environment.
• Preparing set of User acceptance scripts and validating data loaded to target tables.
• Participating in product demos.

Confidential

Team Lead

Environment: Toad for Oracle, HP ALM, Autosys.

Responsibilities:

• Participated in planning sessions, grooming sessions and retrospectives.
• Extensive onsite interaction to understand requirement analysis, formulating solutions.
• Involved in providing the estimates for the project.
• Designing and executing reusable global backend Test Scripts (SQL Scripts) to validate the data.
• Lead the team and was involved in code review, test preparation, test planning, test execution.
• Was single point of contact for the offshore testing team
• Efficiently allocating work and monitoring effectively of all the work performed by the team.
• Setting up the environment and running the Autosys jobs in testing environment.
• Preparing set of User acceptance scripts and validating data loaded to target tables.
• Participating in product demos.

Confidential

Team Lead

Environment: Toad for Oracle, HP ALM, Autosys and HADOOP.

Responsibilities:

• Participated in planning sessions, grooming sessions and retrospectives.
• Extensive onsite interaction to understand requirement analysis, formulating solutions.
• Understood the highly complex requirements for transformation of data in a format suitable for downstream platform and validated the business rules to ensure data is successfully submitted to GRRP.
• Involved in providing the estimates for the project.
• Designing and executing reusable global backend Test Scripts (SQL Scripts) to validate the data.
• Lead the team of 8 members and was involved in code review, test preparation, test planning, test execution.
• Was single point of contact for the offshore testing team and effectively passed on the information to the team by attending the late-night defect triage calls and other status meetings.
• As this was the first project om HADOOP for TRADS a huge number of defects - 345 defects were logged by the team as part of this project out of which 112 defects were logged by me.
• Efficiently allocating work and monitoring effectively of all the work performed by the team.
• Setting up the environment and running the Autosys jobs in testing environment.
• Preparing set of User acceptance scripts and validating data loaded to target tables.
• Participating in product demos.

Confidential

Individual Contributor

Environment: Toad for Oracle, HP ALM, Autosys and HADOOP.

Responsibilities:

• Participated in planning sessions, grooming sessions and retrospectives.
• Extensive onsite interaction to understand requirement analysis, formulating solutions.
• Understood the highly complex requirements for transformation of data in a format suitable for downstream platform and validated the business rules to ensure data is successfully submitted to AML.
• Designing and executing reusable global backend Test Scripts (SQL Scripts) to validate the data.
• Setting up the environment and running the Autosys jobs in testing environment.
• Was involved in all the stages of test window.
• Preparing set of User acceptance scripts and validating data loaded to target tables.
• Participating in product demos.

Confidential

Individual Contributor

Environment: Toad for Oracle, HP ALM, Autosys and HADOOP.

Responsibilities:

• Participated in planning sessions, grooming sessions and retrospectives.
• Extensive onsite interaction to understand requirement analysis, formulating solutions.
• Understood the highly complex requirements for transformation of data in a format suitable for downstream platform and validated the business rules to ensure data is successfully transformed.
• Designing and executing reusable global backend Test Scripts (SQL Scripts) to validate the data.
• Setting up the environment and running the Autosys jobs in testing environment.
• Was involved in all the stages of test window.
• Preparing set of User acceptance scripts and validating data loaded to target tables.
• Participating in product demos.