Project Information Technology

SATHEESH KUMAR. M

Mobile: +91-976******* E-mail:*****************@*****.***

Experience Summary:

Having 4+ years of experience in Information Technology which includes experience in Business Requirement Gatherings, Analysis, Design, Development, Testing and Implementation of Data warehouse/Business Intelligence using OBIEE 10.x, OBIEE 11g, Oracle 9i/10g/11g.

Extensive experience in OBIEE (configuring repository(.rpd), creating Intelligent Dashboards / reports, Answers)

Involved in OBIEE 11g installation.

Creating the Agents and monitoring of Scheduled Briefing books with multiple reports incorporated in it.

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

Strong Experience in configuring Interactive Dashboards with capabilities using global and local Filters, Analytics, Alerts, Security Setup (groups, access privileges), Metadata Objects & Web Catalog Objects (Dashboard, Folders, and Reports).

Experience in managing users and setting up their OBIEE application access in External data base table and configure user access by using session variable in RPD.

Worked on production support for OBIEE applications (Support Central Tickets, Work Requests).

Developed Dashboards, Prompts using OBIEE (Answers) for different subject areas of business, different types including: Drill down, Summary, and Sub-reports.

Having good experience in Siebel Campaign Management, Segmentation and Reporting.

Having Knowledge in Informatica and DAC.

Ability to communicate personally and professionally with clients both verbally and written

Good team worker and has ability to understand and adapt new technology.

Education

M.C.A from Jawaharlal Nehru technological university Hyderabad in 2011

Experience

Currently working as a OBIEE Developer in, Accenture from Aug’ 2014 to Jan’2016.

Worked as a OBIEE Developer in, Wipro Technologies from Aug’ 2011 to Jul’2014.

Technical Skills

Operating Systems

Windows 7/xp/Sun Solaris

Languages

SQL/PLSQL,C, C++.

Databases

SQL Server, Oracle10g/11g

Tools & Utilities

OBIEE 10g and OBIEE 11g,SIEBEL.

TOAD, SQL Developer, IDM tool

Project Profile:

Project – 1

SSE Domestic Customer Support

Client

SSE

Role

OIBEE Developer

Duration

(08/2014-Till date)

Team Size:

6

Module : 1

Environment

(with skill versions)

Software

Database : Oracle 11g,Siebel

OS : windows 7/Sun Solaris

BI Tool : 11.1.1.9.1.

Project Description

SSE is a UK based Utilities company operating in energy generation, distribution and retail. The CS+S programme is reorganized into 2 separate projects: Meter Transformation (MTP), Domestic Customer (DC), starting June 2012. Accenture's current engagement with SSE involves implementing Oracle suite of products for key retail business functions such as CRM (Siebel eEnergy), MWM (Mobile Workforce Management), OBIEE, MDM (Meter Data Management). The project also includes enhancements to their legacy systems in order to align those systems to Oracle's architectural requirements

Roles & Responsibilities:

Supporting for production Issues and Interacting with users and resolving the Support Central Tickets.

Down and up the OBIEE Dev and Stage services using Solaris commands.

Deploying the RPD and Web cat through Enterprise Manager and restart the all services.

Creating in Interactive Dashboards, Pages and the requests.

Created the reports like Table, Chart, Pivot, Narrative views and publish them in dashboards using Answers & Dashboards.

Developed multiple pivot view reports in OBIEE 11g as per end user requirements.

Creation and monitoring of scheduled briefing books with multiple reports incorporated in it.

Involved in Data level security and Object level Security.

Participated in status weekly status meeting along with Client.

Project Profile:

Project – 2

Inventory Analysis

Client

KOEL

Role

OIBEE Developer

Duration

(07/2013-07/2014)

Team Size:

8

Module : 1

Environment

(with skill versions)

Software

Database : Oracle 11g

OS : windows 7/Sun Solaris

BI Tool : 11.1.1.7.0.

Project Description

The project provides customer Revenue cycle, trend analysis, Inventory, Overhead Costs, Receipts, Suppliers, material purchases, Performance overview per year and Executive summary measures for revenue, and profitability trends reports and sub-reports according to business requirements to enhance decision-making process with respective to revenue and service management. It gives complete BI and DW Solution for Organizations Revenue Management Services.

Roles & Responsibilities:

Design and Developed Customer Inventory Sales and Profit Analytics Metadata repository (.rpd) that consists of physical layer, business model layers with aggregates & dimensions, presentation layers with catalogs & folders and external table security with session variables using Oracle BI Analytics Admin tool.

Creating in Interactive Dashboards, Pages and the reports.

Created the reports like Table, Chart, Pivot, Narrative views and publish them in dashboards using Answers & Dashboards.

Utilized features like narrative views, dashboard prompts to create interactive dashboards..

Developed multiple pivot view reports as per end user requirements.

Implementation of Object Level and Data Level Security for OBIEE Dashboard Reports.

Creation and monitoring of scheduled briefing books with multiple reports incorporated in it.

Deploying the RPD and Webcat through Enterprise Manager.

Project – 3

Purchase Performance Management System

Client

Nissan Europe

Role

OBIEE Developer

Duration

(08/2011-07/2013)

Team Size:

7

Module : 1

Environment

(with skill versions)

Software

Database : Oracle 11g

OS : windows 7/Sun Solaris

BI Tool : 11.1.1.6.2.

Project Description :

Purchase and Finance (NMUK and NMISA) departments produce monthly their own reports to measure the performance of the Purchase department.

The processes and systems involved in generating these figures are inherently different.

The main objective of the Purchase Performance Management (PPM) project is to collect data needed to generate the report for Finance, the report for Purchasing, and a so called reconciliation report. The reconciliation report should be able to explain the differences between Finance and Purchasing reports.

Responsibilities

Developed Interactive Dashboards using Reports with different Views (Drill-Down, guided navigation, Pivot Table, Chart, View Selector, Column Selector, dashboard and page prompts) using Oracle Presentation Services. Worked on Filters for the prompts.

Creating variables and initialization block.

Creating Dashboards and Dashboard prompts.

Developing different brand level reports, filters, and prompts by using web.

Performing the Unit and Integration testing.

Contact this candidate