SUMMARY:

• 14+ years of diversified IT experience working with OBIEE/ODI including (OBIA), which consist designing RPD and developing OBIEE Dashboards, BI Publisher with ODI Extraction
• Expertise in customizing OBIEE dashboards and developing new ODI interfaces to extract
• Very knowledgeable in warehouse development designing star schema with emphasis on Facts Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series and Cache Management
• Designed and developed ODI interfaces for integrating EBS data into Hyperion Essbase applications
• Expertise in implementing OBIA in all phases both functional and technical including configuration manager setup
• Very knowledge with essbase application set up, metadata, dimensions, rules, web data entry forms, and task flow manager
• Configured and customized ODI ETL mappings to meet the client requirements including monitoring incremental and full load of data through BIACM and ODI
• Experience in performance tuning DataWarehouse to meet Business Intelligence needs for applications such as Hyperion EPM applications and OBIEE
• Implemented authentication of OBIEE by using WebLogic LDAP for external Authentication (AD) also implemented Single Sign on (SSO)
• Scheduling the ODI loads using Scheduler through ODI Studio/Control - M
• Have successfully installed and configured OBIA (7.9.6.1 to 11.1.1.9.2 ) applications including informtica and ODI for multiple engagements

SKILLS:

Oracle Applications: 11.1.1.7.1

Application Tools: BI Publisher

Databases & Tools: Oracle 11g TOAD, SQL Navigator, SQL*PLUSSQL* Loader.

Scripting Languages: Unix Shell scripts, K shell, C shell.

Languages: SQL, PL/SQL, JAVA, XML, C, C++.

Operating System: Sun Solaris, Unix, Linux, Windows NT/XP/2000/98.

ETL Tools: ODI 12c Informatica 8.x/7.x/6.x/9x

EXPERIENCE:

Confidential

Sr. ODI/OBIEE

Responsibilities:

• Designed the detailed ETL architecture, including agents, scenarios, packages, data mapping, data extractions, transformations and validations. ETL design and implementation include stand-alone and Java EE agents, ODI data services, ODI Console, ODI studio, and other appropriate development tools
• Configured and setup ODI,, master repository, work repository, Project, Models, sources, targets, packages, Knowledge Modules, Interfaces, Scenarios, filters, condition, metadata
• Used ODI for Reverse engineering to retrieve metadata from data storage and load it to the repository
• Developed complex jobs ODI using various stages like Lookup, Join, Transformer, Dataset, Row Generator, Column Generator, Datasets, Sequential File, Aggregator and Modify Stages
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it, etc
• Developed OBIEE Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation Services
• Customize OBIA 11.1.1.9.2 out of the box HR and Financials Dashboards including modifications to RPD
• Configured OBIEE Repository (Physical, business and presentation layer) to provide Analytical Reporting solutions to business, also Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, as related to business needs

Confidential

Sr. ODI/OBIEE

Responsibilities:

• One Man install and implementation OBIA 11.1.1.9.1 including Financials and HR and using ODI 11g to move data from source to target, preformed all function setup using OBIA configuration manager for Financials and HR
• Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including Hyperion Planning, Essbase, Relational Database Management servers (including Oracle RDBMS, SQL Server, and IBM DB2), flat files (including CSV, Excel, & XML file formats), and web services (SOAP, WS-I Security)
• Used different Knowledge Modules (KM) to load and transform the data from different data sources
• Setting up LDAP authentication to enable SingleSign on for Users in Development environment leveraging Analytics Repository
• Develop data extracts from data warehouse environment using ODI and Implemented Journalizing Knowledge Module JKM for integration into Goldengate
• Customize 67 OBIA out of the box OBIEE dashboards also integrated ESSBASE cube data into OBIA reports
• Designed OBIA RPD to provide Analytical Reporting solutions to business, also Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, as related to business needs

Confidential

Sr. ODI/OBIEE

Responsibilities:

