ODI Developer

RAMANA

E-Mail : *******.***@*****.***

Mobile : +91-849*******

Professional Summary:

Having Around 4 years of experience in analysis, design and development in Data warehouse applications.

A solid data warehousing background, with extensive ETL design, development and Reporting skills using ODI and Cognos.

Worked on Technologies like Oracle Data Integrator, OBIEE and Cognos.

Worked with multiple sources such as Relational database, Flat files for Extraction Transforming and Loading data into target tables.

Designed and developed Oracle stored procedures and packages to meet data integration and processing requirements.

ELT design, development, data integration and data migration.

Extensive experience and knowledge of ODI architecture including requirement gathering, analysis, configuration, development, integration, testing and migration.

Having good experience in report development using Cognos10.1.1, Cognos 8.4.1 and Cognos 8.3 (Report Studio, Query Studio, Event Studio and Analysis Studio).

Worked extensively on Cognos Framework Manager for Creating Relational, Dimensionally Modeled Relational (DMR) Model.

Created Unit test cases and written unit test results.

Worked with SQL extensively by using Joins, Sub Queries, Set Operations, functions and advanced OLAP functions.

Worked with Stored Procedures, Functions, Cursors, Packages, and Triggers in PL/SQL.

Strong Knowledge in Data Warehousing concepts.

Knowledge and implementing Star Schema and Snowflake Schema in Decision Support Systems.

Experience in Banking and financial services industry business processes.

Professional Experience:

Organization

Designation

Duration

IBM

Application Developer

June 2011 to Apr 2015

Education Profile :

Master of Computer Applications (MCA) from Andhra University, Vizag in Jun-2008.

Technical Skills :

ETL &Reporting Tools : ODI (Oracle Data Integrator) 11g/12c, Cognos and OBIEE

Data bases : Oracle 11g, DB2

Languages : SQL, PL/SQL

Other Tools & Utilities : SQL Developer, PL/SQL developer

Operating Systems : Windows7, XP, Unix.

Project Experience :

Project Title:

BMO – Quality Systems

Client Name:

Bank Of Montreal (BMO), Canada

Description:

The Loan IQ is a comprehensive commercial lending system that provides both front and back office support. Integrated support is provided during all phases of the deal life cycle, including loan origination, servicing and distribution. Loan IQ records the bank’s entire loan and exposure related credit activity. Most information in Loan IQ relates to customers and/or deals. The customer can be linked to a deal and its facilities.

My Role:

ODI Developer

Responsibilities:

Involved in the work shop to understand the requirements and existing solution.

Developing ODI interfaces in the dimension model as per the data model with fact and dimension load logics.

Development of procedures, models and packages.

Enhancement of ETL code/design, defect fixing- code fixes and data fixes.

CIT plan activities like test case scenarios and test case conditions.

Project Title:

CIBC

Client Name:

Canadian Imperial Bank Of Commerce (Canada).

Description:

CIBC is one of the Canada’s charted Bank, there are some reports are developed in impromptu, by using lift and shift method, we converted the reports into cognos 8.4. There are DSE, DM2, DSE Audit and friendly fraud reports all these reports developed using cognos impromptu by understanding existing business model converting the reports into cognos 8.

My Role:

ODI Developer

Responsibilities:

Involved in the work shop to understand the requirements and existing solution.

Developing ODI interfaces in the dimension model as per the data model with fact and dimension load logics.

Development of procedures, models and packages.

Enhancement of ETL code/design, defect fixing- code fixes and data fixes.

CIT plan activities like test case scenarios and test case conditions.

Project Title:

BIS (Barclays Information Services)

Client Name:

Barclays, UK

Description:

Barclaysis a British multinational banking and financial services company headquartered in London, United Kingdom. It is a universal bank with operations in retail, whole sale and investment banking as well as wealth management, mortgage lending and credit cards. Barclays is organized with in two business clusters corporate and investment banking, wealth and investment management in retail and business banking.

This project will allows providing a customized experience for each customer and it allows you to easily analyze the root causes of denials. Solution involved based on Cognos 8 BI reports.

My Role:

ODI Developer

Responsibilities:

Involved in the work shop to understand the requirements and existing solution.

Developing ODI interfaces in the dimension model as per the data model with fact and dimension load logics.

Development of procedures, models and packages.

Enhancement of ETL code/design, defect fixing- code fixes and data fixes.

CIT plan activities like test case scenarios and test case conditions.

Contact this candidate