Sql Developer Qa Engineer

Detail oriented Sr.QA Engineer with excellent technical & communication skills and hands on experience in Manual & Automated Software Testing on Mobile, API and Web based applications, willing to be part of an organization where innovation and latest technological advancements are embraced, and one gets a scope to learn and grow along with the organization.

SUMMARY

10+ years of experience with Requirements Gathering, Documentation, Web Applications Testing, Mobile Testing, API Testing both Manually and by Automation.

Strong Knowledge of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) & multiple Software Development Methodologies like Agile: Scrum, and Waterfall.

Competent with Requirements gathering, Test Case creation & execution, Defect management and reporting

Experienced in designing and implementing automation scripts using Selenium IDE/RC, Selenium WebDriver using frameworks POM, Page Factory, Junit and TestNG, RestAssured.

Good at writing XPATH for Dynamic Web Elements.

Extensive Work experience on API testing using RESTFUL Webservices.

Manually testing Restful APIs using POSTMAN.

Manually tested GraphQL APIs using POSTMAN.

Experience with testing different versions of Mobile Apps on iOS and Android.

Monitoring logs on Charles Proxy for iOS Apps.

Monitoring logs on Android Studio for Android Apps.

Experience with performance testing using JMETER and Server Performance monitoring on Zenoss, Datadog.

Experience with MongoDB, DB Visualizer, SQL Developer and Medis tools for extracting data.

Experience with build tools like Maven, Gradle and creating builds in Jenkins CI tool.

Hands on experience with repository servers like GITHUB, BitBucket.

Hands on experience working on Graylogs, Kibana, AWS Cloud Watch logs.

Hands on experience monitoring Clusters and Services in AWS.

Hands on experience working on EC2 instances in AWS

Hands on experience monitoring Reports on S3 buckets.

Good Knowledge on Setting billing Alarms in AWS, AWS IAM S3, EC2, Cloud Manager.

Diversified experience in Functional Testing, Integration Testing, System Testing, GUI Testing, Regression Testing, Re-Testing, Link/Navigation testing, Browser & OS compatibility testing, Negative Testing, End-to-End and User Acceptance testing (UAT)

TECHNICAL SKILLS

Test & Defect Management Tool:

Selenium IDE, Selenium RC, Selenium WebDriver, Junit, TestNG, Maven, Jira, ALM, Jenkins, Git, Cucumber (BDD), Eclipse, Soap UI, RESTful Web Services, Postman

Language and Databases

JAVA, HTML, CSS, JavaScript, MySQL

Project Label Pattern (Framework)

Page Object Model, BDD, LOG4J

Software Development Methodologies

Agile, Waterfall

Operating Systems

MS Windows Server 2005/2008, Windows XP, Windows 7,8,10 LINUX, MAC (IOS)

ERP

SAP CRM 7.02, SAP ECC 6.0, Siebel, Salesforce

Database

Oracle, Redis, DynamoDB, MongoDB

Cloud

Amazon AWS, AWS IAM S3, EC2, SQS ECS Cloud Manager, CloudWatch, DynamoDB, Athena

PROFESSIONAL EXPERIENCES

Toyota Motors North America (TMNA) 3/2021— Till Date

Plano, TX

Project Overview: Worked on Non-CV, Pre17CY, 17CY, 17CYPLUS and 21MM Generation vehicle testing for Toyota, Lexus, Subaru on Mobile Apps and Portals for US, Hawaii, Puerto Rico, Canada and Mexico Regions.

Sr. QA Functional Testing

Prepared test cases using user stories and Epics.

Reviewed test cases written for different modules of the application based on Acceptance Criteria with development team.

Participated in Requirement Planning, JIT, UAT, Defect Triage sessions

Worked for Vehicle creation with Data Feed and Retail Delivery Reports triggers

Monitoring Vehicle creation Reports, Retails Delivery Reports.

Worked on Vehicle-association and Ownership.

Worked on Remote Users and Remote Authorization Cards.

Worked on Sub-preview of Product and validated product Description in English, French and Spanish Languages.

Worked on End-to-End Subscription testing

Covered a broad range of validations for Subscription that include

oTrial, Future Paid, Good-Will and Active Paid Subscriptions

odata flow to downstream

odata flow to Affiliates

oAWS logs monitoring

oMonitoring MongoDB collections

oMonitoring Invoices, Refunds made to Credit Card and cheques issued, Manual Adjustments through Zuora calls

oSubscription Reports, Marketing Reports, Enrollment Reports, Payment Failure Reports, Finance and Accounting reports validation and monitoring from S3 buckets

oValidation of Payment Failures, Payment Alerts, Payment Cancellation, Payment Expiration, Credit memo write-offs

oValidation of Cross-country transactions

oValidation of Data-Consents, Remote Authorizations, Vehicles-Associations, Provisioning, Subscriptions.

