Rishu Agarwal

***** ******** ***** ***** ***** FL US 336**-***-*** 8311 ac42p0@r.postjobfree.com

Senior QA Engineer

12+ years of experience in Software quality assurance and testing as a team member and a team lead with system development lifecycle experience in requirement analysis, testing effort analysis, designing, developing and implementing test plans, test cases, defect documentation and regression.

Performed the role of system test lead, senior system test analyst while working on custom built and vendor licensed applications in technologies like Oracle Business Intelligence, ADF, C#, ASP .Net, VB .Net, JAVA, GoldenGate, PL/SQL on UNIX and Windows platforms.

Effectively worked in onshore - offsite model as an onsite coordinator.

Major strength is in Telecommunication Vertical (8 years).

SKILLS SUMMARY

SQA Testing & Methodologies Requirements Test Strategies

Test Plans, Cases & Processes Defect/Bug Tracking Regression & Negative Testing

White Box and Black Box UI & Compatibility Testing Integration Testing

DB & Application Upgrade Testing Data Integrity Testing DW & BI Testing

Performance/Load/Stress Testing Automated Testing Documentation

Job Experience:

Company : Syniverse Technologies, Tampa FL

Project : Analyzer & AccWeb

Duration : Oct 2011 – Mar 2018

Position : Advisory Systems Engineer - Quality Assurance

Role Description : Lead Test Engineer

Syniverse Technologies is a global communications company that develops mission-critical technology services designed to manage and interconnect voice and data systems in more than 50 countries throughout the Americas, Asia Pacific and Europe.

Roles /Responsibilities:

Gathering information and analyzing the business requirements to estimate the effort (ROM) for functional, integration and regression testing.

Analyzing Design documents and interacting with Product, BIA and Development teams to prepare test scope and strategy and manual and automated test plans for functional, integration and regression testing.

Creating and Managing Projects, Test Cases in HP-QC / HP-ALM and Test Plan Package and updating all documents in Knowledge Repository.

Setting up test environments by executing Release Notes and Installation documents for applications based on Weblogic, ADF, OBIEE and JAVA.

Setting up new WebLogic domains for scalable, active-active and high availability implementation for applications like Oracle business intelligence (11G and 12C), Oracle ADF and JAVA.

Testing the Oracle business intelligence functionalities such as Interactive Dashboards with drill-down capabilities using global and local Filters, Security Setup (groups, access / query privileges), Business Model filters, Metadata Objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports), Agents (iBots), GoURLs, session variables, repository variables, initialization blocks, foreign keys and complex joins.

Testing the DW-ETL data load such as partitions creation, indexes, data staging, data load in tables, checking log files and verifying MV rewrites. Debugging the issues faced while data load. Creating and executing SQLs in SQL Developer to verify the data has been loaded successfully and correctly.

Testing the real-time data integration and replication across application using ORACLE GoldenGate and UIs based on JAVA and ADF.

Working with the performance testing team to create performance test plan for Siebel Analytics / Oracle Business Intelligence application.

Creating/Executing automated test cases using HP-QTP/UFT and JAVA-Selenium-Testing for OBIEE and custom java apps.

Worked on upgrading OBIEE based application from OBIEE11G to OBIEE12C.

Designed and developed an automated testing tool for Oracle Business Intelligence by repurposing the BI system utilities to reduce the time taken to upgrade OBIEE 11G to OBIEE 12C.

Running Baseline Tests with old code for upgrade testing using automated and manual test scripts.

Preparing the data request forms and data scenarios required for the data loading.

Executing Test Scripts, raising tickets (bug reports) for defects found and closing once fixed.

Scheduling/attending cross teams status calls and Sending out daily status e-mails to stakeholders.

Creating Sign off document and conducting meeting for the same with Development, DBAs and production teams.

Responsible for reviewing the test strategy and test plan documents prepared by team members,

Responsible for maintaining the document repository with documents in MS-Office.

Responsible for mentoring and supporting onsite and offshore team members and provide knowledge transfer on homegrown DW, ETL, enterprise reporting application and Oracle Business Intelligence to new team members.

Client : Syniverse Technologies, Tampa FL

Company : Tata Consultancy Services, India

Project : Analyzer & AccWeb

Duration : Sep 2007 – Aug 2011

Position : Senior Test Engineer

Role Description : Lead Test Engineer

