Data Analyst: SQL & BI Enthusiast with QA Flair

PRATIBHA UPPALAPATI

Cell: 339-***-****

E-mail: ***********@*****.***

Profile

Accomplished Senior QA Engineer with 6+ years of experience overseeing comprehensive testing procedures for web and gaming applications. Skilled in developing detailed test plans and strategies, performing complex manual testing. Expertise includes defect tracking with Jira, managing the complete defect lifecycle, and providing data-driven reports to stakeholders to optimize workflows and reduce post-release defects. Expert in API testing using tools like Postman and SoapUI, validating data integrity with advanced SQL queries, and integrating testing into CI/CD pipelines

Experience in effective quality implementation in all phases of Software Development Life Cycle.

Experience in testing Web applications.

Expertise in a variety of testing, including functional, regression, load and API testing.

Knowledge of continuous integration/continuous deployment processes and related tools like Jenkins.

Familiarity with languages such as Perl.

Strong background working in Agile and Scrum environments.

Experience with defect tracking and test case management tools like Jira, TFS and zephyr

Experience with verification of data on the reports.

Technical Summary

Test Management Tools – JIRA, Zephyr, TFS

Operating System: Windows, UNIX

Programming Languages: C, C++, Perl

RDBMS/ Database: Oracle, SQL Server

Testing Tools: Postman, SoapUI

CICD – Jenkins

Career Path

American Systems (Chantilly, VA)

Sr. QA Analyst (Sep’ 2022 – Jan’ 2025)

Responsible for writing Test cases and document test results in TFS using the agile methodology.

Responsible for writing SQL queries to test data.

Responsible for creating mockup test data for validation

Responsible for testing reports using complex strategies.

Used Postman to test all the APIs.

Participated in major application enhancements.

Responsible for regression testing in the staging environment.

Conducted Testing in multiple Test environments prior to production rollout

Environment: TFS, Jenkins, Oracle, Jave

Eclipse Gaming Systems. (Duluth, GA)

Software QA Analyst (Sep’21-July’22)

•Analyze new feature additions to a game and create testcases in Zephyr.

•Create test cycles and import testcases into them during execution cycle.

•Identify, create, track bugs in Jira and link them to the respective testcases for traceability.

•Run macro scripts on autocasino machines for identifying potential bugs.

•Document help pages about different bonus features, setting up Standard/Mystery progressives

on the class 2 server and other methodologies on confluence.

•Support the development team in further investigation of issues reported and of potential fixes.

•Functional, Integration, GUI, and Performance testing on electronic gaming machines.

•Reproduced and verified GLI/BMM/Field issues and provided feedback to developers, management.

Environment: C#, Jira, Zephyr, SQL Server

American Gaming Systems LLC. (Duluth, GA)

Software QA Analyst (Aug’17-Mar'20)

•Analyze/Execute test cases for testing class II and class III games across different jurisdictions and platforms.

•Execute Sanity, Functional, Integration, GUI, and Performance testing on electronic gaming machines.

•Identified, logged, track bugs in Bugzilla and link them to the respective testcases for traceability.

•Test new hardware configurations and firmware releases.

•Support the development team in testing custom builds, recreating reported bugs and test potential fixes.

•Worked with the configuration management team in reporting and resolving Jenkins build issues.

•Reproduced and verified production and GLI issues and provided feedback to developers, management.

•Supported offsite teams to get up to speed on testing and assisted in resolving any blocking issues.

•Setup demos to QA team, trained new members in the team and getting them productive quickly.

Environment: C#, Jira, Bugzilla, Jenkins, Oracle, TOAD

Microsemi (Norcross, GA) (Mar’11-Nov’12)

Application Support Engineer

Provided 1st level support and escalate issues to the right member of the team based on the problem category.

Provided support for version control tool Cliosoft SOS. Responsible for creating projects,

adding users and host training sessions in order to train designers in using the tool.

Responsible for supporting IBM SOI 7rf process technology. Duplicated, created testcases to

work with foundry and resolve DRC, LVS issues in Calibre.

Provided support for Win-Semi HBT H02U32 process technology. Ran Assura to verify

Technology library. Created testcases for DRC/LVS and also demo of the tool usage to

designers.

Developed QA scripts in Perl to run a test design which goes through a entire design flow and

applications needed to simulate and verify the test design.

Mediatek Inc. (Woburn, MA)

Applications Support Engineer (Nov’07-Jan’11)

•Provided first level support of EDA CAD applications, tracking and logging of bug in a

ticketing system, provided workarounds to specific problems and software enhancements.

•Responsible for installation of Cadence Custom IC applications and support for

Cadence IC Design environment.

•Responsible for project database management in Cadence using Cliosoft SOS This involves

setting up and maintaining database servers, supporting designers on multi site projects.

•Involved in CAD software licensing. Analyzed the licensing requirements and take decisions

on the number of licenses needed for designers. Participated in business deals with EDA

vendors in buying the CAD software licenses.

•Worked with vendors to organize CAD tool trainings to designers, coordinate meetings with

application engineers and designers to discuss issues.

Analog Devices Inc. (Wilmington, MA)

Applications Support Engineer (Jun’05-Oct’07)

•Provided first level support of EDA CAD applications, tracking and logging of bug in a

ticketing system, provided workarounds to specific problems and software enhancements.

•Involved in automation of cell library generation and QA. Generate and QA the cadence

views for 65nm standard cell and IO libraries.

•Characterized 0.18u and 90nm standard cell libraries, custom IO cells using layout simulation

flow at Best/Worst/nominal case corners as well as other corners using Adopt and performed

QA on the generated Synopsys, Verilog behavioral models as needed by various design teams.

•Extensively involved in CAD programming support, such as Cadence skill code maintenance.

•Responsible for installation and maintenance of Cadence dfII tools.

•Member of Cadence working Group was actively involved in conversion of digital standard

cell libraries to Open Access and QA. Converted custom skill code to Open Access.

•Assist product line design teams, particularly in areas of data flow among EDA tools.

EDUCATION

Masters in Computer Engineering

University of Massachusetts, Lowell, MA

Bachelor of Electronics & Communications Engineering

Nagarjuna University, Hyderabad, India

Residency status

U.S. Citizen.

Contact this candidate