BASAVARAJ Kori

Project: DTP Data delivery

Client: CBA(Common wealth Bank Of Australia).

Environment: Teradata, Oracle SQL, OMNIA, GIT Bash

Description:

• The Commonwealth Bank (the Group) is one of Australia's leading providers of integrated financial services including, retail , premium , business and institutional banking, funds management, superannuation, insurance, and investment and Sharebroking products and services.

Roles & Responsibilities:

Requirement analysis for business data.

· Developed complex SQL queries for querying data against different data base

system for data verification process

· Preparing developing data according to business requirement in Development environment.

Transfer the data from Different Sources to DIL & OBL development environment in OMNIA

· Identified Base table help on the Get Hub, OMNIA ,

· Identified Business requirement Attributes help with Teradata SQL Build the SQL logics and Develop the GitBash Code

· First stage of testing part of Developer Test Manage By JIRA . Tracking on GDW Dev And all Records managing By Master sheet of Excel.

Project Name : B2C CAD Digital Project

Client : Saudi Telecom

Environment : Ab Initio GDE, Express>IT, Tara data, Oracle SQL,Unix

Description:

Saudi Telecommunication Company (STC) was established as a Saudi joint stock company on April 21, 1998 and began operations of Telecommunications services throughout Saudi Arabia om May 2,1998 as a wholly owned entity of the government of Saudi Arabic.

Roles & Responsibilities:

· Requirement analysis for business data.

· Designed, developed AB Initio graphs for loading into data store

· Wide usage of lookup Files while getting data from multiple sources and size of the data is limited

· Translating the logical data model to physical database design

· Create sandbox and edited sandbox parameters according to repository

· Developed Ab Initio graphs to unload required data from database

· Extensively worked under the Unix environment using shell scripts,. Responsible for writing the Unix scripts to invoke the deployed Ab Initio Graphs

· Mapping for the required data into target table in Express>IT tool using logic build filtering records

· Prepared SQL scripts for extraction of data and Prepared Unix scripts to run HRXML