Business Analyst/QA

Jagadeswar

ETL Tester Mail: ***********@*****.***

Contact: +91-973******

Professional Summary

Having 3.6 years of experience in ETL Testing and Manual Testing

Experience on Data ware house - ETL testing

Good knowledge in testing Facts and Dimensions Based on mapping logic

Good Exposure to Data Warehousing concepts

Having good knowledge on Database Testing

Working experience with different Transformations

Having good Knowledge on Oracle

Hands on experience in writing database Queries

Hands on experience in TOAD tool

Has testing experience in Informatica Power Center tool.

Expertise in investigation and reporting defects into Defect Tracking Tools – Quality Center.

Hands on experience on writing, reviwing and executing the Test cases.

Ability to work under deadlines, worked as an active team member and willingness to accept responsibilities

Professional Experience

Working as Test Engineer for L&T InfoTech , Bangalore from Nov 09 to till date

Worked as Test Engineer for ISOFT, Bangalore from Dec 07 to Nov 09

Education Qualification

B.Tech (C.S.E) FROM JNT University, Hyderabad

Technical Proficiency

ETL Tools : Informatica

Databases : Oracle 8i &9i.

Languages : C, SQL.

Test Management Tool : Quality Center 9.0

Tools : TOAD, Putty

Operating Systems : Windows XP/2003 Server.

Project 1#

Client : Flowserve

Technologies : Informatica power centre

Database : Oracle 9i

Role : Tester

Project Description:

Flowserve Corporation (Flowserve) is a manufacturer and aftermarket service provider of flow control systems. The Company develops and manufactures precision-engineered flow control equipment, such as pumps, valves and seals, for critical service applications. It produces engineered and industrial pumps, industrial valves, control valves, nuclear valves, valve actuators and precision mechanical seals, and provides a range of related flow management services worldwide, primarily for the process industries. Flowserve Corporation offers a range of aftermarket equipment services, such as installation, advanced diagnostics, repair and retrofitting. The Company operates through three business segments: Flowserve Pump Division (FPD), Flow Control Division (FCD) and Flow Solutions Division (FSD). In June 2006, the Company acquired HydroTechnik Olomouc, s.r.o., a mechanical seal manufacturer based in Olomouc, Czech Republic.

Responsibilities:

Involved in functional study of the application

Running the jobs/Workflows for ETL process

Verifying the ETL data in target database

Prepared high level test Scenarios and Test cases

Prepared test data for functional & Integration testing

Verified column mapping between source and target

Interactions with BA & Dev teams to resolve the issues.

Reporting daily testing status.

Designed, Reviewed & Executed Test cases.

Identified Test cases for Regression testing

Defect Analyzing and Reporting in QC

Project 2#

Project name : Northern Bank

Client : Northern Bank, UK

Technologies : Informatica power centre

Database : Oracle 9i

Role : Tester

Project Description:

Northern bank has four Kinds of data marts such as Accounts, Loans, Credit Cards and Insurance. In loan Data mart this Bank has loan amounts for various purposes like: Personal Loans Educational Loans, Vehicle Loans, Housing Loans, and Consumer Durable Loans etc. The company requires different level of analysis regarding loan amount, type of loans, customers, Payment schedules, interest rates defaulters list and the penal interest calculations, etc. They need to Analyze Business in different locations, According to profit areas, which could serve as a purpose of DSS for decision Maker.

Responsibilities:

Involved in functional study of the application

Running the packages/Workflows for ETL process

Prepared high level test Scenarios and Test cases

Verifying the ETL data in target database

Verified column mapping between source and target

Prepared test data for functional & Integration testing

Interactions with BA & Dev teams to resolve the issues.

Reporting daily testing status.

Designed, Reviewed & Executed Test cases.

Identified Test cases for Regression testing

Defect Analyzing and Reporting in QC

Project 3#

Project name : eHIS

Client : Siriraj hospital, Thailand

Technologies : Informatica power centre

Database : Oracle 9i

Role : Tester

Project Description:

IBA-eHIS is a standard based, state-of-art, comprehensive, integrated and modular information management system for hospitals, addressing all critical areas of health care activity. IBA-eHIS is entirely based on international norms &standards and relies on internationally accepted/ used guidelines & practices.IBA's Health Information System is an advanced, work-flow-driven application that provides hospitals with the capability to integrate patient management, billing and back-office functionality within a single suite of software. IBA Health Information System coordinates patient flow from admission to discharge, incorporating clinical, administrative and financial information.

Responsibilities:

Involved in functional study of the application

Running the jobs/Workflows for ETL process

Verifying the ETL data in target database

Prepared high level test Scenarios and Test cases

Prepared test data for functional & Integration testing

Verified column mapping between source and target

Interactions with BA & Dev teams to resolve the issues.

Reporting daily testing status.

Designed, Reviewed & Executed Test cases.

Identified Test cases for Regression testing

Defect Analyzing and Reporting in QC

Project 4#

Project name : Insurance system

Client : Equitable Insurance

Environment : Manual Testing

Project Description:

The main objective of this project is to register the new vehicles into Insurance system and display the premium dates and renewal dates of vehicles. This project also contains the information about the policy holders’ information. It comes to choosing insurance for your Vehicle. You have many options to compare between the various policies available in our market. It secure against damage caused by natural and man-made calamities, including acts of terrorism. Avail of Own Damage, Personal Accident and Liability cover all in one policy. As each company offers innovative covers, it becomes easier for you to make a decision based on the coverage as well as the premium offered.

This project is used for generate the reports for customer wise. This project very much useful for organization to optimize and centralized their transaction very easily.

Responsibilities:

Understanding the Requirements and Functional specification of the application.

Participated in identifying the test scenarios and designing the test cases.

Prepared and executed test cases as per system requirements.

Designed, Reviewed & Executed Test cases

Identified Test cases for Regression testing

Defect Analyzing and Reporting in QC

Defect and Issues Reporting

Contact this candidate