We provide IT Staff Augmentation Services!

Sr. Obiee Consultant Resume

Lisle, IL

SUMMARY

  • Over Eight years of experience as an Oracle applications (E - Business Suite) consultant, technical developer with expertise in General Ledger, Account Payables, Accounts Receivables, Fixed Assets, Order Management, Inventory, Purchasing, Install Base, Service Contracts, System Administrator, and Cash Management.
  • Extensive experience in Oracle Financials R12/11i (11.5.10/11.5.9/11.5.8/11.5.4 ).
  • Strong experience in developing and customizing Reports and Forms using Oracle Reports 6i/4.5/2.5 Discoverer 10g/4i/3i and XML Publisher 5.6.3/5.6.2 , OBIEE.
  • Installed and Configured OBIEE, DAC and Informatica on Unix/Linux and Windows Environment.
  • Expertise in developing OBIEE/Siebel Analytics Repository.
  • OBIEE - Good experience in configuring DAC tasks and generating reports by using Answers and configuring and scheduling of iBots.
  • Informatica - Expertise in Developing Mappings, Maplets, Workflows and Sessions using Informatica Power center.
  • Good Experience in Performance Tuning of Informatica Mappings.
  • Ensuring OBIEE Team’s adherence to Quality Norms and Conditions of Service Level Agreement with Client
  • Extensive worked on Business Intelligence and Data warehousing with Kimball and Inman Methodology using OBIEE 10.1.3.x / Siebel Analytics 7.x and Informatica 8.x/7.x/6.x.
  • Implemented Analytics security at the data and object levels.
  • Utilized Siebel Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.
  • Good expertise in RICE (Reports, Interfaces, Conversions, Extensions) components.
  • Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs, and worked on Interface/Conversions like GL Interface, Custom Invoice Interface.
  • Strong Experience in Application Object Library.
  • Experience in System Testing of Oracle Service modules (Service Contracts, Service RequestSales Order, Install base).
  • Extensive Experience in Data Warehousing development using ETL tools such as Informatica Power Center / Power Mart 7.x/ 6.x
  • Detailed knowledge in Data warehouse Administration Console (DAC) and Informatica Servers.
  • Extensively worked on Oracle Discoverer (Desktop, Administrator, Plus, Viewer), which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL).
  • Designed Technical Documentation using AIM Methodologies (MD50, MD70, CV40 and CV70).
  • Extensively worked on Shell scripts and used Bugster to track reporting errors.
  • Expertise in creating, modifying, using and debugging Stored Procedures, Views, User Defined Functions using SQL Server/PL SQL.
  • Experience in supporting the production system and handling day-to-day issues.
  • Experienced in interacting with users, gathering requirements, and drawing up Business Case Scenarios to enable the testing of system setups.

TECHNICAL SKILLS

Oracle Applications: General Ledger, Accounts Receivables, Accounts Payables, Order Management, Inventory, Install Base, Fixed Assets, Cash ManagementPurchase Order, Advanced Pricing, Service Contracts, Purchasing, AOL, System Administrator.

Application Tools: Reports 6i/4i, Discoverer 10g/6i/4i, Forms 6i, Oracle 9iAS, XML Publisher 5.6.3/5.6.2 , Oracle Web Application Server 4.0.8, Oracle Enterprise Manager (2.1.0),OBIEE

Databases & Tools: Oracle 10g/9i/8i/7.x, TOAD, SQL Navigator, SQL*PLUS, SQL* Loader, SQL Server.

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: Informatica 6.x/7.x/8.x, SSIS, DTS

PROFESSIONAL EXPERIENCE

Sr. OBIEE Consultant

Confidential, Lisle, IL

Responsibilities:

  • Gather Information and Requirements for Financial Analytics (OBIA) and implemented.
  • OBIEE Report Development includes RPD development and Dashboards Design.
  • Worked on Oracle EBS systems.
  • Security management for users, groups and web-groups using the various authentication systems (Database table, Dashboard / Report-level security).
  • Developed many Dashboards / Reports for providing analytical information's using Oracle BI Answers and Dashboards. Created and used Oracle BI Delivers and IBots/Agents extensively.
  • Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
  • Creating and maintaining the RPD.
  • Deploying the RPD when new reports were created.
  • Creating reports in Answers/Analysis and creating and managing dashboards
  • Helping users to understand the reports, how to navigate the reports, and understand the report requirements.
  • Sending daily BI Publisher emails to managers of different regions.
  • Using OBIEE to pull data from Customized SQL Server Database.
  • Tuning performance by increasing the number of connections in the RPD due to many users accessing the reports.
  • Setting query limits for users so that they would not congest the system by accessing the reports at the same time causing performance issues.
  • Database performance tuning and created indexes and cost based optimization.
  • Data modeling after understanding the business requirement. Also, designed dimensional modeling for Data warehouse.

