OBJECTIVE

My career objective is to be a part of a growth-oriented organization that offers

a challenging position so that I can utilize and add significant value to my engineering skills, in turn make positive contribution towards the development of organization.

PROFILE SUMMARY

Motivated, Enthusiastic & Skilled Associate with almost 5 years of experience at Cognizant Technology Solutions.

4 years of extensive knowledge of DW/ETL Testing in the BFS Domain and 1 year of experience in Functional testing of Oracle apps and web apps.

Dynamic team player who is consistently motivated towards success and completion of the projects with in timelines with an ability to work independently as well as part of the larger team.

Proven ability to deliver quality results in a busy and dynamic business focused environment.

Excellent ability to prioritize tasks and manage time attributes.

Led a team of 3 people.

Experience in preparing test artifacts like Test summary report, Weekly status report, Daily status reports, Test estimation and Testing metrics.

Experience in all phases of Software Testing life cycle including requirements gathering, project planning, testing, defect tracking, management and reporting.

Ability to analyse Business Requirement document, HLD and LLD.

Experience in testing complete application from source to target which includes heterogeneous sources, data warehouse tables, data mart and reports.

Hands-on experience on Oracle apps, Microstrategy, Business Objects, Informetica, SQL, Netezza, DB2, Sybase DB, Oracle DB, mainframe, UNIX / Linux, PLATINUM, Test Management Tool ALM 12.01/QC,Jira and project management tool RTC for projects.

Experience in working with huge volumes of data and analysing record sets for Data Quality, Data Validation and Metrics using SQL.

Experience in working waterfall, pure agile, Kanban, scrum project processes.

Experience of writing test cases in cucumber feature format for automation and execute them using intellij.

Familiar with Python.

TECHNOLOGY PROFICIENCY AND AWARENESS

Data Validation Tool : Platinum, Synchronizer, Beyond Compare Test Management Tools : HP ALM/QC, Jira

Project Management Tool : RTC

Project process : Waterfall, Agile, Kanban

Languages : C, SQL, Python

Database : Oracle 12.6, Sybase ASE 2.1, DB2 11.0,

Netezza 7.2 & SAP Hana

ETL Tool : Informatica Power Center 9.6

Reporting Tools : Business Objects, Micro strategy Personal Info:

PERSONAL INFO:

Phone: +91-797-***-****

Email ID:

adgv35@r.postjobfree.com

Address:

Parande Nagar,Pune India.

Mother Tongue: Marathi

Languages:

English

Marathi

Hindi

Kanada

PERSONAL SKILLS:

Hard working and Sincere.

Solving Problems under

Pressure.

Conscious of duties and

responsibilities.

Motivated to learn new

skills.

Self-starter, initiative.

TECHNICAL SKILLS:

Oracle apps

ETL/Report testing

Functional Testing

Business Objects

Microstrategy

SQL

ESP

Informetica

UNIX/LINUX

HP ALM/QC

RTC

YUGANDHARA BELAGI

Sr. Test Analyst

PROJECTS WORKED UNDER

Client Reputed Bank in USA

Work

Location

Chennai, Tamil Nadu

Duration October 2015 – September 2017

Tools Netezza, UNIX, DB2, SAP HANA, SQL, Mainframe, Platinum, ALM 12.01, Informatica, IBM data studio, Microstrategy

Projects and

their Abstract

Lending Process Servicing

Replacement of Legacy system with an Automated system that caters to loans originations, servicing as well as reporting functions & processes out-of-box. It includes Custom extracts’ generation similar to MicroStrategy Reports. Data Standardization and Validation for seamless consumption of downstream

(business and reporting) consumption from source (Servicing and Load Administration) Data Acquisition

Involves Informatica Power Exchange to read data from about 120 diverse Source System data to produce the full transaction data file and control file at a pre-specified mount point. This enables the sharing files between multiple systems without the need of physical file transfer. Another Informatica process reads and loads files “as is” into SAP HANA. Liqudity risk management

In order to deliver the reports to federal bank, account will build a simplified cash flow engine and implement an automated SAP risk management system that will be utilizes daily LCR system, in order to make that determination system will generate a daily extract containing information on all active collaterals attached to the commercial loans and the identification of which one to report will be done by the team.

System Upgrade Phase-I and Phase-II

Automation of the existing manual process by upgrading the current process to a newer system. Phase-I- SQL to Oracle

Phase-II-V5.01 to V6.0

