QA Test Engineer (Manual, API & SQL)

HARISH KUMAR MADHAIYAN

QA TEST ENGINEER Manual, API & Database Testing

Bangalore, India +91-709******* **************@*****.*** PROFESSIONAL SUMMARY

QA Test Engineer with 4+ years of experience in manual testing, functional testing, regression testing, and production application support across the BFSI (NBFC loan applications) and Logistics (DTDC) domains. Skilled in test planning, test case design and execution, and defect tracking in JIRA across web, mobile, and enterprise applications. Experienced in REST API testing with Postman, SQL database validation in MySQL, UAT coordination, and Root Cause Analysis (RCA) in Agile/Scrum teams. TECHNICAL SKILLS

Testing Methodologies: Manual Testing, Functional Testing, Regression Testing, System Integration Testing (SIT), User Acceptance Testing (UAT), Sanity & Smoke Testing, End-to-End (E2E) Testing, Ad-hoc Testing, Web Application Testing

API & Database Validation: REST API Testing (Postman), Payload & Response Validation, SQL (MySQL), Complex Database Queries, Backend Testing, Data Validation, Data Integrity & Reconciliation

Test Management: Requirement Analysis (BRD/PRD), Test Planning, Test Scenarios, Test Case Design, Test Case Execution, Requirement Analysis, BRD/PRD Analysis, Defect Management, Defect Life Cycle, Bug Reporting, Bug Triage, Re-testing, Regression Testing, RCA

Domain Knowledge: BFSI, NBFC, Loan Management Systems, Logistics, Shipment Booking, Franchisee Portal, Customer Portal, Master Data Management, Bulk File Uploads, Schedulers/Batch Jobs PROFESSIONAL EXPERIENCE

QA Test Engineer DTDC Express Limited, Bangalore Jan 2024 - Present

Performed end-to-end manual testing of web, mobile, and REST API applications covering Functional, Integration, Regression, SIT, UAT, Smoke, Sanity, and E2E testing, including Shipment Booking, Franchisee and Customer Portal workflows

Analyzed BRDs/PRDs and created Test Plans, Test Scenarios, Test Cases, and test data; executed positive, negative, boundary, and end-to-end scenarios to ensure complete requirement coverage

Tested the Shipment Booking module end-to-end, validating booking workflows, field validations, pricing and charges, booking confirmation, and data consistency across UI, API, and backend

Validated schedulers, batch jobs, and Master Data bulk uploads by verifying triggers, execution timing, file formats, valid/invalid records, error handling, database updates, and output data accuracy using SQL queries

Performed REST API testing using Postman by validating request payloads, JSON responses, headers, HTTP status codes, error handling, and data synchronization, along with MySQL-based backend validation, data integrity checks, and UI-to- database reconciliation

Managed the defect life cycle in JIRA, including defect logging, triage, severity/priority assignment, re-testing, regression testing, and closure; performed RCA for critical application and production issue issues to support successful releases.

Coordinated UAT with business stakeholders and collaborated with developers, QA, BA, and product teams in Agile/Scrum environments to validate business-critical workflows, resolve defects, support production issues, and ensure successful releases

QA Engineer Tata Consultancy Services, Bangalore Feb 2022 - Jan 2024

Supported QA and production activities for an NBFC application in the BFSI domain, testing multiple loan products across the complete lifecycle from application, eligibility and verification to approval, sanction, and disbursement.

Performed backend SQL/MySQL testing using multi-table JOINs and queries to validate business rules, calculations, workflow stages, status transitions, data accuracy, and transactional consistenc

Executed end-to-end UAT test scripts and collaborated with QA, development, and business teams for test planning, build/release validation, defect troubleshooting, defect re-testing, and production issue resolution

Investigated data discrepancies and application issues by analyzing UI transactions, backend database records, and business logic, providing technical findings to support defect resolution and Root Cause Analysis EDUCATION

Bachelor of Engineering, Electrical and Electronics Engineering Karpagam College of Engineering, Coimbatore, Tamil Nadu 2017 - 2021

Contact this candidate