Mohit Balwwani

Software Development Engineer in Test (SDET)

E-mail: ad0v37@r.postjobfree.com Ph:+1-619-***-****

SUMMARY:

●SDET with overall 8+ years of Total IT experience in.Net, Java Development, Quality Assurance in Manual Testing, Automated Testing, Database Testing on Web-based applications and Client/Server based applications.

●Exposure to all stages of SDLC (Software Development Life Cycle), Software Test Life Cycle (STLC), and software development methodologies such as Agile, V Model, and Waterfall.

●Experience in developing the Automation framework using Core java programming using OOPS concepts, Selenium, Java, Junit, TestNG, Eclipse, and Maven.

●Expertise in both manual and automation testing of Web services SOAP and RESTful.

●Designed and developed Automation Frameworks like Keyword Driven, Hybrid is driven, and BDD/TDD.

●Experience in design and development of BDD framework from the scratch by writing Gherkin Features-Scenarios using Spec flow and Cucumber.

●Worked on front end web application development that involved HTML, DHTML, XHTML, XML, JavaScript and CSS.

●Experience in Cross Browser testing and Parallel Test Execution using Selenium WebDriver, TestNG and Selenium Grid.

●Expertise in Design and Development of User Interfaces, User Controls, and Custom Controls using ASP.NET and C#.NET.

●Experience in Building Microsoft.Net/C# automation Scripts by using Selenium, MS visual Studio, NUNIT, Spec flow, Coded UI, Azure, and good expertise in using Annotations.

●Experienced in developing and consuming Web services (Restful)/ WCF.

●Have good Knowledge in developing, Publishing, and implementing test plans for commercial off-the-shelf COTS applications.

●Experience in building Continuous Integration/Delivery automation solutions for each product/project via TFS/Jenkins.

●Good Expertise in Scheduling jobs via Jenkins (Continuous Delivery) and Continuous Integration for automating the build and deploy processes allowing a significant increase in test automation and monitoring scheduled jobs.

●Good experience in Web Services testing using SOAPUI, XML, & WSDL. Providing required input data to request XML & get the required data from response XML & use the response data from another request XML using SOAPUI.

●Reviewing the code using FxCop, style cop, and Code flow tool.

●Proficient in utilizing Agile Scrum methodology to deliver comprehensive and effective software testing

●Responsible for developing the BDD/ATDD framework by using the Cucumber and added Scenarios in features files, Step Definitions

●Good Experience in unit testing/White box testing the code developed by the developers

●Experience in developing and understanding HTML, XML, and CSS.

●Worked extensively on Agile Projects and hands-on experience in creating a task for the sprint in Rally and attended Sprint Planning, Scrums, and Sprint Review meetings.

●Experience in working with Test Management/Bug Tracking tools like HP ALM/Quality Center/Rally/JIRA, to track test execution progress and prioritize bug fixes.

●Worked on SQL Server database by writing different kinds of queries like Stored Procedures, Triggers, Views, Tables, Functions, and Exception Handling in order to perform valid operations.

●Knowledge of networking protocols (TCP/IP Protocol suite) such as TCP, UDP, FTP, SSL, and HTTP.

●Expertise in writing SQL Queries, SQL *PLUS, PLSQL stored procedures for databases like Oracle, MySQL, and DB2 on UNIX as well as Windows platforms.

●Worked on all levels & types of testing like Smoke, Sanity, Unit, Integration, System, Acceptance, Retesting, Regression, Ad-Hoc, Black-Box, White-Box Testing, Grey-Box Testing, Verification, Validation, and Functional testing.

●Testing experience on ETL process for various data loading scenarios.

●Knowledge in creating ETL test data for all ETL mapping rules to test the functionality of the ETL process based on the mapping document.

●Tested the API’s as well as validated the data returned through web services responses using Assertions such as valid HTTP Status Codes, Script Assertions, Contains, XPath, XQuery.c

●Proficient in performing different kinds of testing like Smoke, Sanity, Functional, GUI, Backend, Parallel Testing, Integration Testing, Regression Testing & UAT.

●Experience in defect tracking systems and bug life cycle using Test Director, HP Quality Center.

●Strong exposure testing applications on different browsers Chrome, Firefox, Safari 3x.

●Experienced in facilitating User Acceptance Testing for go-live.

●Good Analytical and Communication Skills and ability to work independently with minimal supervision and perform as part of a team. Ability to work under competing deadlines.

