Ravneet Singh Bhalla

Richland (WA) *****, PHONE: +1-314-***-****, Email ID: add2if@r.postjobfree.com

Career Snapshot

** ** ********** ** ** software testing (Manual and Automation). Tester with complete software development and testing lifecycle experience. Strong knowledge of software testing methodologies and techniques. Knowledge of programming languages like Java allows me to perform automation testing using varied automation tools efficiently and helps me to understand the underlying frameworks effectively. Thorough experience in testing SAP ERP, Web, Mobile, Telecom, Railway, Retail, Finance and Banking applications.

Key Highlights

Strong experience in all phases of Software Testing Life Cycle (STLC) such as Requirement gathering, Test Planning, Test Estimations, Test Case Creation, Test Environment Setup, Test Execution, Defect Reporting and Tracking and Software Development Life Cycle (SDLC) models such as Waterfall, V-Model and Agile (SCRUM) methodologies.

Extensive experience in analyzing functional/technical specifications, designing and implementation of QA testing strategy for different applications to perform Automation and Manual testing for various test phases like IST, PVT and UAT.

Experience in SAP ERP Testing, Functional Testing, Regression Testing, Integration Testing, ETL Testing, Sanity Testing, Smoke Testing, Web Services Testing, Mobile Device Testing, Backend Testing (API), End-to-End System Testing and User Acceptance Testing.

Thorough experience in Manual and Automation Testing using Java programming language and tools like Selenium WebDriver, FitNesse, Appium, TestNG, Cucumber, Maven, Jenkins, GitHub, Docker etc.

Served as liaison between business stakeholders and technical staff to ensure business needs are clearly defined, understood and documented using industry-standard requirements documentation methodologies.

Good experience in Performance Testing using JMeter.

Thorough experience in testing both SOAP and REST web services in Web Integration Developer using SOAP UI, Postman and Rest Assured tool for both XML and JSON formats.

Expertise in Appium tool in mobile testing for both Android and iOS applications.

Experience in testing data flows for ETL testing, to load the data of multiple applications from varied databases (Oracle, SQL Server) into SAP S4 HANA.

Experience in creating Test Automation Frameworks including Data Driven, Keyword driven, Hybrid Framework and Page Object Model (POM) design.

Experience with DevOps environment. Automate test cases and integrate them with scheduled auto deployment pipeline to increase test coverage and leverage nightly builds using Maven/Ant (Project building tool) and Jenkins for CI/CD.

Exposure with defect management tools like Micro Focus HP (ALM), JIRA, Mantis and TDP for reporting defects, tracking defects, maintaining defects and preparing bug reports.

Leading and managing functional test planning and test execution activities on a mainframe modernization project covering multiple complex functional domains.

Prepared Risk Assessment Matrix, Requirements Traceability Matrix, Responsibility Assignment Matrix, Test Estimation reports, Weekly status reports, Monthly metrics reports and Defect Summary reports.

Performed cross browser testing of functionalities in multiple browsers such as IE, Firefox, Chrome, safari using Selenium Grid.

Held weekly status meetings, retrospective meetings and grooming calls with Client, Business Analyst and development and testing teams for better understanding of the application under test.

Actively engaged in Agile Sprint Ceremonies like Daily Standup meetings, Sprint Planning, Sprint Review and Retrospective meetings with client.

Possess excellent communication and inter-personal skills. Recognized for taking initiatives, leading, good analytical skills, co-ordination capabilities, hard work and dedication in various projects.

Education

DEGREE

COURSE

UNIVERSITY

YEAR

PGDM (Executive)

Business Analytics

Institute of Management Technology (IMT), India

2020

Bachelors

Computer Science

Punjab Technical University (PTU), India

2010

Certifications

CERTIFICATION NAME

AUTHORITY

YEAR

SAP ABAP with NetWeaver 7.31

SAP

2014

Diploma in .NET Technology

NIIT

2010

Technical Skills

Programming Language

Java, HTML, SQL, JavaScript

Technology/Frameworks:

AngularJS, React.js, SOAP & RESTful Web Services

Database

