Vamshi Bandaru

Software Development Engineer in Test (SDET) / QA Tester

Current Loation: Charlotte,NC

Phone: 501-***-****

Email: ad0a18@r.postjobfree.com

Summary:

8+ years of extensive IT experience with primary expertise in Object Oriented Programming and Web-based Enterprise applications using Java and J2EE Technologies.

Knowledge of all phases of Software Development Life Cycle (SDLC) including Design, Development, Testing, Documentation and Maintenance of applications.

Profound experience in developing different web applications using Agile Methodology, Waterfall model.

Good knowledge and experience with JDBC, Java Beans and Data Structures like Collections, Maps, Sets, and Lists etc.

Experience with Object Oriented Design and Object-Oriented Analysis, Complete System Life Cycle, Writing Use cases, sequence diagrams and class diagrams with UML tools like Rational Rose for business modeling.

Experience with Continuous Integration using Jenkins.

Efficiently increased products test coverage (over 100%) and significantly reduced the risk of major issues at release.

Experience in developing and executing test cases manually and developed Automation scripts with Selenium IDE, Grid, Selenium Web driver with java.

Used JMeter to execute Load Tests outside the company firewall by configuring host machines with

JMeter.

Create detailed bug reports following best practices and work closely with Development team to reproduce bugs, perform root cause analysis, and resolve bugs.

Proficient in GUI Testing, System Integration Testing SIT, Regression testing, End to End testing, User Acceptance Testing UAT, Functional testing, Sanity testing and Smoke Tests for complex scenarios.

Excellent skills in creating and accessing Database using SQL Queries, PL/SQL scripts (Stored procedures, triggers, functions, packages, cursors, views, and synonyms) on Oracle.

Solid grip on Rest SoapUI, Groovy Scripts for Web Service API and Integration and performance testing.

Experience in implementing JUNIT – unit and integration test cases.

Implemented SOA architecture with web services using REST, SOAP.

Hands on experience in pulling the data by performing Left, right, inner joins etc.

Improved infrastructure design and approaches of different projects in the cloud platform Amazon Web Services (AWS) by configuring the Security Groups, Elastic IP's and storage on S3 Buckets.

Worked on Multiple AWS Lambda instances, set the security groups, Elastic Load Balancer and AMIs, Auto scaling to design cost effective, fault tolerant and highly available systems.

Used JIRA for tracking tasks and user-stories and for bug reporting.

Executed manual test cases and test scripts and raised, reported defects in the team collaborating tool Hp Alm.

Technical skills:

Test Management Tools: JIRA

Automation Testing Tools: JMETER,Selenium WebDriver with JAVA, TestNG, Page Load Time for

performance testing

RDBMS: Oracle Database, MYSQL and MS SQL Server

Database Access Tools: Oracle SQL Developer

Programming Languages: JAVA, SQL

Application Server: Apache Web Server

Operating Systems: MS Windows, Windows Server

IDE: Eclipse and IntelliJ IDE

Experience Summary:

Duke – Energy,Charlotte,NC Aug -2022 to Till date

SDET / QA Tester

Used automated scripts and performed functionality testing during the various phases of the application development using Selenium IDE.

Designed, executed, and maintained Selenium Web Driver (TestNg, JUnit) automated test cases for regression test cases.

Use the client instance to call the desired AWS service APIs.

Tested Java project to ensure the integration with AWS services is functioning as expected.

Actively participated in and represented QA team in the Sprint Planning Meetings, Daily Scrum Meetings, Sprint Review meetings and Sprint Retrospective Meetings.

Maintained detailed test logs and report test results in Test Director

Participated in test plan and test cases review meetings.

Responsible for Backend testing by executing SQL statements

Worked on distributed test automation execution on different environment as part of Continuous Integration Process using Selenium Grid and Jenkins.

Worked on Jmeter to create thread groups and test web application using SOAP/Rest protocols for various loads on key business senarios.

Performed Integration and Regression testing to check compatibility of new functionality with the existing functionalities of the application using Selenium.

Experience in RESTFULL web service Testing using Rest Assured framework java. Validated JSON formatted data, different http status code like 200, 201, 400, 415, 500etc.

