Current Location: Scottsdale, AZ

Ritu Singh Thakur

● 8 years of experience in Software Quality Assurance Analyst. Strong understanding of various phases of software development life cycles and has ability to understand the business model and client requirements.

● Good experience in testing SOA, waterfall and Agile environments.

● Have experience in maintaining and enhancing Shell scripts used for Job Monitoring.

● Have good experience in creating test data and to verify the test conditions and test cases.

● Worked in second line production support to fix the data correction issues in SQL by directly interacting with various clients.

● Experienced in User Acceptance Testing.

● Have experience in Analysis of Software Requirement Specifications and development of Test Scripts, Test scenarios, Test Cases based on the Requirement Specifications.

● Involved in all phases of testing such as Smoke Test, Functional Testing, Integration Testing, System

Testing, Regression Testing, Security Testing, UAT and ad-hoc testing.

● Executed Test scenarios and business process test cases to verify the design and functionality of applications as per user requirements

● Have good experience in preparation of TRM (Traceability Matrix), Release/ Defect Matrices.

● Good knowledge on SDLC, Test Life cycle, Test methodologies like Agile & Scrum.

● Held the lead position for Application Support Team and contributed knowledge to my team members.

● Worked with various clients to resolve business impact data correction issues in backend.

● Excellent interpersonal, communication and presentation skills.

Work Experience

Bank of the West, Phoenix, AZ

Jan 2017 – Till Now

Sr. QA Analyst

Bank of the West is a leading bank in USA which provides financial services to individual, retail and commercial banking services for consumers, small/mid-sized companies and Home Loan. I am working as a Quality Assurance Analyst in Home Loan Mortgage Process & Consumer Lending Project

Responsibilities:

Worked closely with Business Analysts and Developers to fill the gaps in the requirements

Developed all test scenarios and test cases for Inventory Management initiative

Analyzed available business requirements and functional requirements specification document

Write the SQL queries to validation data .

Queried the Oracle database to verify the data consistency.

Reviewed the proposed model with the Subject Matter Experts from business, Quality Assurance (QA) and IT departments

Performed Smoke testing, Black box testing, Grey box testing, Functional testing, System testing, Integration testing, Back end, User Acceptance and Regression testing

Analyzed the business and technical requirements, developed Test Strategy document & Test Plan

Developed Requirement Traceability Matrix (RTM) to trace requirements

Worked with Retesting and Regression testing

Carried out Sanity Tests and executed test cases for GUI, Functionality, Positive / Negative testing

Authored test cases and completed unit, integration and system tests for data warehouse.

Verified the uploading of requirements and test cases to MTM and ensured that the appropriate modifications are enacted based on the requirements change requests

Worked in TFS for planning, running and tracking defects

Verified and validated system to manage requirements quality metrics and ensure test coverage and defect traceability with Microsoft TFS

Imported and Exported data from Microsoft Excel and Microsoft Word to TFS / MTM

Performed Back-End testing by writing and using SQL queries

Developed and maintained Function Libraries, Object repositories and Descriptive

Involved in performing UAT (User Acceptance Testing)

Executed and analyzed various queries and creating reports

Communicated with support, business and development teams to resolve issues

Participated in QA reviews and implementation of processes and procedures improvements

Sr. QA Analyst

HCL (Offshore)

August 2014 to June 2016

The Alcatel-Lucent 9353 Wireless Management System (9353 WMS) enables network administrators to manage Alcatel-Lucent W-CDMA/HSPA access network equipment and additionally, some ATM-based infrastructure. This system is carrier-grade, and can be combined with other wireless-aware specialized applications for example the Alcatel-Lucent 9352 WPS and the Alcatel-Lucent 9359 NPO.

Responsibilities:

Involved in creation of detailed test plan and test cases from the Business Requirements Document.

Involved in creation of Hive database External tables to store the processed data from Map Reduce.

Involved in reloading of corrected data into Hive tables through Hive and UNIX Scripts.

Involved in testing of source and target data base count by using the SQL queries.

Involved in creation of test data by using the Business Requirement Document.

Created hive tables, loaded data into hive tables, and extraction.

Involved in CI testing to test the build and creation of database.

Involved in UAT of the Application by providing users with test cases and scenarios and guiding them during the testing process.

Involved in testing of source and target data base count by using the SQL queries.

Involved in preparation of weekly status reports and status meetings.

Logged defects in defect tracking tool.