Microsoft MySQL, Oracle, Mongo DB, DB2

Domain Expertise

Telecom, Banking, Financial Services, Railroad, SAP ERP, Retail

Operating Systems (OS)

Windows (All Versions), Linux, UNIX, Mac

Code Quality Tools

SonarQube

Web & application server

Apache Tomcat, IBM Web sphere

Testing Tools

Eclipse, Appium, Selenium WebDriver, FitNesse, IBM DataStage, Postman client, Putty, JMeter, SoapUI, PACT, Rest Assured, HP LoadRunner, Canvas

Defect Tracking Tools

Micro Focus ALM, Mantis, TDP, JIRA

Build Management Tools

ANT, Maven, Jenkins

Automation Testing Frameworks

TestNG, Cucumber, Junit

Repositories

GitHub, TortoiseSVN, WinSCP

Professional Experience

Employer: R Systems Inc., US (Dec’2019 – till present)

Role: Test Lead

Responsibilities:

Involved in requirements gathering, establishing technical specifications, designing test cases, test execution, setting up milestones with client.

Engaged in the test preparation activities such as creating test plan, test estimates and test strategy for various test phases like String, System Integration Testing (SIT) and User Acceptance Testing (UAT).

Served as a Business Analyst at onsite and Develop, review and implement test plans, test cases, test reports and testing schedules for software implementations and maintains a test repository. • Review, verify and validate that software meets technical specifications and business/functional requirements.

Involved in manual and automation testing for various SAP modules like SD, PP and functional workstreams like Order to Cash (OTC), Procure to Pay (PTP), Finance and Plant Maintenance using tools such as Selenium WebDriver.

Involved in creation and execution of Performance Load Test script using Micro Focus LoadRunner.

Involved in Database Interface Testing of legacy system; EDI, Dell Boomi, Cadency, Workday and Mainframe applications integrated with SAP S/4 HANA.

Maintained and logged test cases of various functional modules in SAP Solution Manager.

Involved in processes like Change Management, Document Change Control, Scope Management and Issue management using tools like JIRA.

Assisting client with migration from planned driven project approach (Waterfall) to Agile framework (Scrum).

Engaged in Sprint activities like Daily Standup, Sprint Planning, Sprint Review and Retrospective meetings with client.

Host weekly Status meetings with Customer, Interface process leads and development teams to discuss test execution status and impediments/risks to assess the quality of application.

Host Daily Synch up Call with Offshore team to ensure that the project progress is on track.

Employer: Tech Mahindra Americas Inc., US (Sept’2018 – Dec’2019)

Role: Software Test Engineer

Responsibilities

Designed Test strategy, Test plan, Test Data, Test Scenarios, Test Scripts, Test Procedures, Test Environment and Test Automation Architecture for safety critical applications with knowledge of DO 178B Safety Standards to test UP-BOS application.

Estimated requirements using various estimation techniques viz. Work Breakdown Structure, Percentage distribution, Three Point Estimation etc. and share the final estimates in terms of hours required to perform testing.

Prepared and maintained Requirement Traceability matrix (RTM) using Visure Requirement Management Tool.

Created and maintained Test artefacts in addition to raising bugs in Micro Focus ALM.

Tested systems at unit level and performed Integration Testing of all the critical components of the applications using Mockito tool.

Performed Automated Contract Testing to verify interactions at the boundary of an external service using Pact tool.

Created performance test scripts based on the business requirements and tested UP-BOS application using JMeter tool.

Performed automation testing using Selenium WebDriver, Java, Maven, Eclipse IDE, Jenkins and test automation frameworks such as Data Driven, Page Object Model (POM) and TestNG.

Performed cross-browser testing of functionalities in multiple browsers such as IE, Firefox, Chrome, safari using Selenium Grid.

Maintained Jenkins Dashboard, monitored configured jobs, daily job execution, debug Jenkins crashes, memory & workspace optimization.

Created fixture code using Java programming language in FitNesse tool to perform automation testing of UP-BOS application using SLIM test engine.

Performed Web Services automation testing from an end to end perspective, using Rest Assured tool.