develop and maintain automated test scripts using frameworks and tools suitable for Linux-based software. Automation helps in streamlining repetitive test cases, increasing test coverage, and improving overall efficiency.

Performed backend testing for data validation using SQL Queries.

Document all test cases, test documents, and bug reports in Atlassian JIRA and test management tool X-Ray.

Performed negative and positive testing using SQL Queries

Run SQL queries testing and data transfer to the Mainframe for claims process. Performed rigorous manual testing such Functional Testing, Smoke testing, Integration testing, UAT Testing, Backend Testing, Regression Testing, End to End Testing and System Testing.

created and executed Jmeter scripts for performance testing.

Test-Driven Development methodology. Generated code coverage analysis and improved coverage.

Automated Regression, sanity tests for CI/CD process.

Reviewed extensive SQL Queries with complex multi-table joins and nested queries.

It will compare the test data with DB (sql, oracle, mysql, postgrees)

It will generate the test report for each test run.

We can generate this application test reports with JIRA test cases.

Environment: Java, Selenium WebDriver, Eclipse, TestNG, SQL, HTML, XML, XPath, Java, JIRA, Windows, GitHub, Agile/SCRUM, Maven, Mainframes, ACT Tool, Oracle DB, WinSQL.

Walmart, Bentonville,AR Feb 2019 – Aug 2022

SDET / QA Tester

Responsibilities:

Analyzed business requirements and functional requirements specification to get a better understanding of the system from both technical and business perspective.

Performed all the Quality assurance functions, which involved reviewing and analyzing the requirements specification for creating the test plans, test strategies, test cases and test procedures.

Responsible for all testing activities including test case development, tracking test coverage and execution.

Developed BDD tests using Cucumber by writing behaviors and step definitions. Developed required Selenium support code in JAVA for Cucumber.

involved in integrating U/UXI with API and loading data using REST API.

A/B testing and get thorough feedback stylistic UI resembling call of duty environment

created reports/Graphs using Jmeter and loadRunner.

Implemented Dynatrace and Splunk for log trace and configured alerts if the application throws any error or issue.

Used BDD framework with Cucumber created future files with scenario and scenario utline files.

Worked with deployment team to create nightly automation regression execution builds.

Implemented Page Object Model pattern in automation Framework.

Implemented screenshot taking on the failure of automated tests and included them into reports.

Applied test automation framework on CI/CD process using Jenkins.

Configured Cucumber Report Plugin and Performance Plugin to Jenkins to generate html test reports.

worked experience on client side frameworks like ReactJS and Jasmine Unit Testing.

Identified, analyzed, and documented defects utilizing defect tracking system Jira and Confluence as knowledge and documentation management system.

Developed the User Interactive web pages in a professional manner with using web technologies like HTML, CSS, Java Script, jQuery and AJAX.

Performed System, Integration, Smoke, Functional, Positive and Negative and monitored the behavior of the applications during different phases of testing using testing methodologies.

Planning for test Execution activities to accomplish tasks on daily/weekly basis.

Environment: Java, Selenium, TestNG, Soap,Rest, Java Script, JIRA, Cucumber/Gherkin.

Ally Financial, Charlotte,NC Apr 2018 – Feb2019

QA Tester

Responsibilities:

Coordinated work with DB team, QA team, Business Analysts and Client Reps to complete the client requirements efficiently.

Designed dynamic and browser compatible UI using HTML5, CSS3, Bootstrap, jQuery, JavaScript and Groovy.

Implemented J2EE design patterns such as Session Facade, Factory, MVC.

Involved in writing Java API for Amazon Lambda to manage some of the AWS services

Used AWS services like EC2 and S3 for small data sets.

Used WSDL and SOAP protocol for Web Services implementation

Developed RESTful APIs with Spring Boot based Micro services APIs.

Experience in creating event processing data pipelines using Apache Kafka

Worked on advanced Hibernate associations with multiple levels of Caching, lazy loading.

Worked with Docker container infrastructure to encapsulate code into a file system with abstraction and automation.

Implemented the GraphQL APIs in the springbootmicroservice using the repository service design pattern.

GraphQL basically enables/empowers clients to navigate the map according to their needs.

Developed database triggers and procedures to update the real-time cash balances.

