We provide IT Staff Augmentation Services!

Obiee / Bi Apps Analyst Resume

0/5 (Submit Your Rating)

Pittsburgh, PA

SUMMARY:

  • Over 7+ years of professional experience as OBIEE Consultant and BI APPS Consultant with understanding of Oracle E - Business Suite Applications in HR analytics OM order management, Purchasing PO, Inventory INV, Bill of Material BOM, Work in Process WIP, General ledger GL, Account Payables AP and Account Receivables AR and Hyperion Essbase cubes
  • Expertise in OBIEE 10.1.3.4.1 /11 g (Analytics) Architecture and Reporting.
  • Experience with OBIA 7.x and vast experience in IT involving gathering Business Requirements, GAP Analysis, Data Modeling Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts.
  • Proven skills in complete lifecycle of Design, Analysis, Development, and Implementation of Business Intelligence with Star and Snow Flake Schemas using Kimball and Inman methodology using OBIEE, Siebel Analytics 7.x and Informatica 8.x/7.x/6.x, Informatica B2B data transformation.
  • Extensive experience in providing end-to-end BI solution by dimensional modeling design, Logical/Physical models, building/configuring RPD, Answers, Delivers / iBots, creating reports / Dashboards, Cache management, and setting up Security using LDAP Authentication and Basic RPD Authentication.
  • Experience configuring Interactive Dashboards with drill-down and drill through capabilities using global and local Filters, OBIEE Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
  • Experience in using Presentation, Repository and Session variables and Initialization blocks in OBIEE.
  • Experience in administering various OBIEE environments with large number of users and providing optimum system uptime and performance; designing security matrix, configuring authentication and authorization architecture, and providing permissions to users according to their role.
  • Worked on BI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
  • Expertise in developing OBIEE repositories from scratch, and also many Reports/dashboards with different analytics views (drill-down/dynamics, cascading style sheets, pivot table, chart, column sector, tabular with local and global filters) using OBIEE Answers/Dashboard.
  • Troubleshooting performance related issues with reports and data.
  • Experience in developing various dynamic and interactive complex reports/dashboards with intuitive drilldowns, drill-across and drillable charts using Answers

TECHNICAL SKILLS:

Oracle Applications: Oracle E-Business Suite R12/11i (Order Management, Inventory, Purchase Order, General Ledger, Accounts Receivables, Accounts Payables, Bill of Material, Work in Process)

Application Tools: OBIEE 10.1.3.4.1 /11 g, Hyperion Essbase, Siebel Analytics 7.x, OBIA 7x /BI APPS 7.9.6/7.9.5, Toad, SQL Navigator 4.5, SQL*Plus, SQL*Loader, XML Publisher 5.6.3/5.6.2, BI Publisher 10.1.3.4.1 /11 g till 11.1.1.7.x and Oracle Developer Suite

ETL Tools: Informatica Power center 8.x/7.x/6.x, Datastage

Databases: Sybase, Oracle 8i /9i/10g, MS SQL Server 2000/2005/2008

Languages: SQL, PL/SQL, C, C++, Java, JDBC, JSP, XML

Web Technologies: HTML, JAVASCRIPT, ASP and PHP

Operating System: UNIX, Linux (Red hat enterprise) and WINDOWS 98/2000/NT/XP/VISTA

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

OBIEE / BI Apps Analyst

