Test Cases Customer Service

Ravinder Kumar:

************@*****.***

Mobile : 1-201-***-****

Summary of Experience:

Over 15+ years of extensive Quality Assurance experience on various domains in Payroll, Airlines, Healthcare/Pharma, Mobile testing, Financial & Banking, Gas & Power, Security, Networking, Manufacturing and Industrial Domain (SCADA), and 10 years of onsite experience in USA & UK.

Efficient in implementing QA Process, established standards, procedures, and methodologies.

Seasoned QA professional, with outstanding experience in project planning, Tracking, Execution, and Resource Balancing skills with ability to support multiple simultaneous projects in a matrix organizational structure.

Strong Knowledge on the phases of Software Development Life Cycle. (SDLC) Methodology Waterfall, V model, Agile (Sprint) & Scrum Master.

Experienced in preparing the overall test methodology - Test Plans, Test Strategy, Deliverables, Test Scripts, Test Cases and Test Data. Expertise in Risk Analysis, preparation of RTM & Prioritize Test case.

Experienced in designing and executing modularized re-usable automated scripts using - Quick Test Professional (QTP), VBScript, Selenium (WebDriver), SQL, JavaScript, CSS, Load Runner, for testing client/server, web-based n-tier applications

Expertise in the areas of Software Testing end to end cycle, GUI, Functional, System Test (UAT, BAT, Grey Box, Integration, and Performance), and Regression & Web Services testing for Client Server and web applications (Content Management System).

Expertise in analysis of Problem severity, Defect tracking and Defects reporting system.

Expertise in Confluence, Rally, defect triage, scrum/sprint process.

Possess excellent Project Management skills in preparing and delivering status reports (Includes progress, risk identified, mitigation plan, Metrics, etc) and presentations to senior management and development teams. Effectively trained, motivating and mentoring onsite and offshore junior managers, engineers, developers and technicians.

Lead a team size of maximum 30+ QA engineers both on onsite and offshore, well versed with Configuration, Change Management and MS Project.

Education(s):

MCA - Master in Computer Applications from Osmania University, 1997

B.Sc Computer’s from Osmania University, 1993

Work Experience

ADP

QA Lead – Aug’ 2013 – Dec’2017

QA Contractor – Apr’2013 – Aug’2013

ADP workforce now

ADP Workforce Now is a web-based human resources (HR) application designed especially for midsize businesses. This automates all of your company’s HR processes into a single dashboard. You can create additional user permissions for your employees to help them coordinate and manage multiple HR functions. It also allows you to manage all your employees’ payroll, benefits, holidays and easily generate insightful reports.

ADP Workforce Now offers core HR capabilities including time and attendance, talent management, payroll, Reporting and benefits management.

Responsibilities

Acted as SCRUM master for the products owned using the Agile techniques (Sprint).

Design/Create Test Cases / Test Scripts to automate test procedures for both functional and performance testing. Automate test cases (Test Data) and performed data driven using QTP (UFT) and enhancing the overall functionality of the application.

Created Quick Test Professional (UFT) scripts for Regression testing of the application with various data sources and data type scenarios.

Document test results, analyze them and provide detailed analysis for problem resolution.

Translated every new requirements/enhancement into the required test design, test plan and test cases.

Build test cases to automate and test web services using SOAP UI.

Ran PL/SQL batch commands every week to check the integrity of the data getting generated.

Performed Backend testing to verify the data integrity by executing PL/SQL Queries using Oracle.

Prepared Traceability Matrix to show the test coverage requirement vs. Test scripts.

Tracking defects on a weekly basis and working with Project Managers and developers to resolve them in timely fashion using Rally tool.

Preparation of comprehensive test results reports from Rally to Sr. Management and business users on the testing progress / Coverage made.

Closely worked with Developer’s and System Engineers to nail down the problems.

Managing on-site and off-shore teams for weekly deployments on the QA, Staging and Production environment(s) and review the smoke testing results.

