BI consultant

Rajith Kumar P N

Mobile: +316********

Email: *********@*****.***

Summary

* ***** ** ** ********** in implementing Business Intelligence solutions as an OBIEE

Consultant

Implemented end to end BI applications (both data warehousing and Reporting layers)

Expertise in requirements gathering and creating functional and Technical documentation

Expertise in Siebel, OBIEE and ETL tools

Expertise in developing and maintaining repository using OBIEE Administration tool

Expertise in Informatica and DAC for loading data warehouse

Experience in Data warehouse designing, Dimensional data Modeling and Data Vault modeling

Experienced on Oracle Apex, Tibco Spotfire, Qlik View reporting tools

Has basic knowledge on Big data analytics tools such as Hadoop and No SQL databases

Expertise in client facing and offshoaring

Have Valid Knowledge migrant Work permit for Netherlands.

Undergoing Dutch Language Course. Can speak and understand Basic Dutch.

Work Experience:

Company Name Designation Period

Senior programmer July 2010 to Oct 2012

Accenture Service Pvt Ltd,

India

Oct 2012 till Present

Software Engineering Analyst

Accenture B.V

Netherlands

Technical Skills

Reporting Tools : OBIEE 10g and 11g, Tibco Spotfire, Oracle Apex, Qlik View, Tableau.

ETL Tools : Informatica PowerCenter 8.6.x, DAC

Programming Languages : Java, C,C++, Python

Operating Systems : Windows, UNIX, LINUX

Education and Certifications

Oracle Certified OBIEE 10g and 11g implementation Specialist .

Graduated in Computer Science From University Visvaswaraya College of Engineering, Bangalore with

71 % Aggregate score(2010)

Project 1:

Client: BWIN.PARTY DIGITAL ENTERTAINMENT July

2010 –Aug 2012

Environment: OBIEE 10.1.3.3, Siebel 8.1, Informatica PowerCenter 8.5, DAC

OBIEE Developer

Description: The world's largest publicly traded online gambling firm, it is best known for its online poker room

PartyPoker.com and its sports betting brand Bwin. It is headquartered in Gibraltar and quoted on the London Stock

Exchange. PartyGaming is among the world's largest online poker brand (based on cash game revenue and number

of players).

Responsibilities:

Worked on requirements gathering, Business Model definition and technical documentation.

Analysis design development and testing of Analytics metadata Repository (.rpd) files consisting of

physical layer, multiple business models and mappings with dimensions and facts as well as presentation

layer with subject areas.

Created metadata in OBI Admin tool, configured connection pools, data sources and DSN to suit the

technical environment.

Defined Primary Key Foreign Key relationships, complex joins between dimension tables and fact tables

in the physical layer and Business Model and Mapping Layer.

Created Business Model with Logical Tables in the Logical display folders.

Created Dimensional Hierarchies in Business Model layer for Drill down functionality.

Created presentation layer with catalog folders, to show different views of the business model to different

users and group assigned permissions to the catalog folders.

Generating adhoc reports using Oracle answers by applying filters and prompts and configured the reports

in different views.

Created and configured users specific dashboards.

Implementing the security both at the repository level and at the presentation catalog level.

Involved in migration of the application from Dev to Test environment.

Extensively involved in the Enhancement Requests(Work Requests) due to production issue or any newly

added attributes.

Siebel Administration

Responsibilities:

Installing Siebel servers and performing Siebel deployment.

Working on production issues and Siebel environment health check to keep the application up and running

always.

Creating users in Siebel application with appropriate responsibilities and communication profiles.

Improve the process by developing automation scripts to reduce the human interventions and time.

Project 2:

Client: KPN, Netherlands

Sep 2012 – Till present

Environment: OBIEE 10.1.3.3, Informatica PowerCenter 8.5, DAC

Onshore OBIEE Consultant

Description: KPN is a leading telecommunications company in Netherlands.

Responsibilities:

Working closely with client to understand the business requests and providing accurate business solutions

in BI.

Worked on requirements gathering, Business Model definition and technical documentation.

Developing ETL scripts for data load.

Providing authorization and implementing security in OBIEE.

Created many ibots in OBIEE to support business users with email delivery of the reports. Created many

adhoc reports as per the requirements.

Implemented complete production environment including database, ETL and OBIEE.

Performed many deployment activities in both ETL and OBIEE.

Created unit test plans and performed the unit testing of the reports developed.

Created calculated logical columns according to the business requirement.

Design and development of various dashboards and reports that are dynamic and interactive with drill

down capabilities and local & global filters.

Worked on cache management of OBIEE

Created the necessary documentation required for the client.

Provision of dashboard prompts and report navigation features.

Personal Details:--

Name : Rajith Kumar P N

Marital Status : Single

: 15th May 1989

Date of birth

Contact this candidate