Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Vishal J Pandya

Summary

Accomplished SQA Engineer and Business Analyst with a proven track record at Gilead Sciences, enhancing SaaS platforms like Salesforce and SharePoint through rigorous testing and stakeholder collaboration. Expert in SQL and adept at translating business needs into technical solutions, significantly improving project outcomes. Demonstrates strong leadership in guiding teams and streamlining processes for optimal efficiency.

Overview

8
8
years of professional experience
1
1
Certification

Work History

SQA Engineer / Business Analyst

Gilead Sciences
01.2018 - Current
  • Lead Software Quality Assurance (SQA) testing programs for the implementation of new applications and enhancements on SaaS-based platforms like Salesforce and SharePoint, while identifying and documenting business needs for technical alignment
  • Perform high-level data validation and exploratory testing using various methodologies on business-critical applications like Salesforce, SharePoint, Vendor Management System (VMS), Cost of Goods and Services (COGS), and Clinical Batch Record (CBR) to ensure data accuracy and completeness
  • Collaborate with stakeholders and development teams to analyze, document, and validate User Requirement Specifications (URS) and Functional Requirement Specifications (FRS), ensuring clear, complete, and testable requirements
  • Act as a liaison between business teams and developers, translating business requirements into actionable technical tasks and ensuring solutions align with organizational goals
  • Author and revise project artifacts such as test plans, test protocols, and traceability matrices, managing stakeholder review and approval through meetings and workshops
  • Assist with data migration activities using tools like Data Loader and Sharegate, ensuring environments are properly configured for testing
  • Conduct comprehensive system testing, functional testing, regression testing, load/performance testing, and stress testing to verify system functionality and readiness for User Acceptance Testing (UAT)
  • Participate in Software Quality Assurance testing and implementation of Veeva Vault, a SaaS-based application for Quality Document Management, ensuring alignment with business processes
  • Perform end-to-end data validation for Extract, Transform, Load (ETL) and Business Intelligence (BI) systems across multiple data sources and target applications
  • Execute SOQL queries using tools like Workbench to validate data in Salesforce applications and verify large datasets using SQL during data integration testing
  • Lead UAT efforts in collaboration with Business Process Owners and Business Analysts, developing UAT test plans, authoring test scripts, and preparing environments for execution
  • Manage the entire defect lifecycle using tools like Azure DevOps and HP ALM while ensuring timely resolution and accurate reporting
  • Prepare and present test execution summaries, defect reports, and release sign-offs to project stakeholders, ensuring transparent communication of project status
  • Provide guidance to offshore testing teams, ensuring alignment with test activities, and deliver Salesforce application training to new hires monthly
  • Maintain data integrity and ensure compliance with company SOPs, 21 CFR PART 11/EU Annex 11, GLP, GDP, and cGMP regulations, contributing to continuous process improvements for controlled documentation
  • Serve as a Salesforce System Administrator to manage operational tasks, troubleshoot issues, and support ongoing business requirements

Alumni Service Program Assistant (Graduate Assistantship)

International Technological University
08.2017 - 12.2017
  • Planned, coordinated, and implemented major alumni events such as the Global Partner Accelerator, Grad Reception, and Trivia Contest, ensuring successful execution and engagement
  • Supported the development and delivery of outreach programs, reunions, career services, and social networking initiatives, fostering strong connections among alumni, students, and the university
  • Researched, developed, and promoted social, cultural, and educational programs tailored to the diverse needs of generational alumni segments, enhancing community involvement
  • Managed marketing efforts for alumni events, including creating content for newsletters, online registrations via Mailchimp, and serving as the primary liaison between alumni, students, and the university

Software Quality Assurance Analyst (Internship)

Medivation, Inc
CA
09.2016 - 10.2016
  • Involved in implementation of Interactive Response Technology (IRT) application, and its testing and deployment in production environment
  • Analyzed business user requirement specifications to develop test scenarios pertaining to clinical supply chain management and manufacturing, requiring chemistry background
  • Designed and developed test plan from user requirements specification and the use cases documents
  • Documented all the proposed modifications to the user requirements specifications using Electronic Document Management system (EDMS), tested and documented using manual testing methodology
  • Designed and developed UAT protocols and performed UAT testing to ensure that the developed system satisfied the business needs as specified in the URS document
  • Actively participated in the resolution of defects, retesting of the defect fixes and documentation of the test results, per applicable deviation/discrepancy reports, as required
  • Actively communicated with business team, technical team and management team to manage defect life cycle to track and fix defects in time
  • Collaborated with Test Lead to review the executed protocol documentation
  • Created requirement traceability matrix to preserve trace between requirements and test cases
  • Demonstrated strong understanding of computerized systems and its applicability to manage data pertaining to clinical supply chain management and manufacturing using IRT

Education

Master’s - Computer Science

International Technological University
California, USA

Bachelor’s - Chemistry

Sardar Patel University
Vallabh Vidhyanagar, Gujarat, India

Skills

  • Testing and Defect Management Tools: HP QC, Azure DevOps, VersionOne, CodeScan
  • Development and Programming Languages: Java, C, Python, NET
  • Database and Query Tools: SQL, SOQL, Oracle DB
  • Business Intelligence and Analytics Tools: OBIEE, Spotfire, and Tableau
  • SaaS and Data Management Tools: Salesforce, SharePoint, Dataloader, SharePoint Designer

Certification

  • Certified ScrumMaster
  • Certified in Computer System Validation

Timeline

SQA Engineer / Business Analyst

Gilead Sciences
01.2018 - Current

Alumni Service Program Assistant (Graduate Assistantship)

International Technological University
08.2017 - 12.2017

Software Quality Assurance Analyst (Internship)

Medivation, Inc
09.2016 - 10.2016

Master’s - Computer Science

International Technological University

Bachelor’s - Chemistry

Sardar Patel University
Vishal J Pandya