Summary
Overview
Work History
Education
Skills
Certification
Testing Methodologies
Tools Used
Timeline
AccountManager
VINAY KUMAR BHAGAT

VINAY KUMAR BHAGAT

ISTQB certified Test Analyst
Newtown

Summary

ISTQB Advanced Level Test Analyst with over 14 years of experience in software testing at leading multinational corporations, including IBM, Cognizant, and TCS. Expertise in ETL/DWH testing, data migration, MDM testing, functional and manual testing, EDL and Big Data testing, and BI report testing using tools such as Cognos and Power BI. Strong SQL scripting skills for data validation and functional testing, along with hands-on experience optimizing test activities through AI-powered tools like Microsoft Copilot.Proficient in SDLC/STLC, Agile testing methodologies, and defect management with JIRA and ALM, consistently delivering high-quality, reliable, and accurate testing outcomes in complex data-centric environments.

Overview

14
14
years of professional experience
7
7
Certifications

Work History

Sr. Test Analyst

Tata Consultancy Services (TCS)
09.2021 - 08.2025
  • Successfully delivered end-to-end Data Migration testing in Databricks, ensuring 100% accuracy in critical business data.
  • Optimized test case design and execution using Microsoft Copilot (AI-powered tool), reducing manual effort and improving productivity.
  • Independently managed UC Migration backend table verification, dashboard validation, and UI testing with minimal supervision.
  • Appreciated in Mid-Year Assessment meeting for independently handling complex sustainment project testing.
  • Cleared ISTQB Advanced Level Test Analyst Certification (2024), enhancing testing expertise.

ETL/MDM Test Analyst

Cognizant Technology Solutions (CTS)
03.2016 - 09.2021
  • Delivered ETL testing for Insurance client (Manulife), ensuring data consistency across multiple downstream systems.
  • Performed MDM testing for Retail clients (Sodexo, PetSmart), improving data quality and reporting accuracy.
  • Actively contributed to Agile ceremonies (Scrum, Sprint Planning, Defect Triage) ensuring smooth QA delivery.
  • Recognized for strong SQL scripting skills, accelerating defect identification and resolution.

Test Specialist

IBM India Pvt Ltd
06.2011 - 03.2016
  • Built strong foundation in software testing lifecycle (STLC) and defect management, starting as a fresher.
  • Successfully executed manual, functional, and ETL/DWH testing, ensuring adherence to client quality standards.
  • Appreciated for quick learning and adaptability, contributing effectively across multiple client projects.
  • Gained exposure to enterprise-level IT work culture, setting the base for long-term QA career growth.

Education

MCA - Computer Science

BIT Mesra
Ranchi
01.2011

B.Sc. - Math’s

IGNOU Study Center – Vanijya Mahavidyalay
Patna
01.2007

Skills

ETL / DWH Testing

undefined

Certification

ISTQB advance level test analyst certification.

Testing Methodologies

  • Expertise in reviewing requirement
  • Experienced in Agile process (Scrum)
  • Functional and design specifications, developing Test strategies, Test plans, Test cases & Processes
  • Functional Requirements Scripting & Documentation
  • Involved in Functional, Integration, System, Regression & Negative Testing
  • UI & Compatibility Testing
  • Unix command-based Software Testing
  • Experience with SQL Query
  • Experienced in Quality Assurance Process

Tools Used

  • Data Warehouse & ETL Tools: Informatica Cloud services(ICS), IBM DataStage , Informatica PowerCenter, SQL Warehousing Tool (SQW)
  • Data Modeling Tool : IBM InfoSphere Data Architect(IDA)
  • Defect Tracking/ Bug Reporting: Rally,Jira, Test Director/ Quality Center, Rational Clear Quest
  • Configuration Management Tool: Star Team, PRISM (in AT&T )
  • Databases: Databricks, SQL server , Oracle 11g/10g/ 9i , MySQL , IBM DB2
  • Web services: SOAPUI
  • Other Tools: WinSCP, Putty , Citrix , VPN
  • Software Packages: MS-Office, Microsoft Word, Excel and Power Point
  • Automation: Postman(REST API),Selenium(conceptual Understanding)
  • Package/Scheduling Tool: Batchman, Autosys

Timeline

Sr. Test Analyst

Tata Consultancy Services (TCS)
09.2021 - 08.2025

ETL/MDM Test Analyst

Cognizant Technology Solutions (CTS)
03.2016 - 09.2021

Test Specialist

IBM India Pvt Ltd
06.2011 - 03.2016

MCA - Computer Science

BIT Mesra

B.Sc. - Math’s

IGNOU Study Center – Vanijya Mahavidyalay
VINAY KUMAR BHAGATISTQB certified Test Analyst