We provide IT Staff Augmentation Services!

Obiee/odi Consultant Resume

Boston, MA

SUMMARY

  • 6 years of Experience in Requirements Gathering, Analysis, Design, Development, Testing, Implementation, Documentation, User Trainings, Production Support, and Maintenance of Business Intelligence, Data Warehousing and Data migration Projects using ODI(ELT), and OBIEE (Siebel Analytics), Tableau reporting tools.
  • Experience using OBIEE 12c/11g and Siebel Analytics 8.1.1,Informatica 7, 8, 9.x, ODI 11g/12c, Endeca Information Discovery and Clover ETL process, MicroStrategy9.4, Business Objects XiR2/R3/R4 and QlikView V 11, Qlik Sense, Cognos.
  • Experienced in using Oracle Data Integrator (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into Enterprise data warehouse (EDW).
  • Worked extensively with Oracle BI (OBIEE) applications includes meta data configuration, dashboard report development, configuringPhysical Layer, Business Model, Logical Table, Dimension, Column, Logical Table Source, Logical Joins, Aggregation Rules, Dimension Hierarchies, Complex Case Expressions, Facts, Dimensions, Repository Static/Dynamic Variables, Session Variable, iBots,SSO(Single Sign On),Oracle BI Views (Compound Layout, Chart, Gauge, Title, Narrative, Table, Pivot Table, Funnel Chart) etc.
  • Hands - on implementing Oracle BI Apps in all phases like implementing Out of order Box prebuilt mappings(Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.), Designing ETL, metadata management using DAC, Creating Oracle provided Data Warehouse, OBIEE RPD development, OBIEE reports and Dashboards.
  • Setup Multi User Development Environment (MUDE) using BI Administration tool.
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data.
  • Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL and PL/SQL.
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
  • Created numerous ODI Interfaces to implement Business Logic with ODI Graphical (Designer, Topology Manager, Operator, and Security Manager) & Knowledge Modules (Reverse-engineering, Journalizing, Loading, Check, Integration).
  • DevelopedETL Transformations, Informatica Designer (joiner, expressions, lookups, filters, routers, stored procedures etc.,), Informatica Workflow Manager (Sessions, sources, targets, transformations etc., & direct, indirect sources), Informatica Workflow Monitor, and Repository Manager.
  • Expertise in building Enterprise Data Warehouses (EDW),Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model (Kimball and Inmon), Star and Snowflake schema design addressing slowly Changing Dimensions (SCDs)
  • Performed Unit, Integration, Regression and UAT testing to validate reports, dashboards and mappings.

TECHNICAL SKILLS

BI Tools: OBIEE 11g/12C, Cognos, Tableau, Qlik sense 2.x, QlikView, Oracle BI Publisher, BI APPS 7.9.6.x/7.9.5.x, Siebel Analytics 8.x, 7.x (Administration, Answers, Interactive Dashboards, BI Publisher, Disconnected Analytics, Briefing Books, BI Delivers, Analytics Server Administration).ETL Tools Informatica 9.x/8.x, ODI 11g/12c, DataStage

Scheduling Tools: Datawarehouse Administration Console (DAC).

ERP Applications: Oracle R12/11i (Financials (General ledger, Accounts Payable, Accounts Receivables)).

Databases: MS office, Toad, Data Loader, SQL Loader, IBM DB2, MS Access, MYSQL

Languages: Java1.6, C/C++, PL/SQL, Java script, Visual Basic

Software Methodologies: Object Oriented Analysis & Design, UML,SDLC (Agile, Iterative)

Modeling Tools: RUP, MS Visio, Influx Tool for BPE

Documentation: MD050, BR100, BR30, TE040, User manuals

Web Technologies: HTML, XML, CSS

Operating Systems: UNIX, WINDOWS XP/7.0.

PROFESSIONAL EXPERIENCE

OBIEE/ODI Consultant

Confidential -Boston, MA

Responsibilities:

  • Decommissioning of OBIEE Reports, Oracle Discoverer Reports and BIP Reports to OBI Cloud Services (BICS) Platform of different oracle modules like Manufacturing Supply Chain and Management, Sales Operations, HR etc.
  • Worked on the Technical and FunctionalDesignBusinessRequirements gathering, and documented the Technical DesignDocuments, Functional Design Documents and Data Lineage Documents as per the businessrules.
  • CreatedODIInterfaces for reading data from xml using external properties and loaded into staging table.
  • CreatedODIInterfaces to load data into ODS for downstream systems.
  • Configured Interactive Dashboard with drill-down capabilities usingglobal and localFilters, MetadataObjects and WebCatalogObjects.
  • Implementing change in the Product Hierarchy and held responsible for all the dashboards and reports in the data level
  • Backtracking of the OBIEE Metrics in the Rpd level and in the SDE and SILO’s Mappings in the Informatica to get the EBS Source Columns.
  • Re-Modeling the existing Tables, Views and Materialized Views in the data mart to improve the performance of the BICS dashboard using SQL.
  • Analyzed the current data model and modified it to get the Shipment Information, Inventory details and Backlog Units etc... In the Oracle Apps Schema.
  • Develop Business Intelligence Models, Cubes, reports and Dashboards in Oracle Business Intelligence Systems.
  • Decommissioning of HR Analytics OBIA and maintain separate instance for the HR model in the Dev, QA to implement in Cloud Environment (BICS).
  • Implemented Consistent set change data capture (CDC) for real time reporting.
  • Managed security privileges for each subject area and dashboards according to user requirements.
  • Prepared the Test Plans and Test cases for User validation (UAT) of the reports/dashboards.
  • Successfully implemented the code in DEV and deployed in UAT, Debuggedand tested in final Test and deployed in Production.
  • Day to day monitoring of varies interfaces to other internal applications and external vendors for the smooth functioning of the business.

Environment: BI Apps, OBIEE 11g/12C, BICS, Oracle EBS R12, Oracle Business Intelligence Enterprise Edition (OBIEE) 12C, BI Publisher, Data Warehouse Administration Console (DAC), Oracle Supply Chain Management, Manufacturing, Financial and HR Modules, Oracle 11g, PL/SQL, SQL*Plus

OBIEE/ODI Consultant

Confidential - Sunnyvale, CA

Responsibilities:

  • Customized the OBIEE messages by creating Custom Message XML files
  • Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts.
  • Worked extensively on performance tuning including creating aggregate tables, caching and event polling tables.
  • Created Financial Analytics reports which are used to analyze Trial Balance, Intercompany Balances, Journal Inquiries, Flow Analysis, Expense Analysis, Treasury Movement of Cash analysis and Payable reports.
  • Implemented Financial Analytics, Supply Chain and HR Analytics
  • Designed AFE Supplement, Well Analysis and CAPEX Accrual Dashboards to provide Business Critical Analytical view of the Written Sales for a set of Power Users.
  • Upgraded Rpd, Web Catalogs from OBIEE 11.1.1.7 to OBIEE 12c.
  • Configured Usage Tracking and developed reports for BA's to track the users using the reports based on Subject Areas.
  • Created different Views like Table, charts, pivot tables, view selectors, narratives and column selectors.
  • Created Application Roles in Oracle Enterprise Manager 11g and set the permissions on dashboard pages using the application roles.
  • Implemented Scorecards and KPI for the sales and commission data.
  • Involved in performance tuning by setting Cache, limiting the number of initialization blocks, limiting select table types, pushing the calculation to the database.
  • Administered NQSConfig.ini and Instanceconfig.xml configuration files by changing html tags a per business requirements.
  • Customized Out of the box Repository (RPD) to work with other ERP systems and Pulled new physical tables to physical layer of RPD, joined them with dimensional tables, developed hierarchy and presented them to presentation layer.
  • Created ODI interfaces, packages, procedures.
  • Reverse engineer data stores from various source systems like Oracle, Essbase, flat files and excel files.
  • Worked on ODI options to customize Knowledge Modules.
  • Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.
  • Worked on the LKM SQLLDR KM to load huge amounts of data from flat file to Oracle table.
  • Extensively used ODI variables in various scenarios to developer ODI packages, scenarios as per requirements.
  • Worked on ODI security manager to set up ODI users and privileges.

Environment: OBIEE 12c/ 11.1.1.7/ 10.1.3.4.1 , ODI 11g/12c, BI Apps 7.9.6.3, Hyperion IR (Brio), Oracle EBS R12 (12.2.2.4), BI Apps 7.9.6.3/7.9.6.4 , DAC 10.1.3.4.1 , 1SAP, Linux, UNIX, SQL DEV, BI/XML Publisher, Oracle 11g, Toad, PL/SQL

OBIEE/ODI Consultant

Confidential - Houston, TX

Responsibilities:

  • Primary responsibility includes installing and configuring the Oracle Data Integrator ODI software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL
  • Used ODI 11g/12c for extraction, loading and transformation ETL of data in the data warehouse
  • Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
  • Extensively involved in production issues.
  • Gathering requirements from users/business to develop interfaces, packages, Load plans.
  • Used Yellow Interfaces Reusable mappings in ODI 12c for developing most complex interfaces.
  • Increased performance of loads by applying proper Hints, Indexes, and Analyzing master tables and explain plans to check cost.
  • Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
  • Extensive Experience on Topology Navigator with developing Physical and Logical Architecture, Contexts and Configuring Agents.
  • Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.
  • Extensively used ODI to load data from Oracle, XML files and flat files
  • Worked closely with the end users/business and designing the documents to the track changes.
  • Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database and Oracle EBS interface tables.
  • Deployed rpd and catalogs using Enterprise manager.
  • Created new reports and dashboards as per the business need.
  • Analysis, Design, Implementation, documentations, and BI specifications that in corporate OBIEE development standards best practices as well as ongoing support for Data Warehouse.
  • Worked on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE Administration tool.
  • Worked on performance tuning of various OBIEE Reports / Dashboard.

Environment: Oracle Data Integrator ODI 11g/12c, OBIEE 11g/12C, Oracle 11g, SQL Plus, TOAD

OBIEE Developer

Confidential - California

Responsibilities:

  • Worked on BI Publisher reporting and build complex Data Models, Templates as per the business requirement that had to return huge data volumes.
  • Designed the Physical layer, BMM layer, Presentation Layer in RPD, created the session variable and Dynamic variable in RPD.
  • Migrated the Web Catalog, Mappings and ETL Transformation from Test to ProductionEnvironments.
  • Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
  • Working in Financial and Manufacturing modules.
  • Customization and enhancement of standard Oracle applications reports like Material Account Distribution Detail (MADD), Invoice Validation report, Cash requirement report using Oracle BI Publisher.
  • Worked on BI Publisher importing data from the data source and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
  • Created different kinds of Parameters and list of values according to the user requirement.
  • Changed the query in the View level and Data model level according to the user requirements.
  • Worked on Expression Builders and Calculation Wizards to generate certain expressions and formulae, created new logical columns based on the requirement
  • Schedule reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards.
  • Extensively worked on Answers, Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector and Table).
  • Developed different brand level Reports, Filters, and Prompts using Oracle Business Intelligence Answers.
  • Designed and Configured Intelligent Dashboards in Analytics for different groups of users which include business users from various parts of the world.
  • Successfully implemented the code in DEV and deployed in SIT and UAT,Debugged and tested in final Test and deployed in Production.
  • Designed and Developed the RPD and reports by using the column selector, pivot table view selector.
  • Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
  • Designed and Configured Intelligent Dashboards in Analytics for different groups of users which include business users from various parts of the world.
  • Used Transformations like look up, Router, Filter, Joiner, Stored procedure, Source Qualifier, Aggregator and Update strategy extensively.
  • Modified the existing mappings and mapplets based on user change requests to implement new business logic and improve the Session Performance.
  • Successfully implemented the code in DEV and deployed in SIT and UAT,Debugged and tested in final Test and deployed in Production.

