We provide IT Staff Augmentation Services!

Sr. Obiee Developer Resume

San Jose, CA

SUMMARY:

  • Over Eight years of experience in OBIEE (Oracle Business Intelligence Enterprise Edition)/Siebel Analytics, Oracle BI Applications and Oracle Apps(Oracle EBS) implementations.
  • Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using Ralph Kimball and Bill Inmon Methodology.
  • Expertise in implementing Oracle BI Apps in all phases like implementing Out of order Box prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided DataWarehouse, OBIEE RPD development, OBIEE reports and Dashboards
  • Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center.
  • Expert in converting Functional specs to Technical Specs and implementing OBIEE Best practices.
  • Facilitated JAD (Joint application development) sessions with business users and development teams to drive out detailed business requirements.
  • Exceptional Documentation Skills for writing Use Cases, Functional Requirement Documents (FRDs), business requirements documents (BRDs) as well as for creating Use Case diagrams, Activity diagrams, time sequence diagrams, State chart diagrams based on UML Methodology. Also, created business process flow diagrams using MS Visio, Enterprise Architect and Rational Rose.
  • Extensively worked on Installation and configuration of Financials, Supply Chain Analytics, Procurement Analytics and Spend Analytics.
  • Extensively Worked on Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, Aggregator.
  • Expertise in Data Warehouse Administration Console (DAC) to configure, monitor and schedule ETL.
  • Proficient within the Physical Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration tool.
  • Expertise in implementing Security Models for Dashboards, Row level, object Level, Role Level, Dashboard Level
  • Expertise in Creating Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Drill down Properties.
  • Extensively worked on BI Server, BI Answers, BI Dashboards and BI Delivers (iBots)
  • Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.
  • Proficient in Oracle Tools and Utilities such as SQL Developer, SQL * Loader, SQL * Plus, Data Loader, TOAD and UTL FILE.
  • Experienced in Complete Software Development Life Cycle (SDLC) which includes System study, Analysis, Physical and Logical design, Resource Planning, Coding, Testing and implementing business applications.
  • Involved in development of RICE objects (Reports, interfaces and data conversions, customizations, extensions) for the Oracle Applications E - Business Suite implementation across major modules.
  • Experience in design, analysis, development, testing and implementation of applications in Oracle E-Business Suite using PL/SQL, Developer 2000, Oracle Reports 10g/9i/6i, Oracle Discoverer 10g/4i, XML Publisher 5.6.3/5.6.2 .
  • Extensively worked on Oracle Discoverer, which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL).
  • Designed Report Templates using XML/BI publisher.
  • Strong Conceptual, Business, Analytical skills and highly motivated team player and ability to provide work estimates and meet deadlines.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Sr. OBIEE Developer

Responsibilities:

  • Worked with Business Groups to identify, analyze, and document Business Requirements for OBIEE/DW Projects.
  • Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
  • Performed the setting up, Installation and configuration of the complete Analytics platform environment
  • Worked with Oracle BI Repository like, Presentation Layer, Business Model and Mapping Layer (BMM), Physical Layer and migration of the Code, Repository (RPD), Dashboard Reports from Dev to Test/QA and to Production and developed Folders, Dashboards, Pages Columns, Sections, Requests / Answers, Filters, Global Filters, Navigation Links, Views / Charts.
  • Worked with Oracle BI (OBIEE) Installation, Oracle BI Server, Presentation Server, Oracle BI Repository (RPD), Oracle BI Administration.
  • Responsible for configuring the Source and lookup files.
  • Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables including Physical, Logical data modeling in the OBIEE Administration tool.
  • Customizing the existing informatica repository and adding new mappings and workflows based on the requirements.
  • Extensively worked on Answers, Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector and Table).
  • Configured OBIEE iBots to deliver Analytics content based on schedule, automated iBot queries. 
  • Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.
  • Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to Data Warehouse (OLAP) system.
  • Designed and Developed Custom Mappings and Workflows in Informatica to bring the data from other data source systems and Integrated using Universal Adapters in DAC.
  • Implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
  • Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool. Migrated Analytics RPD and Web catalog from one environment to another.
  • Implemented security by creating Users, role and User groups.
  • Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.
  • Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
  • Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
  • Involved in Query Tuning to maximize the performance of reports and Dashboards
  • Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
  • Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
  • Imported and Exported Execution Plan in DAC from one Instance to other Instance.
  • Expertise working with BI XML Publisher, Data Templates, RTF, XSL Templates
  • Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflake Schemas.
  • Designed and Developed Sessions and Workflows.
  • Involved in Unit Testing, Peer Testing and Regression Testing.