CTR Address Doctor

Includes validation of the Informatica’s in built feature of validating the addresses. Mortgage Lending

Automation of reports and providing different levels of aggregation to correspondent lending business users to able to determine opportunities for maximizing profit through pricing reports. Availability of reports at centralized location to run on user demand, tracking of mortgage loans that account is purchasing/funding.

ROLES AND RESPONSIBILITIES:

Understood the client requirements by business requirement document.

Developed and executed test scenarios and test cases to ensure product meets functional and design specifications/requirements provided by client.

Validated extracts with complex logic to satisfy all the requirements for the extracts.

Verified the Data movements from Source File to target database (i.e.) Data Integrity checks, Data Accuracy and Data Completeness validation, error-handling logic, validation on the data loaded and ensured that the data is complete, accurate, and reliable.

Reported product bugs, verified fixed bugs and provided resolutions on issues.

Managed defect resolution (lifecycle) using HP ALM.

Performed sanity testing, smoke testing, Integration Testing, Regression Testing and System Testing.

Prepared and transmitted the Weekly Status Report and Daily status report to all the stake holders, by providing the information on completed modules and the pending modules / in progress modules.

Interacted with business & Development teams to resolve the issues on daily/weekly basis.

Attended weekly client calls to provide the project status.

Coordinated with On-site coordinator team.

Conducted technical & project knowledge transfer sessions for new team members. Client Reputed Bank in USA

Work

Location

Pune, Maharashtra.

Duration October 2017 – Present

Tools Toad for Oracle DB, Business Objects, RTC, Intellij, git, Toad for Sybase, Synchronizer, Squirrel, Oracle SQL developer

Projects and

their Abstract

Real Estate App enhancement:

Adding few new features to the existing application in order to make the application more user friendly.

Oracle financials

Creating the system, which can reduce the number of errors/failures while closing the real estate funds, proving status, error message, which include resolution steps to user directly who will initiate the closing process, reduce the wait time for closing the funds and providing its status.

Real Assets Maintenance and Support

Enhancement of real asset application functionalities based on the business requirements and system upgrades. Additionally, develop the oracle reports and Business Object reports that helps user to retrieve the required data from oracle application and the other interlinked real asset applications to oracle application.

Datawarehouse, Enterprise Servicing Platform:

Migration of legacy system to new system as per business requirement. ROLES AND RESPONSIBILITIES:

Understood client requirements from the story acceptance criteria written by business user.

Developed test scenarios and test cases in cucumber feature format to ensure product meets functional and design specifications/requirements provided by client/business user.

Provided formal walkthrough of the written test cases to stakeholders in order to understand the requirement gaps.

Executed functional test cases.

Reported product bugs, bug isolation, verifying fixed bugs and issue resolution.

Provided formal sign off on executed stories.

Prepared QA release documents and send for the approvals.

Created RTC work items (task, impediment, defects) and keep it up to date as per current work status.

Attended daily stand-up call, retrospective meetings, and project kick off meetings. EDUCATIONAL QUALIFICATION

Exam Passed Year School/College Board/Univers

ity

CGPA/Percenta

BE(E&TC) 2014 BMIT, Solapur Solapur ge 77% HSC 2010 Dayanand Junior College, Solapur Pune 75% SSC 2008 Umabai Shravika School, Solapur Pune 89%

ACADEMIC PROJECT

BE: Project entitled "Development of Android Based Appliances Controlling System" in BMIT Solapur, Solapur university.

CO-CURRICULAR ACTIVITIES

Published International Level Paper in IJETAE journal.

Presented the National Level Paper on Project.

Attended the National Level Conference on ‘Recent Trades in Embedded System, Communication and VLSI Design’.

Published National Level Paper in IJSER journal.

Successfully passed Elementary and Intermediate grade examinations. REFERANCES

1) Mr. Anish Anand 2) Mrs. Rupangundi Muktavali Naga Cognizant Onsite representative, Test analyst, Associate In now Cognizant Technology Solution In now Cognizant Technology Solution North Carolina, USA Chennai, India

e-mail: adgv35@r.postjobfree.com e-mail: adgv35@r.postjobfree.com Contact No.: +1-336-***-****. Contact No:+91-887****** DECLARATION

I, Yugandhara Belagi, do hereby declare that all the information given above is true to best of my knowledge.

Place: Pune (YUGANDHARA BELGI)

Contact this candidate