Environment: Java (J2EE), Jscript, CSS, SOAP, HTML, Oracle 11G, QTP (UFT), Quality Center 11, Rational Clear Quest, PL/SQL, SQLTools 1.5, Jira, UNIX Shell Scripts, Rally, Confluence, Jenkins, Apache KAFKA

Mercedes Benz

Sr. QA Lead – Jan’2012 –Mar’2013

MBUSA.com

Mercedes-Benz USA (MBUSA), headquartered in Montvale, New Jersey, is responsible for the distribution, marketing and customer service for all Mercedes-Benz products in the United States. MBUSA offers drivers the most diverse line-up in the luxury segment with 14 model lines ranging from the sporty C-Class to the flagship S-Class sedans and the SLS AMG supercar.

MBUSA is also responsible for the distribution, marketing and customer service of Mercedes-Benz Sprinter Vans and smart in the US.

Responsibilities

Managing on-site and off-shore test teams in India (4 resources) and in NJ (6 resources) for weekly deployments on the QA, Stage and production environment(s) and review the smoke testing results.

Acted as SCRUM master for the products owned using the Agile techniques (Sprint).

Automated overall testing scenarios for user interface and daily smoke build using Selenium (WebDriver).

Reengineered QA methodologies, Audits and processes that resulted in establishment of complete traceability of Business requirements and enhanced test quality.

Managing various QA phases and performing hands on Automation testing including Regression, Functional, UAT, BAT, System testing, Cross browser & Pre-Release testing of the MBUSA products on QA, Stage and Production environment(s).

Regression testing of the builds on iPAD (iOS 6) & mobiles (iOS 6, Android).

Reviewing business requirements, preparing and executing high level test plans and test cases as well reporting of the test results thru well defined Standards and processes.

Directly interacting and partnering with clients on a regular basis through road shows, user conferences showcasing new functionality and enhancements. Evaluating and gathering specific client expectations on QA.

Performing signoff of test artifacts and conducting internal audits at project management level for ensuring compliance with SDLC standards.

Performing extensive Automation testing on Mobile, tablets / iPAD’s and XML testing on a continuous basis for enhancement releases and patches.

Perform Database validation using PL/SQL tools after migration is done.

Developing reports from Quality Center to track Defect progress and identify trends, running daily status meetings and provides guidance to onshore and offshore team members.

Mentoring the junior QA resources on the application

Environment: Java (J2EE), CSS, Jscript, DHTML, XML, Vignette Content Management (VCM), Apache Web Server 2.2, Quality Center 10, Oracle 9i, SQL Tools 1.5, IBM DB2, Jira (bug tracking tool) 5.2, Confluence 4.3, Ipad- iOS 6, Open Source Selenium (WebDriver).

ADP.com:

QA Lead (consultant) – Mar 2011 – Dec’2011

ADP Vantage & Work Force Now.

ADP Vantage HCM gives clients the most comprehensive set of human capital management capabilities available today, with a single solution that unites the five major areas of HCM: human resource management, benefits administration, payroll services, time and labor, and talent management. With HCM-related data, applications and processes can be better aligned with business strategy. With ADP Vantage HCM, client’s gain greater insight into your workforce. Reports, dashboards and other analytical tools which provide with new perspective on how you hire, manage and reward your people, with real-time information you can take decisions.

Responsibilities

Managing a team of onshore (2) and offshore (2) QA team and interacting with Brazil development team for production releases onto various testing environments.

Participating in design walk-through with the Business Analyst and provide feedback on the Requirements specification for Vantage HCM and Work Force Now.

Design, build and execute automation Functional End to End Scenarios (including Integration Testing, System Testing, Data, Environment, Performance, Security, Regression) using QTP.

Implemented automation testing strategy utilizing Quick Test Pro product. The automated test suite was performed against four different versions of Windows each night eliminating the need to perform manual smoke tests.

