Gopi Krishna Vemula
QA/SDET (Automation Test Engineer)
***************@*****.***
PROFESSIONAL SUMMARY
SDET/Automation Tester with around 9 years of experience in Information Technology with the emphasis on Design, development of Software Quality Assurance/Testing/Automation of Web Based, DevOps Testing of Web Client Server, Cloud (AWS), API, Web services applications on various domains Insurance domains and medical science.
Strong understanding of information technology capabilities and dependencies, including platforms, content management, e-document strategies, and process mapping.
Worked extensively on Agile Projects and hands on experience in attending Sprint Planning, Scrums, Sprint Review, Retrospective, Grooming meetings.
Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project follow the Business Requirements.
Performed Back-End Testing using SQL queries. Worked extensively in writing Complex SQL queries to verify the data from the databases.
Good experience of testing and analyzing databases/data warehouses (ETL) testing, SSIS, Data Stage
Proficiency in Relational Database Management Systems including MS Access, MS SQL, SQL Server.
Wrote complex SQL queries to extract and validate the data from the Facets database for member and claims data.
Created end to end automation solutions for clients as per requirement which involves feasibility study, designing architecture, development, testing, and deployment of automation by using different leading automation technologies like Automation Anywhere and UiPath systems.
Good Knowledge in OOPS (Object Oriented Programming System) concepts i.e., Abstraction, Polymorphism, Encapsulation and Inheritance, Strings, Collections etc.
Expertise in Automation tools such as Selenium Web Driver, Selenium IDE, Selenium Grid, Java, Git Hub, Jenkins (continuous integration-CI), Maven, TestNG, JUnit, Cucumber (BDD/TDD) Protractor and Appium.
Experience in designing, developing, and maintaining Test Automation Frameworks like Data Driven, Keyword Driven, Hybrid and BDD/TDD/ATDD.
Experience in designing and developing the BDD/TDD framework and worked with the scrum master, product owner and users to derive the Scenarios and created features using Gherkin language, Step definitions and cukes test using Cucumber.
Experienced in Java, Spring, Relational Databases, Domain-Driven Design, TDD, and Cloud Native Application Development
Experience on functional aspects, Spring Framework, Spring Boot, Spring Integration.
Developed and executed test cases for SOAP and RESTful web services using SoapUI/Ready API, Postman tools and REST Assured API. Updated WSDL file as needed for Endpoint, Tested request, and response XML. Added Assertions to validate the response xml with database.
Experience in Cross Browser Testing and Parallel Test Execution using Selenium Web Driver, TestNG and Selenium Grid.
Experience in creating page objects by using Page Object Model, developing reusable library functions in java, and using unit testing frameworks like Junit, TestNG.
Tested manually and Automated Hybrid Mobile Application using Appium, C-CARE, Selenium, protractor, JavaScript,Java.
Good Experience in using Configuration management tools like Sub Version (SVN), GitHub, and Build management tools like MAVEN and ANT.
Good Expertise in Schedule jobs via Jenkins (Continuous Delivery) and Continuous Integration for automating the build and deploy processes allowing significant increase in test automation. Monitoring the jobs scheduled jobs.
Experience in developing and understanding of HTML, XMLand good Experience in Java script.
Significant experience in Compatibility Testing, Integration Testing, System Testing, Migration Testing, Regression Testing Smoke Testing and Accessibility Testing etc.
Provided support in the performance testing using JMeter task includes developing test plan, test script and reports.
Hands on experience of testing Power BI reports.
Technical Skills:
Programming/Scripting Languages
Java, C#, VB.NET,Ruby, JavaScript, Typescript.
UI & Functional Automation Tools/ Frameworks
Selenium WebDriver, Appium, Rest-Assured, Rest Client, BDD Cucumber, JUnit, TestNG, KARATEAPI, LoadRunner, JMeter, SoapUI, Postman, Swagger, ES6, Spring Core, Ruby Mine.
Web Technologies
HTML, CSS, Angular, XML, XSLT,JSON.
Databases
MySQL, SQL Server, Oracle, and Cosmos DB.
BI tools
Spreadsheets, Power BI, MS Office Suite, Microsoft Project, Microsoft SharePoint, Office 365.
Build Tools
Ant, Maven, Gradle.
Test Case Management Tools
ALM QC, JIRA Zephyr, Azure ADO.
Bug Tracking Tools
JIRA, Azure ADO.
CICD &Version Control System
SVN, Git, Jenkins, Docker, MS Cloud, Sauce Labs, Azure.
Operating Systems
Windows XP/7/8/10, Mac OS, Android, and IOS.
Professional Experience:
Barclays, New Jersey March 2022 – Present
Sr SDET/QA Automation
Responsibilities
Involvement in Regression testing using Selenium and Creation of automation scripts for web pages.
Design, develop and implement Data driven automation testing frameworks utilizing Java in IntelliJ.
Involvement in developing test plans, test cases and executing test scripts for various scenarios for the module such as submitting application forms for various types of accounts for Existing Customers/ New Customers.
Developed robots using UiPath studio, identifying and debugging the errors using error handlers and participated in online meetings to demonstrate the capabilities of RPA for on-going projects and potential clients
Develop automation test scripts using Java, Cucumber, Splunk, C-CARE, GCP, Kafka, Selenium, Playwright, WebDriver, and Maven prior to agile release.
Using the Karate allows tests to be data-driven easily with support for external data files and JSON, enabling extensive test coverage.
Working Ensure that therapy sessions are structured in a way that aligns with ACBS principles and that there is consistency in the delivery of therapy.
Experience of .NET Core, the cross-platform and open-source version of .NET, provides excellent support for building micro services and cloud-native applications.
Worked with AWS services such as Lambda, Cucumber, Kafka, RDS, EBMS, Protractor, ACBS, SEBT, Cypress, Redshift, EC2, EMR etc.
Design and implement automation frameworks using Appium for mobile app testing.
Tested ETL processes developed for fetching data from oracle database to snowflake environment using SQL Big query stored procedures.
Written automation scripts for creating resources in OpenStack cloud using python and Terraform Modules.
Have used Duplicate and matching rules in Salesforce to improve data quality by removing duplicate data.
Created end to end automation solutions for clients as per requirement which involves feasibility study, designing architecture, development, testing, and deployment of automation by using different leading automation technologies like Automation Anywhere and UiPath systems.
Automated UI test cases by using Selenium Lambda, WebDriver, Splunk, typescript, Playwright, C-CARE, Spring Boot, XPath, integrated with JavaScript.
Using Automation can check that the database schema in Snowflake matches the expected schema, including tables, columns, data types, and constraints.
Deployed Spring Boot based Micro services Docker and Amazon EC2 container using AWS admin console.
Performed all activities at the POS cash counter and prepared reports of daily transactions.
Configured Salesforce mobile application by using the Page Layouts, Compact Layouts, Mobile cards, Quick Actions and developed mobile friendly pages using Visualforce and Lightning Components.
Validate and test data from API using Rest Assured deployed on AWS, GCP and Hana for data validation.
Validated saved model into Pickle format, worked with team to build a web application with flask web framework allow the user to input job information and implement prediction, deployed in GCP as app engines
Validate backend test data using Rest Assured API.
Responsible for Test plans, Apache, Katalon, Type Script, Grafana,Lambda, MacoS, Kafka, EBMS, SEBT, Python, TANF,Java, Karate, Sauce Labs, MDM, SNAP, Protractor, CI/CD, kotlin, JavaScript, ACBS, Camunda, AWS, Spring boot, Jasmine, GCP,Test Scripts, and Test Cases for System Testing.
Worked Karate can be used for testing REST APIs, Grafana, SOAP services, GraphQL, and even web UI automation, providing a comprehensive testing solution.
Created SSAS Cubes (Tabular Models) as the source for Power BI and created various dashboards and visualizations and published it to POWER BI REPORT SERVER.
Make list of new products and send to the engineers to implement the same in POS application.
Validate testing workflows in Ready API as an API testing platform to streamline the workflows.
Worked to develop front end features using Nodes JS and Angular.
Strong JavaScript skills and object oriented design experience, including working knowledge of core libraries and design patterns.
Experience of automated monitoring for Snowflake environments to detect issues like failed queries, long-running processes, and resource utilization spikes. Alerts can be configured for immediate response.
Written automation scripts for creating resources in OpenStack cloud using python and Terraform Modules.
Tested the ETL process of extract files from legacy databases to snowflake environment using SQL queries. Created and executed SQL queries for ETL testing along with testing on databases.
Tested and developed real time tracking of class schedule and multi talent SAAS solutions with responsive UI using Angular JS with Node JS.
Strong experience in Microsoft Business Intelligence stacks (SSRS, HL7, SSAS, SSIS, Power BI
Validate and test data from API using Rest Assured deployed on AWS, GCP and Hana for data validation.
Experience of Playwright supports testing across multiple browsers, including Chromium, Firefox, and WebKit, ensuring compatibility and consistent behavior across different platforms.
Validate test cases using Performance testing using JMeter and perform Security testing.
Working on microservices using Kubernetes or Docker.
Implement and maintain Page Object Model - added and updated new elements as required, create new page objects as required.
Perform mobile testing using Xamarin in IOS devices to monitor the applications and insight of reports.
Analyzed the page source to identify reliable locators for web elements.
Involvement in developing framework and Test Environment Setup for Selenium WebDriver/ Java.
Perform Automation Testing of each Build and then Regression testing on each build using Java and Selenium WebDriver.
Working on data related to performance testing, such as response times and load capacities, can be visualized in Power BI to understand system behavior under various conditions.
Proficient over iOS and Android Mobile Applications testing.
Developing and managing test automation frameworks using Cypress Java script base automation tool.
Used UiPath for scripting and identifying elements in UiPath for automation.
Experience of Playwright provides bindings for several programming languages such as JavaScript, TypeScript, Python, Java, Karate, Lambda, AWS and C#, making it accessible to a wide range of developers.
Use Cucumber & JUnit for testing sections of application submission workflow.
Involved in using Maven build tool to manage framework dependency jar files in POM.xml.
Used Selenium WebDriver for writing test scripts and executing them with existing API using Rest Assured to test Framework.
Performed Compatibility testing of applications for dynamic and static content of browsers using HTML, EBMS, SEBT, DOM, XPath in Selenium.
Wrote Features using Gherkin format and implemented the step definitions using Cucumber for User Acceptance Test (UAT) to implement Serenity BDD.
Environment: Salesforce, Windows, POS, Camunda, Protractor,Q-Meter, GraphQL, EBMS, Grafana,SEBT, Splunk,Lambda, Jira, GCP, typescript, Playwright, ETL, AWS, Gherkin, Spring Boot, Selenium Web Driver, Karate, Python, Jenkins, JMS, Kafka, Post Man, C-CARE, Source Tree, Bit Bucket, Appium, Perfecto, Selenium, API testing, Smoke Testing, Massaging testing, Regression Testing, Manual testing.
Bank of New York, NY, NY Aug 2021 – Feb 2022
Sr SDET/QA Automation
Responsibilities:
Participated in all meetings planned for release and obtain necessary technical requirement. Such meetings include design review, test execution timeline etc.
Performed the role to guide the offshore team by gathering the requirements from the client.
Identified high level scenarios to perform test execution for requirements in current release.
Involved in Automation Framework development from scratch using Selenium WebDriver, typescript, Playwright, TestNG, Lambda, ACBS, Kafka, GraphQL, Karate, Camunda,python, Splunk,Cucumber JVM and Page Object Model in Eclipse.
Working Automation can check that the database schema in Snowflake matches the expected schema, including tables, columns, data types, and constraints.
Working with Power BI, QA teams can analyze defect data to identify high-risk areas, track defect resolution progress, and measure the effectiveness of defect fixes over time.
Followed DevOps continuous integration (CI) tool Jenkins to execute the test scripts periodically on Selenium Grid for different platforms like desktop, tablet and mobile.
Performed Cross browser testing and parallel testing on Chrome, Firefox and Edge using TestNG and Maven on Selenium grid.
Experience of Karate encourages script reusability by allowing the creation of reusable functions and steps, which can be shared across tests.
GCP offers tools like Anthos that enable businesses to manage applications across both on-premises environments and multiple cloud providers, promoting a hybrid and multi-cloud strategy.
Worked with Right Data ETL testing tool to perform automation of testing data and quality checks.
Responsible for writing automated test cases using QTP/UFT.
Created and executed automated test scripts for regression testing using QTP/UFT.
Test Scenarios preparation using QTP.
Experience of Power BI enables the creation of custom dashboards that display key QA metrics, such as defect density, test coverage, and automation progress, tailored to specific stakeholder needs.
Automation Framework implementation for UFT / QTP.
Performed Integration Testing in Vendor Development environment and System Testing in SIT environment and User Acceptance Testing in Pre-Production Environment.
Involved Preparation of Traceability Matrix and mapping the Test Cases with the requirements and
Test Metrics in Quality Center.
Expertise in using Selenium Grid to run test scripts on different platforms and against different browsers in parallel to save time.
Experience of DBT therapists participate in consultation teams to receive support, maintain adherence to DBT principles, and improve their skills.
Using Power BI’s sharing and collaboration features make it easy for QA, development, and business teams to access and review test automation data, fostering better communication and alignment.
Verification and Validation of Software in the simulators and on the hardware controllers (tablet), desktop, web, ACBS, Mobile PDA and TPS and GNSS sensors by updating firmware files.
Experienced in API Testing, automation with RestAssured framework with Java and manual testing with Postman. Proficient in applying object-oriented programming concepts during test case automation.
Reported bugs in Quality Center with server logs information from Web and DB servers.
Independently creating and executing UFT / QTP scripts.
Involved in pilot project for automation using Selenium IDE/RC.
Expertise in grouping of test suites, test cases and test methods for regression and functional testing using TestNG Annotations like Groups, Parameter, Data Provider and Tags.
Utilized Maven to manage dependencies for test execution, plug-ins and created profiles of grouped test cases to run sanity and regression testing.
Tested the mobile applications for Android and IOS using Appium and Xamarin frameworks for automating the test cases.
Integrated Jenkins with version controller (GIT) and scheduled builds to run automatically during a build release by invoking predefined maven commands.
Experience in writing complex XPATH using following and preceding and using functions like contains and not contains.
Good knowledge of Kafka for streaming real-time feeds from external rest applications to Kafka topics.
Automated few applications using Python scripting for Gilead RA medical related projects.
Environment:Java, Selenium WebDriver, ACBS, Protractor, Camunda, EBMS, Protractor, SEBT, typescript, Grafana, Karate, Jasmine, C-CARE, Lambda, Playwright, Cucumber, Ant, Jenkins, Junit, GitHub, Eclipse IDE, Xpath, JSON, XML, Kafka, CSS, HTML, Firebug, Internet Explorer, Chrome, Edge, GraphQL,Python.
Nationwide, Columbus OH Apr 2019 – Jul 2021
SDET/QA Automation
Responsibilities:
Analyzed the system requirements and developed detailed test plans and test cases and provided the documentation. Collaborated with product management teams in an agile environment to develop a comprehensive set of tests for web-based applications.
Experience of Automate the process of refreshing data in Power BI dashboards and reports to ensure they always display the most up-to-date information.
Experience in automating tests for mobile apps using Appium in Selenium using Java.
Involved in performing functional, application, Playwright, integration, system, and regression Testing.
Conducted Functional testing, Regression Testing using selenium with Data-driven framework and Key- Word driven framework.
Created automation test scripts using data Driven framework and Page Factory model to test the web applications using Selenium WebDriver and with JAVA and maven.
Expertise in using Selenium Grid to run test scripts on different platforms and against different browsers in parallel to save time.
Used Jenkins to execute the test scripts periodically on Selenium Grid for different platforms like desktop, tablet and mobile.
Automated the API services using Karate DSL framework for Unit Testing, Integration Testing, and Regression Testing.
Familiarity with ETL Testing and Data Migration w.r.t Database Management and Big Query.
Performed Cross browser testing and Parallel testing on Chrome, Firefox and Safari using TestNG and Maven on Selenium grid.
Strong background in signal processing with emphases on real-time signal processing on embedded DSP processors and embedded Linux systems.
Involved in Selenium web driver test scripts and writing Selenium supporting classes through Java and Python.
Performed Data-driven testing by using JDBC as a data source in SOAP UI and configured SQL queries to fetch data from the Oracle database.
Design, implement, and test C and C++ applications in embedded environments including bare-metal, RTOS, and Linux.
Analyzed software Requirements and Business Requirements documents to get a better understanding of the system. Responsible for Test plans,Karate,UNIX,Test Scripts, and Test Cases for System Testing.
Performed testing on Web Services using WSDL and SOAPUI to check the communication between different services and adding different assertions and automated data driven testing by getting the data from various external sources like excel and database.
Specify, design, implement, test, and support embedded software for products across the range of the portfolio.
Manual Web services testing using Postman Tool, Validated request and response JSON.
Implemented logic towards a robust Rest service testing process and code clean up.
Used Postman &SOAPUI for rest service testing.
Automated REST API’s using Java and Rest Assured java Library which follows the TDD/BDD model and asserted HTTP codes, response data etc.
Environment: Selenium, DevOps, AWS, Java, Camunda, JavaScript, Embedded, Kafka, Karate, Grafana, Jenkins, Git, python, Playwright, typescript, C-CARE, GitHub, SOAP, ETL, REST, SOAP, POSTMAN, Android, Mobile, iOS, Cucumber, BDD, WebDriver, TestNG, MAVEN.
Paymentus, Charlotte, NC Aug 2017 – Mar 2019
SDET/QA Automation
Responsibilities:
Involved in various meetings with Business analysts and developers.
Conducted Functional testing, Regression Testing using selenium with Data-driven framework and Key- Word driven framework.
Participate in embedded system design projects through SDLC, from concept to production.
Used Jenkins to execute the test scripts periodically on Selenium Grid for different platforms like desktop, tablet and mobile.
Created automation test scripts using data Driven framework and Page Factory model to test the web applications using Selenium WebDriver with JAVA and maven.
Expertise in using Selenium Grid to run test scripts on different platforms and against different browsers in parallel to save time.
Experienced with Cross-Browser and Compatibility Testing to test whether the web applications are working as desired in different browsers and environments, Embedded.
Used Jenkins to execute the test scripts periodically on Selenium Grid for different platforms like desktop, tablet and mobile.
Performed Cross browser testing and Parallel testing on Chrome, Firefox and Safari using TestNG and Maven on Selenium grid.
Performed data driven testing by using JDBC as a data source in SOAP UI.
Conducted backend testing using SQL queries to validate data for database and Used SQL queries for retrieving data from database for executing user specific test cases.
Extensively involved with backend testing by writing complex SQL queries.
Executed the automated regression test cases during every release and executed the daily regression test suites.
Experience in hands-on development and troubleshooting on Embedded targets.
Experience in Performance Test solutioning, defining Performance Test Strategies, Approaches, Test Plans and Workload Modeling for various types of Web Applications, Portals, Mobile Apps, Web Services, SPA with Microservices and SOAP & REST APIs.
Involved in debugging of the existing automation script.
Experience working in Agile/ Scrum methodology for SDLC and working on Test management tools like Jira.
Participated in daily Scrum meetings.
Environment: Selenium WebDriver, JavaScript, Java, typescript, Embedded,Restful Web Services, SQL, Quality Center, AGILE, GIT, HTML, XML, JSON, Java Script, CSS, Windows, Jira.
Real Page, Hyderabad, IND Feb 2014 - Jan 2017
Quality Assurance
Responsibilities:
Involved in various meetings with Business analysts and developers.
Conducted Functional testing, Regression Testing using selenium with Data-driven framework and Key- Word driven framework.
Experience of Playwright provides a consistent API for interacting with different browsers.
Created automation test scripts using data Driven framework and Page Factory model to test the web applications using WebDriver with JAVA and maven.
Used Jenkins to execute the test scripts periodically on different platforms like desktop, tablet and mobile.
Performed data driven testing by using JDBC as a data source in SOAP UI.
Conducted backend testing using SQL queries to validate data for database and Used SQL queries for retrieving data from database for executing user specific test cases.
Experience of Playwright can run tests in headless mode, which means the browsers run without a graphical user interface. This is useful for automated testing environments and CI/CD pipelines.
Extensively involved with backend testing by writing complex SQL queries.
Executed the automated regression test cases during every release and executed the daily regression test suites.
Experience with Mobile Testing and Automation using Java Appium and Selenium.
Experience of Playwright supports multiple web browsers, including Chromium, Firefox, and WebKit. This allows developers to write browser automation scripts that can be executed across different browsers.
Involved in debugging of the existing automation script.
Experience working in Agile/ Scrum methodology for SDLC and working on Test management tools like Jira.
Participated in daily Scrum meetings.
Environment: Java, Restful Web Services, typescript, SQL, Quality Center, Playwright, AGILE, GIT, HTML, XML, JSON, Java Script, CSS, Windows, Jira.
Education: Bachelor’s in computer science --2014