Project Insurance

Pavan kumar Nayakanti

***********@*****.*** Ph: +91-784*******

Professional Summary:

• Having 2.5 years’ of working experience as OBIEE Developer.

• My technological forte is OBIEE 10g,11g Oracle 9i.

• Extensive experience in OBIEE Administration Tool, Answers, Dashboards and Delivers.

• Hands on experience in Reports and Repository creation.

• Expertise in building reports using drill up, drill downs, Pivot, Chart Views, Narrative View, Column Selector View and incorporate them into Dashboard pages.

• Implementing the business logic by customizing Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, Security Management (Data level/Object level security, Time Period Level).

• Working with Presentation, Repository and Session variables.

• Designing Business layer with multiple sources.

• Has excellent knowledge on SDLC process as well as Quality processes followed in the project.

Professional Experience:

• Working as OBIEE Developer in Fortech Soft pvt ltd(www.fortechsw.com), Hyderabad from AUG-2009 to till date.

Academic Profile:

S.no Degree Name of the institution:-

1. 10th- Sister Stanislas English School (Distinction)

2. Inter-Narayana Junior College(Distinction)

3. Btech-Mahatma Gandhi Kasi Vidyapeeth(Distinction)

Technical Skills:

Reporting Tool : OBIEE 10g,11g

Data base : Oracle 10g

Operating system : Windows Family.

Project Details:

Current Project:

Title : HR Metrics Dashboard

Client : EATON STEEL, USA.

Environment : OBIEE 11g, Oracle 9i

,

Description:-

The HR Metrics Dashboard project is intended to provide facilities for a comprehensive measurement tool for HR metrics around critical key performance indicators of employee demography and organizational structure. This project is designed tin order to satisfy the stated needs of the Human Resources department of the GEMS. This maintains all the information about the employees and the ex-employees. The main objective is to display all the metrics on the first page of the dashboard.

The metrics that are displayed on the Dashboard are the count of active officers, employees new to GEMS, %of all employees who are diverse, % of all promotions, employees leaving GEMS. Security for Dashboard is based on the SSO access. It is limited to specific number of users/employees approved by HRfunctionaldataowner.

HR Metrics Dashboard allows data base access to only BI DBA team for administrative tasks based on the approval by HR functional owner. HR reporting tool is secured from all users except for Core Hr team and HR super users to be identified at the Testing Phase. The Oracle BI reporting system is required to perform any specific functions and fulfill company HR requirements.

Responsibilities:-

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document by access and retrieval of financial and personnel data from one single source.

• Identified & Created Facts, Dimensions, and Hierarchies of the business model.

• Developed Segment Value Detail, Work Order Detail and OGA Repositories (RPD) by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.

• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.

• Configured Interactive Dashboard with drill-down capabilities using global and local Filters, Metadata Objects.

• Identified issues and optimized the Business Intelligence Dashboards and Reports.

• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.

• Used Scheduler where ever required according to client requirements.

Environment: Oracle BI, Oracle 9i, Windows Server 03

Team Size: 8

Project #1

Title : L.B.U

Client : Lloyds Banking Group, U.K

Environment : OBIEE 11g, Oracle 9i

Description:-

Lloyds Banking Group is a major British financial institution, with several branches across U.K. Lloyds Banking Group's activities are organized into four business divisions: Retail Banking, Wholesale, Life, Pensions & Insurance, and Wealth & International.

Retail bank providing all banking services and also including issuing money in the form of coins, banknotes or debit cards, receiving deposits of money, lending money and processing transactions.

A retail bank accepts deposits from customers and in turn makes loans based on those deposits. It offers ancillary financial services to make additional profit; for example: selling insurance products, investment products or stock broking.

Responsibilities:-

• Understanding reports requirements and customizing the Repository to meet the business requirements.

• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer.

• Designed hierarchies based on the reporting requirements.

• Developed security both at rpd level and at Web catalog level.

• Extensively used Variables (repository and presentation) in the process of making the reports

• Has also enabled Cache to improve performance of the reports.

• Built OBI reports showing comparison between current measures and historical measures

• Created reports in the Answers and configured the results in different views such as Table view, Pivot table view, Chart view, Narrative view etc based on the requirement.Has integrated different reports into dashboard and has set access permission accordingly based on user needs.

• Project #2

Title : Northland Insurance Company

Client : Northland insurance company, Arizona

Environment : OBIEE 10g, Oracle 9i

Description:-

Northland Insurance Company is an insurance corporation, primarily engaged in the business of providing insurance protection to the public.There are three divisions namely motor, life&health insurance and property & casualty insurance. A Data ware house is organized according to requirements of the organisation. Different modules are designed to support tactical reporting requirements of current data (Operation Data Source) & strategic reporting requirements on Historical data (Data Warehouse).

Responsibilities:-

• Studying the Sources data based upon the Functional Specification given by the onsite team, and preparing the LLD’s.

• Development of all layers of Oracle BI Administrator Tool, Physical, Business Model, and Presentation layer.

• Created Views for Reporting.

• Developed reports with conditional filters.

• Developed reports with prompts.

• Customization of Answers, Reports and Dashboards.

• Creating the Dashboard and Report level prompts.

Project #3

Title : InspirIT

Client : Genpact

Environment : OBIEE 10g, Oracle 9i

Description:-

InspirIT: This System has two modules like ProfIT, ManIT.

ProfIT: In this System where all new projects creation and extensions of current projects being done through Profit. This module is used by the Finance team and it has different sub-modules that will be used for Sending the deals created for various levels of approvals, Billing, Invoicing etc. There are several reports that are created on this module that will be used by the middle and high-level management.

ManIT: This module is used by the Resourcing and HR teams. It contains various screens used for entering employee details such as resource allocation/release to/from projects...etc into the system. This system also records all information related to Appraisals, Leaves, and Loans...etc of the employees

Responsibilities:-

• Interacted with Users and Business Analysts to understand and document the reports requirements and translate these to technical specifications for designing OBIEE Reports.

• Importing the metadata tables from the database to the OBI Administration Tool for customizing and modifying the Physical, BMM Layer and Presentation Layers of the metadata repository.

• Has designed hierarchies based on the reporting requirement.

• Has implemented security both at rpd level and at catalog level.

• Developed reports in OBIEE Answers.

• Developed different kinds of Reports, pivots, Interactive Dashboards with drill- down capabilities, charts, tabular using global and local Filters.

• Has integrated OBI with Ms-office

Contact this candidate