SUMMARY:

• 14+ years of diversified IT experience working wif OBIEE/ODI including (OBIA), which consist designing RPD and developing OBIEE Dashboards, BI Publisher wif ODI Extraction
• Oracle Application Tech Lead wif 16 plus years of progressive professional experience wif Oracle Applications Technologies, Oracle Products and full cycle of Oracle E - biz suite (11i and R12) implementations
• Expertise in OBIEE 12c, WEBLOGIC 12c implementation and Administration
• 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 noledge wif ESSBASE application set up, metadata, dimensions, rules, web data entry forms, and task flow manager
• Configured and customized ODI ETL mappings to meet teh client requirements including monitoring incremental and full load of data through BIACM and ODI
• Experience in performance tuning Data Warehouse to meet Business Intelligence needs for applications such as Hyperion EPM applications and OBIEE
• Implemented authentication of WebLogic LDAP for external Authentication (AD) also implemented Single Sign on (SSO)
• Scheduling teh ODI loads using Scheduler through ODI Studio/Control-M
• Have successfully installed and configured OBIA (7.9.6.1 to 11.1.1.10.2) applications including ODI for multiple engagements

PROFESSIONAL EXPERIENCE

Confidential

OBIEE/ODI Architect

Responsibilities:

• Configuration of OBIA Financials A/P, A/R, GL, Fixed Assets, Transaction Monitor reporting. RPD, BI catalog (Dashboard and Reporting and ODI ETL Load Plan, OBIA Configuration Manager Object design and development
• Researched and evaluated new reporting technologies and made recommendations to upper management to facilitate planning and future systems development efforts
• Technical and functional direction in many group meetings on base Air Force (Wright-Patterson) for interfacing SOA and Oracle e-Business Suite R12 modules into Oracle Warehouse
• Design architectural functional including technical documentation for Oracle EBS Reporting & Business Intelligence technologies, including OBIEE BI Publisher
• Designed ETL architecture for Air Force DEAMS project, including agents, scenarios, packages, data mapping, data extractions, transformations and validations.
• 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 teh repository
• Developed OBIEE Dashboards wif different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, wif global and local filters) using Oracle BI Presentation Services
• Customize OBIA 11.1.1.10.2 out of teh box Financials Dashboards including modifications to RPD
• Customize OBIEE Repository (Physical, business and presentation layer) to provide Analytical Reporting solutions for Air Force DEAMS project
• 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
• Provided technical support 24x7 for teh database and application activities in Production, Development environments that includes design, installation, implementation, operation and maintenance of Oracle 11g RDBMS and Oracle Applications 11.5.10.2 and 12.2.3
• Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including Hyperion Planning, Essbase, Relational Database
• Implemented teh install and configuration on of BPEL and SOA based applications
• Develop data extracts from data warehouse environment using ODI and Implemented Journalizing Knowledge Module JKM for integration into Gloden Gate
• Installed, configured OBIEE 12c and supported users' adhoc queries, participated in hardware planning for all 4 environments
• Designed OBIA RPD to provide Analytical Reporting solutions to business, also Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, as related to business needs

Confidential