Implemented a root cause analysis process that categorized defects using the 5-Whys methodology. This effort identified two specific areas that were the cause of more than 60% of the defects found during a project: inadequate communication of design decisions to the developers/testers and code review processes.

Ensuring the delivery of all release deliverables as planned and on time, including the design solution, on the prioritized backlog.

Planning and Managing multiple projects and Prioritizing to changing priorities.

Preparation of Automation Test plan using QTP for each product deliverable.

Creating and reviewing automation test cases from approved Requirement document and sharing the updates with the Business unit.

Verifying the data integrity of the data that is stored in the database tables by querying them against a set of predefined PL/SQL queries.

Preparation of comprehensive execution test results report to project developers.

Managing and prioritize testing schedules to meet completion dates, well versed with multitasking at times.

Reporting and maintaining the bugs in Clear Quest.

Closely worked with Developer’s and System Engineers to nail down the problems.

Environment: PHP 5.2, Jscript, Apache Web Server, SOAP, Oracle 10G, QTP 10, HTML, Quality Center 10, Rational Clear Quest 7.1, PL/ SQL 2005, SQLTools 1.5.

Standard & Poor's Financial Services:

QA Tech Lead (Consultant) – Sep 2010 – Feb 2011

Ratings Process Manager (RPM) and People DB.

Responsibilities

Acted as SCRUM master for the products owned using Agile techniques (Sprint).

Converting requirements into Test scenarios and Building SQL queries to validate data.

Participating in design walk-through.

Using SOAP UI to validate the web services.

Querying the Database for any data mismatch by building SQL queries to validate the employee records.

Performed DB testing for the integrated piece of RPM and People DB using SOAP UI and web services for HTTP requests.

Preparation of Functional & Integration test plans and other test artifacts.

Identify test scenarios for UAT and get a signoff from the business and execute the UAT scripts on the UAT environment.

Reporting and maintaining the bugs in Clear Quest.

Closely worked with Developer’s and System Engineers to nail down the problems.

Environment: GoldenSource8.2, PEGA, Toad 10, Oracle 10G, Java, XML, XML SPY, Quality Center 10, SharePoint, SOAPUI 3.6, VSS, MS Office Tools.

Applabs Technologies – United Airlines.

QA Project Lead – Dec 2009 – July 2010

Projects: Money&Miles, ARP, IPOS, Secure Flight.

Responsibilities:

Leading a team of 35+ engineers and managing the overall delivery aspects of the project using Scrum and Agile Techniques.

Defining project strategy, objectives, and scope after discussing with the end client.

Gathering the requirements from the end client and the business unit and walkthrough to identify the gaps for correctness.

Perform system testing including grey box, black box, Integration, regression, Stress / Load.

Maintaining the quality of component areas in a UAT and production environment with a rapid development cycle and weekly deployments by interacting with the Development Lead.

Web Services testing using SOAP UI, validating the request and response from services.

Perform Database testing for the values being recorded in oracle database and in the appropriate tables by writing SQL queries.

Validated the XML WSDL response from the SOAP UI and verifying them against the default values logged in the excel sheet.

Verifying the data integrity of the data that is stored in the database tables by querying them against a set of predefined SQL queries.

Performed mobile regression testing on IPhone 3rd Generation) to test the various features of the United.com application with regards to Booking of the tickets.

Approving the testing artifacts that are created as part of the UAT testing like Test Cases, Defects Reports, and Execution progress.

Reviewed automated Test Cases written by Team and also assisted UAT team in writing Test Cases, Test Scenarios and testing the application.

Creating and reviewing high level test scripts from approved FRS document and sharing the updates with the End Client / Business unit.

Using SharePoint for Managing the progress of projects from the handoff through release using review meetings, project progress to various stake holders based on the SLA’s agreed upon.

Compiling project status, performing risk analysis of project readiness

Managing and prioritize testing schedules to meet completion dates, well versed to do multitasking at times.