Worked on Data Consents.

Lead JIT with SiriusXM for 17CY Toyota and Lexus vehicles on Trial and Paid Packages for US, Canada, Hawaii and Puerto Rico Regions in English, French and Spanish Languages through iOS and Android Apps.

oValidated the data flow between downstream systems and portals (Dealer, Admin and Agent Portals)

Worked on End-to-End Wi-Fi subscriptions for Trial and Paid Products for 17CYPLUS and 17CY US and HI vehicles.

Participated in Planning of Certified Pre-Owned (CPO) Vehicles, worked on the CPO products, Subscriptions and Reporting.

Worked on validating SQS queues and flag triggers based on CPO indicators as received from Dealer Daily Feed.

Worked on the Customer Account transition from Azure to ForgeRock IDP, by validating user profiles from Mobile Apps, Portals and flow of data to the Centralized repository (Customer Central)

JIT with SiriusXM for Azure to ForgeRock IDP transition for Account Profiles and well as token changes on Payment Pages of Mobile Apps.

Worked on various version of Mobile Apps for Lexus, Toyota and Subaru on iOS and Android

Monitored logs on Charles Proxy for iOS and Android Studio for Android.

Monitored Network logs for Web Applications when working on Dealer and Admin Portals.

Worked on Authentication Token and Refresh Token for Web Application API’s

Worked on Salesforce CRM for Agent Portal tasks.

Worked on Manual Adjustments and Chargebacks, Payment Alerts, Payment Failures.

Worked on Scheduling of Jobs.

Performed Smoke Testing, Retesting, Regression Testing for log4j vulnerabilities.

Worked on Mobility for Fleet Customer accounts and making reservations.

Monitored Dead Letter Queue on AWS for failed transactions in SQS

Validated Subscriber Notifications services (SNS).

Validated OTP’s, Alerts, Messages and Emails in English, French and Spanish languages.

Worked on gRPC framework for 21MM vehicle association.

Validated Flutter Apps with Figma Selections.

Worked on Active-Active Testing, load balancing for East and West Regions on AWS for Various Clusters and Services of ECS and monitoring the tasks.

Hands-on experience on Postman to validate Rest API calls manually.

Monitored AWS Cloud Watch logs for each API call.

Monitored Kibana Logs.

Monitored performance on Datadog.

Validated data from S3 buckets in AWS.

Validated API from EC2 instances of AWS on Gateways.

Hands on experience with Test bench.

Validated Automation Test Cases, verified Automation Test Results for API’s and made suggestions accordingly.

Coordinated with Design Team, Issue Management Team and offshore Team for testing activities.

Created and shared Daily Status Report with Team Lead and proactively followed up with the appropriate team member to resolve any blockers

Attended QA stand up meeting, Weekly QA Review meeting and Product update meeting to understand quality testing activities and to determine work priorities

Attended meeting with offshore team as needed to discuss outstanding issue and to track progress.

Participated in mutual discovery workshops, ‘Art of possible’ sessions with the customer along with the development team

SiriusXM 3/2020— 3/2021

Irving, TX

Project Overview: Worked for Rapid Registration for Nissan, Infinity and FCA Vehicles for Head Unit and Dealer Registration APIs. Worked for Fleet Management Services, Vehicle Locator services and Stolen Vehicle Services. Worked for Accident Collision Notification and implementation for FCA.

Automation Champion

Prepared test cases using user stories and Epics.

Reviewed test cases written for different modules of the application based on Functional Specifications with development team.

Prepared automation scenarios Developed Selenium Test automation scripts using Cucumber framework for API testing.

Used SQL queries to extract data for automation and compared with the expected results of the JSONs.

Performed Web Application Testing.

Creating automation script and committed the codes in Bitbucket, reviewed pull request of teammates.

Use Continuous Integration Tools (Jenkins) for automation script run in every new push and during deployment to provide quick feed back to the developers.

Hands-on experience on Postman to validate Rest API calls manually.

Hands-on experience on manually testing Mobile Apps.

Used Swagger to validate the JSONs and validated the fields in each JSON Payload as per swagger documentation.

Monitored Graylogs for API flow. Checked the data in, session id’s, https status etc. in Graylogs to triage failures.

Performed API performance monitoring using JMeter and validated Throughput, first byte latency, response time, https status etc.

Monitored CPU Utilization, memory utilization, server performance using Zenoss.

Used Putty to login to Linux servers to check the daily logs for the scripts and to generated tokens.

Validated data logging in Siebel CRM System. Used DB visualizer to run SQL Queries for extraction of data from Siebel for the purpose of automation.

Validated data in data tables in Oracle DB using SQL Developer

Uploaded documents for various projects in Confluence

Used Intellij with gradle build tool to run automation scripts.

Used Medis tool to check the data in Redis.