OBIEE/ODI Architect

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 teh Financial Statement reports and Intelligence Dashboards (Financials) as per teh detailed design requirements
• Configured ODI JKM to extract source data once and replicate it into both teh Foundation Layer and Raw Data Reservoir in parallel
• Configure ODI Integration to Apache HBase through using teh 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 teh jobs through teh ODI Studio and Weblog Application Server
• Develop data extracts from data warehouse environment using ODI and Implemented Journalizing Knowledge Module JKM for integration into Glodengate
• Customize any OBIA out of teh 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 teh business model to different users and assigned group permissions to teh catalog folders
• Installation and configuration of teh 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 teh 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 teh 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 teh daily refresh of teh Data Warehouse
• Setup OBIEE 11.1.1.7.1 security roles and groups wif integration into external directory Active Directory and OIM, including SSO
• Configured teh csv files required for teh source independent load and source dependent load.
• Involved wif Oracle SME in developing queries to validate teh data in Oracle Business Applications Warehouse (OBAW) against teh source PeopleSoft 8.9
• Used tuning techniques to increase teh performance of slowly running OBIEE 11.1.1.7.1 reports.
• Senior OBIEE architect for converting salesforce.com reporting into OBIEE also as part of teh 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 teh 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 teh 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 teh materialized views, partitions, re-building of indexes, overwriting teh 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
• Installation and configuration of OBIA 7.9.6.4 including configuration of informatica/DAC connectivity for seamless integration into teh 11g Data Warehouse.
• Developed custom OBIEE 11g dashboards wif direct connection into PeopleSoft financials including RPD development
• Created OBIEE/RPD Dimension Hierarchies to achieve teh drill down functionality as per Business Requirements
• Lead OBIEE ADMIN for performance issues and weekly RPD and web catalog migrations
• Upgraded OBIEE from 10.1.4 to 11.1.1.7.1
• Successfully Implemented Oracle HR Analytics and created separate execution plans for teh daily refresh of teh Data Warehouse
• Setup OBIEE 11.1.1.7.1 security roles and groups wif integration into external directory Active Directory and OIM, including SSO

Confidential

OBIEE/ODI Architect

Responsibilities:

• One Man install and implementation OBIEE 11g for all environments (DEV, UAT, PRODUCTION) include update and running informatica power center to move data from source to target (EBZ), preformed all OBIEE security setup using weblogic
• Created ETL load plan and scenarios for extracting and loading data from a variety of data sources/targets including Essbase
• Setup LDAP to enable SingleSign on for Users in Development environment leveraging Analytics Repository
• Customize 67 OBIA out of teh box OBIEE dashboards also integrated ESSBASE cube data into OBIA reports
• Manage Daly OBIEE maintenance, RPD/CATALOG migrations including OBIEE patches and upgrades
• 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 teh 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 teh required objects (Dimensions and Facts) wif integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down, Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating teh Presentation catalogs in Presentation Layer
• Developed customized OBIEE reports and interactive dashboards wif 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 teh OBIEE environment including ETL
• Conducted training sessions for end users on OBIEE and OBIA Applications
• Gatheird Business requirements by interacting wif teh 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 teh 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 teh 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

OBIEE/ODI Architect

Responsibilities:

• Gather requirements and conduct interview sessions wif 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 wif 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 teh End users.
• Developed Reports / Dashboards wif 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 teh training materials for teh end users.
• Conducted training sessions for end users on BI tool.
• Performed teh Installation and configuration of teh complete OBIEE environment and teh required connectivity for seamless integration wif teh 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 wif 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 teh End users.
• Designed and Developed Informatica Mappings from Scratch to Load teh Data from Source System to Staging system and Warehouse System.
• Developed Reports / Dashboards wif different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, wif 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.
• Install OBIEE 10g for all environments migrated data to Peoplesoft to warehouse using connection in RPD
• Design Reporting warehouse to achieve star schema
• Created 22 dashboards from end user functional documentation

Confidential

Oracle DBA

Responsibilities:

• Responsible for teh 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 teh 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 teh repository building in OBIEE..
• Created reports in Answers and embedded them in Dashboards according to teh 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 teh testing and validating teh 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 teh design and development of execution plan in DAC which will call teh Informatica workflows and updates teh 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.
• Designed and Developed OBIEE financial dashboard pages in general ledger, payables and receivables.
• Implemented dynamic dashboard prompts to zoom into particular segments of teh 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 teh requirements.
• Optimized performance by tuning teh Informatica ETL.
• Designed and developed various Dashboards that are Dynamic & Interactive wif drill-down & drill-across capabilities wif local & global filters.
• Developed an Interface for teh 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 DBA

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 wif standard applications.
• Involved in Open Sales Order conversion based on client specifications.
• Imported Items from legacy system into Oracle Inventory using teh 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 teh reports.
• Developed OBIEE Reports / Dashboards wif different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular wif 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 teh 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 teh adhoc report according to teh 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.
• 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 wifout PO Reportin 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 teh PL/SQL validation program for teh Vendor Interface process.