Environment: Oracle Applications R12, Accounts Receivable, Oracle 11g/10g/9i (9.2.0), OBIEE 10.1.3.4.1 / 11.1.1.6/ 11.1.1.7 , DAC 10.1.3.4.1 , XML/BI Publisher 5.6.3, SQL*PLUS, SQL*Loader, TOAD

Sr OBIEE Consultant

Confidential, Glendale CA

Responsibilities:

  • Implemented Financials, Supply Chain and Procurement & Spend Analytics.
  • Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
  • Involved in installation and configuration of OBIEE, Informatica and DAC.
  • Analyze, Design and Develop OBIEE Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
  • Responsible for configuring the Source and lookup files.
  • Custumizing the existing informatica repository and adding new mappings and workflows based on the requirements.
  • Created Dimension hierarchies to achieve the drill down functionality.
  • Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
  • Designed and Developed Custom Mappings, Workflows and Registered in DAC.
  • Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
  • 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.
  • Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
  • Implemented the single sign on (SSO).
  • 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.
  • Designed and Developed Sessions and Workflows.
  • Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.
  • Adding new Tables,Tasks and rebuilding the subject areas in DAC based on the changes done to the informatica repository.
  • Configuring the Anlaytics repository(RPD) and implementing the security to authenticate and authorize Oracle EBS users.
  • Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler & iBots.

Environment: Oracle Applications R12, General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management, Oracle Purchasing, Oracle 10g/9i (9.2.0), OBIEE 10.1.3.4.1 , Informatica 8.6.1, DAC 10.1.3.4.1 , XML/BI Publisher 5.6.3, Discoverer 10g, Repots10g, SQL*PLUS, SQL*Loader, TOAD, Unix

Sr OBIEE Consultant

Confidential, Milwaukee, WI

Responsibilities:

  • Was involved in the installing and configuring of Financial and Supply Chain Analytics Analytics.
  • 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.
  • 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.
  • Designed and Developed Custom Mappings in Informatica to bring the 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.
  • 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.
  • Used the Totals/Subtotals/group/sort features of XML/BI Publisher to make data intense operations happen at the template level.
  • 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.
  • 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.
  • Conducted training Sessions on Informatica power center and OBIEE.
  • Designed, implemented and tested security privileges on subject areas, dashboards and reports.

Environment: OBIEE 10.1.3.4.1 , Oracle Applications R12/11.5.10, General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management, Supply Chain(SCM), Service Contracts, Install Base, Oracle 10g/9i (9.2.0), Informatica 8.1.1, DAC 10.1.3.4.1 , XML/BI Publisher 5.6.3, Discoverer 10g, SQL*PLUS, SQL*Loader, TOAD, Unix

Sr OBIEE Consultant

Confidential, LA,CA

Responsibilities:

  • Implemented Invoice level security in OBIEE depending on the user level access by integrating with EBS. Developed many Reports / Dashboards with different Analytics Views (Drill-Down, Dynamic, Pivot Table, Chart, and Column Selector, with global and local Filters using Oracle BI Presentation Services).
  • Analyze,Design and Develop OBIEE/Siebel Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
  • Created Metadata repository - Physical layer, Business Model and Presentation Layer for contract activation report in Service Contracts
  • Configured iBots in order to deliver the reports based on Schedule and automated iBot queries to deliver at scheduled timings.
  • Responsible for the development of DAC tasks design and development which will call the Informatica workflows and updates the Image tables.
  • Used various Transformations like Lookup, Expression, Filter, Joiner and for better data scrubbing and to cleansing and consistent data.
  • Responsible for the development of DAC tasks design and development which will call the Informatica workflows and updates the Image tables.
  • Performing tuning in Informatica Source and Target and Mapping and Target and Session level and oracle query tuning.
  • Participated in Production Support and resolved problems that occurred during this phase.
  • Developed repository and created logical columns, Hierarchies, Economical Source and Aggregate navigation in the Business model according to the requirements.
  • Identified the granularity level of the data required to be available for analysis.
  • Created hierarchy based Sales Card Dashboards and marketing dashboards (Buying segments, Purchase analysis) for different Business units and end users
  • Developed Order and Invoice Revenue by Product dashboard in Procurement Analytics
  • Developed Order Revenue Growth Over Previous Year dashboard in Procurement Analytics
  • Developed Cumulative Order Revenue versus Last Quarter Dashboard in Procurement Analytics
  • Created VPD security for reports in OBIEE.
  • Developed many complex Initial/Incremental Informatica Objects (Workflows/Sessions, Mappings/mapplets with various transformations.
  • Designed and developed logical model in BMM in Repository.
  • Installed and Configured DAC.
  • Created custom reports in Payables in OBIEE according to user requirement
  • Modified the PO: Printed Purchase order report (printed) to meet the client’s requirement.
  • Customized Standard Sales Order Acknowledgement Report using XML/BI Publisher.
  • Customized existing Dunning report in Account Receivables using XML/BI Publisher.
  • Converted Supplier Payment History Report in Account Payables from Report 6i to XML/BI Publisher.
  • Developed OBIEE reports like Inventory details report, Price evaluation report and many other Inventory related reports.
  • Implemented Financial Analytics. Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).

