ABHISHEK BANSAL
adhtzj@r.postjobfree.com
PROFESSIONAL SUMMARY:
Over 6 years of involvement in Programming Quality Confirmation and QA usage.
Strong experience in Manual, Automation and Performance Testing of client Server and Web based Applications.
Knowledge of oracle financials.
Experience in performing System Integration testing, Regression testing, Performance testing, Load testing and coordinating User Acceptance Testing
Experience in all phases of Software Testing Life Cycle (STLC), Software Development Life Cycle (SDLC), Bug life Cycle and Methods like Waterfall and Agile.
Designed and Developed Automation test scripts in Java implementing test in selenium Web Driver
Experience with open source tools Selenium (Selenium IDE, Selenium RC, Web Driver)
Well versed with Java Testing Frameworks like Test NG and JUnit 3, JUnit4
Extensively strong on databases including Oracle 12c/11g, MSSQL Server2014/2012/2008R2 and IBM DB2, Teradata 13.0
Expertise in Selenium automation using Selenium WebDriver, Selenium Grid, JAVA, JUnit& Maven.
Executed automation scripts on different browsers/environments & reported defects/results to the team.
Proven ability in developing BDD scripts with Cucumber and writing step definitions for behavior.
Experience in Analysis, Design, Development, Implementation, Testing, and Production & Maintenance Methods using Waterfall, RUP, CMM, and Agile/SCRUM.
Expertise in working with the defect tracking tools like JIRA, BUGZILLA, HP/ALM quality centre.
Experienced in Selenium Grid to execute tests on multiple systems to achieve parallel execution.
Created Customs functions in Java/Junit code to achieve code reusability.
Developed and maintained Test Plans, Test Cases, Test Procedures and Test Scripts for manual and automated testing.
Experienced in reviewing Project Requirements (BRS), design documents and business documents. Experienced in developing Automation Framework like Data driven, Keyword driven and Hybrid using QTP.
Experienced in performing manual testing applying Functional, Smoke, Regression, GUI and UAT testing approaches.
Experienced in developing and executing automation Regression testing and System testing using HP UFT/QTP and ALM/Quality Center.
Expertise to work with UI and API testing with REST and worked with the API testing tools like Soap UI and http Master as per the system requirement.
Strong exposure testing applications on different browsers like IE, Firefox, and Chrome.
Expertise in Problem solving and Defect Tracking Tools like Quality Center, Bugzilla and JIRA.
EDUCATION:
Master of Science, University of Texas, Dallas, TX, USA – 2018
B.S. in Electronics and Communications Engineering, LNMIIT, Jaipur, Rajasthan, India – 2012
TECHNICAL SKILLS:
Programming Languages
Java, SQL, JavaScript, Python
Database Systems
MySQL, Oracle 12c/11g, MS SQL Server
Web Designing
HTML, XML, JavaScript, CSS, JSON
Bug Tracking tools
Quality Center, JIRA and Bugzilla
Testing Tools
Mercury QTP, Selenium, Web driver, SOAPUI, REST Client, JMeter and Load Runner, Python/Java/Selenium API JMeter, Mobile testing (Appium), Manual/Automation
Web Technologies
Java, HTML, Java Script, CSS, Web Services, SOAP, REST, WSDL
IDE Framework
Eclipse, IntelliJ, TestNG
Application Server
Weblogic, JBoss, Tomcat
Operating System
Windows, Linux, Mac
Build Tools
Ant, Maven, Jenkins
Methodologies
Waterfall, Agile, Scrum
Other Skills
Excel Macros, Shell Scripting,
PROFESSIONAL EXPERIENCE:
Client: CVS Health- Woonsocket, RI Apr 2020 -Aug 2020
QA Analyst-Manual/Automation
Roles &Responsibilities:
Manual testing (Tc dev and exec) on tool HP ALM
Azure DevOps Tracking
Experience testing RESTful web API
Experience testing an ERP, CRM/development platform
Automation experience using Selenium
Experience testing Mobile applications
Experience with API testing using Postman
Strong working knowledge of ASP.NET, VB.NET, C#
Strong command of the ASP.NET Page, MVC, Web API, WCF services and Control models and lifecycles.
Good working knowledge of DHTML related technologies including JavaScript, DOM, CSS, and jQuery/AJAX. Experience with Microsoft SQL, stored procedures and data modeling.
Experienced testing .NET projects
Well versed in creating, importing and running test cases in TFS.
Defecting logging on JIRA tool
Knowledge of SQL, Toad, and Unix commands
Running PL/SQL queries for Database Upgrade Testing
Validating production scenarios
Raising incidents/defects via Team Track Tool
Regression testing for new releases
Batch processing with batch scheduling tool through (Control M)
Hands on experience test planning, automation and test execution
In-depth knowledge of preparing test documentation: Test Plans, Test Scenarios, Test Case, Test Results and Test Summary reports
Experience with Selenium Automation
Experience with Rally tool
Experience automating complex functional and regression test scenarios
Experience with Defect Workflow, Waterfall and Scrum/Agile methodology experience with API testing with SOAP UI
Intermediate level SQL skills.
Client: BCBS- Chattanooga, TN Jul 2018 to Mar 2020
QA Analyst- Manual/Automation
Roles &Responsibilities:
Understand the business requirement and technical specification documents of the system.
Reviewed change request documents and defect description and attended meetings to document the required changes.
Developing test cases, test procedures and test data from requirement document.
Involved in test plan and test case review meetings.
Created & Maintained Automation Selenium Automation Scripts for the Scrum Stories.
Used TestNG to create the Test Suites and to execute all the test scripts.
Tested Enterprise SOAP and Restful Web Services using SOAP UI tool.
Involved in Design and Development of hybrid automation framework using Selenium.
Used Selenium WebDriver for creating scripts using Java/JUnit.
Used Quality Center (QC) to report the system testing defects to the development team.
Performed Smoke, System testing, Integration Testing, Regression testing, User acceptance testing and Database testing.
Used Selenium Grid to execute tests on multiple systems to achieve parallel execution.
Extensively used SQL query statements to verify the data integrity and validation between the front-end values with the backend database values of the application.
Prepared Test cases, procedures, Bug Tracking, Logging and reporting bugs using Quality center.
Experience developing a Comprehensive Test Strategy inclusive of all testing activities
Updating status report daily basis and weekly basis by conducting meetings with QA team.
Involved in writing of modification reports for errors identified in testing and clearly communicated with development via defect tracking system using Quality Center.
Involved in Database testing to verify data integrity tests.
Extensively interacted with developers to analyze and resolve the issues that were encountered while testing the application.
Review requirements, specifications, user documentation, help files, and other project documentation to assure quality of the products and tests to be developed; i.e., perform manual static testing.
Select and develop appropriate test automation tools, applying the latest techniques in test automation; e.g., data driven testing.
Use risk driven techniques to develop, maintain, and execute automated test suites for various Software products; i.e., perform automated dynamic testing.
Work with the Development team to capture and reuse automated Unit Test Cases, Test Stubs and Drivers, and other Development test objects.
Participate in the Change Control Board to identify the quality implications of known bugs and the impact of proposed changes to product definition on the testing process.
Work with the Release Engineering team to create and maintain an automated nightly build verification (smoke) test.
Ensure proper version control and configuration management of all test objects developed and test environments used.
Research and document bug reports following agreed upon processes immediately upon discovery of a quality problem.
Update test execution status following agreed upon processes as part of regularly scheduled test status updates.
Trace test cases and results back to specific quality risks.
Assist the Test Manager in the creation of test project status reports and metrics (e.g., Test Dashboard).
IOS Mobile Test Automation using Selenium Appium
Android Mobile Test Automation using Selenium Appium
Minimum 3 years of Hands on Test Automation experience on Microfocus UFT
Proficient in VB Scripting, SQL
Hands on experience in creating and maintaining Automation scripts for multiple technologies (SAP, Web is desirable)
Ability to deal with change and flexibility to handle multiple tasks and learn new tools & techniques
Hands on experience in scripting using Descriptive programming, Automation object model
Strong communication skills and ability to work independently as part of multi-vendor team
CI/CD, Kubernetes, Databases experience required.
Experience with Python (Django framework)
Experience with the POSTMAN tool.
Should be able to work on Linux/Unix based environments.
Environment: Selenium Web Driver 2.0, TestNG, Maven, Jenkins, XPATH, Quality Center 11, Oracle 12c, HTML5, Java Script, J2EE, JIRA, Firebug, UNIX, SQL, Agile, XML, SOAP, SOAP UI, Web Services, TOAD.
Grainger, Gurgaon, India Jun 2014 to Nov 2016
QA Manual/Automation Selenium Tester
Roles &Responsibilities:
Performing Manual and Automation testing. Working on Selenium Web driver for my work as QA Automation Engineer.
Developed test scripts using Selenium Web driver.
Worked extensively in creating selenium automation scripts and maintained them according to the enhancements throughout the projects.
Used various available features of Selenium to develop efficient and error free Automated Test Scripts using java
Performed Data Driven testing using Java, Selenium WebDriver, TestNG and Apache POI.
Created and executed smoke tests, functional test scripts and regression scripts till the project maintenance phase.
Generate and produce test cases first pass results and defect reports every other day to the project manager
Used JIRA to keep track of defects as well.
Performed backend testing. Validated data in the database by creating and executing SQL queries.
Good experience working in different Agile and waterfall projects.
Involved in creation of automated test cases for testing various web modules.
Developing automation scripts to reduce manual testing efforts and increased code quality.
Automate regression and functional tests using test frameworks.
Implement Selenium Grid to execute test scenarios on multiple browsers.
Involved in performance testing using JMeter.
Review requirement specifications and technical design documents to create test scripts and test plans.
Collaborate with development and cross-functional teams to troubleshoot and perform root cause analysis.
Add business value to agile teams through proactive participation in all phases of agile development.
Environment: Selenium IDE, Selenium RC, Web Driver, JUnit, Java, HTML, XMSA, Toad, UNIX, Oracle, Jira, TestLink.
CVS Caremark, Gurgaon, India Dec. 2012 - May 2014
QA Manual Tester
Roles &Responsibilities:
Tested standalone application of CVS Caremark (Pharmacy) client.
Led Deployment & Rollback testing for two major releases (Team size 6).
Prepared test plans for two major releases.
Verified end to end flow of data.
Prepared test case scenarios, test cases from Business Requirement Documents (BRDs) and use cases for functional testing of the application.
Identified test cases for Regression Testing and various phases of testing.
Provided test case estimations from BRDs and impacted use cases.
Executed test cases, logged defects in HP QC/Serena Business Manager and verified completion of defect life cycle. Troubleshoot test issues, recorded test results, tracked and prioritized defects.
Worked on production defects testing slotted in the coming releases.
Represented team in various status calls with the client.
Delivered various training sessions and presentations for cross-team co-ordination.
Used all types of SQL queries like select, insert, update, delete and joining multiple tables based on business requirement to conduct Backend testing.
Involved constantly in the team to adopt QA Testing Standards; logged and tracked defects
Analyzed defects or test results and deducted the chain of events leading to a failure.
Involved and responsible for creating Daily and weekly status reports regarding the progress of testing process
Environment: JIRA, Java, TestNG, Java Script, Oracle, SQL Server, MS Office, MS Excel, Windows