Involved in the performance tuning of SQL Queries by generating execution plans and used Indexes, partitions.

Implemented Ansible to manage all existing servers and automate the build/configuration of new servers.

Defined all server types in Ansible, so that a newly built server could be up and ready for production within 30 minutes with OS installation.

Worked closely with the testing team in creating new test cases and also created the use Cases for the module before the testing phase.

Involved in writing JUNIT test cases and day to day builds and deployments using GRADLE.

Expertise in MVC architecture Web Framework Struts 2.0, Spring 4.0 (Dependency Injection, Data AccessObjects, MVC Framework and Spring Web Flow) and know how to use Spring and SpringBoot Framework in business layer for Dependency Injection, AOP, Spring MVC, transaction management and used Hibernate as a persistence layer that use the POJOs to represent the persistence database

Environment: Java, JSP, Spring 3.0, Hibernate 4.0Spring Boot, AWS, Docker, RESTful, JSON, HTML5, JavaScript, AWS, Gradle, SQL, Eclipse, Junit, Maven.

Aienterprise, Bangalore,IndiaDec 2013 – Feb2015

Java/J2EE developer

Responsibilities:

Analyzing the requirements, designing a solution and interacting with team members to provide effort estimates, Coding and Unit Testing.

Used Agile Methodology for developing applications.

Used React JS in the development of the web applications.

Used React router for Routing/Navigation of views.

Load data from various data sources into HDFS using Kafka.

Involved in analysis of Requirements Documents to completely understand the required behavior of the web pages and user interactions.

Used Spring MVC framework for implementing MVC architecture. Including AWS CLI / API, Terraform, Ansible, Python, Bash, and GIT.

Configure build pipelines to support automated testing and deployments using tools including Jenkins, AWS Code Deploy. Configure these pipelines for specific products and help optimize them for performance and scalability.

Gained good experience by working with configuration management tool Ansible and CI/CD tool Jenkins.

Worked on AWS Elastic Beanstalk for fast deploying of various applications developed with Java, PHP, Node.js, Python, Ruby and Docker on familiar servers such as Apache and IIS.

Implemented REST controllers using Spring MVC framework.

Used JDBC for interacting with database.

Built reusable visual components using JavaScript, JQuery, HTML and CSS3.

Developed client-side validation code using JavaScript and React custom component developed by us for validating input fields named input validator.

Generating automated test workflows with PYTHON scripts using Squish Tool.

Developed unit test cases for the front-end JavaScript code using Jasmine framework.

Used Git hub for version control.

Involved in writing SQL queries for retrieving data from RDBMS DB2.

Environment: Java, Spring, REST, JavaScript, Spring 3.0, JDK 1.6, JDK1.7 jQuery, HTML, CSS3, Bootstrap, React JS, IBM DB2, Docker, Jasmine, Git hub, Windows XP, AIX.

Info Edge Solutions, Hyderabad,India Aug 2012-Dec 2013

Java Developer

Responsibilities:

Extensively involved in analysis and design of the back-end skeleton including connecting to Database, creation of Data Model layer and DAO Layer for the system using Hibernate.

Involved in the creation of mapping of the Oracle database tables using POJO classes to the upper application layer of the application.

Used different Transfer Object (TO) to merger/transfer data between different layers.

Developed application functionality inside DAO layer; that can be used in the processing of all the transaction of the application using Spring Framework.

Implemented Model View Controller webframework.

ExperiencedworkingonseveralDockercomponentslikeDockerEngine,Hub,machine,composeandDocker registry.

Created UserH Interfaces (UI) using JSP, JSTL, HTML, JavaScript and CSS.

Generating dynamic PDF reports with the help of XML usingXSLT.

Deployed application to the JBossApplicationserver.

Worked with Ant to create build automation for thesystem.

Involved in JUnit, functional testing and also involved in debuggingprocess.

Environment: Java, J2EE, spring, Hibernate, JSP, Servlets, HTML, DHTML, XML, XSL, XSLT, CSS, JavaScript, Oracle, JBoss, Linux, Kafka.

Education :

Bachelor's : BBM 2012 kakatiya university

Master's: CIS 2018 Bellevue University.

Contact this candidate