Actively participate in daily Synch up Call with Offshore team to ensure the project progress is on track.

Employer: Tech Mahindra Americas, US (May’2017 - Sep’2018)

Role: Software Test Engineer

Responsibilities

Developed a comprehensive test automation framework to reduce repetitive manual testing of ATT web application (Internet, Shop, DirectTV, Wireless) modules using Selenium WebDriver and Hybrid framework.

Used and created locators like ID, Name, LinkText, Partial LinkText, Tag Name, Class Name, DOM locator, XPath, CSS, FirePath and Firebug to perform automation testing.

Reduced build/deploy time considerably by creating Jenkins scripts to automate code pull from GIT repository, used ANT/Maven to build war/jar files, configured customized properties files and deploy code to various internal servers.

Experiences in performance testing using HP LoadRunner tool to create thread Groups and tested Web Application for various loads on key business scenarios.

Performed Security Testing to ensure that the applications are not susceptible to security threats, violations and vulnerabilities using Canvas tool.

Hosted Defect Triage call involving stakeholders, development team, Business Analysts and testing team for effective closure and quick resolution of defects.

Interact with Off-shore team to resolve defects and functional issues of the application.

Actively engaged in Agile Sprint activities like Daily Standup meetings, Sprint Planning, Sprint Review and Retrospective meetings to discuss the overall project progress and managed the same in AgileCraft tool.

Employer: Tech Mahindra Ltd, India (Jan’ 2017 - May’2017)

Role: Test Lead

Responsibilities

Handled a team of testers in project, responsible for overseeing their day-to-day operations, providing domain knowledge to team and arranging technical training sessions for skill set improvement.

As a BA, Identify and report IT risks to management; analyzing risks and recommending mitigations and resolutions.

Interacted with client and business analyst to understand Business Use Cases, Functional and Design Requirements for effective Test case creation.

Define goals for each iteration and detailed work break down structure (WBS) for QA team (Onshore and Offshore) using Primavera 6 tool.

Reviewed test cases and helped team in generating test data. Also, verified defects raised by the team in ClearQuest for effective testing.

Perform code quality assessment using SonarQube tool to detect bugs, check coding rules, duplications and manage code quality.

Involved in the complete lifecycle of the project from strategizing to implementation of the automation test framework.

Performed automation testing of various modules of ATT web application using Selenium WebDriver tool.

Created Test Estimation Report, Requirement Traceability Matrix, Burn Down chart, Risk chart, defined the scope of testing for each release, deployed and managed resources for testing and approved daily timesheets for team members.

Hosted Weekly Status call with Client, Onshore team, BA, and Scrum Master to discuss technical challenges and issues. This helped mitigate jeopardy and aided in meeting stringent deadlines for project.

Employer: Tech Mahindra Ltd, India (Aug’2014 - Dec’2016)

Role: Senior Test Engineer

Responsibilities

Created test cases, test scenarios, test scripts and test data in Micro Focus ALM.

Set up test environments and assisted system administrator and network management staff for the same.

Created and maintained required test automation framework(s) using automation testing tools such as Selenium WebDriver, Cucumber and Java programming language.

Performed GUI Testing, Functionality Testing, Integration Testing, Black/White box techniques, Regression Testing, Security testing, User Acceptance testing, Smoke testing and System testing

Performed XML/SOAP Web Services testing by creating Test Suites in SoapUI tool.

Host Defect Triage Call for effective closure of defects and logging the defects with appropriate details in Micro Focus ALM and JIRA.

Involved in RCA (Root Cause Analysis) of defects raised by IST and UAT teams.

Performed Performance Testing of the web applications using HP load runner.

Performed mobile automation testing of both android and iOS mobile device applications of ATT using Appium tool.

Participated in Sprint activities like Daily Stand up meetings, Sprint Planning, Sprint Review and Retrospective meetings in agile model.

Employer: Infosys Ltd, India (Dec’ 2012 - Jul’2014)

Role: Systems Engineer

Responsibilities

Involved in Requirement gathering, preparation of Test Plan, Test cases, Test Data and Test Reports.

