Project Developer

SUBHENDU SUNDAR SAHOO

OBIEE DEVELOPER Ph.

No: +91-953*******

E-mail: *****.**************@*****.***

* ********** *******

3.8 years of experience in the IT industry and extensive experience

in analysis & design, coding, development, implementation and maintenance

of business technology solutions for various business and customer

applications.

> 2.5 Years of Experience in Full System Development Life-Cycle

Implementation of various OBIEE and Siebel Analytics Projects

> Expertise in Configuring Repository and Create/Manage Dashboards,

Reports/Answers

> Created Users, Groups and giving the permissions in Administration

Tool and verified the permissions of the users in the OBI domain

> Proficient in Merging/Importing Objects from Different Repositories

using OBI Admin Tool

> Experience in Creating Dimensional Hierarchies, Level Based

Measures. Time series Functions, Initialization Blocks and Variables

depending upon the need for Business Reports using the OBIEE Admin

tool.

> Knowledge in Scheduler setup and iBot Configurations for delivering

reports using Oracle BI Delivers component of OBIEE.

> Ability to rapidly learn new concepts together with excellent

interpersonal skills.

> Excellent skills in understanding business needs and converting them

into technical solutions.

> Excellent problem solving skills with a strong technical background

and result oriented team player with excellent communication and

interpersonal skills.

> Extensively experienced and comprehensively skilful in using various

features/tools of OBIEE Application involving both Repository and

Web Cat.

> Proficient in creating, configuring and managing Dashboards, Reports

and Answers

> Expertise in developing OBIEE repository from the scratch, build

reports/dashboards using OBIEE (OBIEE) Answers.

> Good in working of Physical, BMM and Presentation Layers of Admin

Tool.

> Well versed with Dimensional Modeling like Star and Snowflake

schemas.

> Configure Reports / Dashboards with different Views (Drill-Down,

Pivot Table, Chart, and Column Selector, global and local Filters)

using OBIEE Answers.

> Having good knowledge in Oracle and Informatica.

> Having good experience in DAC&BI publisher.

2 PROFESSIONAL EXPERIENCE

> Currently working as a OBIEE Developer for Wipro, Bangalore from

August 2011 to till date.

> Worked as a Senior Specialist with CEGEDIM INDIA SOFTWARE PVT.LTD,

Bangalore from July 2010 to June 2011 .

> Worked as a Software Engineer with Belkintechnologies, Bangalore

from Nov 2008 to Jan 2010

3 TECHNOLOGY EXPERIENCE

|Reporting/BI Tools|OBIEE 11.1.1.5, 10.1.3.4, BI PUBLISHER, DAC, |

| |Xtelligence. |

|Database |Oracle 8i, 9i,10g and 11g |

|Database Languages|Sql,Pl/sql |

|Etl Tools |Informatica,Comodo |

|Scripting |Unix, Shell Scripting |

|Tools |SQL*Plus, Toad, Pl/Sql Developer. |

|Operating System |Windows NT 4.0/XP/2000 Professional, Unix |

4 EDUCATION SUMMARY

|Degree |Institute |Percentage |

|MCA |Biju Patanaik University of|76 |

| |Technology, Orissa | |

Experience Profile-Key Projects

|Project #1 |APEX |

|Client Name |Cadbury,AUSTRALIA |

|Technolgy Used |Obiee 11.1.1.5,Informatica 8.6,Oracle 1og(sql) |

|Position |OBIEE DEVELOPER |

|Team Size |6 |

|Duration |Feb-12 to Till date |

|Project |The consumer goods Cadbury consists of the group of |

|Description |companies that manufacture and sell consumer goods products |

| |as well as the account customers to whom they sell. These |

| |products may include food PREMIUM, MINTS, Medicines, GUM and|

| |etc. Account customers in this industry include retailers |

| |and wholesalers who sell to each other and to consumers. |

| |For day-to-day business operations, consumer goods companies|

| |use general business processes that fall across industries |

| |such as sales, marketing, and order management. They also |

| |use business processes that are specific to the industry |

| |such as trade promotions, trade planning, and trade |

| |budgeting. |

|Role Description|Installed and configured OBIEE Admin tool and web components|

| |including Intelligence Dashboards, answers, and requests. |

| |Used admin tool to creation of repositories by using |

| |physical layer, business model and mapping layer and |

| |presentation layers. |

| |Worked on BMM layer to customize the tables, hierarchies, |

| |dimensions and aggregations and calculations. |

| |Tested and validated the unit test cases |

| |Organized and customized the presentation layer in a format |

| |that is easy for end user to use as basis for reporting |

| |Worked on creation of repository variables and session |

| |variables. |

| |Worked with the Security settings in OBIEE Admin Tool to set|

| |up users, groups, access privileges. |

| |Designed and developed interactive navigational drill down |

| |reports in OBIEE Answers, requests and Intelligence |

| |Dashboards using various reporting features and |