Recommending go/no-go decisions for projects about to launch and Evaluating reported defects and oversees re-testing of prioritized defects. Provides final sign-off on testing deliverables.

Foresee issues and provides proactive solutions to closure

Analyzes process blockages, Defects Management and facilitates enhancements to closure

Preparation of comprehensive test results reports from Quality Center to End Client and business users.

Planning and Managing multiple projects and Prioritizing to changing priorities.

Coordinates the dependencies between departments on projects with aggressive timelines.

Environment: C# (dot net), SOA, Web Services, SharePoint 3.0, Mainframes (C, C++, COBOL), QTP 10.0, Quality Center 10.0, Documentum, Oracle 10g, Apollo, IPhone (3rd Generation).

Total Gas & Power Ltd – UK. (Jan 2009 – Oct 2009)

Projects: Pricing and Quotations, Maintenance

Responsibilities:

Lead a team of 4 member’s team, and prepared the automation regression testing. Used QTP to convert manual test cases into automated scripts.

Reduced manual execution time by developing automated test scripts for regression testing and monitor the time saved.

Used the QTP Data driven testing and database accessing techniques to support the scripts.

Responsible for developing and maintaining an Infinite testing program and the SLA’s.

Evaluating reported defects and oversees re-testing of prioritized defects. Provides final sign-off on testing deliverables.

Driving the development of testing standards, policies and procedures and continuous improvement of the testing processes.

Environment: C# (dot net) SOA, Java (JCAPS), SQL server 2000 & 2005, HTML, XML, Web services, QTP 10, Quality Center 10, Tortoise SVN, Oracle 9i/10g, Lotus Notes 6, Marvel (Business Defect Tool), Siebel CRM Tool.

GE FANUC – as Project Lead / Project Manager – Nov’2005 till Jun’2008

Projects Handled: SCADA/HMI, iFix, RTIP, iBatch (Healthcare), Plant Apps, and Labview.

Responsibilities

Leading a team of 12 members and delegating the work among the team using Agile & Scrum and V Model.

Successfully automated 10% of the overall testing scenarios, thereby reducing the testing effort required with QTP for Regression and Functional Testing.

Implemented an automation testing strategy utilizing Mercury Quick Test Pro product. The automated test suite was performed against four different versions of Windows each night eliminating the need to perform manual smoke tests.

Optimized QTP scripts for Regression testing of the application with various data sources and data types.

Checking the features using Web Services Request and Response from the WSDL.

Used SOAP UI extensively to validate the requests.

Managed the successful testing and delivery of more than 6 releases of SCADA/HMI products with more than 100 enhancements.

Execute and oversee all aspects of testing - Business Scenario, UAT/BAT, Functional/Black Box / White Box, Integration, Security, Internationalization and localization (I18n/L10n), GUI, Regression testing. Deriving high level Test Plan and Test Strategies for QA evaluations, reviewing projects/test plans.

Reducing the number of defects found in QA by 20% the change caused a dramatic increase in the communication between the QA and development teams. Increased the turnaround time by implementing the virtualization techniques.

Environment and Tools: C#, SOA, C++, VC++, MFC, DCOM, ASP, Java Applets, IIS6, Visual Studio.net, SQL 2000 & 2005, Subversion SVN, Siebel CRM tool, Team Track, Lab view, Siemens PLC, Oracle 9i/10g, Team Tracker (Bugzilla), VSS / CVS, MS Project-2007, XML, HTML/DHTML, Jscript, VBScript, QTP 8.0 & 9.0, VMware WorkStation 5.0 & 5.5,Linux 2.4,

Applabs Technologies (Aug’02 – Nov’05)

Role: QA Validation Engineer/Test Lead

Projects: LIMS Sample Manager (Thermo, InnaPhase), Report Retriever, Verdasys-DRM, Sealed Media, HIPAA (Healthcare), National Australia Bank, Market Axess (Bonds & Fixed Income).

Responsibilities:

Leading a team of 20 members and distributing the work among the team.

