S. NAGESWARA RAO

Results-driven software testing professional with over 14 years of experience ensuring the quality and functionality of diverse web and Windows-based applications. Proficient in utilizing a wide range of tools, including HP ALM, JIRA, Azure DevOps, and SQL Server, to execute comprehensive testing strategies encompassing functional, non-functional, integration, and regression testing. Expertise in ETL processes and BI report validation using MSSMS, along with CI/CD pipeline projects, reflects a commitment to delivering high-quality products in agile and DevOps environments. A meticulous approach to quality assurance combined with strong problem-solving skills facilitates the swift identification and resolution of issues, ensuring optimal application performance.

• Having experience in leading the team and reviewing test reports.
• Having work experience in telecom and health care domain projects.
• Extensive experience in reviewing and understanding functional requirements, user stories and thorough expertise in writing detailed test plans, test protocol and metrics.
• Got hands on experience in manual and automation testing.
• Areas of expertise include functional testing, system testing and regression testing.
• Preparation of test cases, test execution and reporting bugs, generating test reports.
• DB testing, API validation using postman.
• Proficient in identifying the resolution for the issues throughout the testing process.
• Well-versed with agile scrum methodology.
• Well-versed with web based and windows-based applications testing.
• I am well acquainted with software development life cycle concepts.
• Preparing/Executing SQL queries to view successful transactions of data and for validating data.
• Problem solving skills with a proactive approach to work.
• Ability to work independently and effectively in a team environment.
• Effective verbal, written and presentation skills.

• Defining the testing activities for subordinates.
• Reporting, document and manage risks, risk mitigation activities and the resolution of project issues.
• To check if the team has all the necessary resources to execute the testing activities.
• To check if testing is going with the software development in all phases.
• Interactions with stakeholders and attend weekly review meetings.
• Updating project manager and client regularly about the progress of testing status.
• Having a flexible attitude and positive approach.
• Ability to lead offshore testing teams.
• Training new associates to the team.

Project 1:

Title : Lab Power BI Dashboard Reports

Environment : SSMS, Power BI, SSRS

Role : Lead Test Engineer

Organization : IQVIA RDS INDIA PVT LTD

Tools Used : HP ALM, Azure DevOps (ADO), SSMS

Duration  : Aug 2024 to Till Date

Description:

Lab BI projects include many Power BI Dashboards and data management systems. There are different types of dashboards like customer portal, Internal dashboards and SSRS (SQL server reporting services) dashboards and for all these dashboards the source system is LTMS (Lab trial management systems).

The Reports are developed in Power BI and the data management systems data is developed and stored with stored procedures. As a testing validation process, ETL/DB testing is performed on Power BI dashboards to verify the database integration and for data management systems, Integrated parts are validated through by extracting the queries database data.

Responsibilities:

• Design test plans, test script, test scenarios, test reports, defect reports

• Analyzing system requirements, Mapping documents and transformation rules to design comprehensive test cases

• Designing and reviewing test cases to ensure test coverage

• Creating test data to validate scenarios based on functional requirements and ensure accurate results

• Executing tests across various environments by using SSMS with the help of SQL Queries

• Conducting regression tests to identify any regression issues and ensure backward compatibility

• Conducting smoke tests in the production environment to validate stability and functionality

Project 2:

Title : CI/CD Pipeline Bioinformatics Projects

Environment : Linux, Docker Execution Environment, Python, Nextflow

Role : Lead Test Engineer

Organization : IQVIA RDS India Pvt Ltd

Tools Used : HP ALM, CLI, WINSCP, Azure DevOps (ADO)

Duration  : Dec 2022 to Aug 2024

Description:

CI/CD Pipeline Projects include GCP (Good clinical practice) and RUO (Research use only) projects. I have been involved in testing the GCP Projects and RUO Projects like Ion Reporter, Genemapper, SVRNA, RAPPER, DAPPER, PACT, IPA…etc. RUO projects are aimed at creating an internal use only tool, that lab ops can use to track and monitor the performance of tool-based assays. The proposed tool will consist of an oracle database that will store control data and a custom script that will collect control data from the PTR/ Data form files. Users will be able to view plots of the data stored in the database using a Tableau dashboard. Additionally, the custom script will run automatedly at a set time interval and the tableau dashboard will update at a set time interval. This automation will allow real time tracking of the assay's performance.

GCP Projects are comprehensive pipelines designed to analyze gene expression data from various sources. Pipeline testing was performed within a Linux virtual machine (VM), utilizing the Docker image deployed on the VM. The testing involved executing the required commands to validate the functionality of the pipeline.