CERTIFICATIONS:

Certified in Foundation Level - International Software Testing Qualifications Board (ISTQB)

Oracle java certified Professional

Microsoft Certified in Azure Fundamentals (AZ-900)

Microsoft Certified in Azure Administrator Associate (AZ-104)

TECHNICAL SKILLS:

Programming Languages

C, C++, C#(.Net), Java, Python

Frontend Technologies

HTML5, CSS3, JavaScript, AngularJS, Twitter Bootstrap

Microsoft Technologies

Asp.Net, MVC, Ado.Net, Entity Framework, Web Forms, Web API, Java, Silver light

Databases

Cosmos db, SQL Server, Oracle, MS Access, T-SQL, LINQ to SQL, AS400(IBM)

Automation Tools and Languages

Selenium IDE, WebDriver, Grid, RC, Nunit, MSTest, Coded UI, ETL

Spec Flow, Groovy Scripting, Gherkin (Cucumber), QTP, Clear Quest, Appium, Protractor, behave

Web Services& Database Testing Tools

SOAPUI (SOAP, REST), Ready API, Rest Client (Firefox add on),

SQL Server, Postman, Insomnia, Swagger.

Automation Frameworks

BDD/ATDD (Spec Flow), TDD, Data-Driven, Keyword, Hybrid is driven

Project Management / Defect Tracking Tools

JIRA, JIRA X-Ray, Rally (Central Agile), HP Quality Centre (ALM), TFS(ALM), Bugzilla

Methodologies

Agile, Scrum, Waterfall, and V-Model

IDE

Visual Studio, Eclipse, Rational Rose, UML, PyCharm

Version Controller

Team Foundation Server (TFS), GitHub, SVN, SourceTree, GitHub Desktop.

EDUCATION:

Bachelor’s in computer science from Osmania University, Hyderabad, 2015

Master’s in computer information system from CALMU, San Diego, 2019.

PROFESSIONAL EXPERIENCE:

General Motors, MI

Role: Automation Engineer June 2022 - Present

Roles & Responsibilities

●Creating automation test scripts using PYTHON and Behave for the automating the rest API functional testing.

●Automated Web Services/REST Services using Request Library and Python in PyCharm IDE to validate the HTTP status codes and validating the responses of APIs with conditional assertions.

●Worked on different HTTP methods like get, put, post, and delete and validating them with Json and String methods, validating key values for functional testing.

●Developed the Automation Test Scripts in behave using Python based on the BDD approach for reusability and creating feature files and step definitions.

●Using python libraries like requests, behave, pandas, openpyxl, NumPy, parse, azure-cosmos, allure-behave.

●Testing the API’s and validating the data returned through web services response using Assertions such as valid HTTP Status Codes, required JSON Object and validating the data in Azure Cosmos db using Cosmos DB Queries.

●Used Azure services like cosmos dB to upsert the data in the container/tables and query the data from those container/tables using cosmos queries.

●Used appInsights to check the logs manually for the cloud event that are sent from Service Bus Explorer tool and also from the scripts.

●Used EventHub to verify the events that we sent from our python scripts.

●Coordinated with the QA Testers to facilitate the gathering and documenting of test automation objectives and requirements for input into the Automation Strategy and Design approach.

●Responsible for the Build Deployments in Jenkins (CI/CD) for the project.

●Used GitHub, a source code management tool for code re-usage, high portability extending the scope of Automation Testing.

●For In-Vehicle Automation we used TestApp to send the Cloud event from the Device to the Backoffice and analyze the logs using Android Studio.

●For In-Vehicle Automation we use Simulation Proxy tool which acts as a proxy between Android IDE and Python scripts.

●Responsible for developing and executing automation test plans and test cases for REST API testing.

●Worked with programmers to test the daily builds and reported bugs.

●Collaborated with development on test automation efforts to ensure that development supports the testing solutions.

●Participating in Scrum activities like refinements, retrospective, daily Scrums.

●Responsible to review, update and give feedback on the scripts which were written by other automation testers.

●Mapping test cases with the requirement using the Requirement Traceability Matrix

●Using Azure for accessing cosmos database (NO SQL)

●Written and executed SQL queries to validate the data, manually and automatically in scripts.

●Using reporting tools like Allure.

●Using behave command line parameters for debugging the scripts.

●In behave we are using environment file, helper file, and before and after functions.

