Oracle Technical Support

Summary Overview

* ***** ** ******** ********** working with delivering Business Intelligence solutions by gathering requirements, analyzing, testing, deploying Business Intelligence (BI) applications using OBIEE Analytics and OBIEE Apps and supporting Oracle EBS.

Extensive experience in OBIEE 11x/10x and Oracle BI applications which includes managing repository and Presentation services (Answers, Dashboards & Delivers), OBI iBots/agents (BI Scheduler), BI publisher, BI (RPD and Web-catalog) administration.

Strong understanding of Data Warehouse concepts ETL, OLAP, Star Schema, Data Modeling using Normalization, Business Process Analysis, Physical & Logical Data Modeling, Aggregate persistence wizard.

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 up-time and performance, and creating users and providing permissions to users per their role.

Expertise in developing OBIEE 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.

Experience in developing various dynamic and interactive complex reports/dashboards with intuitive drill-downs, drill-across and drill able charts using Answers

Extensive Knowledge on Oracle Delivers and Implemented schedule based iBots/agents to deliver reports.

Worked Extensively on OBIEE Administration Tool, Answers, Interactive Dashboards and BI Publisher.

Strong Knowledge in Oracle SQL queries Performance tuning using Explain plan.

Great Communication, Co-ordination and team skills. Well organized with excellent leadership skills and commitment to deliver on schedule.

Supporting the client on day-to-day operations and troubleshooting any issues that arise.

Performing daily, weekly and monthly checklists and correcting and discrepancies in the reports, ODI processes, and for monthly revenue closures.

Supporting the client on any none OBIEE systems such as EBS and POS.

Assisting/training team members and clients with creating reports and answer any questions they may have regarding OBIEE.

Certifications

Oracle Business Intelligence (OBI) Foundation Suite 11g Essentials

Technical Skills:

Oracle EBS: R12/11i, OBIEE 10x/11X, Win XP/2003/2008 Win 7, Windows NT/98 & UNIX (Linux), SQL, PL/SQL, Core JAVA, XML, TOAD, ODI, SQL Developer, Oracle Reports Builder, BI Publisher, Oracle Order Management, Oracle Inventory, Accounts Receivable,

Professional Experience

Client: January 2013 – December 2016

Metra

Project

Oracle OBIEE/Applications R12 Support/POS

Employer

AST Corporation

Domain

Public Sector (Financials)

Environment

Oracle SQL 10g, PL/SQL, BI Publisher, Putty, Oracle Forms Builder, Oracle Reports Builder, OBIEE, Oracle Applications Release 12

Modules

Oracle Payables, Receivables, Order Management, Cash Management, Point of Sale, Inventory

Role

Staffing Consultant

Project Description: The project handled the Oracle Applications OBIEE 11, R12 (12.1.3), Point of Sale and maintenance of Oracle AP, AR, OM, CM, BOM, POS, and Inventory modules. The project encompassed the modification of the inbound and outbound interfaces and developing new reports and modifying existing reports to meet the business requirements.

Responsibilities

Manage support on Oracle services for Metra.

Diagnosed and troubleshoot issues with OBIEE/Oracle Business Intelligence Enterprise Edition, ODI, Oracle E-Business Suite, ORPOS 13.4.8.

Upgrading OBIEE 10x to 11x

Created complex SQL statement to populate data from EBS 11i into OBIEE 10g.

Creating new users and providing the appropriate security settings through weblogic.

Query the tables in the data warehouse to ensure the tables are populated with the proper data.

Correcting any issues that arise in OBIEE.

Creating and modifying OBIEE reports/analysis, Dashboards.

Scheduling OBIEE agents for automated reports to be emailed to the users.

Allocations of sales in OBIEE based on a Excel provided by the client.

Research on any discrepancies on OBIEE reports.

Monitoring ODI Processes.

Troubleshooting and correcting failed ODI processes.

Opening SR for any Oracle issues.

Rescheduling or rerunning ODI processes for OBIEE

Daily, Weekly and monthly checklists.

Clearing cache in the repository as part of the weekly checklist.

Closing the revenue period for OBIEE.

Modify and design reports for Oracle E-Business Suite r12.

Provided level 1 & level 2 technical support to all Metra's Revenue Accounting systems (front & back end) hardware and software [Remotely and onsite]

Use Oracle E-Business Suite R12 previously 11i consisting of the following modules: Oracle Order Management, Oracle Inventory, Accounts Receivables, Purchasing, General Ledger, Cash Management.

Monitoring system performance using Oracle Enterprise Manager.

Maintain daily concurrent processes that control daily operations among the revenue accounting systems as well as solve issues or problems that may arise during month end close of accounting periods.

Document all functions and support procedures.

Education

ITT Technical Institute Oak Brook, IL

Bachelor of Science, Information System Security

ITT Technical Institute, Orland Park, IL

Associate of Applied Science, Computer Network Systems

Contact this candidate