Responsibilities:

  • Extensive work on the relational and star schema data modeling.
  • Gather reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.
  • Create centralized Dimensional models for the developers of PPG to work easily on the target physical tables using CA ERWIN and SQL architect.
  • Expert on data analysis for all the upgrade projects of Enterprise source systems of PPG.
  • Expert on server’s maintenance and administrative tasks with security and management on OBIEE 11.1.1.7.0.
  • Successfully complete upgrading and configuring OBIEE 11.1.1.7.0 tools on the servers and clients without errors on BI publisher reports and OBIEE reports and dashboards.
  • Working on Informatica Designer Components - Source Analyzer, Transformations Developer, Mapplet and Mapping Designer with Source Oracle DB.
  • Implemented security based on LDAP Authentication.
  • Used OBIEE Web Catalog to set up groups, access privileges and query privileges.
  • Work on the complex star schema models in the industry with multiple facts under a logical fact with more than 40 million records each and had tuned to give the best performance on all most complex reports in the industry.
  • Define and create Initialization Blocks, Repository and Session Variables for generating filters and defining security.
  • Work with various different Hierarchies on different Levels, and implemented Business Logic by creating level based measures in OBIEE business model and mapping layer.
  • Work with Informatica Designer tool in developing mappings and mapplets to extract and loading the data from flat files and SAS cubes.
  • Extensively use Informatica for loading the historical data from various tables for different departments.
  • Work on complete SDLC from Extraction, Transformation and Loading (ETL) of data using Informatica.
  • Schedule and monitor all jobs through DAC and informatica and communicate with the other teams for the dependent jobs to avoid hassles.
  • Subject matter expertise with strong communication and skills who can work in a team or independently.

Environment: OBIA 7.9.6.3, Informatica 9.1, SQL Developer, SQL Server, MS Analysis Services cubes, Hyperion Essbase cubes TOAD, Sybase, Oracle 10g/11g, DAC, HP Quality Center, UNIX.

Confidential, Littleton, MA

OBIEE / BI Analyst

Responsibilities:

  • Worked on complete Software Development Life Cycle (SDLC), from gathering requirements to deployment.
  • Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
  • Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
  • Managed and customized the ETL Informatica/DAC loads, RPD and Web catalog metadata according to the reporting needs of the client.
  • Monitored incremental and full load of data through Data Warehouse Administration Console (DAC) and Informatica.
  • Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBots queries to obtain daily and weekly reports.
  • Created hierarchies, complex and foreign joins, initialization blocks for repository or session variables, presentation variables in answers calculations, aggregates, partitions, fragmentations and slowly changing dimensions.
  • Granting access to users and maintain security by using database authentication and authorization.
  • Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
  • Designing the collections for AR Transactions, Claims, Disputes, Cash On Account, Credit Memo, Receipts at Risk information using Oracle BI.
  • Designing the Month End Closing Mechanism for Accurate Finance Reporting of AR Credit using Oracle BI.
  • Monitored incremental and full load of data extraction through Data Warehouse Administration Console (DAC) and Informatica.
  • Involved in developing the Incremental ETL processes i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions/Tasks for data extraction from E-Business suite.
  • Used Heterogeneous sources in Informatica like flat files and Oracle apps tables.
  • Customized out of box Dashboard pages like Sourcing Trends, Total Spend Overview, Exceptions, Purchase Requisitions, Purchase Orders and Employee Expenses in Supply Chain Analytics and Procurement and Spend Analytics.
  • Customized Dashboard pages like Overview, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
  • Involved in complete Procure-to-pay (P2P) and Order-to-Cash (O2C) life cycle.
  • Customized Supplier Paid Invoice History Report, Supplier Audit Report, and Supplier Payment History Report in Account Payables (AP) using OBIEE.
  • Developed Replenishment Interface in Oracle Inventory (INV) based on data sent from warehouse in flat file. Used Loader program to load the data into the staging table, and then performed PL/SQL validations to load the data into the interface tables.
  • Developed balance sheet, profit and loss statement using BI Publisher.
  • Explain Plan for tuning of PL/SQL queries for better database performance.
  • Resolved open issues with production system
  • Gathered requirements from the client for GAP Analysis, translated them into technical design documents.

Environment: OBIEE 10.1.3.4.1 /11 g, Oracle EBS R12 (General Ledger GL, Account Payables AP, Account Receivables AR, Inventory INV, Purchasing PO, Order Management OM), Oracle 10g, TOAD, PL/SQL, Oracle BI APPS 7.9.6, DAC, Informatica 8.6.1, XML publisher 5.6.3, BI Publisher 10.1.3.x/11g SQL*Loader.

Confidential, Richmond, VA

OBIEE/BI developer