Performed Functional Testing, Smoke Testing, Regression Testing, Integration Testing, Web Services Testing, Backend Testing (API) and Performance Testing of the application.

Performed ETL testing by running data stage jobs in IBM DataStage Tool to ensure the correct data is migrated in target system (DB2) as per the source data file (Oracle, flat files and SQL server).

Leading and managing functional test planning and test execution activities on a mainframe modernization project covering multiple complex functional domains.

Executed SQL queries on Source and Target systems to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.

Performed RESTful web service testing using Rest Assured Tool. Validated JSON data and different http status code like 200, 201, 400, 415, 500, etc. for GET, POST, DELETE and PUT methods.

Responsible for implementation of Hybrid Test Automation Framework (TestNG, Cucumber, POM, Data Driven, Apache POI) using Selenium WebDriver, Maven, Jenkins and GitHub repository.

Integrated automation scripts in Continuous Integration tool (Jenkins) for nightly batch run of the Test Suite.

Attended daily Scrum meetings conducted by Delivery and Services teams and Updated the status. Also, discussed about QA goals, Risks and Future plans.

Prepared technical and functional documents for team, management and client for reference.

Employer: Infosys Ltd, India (Jul’ 2012 – Dec’ 2012)

Role: Systems Engineer

Responsibilities

Attended Sprint planning and daily scrum meetings to discuss QA goals and risks.

Designed Test Cases using Software Testing Techniques such as, Boundary Value Analysis, Equivalence Class Partitioning and Decision Table based testing.

Performed Peer Review of the test cases prepared by team members.

Prepared Test Data, Configured Test Environment Setup and installed all the necessary software required to test the application.

Created complex SQL queries using joins to perform Database Testing.

Performed mobile automation testing using Appium tool and Java programming language.

Maintained the automation test scripts in Tortoise SVN tool.

Logged Defects and monitored them for closure using Test Management Tool- Mantis.

Prepare each iteration testing report and submitted the same to higher management.

Performed UAT testing and thoroughly explained all the functional and technical aspects of the application to client.

Employer: Infosys Ltd, India (Dec’ 2011 – Jul’ 2012)

Role: Systems Engineer

Responsibilities

Performed Automation testing, Functional Testing, Regression Testing and End-To-End testing.

Prepared functional and non-functional Test Scenarios and Test Cases using Application Design (AD) and Functional Design Specification Documents (FSD).

Prepared a Requirement Traceability Matrix to map all the business and technical requirements to the test cases.

Integrated Web services using Web Integration Developer and tested the same in SOAP UI.

Performed testing on the web services APIs using protocols like HTTP, HTTPS, SOAP and WSDL using SOAP UI tool related with various interfaces.

Performed Automation Testing for various modules of web application using Micro Focus UFT, hybrid framework and JavaScript programming language.

Performed defect prevention activities such as requirement specification review, design review and Pareto Analysis to reduce defects leakage into production environment.

Conducted Defect Triages in order to identify defects, their classification and raising them to appropriate team in HP-QC ALM tool for effective resolution.

Employer: Infosys Ltd, India (Jul’ 2010 – Dec’ 2011)

Role: Systems Engineer

Responsibilities

Involved in analysis and design of the application to prepare effective Test Cases, covering all the negative and positive scenarios.

Developed Test Data corresponding to the test scripts using SQL and Oracle knowledge.

Performed Functional Testing, Regression Testing, Database testing and System Integration Testing.

Raised and assigned Defects to appropriate development teams in JIRA.

Performed Root Cause Analysis of defects by checking Logs using UNIX programming commands in Putty.

Prepared Risk Assessment Matrix to identify the level of testing required to test different modules of the application.

Used HP LoadRunner for Performance Testing involving multiple transactions for Money wallet and Bank Wallet Applications and measured Server response time, throughput and performance bottlenecks.

Generated performance testing reports using Analysis Tool in HP LoadRunner.

Created technical documents related to project domain for knowledge transfer among team.

Prepared Test Execution Status Report, Weekly Status Report, Defect Status Report and shared the same with client.

Contact this candidate