Summary
Overview
Work History
Education
Skills
Publications Presentations Affiliations
Certification
Automations Developed
Skills Summary
Languages
Timeline
Generic
KEERTHANA VENUGOPAL

KEERTHANA VENUGOPAL

CHOTTANIKKARA

Summary

Over 10.7 years of IT experience, including 10 years as an ETL Test Engineer focused on Data Warehousing and ETL Testing. Expertise in Microsoft Azure, Databricks and SQL Server, complemented by skills in .NET, MongoDB Compass, and Power Automate. Proven track record of delivering projects on time, recognized for strong analytical and problem-solving abilities. Holds certifications in INS-STAR1, INS-STAR2, and DP-900 Microsoft Azure Data Fundamentals.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Senior Associate | Senior Test Lead

EY Global Delivery Services
01.2025 - Current

NEXUS FOR HEALTH

  • Created comprehensive test cases for functional and non-functional requirements.
  • Collaborated with business users to align project outcomes with expectations.
  • Documented and triaged software defects, working closely with developers for prompt resolutions.
  • Monitored bug resolutions to enhance software performance.
  • Coordinated with development teams to resolve technical issues in ETL processes.
  • Reviewed team test reports to ensure adherence to organizational quality standards.
  • Facilitated timely tests and product releases in collaboration with off-site teams.

Senior Associate | Senior Test Lead

EY Global Delivery Services
01.2021 - 12.2024

FONTERRA

  • Conducted requirement analysis and gathered specifications for effective project planning.
  • Developed test cases aligned with each functional requirement to ensure comprehensive coverage.
  • Created SQL queries to validate data transitions from Standard Layer to Serving Layer.
  • Validated data flow across layers in Azure Data Bricks, ensuring integrity from Source to Standard.
  • Prepared detailed test plans and estimated efforts based on gathered requirements.
  • Logged test cases, statuses, and defects in Azure DevOps for efficient tracking.
  • Detected bugs and performed re-validation to uphold quality assurance standards.

ETL – QA TEST ANALYST

Cognizant Technology Solutions|
06.2020 - 01.2021

UNUM

  • Conducted requirement analysis and gathered specifications for testing processes.
  • Developed test plans and estimated effort based on defined requirements.
  • Created comprehensive test cases for each functional requirement.
  • Executed complex SQL queries in SQL Server to validate back-end data against requirements.
  • Performed bug detection and re-validated identified issues for accuracy.
  • Logged test cases, statuses, and defects in Azure DevOps for effective tracking.
  • Scripted in KSQL (Kafka) to streamline data validation tasks.
  • Compared data values between SQL Server and MongoDB to ensure consistency.

ETL – QA TEST ANALYST

Cognizant Technology Solutions
09.2014 - 05.2020

TRAVELERS

  • Conducted requirement analysis and gathered specifications for project initiatives.
  • Prepared comprehensive test plans and estimated efforts based on requirements.
  • Developed test cases and test sets for each functional requirement.
  • Crafted complex SQL queries in SQL Server to validate back-end data against requirement documents.
  • Validated and tested various dashboards and reports for accuracy and performance.
  • Identified bugs and performed re-validation to ensure quality standards.
  • Logged test cases, statuses, and defects in QC HP ALM for tracking purposes.
  • Upgraded SQL Server from 2012 to 2016, including enhancements to approximately 65 SSIS packages.

Education

M tech - Software Development and Management

VIT University
Vellore
01.2018

B Tech - Computer Science and Engineering

Adi Sankara Institute of Engineering and Technology
Kalady
01.2014

12th Standard - CBSE Board

Mahatma Gandhi Public School
Ambadimala, Ernakulam
01.2010

10th Standard - CBSE Board

Mahatma Gandhi Public School
Ambadimala, Ernakulam
01.2008

Skills

  • SQL Server and Oracle DB
  • Teradata
  • C, C, and C#
  • Dot Net and Microsoft Visual Studio
  • HP ALM and Advanced Query Tool
  • Ultra Edit
  • Python and MongoDB
  • KSQL
  • Microsoft Azure and Azure DevOps
  • Data Bricks

Publications Presentations Affiliations

  • Won the 'Everyday Champion' award in the Travelers account from the client during 2016
  • Won the 'Exceptional Performer' award from the client for the Fonterra account during 2023
  • A permanent member coordinating several cultural events
  • Involved in extracurricular activities during school and college days, and a regular prize winner
  • Editor of 'Quintessence,' the college magazine during my B Tech academics
  • Hosted several quiz competitions throughout college and corporate life

Certification

  • STAR1 and STAR2 External Certifications of Insurance Domain
  • Dp-900 Microsoft Azure Data Fundamentals External Certification

Automations Developed

  • Text Locus, A Text File Delimiter Tool developed in Dot Net for delimiting Mainframe source files.
  • Test Case generator, An Excel Based Tool for generating Test Cases automatically.

Skills Summary

SQL Server, Oracle DB, Teradata, C, C++, C#, Dot Net – Microsoft Visual Studio 2010, HP ALM, Advanced Query Tool, Ultra Edit, Python (Basics), MongoDB, KSQL (Kafka), Microsoft Azure, Azure DevOps

Languages

Malayalam
First Language
English
Proficient (C2)
C2
Hindi
Upper Intermediate (B2)
B2
Tamil
Intermediate (B1)
B1

Timeline

Senior Associate | Senior Test Lead

EY Global Delivery Services
01.2025 - Current

Senior Associate | Senior Test Lead

EY Global Delivery Services
01.2021 - 12.2024

ETL – QA TEST ANALYST

Cognizant Technology Solutions|
06.2020 - 01.2021

ETL – QA TEST ANALYST

Cognizant Technology Solutions
09.2014 - 05.2020

M tech - Software Development and Management

VIT University

B Tech - Computer Science and Engineering

Adi Sankara Institute of Engineering and Technology

12th Standard - CBSE Board

Mahatma Gandhi Public School

10th Standard - CBSE Board

Mahatma Gandhi Public School
KEERTHANA VENUGOPAL