Environment: BI Apps 7.9.6.3, Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7, BI Publisher 11.1.1.1, Hyperion IR (Brio), Informatica Power Center 8.6, Data Warehouse Administration Console (DAC), Oracle Financial and Manufacturing modules, Oracle 11g,PL/SQL, SQL*Plus

OBIEE Developer

Confidential

Responsibilities:

  • Participated in requirements gathering by meeting with the business user and base lining the details.
  • Identified the Data Sources (Relational, Excel etc.), Identified Business Model, Determined Facts & Dimensions, Granularity, and Data Consistency across Dimensions.
  • Designed and BuiltOBIEERPD at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs.), test and validate the model.
  • Implemented Financial Analytics. Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
  • Designed and Developed Financial Dashboard like General Ledger, Payables, Receivables.
  • Developed Dashboard pages like Budget Vs Actual, Finance Structure, Cash Flow and Asset Usage in General Ledger Dashboard.
  • Developed Dashboard pages like Overview, Effectiveness, Invoice Details and Payment Performance in Receivables Dashboard.
  • Developed different kinds of Reports Pivots, View Selectors, Column Selectors, and Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters, and Page/Dashboard Prompts.
  • Created Week Ago,and Month Ago and Year Ago Fact Measures and Dimension attributes.
  • Managed Security Privileges for each Subject Area and dashboards according to user requirements.
  • Debugged reports and Dashboards visibility with respect to user's responsibilityand web groups in an integrated environment.
  • Prepared the Test Plans and Test cases for validating the reports/dashboards.
  • Written many SQL statements for validating the reports and used the same in Test documents.
  • Performed Tuning of Dashboards/Reports by aggregate navigation, and cache management.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.0/10.1.3.4 , Informatica 8.6, Oracle 11g/10g, BI Publisher, PL/SQL, SQLDeveloper, Windows XP.

Hire Now