Used SOAP-UI for WSDL and SOAP-calls.

Monitored AWS Cloud Watch logs for each API call.

Validated DynamoDB Tables in AWS

Validated data insertion to S3 buckets in AWS and also validated reporting in Athena.

Triggered stolen vehicle and Accident collision calls from Telematics Simulator and verified the calls on ORCV (One Road Connected Vehicle) Agent Screen.

Monitor defects in defect-tracking tool using JIRA tool Involved in daily SCRUM meetings and updating the daily status of the tasks.

Test Plan Preparation and execution using ALM.

Konica Minolta Business Solutions 6/2017—1/2020

Windsor, CT

Project Overview: Worked on Konica Minolta Inkjet and Laser Printers patch upgrades for document saving and email delivery engines.

Automation Engineer

Prepared test cases using user stories and Epics

Reviewed test cases written for different modules of the application based on Functional Specifications with development team

Prepared automation scenarios Developed Selenium Test automation scripts using POM framework.

Developing new automation scripts in different environments and submitting to review board

Creating automation script and committed the codes in Git, reviewed pull request of teammates.

Use Continuous Integration Tools (Jenkins) for automation script run in every new push in Git and during deployment to provide quick feed back to the developers.

Store log information using TestNG Reporter and to generate information in html file.

Hands-on experience on Postman and Rest client plugin to validate Rest API calls manually.

Monitor defects in defect-tracking tool using JIRA tool Involved in daily SCRUM meetings and updating the daily status of the tasks.

Prepared and maintained Test Deliverables including Appropriate Test Summary Reports, Progress Report, Bug Reports and RTM

Created and shared Daily Status Report with Team Lead and proactively followed up with the appropriate team member to resolve any blockers.

Attended QA stand up meeting, Weekly QA Review meeting and Product update meeting to understand quality testing activities and to determine work priorities.

Attended meeting with offshore team as needed to discuss outstanding issue and to track progress.

Starwood 12/2015–1/2017

Stamford, CT

Project Overview: Worked for various hotel API’s integration for image, data exchange operations.

QA Engineer

Participated in Sprint planning, Daily standup, Retrospective meeting and ensured QA team engagement with Developers and Product team.

Developed test scenarios with test data to support test objectives.

Designed Test Cases for manual testing and test scripts for automation using Selenium WebDriver to check the functionalities of the application.

Managed multiple Test Environments and followed best practices on Release Management in order to mitigate functional & operational risk.

Reviewed Test Execution Results generated from TestNG output folder.

Performed functional, integration, regression, and boundary testing on different modules to check for the stability of the system.

Used Jira for reporting, defect tracking and managing the defects and tracked them to closure.

NetAPP 4/2014–7/2015

Sunnyvale, CA

Project Overview: Worked for GTC RMA project to perform the shipment of disks based on the legal restrictions and to route through the approval process to send the Field Service Engineer to Site based on individual customer’s SLA.

Tester / BA

Had been a key player in end-to-end testing that includes but not limited to drafting Test Scenarios, creation of Test Cases, Test Data Staging, Test Execution, Defect Reporting and tracking, Re-testing and Regression Testing, End-user training and Status Reporting.

Reviewed Functional Spec and suggested corrections as per the end user’s requirement.

Participated in the POD meetings to understand the on-going production issues, drafted Test Scenarios and updated Test cases for Monthly Releases in ALM.

Performed Test Data set up for Data staging of UAT. Executed Test Cases, did intensive Re-testing and Regression testing, coordinated with the Technical team with screen shots and WebEx recordings on different bugs detected and worked closely with the Technical Team and QA team to get the fix and test.

Coordinated actively with different teams to execute Test cases involving multiple environments. Performed User

Acceptance Testing on behalf of end-user to ensure that the user requirements are satisfied and properly tested apart from Requirement gathering.

Involved in weekly project status meetings and provided UAT status reports.

Worked on integrating the SAP system with non-SAP systems so that the messages/updates can be posted successfully.

Checked the updates made on the WSDL as per the requirement.

Ocwen Financial Solutions 3/2005–7/2008

Bangalore, India

Worked as System Administrator. As a System Administrator actively involved in the creation of users in the Active Directory, Setting up mailboxes for the user, maintaining the mailboxes in the Exchange server, Maintaining in-house applications like RealServicing, RealTrans, RealSynergy. Also maintaining other applications like Everest, AS400. Worked on the Remedy Ticketing tool for administering the user authorization issues. Server Maintenance, Running scripts on a daily basis for deactivating the users not logged in to the system for more than 15 days. Deactivating the unused accounts and deleting the accounts for the terminated employees.

EDUCATION

Bachelor of Technology from JNTU, Hyderabad

CERTIFICATIONS

SAP Certified CRM Associate

RPIC with Part 107 Certification with sUAS Rating

Contact this candidate