Vasantha Navaneeth

Working on multiple automation projects, including SQL Stored Procedure automation through SSIS, with Azure pipeline integration for an insurance client in the UK (AJG Gallagher). Leading test automation for ALM Integration Framework using Python and end-to-end test automation on Azure Data Factory projects.

• Leading multiple ETL test automation and data validation projects for a UK-based insurance client (AJG Gallagher), focusing on Azure cloud data platforms
• Designed and implemented automation for SQL Stored Procedures using SSIS, integrated with Azure DevOps CI/CD pipelines across multiple Orbit-based source systems
• Led test automation strategy and execution for the ALM Integration Framework using Python, enabling scalable and reusable automation frameworks
• Performed end-to-end ETL and data pipeline test automation for Azure Data Factory (ADF) projects using Azure DevOps, Azure Pipelines, and NUnit
• Developed and executed complex SQL queries based on Source-to-Target (S2T) mapping documents for data reconciliation and validation
• Validated and reconciled multi-source system data against target systems using business-driven data quality and ETL validation scenarios
• Created and maintained ETL data quality stored procedures in SSIS targeting Azure cloud environments, ensuring accuracy, completeness, and consistency
• Executed automated ETL test scenarios using AccelQ to improve regression coverage and testing efficiency
• Implemented CI/CD-enabled test automation in Azure DevOps using NUnit, Visual Studio, and PowerShell scripts

Led test planning, test execution, and test strategy for Citi Corp’s RTP (Rapid Test Pro) application, delivering customized QA solutions for banking and financial services

• Managed end-to-end test management activities including project planning, effort estimation, resource allocation, and team management
• Conducted test progress tracking, defined tester KPIs, and generated test metrics, dashboards, and defect reports
• Provided regular test status reporting, risk analysis, and quality metrics to senior management and client stakeholders
• Implemented QA best practices, process improvements, and lessons learned to increase test coverage, quality, and productivity
• Defined, documented, and enforced quality assurance processes, standards, and SOPs in collaboration with operations teams and Regional QA leadership

Led testing for the ACTIMIZE ICM regulatory platform, focusing on Individual Client Due Diligence (ICDD) for customer onboarding, KYC, and risk assessment

• Defined and implemented the QA strategy across all SDLC phases, ensuring compliance with regulatory and AML requirements
• Managed and guided the testing team through test planning, test execution, and User Acceptance Testing (UAT) activities
• Performed peer reviews of test plans, test cases, and test summary reports through project closure to ensure quality and consistency
• Prepared and analyzed defect metrics, test summary reports, and defect status dashboards using JIRA
• Mentored team members, addressed project risks, and resolved testing and delivery issues proactively
• Designed and developed automated test scripts using Selenium WebDriver with Cucumber (BDD framework) for the ICM application

Worked on TDBank Canada project focusing on Basel norms data feeds loading from various business segments through Load Manager Application to Finstudio core tables.

• Coordinated test execution activities with project management, development teams, and internal IT stakeholders
• Collaborated with internal and external partners to define optimal data analysis and testing solutions
• Managed end-to-end testing activities including test strategy definition, test plan preparation, and test case design
• Actively participated in Agile/Scrum ceremonies and supported Software Quality Assurance (SQA) audits
• Oversaw the complete defect management lifecycle, including defect identification, logging, reporting, tracking, and closure.

Nokia PORT Project – Portfolio Management Tool.

• Worked on Nokia PORT, a Go-To-Market portfolio planning and management application supporting Nokia markets
• Coordinated requirement understanding sessions with concept owners and business stakeholders
• Managed end-to-end testing activities including test strategy definition, test plan preparation, and test case design
• Conducted peer reviews of test cases, unit test cases, and assembly test cases to ensure quality and completeness
• Performed system testing and regression testing, actively participating in Sprint planning and Agile ceremonies
• Worked within Agile/Scrum frameworks and supported Software Quality Assurance (SQA) audits

Worked on the Standard Bank of South Africa – Business Operations project, supporting multiple interfaces of the Branch Delivery System.

• Participated in requirements analysis and the preparation of requirement specification documents.
• Conducted Functional Specification Specification (FSS) walkthroughs with clients to clarify business and technical requirements.
• Executed non-functional testing, including volume and performance testing, using Silk Performer.
• Prepared high-level effort estimations and Work Breakdown Structures (WBS) for testing activities.
• Executed integration, system, and regression testing across multiple application interfaces.
• Managed defect logging, tracking, and reporting, and prepared weekly test status reports.