Quality Assurance Test Engineer

Shobha Hassan

South Elgin, IL ***** 847-***-**** *************.******@*****.***

linkedin.com/in/shobha-hassan-0aa29581

QUALITY TEST ENGINEER

Collaborative, analytical, and results-driven Quality Assurance Engineer with 10 experience in IT, specializing in ETL and big data testing. Expertise in validating complex ETL solutions, data warehouse testing, and cloud testing. Adept at collaborating with cross-functional teams in Agile environments to ensure high-quality software deliverables. Skilled problem solver who strategically drives swift corrective actions, achieves significant cost savings, and ensures fault-free audits. Brings a hands-on approach to QA lifecycle management, functional testing, and the establishment of impactful automation frameworks, while navigating project-based complexities. Expertise in recommending impactful automation test strategies, a pivotal factor in optimizing testing efficiency across diverse projects. TECHNICAL SKILLS

Databases: MicrosoftSQL Server, MS-Access

Automation Packages: Abinitio, Azure Databricks, Azure Data Factory, Selenium Webdriver, Cucumber, QuerySurge – ETL Test Tool, Postman, JMeter, TestNG, HP Quick Test Professional 9.2, Kafka Programming Languages: Python, PySpark, Java, Java script, C, C++, Visual Basics Operating Systems: Windows XP/Vista/7, Linux/Unix

Cloud Platforms: ADLS, AWS, GCP

Test Management Tools: Jira, Azure ADO, Test Rail, Zephyr, qTest, Version one, MS-Office, MS Visual Studio, HP Quality Center 9.1

Business Intelligence Tools: Microsoft Excel, Power Query, Tableau, Power BI CORE COMPETENCIES

ETL Testing/ Big Data Testing/ Cloud Testing Manual Software/ System Testing Automated Software Testing API Testing

Test Automation Management Business Intelligence & SQL Reports Agile/Scrum/Waterfall Methodologies

Behavior Driven Development Continuous Integration/Continuous Testing Risk Assessment & Management

User Training & Support Configuration & Troubleshooting Complex Mathematics & Problem Solving Communication Agile & Cross-Functional Team Environments Offshore Team Leadership Coordinating Testing Efforts

PROFESSIONAL EXPERIENCE

OAK STREET HEALTH (CVS HEALTH)

October 2023 – Present

Data - Quality Engineer

The project was mainly based on Ingest, process and load Payer, Membership, Medical Claims, Pharmacy Claims and CMS, STARS files through Raw, Stage and Fact data layers. Files were ingested through Python Jobs and data was processed in Stored Procedures. STARS Incoming file processed to create quality metrics. Views were built on the Fact tables, which would be accessed for Compliance and Reporting.

• Oversaw the complete Software testing life cycle starting from preparing test scenarios, test cases, execution and data validations, test result reporting, and obtaining required sign-off from the client.

• Created exhaustive SQL queries by understanding logics in stored procedure and validating the data transformation, using Microsoft SQL server.

• Oversaw data quality assurance and troubleshooting.

• Validated data transfer between different layers of architecture and as per business requirements.

• Gained experience working in agile environment and managing user stories in JIRA.

• Acquired hands-on experience in using TestRail or Zephyr, a Test Management tool used for project management and bug tracking.

• Ensured quality thorough testing, maintaining test artifacts and updating Regression suits.

• Executed end-to-end application testing, including data validation testing, integration testing, user interface testing, regression testing, sanity testing as per the project needs.

• Effectively communicated and managed expectations to team members and stakeholders in a timely fashion.

INFOSYS LTD

February 2020 – October 2023

Technical Test Lead

Client: Everest Insurance, NJ, April 2022 – October 2023 The project was mainly based on:

• Designed and implemented data processing and storage solutions for cloud system, using Microsoft Azure services such as Azure data lake storage, Azure SQL database.

• Developed and maintained data pipelines, using Azure data factory and Azure Databricks.

• Performed data modeling and schema design for data storage and retrieval.

• Optimized data processing and storage for performance and cost efficiency.

• Oversaw the complete Software testing life cycle, starting from preparing test scenarios, Test cases, execution and data validations, test result reporting and obtaining required sign-off from the client.

• Created python scripts and validated the data transformation using python scripts/SQL in Azure data bricks from source to target (Azure Synapse), as per data lake standards and business requirements.

• Assisted with data quality assurance and troubleshooting.

• Validated data transfer pipelines between Azure services.

