Oracle BIapps Consultant

SURENDRA

Email: aceyr1@r.postjobfree.com

aceyr1@r.postjobfree.com

Mobile No: +973-********

PROFESSIONAL SUMMARY:

Having 5+ Year professional experience to implement Oracle Business Intelligence solutions using OBIEE

and 2+ years of experience on BIapps Consultant(Informatica, DAC,ODI)

Expert in Installation, Configuration, Implementation and customization of (OBIA/OBIEE) packaged.

Extensively working on OBIA modules like HR analytics, Financial Analytics with source as Oracle EBS

R12.

Strong experience in developing OBIEE Repository (.RPD) at three layers (Physical Layer, Business

Model & Presentation Layer), Interactive Dashboards with drill down capabilities.

Expert in creating Metadata Objects and Web catalog Objects (Dashboards, Pages, Reports) using

OBIEE Admin Tool and OBIEE Answers.

Experience in up gradation OBIEE 10g to 11g and also patching upgrade from version to version

Proficient in BI Publisher reports using various templates to publish the reports as per user and Business

requirements.

Proficiency in security management of all aspects of OBIEE

Implemented Security by configuring roles and web groups using LDAP Authentication in OBIEE 11g.

Designing DWH schemas as per requirements and configuring ETL in ODI and Informatica.

Beside Business Intelligence, I have good understanding of Oracle Financials, HRMS,SCM

and Procurement and Spend Analytics.

Extensively Working with Informatica Designer, Workflow Manger to create Sessions, Workflows and

mappings etc.

Used Informatica Power Center Designer (Source Analyzer and Mapping Designer) to develop

mappings for extracting, transforming, integrating and loading data to targets.

Expertise with all ODI tools Topology, Security Manager, Designer and Operator

Hands on experience with Data Extraction, Transformation and Data Loading in Data Warehouse

environment.

Having good experience in Data warehousing concepts such as dimensional modeling, Star Schema

and snowflake schema, galaxy schema, Data marts, Dimensions and facts identification.

Involved in OBIEE testing for technical support, Functional support, User Acceptance and Integration

testing.

Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP

and dimension modeling for OLAP.

Expertise in documentation and Interaction with the client for technical information in a timely and well

organized manner.

Very strong analytical and presentation skills, problem solving techniques, proven leadership qualities with

emphasis on individual and team effort backed by excellent communication skills

EXPERIENCE SUMMARY:

• Working as Senior BIapps consultant in Intertecsys Pvt Ltd Bahrain from Oct 2013 to till date

• Worked as an OBIEE and ODI Consultant in Herbalife international India Pvt Ltd

Bangalore From Nov 2012 to Oct 2013

• Worked as an OBIEE and ODI Developer in Ramyam Intelligence Lab Pvt Ltd, Bangalore from Oct 2011 to

Nov 2012

• Worked as an OBIEE Developer in TCS, Bangalore from Oct 2010 to September 2011

• Worked as an OBIEE developer in HCL Technologies, Bangalore from Oct’08 to Sep 2010.

Technical Skills:

Reporting Tools OBIEE 10.1.3.x,OBIEE 11g,BIapps

ETL Tools ODI 10g/11g,Informatica 9x

Toad, SQL Developer, SQL*plus, DAC (Data Warehouse Application

Tools

Console) and Quality Center

RDBMS Oracle9i/10g/11g,SQLServer, MS Access.

Operating Systems Windows, UNIX, Linux, IBM AIX

Languages SQL, PL/SQL, UNIX Shell Scripting

Web Technologies HTML

EDUCATION QUALIFICATION:

• MCA (Master of Computer Applications) from JNT University.

Work Experience:

Project #1 :

Project : CSB HR and Financial Analytics

Client : CSB Bahrain

Environment : Oracle Business Intelligence (OBI) EE 11.1.1.7.0,Informactica,ODI 11g,BIapps 11g,IBM AIX.

Role :BIapps Consultant

Duration : Oct‘2013 to till date

Description:

Civil Service Bureau Human Resources Analytics integrates data from HR, financial and other enterprise

systems and transforms it into integrated, easy to use, and actionable insight into how various factors impact

workforce and measuring their performance.

Civil Service Bureau Financial Analytics provides organizations with better visibility into the factors that drive

costs and performance output value. Through intelligence dashboards, Oracle Financial Analytics provides

hundreds of powerful financial metrics, alerts, reports, and dashboards to financial professionals and line of

business managers. Data extracting from CSB Oracle EBS R12 to CSB warehouse through Oracle data

integrator.

Responsibilities:

• Installed BIapps (ODI,Biapps,OBIEE11g versions)

• Created new models for the data sources Oracle EBS R12.