Syniverse Technologies is a global communications company that develops mission-critical technology services designed to manage and interconnect voice and data systems in more than 50 countries throughout the Americas, Asia Pacific and Europe.

Roles /Responsibilities:

Gathering of information and analyzing the requirements.

Responsible for mentoring the team for support and enhancements.

Responsible for conducting knowledge session for the client to explain the TCS functional understanding.

Creation of Project in HP-QC

Analyzing Requirement and High-Level Design documents and interacting with Development team.

Creating Test Cases in HP-QC and Test Plan Package and updating all documents in Knowledge Repository.

Reviewing Release Notes and finalizing the Test Cases.

Running Baseline Tests with old code to duplicate the error conditions.

Executing Release Notes and Test Scripts.

Raising Tickets (Bug Reports) for defects found and closing once fixed.

Creating Sign off document and conducting meeting for the same with Development and production team.

Creating the data pool in Win Runner for testing.

Effort analysis for integration, regression and functional testing.

Review the test cases written for integration and functional testing as per the scenarios created.

Working with the performance testing team to create the performance test plan for Siebel Analytics / Oracle Business Intelligence application.

Preparing the data request forms that are required for the data loading.

Testing the Siebel business intelligence functionalities such as Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Business Model filters, Metadata Objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports), iBots (Delivers), session variables, repository variables, initialization blocks, foreign keys and complex joins.

Worked at the client site (Tampa, FL) for 2 years to a complete the testing for a critical release.

Client : Sagem

Company : Tata Consultancy Services, India

Project : Document Management System

Duration : May 2006 – August 2007

Position : Test Engineer

Role Description : Test Lead, Senior test engineer & UAT Tester.

Document Management System is a centralized document management repository system that caters to various document related operations like archiving, check in, checkout, etc.

This has a Multi-tier architecture. The presentation layer is developed using .Net window forms / ASP .net web UI. The information storage base is on MySQL / MSSQL database, XML files and windows registry. The middle layer having all the business functionality is C# classes, implemented using Windows Services.

Roles /Responsibilities:

Develop test scenarios - Analyzing Requirements(through SDD and SRS)

Test Planning - Preparing Unit Test and System Test (Integration and Regression) Plans

Test Design - Preparing Test cases

Setting up testing environments

Test Execution of the system test, integration and regression test cases.

Coordinating with Client in Pre-Acceptance Test and User Acceptance Test.

Defect Reporting - Logging Defects and Verification of defects

Test Report Generation

Defining/ changing current business rules as per the changes in the requirement documents.

Using SQL for checking the output of various reports.

GUI testing using WinRunner.

Extensive unit, integration, and regression testing for all the modules of the application.

Client : Mercer

Company : Tata Consultancy Services, India & Tata Infotech Ltd.

Project : On Track V2

Duration : Dec 2005 – May 2006

Position : Developer & Test Engineer

Role Description : Developer, Test Lead, Senior Test Engineer & UAT Tester.

Mercer Advisors requires a comprehensive System for Service Delivery to Dentists (ONTRACK V2). ONTRACK V2 would replace the existing Practice Consultation offered by Mercer Global. The new system will help the practice Consultants in better management of their time and will help them to share the information about the clients with remaining divisions.

Roles /Responsibilities:

Part of the development team as a Developer (DRF Module) in designing of DRF (Data Request Forms).

Involved in Unit Testing and Bug Fixing.

Worked as part of the testing team as a Testing lead responsible for preparing unit test plans and test cases for the DRF Module.

Performed a role of a test engineer in executing the test cases and logging defects.

Setting up testing environments

Develop test scenarios - Analyzing Requirements (through SDD and SRS)

Test Planning - Preparing Unit Test and System Test Plans

Test Design - Preparing Test cases

Test Execution

Defect Reporting - Logging Defects and Verification of defects

Code inspection for defects and verifying the code standards conformance.

Educational Details:

University/College : Maharishi Dayanad University

Degree : Bachelor of Engineering in Electronics and Communication

Training /Certification Details:

Course

Company

Date Taken

CSTE

QAI Global Institute

July 2010

ISTQB Technical Tester

ISTQB India

Oct 2008

ISTQB Functional Tester

ISTQB India

Oct 2008

ISTQB Test Manager

ISTQB India

Oct 2008

ISTQB Foundational Level

ISTQB India

July 2008

Contact this candidate