Environment: Oracle Applications R12, Service Requests, Service Contracts, Install Base, General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management, Oracle Purchasing, OWB, Oracle 11g/10g/9i (9.2.0), OBAW, OBIEE 11.1.1.3/ 10.1.3.4.1 ,Siebel (OBIEE, Informatica), Informatica 8.6.1, DAC 10.1.3.4.1 , XML/BI Publisher 5.6.3, Discoverer 10g, Repots10g, ANSI SQL, SQL*PLUS, SQL*Loader, TOAD, Unix(shell scripting).

Confidential, GA

Sr OBIEE Consultant

Responsibilities:

  • Analyzed Business Requirements/Functional Documents and prepared Technical documents.
  • Involved in installation and configuration of OBIEE, Informatica and DAC.
  • Integrated OBIEE with EBS for Single Sign On (SSO).
  • Worked on integrating and configuring BI Publisher with OBIEE.
  • Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
  • Involved in the installing and configuring of Financial and Supply Chain Analytics.
  • Built Siebel Analytics Repository at 3 layers i.e., Physical Layer (connecting to Data sources and import schema), Business Model / data mapping (create Logical tables and data source mapping) and Presentation Layer level (create presentation catalogs).
  • Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets.
  • Responsible for customizing the out of box reports and creating new reports and dashboards.
  • Developed Reports/Dashboards by implementing different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).Created Environment Variable on Unix/Linux Environment.
  • Configured the Anlaytics repository(RPD) and implementedthe security to authenticate and authorize Oracle users.
  • Extensively used Transformations like Lookup, Router, Normalize, Aggregator, Source Qualifier, Joiner, Expression and Update Strategy.
  • Designed and implemented Informatica Power Center 8.6 for ETL to load target Oracle 11g database.
  • Responsible for extracting Data from Oracle Apps Modules and loading into stage system and warehouse system.
  • Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
  • Used Template, sub Template method for a creating single report with multiple Layouts.
  • Designed and developed BI Publisher reports according to client requirement
  • Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
  • Imported and Exported Execution Plan in DAC from one Instance to other Instance.
  • Customized Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
  • Customized the Repository by creating Facts and Dimensions and adding some extra columns to the Existing Facts and Dimensions.
  • Developed Custom Reports from OLTP without creating any Views or Tables in EBS Database in IProcurement, Payables and General ledger.
  • Designed and Developed Dashboard Pages Like Total Spend Overview, Trends, Exceptions, Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee Expenses in Procurement and Spend Dashboard.
  • Designed and Developed Procurement and Spend and Supplier Performance, General Ledger Dashboards in OBIEE.
  • Designed and Developed Dashboard Pages Like Trends, Exceptions, Supplier Payables, Quality Performance, Delivery Performance and Price Performance in Supplier Performance Dashboard.
  • Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics.
  • Designed and developed Delete Cancelled requisitions program to delete all the cancelled requisitions in iProcurement.
  • Setup the visibility of Dashboards to employees with respect to their responsibilities. Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
  • Configured Row Level Security, Column Level Security and Object level security to allow users to view their respective data only according to the requirement.
  • Performed Unit, Integration and Regression testing to validate reports and mappings.

Environment: OBIEE 10.1.3.4, Oracle Applications R12, General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management, Supply Chain(SCM), Service Contracts, Install Base, Oracle 11g/10g/9i (9.2.0), OWB, SAP BO, OBIEE 10.1.3.4.0 ,SIEBEL Analytics 7.x, RPD, Dashboards, Delivers(iBots), Informatica 8.1.1, DAC 7.9.5, XML/BI Publisher 5.6.3, Discoverer 10g, SQL*PLUS, SQL*Loader, TOAD, Unix(shell scripting).

Confidential, VA

OBIEE Technical Consultant

