SABAREESH S.G

EMAIL: adzsr7@r.postjobfree.com

MOBILE: +91-843*******

Career Objective:

Around 4 years of work experience in End-to-End Testing (ETL TESTING, SQL. API. INFORMATICA, Manual Testing, Automation (Python) in Banking Domain.

Having experience in writing complex SQL queries using Joins, set operators, sub-query, Pseudo- column, group function, analytical function.

Well-versed in execution of Functional Test Cases on the basis of use case documents, business requirements, technical specifications, user story descriptions.

Hands-on experience in JIRA.

Hands on experience in SQL

Hands on experience in Python

Significant experience in Software Testing Lifecycle and Defect lifecycle including Test data analysis, setup, Test case Development, Test Case Review and Test Execution.

Hands on experience in Informatica.

Good explore in Agile, Waterfall Methodology.

Sound knowledge of manual testing, SDLC, STLC, Defect life cycle, Bug Reporting and Tracking, End to End Operations of the testing phase.

Strong skills in performing Regression Tests, Functional Testing and GUI Tests.

Good verbal and written communication skills.

EMPLOYMENT PROFILE

Working as a Senior Tester at TEKsystems from June 2023 to Till Date

Worked as a Software Tester at Hexaware from Aug 2019 to Sep 2022

Skills Summary

Programming Languages

ETL Testing, SQL, UNIX, Manual Testing, API (Postman), Python (Automation)

Operating System / ERP Version

Windows XP

Tools /DB/Packages / Framework / ERP Components

JIRA

PROJECT: 1:

Project 1

Project Name

Cash Management System (Banking)

Team Size

12

Project Description

CMS Cash Management System product is offered by Heritage Bank to provide an automatic solution to perform pooling and sweeping. Customer takes advantage of their funds in different accounts, within the country or in the region as a whole. Customer can earn interest at higher rate by grouping accounts balance together. Customer can reduce the overdraft interest by offsetting any overdrafts by other participating accounts with credit balances. Computation of interest, reallocation of interest and generation of MIS reports

Role & Contribution

Involved in resolving production problems for the applications and ensure all support service level agreements are met.

Monitoring day-to-day process for different data loads and resolving issues.

Provide support for application build and releases and Monitoring performance and resources on server.

Involving in job Monitoring task with help of Autosys and identify the failures issue and rectify with in the SLA.

Working in sql developer tool for generating the user report and monitoring EOD reports and SOD reports.

Connecting UNIX server from windows by using Putty tool

Understanding Requirements and Raising Clarifications.

Test case designing.

Preparation of Test Data for an application.

Preparation of Test Scripts and Executing Test scripts.

Technology &Tools

ETL TESING, SQL, Manual Testing, API(Postman), Python

Project 2

Project Name

Online transaction (Banking)

Team Size

8

Project Description

The project has been developed to deal with all the internal banking Operations and the external Customer’s services. The integrated banking Automation system is designed to handle the head office and the branch office transactions. At head office the project deals with employee’s personal information, employees pay roll system, describing the policies related to customers’ accounts opening / closing, the advances to its customers, bank reconciliation. The branch office transaction deals with the opening of accounts /closing / with drawls and the deposits. The branches are able to give the advances on their limits. Branch office contains demand deposits, term deposits, advances, services, accounts, admin, communication, and modules.and ideas for starters and plenaries.

Role & Contribution

Understanding Requirements and Raising Clarifications.

Test case designing.

Preparation of Test Data for an application.

Preparation of Test Scripts and Executing Test scripts.

Raising the Defect in JIRA.

Performed Regression /Exploratory/System testing.

Participated in Test script walkthrough and Review.

Technology &Tools

SQL, Manual Testing,

Project #3

Project Title : AVIVA Warehouse System

Client : AVIVA, UK

Environment : SQL. Manual Testing

Description:

AVIVA National Life Insurance is a life Insurance Product that consists of modules like new Business, policy services, Re-insurance Agency, Moment, Client data bank, and Accounts. New business is a business brought by the agent and his business is called a Proposal. Proposals will be approved by underwriters to convert into a policy. These underwriters check for all the eligible criteria like Clients annual income, age, health, etc along with this proposal needs more amount of money in suspense to convert into a policy. This includes internal and external funds maintenance for the injurer. Agency module maintains all the details about individual and company agent. Moment module maintains all the modification details of the insurer

Responsibilities:

Involved in functional study of the application.

Running the Jobs/Workflow for ETL process.

Prepared and ran sql queries to verify Dimensional and Fact tables.

Verifying the data in target database after ETL process.

Performed column data mapping between source & target database.

Prepared Test Cases for the Validating the data.

Prepared test data for testing.

Verifying the data which is loaded into target database.

Contact this candidate