Used QTP to execute regression and functional test cases as and when new build was released.

Written and executed test scripts to verify the Test cases using QTP for various modules of the application.

QTP: Created repository files, Data tables for DDT testing, Database Checkpoints in QTP testing

Performed DDT (Data Driven Tests) a QTP option to scenarios

Performed Performance test using Load Runner on various applications and provided the solutions to the clients for review,

Analyzed, developed, documented and validated QA work product for the Sample Manager application, against the Use Case and Business Requirements Documents as part of the SDLC activity.

Validating the CSV files for data validation (270/271, 276/277,278,820,834,835) and generating appropriate reports

Developed SQL Queries to query the database to test the back-end process of the application.

Testing and organized daily scrum meetings, Generated defect reports and metrics to provide project status to upper management.

Reporting and maintaining the bugs in BTS (Bug Tracking System).

Closely worked with Developer’s and System Engineers to nail down the problems

Coordinated the testing between onsite and offshore resources.

Environment: MVC Architecture, C# (dot net), Oracle 9i, Visual Studio.NET, .Net framework 1.1, CVS, DevExpress controls. XML, Crystal Reports, Java, Struts, Jscript, RS232 Interfacing, Microsoft server platforms, Java, Java Applets, ASP, IIS, SQL Server, WinNT, Java Script, QTP 8.0 / 9.0, VB script, Visual Basic 6.0, VJ ++, ActiveX components, C++, HTML, COM.

Boston Group Inc – (Mar’99 – Jun’02).

Software Quality Assurance Engineer

Projects: Intralearn, MD Planet, Navione, DSL – 3Com,

Responsibilities:

Involved in test plan preparation, which includes test environment and test strategies

Written test cases and performed Manual Testing, White Box Testing, Black Box Testing, User

Tested GUI and functionality of web page objects such as HTML objects, links and images

Developed GUI Map through Rapid Test Script Wizard using Win Runner.

Acceptance Test (UAT), Regression testing, Integration, Stress testing, load testing verified and interacted with developers to resolve technical issues.

Defects were tracked, reviewed, analyzed and compared using Test Director

Performed testing of servers for load and scalability by simulating Virtual User’s using Loadrunner.

Setting up the lab network for ANVL workstation connected to the device under test (DUT).

Installing and configuring Solaris 7.0, configured Apache web server and configuration service tracker and configured secure shell, installed Veritas Volume Manager 3.0.2 and configured disk groups and implemented RAID level,

Written Unix shell scripts to run the batch process.

Writing scripts using Tcl/Tk (7.6/4.2) for testing the voice calls.

Involved in setting and installing the workstations and configuring it to the network.

Environment: Win NT, SQL Server, Java, Win Runner, Loadrunner and PVCS Tracker, Solaris2.6, SUN E10000 Server, UNIX Shell Scripts, Portal Infranet, Tcl/Tk, Perl, Expect, C, C++, Java2.0, DHTML, XML, JavaScript, Expect, Smartlib, Smartbits, Anvl, Mod_perl.

Current / Previous Experience(s)

ADP.com (Roseland, NJ) Aug’2013 –Dec 2017.

Lead – QA Engineer

ADP.com (Parsippany, NJ) Apr’2013 –Aug’2013.

QA Contractor

Mercedes Benz Jan’12 – Mar’13

Sr. QA Lead/ Analyst

ADP.com Mar’11 – Dec’11

QA Lead

Standard & Poor's Financial Services Sep’10 – Feb’11

QA Lead

Applabs Technologies Dec’09 –Jul’10

QA Project Lead

Total Gas&Power UK Ltd Jan’09 – Oct’09

QA Lead

GE India Exports Ltd, Hyderabad, Nov’05 – Jun’08

QA Project Lead

Applabs Technologies Aug’02 – Nov’05

QA Test Lead

Boston Group Inc Mar’99 – Jun’02

QA Consultant

Contact this candidate