Conducted User acceptance testing to ensure that developed system satisfied the needs of business clients as specified in the functional requirements.

Lead Engineer

Alcatel Lucent (Offshore) August 2011 to July 2014

The Alcatel-Lucent OmniVista 4760 and 8770 Network Management System called (Omni VistA 8770)

Is a set of management applications which provides centralized management for network PCXs such as OmniPCX Enterprises(OXE) and Open Touch(OT). The OmniVista 8770, built on client-server architecture,

runs on a Windows platform.

The Unified User Management application is part of the Alcatel-Lucent OmniVista 8770.

Network Management System This application allows to simplify user configuration. It provides access to parameters allowing to:

- Configure users from one single interface. This avoids having to configure users in several distinct interfaces, such as PCX, technical directory and company directory of Alcatel-Lucent OmniVista 8770

Network Management System. Directories and PCX are automatically updated with the user data configured in the UUM application.

Responsibilities:

Worked as Lead Engineer and contributed the product knowledge among the team members.

Involved in customer support to analyze issues in backend by interacting directly with clients.

Written Test cases for requirements for enhancements

Written test scenarios and documented the test result as they are executed.

Performed User Interface Testing, Integration Testing, System Testing & UAT.

Logging and keeping in track of defects.

Involved in Automation Test Plan Preparation.

Test Scripts generated using QTP.

Performed Database Testing using SQL queries in order to check the Data Validation and Data

Integrity.

Environment: C#.Net, .Net Framework, SQL Server2005/2008, Windows 2000/XP, MS Visual Studio

2005/2008.

Software Test Engineer

Alcatel-Lucent (Offshore) February 2010 to August 2011

EVDO (Evolution Data Optimization) is a web based software developed in Linux, Ruby and ROR. This has to provide high speed data service for traditional wide area wireless users by creating a physical path between receiving and sending data. And software has to track its performance data and displayed through

HTML tables on hourly basis.

Main aim of this project is testing the functionality of the all modules manually and validating the data in backend.

Responsibilities:

Worked as a Software Test Engineer and involved in creation of Test plans, Test Strategy & Test

Scenarios and Test Scripts by using the mapping documents.

Involved in gathering, analysis of requirements and review meetings.

Worked closely with the developers on review and resolution of issues.

Involved in testing the data in backend by using the joins.

Prepared traceability matrix.

Involved in finding the root cause analysis of identified defects.

Logging the bugs into defect tracking tool.

Prepared status report and send them to managers on weekly basis.

Involved in the defect tracking meetings.

Implemented the QA process to the new QA team.

Involved in code review and bug review meetings.

Involved in User Acceptance Testing.

Environment: Ruby ROR, Quality Center 9.0, QTP 10.0, Windows XP, UNIX Alcatel-Lucen

Software Engineer Alcatel-Lucent (Offshore) February 2010 to July 2011

Project GSMART

This is web based software developed in C++, Ruby and ROR. Using this software user can view network details over a LAN using web based UIs. Performance management tools which shows network health on daily and hourly basis. The information is displayed in HTML tables and also in a GIS based tool which shows details on GE Plugin in web browser.

Responsibilities:

Involved in creation of detailed test plan and test cases from the Business Requirements Document.

Involved in creation of test data by using the Business Requirement Document.

Involved in white box testing to test the maps.

Importing the maps to Informatica and extracting the data by running the sessions.

Involved in validation of transformations, aggregations and look ups.

Involved in loading of data into database through UNIX.

Involved in validation of XMLs and HTML.

Written several complex SQL queries for validating the migrated data.

Checked the performance of the SQL server by loading huge amount of data.

Environment: Java Script, Quality Center 9.0, Oracle 9i, UNIX.

Education

Bachelors in Chemical Engineering

Pandit Ravishankar Shukla University

Skills

TESTING, DATABASE, SQL, UNIX, .NET

Additional Information

TECHNICAL SKILLS: Testing Tools

● HP ALM 12,5

● Jira

● Test Director 8.0

● Quality Center 8.2/10.0

● Jenkins

● Clear Quest

Languages

● SQL*Plus

● VB, .Net

● XML/HTML

Database Technologies

● MS Access

● HIVE

● Oracle 8i/9i

Oracle SQL developer 1.1.3

● MS SQL Server 2000/2005

Operating Systems

● Windows 2003/2000/XP

● UNIX

● Ubuntu

Contact this candidate