Responsibilities:

· Analyzing system requirements to design comprehensive test cases.

· Designing and reviewing manual test cases to ensure test coverage.

· Creating test data to validate scenarios based on functional requirements and ensure accurate results.

· Executing manual and automated tests across various pipeline environments

· Conducting regression tests to identify any regression issues and ensure backward compatibility.

· Performing site compatibility tests to verify compatibility with different platforms and configurations.

· Conducting smoke tests in the production environment to validate stability and functionality.

Project 3:

Title : LIMS Health Care Project

Environment : .Net, and SQL Server

Role : Sr Software Engineer / Lead Test Engineer

Organization : IQVIA RDS India Pvt Ltd

Tools Used : HPALM, JIRA, SQL Server, Tableau Server, ADO, Postman, API

Duration : Aug 2014 to Dec 2022

Description:

StarLIMS/ClarityLIMS offers Clinical Laboratories a powerful solution suite, which leverages the cumulative know-how and management tools of a wide range. The main aim/objective of the Project is to equip the present StarLIMS/ClarityLIMS application with the additional features/modules to enhance and optimize its affectivity for business use and to replace the usage of legacy system with new updated LIMS application for lab usage.

The Key features of ClarityLIMS are creation of projects/samples/workflows/protocols, sample management and Inventory management and it has developed on .NET framework. There are different modules developed in ClarityLIMS environment like Projects, Configuration, Lab View, Dashboards, Overview of samples/projects, automation, lab work, consumables, custom Fields…etc.

I have worked on couple of applications/tools/Instruments testing which are Integrated to the ClarityLIMS System like client manifest tool, Synchronizer, Inventory websites, Lab matrix (Bio repository), Freezerworks, EALIMS, Clarity API wrapper, Tableau server, Spotfire reports, Agilent/TapeStation/SoftMax Tools. etc.

Responsibilities:

• Understanding requirements from Top Team/ADO/JIRA and interacting with business analyst and dev team.
• Preparing test scenarios, test cases, test data based on functional/regulated requirements and HLD Document
• Involved in peer review of the test cases (functional and regression) and UAT test cases, post Test execution review.
• Performing adhoc, dry run and formal testing.
• Worked on different regulated applications like StarLIMS, ClarityLIMS, Freezerworks and EALIMS.

· Reporting defects and updating tasks in JIRA/HP ALM/ADO.

• Performing functional, Integration, regression and end to end testing.
• Actively involved in sprint planning, product backlogs estimation, daily scrum, retrospective, weekly status, prioritization…etc. meetings.
• Executing SQL queries to view successful transactions and for validating data.
• Prepared test reports, test plan, test protocol.
• Review of testing status from the testing team daily and plan for the rest of the work.

· Responsible for KT sessions on applications for peers.

· Postman has been used to verify the project/sample data from API.

Project 4:

Title : PGi Conferencing Services

Environment : .Net, Classic Asp, Php, and SQL Server

Role : Software Engineer

Organization : Proliant InfoTech Pvt Ltd

Tools Used : JIRA, CS Wiki, Sikuli, RC Tool, XML Tool, Branding Editor

Duration : Oct 2011 to June 2014

Description: PGi (Premiere Global Services Inc.) is a multinational corporation and global provider of conferencing and collaboration solutions. Their products include audio conferencing, web conferencing and video conferencing. PGi provides global SaaS (Software as a service) and cloud computing solutions to small, medium and enterprise businesses.

Application encompasses two major Services. Custom development applications and Backend services. Custom development applications made for customer services. Backend services made for support to the custom development applications to provide best services to the customers. The main objective of the testing custom development applications and backed applications is to verify the functional (functionality) flow of the apps for the change requests.

Responsibilities:

· Proactively Scheduling KT sessions with developers and on-site coordinates on new requirements in the release.

· Interaction with the test lead and development team regarding the status of the project.

· Test cases preparation based on requirement and HLD documents.

· Performed peer review of the test cases.

· Performed functional testing, regression testing, re-testing.

· Involved on deployments and perform production testing.

· Modifying the test cases according to the change request.

· Worked on different applications like custom development sites and Backoffice applications.

· Ensure all the deliverables are on schedule and of quality.

· Raising, Monitoring defects in the JIRA and ensure proper follow up of defects for their fixation.

· Involved in preparing test scripts using QTP.

· Executed regression test scripts.