• Implemented OBIA 11.1.1.8.1 Oracle Financials, HR and Supply Chain using Oracle Data integrator (ODI) to move data from source to target
• Implemented function setup using OBIA configuration manager, Financials and HR
• Worked extensively on OBIEE Answers to create the Financial Statement reports and Intelligence Dashboards (Financials) as per the detailed design requirements
• Configured ODI JKM to extract source data once and replicate it into both the Foundation Layer and Raw Data Reservoir in parallel
• Configure ODI Integration to Apache HBase through using the following Knowledge Modules: LKM HBase to Hive (HBase-SerDe):IKM Hive to HBase Incremental Update (HBase-SerDe)RKM HBase
• Created master & work repositories and configured ODI connections for source and target systems in topology, created ODI Agent and configured it for automating the jobs through the ODI Studio and Weblog Application Server
• Develop data extracts from data warehouse environment using ODI and Implemented Journalizing Knowledge Module JKM for integration into Goldengate
• Customize any OBIA out of the box OBIEE dashboards, including new OBIEE development including BI publisher reports from 3th party database source including RPD as source
• Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders

Confidential

Sr. ODI/OBIEE

Responsibilities:

• One man installation and configuration of the complete Analytics platform environment OBIA 7.9.6.4 later migrating to OBIA 11.1.1.7.1 install required ODI connectivity for seamless integration into the 11g Data Warehouse.
• Developed custom OBIEE dashboards and BI publisher reports from 3th party database source including RPD development
• Created OBIEE/RPD Dimension Hierarchies to achieve the drill down functionality as per Business Requirements
• Integrated data from Finance and other enterprise systems and transformed data using ODI
• (ELT).
• Successfully Implemented Oracle HR Analytics and created separate execution plans for the daily refresh of the Data Warehouse
• Setup OBIEE 11.1.1.7.1 security roles and groups with integration into external directory Active Directory and OIM, including SSO
• Configured the csv files required for the source independent load and source dependent load.
• Created task dependency, assembled the subject areas, build the execution plan and successfully tested the full & incremental load of Financial Analytics using DAC and Informatica.
• Involved with Oracle SME in developing queries to validate the data in Oracle Business Applications Warehouse (OBAW) against the source PeopleSoft 8.9
• Used tuning techniques to increase the performance of slowly running OBIEE 11.1.1.7.1 reports.

Confidential

Sr. ODI/OBIEE

Responsibilities:

• Developed OBIEE Repository (RPD), Interactive Dashboards, OBIEE Answers, security implementation
• Senior OBIEE architect for converting salesforce.com reporting into OBIEE also as part of the ETL process migrating and mapping Sales Analytics CSV data into OBIEE metadata repository by configuring Informatica and DAC
• Installed and configured OBIA 7.9.6.2 including OBIEE, DAC, Informatica to support the following Analytics Sales and HR. (Linux Environment)
• As a standalone project installed ODI 11g to extract data SQL server to Oracle Warehouse
• Created over 30 OBIEE dashboards this development included creating a new RPD and merging into the original 7.9.6.3 RPD to create reporting from OBIEE Answers
• Implemented performance-tuning of OBIEE Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path
• Developed many OBIEE Metadata Repository (RPD) by importing database tables into physical layers, forming dimensional and fact table schemas in BMM layer and customizing table and column definitions in presentation layer
• Developed multiple OBIEE Drill-Down Dimensional Hierarchies in Business Model Layer and customized Presentation catalogs in Presentation Layer

Confidential

OBIEE Admin/Developer

Responsibilities:

• Developed and customized OBIEE 11g Dashboards, OBIEE Answers, security implementation
• Installed and configured Oracle BI Applications 7.9.6.2 including DAC, Informatica to support the following Analytics Financial, Projects and HR.
• Implemented performance-tuning strategy at OBIEE level such as cache management, aggregate table, schema re-customization
• Developed OBIEE Metadata Repository (RPD) using OBIEE Server Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down, Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer
• Developed customized OBIEE reports and interactive dashboards with various contents and functionalities including drill-down, navigation, advance filter, conditional format, union reports etc.
• Developed several OBIEE BI publisher Reports to support existing OBIA financial dashboards as a enhancement.
• Wrote all AIM documentation to support the OBIEE environment including ETL
• Conducted training sessions for end users on OBIEE and OBIA Applications

Confidential

SR. OBIEE Admin/Developer

Responsibilities:

