Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Kavandeep Chawla

Www.linkedin.com/in/kavandeepchawla

Summary

Passionate and accomplished Senior QA Engineer with a solid 9+ year background in the health and financial sectors. I excel in crafting and executing thorough test plans, utilizing both manual and automated testing methods to ensure top-notch software delivery. Well-versed in agile methodologies, I adeptly handle Agile ceremonies, client interactions, requirement analysis, and SDLC/STLC cycles. Proficient in BDD and TDD using Cucumber and Jenkins. I actively contribute to refining QA processes, boosting test coverage, and enhancing system stability. Eager to leverage my expertise in Agile/Scrum methodologies, testing, and automation to drive impactful contributions to organizational success.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Senior Quality Assurance Engineer

Veeva Systems
Canada
04.2023 - Current
  • Collaborate with cross-functional teams, including developers, product owners, and business analysts to understand requirements and provide strategic input throughout the software development lifecycle
  • Liase with scrum team to review requirements, specifications, and technical design documents offering timely and impactful feedback to enhance project outcomes
  • Proficiently organized and facilitated sprint planning, daily scrum, sprint reviews and help remove impediments
  • Collaborate with the Product Owner on product backlog refinement and to define acceptance criteria and the definition of done
  • Maintain up-to-date team dashboards and meticulously track feature progress using burndown charts within sprints
  • Organize sprint retrospective meetings to gather team's reflection on the process
  • Identify actions and next steps to improve the future sprints
  • Coordinate and execute end-to-end testing processes within Agile sprints, ensuring the delivery of high-quality features within specified timelines
  • Perform in-depth analyses of design and implementation documents to ascertain sufficient test coverage, actively participating in the development of comprehensive test plans
  • Involve in analyzing and feasibility check of a newly added functionality for automation
  • Conduct thorough root cause analyses for identified production issues, collaborating seamlessly with development teams to implement robust solutions and automate remediations
  • Develop automation scripts for end-to-end scenarios within 'in-sprint' timeframes, leveraging the Cucumber framework to achieve a 20% increase in test coverage
  • Continuously enhance automation coverage and stability, resulting in reduced testing time and improved overall efficiency
  • Investigate and address automation failures to achieve over 80% stability.

Quality Assurance Engineer

Veeva Systems
Canada
04.2020 - 03.2023
  • Develop and execute comprehensive test plans, test cases, and test scripts for functional testing, ensuring alignment with rigorous business requirements
  • Manage the entire bug life cycle, meticulously verifying, tracking, and reporting defects using Jira
  • Triage API and UI automation failures, actively investigating and updating scripts for seamless integration
  • Implement data-driven development testing approaches to create robust test data
  • Perform sanity, confirmation, and regression testing to guarantee the stability and reliability of software applications
  • Automated regression test suites, daily and weekly runs, significantly enhancing overall test coverage
  • Execute end-to-end testing of production defects and hotfixes, actively contributing to automation efforts
  • Develop scripts to create test data for both manual and automation testing
  • Contribute to knowledge sharing and onboarding processes by creating wiki pages on Confluence and developing training materials for new hires
  • Manage and maintain automated code in the central repository utilizing GitHub.

Software Quality Assurance Sr. Analyst

NTT Data
Canada
09.2018 - 03.2020
  • Cultivate effective collaboration with clients, product owners, and development teams to comprehend user stories and acceptance criteria, actively participating in sprint planning, review sessions, and scrum meetings
  • Formulate and execute comprehensive test cases, scripts, and test data for positive and negative test scenarios
  • Conduct Informatica workflows testing, ensuring the seamless execution of test cases for staging and layer tables
  • Design robust test cases for database objects (tables, views, stored procedures) testing
  • Develop and maintain automated test scripts for integration and regression testing of UI components using Selenium and Java
  • Execute Oracle SQL queries to validate UI fields, employing cross-browser testing across various platforms
  • Identify correct GUI elements with the help of Firebug Inspector and locating web elements using selenium locators to create automation scripts
  • Create custom xPath for dynamic components of UI and captured screenshots of the failed test cases
  • Perform cross-browser testing on different browsers (IE, Chrome, and Firefox)
  • Integration and regression tests were configured to run through Jenkins for web-based application testing.

