Shubham Gupta

SDET

Family Of Apps smoke/hotspot e2e Automation

Javascript Hack Jest-e2e Git python CI/CD

• Led successful onboarding of multiple Facebook App teams to E2E automation using the Jest framework, significantly improving testing efficiency.
• Accelerated automation progress by developing essential data builders, resolving critical framework issues, and creating robust E2E tests.

GenAI Integration in QA tools

Hack GraphQL GenAI Git Cloud

• Pioneered the integration of Generative AI into the QA tool, automating the generation of manual test cases from project requirement and test strategy documents, resulting in a 30% reduction in manual effort.
• Collaborated with the internal LLM team to train the AI model with QA test case data

SDET

KATS Automation for multimedia validation

Python Pytest Linux Git PDB AWS

• Was main POC for maintaining and building automation framework for multimedia team which is responsible for testing echo, alexa and fire tv devices.
• Helped automation QA by adding APIs for new testing scenarios and tooling support, enabling faster automation onboarding for new devices.

Device Montitoring

Python Jenkins Linux Git EC2 Docker

• Built device watcher notification service that gives near real-time alerts for physical test device health status, enabling faster maintenance of 100 plus devices.

Systems Software Engineer

Complex Datatype Support in Vertica

C C++ Linux Git GDB Docker

• Part of the Query Optimizer team, working on parse tree enhancements and intelligent query optimizations for complex type project
• This project will allow users to create table columns with complex data types such as structs, arrays & maps.

SDE Intern

Lockless Pub-Sub Framework

C C++ Multithreading SPDK Linux Git

• Worked on a project to implement a lockless publisher-subscriber framework. It supported multi-producer enqueue and multi-consumer dequeue of messages.
• For thread safety, used SPDK library to implement lockless queue wrapper using ring container.
• Achieved 50% performance improvement as compared to pubsub framework consisting of locks and mutexes.

SDET II

Rating Xpress V4 on Xpress Feed And MI

SQL Server T-SQL SSIS Toad for Oracle VBA Java Selenium

• Performed end to end data testing of Ratings data.
• Ensured data quality by running various data checks on multiple DB servers (SQL Server/Oracle), consisting of formulating and executing complex SQL queries, performing stored proc review, etc.
• Automated 60% of data quality checks consisting of records ranging from 10-70 million by using SSIS packages and SQL agent job.
• Done testing of web-based RD portal and automated regression cases using Selenium/Kosher framework

GDS Excel Plugin Validation

SOQP UI Web Services Toad for Oracle SQL ServerVBAADO DB

• Validated excell plugin by testing web services using SOAP UI
• Automated data comparison checks between source DB and excel using VBA, ADO DB and excel macros

Intern

Cross Ref Automation Regression Dashboard

SQL Server T-SQL VBA ADO

• Automation tool for regression testing of cross ref team.
• Tests are run on a single click and results are updated in ALM and test report mailed to team members
• Saved 90% of time 60 man hours of effort as compared to manual testing for each release

Arizona State University

GPA: 3.97/4