Environment: PYTHON, PyCharm, PyCharm IDE: behave framework, BDD, Jenkins (CI/CD), Azure Cosmos db, Swagger, Jira-Xray, Confluence, Git - Version Control, Rest API, SharePoint, Microsoft Excel, Microsoft Teams, Gherkin (Cucumber),

Equifax, Atlanta, GA. Nov 2020 – June 2022

Role: SDET

Roles & Responsibilities

●Creating automation test scripts using JAVA and Selenium Web Driver for the functional test cases.

●Creating a request base class and a response base class for API testing using Rest Assured.

●Coordinated with the QA Testers to facilitate the gathering and documenting of test automation objectives and requirements for input into the Automation Strategy and Design approach.

●Integrated Maven scripts (Smoke and Regression) with the Jenkins (CI/CD) from Team Foundation Server (TFS) using Groovy Script.

●Responsible for the Build Deployments in Jenkins (CI/CD) for the project.

●Created, implemented, and maintained Page Objects (POM) for each Webpage.

●Developed the Automation Test Scripts in Selenium WebDriver using Java based on the design pattern Page Object Model for reusability.

●Implemented and configured TestNG, Selenium web driver from Maven packages as build for adding all the dependencies. Developed Test Cases using Data-Driven, Hybrid, Modular, and Keyword Driven frameworks in WebDriver.

●Prepared XML and Excel files for collection of data and Element Locators using object repository,

used this in the test suite with the help of APACHE POI library files.

●Created Maven Project using Maven build automation tool to create dependencies like wars, jars, and usage of plugins for invoking XML files.

●Triggered POM.XML files using Jenkins, Continuous Integration Tool to generate reports and to trigger periodically.

●Used GitHub, a source code management tool for code re-usage, high portability extending the scope of Automation Testing.

●Responsible for developing and executing manual test plans and test cases for Web Services SOAP and REST API testing.

●Performed Web Services automation testing using SOAPUI pro.

●Validated Web Services SOAP request and response XML and RESTful Service Calls using SOAPUI tool.

●Validated WSDL Files, XML Schema, and Web Services End Points for each environment.

●Added assertions in response to XML to validate the output of web service calls.

●Utilized multiple validation rules, property transfers, Data Gen, etc. in the SOAPUI tool to validate requests and responses of Web Services.

●Developed Groovy Script in SOAPUI tool to connect to a database for automation of Web Services.

●Worked with programmers to test the daily builds and reported bugs.

●Collaborated with development on test automation efforts to ensure that development supports the testing solutions.

●Performed functional, compatibility testing on different browsers like IE, Firefox & Chrome.

●Responsible to review, update and give feedback on the scripts which were written by other automation testers.

●Mapping test cases with the requirement using the Requirement Traceability Matrix

●Used SQLServer Management studios 2014 as a database to store and retrieve the data that comes from UI.

●Written and executed SQL queries (stored procedures) to validate the data.

●Used TFS (Team Foundation Server) as an ALM tool.

Environment: Eclipse, JAVA, TFS, WSDL, XML, Selenium Web Driver, BDD/ATDD, SQL Server, TestNG, MAVEN, Jenkins, Jmeter, HTML, SOAPUI Pro, SharePoint, Microsoft Excel.

Fannie Mae – Reston, VA July 2019 - Oct 2020

Role: Automation Engineer

Roles &Responsibilities

●Responsible for going through the User Stories and creating Test Cases based on the mock up’s provided in User Stories.

●Involved in documenting the Test Plan, Test Cases, Traceability Matrix, and defect reports Interact with project management, development teams, and support team to develop a strong understanding of the project and testing objectives.

●Participate in reviews and provide feedback on Requirements, Design Documents and Specifications, and Project Plans and Initiatives from a Quality Engineering and testing perspective.

●Designed and Developed the Automation Test Scripts using Selenium WebDriver using Java for functional test cases.

●Involved in writing, updating, and maintaining the test documents for various stages of testing for reference and auditing purposes.

●Used Boundary Value Analysis and Equivalence partitioning techniques to validate the test values.

●Implemented Regression and Smoke test execution as a separate step of the deployment process by using WebDriver.

●Written various Features, Scenarios, and Scenario Outline with Examples, Scope Bindings, Dynamic Tables, and Hooks in Gherkin language for developing the BDD framework.

●Created, implemented, and maintained Page Objects (POM) for each Webpage.

●Involved in Hybrid Test framework to achieve Regression Testing and developed packages for the Driver scripts, Page Objects, Reusable Libraries, HTML reports, and Log files.

