Ankush Pathak

• H1B US VISA Holder which is Valid till Sept 2026. Authorized to work for any US employer.

• 9 Years of professional experience in Data Warehousing with progressive experience in ETL Testing and DevOps in Client/Server environments along with Good knowledge in Telecom domain and Banking Domain.

• Having more than 3 years of Onsite experience with one of the Telecom giant of Saudi Arabia (STC). Good knowledge of Data warehousing, ETL. Involved in creating test design, executing test cases and defect logging. Involved in ETL testing by writing and executing SQL queries to validate that the data is being populated as per the business requirement. Analyzing the root cause of the failed Test Case. Defect logging and bring them to closure when it meets business requirements.
• Currently Working on a Complex Project which involves generating Events on a Daily Basis and sharing it with the Bureaus to identify various activities of all the Loan Accounts which includes Home Loans, Personal Loans, Over Drafts, Credit Cards etc.

• Having experience in DevOps to manage continuous Integration using Jenkins. Involved in implementing continuous deployment on Docker containers. Involved in implementing CI/CD on Google Cloud services.
• Good communication skills, interpersonal skills, self-motivated and quick learner. Team player and capable of working independently.

Worked on tools like Ab Initio GDE, Ab Initio Express>It, Ab Initio Query>It, UNIX Box, GitHub, Teradata, JIRA, SVN, Hive, HP ALM-QC,Jenkins, GCP,AWS.

• Sept 2015- Oct 2021 : EDW Dev and Testing STC Riyadh (Cognizant)
• Responsibilities:

Prioritizing the release activities by focusing on business requirements.
Providing Test Estimates for the project to Clients and communicating feasibility/risks, recommend mitigation.
Following up with the Design, Dev team on the requirement, defects and
Clarifications
Designing the test scenarios.
Developing test scripts for the Test Scenarios.
Conducting peer review of test scripts.
Review the defects raised, prioritize and coordinate with development for defect closure.
Testing of stored procedures on daily, weekly and monthly.

• Project Activities:

Testing of various CRs from the client includes mapping and data validation.
Implemented the execution of continuous integration through Jenkins where Multiple jobs runs as the scheduled time with defined dependencies.
Implemented Continuous Deployment using Docker on multiple containers.
Single handedly tested one of the internal project, BSST from start to end without any failures in production.
Script validation for various Teradata utilities like BTEQ, MLOAD, and FEXP.
Analyzing and testing Abinitio Mappings with OLTP source data, staging and target data.
Formulate methods to perform Positive and Negative testing against requirements.
Maintaining QC work including test case creation, execution and Defect logging.
Tested the BAU CRs which includes writing the Source queries in order to do the data validation in one go.
Tested Hotfixes for many CRs which includes the testing of patch applied in that particular Hotfixes.

• Nov 2021- Till Date : CRDH Testing at ANZ Australia (Incandescent Technologies Pvt Ltd)

• Responsibilities:

Understanding the requirement of each and every release.

Watching the Current Implementation and reviewing the rejected Events.

Preparing Release Test Plan and Phase Test Summary Report for every Release along with Traceability Matrix.

Managing the Test Team with work Assignments, Daily Updates, Blockers, Automation Scope, Technical Support, Trainings, Knowledge Transitions etc.

Collecting current stats and Preparing the Test Scenarios, Test Cases and Test Results.

Involved in System Testing, System Integration Testing, Functional Testing, Regression Testing , UAT Testing.

Preparing Complex SQL Queries and Abinitio Graphs to Validate the data.

Defect Tracking and Performing full Defect Life Cycle from JIRA Board.