We provide IT Staff Augmentation Services!

Obiee Consultant Resume

Des Moines, Ia

SUMMARY

  • Over seven y ears of IT experience involving Analysis, Development and Implementation using standard SDLC methodologies.
  • Over five years of experience in designing and developing end - to-end BI solutions according to standard OLAP methodologies using Siebel Analytics/Oracle Business Intelligence (OBIEE), including full life cycle implementations.
  • Experience in Business Intelligence and Transactional applications, Design and Implementation of Data Warehouse/Data Mart, Gathering Business User Requirements, System Analysis, Design and Data Modeling.
  • Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas.
  • Very strong experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
  • Hands on experience in Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication and also implemented Single Sign on (SSO).
  • Expertise in implementing Security Models for Dashboards, Row level, object Level, Role Level, Dashboard Level
  • Experience in creating Aggregate tables using materialized views and using Aggregate Persistence wizard.
  • Expert in converting Functional specs to Technical Specs and implementing OBIEE Best practices
  • Expertise in configuring Interactive Dashboards with drill-drown capabilities using global and local filters, Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).
  • 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 Data Warehouse, OBIEE RPD development, OBIEE reports and Dashboards
  • Expertise in Data Warehouse Administration Console (DAC) to configure, monitor and schedule ETL.
  • Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center.
  • Strong experience in developing and customizing Reports using OBIEE 10.1.3.4.1 /10.1.3.4.0/ 10.1.3.3/10.1.3.2 , Oracle Reports 6i/4.5/2.5 Discoverer 10g/4i/3i, XML Publisher 5.6.3/5.6.2.
  • Extensively Worked on Informatica Power Center 8.x/7.x.
  • Extensively Worked on Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.

TECHNICAL SKILLS:

ETL Tools: Informatica 8.6, DAC.

Database & Tools: Oracle 10g/9i/8i/7.x, MS SQL Server 2000/2005, MS Access, IBM DB2 8.2, Teradata V2R6, ERWIN 4.0/3.5

Scripting: UNIX Shell scripts, K shell, C shell.

Languages/Utilities: C, SQL, PL/SQL, UNIX Shell Scripting, HTML and XML.

Operating System: Windows 95/98/NT/XP/Vista, Server 2003/2007, UNIX, Linux.

Other Tools: SQL Plus, SQL *Loader, TOAD.

PROFESSIONAL EXPERIENCE:

Confidential, DES MOINES, IA  

OBIEE CONSULTANT

RESPONSIBILITIES:

  • Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the Data Warehouse.
  • Worked with Business Groups to identify, analyze, and document Business Requirements.
  • Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
  • Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
  • Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
  • Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to 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.
  • Migrated Analytics RPD and Webcat from one environment to another.
  • Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions. ).
  • Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
  • Involved in setting up IBots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
  • 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.
  • 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.
  • Created and Customized Dimension Hierarchies to achieve the drill down functionality as per Business Requirements.
  • Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.
  • 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.
  • 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.
  • Involved in Integrating Oracle BI Presentation Services with BI Publisher.
  • Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflake Schemas.
  • 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 customizing out of the box reports to support the business Requirements.
  • Involved in configuring and customizing sources, targets, tasks and execution plans using DAC.
  • Involved in Query Tuning to maximize the performance of reports and Dashboards.

ENVIRONMENT: OBIEE 11.1.1.7.X, Oracle BI Apps 7.9.6.X, Informatica Power Center 8.6.1, Oracle 11g, EBS 11i, R12, DAC 10.1.3.4.1 , Oracle Applications 11i/R12 General Ledger, Accounts Payables, Accounts Receivable, Inventory, Purchasing, Fixed Assets, Toad, Linux, File-Zilla.

Confidential, CA 

SR. OBIEE DEVELOPER