●Performed Data Driven Testing (DDT) using Scenario outline and examples.

●Implemented logic to read data from Excel to achieve functional testing with different data.

●Performed mouse actions using Selenium Actions API. Implemented web element locators using Selenium WebDriver - By ID, Class, Name, CSS Selector, Xpath, and Link.

●Documented all the scenarios of the test cases.

●Used Jenkins for continuous integration and delivery (CI/CD) in order to execute them automatically after every successful deployment.

●Responsible for creating Resource files to store the Constants.

●Making sure the resolved bugs are retested and closed if needed.

●Involved in testing the Web Services like SOAP by using a tool SOAPUI

●Created projects, Test Suites, Test Cases, and Test Steps in SOAP UI Tools and Validated the Response XML file.

●Inserted Assertions like XPATH to validate the data against the database data in the response XML.

●Automated one of the applications developed in AngularJS framework by using Protractor, Jasmine, and JavaScript with describing, it and Expect

●Used different kinds of Assertions and Attributes for validating the test cases.

●Responsible for writing the SQL Queries using Joins, Stored Procedure to retrieve the data

●Updating the test plan document for every Sprint meeting.

●Developed SQL queries to validate the data integrity of the database.

●Performed parallel execution of test cases using Selenium Grid.

●Written different kinds of SQL queries like creation, updates, inserts, deletion, joins, etc., in SQL Server Management Studios 2014 to perform Backend testing of the application for validating the saved data that comes from Frontend.

Environment: Java, Eclipse, Selenium Web Driver, Selenium Grid, JIRA, Data-Driven Behavioral Driven Development (BDD), Page Object Model (POM), Gherkin (Cucumber), Junit, Jenkins, TFS, VSTS, Appium, SQL Server Management Studio, Chrome, Firefox, Internet Explorer HTML5, CSS3, Excel.

Care First BCBS, Washington DC Aug 2018 – June 2019

Sr. Automation Engineer in Test (Java and Selenium)

Roles & Responsibilities

Coordinated with the QA Testers to facilitate the gathering and documenting of test automation objectives and requirements for input into Automation Strategy and Design approach

Designed and developed test automation artifacts (scripts, functions, scenarios, processes) for simple to complex automated testing situations using various tools.

Involved with Test Coverage Metrics and Defect metrics such as Defect Density, Delivered Defect Density, Defects by Severity, Number of Defects, and Defects per build, Defect Fix Rate, Test Case Utility, Test Effort and various other measurements.

Coordinated with other team members to test end-to-end test scenarios.

Generated Test Plan, Test Scenarios, Test Cases and Test Data and executed test scripts to test the functionality of the application and regression testing.

Creating test scripts using JAVA and Selenium Web Driver and TestNG framework for the functional test cases.

Performed data driven testing by using JDBC and Groovy script as a data source in SOAP UI and configured SQL queries to fetch data from the Oracle database.

Developed and included packages for the Driver scripts, Page Objects, Reusable Libraries, HTML reports and Log files.

For Continuous integrations and delivery of the automation scripts used SVN

Involved in unit testing using TestNG framework and worked very closely with the developers.

Involved in testing the Web Services like SOAP, REST by using a tool SOAPUI.

Mapping test cases with the requirement using Requirement Traceability Matrix

Used JIRA as a bug tracking, and project management software.

Developed SQL queries to validate the data integrity of the database.

Tested the mobile application for UAT, usability, performance, compatibility and load testing for iOS and Android devices.

Created custom Appium framework.

Preparation of Daily and weekly Project Status Reports and Documentation of results of test execution. And Shared Daily Status Reports with all the team members, Team Leads, Managers and Clients.

Environment: Eclipse, JAVA, SVN, Selenium Web Driver, BDD/ATDD, Selenium Support SQL Server,

Test NG, MAVEN, Wiremock, UAT, Jenkins, Jira, HTML, Microsoft Excel, Protractor, Appium.

Data Point Info Solutions Pvt. Ltd, India July 2016– Dec 2017

Role: Developer

Roles & Responsibilities

●Participated in Requirement Analysis, Business Analysis, Design Analysis, and Gap Analysis reviews.

●Used the iterative incremental framework Scrum with Agile Software Development.

●Designed and developed base classes, framework classes, and common re-usable components.

●Involved in re-factoring the existing components to meet the current application requirements.

