Summary
Overview
Work History
Education
Skills
Personal Information
Data WareHouse Project
Projects
Certification
Timeline
Hi, I’m

ADARSH YADAV

Gurgram

Summary

To acquire a position with a progressive web development or software development company with a strong focus on creativity and problem solving. To find position that is challenging, rewarding and provides an opportunity to expand my knowledge and abilities in creating client centric solutions.

Overview

5
years of professional experience
1
Certification

Work History

EY
Gurugram Sector-44

Software Test Engineer
05.2024 - Current

Job overview

  • Performed data validation using SQL queries to ensure data accuracy and consistency across various systems.
  • Utilized SQL to perform data validation and ensure accuracy and consistency of migrated data.
  • Identified, logged, and tracked defects using Azure DevOps (ADO), and worked closely with the development team to ensure timely resolution.
  • Developed and deployed ETL processes to extract data from multiple sources into a single Data Warehouse.
  • Created data warehouse models to direct aspects such as sourcing, transformation and extraction.

HCLTech
Bangalore

Software Test Engineer
08.2019 - 04.2024

Job overview

  • Reviewed and comprehend business requirements and functional specifications
  • Creating detailed, comprehensive and well-structured test plans and test cases
  • Executing test cases and test scripts
  • Performing functional testing (regression, integration, and system testing)
  • Reporting any bugs that are found using Jira
  • Retesting bugs to ensure they have been fixed
  • Creating new test cases for new features that have been added to the software
  • Execute automated and manual tests to verify the functionality of new or modified software applications
  • Participating in sprint planning and stand-up meetings
  • Experience in writing SQL queries for backend testing and validating the results with expected output
  • Working closely with developers and other stakeholders to ensure that test automation plans are executed effectively and efficiently
  • Ensuring quality throughout the Software Development Life Cycle.

Education

Techno India Salt Lake

Bachelor of Technology
06.2019

BSEB

Senior Secondary Schools
05.2015

Skills

  • Programming
  • Core Java
  • SQL
  • Automation Testing
  • Manual Testing
  • SDLC
  • STLC
  • JIRA
  • AGILE
  • Functional Testing
  • Selenium Webdriver
  • TestNG
  • Xpath
  • Maven
  • Cucumber Tool
  • BDD
  • API Testing(POSTMAN)
  • Domain (HealthCare & Insurance)
  • Rest Assured
  • API Automation
  • Rest API
  • User Acceptance Testing
  • Regression Testing
  • Test Planning

Personal Information

Title: Software Test Engineer

Data WareHouse Project

  • As a Manual Test Engineer working on data warehouse projects, I am responsible for ensuring the quality and accuracy of data throughout the ETL (Extract, Transform, Load) processes.
  • My role involves developing and executing detailed test plans and test cases to validate data integrity, accuracy, and consistency across various systems. I collaborate closely with business analysts, developers, and stakeholders to understand requirements and translate them into effective testing strategies.
  • Utilizing my strong SQL skills, I perform data validation and profiling to identify and resolve data discrepancies, ensuring compliance with business requirements and industry standards. Through diligent defect tracking and resolution, I contribute to the successful deployment and maintenance of high-quality data warehouse solutions.

Projects

HealthCare- Claim-Insurance, 03/2021, Present, Bangalore, Ucare, I am working as SDET. Selenium Automation Engineer. My Current project is Healthcare based, it's basically healthcare insurance application. which is SAAS Product(Software as a service). where we have four major module: 1.Provider( supplier i.e hospital, practitioner, dental).2. Payers(Health Insurance company who provide health insurance plans).3.Employers (who purchase health insurance plans and share among their employees).4. Member /patient (who enroll for health insurance)., Requirement gathering & analysis. Preparing a test data to test the claim process. Testing the claim and adjudication process with complex scenarios. Verifying the claims with EDI form and paper form. Tested the claims for all types of claims I.e Institutional, Professional and dental. Tested the EDI claim form with all 3 types of claims types. Testing the claims with both positive and negative scenarios. Good Knowledge of AGILE development methodology. Worked on Bug Reporting Tools (JIRA). Healthcare Mobile & Web Application: OnlifeHealth, 08/2019, 02/2021, Bangalore, Onlife Health, Selenium Automation Engineer. Onlife Health offers its users a variety of services pertaining to wellness initiatives. Users are able to complete a health assessment, set personal goals, & monitor their progress towards improving their health all inside the Onlife online application & the Always-Onmobile app., Requirement gathering & analysis. Functional testing, integration & regression testing, complete bug lifecycle using JIRA tool. Actively involved in preparing, documenting & executing the test cases. To ensure that all testable aspects of new features and functionality are thoroughly covered by test plans and test cases. Bug allocation, tracking, revisiting & verifying the bugs. Identifying areas of improvement in the testing process.

Certification

  • Earned 5 stars badge in SQL on HackerRank!

Timeline

Software Test Engineer

EY
05.2024 - Current

Software Test Engineer

HCLTech
08.2019 - 04.2024

Techno India Salt Lake

Bachelor of Technology

BSEB

Senior Secondary Schools
ADARSH YADAV