Vamsi Reddy G

Designed and implemented ETL automation frameworks using Python, SQL, and Selenium, ensuring accurate data transformation and integrity across Oracle, MySQL, and PostgreSQL. Automated data validation across healthcare datasets, enforcing HIPAA compliance and reducing manual QA effort by 60%. Integrated automated ETL tests into Jenkins and Azure DevOps CI/CD pipelines, enabling continuous validation of data flows after every code change. Conducted performance and scalability testing of ETL jobs using JMeter, optimizing throughput for large healthcare data volumes. Built data-driven test suites using TestNG and Selenium, supporting parameterized validation across multiple input datasets. Designed and implemented Tricentis Tosca model-based automation for end-to-end healthcare workflows including patient registration, eligibility verification, claims adjudication, and billing. Automated REST APIs using Tosca API Scan to validate claims and billing services. Created automated reconciliation scripts ensuring accurate mapping and transformation between source and target systems. Validated AWS RDS, Lambda, and S3 data pipelines, ensuring cloud-hosted ETL processes were reliable and secure. Collaborated with data engineers and architects to identify and resolve data quality defects in near real time. Embedded regulatory compliance checks for healthcare data privacy and security into automation (UI, API, and data validations), ensuring encryption, access control, and audit logging were consistently validated in test cycles. Applied risk‑based testing to prioritize critical healthcare workflows such as patient registration, eligibility verification, claims adjudication, and billing, optimizing regression scope and reducing production incidents. Led risk assessment of test coverage and test evidence for major releases, identifying control gaps, defining mitigation actions, and tracking them through to closure with product and risk teams.

Built cross-platform mobile automation using Appium, XCTest, and Espresso, ensuring consistent performance on Android and iOS. Automated API and UI testing using Cypress and REST Assured, integrating validations for end-to-end financial workflows. Orchestrated data testing automation with Python, SQL, and Azure Data Factory, validating transformations and reconciliations in ETL pipelines. Designed performance and load tests using JMeter, benchmarking API throughput for high-volume financial transactions. Developed reusable BDD frameworks using Cucumber and Java, increasing regression coverage and improving maintainability. Implemented real-time data validation for streaming pipelines using Apache Kafka and MongoDB, improving data consistency and latency. Ensured QE activities across releases (planning, development, testing, deployment) followed organization SDLC/SDAM standards by enforcing change management, peer review, and quality gates in CI/CD pipelines. Served as a key contact for testing‑related compliance topics, partnering with risk and audit teams to ensure test processes, evidence, and environments met internal control and regulatory requirements. Designed and executed risk‑based test strategies for high‑value financial workflows (transactions, portfolio valuation, reporting), focusing automation and manual validation on high‑impact, high‑risk scenarios. Automated Data Warehouse validation on Snowflake and SQL Server, ensuring financial accuracy in reporting. Designed reusable Tosca business process models to automate complex financial scenarios with minimal maintenance. Used Tosca TestCase Design (TCD) for large-scale data-driven regression of financial calculations. Automated REST services using Tosca API Scan for investment and transaction APIs. Performed backend data validation using Tosca DB automation across SQL Server and Snowflake systems. Integrated Tosca automation into Jenkins and GitLab CI/CD pipelines.

Developed and executed Selenium automation frameworks in Java with TestNG and Maven, ensuring regression stability for web and mobile applications. Configured CI/CD pipelines using Bitbucket, Bamboo, and Jenkins for continuous integration and automated regression runs. Automated cross-platform mobile tests using Appium and Python, achieving seamless execution across Android and iOS devices. Validated backend data integrity using SQL queries and XML comparisons, ensuring reliable transactional data processing. Performed API testing using Postman and Rest Assured, validating integration between middleware and front-end components. Conducted stress and endurance testing with JMeter, identifying and optimizing performance bottlenecks in streaming applications. Integrated automated ETL tests with Apache Airflow, ensuring early detection of data quality issues after pipeline runs. Implemented data-driven test execution and reusable test components to improve framework efficiency and maintainability. Collaborated in Agile teams, participating in sprint planning, backlog grooming, and daily stand-ups to ensure quality deliverables. Automated REST and SOAP services using Tosca API Scan for provisioning and billing systems. Used Tosca TestCase Design to manage high-volume customer and plan variations. Performed backend validations using Tosca DB Connect to ensure billing accuracy. Integrated Tosca regression suites into Jenkins and Bamboo CI/CD pipelines. Enabled Distributed Execution (DEX) for parallel regression execution. Applied Risk-Based Testing to optimize telecom release cycles. Contributed to end-to-end automation strategy, aligning QA processes with DevOps pipelines for faster release cycles.

Prepared and executed detailed test scenarios and scripts based on business requirements, ensuring complete test coverage across modules. Automated web testing using Selenium WebDriver with Python, validating key business workflows across browsers for consistent user experience. Performed manual and automated functional, integration, and regression testing, identifying high-impact defects before release. Developed SQL queries and stored procedures to verify backend data integrity and perform database validation during regression cycles. Created and maintained data-driven test cases using reusable functions in JavaScript, improving test suite efficiency and scalability. Conducted API validation using SOAP UI, ensuring stable communication between web services and third-party systems. Performed performance tuning and database monitoring using SQL Server Profiler and Index Tuning Wizard, reducing query latency. Implemented basic performance testing with Python libraries, analyzing response time and memory usage for key business functions. Collaborated with developers and business analysts to troubleshoot defects and validate fixes in pre-production environments. Designed reusable Tosca business process models for product listing, asset upload, and synchronization. Automated DAM and PAM APIs using Tosca API Scan. Implemented Tosca TestCase Design (TCD) for data-driven retail scenarios. Authored comprehensive test documentation, user guides, and release notes, supporting smooth QA handoffs and knowledge transfer.