Sr Developer & Analyst

Rajesh Babu . B Email: **************@*****.***

Mobile No:+91-988*******

Professional Summary

Around 2 years experience in Information Technology and in Oracle Business Intelligence 10.1.3.2 – 10.1.3.4.X in Repository, Answers Dashboards, Delivers and Security

Implemented Oracle Business Intelligence Enterprise & Stand Alone Editions

Expertise in developing all 3 layers of the Analytics Repository (Physical Layer, Business Model & Mapping and Presentation Layer), RPD Development with Dimensions, Drill-down, Hierarchies, Measures, Aggregation Rules, Time Series, Cache Management

In-depth knowledge in Repository & OBI Architecture & Front End UI development

Exposure to Insurance, Healthcare, Industrial sectors and business with regard to data ware house development

Employment History

Working as a OBIEE Developer in Sristek Consulting Pvt.ltd, Hyderabad, from August’09 to Till Date

Educational Background

B Tech Electronics & Communication engineering from JNT University, Kakinada in 2009.

Technical Skills

OBIEE OBIEE 10.1.3.2 & 10.1.3.4.X

Databases Oracle 8I/9I/10G

ETL Informatica 7.1/8.X

Operating systems Windows XP/2000/2003, Linux, UNIX

GUI Tools Toad, SQL Developer, SQL Loader

OBIEE– Technical Expertise

Expertise in creating Business / Technical Design documentation for Business Analytics

Expert in developing RPD layers – Physical, BMM & the Presentation Layer

Expertise in configuring Standalone Security Tables & also creating Users / Groups / Setting privileges using Session Variables

Experience in Metadata Modeling at all three layers (Physical, Business Model and Presentation) using the Oracle BI Administration Tool.

Hands on experience in developing multiple Dashboards / Reports & ibots

Created reports under various Dashboards

Expertise in loading data from multiple sources like Flat Files / Relational Databases

Used Informatica Designer (Source Analyzer, Warehouse Designer, Mapping Designer) to develop mappings for extracting, transforming, integrating and loading data to target

PROFESSIONAL EXPERIENCE:

Project

Sristek Consulting Pvt.Ltd, Hyderabad.

OBIEE Developer

Description:

The objective of this project was to implement a centralized database that collects and organizes opportunity data to provide a single source of integrated current and historical trials data for the purpose of end user reporting, analysis and decision support. The project involved extracting data stored in different databases such as Oracle to load finally into the data warehouse repository. The data used for generating reports was sourced from Oracle and flat files using Informatica. The reports were generated and delivered to users using Oracle Business Intelligence.

Responsibilities:

Understanding requirements and customizing the Repository to meet the requirements.

Created Technical Design Documents of the Application.

Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBI Administration Tool.

Identified various Dimensional Hierarchies and level based measures for several Dimension tables during Discovery Phase.

Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.

Responsible for controlling user access assigning Oracle BI Responsibilities.

Developed custom reports/Ad-hoc queries using OBI Answers and Filters.

Created several complex reports and prompts with navigation capabilities and used them in creating dashboards.

Used customized sub-filters, Dashboard Prompts, & local prompts on UI /SAW.

Customized Mappings and used Aliases in Physical Layer.

Used Session Variables in report calculations and Security implementation.

Developed Test execution and Defects Dashboards .Created custom reports using Answers and assigned them to application specific dashboards.

Responsible for Unit Testing and Performed Data Validation for all the reports that are generated from OBI.

Environment: Oracle Business Intelligence 10.1.3.3.2, Oracle and Microsoft Windows XP.

Project

Techno Wingz, Hyderabad

(Academic Project)

Description:

This Project covers purchase of computer peripherals, sales of computers and different IT products, stock maintenance, stores, payroll, and accounts. The project involved extracting data stored from flat files and Oracle database and load finally into the data warehouse repository. Here we generate various types of reports like purchase reports, sales analysis reports, stock position reports and various reports on payroll and accountancy.

Responsibilities:

Used Informatica Designer Tools such as Source Analyzer and Warehouse Designer to create source definitions and to create target definitions.

Created Sessions and Work flows using Workflow Manager.

Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBI Administration Tool

Developed Dimensional hierarchies at different levels.

Created Aggregate tables which store pre computed results.

Configured charts, pivot table views, narrative Views, filters in user interface.

Created Dashboard prompts using different filters.

Environment: Oracle Business Intelligence 10.1.3.3.3, Informatica 7.1, Oracle and Microsoft Windows XP.

PERSONAL PROFILE

Name : B.Rajesh Babu.

Father’s Name : Mr. Baburao.B

Date of Birth : 28th June, 1988

Sex : Male

Nationality : Indian

Languages known : Telugu, English, Hindi

Permanent Address : Ews-233,3rd Line, KPHB Colony, Hyderabad.

DECLARATION:

I Hereby Declare That All The Information Furnished Above Are True And Correct To The Best of My Knowledge.

Date:

Place: Hyderabad (B Rajesh Babu)

Contact this candidate