• Created ODI packages, scenarios using interfaces, variables, procedure

• Used ODI commands like ODIFile_Move, odiFileAppend, odiFilecopy etc

• Optimized the knowledge modules to improve the functionality of the process.

• Creating several reverse engineering Models as per the requirements

• Imported and executed master jobs, scenarios in Execution repository

• Performed Debugging and Tuning of mapping and sessions.

• Monitoring the Execution Logs in operator navigator

• Mapped Logical resources to Physical resources in different contexts

• Scheduling the scenarios by using ODI Scheduler

• Handled the ODI Agent with Load balancing features

• Design and development of ODI repository to meet business functionality

• Worked extensively on Customizing OBIEE Administration Tool for Repository that includes Physical Layer,

BMML and Presentation Layer.

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

• Extensively used Dashboard, Pages, Sections, Add Column and Dashboard Prompts including View Selector,

Pivot Tables, and Charts.

• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and

rights to users and groups (etc. Shared Folders, Web Catalogs, Metadata Objects)

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

Objects and Web Catalog Objects.

• Applied Cascading Prompts and Multi Level Prompts on Dashboards.

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

• Preparing the Test cases RPD and Reports level based on the SRS Specification.

• Trained End Users and Pilot Users about OBIEE Tools.

Project # 2

Project : DM

Client : Herbalife International India Pvt Ltd

Environment : Oracle Business Intelligence (OBI) EE 11.1.1.7.1,OBIEE Admin, Oracle APPS Distributor

Management, Oracle 11g,ODI, Web logic, BI Publisher.

Role : Senior OBIEE and ODI Developer

Duration : Nov ‘2012 to Oct '2013.

Description:

The project is developed for converting Oracle Application (Distributor Management) Reports to BI Publisher

Reports. OBIEE 11g version has been used. We extensively used Packages, Procedures in Dataset to connect to

the Database directly for better performance. We have designed RTF (Rich Text Formatting) for designing report

output.

Responsibilities:

• Installed ODI and Configured Oracle BI EE 11g on Windows.

• Creating several reverse engineering Models as per the requirements

• Debugging the master jobs and packages by using operator navigator

• Loading metadata data from Oracle EBS suite source system into RDBMS target system

• Mapped Logical resources to Physical resources in different contexts

• Scheduling the scenarios by using ODI Scheduler

• Handled the ODI Agent with Load balancing features

• Design and development of ODI repository to meet business functionality

• Built DataModelto plug in in to database directly to improve the performance.

• Used Packages, Procedures and Lexical Parameters to pass multiple values in a Dataset.

• Used Event Triggering to call a function before the dataset is refreshed.

• Configured Bursting feature in BI Publisher to burst a Single output to multiple reports based on a

Parameter key.

• Configured Email Server, FTP, CUPS Server and Printer Integrated with BI Publisher.

• Installed and configured Template Builder in Windows office for RTF Design and Designed RTF

Templates for report output.

• Designed various Sub templates contains Headers and Footers and called them in Main Template for

better accessibility and used various functions such as call, in lines, column in template.

• Customized Skin and style in the new version and provided multiple logo display option in BI Dashboard.

• Migrated Repository and web catalog from Enterprise Manager and increased the Cache Memory Size on

the same.

•

Project#3:

Project : OMIPM

Client : Rovi, US.

Environment : ODI 11g, Oracle Business Intelligence 11.1.1.5, Windows, Oracle 11g,

SQL, PL/SQL.

Role : OBIEE Admin and OBIEE Developer

Duration :Oct ‘2011 to Nov 2012

Description:

Oracle Media and Intellectual Property Management (IPM) systems will be implemented at RES, replacing the

manual and spreadsheet based business processes and systems currently in use.

This interface will send the Royalty/Revenue Share data set to the data warehouse.

It is assumed that the transaction data interface is in place and is needed to calculate the royalty accruals, royalty

payments and revenue share for the digital contents being sold using a mix of website based storefronts and

software’s embedded within electronic devices like TV, Digital player’s mobile devices etc.

Responsibilities:

• Creating several reverse engineering Models as per the requirements

• Debugging the master jobs and packages by using operator navigator

• Loading metadata data from Oracle apps source system into Warehouse target system

• Mapped Logical resources to Physical resources in different contexts

• Scheduling the scenarios by using ODI Scheduler

• Debug the sessions by utilizing the log of the sessions

• Handled the ODI Agent with Load balancing features

• Design and development of ODI repository to meet business functionality

• Worked extensively on Customizing OBIEE Administration Tool for Repository that includes Physical Layer,

BMML and Presentation Layer.

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

• Extensively used Dashboard, Pages, Sections, Add Column and Dashboard Prompts including View Selector,

Pivot Tables, and Charts.

• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights

to users and groups (etc. Shared Folders, Web Catalogs, Metadata Objects)

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

Objects and Web Catalog Objects.

• Applied Cascading Prompts and Multi Level Prompts on Dashboards.

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

• Identified and created aggregate tables to improve query performance.

• Experience in creating IBots using OBIEE Delivers to create alerts based on results.

• Implemented Security by authenticating against the LDAP and external table.

• Preparing the Test cases RPD and Reports level based on the SRS Specification.

• Co ordinated with QA team and created Test Plans and Test Cases to test and validate the reporting system and

its data

• Trained End Users and Pilot Users about OBIEE Tools.

Project #4:

Project : RAPDRP

Client : Discom, Gujarat.

Environment : ODI 11g, Oracle Business Intelligence 10.1.3.4.1, Linux, oracle 11g, ODI11g, SQL and

PL/SQL

Role : OBIEE Developer

Duration : Oct ‘10 to Sep ‘2011

Description:

The Proposed solution is based on the oracle bi enterprise edition plus product from oracle .There will be a

single centralized database instance for MIS across DISCOMS. The component installed at datacenter site. Oracle Data

Integrator (ODI) is used as an ETL tool to extract data from diverse source system into data warehouse.

Responsibilities:

• Developed OBIEE Repository (.RPD) at three layers (Physical Layer, Business Model&Presentation

Layer), Interactive Dashboards with drill down capabilities.

• Expert in creating Metadata Objects and Web catalog Objects (Dashboards, Pages, Reports) using OBIEE

Admin Tool and OBIEE Answers.

• Experience in up gradation OBIEE 10g to 11g and also patching upgrade from version to version

• Proficient in BI Publisher reports using various templates to publish the reports as per user and Business

requirements.

• Implementation data and Objectlevelsecurity

• Defining Multiple DimensionHierarchies for the Dimension Logical Table.

• Creating the Dashboard and Reportlevelprompts.

• Enhanced existing Business Models & created customized Dashboards.

• Generated OBIEE reports using OBIEE Answers, dashboards, filters and Prompts.

• Configure the Scheduler to deliver the reports to the Business using Ibots.

• Developed in BI publisher reports and scheduled the various reports for various destination

• Published reports in BI Dashboard and provided output in various format including CSV, EXCEL, PDF.

Project #5:

Project : Central Data Warehouse

Client : Luton, U.K

Environment : Oracle Business Intelligence 10.1.3x Windows XP, oracle 10g,

SQL, PL/SQL, TOAD.LINUX (Red hat).

Role : OBIEE Developer

Duration : Oct’09 to Sep’10

Description:

The project was for a central data warehouse for the supplier and stock details in the various depots. The

various details wise Generating Reports were developed using OBIEE.

Responsibilities:

• Worked extensively on Customizing OBIEE Administration Tool for Repository that includes Physical Layer,

BMML and Presentation Layer.

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

• Extensively used Dashboard, Pages, Sections, Add Column, Dashboard Prompts including View Selector, Pivot

Tables, and Charts.

• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights

to users and groups (etc. Shared Folders, Web Catalogs, Metadata Objects)

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

Objects and Web Catalog Objects.

• Applied Cascading Prompts and Multi Level Prompts on Dashboards.

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

• Identified and created aggregate tables to improve query performance.

• Experience in creating IBots using OBIEE Delivers to create alerts based on results.

• Implemented Security by authenticating against the LDAP and external table.

• Preparing the Test cases RPD and Reports level based on the SRS Specification.

• Co ordinated with QA team and created Test Plans and Test Cases to test and validate the reporting system and

its data

• Developer BI publisher reports for various output formats and schedule those reports.

• Trained End Users and Pilot Users about OBIEE Tools.

Project #6

:

Project : Customer Service and Profitability Data warehouse

Client : VISA International, Foster City, California

Environment : Oracle Business Intelligence 10.1.3x Windows XP, oracle

10g, Linux

Role : OBIEE Developer

Duration : Oct’08 to Sep’09

Description:

VISA is one of the leading Credit Card and Financial Service providers and serves many corporate customers

across the Globe. VISA allows its customer to do different financial transactions on line.

Responsibilities:

• Used the OBI Administration tool to develop and enhance meta data.

• Created connection pools, physical tables, defined joins and implemented authorizations in the physical

layer of the repository.

• Worked extensively with Physical Layer, Business Layer and Presentation Layer.

• Designed Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables.

• Built Business model and established relationships & Foreign Keys (Physical & Logical) between

tables.

• Developed different kinds of Reports and Dashboards (pivots, charts, tables/compound layout) using

global and local Filters.

• Implemented both Object and Data level security as part of the project.

Contact this candidate