Environment: Oracle Applications 11.5.10, General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management, Supply Chain(SCM), Service Contracts, Install Base, Oracle 9i (9.2.0),, Informatica, XML/BI Publisher 5.6.3, OBIEE, Discoverer 10g, SQL*PLUS, SQL*Loader, TOAD, Unix.

Sr OBIEE Consultant

Confidential, CT

Responsibilities:

  • Worked with business users to gather business requirements and provided reports in Financial, manufacturing and Supply Chain modules.
  • Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
  • 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.
  • Created AD hoc reports in Account Payables.
  • 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 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.
  • As part of the installation team installed OBIEE BI Apps.
  • Configured and validated OOTB Profitability and Payables Analytics.
  • 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, Accounts Payables, Account Receivables, Order Management, Supply Chain(SCM),Service Contracts, Install Base, BOM,WIP, Inventory, Oracle 9i, Discoverer 10g,OBIEE,Informatica, Windows 2000/NT, SQL*Plus, TOAD, Reports 6i, Kintana, UNIX

Oracle Apps Techno-Functional Consultant

Confidential

Responsibilities:

  • Design, Development, Implementation and Technical support of complex business custom extensions for Oracle Financial, Manufacturing modules. Designed and recommended solution for custom processes flow integrated with standard applications.
  • Provided customer support for Oracle standard and custom built Applications.
  • Imported Items from legacy system into Oracle Inventory using the Standard Item Interface Program.
  • Involved in Customization of Cancelled Orders Report, Orders Summary Report.
  • Involved in Open Sales Order conversion based on client specifications.
  • Used TCA API's for creating Parties, Party Accounts, Contacts, and Account Sites.
  • Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities.
  • Mapped the configurations to accommodate for the territorial hierarchy that were accommodated via chart drilldowns.
  • Migrated Business Areas/Item Classes/Hierarchies from one Instance to the other.
  • Involved in Unit Testing and Performance Testing for reports.
  • Involved in preparation of various documents like MD050, MD070 (functional & Technical Design) documents.
  • Performed unit, system, integration testing with reference to interfaces to non-oracle applications
  • Created and have setup Resources using public packages.
  • Responsible for techno design documentation of the reports.

Environment: Oracle Apps 11i, Siebel Analytics 7.8.4, General Ledger, Order Management, Informatica 7, Inventory, Accounts Receivables, System Administrator, Supply Chain(SCM), Oracle 8i, Reports 6i, Discoverer 4i, SQL, PL/SQL, SQL*Loader, Sun Solaris OS 2.8, Unix Shell scripting, PVCS

Oracle Developer

Confidential

Responsibilities:

  • Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
  • Created new database objects likeProcedures, Functions, Packages, Triggers, IndexesandViewsusingT-SQLinSQL Server 2000.
  • Validated change requests and made appropriate recommendations. Standardized the implementation of data.
  • Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
  • Modified database structures as directed by developers for test/develop environments and assist withcoding,designandperformance tuning.
  • Managed user access. Created and managed new security accounts.
  • Backupandrestoredatabases.
  • Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
  • Created theDTSPackagethroughETLProcess to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
  • Updated the statistics info for both the old and new servers.
  • Assisted with various ad hoc query requests.
  • Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2000, T-SQL, DTS Designer, MS-Office, Ms-Excel, VSS

Hire Now