Responsibilities:

  • Interacted with business Management representatives for gathering the Reports/ Dashboards requirements and to define business and functional specifications.
  • Designing the Technical Design documents by understanding the Functional Design documents.
  • Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
  • Created Dashboards and Answers for End user.
  • Worked with Security of the application/solution to define users and groups, set permissions, Group Inheritance, Authentication Methods, Query Limits, Timing Restrictions, and Filters.
  • Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
  • Developed reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly sales for each region & send alerts to upper management.
  • Created new repository, customized existing metadata Repository (.rpd).
  • Was involved in the installing and configuring of Financial Analytics.
  • Worked on Answers to build Interactive Dashboards with drill-down capabilities
  • Created reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
  • Designed and Developed General Ledger, Payables, Receivables and Profitability Dashboards in OBIEE.
  • Developed Dashboard pages like Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
  • Developed Dashboard pages like AR Balance, Payments Due, Invoice Details and All AR Transactions in Receivables Dashboard.
  • Developed Dashboard pages like AP Balance, Overview, Payments Due, Supplier Details and Invoice Details in Payables Dashboard.
  • Developed Dashboard pages like Overview, Margins, Revenue, Products and Customers in Profitability Dashboard.
  • Setup Multi User Development Environment (MUDE) in OBIEE.
  • Responsible for extracting data from Oracle Apps Modules and loading into stage system and warehouse system.
  • Created and ran Sessions and Workflows to load the data into the Data warehouse.
  • Created Business Facts & Dimensions and defined Logical relation between them in BMM layer.
  • Extensively used Transformations like Lookup, Router, Normalize, Aggregator, Source Qualifier, Joiner, Expression and Update Strategy.
  • Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool.
  • Configured and Scheduled Sessions and Workflows.
  • Created VPD security for reports in OBIEE.
  • Designed and developed logical model in BMM in Repository.
  • Installed and Configured DAC.
  • Maintained the Full and Incremental loads through DAC on different environments like Development and Test environment.
  • Used SQL loader to import data from large flat files and Excel sheets to Oracle tables.
  • Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
  • Created custom reports in Payables in OBIEE according to user requirement.
  • Involved in Unit Testing, Peer Testing and Regression Testing.

Environment: Oracle Applications 11i/R12 iProcurement, General Ledger, Account Payables, Accounts Receivables, Fixed Assets, BI Apps 7.9.5, OBIEE 10.1.3.4.0 /10.1..3.3/10.1..3.2, Informatica 8.1.1, DAC 7.9.5, XML/BI Publisher 5.6.3, Discoverer 10g/4i/3i,, SQL*PLUS, SQL*Loader, TOAD, Unix.

Confidential, FL

OBIEE Technical Consultant

Responsibilities:

  • Worked with business users to gather business requirements and provided reports in Financial, manufacturing and Supply Chain modules.
  • Designed and Developed Financial Dashboard like General Ledger, Payables, Receivables.
  • Created AD hoc reports in Account Payables.
  • Developed Dashboard pages like Finance Structure, Cash Flow and Asset Usage in General Ledger Dashboard.
  • Developed Dashboard pages like Effectiveness, Invoice Details and Payment Performance in Receivables Dashboard.
  • Developed Dashboard pages like Overview, Payments Due, Effectiveness and All AP Transactions in Payables Dashboard.
  • Created Dashboard prompts and advance filter criteria.
  • Created reports in Answers and embedded them in Dashboards according to the requirements.
  • Was part of the installation team to install OBIEE BI Apps.
  • Designed and developed custom Dashboards.
  • Designed and developed Customer Interface, Auto Lockbox Interface.
  • Extensively Modified Shipping INBOUND/OUTBOUND interface programs to accommodate changes in business process.
  • Designed Customer Products Summary Report in Install base using OBIEE.
  • Created and ran Sessions & Workflows using Informatica Workflow manager to load the data into the Data warehouse.
  • 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.
  • Customized Supplier Payment History Report in Account Payables to meet client requirements.
  • Customized GL Detailed Trial balance report, GL Period to Date Balances reports in General Ledger using FSG’s.

Environment: Oracle Applications 11i (11.5.10) General Ledger, Account Payables, Accounts Receivable, Inventory, OBIEE 10.1.3.3/10.1.3.2 , XML/BI Publisher 5.6.3, Discoverer 10g, SQL*PLUS, SQL*Loader, TOAD, UNIX.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

  • Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes.
  • Designed and Developed AP Check Printing Report, Invoice Detail Report by Supplier, Payment Schedule Report in XML/BI publisher.
  • Customized the standard AR Aging Report and Invoice History Report using XML/BI publisher.
  • Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.
  • Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
  • Designed, implemented and tested security privileges on subject areas, dashboards and reports.
  • Developed new report Credit Memos in AR using Discoverer.
  • Developed GL journal Import interface program in General Ledger.
  • Customized Chart of Account Detail listing, Trial Balance, Summary Income Statement in General Ledger using FSGs.
  • Converted Order Detail Report, Credit Order Summary Report, Orders by Item Report in Order management from report 6i to XML/BI publisher.
  • Created new responsibilities and involved in defining the required system profile options.
  • Loaded data to the interface tables and populated data to Standard Tables through Standard Order Import Program.

Hire Now