VISHANT RAJ
Noida
Summary
I have over 4 years of experience working as a Associate Business Quality Analyst in data validation and testing environments. My expertise lies in functional, regression, and integration testing across internal and client releases. I have hands-on experience in preparing validation documents such as IQ, OQ, VTP, and VTSR in compliance with regulatory standards. I have worked extensively on SQL queries and ETL validation to ensure data accuracy and consistency. Additionally, I have developed and optimized PySpark-based validation scripts to automate patient safety data integration processes. I have experience working with AWS S3 and Oracle databases to manage and validate large datasets. My role also involves creating detailed test cases and scenarios based on business and system requirements. I actively collaborate with cross-functional teams to ensure timely delivery of high-quality, compliant solutions.
Overview
5
5
years of professional experience
Work History
Associate Business Quality Analyst II
RxLogix Corporation
Noida
06.2024 - Current
IQ/OQ Automation Framework | January 2023 – June 2023
- Developed a Python and Selenium-based automation framework for IQ/OQ, handling both web and DB operations with assertions at multiple checkpoints.
- Built Excel-based user interface for easy test script creation and execution across multiple environments with parallel logging and HTML reports.
- Sole owner of framework development and enhancement; cost-effective solution executable from local machines or VMs.
Technologies: Python, Selenium, OracleDB, SQLPlus, RDBMS - Prepared and reviewed IQ, OQ, VTP, and VTSR documentation for internal validation processes.
- Performed functional, regression, and integration testing across multiple releases.
- Designed and executed ETL jobs with strong hands-on experience in SQL queries for data validation and analysis.
- Developed comprehensive test cases, test scenarios, and test strategies based on User Requirement Specifications (URS) and System Requirement Specifications (SRS).
- Led the development and optimization of PySpark-based validation scripts to ensure seamless patient safety data integration from AWS S3 to Oracle databases.
- Implemented automated validation processes to improve data accuracy, significantly reducing manual effort and potential errors.
- Collaborated with cross-functional product teams to enhance data pipelines and ensure compliance with pharmacovigilance standards.
Associate Business Quality Analyst I
RxLogix Corporation
Noida
06.2021 - 06.2024
- Designed and refined Selenium-based automation frameworks using Python to streamline operational qualification (OQ) processes, reducing validation time.
- Enhanced data validation frameworks by integrating business-specific scenarios with advanced SQL queries, improving accuracy and robustness.
- Authored test scripts for PL/SQL programs, wrote complex SQL queries to validate business scenarios, and prepared release documentation for multiple deployments.
Validation Framework | December 2023 – December 2024
- Automated Pl/SQL and SQL validation framework for source-target data comparison using metadata-driven query generation.
- Supported ad-hoc, date-range, and full dataset validations with parallel batch execution and consolidated reporting.
- Authored IQ/OQ, VTP, VTSR, and release documentation for all validation processes.
Technologies: Pl/SQL, SQL, RDBMS
Skills
- SQL
- Data validation
- Manual Testing
- Automation Testing
- Selenium
- Python
- End-to-end testing
- Regression testing
- Bug tracking
- Defect logging
- SQL
- ETL Testing
- Data Validation
- ARGUS
- LAM
- JIRA
- CSV
- GitHub
- Jenkins
- Regulatory compliance
Accomplishments
Employee of the Month, 06/01/22, Received Employee of the month award for effectively executing the end-to-end testing along with highest number of bugs reported in 1 story/module.
Timeline
Associate Business Quality Analyst II
RxLogix Corporation
06.2024 - Current
Associate Business Quality Analyst I
RxLogix Corporation
06.2021 - 06.2024