• Gathered Business requirements by interacting with the business users, defined subject areas for OBIEE analytical data requirements
• Installed and configured OBIA 7.9.6.1 this was a one man implementation where all BI components DAC, Informatica, BI Applications and OBIEE was installed to support the following Analytics.
• Supply Chain and Order Management Analytics - configure Domain Values and CSV Files for Oracle Supply Chain and Order Management Analytics
• Supply Chain and Order Management Analytics - Configure DAC and Informatica for Supply Chain ETL execution plan
• Procurement and Spend Analytics - configure CSV files for Oracle Procurement Analytics by mapping values from source systems to the domain values
• Procurement and Spend Analytics - Configure DAC and Informatica for ETL execution plan
• HR Analytics - configure Domain Values and CSV Files, create DAC and Informatica ETL execution plan
• Analyzed, Designed and Developed OBIEE Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
• Debugged BI Server, Presentation Server, DAC Server and Informatica Server including Client tools for performance and connectivity
• Conducted training sessions for end users on BI Applications

Confidential, Chicago, IL

Sr. OBIEE Admin/Developer

Responsibilities:

• Gather requirements and conduct interview sessions with end users.
• Translated Business requirements into technical requirements.
• Developed OBIEE dashboards and reports for E-BIZ 11i modules AR, AP, PCA and GL
• Participated regularly in Walkthroughs and Review meetings with Project Manager, QA Engineers and Development team.
• Implemented Siebel Delivers using iBots for delivery of reports through email, hand-held devices and mobile phones
• Created new requests and opened Answers for adhoc reporting to the End users.
• Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector using Oracle BI Presentation Services.
• Customized Dashboard pages like Liquidity, Profit and Loss, Cash Flow, Income Statement and Balance Sheet in General Ledger Dashboard.
• Customized GL Detailed Trial balance report, GL Period to Date Balances reports in General Ledger using FSG’s.
• Designed, implemented and tested security privileges on Dashboards and reports.
• Involved in Unit Testing and Performance Testing for reports.
• Prepared the training materials for the end users.
• Conducted training sessions for end users on BI tool.

Confidential

Sr. OBIEE Admin/Developer

Responsibilities:

• Performed the Installation and configuration of the complete OBIEE environment and the required connectivity for seamless integration with the data warehouse.
• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Implemented OBIA Financial, Order Management, Procurement, Spend Analytics and HR, integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Integrated OBIEE with EBS for Single Sign On (SSO).
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Created new OBIEE requests and opened Answers for adhoc reporting to the End users.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBots queries to obtain daily and weekly reports.
• Designed, implemented and tested security privileges on Dashboards and reports.
• Monitored Incremental and Full load Work Flows through Data Warehouse Administration Console (DAC) and Informatica WorkFlow Monitor.
• Customized OBIA dashboard pages AR Balance, Payments Due, Invoice Details and All AR Transactions in Receivables Dashboard.
• Customized OBIA dashboard Overview, Margins, Revenue, Products and Customers in Profitability Dashboard.
• Designed and Developed New Dashboard pages in General Ledger, Payables, Receivables, profitability, Procurement and spend and supplier performance Dashboards in OBIEE.

Confidential

OBIEE Admin/Developer

Responsibilities:

• Responsible for the installation of OBIA 7.9.5.
• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle, flat files and loading to Oracle target database.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Worked using Catalog manager to migrate web catalog between different instances.
• Created Dimensional Hierarchies and implemented Business Logics for Facts.
• Created and modified session variables, repository variables and initialization blocks in the repository building in OBIEE..
• Created reports in Answers and embedded them in Dashboards according to the requirements.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool..
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Worked on the testing and validating the Repository in OBIEE.
• Customized Dashboard Pages Like Total Spend Overview, Trends, Exceptions, Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee Expenses in Procurement and Spend Dashboard in OBIEE. .
• Responsible for the design and development of execution plan in DAC which will call the Informatica workflows and updates the Image tables.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.
• Developed Order and Invoice Revenue by Product OBIEE dashboard for Procurement Analytics.
• Developed Order Revenue Growth over Previous Year OBIEE dashboard for Procurement Analytics.
• Developed Cumulative Order Revenue versus Last Quarter OBIEE Dashboard for Procurement Analytics.

