Qa Tester Test Automation
Resume:
Haider Ali
SUMMARY:
Detail-oriented and results-driven ETL / Database QA Tester with 10+ years of experience in data validation, ETL pipeline testing, and SQL-based QA analysis. Proven ability to ensure data integrity across multiple data sources and warehouse environments. Adept in developing complex SQL queries, validating transformation logic, and collaborating with cross-functional teams to ensure data accuracy, performance, and compliance.
Have extensive understanding and experience of Software Development Life Cycle (SDLC), Agile and RUP, Technical writing and Documentation.
Ability to work with Business Analysts, Developers and other Team Members in complex testing projects and in the overall enhancement of software product quality.
Experience in UAT Testing, Functional Testing, Regression Testing, System Testing, Backend Testing, Integration Testing, UX/UI Testing, and End to End Testing.
Experience with HPALM, JIRA, QC, or another similar system (TFS, MTS, VersionOne).
Has strong working experience with ServiceNow Tools, and for Logging/tracking defects in Azure DevOps.
Has Strong experience on Selenium WebDriver, JUnit and TestNG, with java and Python.
Have working experience with Automation team using Java, Selenium WebDriver, Maven/Gradle, TestNG, and WebDriver Manager.
Have experience with test automation frameworks (e.g., Selenium, Playwright, Cypress, Appium, Karate, JUnit, TestNG).
Experience for defining and developing test automation for the Fleet management application leveraging BDD and TDD with BDD methodology and Gherkin Language.
Have working knowledge of AWS, specifically API Gateway, Lambda, CloudWatch, SNS.
Have experience working with Institutional Financial Products, including exposure to Collateralized Loan Obligations (CLOs).
Experience with strong background in API Manual testing and Web Apps.
Hands on experience using Java & REST Assured automation framework for API.
Have extensive experience implementing automated testing frameworks for Restful APIs in AWS environment.
Have working experience for Microsoft Azure, Microsoft Visual Studio, Azure Devops, MTM and TestRail.
Experience in writing and executing Performance and load testing uses JMeter, and NeoLoad.
Has strong working experience using Zephyr for test case management and reporting on testing status in JIRA.
Develop and manage CI/CD pipelines for automated deployment and testing of data solutions.
Utilized .NET Core is crucial for writing integration tests that validate various components of the application interaction.
Have experience for design, develop, test, and support ETL solutions using Informatica and SSIS.
Experience in complex MY_SQL queries for verifying the ETL Mapping rules, and Experience with Apache Spark
Strong experience in SQL preparation in SQL Server/Oracle (Benthic).
Experience with SOAP UI, Load UI/Load Testing Skills, SQL Server, LADAP and Microsoft SQL Reporting Services .
Have Experience working with SQL and RDBMSs, such as Oracle, PostgreSQL, SQLite - Some scripting experience
Experience in Claims processing and must be familiar with claims processing in healthcare industry.
Has working experience to create/build EDI test files like 837 and abled to validated the related data (Claims data) in the Core system post processing.
Healthcare Domain knowledge.
Has working experience to create/build EDI test files like 837 and abled to validated the related data (Claims data) in the Core system post processing.
Have strong experience in EDI standards, protocols, and transaction sets and test automation frameworks for EDI testing.
TECHNICAL EXPERTISE:
Operating System : Windows XP/ Windows and Unix
Testing Tool : HP Quick Test Professional (QTP)/ Unified Functional Testing (UFT), HP ALM / HP Quality Center (QC), JIRA, VersionOne, Bugzilla, IBM Clear Quest,
Databases : SQL Server 2008/2012, Oracle 10g/11g, Access, SQL plus, SQL/PL Developer
Language : Visual Basic, VB Script, Java, Java Script, SQL/PL, C++, Python.
Networking : HTML, XML, HTTP, FTP, TCP/IP
Application Server : IIS
EDUCATION:
Masters in Physics
BSc in Physics
Status: US Citizen
References: Available upon request
PROFESSIONAL EXPERIENCE:
Wells Fargo, Summit, NJ
October 2022 -Mar 2025
QA Automation Engineer
Responsibilities:
Lead and worked with QA teams to create, maintain, and improve automated test suites for Web applications.
Worked with developers to ensure that all features and bug fixes come with automated test coverage.
Designed and developed Test Scenario/Test Cases/Test steps for various Business Services/methods covering both positive and negative testing requirements.
Mapped system requirements with Test cases, ensured traceability of Test Cases back to the Business Requirements using JIRA.
Worked with Automation team using Java, Selenium WebDriver, Gradle, TestNG, and WebDriver Manager.
Developed automated Test Scripts in Selenium WebDriver using Java for Functional and Regression Testing.
Supported QA efforts for financial platforms that managed structured credit products.
Involved validating complex data flows, portfolio performance metrics, and compliance rules specific to CLO structures.
Perform background in API Manual testing and Web Apps and perform using Java & REST Assured automation framework for API.
Worked for API testing using SOAPUI, Postman, or other web service call/API test utility.
Worked for API Consumption with APIs to develop one's own software applications and products.
Performed and worked using Microsoft Visual Studio, Azure Devops, and MTM.
Maintained automated test frameworks for integration testing across various systems.
Implemented automation scripts using tools like Selenium, JUnit, TestNG, or similar frameworks for efficient testing.
Implemented and maintained test automation scripts to validate integration points between different services, APIs, and databases in a .NET Core environment.
Have skilled with CI/CD automation (GitHub Actions, Azure DevOps, or similar).
Performed Manual Testing of Web-based and Client-server enterprise applications and used JIRA for test management.
Analysed logs and debug .NET Core applications to identify performance issues or integration flaws.
Performed with DevOps team and Scrum team to provide direction on CI/CD setup.
Developed Test scripts to implement Test Driven and Behaviour Driven Developments using Cucumber.
Involved in Data Centric Testing for verifying the accuracy and integrity of data across an entire system.
ThriveDX(Formerly HackerU), Washington, DC
October 2021 to 2022 October
Database Tester
Responsibilities:
Led data testing for enterprise-level ETL pipelines using Informatica and SQL Server Integration Services (SSIS).
Validated source-to-target mappings (STTM) for financial and healthcare data systems.
Created complex SQL queries to verify data accuracy, completeness, and business rule transformations.
Performed data reconciliation between legacy systems and target data warehouse.
Logged and tracked defects using JIRA, and collaborated with developers for issue resolution.
Generated test plans, test cases, and test summary reports for every release cycle.
Developed and executed test scenarios for testing of back-end operations (APIs, Deployment, Scaling, etc.)
Performed and Worked of AWS, specifically API Gateway, Lambda, CloudWatch for creating a complete serverless architecture for event-driven applications.
Work with QA teams to create, maintain, and improve automated test suites for applications
Worked with developers to ensure that all features and bug fixes come with automated test coverage.
Delivered quality process training to technical staff and acts as an internal quality consultant to advise or influence business or technical partners.
Assist software development and support teams in software product deployments. Includes deployment/build verification, and identification, analysis and troubleshooting of issues.
Developed automated Test Scripts in Selenium WebDriver using Java and python for Functional and Regression Testing.
Performed and developed test automation scripts in Visual Studio with Java script using Selenium WebDriver.
Mapped system requirements with Test cases, ensured traceability of Test Cases back to the Business Requirements using JIRA.
Performed Manual Testing of Web-based and Client-server enterprise applications and used JIRA for test management.
Created test condition, test scenario sheet, test data/result sheet based on the User stories in excel sheet and then uploaded in Jira.
USPS Solutions Center, Wilkes Barre, PA
December 2019 to SEP 2021
ETL Tester
Responsibilities:
Led data testing for enterprise-level ETL pipelines using Informatica and SQL Server Integration Services (SSIS).
Validated source-to-target mappings (STTM) for financial and healthcare data systems.
Created complex SQL queries to verify data accuracy, completeness, and business rule transformations.
Performed data reconciliation between legacy systems and target data warehouse.
Performed Manual Testing of Web-based and Client-server enterprise applications and used HP ALM for test management.
Designed, developed, test, and support ETL solutions using Informatica
Created automation scripts in Eclipse, Selenium WebDriver, running them as TestNG.
Performed with DevOps team and Scrum team to provide direction on CI/CD setup.
Worked with the DevOps team to integrate CI/CD practices into the initial framework build out.
Developed Test scripts to implement Test Driven and Behaviour Driven Developments using Cucumber.
Involved with backend testing/Database Testing (Complex SQL Queries) on Oracle Benthic.
Involved with backend testing of the MYSQL database and verified if the data displaying is correct.
Experience in Database testing, writing SQL queries and DWH.
Performed design test cases, design ETL mapping scenarios, create SQL scripts, and define transformational rules in Informatica.
Developed ETL queries/Stored procedures to validated the ETL transformation logic implementation.
Supported QA team with validation procedures/queries to execute the ETL scenarios.
Conducted integration testing to ensure data quality checks and business validation rules ware being applied successfully during ETL process.
Unisys Corporation,
Blue Bell, PA
ETL/Database Tester December 2017 to June 2019
Responsibilities:
Analysis requirements and Design and development of Test Plans, Test Cases on the basis of business, functional requirements.
Understand functional and technical aspects of the system and convert the requirements into test scenarios.
Developed functional testing of various Financial Systems end to end in the wealth management and financial services.
Develop comprehensive test plans, test cases, and test scripts for EDI transactions such as X12, EDIFACT, IDoc, etc.
Supported QA efforts for financial platforms that managed structured credit products.
Coordinated with business analysts, developers, and stakeholders to understand EDI requirements.
Troubleshoot and resolve EDI-related issues, including data errors and communication failures.
Worked for Payment Processing for Financial Institutions, specifically for debit cards, loans and/or credit card systems (new accounts, plastics, letters, notifications, preferences, parameter controls, payments, sales, account updates, memos, rewards.
Drafted and executed enabler features tied to BDD(Gherkin) framework implementation.
Worked with Performance Testing, ETL Testing, and Manual testing processes and practices.
Performed design test cases, design ETL mapping scenarios, create SQL scripts, and define transformational rules in Informatica.
For Organizing and monitoring defect management process using Jira.
Performed web Service Testing and API Testing based on requirements.
Involved for setting up Web Services project using WSDL in SOUPUI and provide setup help to other team members.
Performed and working with ready API (SOAPUI Pro) automation tool with JSON.
Wrote SQL queries to retrieve data from databases after data migration.
Performed Database Testing with SQL Server and writing MYSQL queries directly to the database as well as using ODBC.
Well Care,
Tampa, FL July 2016 – December 2017
EDI Tester/ Database Tester
Responsibilities:
Involved in the Analyzing system Requirement Specification and system Design document.
Understand functional and technical aspects of the system and convert the requirements into test scenarios.
Maintained requirements and created Traceability between requirements and test cases.
Involved in Agile meeting, Storyboarding, daily stand-up meeting and worked as a part of an
agile team.
Design and Developed the Test cases and Execute Test cases using Test data.
Extensively involved in Manual Test cases for Functional testing, UI testing and SIT Testing.
Worked with Product Owners and Developers to review, evaluate and derive requirements for testability and providing feedback to define functionalities, test scenarios and to ensure the test requirements are correct.
Performed and able to create/build EDI test files like 837 and abled to validated the related data (Claims data) in the Core system post processing.
Performed and worked with 837 Health care claim and Payment 835 information.
Performed and worked with the EDI 276 transaction set is a Health Care Claim status inquiry.
Performed and worked with Testing EDI HIPAA 5010 Transactions including 837,834, 835, 270, 271, 276, 277. Thorough with the Transaction semantics, structure and content at the Segment, loop and attribute level and must be familiar with EDI Gateways and SNIP validations.
Wrote SQL queries to retrieve data from databases after data migration.
Performed back-end testing using complex SQL Queries.
Worked with Performance Testing, ETL Testing, and Manual testing processes and practices.
Developed ETL queries/Stored procedures to validated the ETL transformation logic implementation.
Supported QA team with validation procedures/queries to execute the ETL scenarios.
Executed the ETL scenarios and report bugs Root cause analysis for data discrepancies.
Performed design test cases, design ETL mapping scenarios, create SQL scripts, and define transformational rules in Informatica.
Performed data-centric testing’s core function is to test the ETL processes to ensure that data loaded into a data Warehouse is accurately inserted into the data Warehouse Tables.
Conducted integration testing to ensure data quality checks and business validation rules ware being applied successfully during ETL process.
Involved in the error checking and testing of the Data warehouse ETL procedures and programs
Developed complex MY_SQL queries for verifying the ETL Mapping rules.
Manual QA Tester
July 2014 - June 2016
Central Bank - Lexington, KY
Online Banking provides client to login, to view account information like account summaries, account details, monthly statements, balance transfers, accrued interest, check ordering, loan application, to apply credit cards, and other financial services.
Understanding the Requirements and Functional Specifications of the application
Coordinate with onsite BA to document requirements, Functional Specifications, User Stories.
Participate in Reviews and validate, Update BRD, FS, User stories, QA Plans, Test scenarios
Wrote and maintained Test Cases, Test Plans and Test Scenarios
Gather requirements on project scope, workload, environment, test data and manual test scenarios
Extensively performed Manual Testing process to ensure the quality of the software
Maintained traceability matrix to trace the requirements and corresponding development through the Software Development Life Cycle (SDLC).
Prepared by analyzing test cases functional requirement specification document.
Conducted Functionality and Regression testing during various sprints of application.
Engaged in waterfall methodology for the project
Developed test case in details for account summary and transactions functionalities
Contributed in test cases in details for account summary and transactions functionalities
Participated in UAT to make sure that the customer’s needs are met
Responsible for daily/weekly status updates showing the progress.
Reports and tracking the status of each defect and analyzing the bugs using QA / ALM
Completed test cycles and deliver applications per customer deadlines
Performed Integration testing, Regression testing and System Testing.
Perform data driven testing for regression testing.
Analyzed and imported test data from spreadsheets into Quality Center using Excel.
Participated in walk-through and defect report meetings periodically.
Responsible for daily/weekly status updates showing the progress.
Environment: Window 7, MS Excel, HP UFT, HP Quality Center/ ALM
********@*****.***
Cell:267-***-****
Contact this candidate