RESPONSIBILITIES:

  • Implemented Financial Analytics and Procurement and Spend Analytics. Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
  • Gathered requirements from the client for GAP Analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
  • Extensively worked on SRs as per the client’s requirement to get the reports for the Business Analyzation.
  • 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.
  • Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
  • Created Environment Variable on Unix/Linux Environment.
  • 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, Payables, Receivables, Profitability, Dashboards in OBIEE.
  • Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics.
  • Designed and Developed Custom Mappings in Informatica to Load the Receivables Data from Legacy system.
  • To implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
  • Extracted various sources like Oracle tables and imported Flat files using Informatica Power center.
  • Extensively developed mappings on various business areas in the project by employing the available Transformations.
  • Responsible for extracting Data from Oracle Apps Modules & loading into stage system and warehouse system.
  • Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
  • Customized Dashboard pages like Overview, AP Balance, Payments Due, Payment Performance, Supplier Report, Invoice Details and AP Transactions in Payables Dashboard.
  • Customized Dashboard pages like Profit and Loss, Revenue, Products and Customers in Profitability Dashboard.
  • Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
  • 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.
  • 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.
  • Created Dimension hierarchies to achieve the drill down functionality.
  • Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
  • Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
  • Designed and Developed Sessions and Workflows.
  • Conducted training Sessions on Informatica power center.
  • Designed, implemented and tested security privileges on subject areas, dashboards and reports.

ENVIRONMENT: OBIEE 11.1.1.6.X, BI Apps 7.9.6, Informatica 8.6.0, DAC 10.1.3.4.1 , XML/BI Publisher 5.6.3, EBS 11i, R12, Discoverer 10g/4i/3i, Oracle Applications 11i/R12 General Ledger, Account Payables, Accounts Receivable, Inventory, Purchasing, Fixed Assets,, SQL*PLUS, SQL*Loader, TOAD, Unix.

Confidential, CONNECTICUT  

SR. OBIEE CONSULTANT

RESPONSIBILITIES:

  • Created Dashboards and Answers for End user.
  • Implemented Invoice level security in OBIEE depending on the user level access by integrating with EBS.
  • 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 many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services.
  • Was involved in the installing and configuring of Financial 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.
  • Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.
  • Responsible for extracting data from Oracle Apps Modules & loading into stage system and warehouse system.
  • Created and ran Sessions & Workflows to load the data into the Data warehouse.
  • Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
  • Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool.
  • Configured and Scheduled Sessions and Workflows.
  • Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.
  • Worked on multiple folders at time to meet the dead lines of the tasks.
  • Created VPD security for reports in OBIEE.
  • Designed and developed logical model in BMM in Repository.
  • Installed and Configured DAC.
  • 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.
  • Created custom reports in Payables in OBIEE according to user requirement.

ENVIRONMENT: OBIEE 10.1.3.2, Informatica 8.1.1, BI Apps 7.9.5, DAC 7.9.5, Oracle Applications 11i/R12 I procurement, General Ledger, Account Payables, Accounts Receivables, Fixed Assets, XML/BI Publisher 5.6.3, Discoverer 10g/4i/3i,, SQL*PLUS, SQL*Loader, TOAD, Unix.

Confidential, ENFIELD - CT  

SIEBEL ANALYTICS/OBIEE DEVELOPER

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: OBIEE 10.1.3.3/10.1.3.2 , Oracle Applications 11i (11.5.10) General Ledger, Account Payables, Accounts Receivable, Inventory, XML/BI Publisher 5.6.3, Discoverer 10g, SQL*PLUS, SQL*Loader, TOAD, UNIX.

Confidential  

ORACLE DEVELOPER

RESPONSIBILITIES:

  • Developed Syndicated oracle packages to include the rolling 24-month syndicated third party data that was mainly in flat files.
  • Provided support activities to their existing warehouse by developing new PL/SQL programs to support their existing structure and also data validation.
  • Interacted with the user group on a regular basis to discuss requirements and updates.
  • Performed mapping gap analysis between existing OTB mappings and already existing tables to support the new requirements.
  • Developed complex new Informatica ETL process and Mappings & Mapplets using various Transformations (Update Strategy, Filter, Router, Expression, Stored Procedure, Lookup, and Aggregator) and Workflows with Sessions / Tasks.
  • Designed and documented multiple interfaces using the Informatica Power Center.
  • Developed many complex Informatica mappings and mapplets to build key interfaces using transformations & reusable transformations (Source Qualifier, Update Strategy, Lookup, Expressions and Aggregator) for loading the data into DW.
  • Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable / parameters for simplifying complex mappings.
  • Performed Database and Informatica performance tuning and implemented the session partitions, changes to database by re-building the indexes, analyzing the objects etc.
  • Developed many Shell Scripts for pulling data from remote machines, Backup / Migration of metadata from version, development and production, FTP, untar & sending files to source directory, managing sessions files in the server.
  • Extensively developed complex PL/SQL packages for ETL.

ENVIRONMENT: Oracle 10g R2, TOAD, Informatica 6.x/7.x, Windows XP, Sun Solaris.

Hire Now