Confidential

OBIEE Architect/Developer

Responsibilities:

• Designed and Developed OBIEE financial dashboard pages in general ledger, payables and receivables.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Used various Transformations like Lookup, Expression, Filter, and Joiner for cleansing and consistent data.
• HR Analytics - configure Domain Values and CSV Files, excute DAC and Informatica ETL
• Created OBIEE reports in Answers and embedded them in Dashboards according to the requirements.
• Optimized performance by tuning the Informatica ETL.
• Designed and developed various Dashboards that are Dynamic & Interactive with drill-down & drill-across capabilities with local & global filters.
• Developed an Interface for the Standard Items of Sales Orders Import in Order Management.
• Designed and developed Customer Interface, Auto Lockbox Interface.
• Developed an interface program using API for loading item On Hand quantity balances.
• Designed and Developed AP Check Printing Report, Invoice Detail Report by Supplier, Payment Schedule Report by using XML/BI Publisher.
• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes by using XML/BI Publisher.
• Designed and developed custom Dashboards.
• Developed Contract History Report using Discoverer in Service Contracts.
• Developed Give Service Report using XML/BI Publisher in Service Contracts.

Confidential

Oracle OBIEE Developer

Responsibilities:

• Design, Development, Implementation and Technical support of complex business custom extensions for Oracle Financial, Manufacturing modules.
• Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of Siebel Analytics
• Install and Configure OBIEE Disconnect. Design and create dashboards, custom star schemas, and custom sourcing reports, customize Siebel Analytics metadata, create SQL scripts for local SQLAnywhere database, customize dashboards and customize informatica ETL loads in support of Disconnected Analytics
• Designed and recommended solution for custom processes flow integrated with standard applications.
• Involved in Open Sales Order conversion based on client specifications.
• Imported Items from legacy system into Oracle Inventory using the Standard Item Interface Program.
• Configured OBIEE iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports
• Used TCA API's for creating Parties, Party Accounts, Contacts, and Account Sites.
• Involved in Unit Testing and Performance Testing for reports.
• Involved in preparation of various documents like MD050, MD070 (functional & Technical Design) documents.
• Created and have setup Resources using public packages.
• Responsible for techno design documentation of the reports.

Confidential

OBIEE Developer

Responsibilities:

• Developed OBIEE Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE Analytics Web.
• Designed Customer Products Summary Report in Install base using Reports 6i..
• Worked on Service Contract interface program by using the standard API’s.Generated Inter Company Transaction Detail Report, Open-Debit Memo Report in General Ledger using Reports 6i.
• Created new custom reports in Discoverer 10g.
• Customized Supplier Payment History Report in Account Payables to meet client requirements.

Confidential

Siebel Analytics Developer

Responsibilities:

• Designed, Created and Tested Report in Siebel Analytics Dashboard and created the adhoc report according to the client needs. .
• Design Analytics Star Schemas for custom Analytics Dashboards. Design and create Informatica Workflows, Mappings and other supporting data migration programs. Populate designed Star Schemas using Informatica ETL. Create Analytics Metadata to support customer specific requirements
• Customized GL Detailed Trial balance report, GL Period to Date Balances reports in General Ledger using FSG’s.
• Closed Order Outbound Interface, AR Customer Conversion, developed new reports and worked on customizations of OM Reports.
• Used standard open interfaces for Order import, AR Customers Conversion.

Confidential

Siebel Analytics Developer

Responsibilities:

• Worked on Journal Import to bring legacy journals from AP, AR and Posting in Oracle General Ledger.
• Involved in Vendor Conversion from legacy system to Oracle System.
• Designed and developed Aging Buckets report in Accounts Receivables using Discoverer 4i.
• Designed and Developed PO Exception Report, Requisition without PO Report in Purchasing using Reports 4i.
• Designed and Developed Checks Invoice Details report in Accounts Payables using Discoverer.
• Customized Open Payable invoices by Vendor using Reports 4i in Account Payables.
• Developed the PL/SQL validation program for the Vendor Interface process.