Pvt Ltd Developer
Resume:
Oracle BIapps Consultant
SURENDRA
Email: ********.**********@*****.***
*************.*****@***********.***
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