●Developed interactive and user-friendly web pages using JSP, CSS, HTML, JavaScript

●Used various Java and J2EE APIs including JDBC, XML, Servlets, JSP, and JavaBeans, Spring Framework.

●Developed modules using Spring Framework for Dependency injection through configuration files and ease the integration of different frameworks.

●Wrote Core Java classes, JSP, and HTML files

●Created test plans for the QA team

●Implemented RDBMS to add the additional condition for the system to support a tabular structure for the data with enforced relationships between the tables.

●Worked very closely with Product Owner, Customers, and Project team members in analyzing the User stories and acceptance criteria.

●Involved in Updating Test plans, Writing Test Cases, and Executing Test cases. Used Quality Center to write Test cases.

●Created a Traceability matrix between requirements and test cases.

●Conducted Integration, System, Functional, GUI, Regression, Smoke, Database, Integrity, User-Acceptance (UAT), and Performance testing.

●Performed API Level testing for web services, enhanced the Test harness and developed many Test suites using XML.

●Involved in Smoke testing, black-box testing, white-box, Integration testing, Database testing, regression testing, and GUI software testing.

●Involved in architecture skills from the scratch implementation of BDD framework, moved entire framework from hybrid to BDD by using POM, and creating Feature files, Step definitions, and Runner class. Using reports analyzed step by step fail and pass criteria.

●Developed BDD tests using Cucumber by writing behavior and step definitions & developed required Selenium support code in Java for Cucumber.

●Worked on Selenium GUI Object/element verification is done through XPath, CSS Locators.

● Used to identify object locators and create X-path using Firebug and had good knowledge of Page factory and POM in selenium, Worked with Log4J, Apache POI Library, and J-unit.

●Automated Web Services using Rest Assured using Java in eclipse.

●Used Hybrid, Keyword/Data Driven Framework and extracted data from external Excel files using Apache POI and loaded it into the variables in the scripted code.

●Performed end-to-end testing framework for AngularJS applications using Protractor, which works as a solution integrator.

●Here, Protractor uses WebDriver JS which is based on Selenium.

●Designed and developed tests for Mobile App Testing in the Android Platform using Appium

●Executed Test Scenarios using 3rd Party Emulators for Android OS and Simulators for IOS testing.

●Tested web services by generating XML, SOAPUI Requests and validated the corresponding XML, SOAPUI Responses.

●Automated Restful services using Rest Assured API using java by following the TDD/BDD framework model.

●Used GIT to re-modify files and for software development.

●Involved in setting up continuous integration system using Jenkins and working knowledge with cloud-based code repository systems like GitHub.

●Integrated with Continuous Integration tools Jenkins for running tests on a nightly basis automatically.

●Worked effectively with Developers, AGILE Team, and Project Management to achieve Selenium automation, high quality, release deadlines, and QA processes improvements.

Environment: Java, J2EE, JSP, Servlets, JavaScript, TestNG, Maven, Jenkins, SOAP UI, Rest Assured, HTTP Client, HTML, XML, XPath, JIRA, GIT, JavaScript, Hibernate, Oracle, Eclipse, Cucumber, Selenium WebDriver & Protractor.

WIPRO, India Mar 2015- Jun 2016

Role: Jr. Java Developer

Responsibilities:

●Involved in the Preparation of Traceability Matrix and mapping the Test Cases with the requirements and Test Metrics in Quality Center.

●Involved in Requirement gathering, Analysis, and Design using UML and OOAD.

●Involved in the development of applications using struts, RAD, and Oracle databases.

●Developed user interface using HTML, CSS, JSPs, and AJAX.

●Client-side validation using JavaScript and jQuery.

●Designed the Application using Model View Controller Architecture.

●Developed different modules using J2EE (Servlets, JSP, JDBC, JNDI).

●Integrated the Application with Database using Hibernate.

●Communicated between different applications using JMS.

●Used JNDI for registering and locating Java objects.

●Interacted with backend Oracle and wrote stored procedures, functions, and cursors for deleting and inserting using PL/SQL.

●Deployed the Application in Web Logic App Server.

●Developed test cases and performed unit testing using JUnit framework.

●Worked on production issues.

●Interacted with the Users and Documented the Application.

Environment: Java, Web Logic App Server, Struts, JDBC, JNDI, JSP, JMS, HTML, AWS, XML/XSL/XSLT, J2EE, PL/SQL, SQL, Oracle 9i, JUnit, Windows.

Contact this candidate