Technology Analyst

Infosys Ltd.
India
11.2017 - 08.2018
  • Perform end to end testing for the ETL Load process which included testing incoming data file format, loading staging tables, business rules implementation, Data Cleansing, Load to final mart/target tables
  • Develop comprehensive test cases and test data to perform functional and regression testing
  • Perform root cause analysis and resolve production issues encountered while testing
  • Test database interactions at both the end-user and backend levels.

Senior System Engineer

Infosys Ltd.
India
09.2016 - 10.2017
  • Implement waterfall model methodologies, collaborating closely with business users to understand, design, and document functional test plans
  • Contribute to the writing, execution, documentation, and logging of ETL test specifications
  • Generate queries using Oracle SQL developer to check for consistency of the data in various staging, transformation, business, and mart layer tables
  • Develop and maintain ETL mappings in Informatica
  • Debug Informatica mappings, actively participating in performance testing and unit testing of Informatica sessions and target data
  • Coordinating with various teams like DB teams, admin teams and network teams
  • Conduct UAT sessions with business users and prepare documentation for enhancements and bug fixes.

Systems Engineer

Infosys Ltd.
India
06.2014 - 08.2016
  • Drive the creation of new reports, troubleshoot bugs during unit testing, and incorporate new features in Business Objects reports and Universe
  • Review ETL code and reports, analyzing various data issues and providing fixes using Informatica and SAP Business Objects reporting tools
  • Deliver operational and service enhancement requests for application issues
  • Work closely with Informatica PowerCenter Designer, Workflow Manager, Workflow Monitor, and Repository Manager
  • Created different Informatica mappings by using Lookup, Expression, Filter, Sequence generator, Aggregator, Router transformations to implement business logic for populating the data into the dimensions, facts, and history tables from multiple source systems
  • Develop reusable transformations, mappings, workflows using Informatica
  • Ensuring that the daily and monthly data loads are complete and reconciliation of data into different layers from source systems
  • Coordinate effectively with various business and vendor stakeholders and testing teams during server, application migration, and upgrade projects
  • Log and track incidents in ServiceNow.

Education

Bachelor of Engineering in Information Technology -

University Institute of Engineering and Technology, Panjab University
06.2014

Skills

Test Approaches: Agile/Scrum, SDLC, STLC, Waterfall

Test Management Tool: TestRail

Testing Tools: Selenium Web driver, Cucumber, Gherkin, Postman

Version Control: Git

Build and CI Tool: Maven, Jenkins

Framework: Behavior Driven Development, Page Object Model

Atlassian Tool: Jira, Confluence

Database: Oracle SQL Developer

Programming Languages: Java

Reporting Tool: Business Objects XIr4

ETL Tool: Informatica Power Center

MS office & IDE: Word, Excel, PowerPoint, Intellij

Certification

  • CSM certified, 2024
  • ISTQB Foundation Level, 2024
  • Cucumber Essential LinkedIn Training, 2021

Timeline

Senior Quality Assurance Engineer

Veeva Systems
04.2023 - Current

Quality Assurance Engineer

Veeva Systems
04.2020 - 03.2023

Software Quality Assurance Sr. Analyst

NTT Data
09.2018 - 03.2020

Technology Analyst

Infosys Ltd.
11.2017 - 08.2018

Senior System Engineer

Infosys Ltd.
09.2016 - 10.2017

Systems Engineer

Infosys Ltd.
06.2014 - 08.2016

Bachelor of Engineering in Information Technology -

University Institute of Engineering and Technology, Panjab University
Kavandeep Chawla