Gaurav Agarwal
Cell# 510-***-****
Email ***********@*******.***
Summary:
·I am a dedicated individual with strong technical knowledge. I believe in teamwork and enjoy quality assurance of the Software.
Experience in performing Backend, Front-end, Regression, Functional, System, Black box, Integration, end-to-end and User Acceptance Testing.
·Created and managed test data requests for platform teams to support development and QA testing.
·Tracked defects and logged them by severity and root cause in defect tracking tool.
·Defined and tracked quality assurance test metrics and report on outcomes to management.
·Participated in defect review meetings and prioritized defect remediation work.
·Developed web applications using Java/JSP, JavaScript, VBscript
·Conversant with Software Development Life Cycle, Software Test Life Cycle and Software Test Methodologies from project definition to post-deployment along with the QA processes.
·Experience in middleware (web services), API and database applications testing
Education/Certification:
1.Sun Certified Programmer (SCJP) for Java 2 Platform 1.5
2.California State University, Hayward Bachelor of Science in Computer Information System
3.University of California, Santa Cruz Extension, Network Management System
4.Advanced Object-Oriented Programming
Technical Skills:
Operating Systems: Windows 95/98/2000, UNIX, LINUX
Languages: C/C++/C#, Java, Node.js, SQL, PYTHON, PERL, JSP, ASP, Java Script
Software: Silk Test 5.0.3, Silk Performer, Selenium, QA Partner, RESTful API SQL PLUS, Tom Cat, Jun
Platforms: .NET, Java
Test Tool UI Automator, Android Studio
Relevant Experience:
Sr. Software Test Engineer
Cox Automotive Inc.
March 2022 – Present
Worked on Python Open stack API's, used Python scripts to update content in the database and manipulate files.
Used Test driven approach for developing the application and implemented the unit tests using Python Unit test framework.
Resolved automation challenges related to test data setup and execution against functionality
Built automated Smoke and Regression test framework using Python and Selenium
Integrated automated regression test runs with Git Hub action that can be triggered as frequently as required
Tested applications/APIs built on AWS
Automated test code in Java using XCI and Ui Automator test framework. Fixed existing tests and creating new scripts
Develop framework using page object model, data driven approach and Keyword driven approach.
Written Integration test cases for Restful API.
Involved in Backend Database testing in SQL Server using SQL.
Independent Consultant
Automation Consultant Aug 2019 – Jan 2021
Designs, develops framework for Selenium, Java and Junit.
Configured Continuous Integration environment, using Jenkins to kickoff daily builds and automation suites Jenkins, Maven and GitHub
Designs, develops framework for REST/HTTP, SOAP APIs, including JSON data formats and API versioning strategy
Developed and executed SQL queries to verify the proper insertion, deletion and updates into the Oracle supporting tables and cubes
Cavrin System
Lead Automation Engineer JULY 2018- JUNE2019
Responsibilities:
·Created and maintained cloud automation framework in python
·Automated cloud resources for AWS, GCP and AZURE
·Build web service framework using Junit, Java, Maven, Rest Assured, HTTP Client, Json-Simple
·Build framework using Selenium, Java, Junit
Rocket Lawyer
Sr. Quality Engineer 10/2016- 07/2017
Responsibilities:
Created BDD Framework using WebDriver, Java, Junit and cucumber
Used Cucumber to write features and scenarios Scripts
Triggered the automation jobs using Jenkins to get the cucumber JSON reports
Build web service framework using Junit, Java, Maven, Rest Assured, HTTP Client, Json-Simple
Automated the current sprint stories and backlog stories.
Framework for various services Billing, Payments, creating document, updating document, Deleting Document and promotions.
Create Sql scripts to verify correct information that was populating in DB.
Used Postman and swagger for testing Rest API.
Used Different Design Patterns in Creating Harness in both UI and rest API.
Sony Networks, Sunnyvale, CA
Sr. Quality Engineer 2015 – 2016
Responsibilities:
Created Framework using Selenium WebDriver and Python
Develop TestNG Test Cases for REST web service Java API.
Hewlett Packard, Sunnyvale, CA
Sr. Quality Engineer 10/2011- 7/2015
Responsibilities:
Develop integration test using robot framework with python
Used Jenkins to make test part of CI
Develop test for SOA using python libraries
Created Framework using Selenium WebDriver Java TestNG and Maven
Scrum master
Developed forms to validate data from the user in HTML and JavaScript
Develop framework using page object model, data driven approach and Keyword driven approach.
Written Integration test cases for Restful API.
Involved in Backend Database testing in SQL Server using SQL.
Create and execute End to End Use Cases for User Acceptance Testing
Tested Web Services Using SOAP UI
MobiTV, Emeryville, California
Sr.Quality Engineer 02/2011 to 11/2011
Responsibilities:
Develop unit and integration test using Junit
Prepared Test Plan, Test Design, Test Script and Execution of the testing process.
Created forms to collect and validate data from the user in HTML and JavaScript.
Participated in developing and testing intranet web applications using JSP, JavaScript and CSS.
Automated test data creation using SQL Scripts
SMARTTURN, San Francisco, CA
Sr. Quality Assurance Engineer 07/2008 to 10/2010
Responsibilities:
Tested web services using SOAP scope
Created test scripts for functional and load testing
Coordinate efforts between product development teams and offshore enterprise test team
Scripted and executed automated tests using Perl
Developed Java based testing framework using Junit
Automated test using selenium rc and java
Managed defects using Bugzilla
Ecast
Sr. Quality Assurance Engineer 12/2006 to 06/2008
Responsibilities:
Tested Application build on Java Script and JSP
Implemented applications in JavaScript.
Performed client-side validations using JavaScript.
·Created Test plan and wrote edge test cases for new features
·Write Sql test scripts for data verification
·Verified new functionality using java and perl scripts
·Reported and tracked bugs found during functional testing using bugzilla
Moody's
Sr. Quality Assurance Engineer/SW Developer 02/2004 to 06/2006
Responsibilities:
·Shell scripting and SQL scripting to support DB verification on various databases Tested SQL Queries using SQL Query Analyzer to track down SQL code errors, to study table relationships, and to select appropriate test data Wrote SQL Queries to test Data and to find Tables & Columns
·Experience in implementing applications in JavaScript.
·Created various web page layouts using HTML.
·Designed, developed and updated User Interface Web Forms using CSS and JavaScript.
·Performed client-side validations using JavaScript.
·Collected business needs from client users.
·Verified SQL background processes were running as expected by using Enterprise Manager
·Used SQL Profiler, to check the Stored Procedures or Queries
·Tested Application built on .Net and C# platform running on Window 2000 Ensured data exchange on web services platform between MoodyÆs application and client application
·Validate application on different language packs to ensure localization and internalization
Verity Inc
Quality Assurance Engineer 01/2001 to 09/2003
Responsibilities:
·Implemented and developed Quality Assurance methods and procedures Developed test plans and test cases for functional, system and regression testing
·Reported and tracked bugs found during load and function testing
·Configured Tom Cat, Apache and other web server for stress testing Tested data access software in Java, XML, and SQL utilizing black box and white box testing methods
·Developed, executed and maintained automated test scripts using Silk Test and Silk Performer
·Worked with Customer Support and Developers to resolve customer issues on installation, integration and custom development.
·Experienced with installing and configuring J2EE Application Servers, Web
·Servers and deploying J2EE applications
·Ensured software installation and deployment on Unix, Linux and Windows operating system.
·Involved in entire development cycle of E-commerce Application and Propel Data Tier
·Generated benchmark numbers with Silk performer and Perl
·Performed black box testing of E-commerce software applications in Java and XML Quality Assurance Engineer
Compuware Corporation
Engineer 10/1999 to 09/2000
·Developed test scripts with SQL
·Tested E-Commerce software applications in ASP, COM and Java Participated in design phase of new products, to improve customer satisfaction Developed test plans and test scripts for functional and regression testing
·Reported and tracked errors found during functional and regression testing
·Developed, executed and maintained automated test scripts with QA Partner