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, India01.2011
Bachelors - Electronics and Communication Engineering
Malnad College of Engineering
Hassan, India01-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