Api Testing Quality Assurance
Resume:
DIVYA SRI BURUGUPALLI
*****.****@*****.***
Austin, TX 78717
PROFESSIONAL SUMMARY :
Over all 12 years of IT experience in Database testing, Functional Testing, API Testing and PL/SQL Programming with Oracle
Expertise in Data Migration, Web Application, Web Services, Desktop, Mobile Applications and Device testing
Sound knowledge on Data warehousing concepts and ETL tools such as Informatica.
Experience in Banking, Capital Markets and Aviation domains
Working experience in Agile development methodologies (SCRUM)
Strong SQL scripting experience on data creation, validation, integration and Transformations.
Work Experience in writing Cursors, Triggers, Stored Procedures, Functions and Packages.
Work experience on REST and SOAP API testing using POSTMAN for JSON responses, SoapUI for XML validations.
Well acquainted with SDLC and STLC, Bug Life Cycle and Testing Techniques.
Expertise in Software Quality Assurance as a QA in developing Test Strategy, Test Plan, Test Scope Definition, Estimation, Test case preparation, Review, and Test case execution based on Business Requirements and Functional Specifications.
Performed testing in all environments - Staging, Maintenance, UAT and Production for Desktop, Mobile applications and Backend databases.
Extensively worked on various testing types such as System Integration, Functional, Regression, User Interface, User Acceptance, Ad-hoc, Data Base, Comparison, Browser compatibility and End to End testing.
Experience in writing test cases using BDD framework in Selenium
Well acquainted with Scrum environment – Product backlog, Sprint planning, Grooming, Story Points, Sprint Backlog, Task Breakout, Creation of Tasks, Sprint Review and Retrospective
Communicate Bugs, create and maintain Test Plans, Test Case design, Test Procedures and Test Scripts using tools such as JIRA, VSTS, HP ALM, and Azure DevOps.
Profound experience in managing Cross functional teams especially providing Test support/Test data support to complete E2E functionality of the project.
Proven experience in providing detailed Demos to Stakeholder in UAT env and getting sign-off on features/functionalities before releases.
Coordinated actively with technical peers such as Developers, Project Managers, and Business Line Analysts.
Conducted Defect triage calls with Developers to prioritize the defects.
Work Experience on Database tools like Toad, SQL Server and DBeaver
Having Sound Analytical and Communication skills, Interpersonal and Problem-Solving Skills
Proven experience in Leading offshore and multiple QA teams as a SME in validating data elements and supporting various Frontend teams with Test Data based on Business Line requirements and providing the necessary documentation in Confluence for release signoff.
Assisted in creating User stories, EPIC’s according to Backlog refinements and Planning meetings.
Worked as a Subject matter expert (SME) for various functionalities across multiple large-scale projects and providing required inputs which enhanced user experience to 99.9%.
TECHNICAL KNOWLEDGE
Testing experience : Functional Testing, Database Testing, API Testing
Applications : Web Services (Postman, Swagger, SOAP & REST API)
Languages : Oracle, PL/SQL, JSON, XML, Microsoft SQL Server
Database Tools : Toad, SQL Server, DBeaver
Defect tracking tools : JIRA, HP ALM, VSTS and Azure DevOps.
Frameworks : Cucumber, BDD.
Process : Agile Methodology
Operating Systems : Windows
Version Control System : GIT
WORK EXPERIENCE
Shell Inc – Houston Feb 2022 to Aug 2024
Role: Senior Quality Analyst
Validated Business functionalities in multiple areas of the applications from planning to closure, this includes all steps of the process from customer facing WEB interface to Databases.
Supported in creating Acceptance criteria for testing user stories according Business line requirements in Refinement meetings in JIRA.
Acted as a Test lead and provided the Test Estimates, schedules and status to management.
Developed well defined Test Strategy, Test plan, Test case, Test artifacts for Skypad WEB UI applications for business line signoff.
Participated in business requirement gatherings and review meetings and understanding the UAT testing scope.
Defined Entry and Exit Criteria for each level of testing.
Tested the application on Desktop and SKYPAD ground field devices (Tablet and Printer).
Wrote SQL queries to validate API and DB data elements.
Manually created Multiple Test Suites using SOAP UI and POSTMAN Performed E2E validation for XML and JSON payloads.
Used all the web methods like GET, PUT, POST and DELETE to validate the request, response, response time and error codes
Participated in code reviews, providing feedback on API design and functionality, which enhanced the robustness of implemented APIs
Used OAuth and OAuth2 authentication mechanisms while performing API testing.
Performed Cross browser testing using Microsoft Edge, Internet Explorer, and Chrome.
Performed Integration and Regression testing in Staging and Maintenance environments.
Get ready with the UAT Pre-requisite document before UAT Kick off.
Performed END to END Regression Testing in IT and UAT from User interface and conducted Defect triage calls with Developers to prioritize the defects.
Provided UAT signoff on Pre-Prod environment once all the raised defects are closed.
S&P Global - New Jersey Jul 2014 to Feb 2022
Role: Senior QA Engineer
Understanding the business needs and reviewing the documents at various stages with respect to functional aspects and working with Business Analyst for requirement clarification
Created High-level Test plan as per the functionality
Created BDDs and Test Data as per the business requirements
Created Test Scenarios, Test cases and Test Data
Developed SQL Queries to validate the Test Cases
Hosted Test case review meetings with scrum team
Developed new scripts and modified Existing SQL scripts as per the change requests
Performed Database testing by writing & executing SQL queries to validate the data is being populated in appropriate tables & compared the results with front-end values
Efficiently test the data at source and destination databases
Performed Positive & Negative Testing for system validations
Compare and Analyze the Expected with Actual results in DB
Debug SQL’s if source and target are not matching
Follow-up for the defect-fixes, retesting and closing the defects.
Involved in daily defect review meeting to discuss defects and prioritize the defects.
Performed all types of testing in various environments like QA, Staging and Production Releases.
Responsible for production support by execution of the scripts, analyzing the results and giving sign-off from automation Team.
Participated in all projects related activities – Sprint planning, daily scrum calls, test case reviews, defect reviews, grooming and retrospective meetings.
Tested the migrated project by validating the functionality and data between source and target.
Oracle Financial Services Software Ltd – Bangalore, India Jan 2011 – Oct 2013
Role: Staff Consultant
Flex cube environment set up for offshore development.
Developed new Stored Procedures & Packages in PL/SQL as per the business requirements.
Updated the Stored Procedures, Packages & Triggers in PL/SQL.
Prepared Design specification, Program Specification documents and Unit Test Plans with reference to the Functional Specification document.
Uploaded the data for all the modules by using Excel Import.
Performed Unit Testing to verify the functionality.
Involved in SQA Support and Project Closing activities.
Tested various Incoming and Outgoing Interfaces.
Develop and execute complex SQL join queries to perform DB testing.
Efficiently test the data at source and destination databases.
Involved in Test case review meetings with team members.
Involved in daily defect review meeting to discuss defects and prioritize the defects.
Developed SQL Queries to validate the DB Test Cases.
Compare and Analyze the Expected with Actual results in DB.
Performed Positive & Negative Testing for system validations.
Worked on Migration of the product from FLEXCUBE 4.3 version to FLEXCUBE 12.0
PROFESSIONAL SKILLS
Excellent IT project management skills, analytical skills and problem-solving skills.
Excellent interpersonal skills to effectively communicate with diverse, cross functional teams including staff at all levels of the organization.
Excellent and demonstrated skills in meeting facilitation, relationship management, leadership, critical thinking, technical writing and presentation skills.
Excellent strong written, verbal and nonverbal communication skills with internal and external customers and highly flexible and adaptable.
Demonstrate leadership skills via coordination skills, problem solving and guiding more junior team members and Strong time management skills with the ability to manage multiple tasks and prioritize effectively.
SKILLS SUMMARY
SQA Testing & Methodologies
Functional Testing
Webservices/API Testing
Database Testing
SQL, PL/SQL Scripting
User Acceptance Testing
Desktop, Mobile Applications and Device testing
Test Strategy, Test Plans, Estimation & Coverage
Test Scenarios & Test Cases, Test Data Creation
Integration & Regression Testing
Cross-Browser & Negative testing
Defect/Bug Tracking
Data Interface & Migration Testing
ETL Testing
EDUCATION
Jawaharlal Nehru Technological University – Telangana (INDIA): Bachelor’s in technology, Information Technology.
Contact this candidate