We provide IT Staff Augmentation Services!

Obiee Admin/developer/architect Resume Profile

Farmingdale, NY

Professional Profile

Confidential has over 10 years of experience working with many large firms such as Navistar, Telephonics, Jones Lang LaSalle and Adiva. Mrs Hostetler has very strong Functional/Accounting/Business experience combined with hands on cutting edge Technology experience. Strengths include I.T. Oracle OBIEE, OBIA, EBS R12 BI Publisher Development, General Accounting, General Ledger, A/R, A/P, Financial Reporting preparation, Financial Analysis, outstanding communication skills, and team player. Mrs Hostetler has worked comfortable in an array of roles from IT Developer to Functional SME.

Summary of Skills

OBIEE 11G, Oracle 11g, ERP Implementation, ERP Installation, DAC/Informatica, PL/SQL, EBS R12, BI Apps/OBIA, BI Publisher, Weblogic, XML, Team Lead, Management, Technical and Functional SME

Summary of Experience

  • Hands on OBIEE Dashboard design and creation
  • Techno/Functional EBS R12 Developer Analysis GL, AP, AR
  • Sr. OBIEE Architect Developer
  • Hands on OBIEE Administrator
  • OBIEE/OBIA 7.9.6.4 Implementer in EBS R12 Environment
  • BI Publisher Developer in EBS R12 Environment
  • Financial Reporting
  • Has performed Technical and Functional Consultant
  • Provide training in a group and one on one settings
  • OBIEE Dashboard design and creation
  • Installation of EBS R12
  • Essbase Jr. Administration/Migration/OBIEE Data Sourcing

Professional Experience

Confidential

OBIEE Admin/Developer/Architect

  • Personally, Created OBIA/BI APPS Dashboards, answers reports, ETL, and DW.
  • Personally, Performance Tuning of Web Logic services according to Oracle best practices
  • Managed servers and OBIEE services.
  • Performed multiple OBIEE migrations.
  • Applied patches to Web Logic.
  • Produced multiple SQL statements, views, reports, MD050s and MD070s for the GL General Ledger , AR Accounts Receivable , AP Accounts Payable .
  • Utilized TCA and the XLA architecture in SQL to drill from sub Ledger to GL.
  • Installed OBIEE 11G. Administered OBIEE. Create OBIEE groups and security.
  • Installed and Administered Weblogic.
  • Architected EBS R12 Solution, Real time EBS R12 reporting database, RAC, Load Balanced servers etc.
  • Create custom PL/SQL packages and procedures.
  • Personally, utilized BI Publisher to create custom reports.
  • Architect and Developer that personally completed multiple OBIEE reports and multiple dashboards in an EBS R12 environment.
  • Installed and configured, BI APPS 7.9.6.4
  • Implemented Financial Analytics, Procurement and Spend Analytics, Human Resources Analytics, Product Lifecycle Analytics, Supply Chain and Order Management Analytics and Projects Analytics.

Data Warehouse ETL Architect/OBIEE Developer/Analyst

Confidential

  • Architect and Hands on Developer that completed 3 full life cycle OBIEE projects.
  • Gathered, analyzed and documented requirements architected the Physical and Logical Star Schemas and developed the Dashboards and reports.
  • Personally, Installed and configured OBIEE.
  • Utilized Catalog Manager, OBIEE Administration, and BI Answers tools.
  • Completed Projects for SG A analytics, Enterprise Wide Financial Consolidation, Employee Resource Analytics.
  • Created IT Executive Level Dashboard.
  • Additional projects completed, analyst and OBIEE developer on Corp wide finance consolidation Data Warehouse, including Trial GL Balance, Journals, AP, AR SG A etc. The solution sourced 19 different systems Oracle 11i, PeopleSoft, EPM, Baan/LN, SAP, JBA, MRAS, HFM, NDW, SAP, on multiple platforms, Oracle, Teradata, SQL Server, DB2, Essbase/Hyperion OLAP etc...
  • Migration of Catalogs Webcats and RPD. Identified and designed Facts, Dimensions, Levels / Hierarchies both Ragged and Skipping.
  • Tuned OBIEE via model alteration, backend design and SQL.
  • Architected PeopleSoft to Teradata ETL and star schemas.
  • Implemented multiple hybrid OLAP to Star to OLTP systems.
  • Wrote multiple BI publisher reports from a variety of source systems. the GL General Ledger , AR Accounts Receivable , AP Accounts Payable , INV Inventory , WIP Work In Process .

OBIEE Analyst Developer

Confidential

  • Architect and Developer that personally completed multiple OBIEE reports and multiple dashboards in an EBS R12 environment.
  • Reporting Lead responsible for delivering custom reports.
  • Produced multiple SQL statements, views, reports, MD050s and MD075s for the , GL General Ledger , AR Accounts Receivable , AP Accounts Payable . SLA architecture in. Installed OBIEE 11G. Create/Implement OBIEE roles and groups for security.
  • Installed and Administered OBIEE 11G and Weblogic.
  • Architected EBS R12 Solution to include, Real time EBS R12 reporting database. Installed and configured, BI APPS 7.9.6.4
  • Implemented, configured, executed, customized, Informatica ETL, OBIEE and DAC. Created OBIA Dashboards, ETL, and DWH.
  • Created the Enterprise Reporting Strategy and Enterprise Architecture.
  • Implemented OBIA / BI APPS 7.9.6.4 Financial Analytics, Procurement and Spend Analytics, Human Resources Analytics, Product Lifecycle Analytics, Supply Chain and Order Management Analytics and Projects Analytics.
  • Executed ETL via ODI 11.1.1.7
  • Experience in Design, Development of various BI Publisher component including Data Template, RTF Template, Interactive BI Publisher Template for BI Publisher 11g

Confidential

Senior Accountant

  • Prepare monthly journal entries reconciling accounts
  • Review and approve all A/P and A/R
  • Prepare timely and accurate monthly financial statements for portfolio, by deadlines established within Client Accounting Services and external Client.
  • Submit financial statements and work papers in reviewable form including documentation and within the proper time frame for review.
  • Document the resolution of all issues identified in the Manager's review of financial statements. Responsible for cash management of assigned portfolio.
  • Insure that all bank statements are reconciled on a timely basis and follow-up on all outstanding checks and reconciling items monthly.
  • Assist property management in the budget process and review the budget from an accounting perspective.
  • Work with the property manager team to process escalation billings.
  • Handle difficult client situations and ensure that all special needs are being met.
  • Assume responsibility for the coordination and organization of year-end audit work, and prepare supporting schedules.
  • Maintain a working knowledge of assigned property budgets and assigned property operations

Hire Now