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
Ranchi01.2011
B.Sc. - Math’s
IGNOU Study Center – Vanijya Mahavidyalay
Patna01.2007
Skills
ETL / DWH Testing
undefinedCertification
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
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Amol PhansekarAmol Phansekar
Business Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTDBusiness Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTD
Viraj Swaroop SrivastavaViraj Swaroop Srivastava
Group Head at Tata Consultancy Services (TCS)Group Head at Tata Consultancy Services (TCS)
Gulshan SinghGulshan Singh
System Engineer at Tata Consultancy Services (TCS)System Engineer at Tata Consultancy Services (TCS)
Ina AsllaniIna Asllani
Staff Pharmacist at CVS PharmacyStaff Pharmacist at CVS Pharmacy