Srikanth Venkata

Led a public transport project as a ETL QA Specialist focused on migrating an on-premises Enterprise Data Warehouse (DWH) to Azure, integrating data from multiple sources including PeopleSoft, Trapeze, SharePoint lists, manual inputs and many more sources. As part of this initiative, I was responsible for spearheading the analysis and development of a comprehensive testing strategy within an Azure-based ELT (Extract, Load, Transform) DWH architecture. This involved ensuring seamless data integration, validating data accuracy, and optimizing performance across diverse data sources while adhering to Azure best practices.

• Orchestrated end-to-end migration testing strategies for 20+ Data Marts to Azure, ensuring zero critical data loss and minimal downtime
• Developed and executed comprehensive test plans encompassing historical load, incremental updates, and edge cases, based on rigorous risk assessments and stakeholder alignment
• Engineered a robust data validation framework utilizing Spark SQL, Python, and SQL, automating complex data comparisons and ensuring 100% accuracy in business logic and data structure translations
• Led in-depth ETL testing for Azure Data Factory pipelines and DataBricks notebooks, employing advanced data profiling and reconciliation techniques to maintain data integrity throughout the migration lifecycle
• Designed and implemented a sophisticated testing infrastructure for precise 'apples-to-apples' comparisons between on-premises and Azure data, significantly reducing data inconsistency risks
• Executed multi-layer ELT/ETL testing across Parquet, Azure SQL Database, Delta Lake, and Serverless SQL pools, validating data consistency and functionality at each layer of the architecture
• Developed and implemented custom SQL scripts for automated data quality checks and performance testing, demonstrating strong programming proficiency and automation skills
• Utilized Spark SQL for complex data queries and transformations, performing in-depth data analysis to validate data integrity and ensure alignment with business requirements
• Proactively reviewed design documents and Miro boards, providing critical QA feedback to ensure alignment with technical specifications and prevent costly rework
• Facilitated design review meetings, fostering open communication and collaboration among cross-functional teams, demonstrating strong communication and leadership skills
• Actively participated in Agile ceremonies, providing accurate estimates, identifying potential risks, and fostering a culture of continuous improvement, contributing to efficient project delivery
• Developed and presented comprehensive cycle reports utilizing data visualization tools, providing stakeholders with clear insights into test progress, defect status, and resolution efforts
• Conducted meticulous manual testing of code refactoring, ensuring new logic implementations met business requirements and functioned as expected in the Azure environment
• Implemented automated data quality dimension checks (completeness, accuracy, consistency, timeliness) using SQL and Python, ensuring migrated data matched on-premises source systems
• Utilized Azure DevOps and Visual Studio for test case management, defect tracking, and automated test reporting, streamlining testing processes and improving traceability
• Led bug triage meetings, collaborating with developers and architects to prioritize and resolve critical issues, minimizing deployment risks and ensuring system stability
• Engineered data quality dashboards to monitor data integrity and track improvements over time, demonstrating a data-driven approach to quality assurance

The project mainly deals with developing web-based application where students can choose different courses and programs of their choice and get certified online. The data of the courses and students are stored in SQL Server database. The project now mainly deals with upgrades and integration with latest tools streamlining existing data. Primary role was to perform end to end testing of the application upgrades and data changes.

• Primary role in this project was to act as an SME of the data dealing with handling SCRUM activities and leading testing team
• Worked as a Senior QA handling multiple projects within the organization
• Handled testing team under onshore / offshore model
• Have driven QA team in multiple Projects with excellent knowledge of Testing methodologies
• Acted as SME during implementation of project CNS with Blue to real time integration
• Performing Scrum master role along with leading testing team as a lead tester
• Analyzed functional and technical requirements (Use Cases), BRD, mapping documents, and transforming them into a test plan
• Used Azure Dev Ops for test plan development and defect tracking
• Created and executed test plans, and test cases to test web application, packages, tables, and BI reports
• Worked on different test environments SIT, Staging and PROD while executing Test Cases effectively
• Implemented and maintained solutions to support multiple teams and mapped business requirements to testing needs
• Created test plan, mapping documents using Business Requirements Documents
• Created Test data when Source data is not available to test critical business logics
• Created detailed Test Cases using Microsoft Excel and Azure
• Participated in test case review meetings and provided feed back to cover corner test cases
• Covered testing of multiple integrations by designing test cases to provide full coverage
• Tested multiple data storage formats including SQL server tables, views, external table, temporary tables
• Proactively communicated and collaborated with development team to analyze requirements and deliver the test artifacts as needed
• Prepared Test Cases and Test Data for all the ETL testing stages
• Attended weekly and monthly Walkthroughs to review project status with Manager, Developers, and offshore team
• Validated the source and the target tables against the Mapping Document
• Communicated with end user to clear gaps in requirements and logged defects with excellent quality of testing
• Used postman in application testing projects to test API calls and integrations
• Performed Prod validation and proactively raised bugs for hot fixes
• Performed Regression, Functionality, and data mapping testing
• Deployed multiple projects into Production with excellent working knowledge of deployment processes

The project deals with B2B and B2C Client record management portals which brings in new enhancements to revamp the current application to improve the user experience allowing to interact between payment management portal, patient record portal and data management portal with integration of various third-party payment tools like Oracle NetSuite. Primary role is to perform end to end testing of integration between the Client record management portal and the data management portal

• Analyzed functional and technical requirements (Use Cases), mapping documents, and transforming them into a test plan
• Implemented testing with ability to develop test case by interpreting complex business logics
• Used HP ALM for test plan development and defect tracking
• Created and execute test plans, test harnesses and test cases
• Worked on different test environments SIT, UAT while executing Test Cases effectively
• Implement and maintain solutions to support multiple teams and mapped business requirements to testing needs
• Participated in creation of Test Plan using Business Requirement Documents
• Created detailed Test Cases using Microsoft Excel and imported onto HP ALM to Application components
• Did trouble shooting and provided solutions for potential issue
• Proactively communicated and collaborated with business analyst team and development team to analyze requirements and deliver the test artifacts as needed
• Prepared Test Cases and Test Data for all the testing stages
• Participated in defect advocating and tracking till the defect is fixed by the developers
• Used postman as tool to perform API testing
• Performed Regression, Functionality, and data mapping testing
• Designed and implemented test cases to test accessibility, compatibility, and API testing
• Helped automation team with providing test cases to be automated
• Performed regression testing using Selenium as tool of automation

The project involved developing a web-based application for automobile and property insurance where a user can obtain insurance for automobiles, properties, and process vehicle registrations. Primary role in this project is to perform end-to-end testing of the application front-end and backend, dealing with integration of client insurance portal using various integration tools, processing claim request along with license management platform

• Performed end-to-end testing of the application as a part of QA team while collaborating with automation team
• Analyzed BRD and design documents to prepare test plans to perform effective testing of the application
• Analyzed business requirements identified gaps and reported to the author
• Created detailed Test Cases and Test condition by applying equivalency partitioning and Boundary value analysis
• Used HP ALM as centralized Test Management and Defect tracking tool
• Created traceability matrix by mapping the requirements to the test cases to ensure test coverage
• Mapped all the Test Cases into the test lab of HP ALM and executed in the test lab module
• Participated in test advocating meetings to discuss defects identified with developers and business analysts
• Testing of Integrations and HTTP protocols using Rest API
• Performed Smoke/sanity testing of the application to ensure it is ready for extensive testing
• Performed functional, Integration, System testing by executing all the functional test cases by validating and tracking the results in Quality Center
• Performed Retesting and Regression Testing of application after defect is fixed by the developer
• Test plan, test cases, test data are provided as test deliverables after test closure