We provide IT Staff Augmentation Services!

Obiee/odi Architect Resume

MiamI

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
  • Oracle Application Tech Lead with 16 plus years of progressive professional experience with 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 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 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 the 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

TECHNICAL SKILLS:

Oracle Applications: 11.1.1.7.1, 11.1.1.9.2

Application Tools: BI Publisher

Databases & Tools: Oracle 11g TOAD, SQL Navigator, SQL*PLUS,SQL* 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

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
  • Excellent relationship with Officers and Technical staff at Air Force (Wright-Patterson) cultural and organizational, also ex-US Navy
  • 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 the repository
  • 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 Financials Dashboards including modifications to RPD
  • Customize OBIEE Repository (Physical, business and presentation layer) to provide Analytical Reporting solutions for Air Force DEAMS project
Confidential

OBIEE/ODI Architect

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
  • Provided technical support 24x7 for the 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 the 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 Golden 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 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, Miami

OBIEE/ODI Architect

Responsibilities:

  • 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.
  • 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

OBIEE/ODI Architect

Responsibilities:

  • 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/ODI Architect

Responsibilities:

  • Installation and configuration of OBIA 7.9.6.4 including configuration of informatica/DAC connectivity for seamless integration into the 11g Data Warehouse.
  • Developed custom OBIEE 11g dashboards with direct connection into PeopleSoft financials including RPD development
  • Created OBIEE/RPD Dimension Hierarchies to achieve the 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 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
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 the box OBIEE dashboards also integrated ESSBASE cube data into OBIA reports
  • Manage Daly OBIEE maintenance, RPD/CATALOG migrations including OBIEE patches and upgrades
Confidential

OBIEE/ODI Architect

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

OBIEE/ODI Architect

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

OBIEE/ODI Architect

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

Oracle DBA

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

Oracle DBA

Responsibilities:

  • 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 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

Oracle DBA

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 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 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

Oracle DBA

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.

Hire Now