Roopa Rani Bhandari

Mobile: +1-785-***-****

Email: ad3vi9@r.postjobfree.com

Roopa is an IT professional who is now a home maker and an entrepreneur working hard to make a comeback into mainstream work force to rekindle her passion towards software testing.

Summary of Experience and Qualifications

Roopa has over 9 years of extensive experience in Quality assurance roles on various client/server and web-based applications and working in different software development methodologies

Expertise in design, development and execution of Test Strategy, Test Plan, Test Scenarios, Test Cases, Test Management process and Bug reports

Having work experience in all the SDLC phases with globally distributed teams, with onshore, near-shore and offshore models in Water Fall and Agile methodologies.

Experience with testing environments like Java, .Net, VB, ASP, HTML, DHTML, XML, JavaScript and VBscript in Relational DBMS like Oracle, SQL Server and writing SQL queries

Performed ETL Testing, Functionality Testing, System testing, including Integration Testing, Regression Testing, UAT and executing Automation Testing scripts using Selenium.

Performed Identification, Tracking, reporting and Verification of Defects using different Bug Tracking Tools.

Work Experience

Worked as Lead ETL Test Engineer with Prudential Singapore from 19th Jan 2022 to 19th Aug 2022.

Worked as Senior Software Engineer with JP Morgan Chase, Hyderabad from 07/11/2011 to 07/30/2014

Worked as Senior Software Engineer with AppLabs, Hyderabad from 10/19/2009 to 07/07/2011

Worked as Software Engineer with CHEKHRA from March 2009 to 08/25/2009.

Worked as Software Engineer for Emagia India Pvt. Ltd., Hyderabad from 08/29/2005 to 03/03/2008

Experience Summary

Company: Prudential Singapore Jan 2022- Aug 2022

Project: ETL IFRS17 Implementation

Role: Lead Test Engineer

Test Environment: Control M, ADLS, SSISDB, MS Azure

IFRS 17 is the newest IFRS standard for insurance contracts and replaces IFRS 4 on January 1st, 2022. It states which insurance contracts items should by on the balance and the profit and loss account of an insurance company, how to measure these items and how to present and disclose this information. Mainly to make the financial statement easier to compare across insurance companies and among industries.

To implement the changes ETLs has played a vital role uploading accurate data into DB.

Roles & Responsibilities:

Requirement’s brainstorming to understand end to end user specification document

Creating Test scenarios & test cases using user specification document

Responsible for execution and analysis of the data from the users and checking if data is loaded into DB as per user specification document.

Validating the test Results and sharing the data with the user.

Executing testcases in JIRA and updating the results with appropriate test execution document.

Triaging Defects by having regular meetings with team and users

Company: JP Morgan Chase July 2011 – July 2014

Project: Customer Assist, EDO

Role: Team Lead

Test Environment: ALM, QTP

Customer Assist is a web-based application most importantly used for opening Checking, Savings accounts in Chase and also to perform various maintenance activities on these accounts such as Funds transfer, wire transfer, Customer maintenance, Account Maintenance, and many other functions

Any enhancements to CA come as part of a project and goes into production on monthly & quarterly basis.

Roles & Responsibilities:

POC for a team comprising both JPMC and Accenture in Testing and delivering a Quality Customer Assist product. In this role was responsible for Work Distribution and ensuring efficient utilization of the team.

Responsible in gathering requirements from the Business stakeholders & sharing it back with the development team

Creating Test plan, Test scenarios & test cases using Business components

Executing test cases and capture the test results

Validating and approving the Testing Results, Support during Deployment

Triaging Defects by having regular meetings with Dev and Business partners

Company: AppLabs October 2009 – July 2011

Project: United Airlines

Role: Test Engineer

Test Environment: Windows XP, Citrix VPN, ALM 11.0

United Air Lines, Inc., operating as United Airlines, is a major U.S. airline owned by United Continental Holdings (originally UAL Corporation), headquartered in Chicago, Illinois. It is the world's largest airline by number of destinations and scheduled passenger-kilometer flown. The airline was founded in 1926 as Varney Air Lines; it was renamed Boeing Air Transport in 1927 after it was acquired by aircraft manufacturer Boeing. United became an independent company in 1934 and merged with Capital Airlines in 1961. In 2011, it merged with Continental Airlines, replacing its own tulip logo with Continental's globe logo and its aircraft livery.

Roles & Responsibilities:

Responsible for writing Functional Test Cases and executing Test Cases

Prepare and review project documents such as Test Strategy, Project Plan, Test Plan, FDR, QAR reports et al.

Preparing the Status reports and reporting to the Client/onsite Test manager Develop scenarios for Smoke Test and prepared a Checklist for the same. Performed Smoke Test.

Involved in Test Case Authoring and Test Case Reviews, preparing TRTM, Test Case Execution on a release basis and defect logging

Identifying the critical and core components to be tested and executing the test cases developed

Perform Bug Reviews and reported bugs identified during the test execution and Ad-hoc testing process in HP ALM.

Company: Chekhra March 2009 – August 2009

Project: GPS

Role: Development and Testing

Technology: JSP, EJB, DAO

Roles & Responsibilities:

Being the primary Java resource, involved in developing User Interface which enables accessing the ports using Socket Programming in Java.

Migrating PHP code into Java for CHEKHRA School Bus Tracking Interface.

Preparing Use Case diagrams and authoring Use Cases based on the School Bus Tracking Interface.

Involved in programming using JSP, EJB, DAO’s.

Preparing documentation for School Bus Tracking Interface.

Designing of the Front-end Screens using JSP.

Involved in Unit Testing and Debugging.

Company: Emagia India Pvt LTD March 2007 – August 2009

Project: Working Capital management

Role: Development

Technology: Java, J2EE, Windows 2000Pro, Oracle 10g, Jboss

Emagia Cash Inflow Manager: Cash Inflow Manager is the leading Collections, Credit and Deductions Management Solution from Emagia. Through a simple browser-based user-interface, this product provides information access to collectors and credit managers from any location around the globe to track and record collections activities with any customer

Roles & Responsibilities

Worked as a Software Engineer with Emagia India Pvt Ltd, a product development company

with its core area of expertise being Working Capital Management.

Involved in developing the Working Capital Management Suite by understanding the requirements, enhancements.

As part of the development was involved in developing screens which are displayed depending on the preferences set in the security screen.

Setting up of Environment on remote machines for Jboss, Tomcat and Sun One Appservers. Configuring and deploying the ECIM 4.3.1 Application on the servers.

Loading data on remote machine and setting the Time for data loading

Exploring on OpenJPA API and handled Performance related activities.

Involved in understanding the functionality of Coreguard Security Server Application.

Writing Test Scripts using Selenium testing tool.

System Experience

Test management and Defect management tools:

TFS – Expert

JIRA - Expert

Quality Center – Expert

QTP – Intermediate.

CONRTOL M – Project Experience

ADLS – Project Experience

MS Azure – Project Experience

Databases:

MySQL

ORACLE SQL Developer

SSISDB

Education

Masters in Computer Applications

Osmania university

Bachelors in Computer Applications

Osmania University

Contact this candidate