Summary
Overview
Work History
Education
Skills
Websites
Languages
Personal Information
Timeline
Generic

Shobha Hassan

South Elgin,USA

Summary

Dynamic ETL Test Lead with over 10 years of extensive experience in software testing and data validation. Skilled in creating complex SQL queries, managing data transformations, and ensuring data quality across various environments. Successfully led testing efforts for high-profile projects, streamlining testing processes and enhancing client satisfaction. Equipped with hands-on experience in agile methodologies and advanced testing tools such as TestRail and JIRA. Ready to leverage unique skill set to drive data integrity and quality assurance in any challenging environment.

Overview

22
22
years of professional experience

Work History

Quality Test Engineer

Oak Street Health (Now as CVS Health)
South Elgin, USA
10.2023 - Current
  • Oversaw the entire software testing life cycle, including the preparation of test scenarios, test case execution, data validation, reporting of test results, and securing necessary sign-offs from clients
  • Engineered comprehensive SQL queries to analyze logic within stored procedures, validating data transformations through Microsoft SQL Server
  • Executed Data Quality Assurance and troubleshooting processes
  • Validated data transfer between different architecture layers according to business requirements
  • Collaborated in an agile environment, managing user stories within JIRA
  • Utilized TestRail or Zephyr for project management and bug tracking effectively
  • Ensured rigorous testing standards, maintained test artifacts, and updated regression suites

Technical Test Lead (Quality Test Engineer)

Infosys Ltd
Everest Insurance, USA
04.2022 - 10.2023
  • Company Overview: Everest Insurance
  • Directed the full software testing life cycle, from crafting test scenarios to executing test cases, validating data, and reporting results while acquiring the necessary client sign-offs
  • Developed Python scripts to validate data transformations, utilizing Python/SQL in Azure Databricks, conforming to data lake standards and business requirements
  • Assessed data transfer pipelines between Azure services for integrity and accuracy
  • Coordinated with the offshore team, delegating testing responsibilities while tracking progress and communicating status updates to the product team
  • Everest Insurance

Test Analyst (Quality Test Engineer)

Infosys Ltd
Allstate Insurance, USA
02.2020 - 07.2022
  • Company Overview: Allstate Insurance
  • Managed the complete software testing life cycle, from preparing test cases to executing tests and reporting results, ensuring client sign-offs were attained
  • Allstate Insurance

QA Tester/Analyst

Travelers Insurance
MN, USA
09.2017 - 07.2019
  • Coordinated activities with the onshore test lead, generating status reports while keeping onsite teams informed of issues and overall status
  • Evaluated requirements, functional specifications, and essential documentation for testing purposes
  • Executed various testing types including Functional, White Box, Black Box, System, Integration, Regression, and User Acceptance Testing (UAT)

QA Analyst

Blue-Cube Information Technology
NY, USA
06.2011 - 06.2013
  • Company Overview: Barclays Bank
  • Participated in testing activities within an agile project environment, attending sprint planning, daily scrums, and sprint reviews
  • Assessed various documents to prepare test cases that comprehensively covered all application requirements
  • Formulated automated tests using Selenium WebDriver and TestNG to enhance testing efficiency
  • Barclays Bank

QA Tester

VCS Technologies
Bangalore, India
08.2006 - 12.2007
  • Engaged in implementing all phases of the Software Development Life Cycle (SDLC) while coordinating test environment setup
  • Conducted functional testing, handling deployment requests, and executing sanity tests alongside prioritizing QA test cases within the project plan

QA Tester

Yantri Enterprise Solutions
Bangalore, India
08.2003 - 07.2004
  • Analyzed business requirements and functional specifications, developing a detailed Test Plan, Test Scenarios, and Test Cases
  • Organized and facilitated quality assurance review meetings to ensure project alignment and quality standards

Education

Masters - Microelectronics and Control Systems Engineering

NMAM Institute of Technology
Belgaum, India
01.2011

Bachelors - Electronics and Communication Engineering

Malnad College of Engineering
Hassan, India
01-2001

Skills

  • ETL Testing
  • Big Data Testing
  • Cloud Testing
  • Manual Software Testing
  • Automated Software Testing
  • API Testing
  • Test Automation Management
  • Business Intelligence
  • SQL
  • Azure
  • Python
  • Java
  • JavaScript
  • Selenium
  • Databricks
  • Data Factory
  • Postman
  • JMeter
  • HP Quick Test Professional
  • Kafka
  • JIRA
  • TestRail
  • Zephyr
  • Analytical skills
  • Problem-solving skills
  • Communication skills
  • Collaboration skills
  • Agile team management
  • Leadership

Languages

  • English, Fluent
  • Hindi
  • Kannada

Personal Information

Title: ETL Test Lead

Timeline

Quality Test Engineer

Oak Street Health (Now as CVS Health)
10.2023 - Current

Technical Test Lead (Quality Test Engineer)

Infosys Ltd
04.2022 - 10.2023

Test Analyst (Quality Test Engineer)

Infosys Ltd
02.2020 - 07.2022

QA Tester/Analyst

Travelers Insurance
09.2017 - 07.2019

QA Analyst

Blue-Cube Information Technology
06.2011 - 06.2013

QA Tester

VCS Technologies
08.2006 - 12.2007

QA Tester

Yantri Enterprise Solutions
08.2003 - 07.2004

Masters - Microelectronics and Control Systems Engineering

NMAM Institute of Technology

Bachelors - Electronics and Communication Engineering

Malnad College of Engineering
Shobha Hassan