• Worked in agile environment and managed user stories in JIRA.

• Gained hands-on experience in using a qTest, a Test Management tool used for project management and bug tracking.

• Coordinated with Offshore team and assigned testing responsibilities and followed up for the test completion and reporting the status to product team.

• Environment: Azure Data Lake, Azure data Factory, Azure dataBricks, Azure Synapse, Microsoft SQL server, JIRA, qTest, Python.

Test Test Lead

Client: Allstate Insurance, IL, February 2020 – July 2022 This was a ETL architecture solutioning project mainly focused on Ab–Initio based ETL/Data Warehousing Testing and providing data strategy and solutioning leveraging latest technology.

• Oversaw the complete software testing life cycle starting from preparing test cases and execution to test result reporting and obtaining required sign-off from the client.

• Managed E2E ETL process from source to Metrics Coordinating Regression testing at the end of each sprint the impact of existing functionality impacts.

• Worked in agile environment and created user stories in JIRA or Version One.

• Prepared SQL scripts for assessments and data profiling.

• Gained experience in event-based testing using Kafka and Lenses. Coordinated with the Offshore team and assigned testing responsibilities and followed up until test completion and reporting the status to Project Manager.

• Updated the weekly reports.

TRAVELERS INSURANCE, MN

QA Tester/Analyst, September 2017 – July 2019

This was a reengineering project where Auto Insurance Endorsements and Renewals were implemented as a Web Application. Testing of this project involved comparing premiums, policy documentation and state/federal specific insurance regulations between old and new systems.

• Coordinated with onshore test lead, creating status reports and keeping onsite updated with all issues and status.

• Analyzed requirements, functional specification, and the required documents for testing.

• Performed Functional, White Box, Black Box, System, Integration, Regression, User Acceptance Testing (UAT).

• Conducted elaborate manual testing on test cases and provided feedback to the development team.

• Used HP Quality Center and JIRA for requirements management, planning, scheduling, running tests, defect tracking, and managing the defects.

• Collaborated with Business System Analysts and internal stakeholders to create test scenarios.

• Generated daily status reports, weekly reports, defect reports and testing summary Reports.

• Performed Regression Testing at various phases of development life cycle for impacted existing functionality.

• Environment: Quality Center (QC), Windows NT, SQL, MS Access, SQL Server, Selenium, Eclipse, JIRA, Jenkins, TestNG, Junit, Agile (SCRUM).

BLUE-CUBE INFORMATION TECHNOLOGY

June 2011 – June 2013

QA Analyst; Client: Barclays Bank, NY

The purpose of this project was to automatically approve invoices with zero balances. Once these invoices had been automatically approved, they should follow the mailing instructions within Master File,

“Billing Method”. An automatic e-mail should also be generated to the appropriate Relationship Manager informing them that their client Zero Invoice had been approved. Previously, most invoices were zero but an Administrator still needed to approve all invoices within the Billing System.

• Participated in testing activities in an agile project setup – Attended Sprint Planning, Daily Scrum Meetings and Sprint Reviews.

• Analyzed various documents and prepared test cases covering all requirements of the application

• Manually checked the important features of the application before going for automation testing.

• Assisted in analyzing and feasibility check of a newly added functionality for automation.

• Developed automated tests using Selenium WebDriver and TestNG.

• Updated test suite for some Web service operations in the SOAP UI test tool.

• Reported and tracked testing progress in the bug tracking system Test Director.

• Interacted with developers to report software bugs and re-tested the fixed issues.

• Troubleshooted new releases and production issues.

• Environment: Selenium WebDriver, QC, SQL Server, Windows NT, QTP, Regression Testing, Jira, MS Office.

ADDITIONAL RELEVANT EXPERIENCE

VCS TECHNOLOGIES, Bangalore, QA Tester; Project: Manpower Management System YANTRI ENTERPRISE SOLUTIONS, Bangalore, QA Tester; Project: Pfizer Consumer Healthcare ISRO MASTER CONTROL FACILITY, Hassan, India, Intern ST. JOSEPH ENGINEERING COLLEGE, Karnataka, India, Lecturer APTECH COMPUTER, Hassan, India, teaching Faculty in Java/C/C++/VB/MS Office/Windows EDUCATION

Master’s degree in Microelectronics and Control Systems Engineering NMAM INSTITUTE OF TECHNOLOGY, India

Bachelor’s degree in Electronics and Communication Engineering MALNAD College of Engineering

Contact this candidate