Engineer Test Cases
Resume:
Rishu Agarwal
***** ******** ***** ***** ***** FL US 336**-***-*** 8311 *****.*******@*****.***
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