Responsibilities:

  • Used the OBIEE 11.1.1.x Administration tool to develop and enhance meta-data.
  • Installation and configuration of all components of OBIEE, including the physical, logical, BMM and presentation layers.
  • Involved in One on One meeting with SME to understand the business scenario and process flow.
  • Used Filters (Global) and provided customized prompts to avoid excessive data showing up in the reports.
  • Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
  • Involved in setting up methods of usage tracking using Direct Insertion and setting up Log File. Merged the Usage Tracking Repository with the main repository (. rpd) to have dashboard based usage tracking.
  • Worked extensively with Physical Layer, Business Layer and Presentation Layer.
  • Built Time-Series calculations using AGO and TODATE functions on BMM (Business mapping and modeling) layer of repository and TIMESTAMP Functions in the Answers.
  • Worked on data from different sources and data at different levels of granularity to build the required functionality.
  • Performed Data Validation including both unit and regression testing of data in the reports and dashboards including the functionality based on requirements.
  • Shared Knowledge in ETL processes using Informatica Power Center, PL/SQL for various transactions and loading data from various legacy data sources.
  • Worked with Other Teams of Reporting, Data warehouse Developers and DBA's along with the Business Analysts and BRM's for requirement Gatherings and Feasibilities, Standards and Troubleshooting with the Issues along with QA Teams.

,.

  • Implemented user security authentication using LDAP server directory
  • Involved in performance tuning for BI server and Oracle SQL queries.
  • Worked Extensively on Oracle Answers, Dashboards and Delivers to create reports.
  • Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
  • Performance Enhancement of the data ware house using indexing, partitions and running statistics.

Environment: OBIEE 11.1.1.X, Siebel Analytics 7.8, DAC 7.9.5, ORACLE 11g, SQL, TOAD, PL/SQL, DB2, BI Publisher, XML, Oracle Reports, UNIX.

Confidential

OBIEE Developer

Responsibilities:

  • Involved in gathering the requirement, completed the proof of concept in translating functional requirements into technical requirements, and developed the technical designs.
  • Conducted meetings and Design sessions with Business Analysts from OLTP and OLAP to customization of Oracle Business Analytics warehouse (OBAW)
  • Implemented dashboards to analyze head count, hires, promotions, transfers and other related HR business data
  • Experienced working with Oracle BI Server, Presentation Server, all three layers in the repository RPD - Physical, Business Model and Mapping and Presentation Layer and Oracle BI Administration
  • Customized the OOB RPD to meet the business requirements by enhancing custom hierarchies, columns, logical sources, etc.
  • Created Interactive Dashboards, Answers and Administering Oracle BI Apps Applications.
  • Analyzed, Designed developed and customized Reports and Dashboards in OBIEE
  • Interacted with the business team on a regular basis to prepare the test plans and wrote test scripts
  • Expertise in Data Modeling design, analyze and implement
  • Worked on security for users based on LDAP
  • Added column/data level security at the repository level and defined dimensional hierarchies and associated the proper level of granularity to the fact table
  • Developed custom logical columns and calculated measures using expression builder. Created presentation catalog with restricted access to various business users
  • Experience in providing Security privileges (Object level & Data level Security) for each Subject area and Dashboards according to user requirements
  • Involving in functional, system and user acceptance testing
  • Executed test cases and documented bugs found during the process of testing

Environment: Oracle Applications 11i/R12, OBIEE 10.1.3.4.1, OBIA 7.9.6.1, Informatica Power Center 8.6.1, Oracle 10g, DAC 10.1.3.4.1, Toad, Linux

Confidential

PL/SQL Developer

Responsibilities:

  • Involved in design, development and maintenance of the Application
  • Gathered business requirements and created design documents
  • Created and maintained a several Database objects including tables, Indexes, stored procedures. Created Views from extracting data from various tables for Report Generation
  • Involved in the upgrade of Developer 4.5 to Oracle 6 using interactive mode and batch mode
  • Modified PL/SQL code in the forms to adhere the syntax change
  • Developed forms screens to enter customer information
  • Created new stored procedures and modifying the existing ones
  • Worked on improving the Query performances
  • Prepared the different test scenarios and tested the SQL queries and stored procedures
  • Conducted the Weekly Status meetings to Review/generate reports on the development of the software.

We'd love your feedback!