| |functionalities such as formulas, filters, charts, pivot |

| |tables. |

| |Using the Presentation Variable in prompts Report filters. |

|Project #2 |Budgeting, forecasting and reporting application |

|Client Name |B.T(UK) |

|Technology Used |OBIEE 10.1.3.4.1, Oracle 10g,unix |

|Position |Obiee Developer |

|Team Size |4 |

|Duration |Sep-11 to Feb-12 |

|Project | The main purpose of data warehouse is to provide supporting|

|Description |details and monthly activities and balances. The data |

| |warehouse contains of a wealth of historic information about|

| |the clients, their households, credit information, their |

| |account activity and their relationship with bank. This |

| |project was developed to aid and assist management committee|

| |in making various decisions regarding customers, planning |

| |and budgeting and maintaining customer details, automatic |

| |interest calculations, query and analysis thus helped in |

| |understanding customer base as well as the ability to |

| |provide their customer relationship managers with |

| |meaningful, actionable information that impacts their |

| |decision-making process. OBIEE was used to build a scalable,|

| |self-service enterprise-reporting environment. |

|Role Description|Partnered with the OBIEE team in gathering and analyzing |

| |business requirements from various sources, ensuring the |

| |business needs and delivery feasibility. |

| |Worked with the ETL team to design the Star Schema and |

| |populate the Data warehouse. |

| |Built the Physical Layer /Business Model and Mapping Layer/ |

| |Presentation Layer of a Repository by using Star Schemas. |

| |Involved in creating Dashboards for the reports also using |

| |Guided Navigation and Links. |

| |Configured Web Catalog Objects (Dashboards, Pages, Folders |

| |and Reports) and Implemented different views of report i.e. |

| |Pivot table, Titles, Graph, Filters etc. |

| |Created Users, Groups and giving the permissions in |

| |Administration Tool and verified the permissions of the |

| |users in the OBI domain |

| |Involved in Performance Tuning of reports by identifying the|

| |indexes required on the backend tables and also from the |

| |data available in the Cache. |

| |Designed Interactive Dashboards and created dashboard |

| |prompts with multiple selections. |

| |Integrated reports created in Oracle BI Publisher with |

| |Oracle Business Intelligence Enterprise Edition. |

|Project #3 |DSI SANKYO |

|Client Name |Galderma, FRANCE |

|Technology used |Oracle 10G(Sql,PL Sql),Komodo,Mi5.3,Sequoia,Sibel Analytics |

|Position |Team Member |

|Team Size |6 |

|Duration |Sep-10 to Apr-11 |

|Project |This project is mainly based on Single-tenant architecture |

|Description |and deals with database migration process. This project uses|

| |the MOBILE INTELLIGENCE(MI5.3)(Product of Cegedim Dendrite) |

| |which is a comprehensive, web-enabled product suite that |

| |improves communications, optimizes promotional |

| |activities,and streamlines new product launches of |

| |pharmaceutical companies. It provides sales forces with a |

| |single, centralized location from which to access product |

| |information, evaluate competitors, record and catalogue |

| |client and prospect data, and access physician databases. It|

| |also uses ETL tool KOMODO for import and export process. |

|Role Description|In this project I have done data extraction, import and |

| |export jobs through several interfaces which includes the |

| |following tasks. |

| |Created triggers, developed functions, complex queries, |

| |stored procedures, packages, indexes, views etc. |

| |Responsible for PL/SQL coding for KOMODO(ETL) module for |

| |exporting the production data into a flat file. |

| |Performed database tuning using indexes,passing hints, using|

| |parallel option,Tkprof, Explain Plan etc. |

|Project #4 |Farmers bank welfare System(FBWS) |

|Client Name |Viacom(USA) |

|Technolgy Used |Oracle 9i(Sql,PL/Sql),Informatica |

|Position |Oracle Developer |

|Team Size |7 |

|Duration |Dec-08 to Jan-10 |

|Project | The Farmers Bank Welfare System is to implement easy |

|Description |transactions for farmers so that farmer need not approach |

| |the mediator to sell their crop production and they can get |

| |back loans from any bank, anywhere within the country. This |

| |system helps to sell their crop production directly to |

| |government and the amount is directly transfer to their |

| |accounts without any commission (without the mediator), |

| |farmer can get personal loans with help of this system(all |

| |details of farmers are include in the database, like their |

| |land details, financial status and their loan status in |

| |other banks.) |

|Role Description|Proper analysis of any problem occur should be done, |

| |otherwise it will create impact on another region / module. |

| |Need to perform simulation of any problem come, then to |

| |check the impact and proper fix will be provided. |

| |Involved in unix testing |

. PERSONAL DETAILS

|Gender |Male |

|Marital Status |Unmarried |

|Nationality |Indian |

|Language Known |English,Hindi,Oriya |

|Interest |Net Browsing, Playing Cricket |

|Passport |Avalliable |

[pic]

1

Contact this candidate