SUMMARY

• Over fifteen years of Accounting and Information Systems experience.
• Extensive use of Confidential Business Intelligence Enterprise Edition (OBIEE), Confidential Financial / Manufacturing Applications and development tools.

TECHNICAL SKILLS

• Confidential Intelligence: Confidential Business Intelligence Enterprise Edition (OAC, OAS, OACS, BICS, OBIEE 11g 12c, Business Intelligence Answers, Intelligence Administration Tool), OBIA 11g, OBIA 7.9.6.2, OBIA 7.9.6.3, Confidential Data Integrator 11g. Informatica PowerCenter Services, Confidential Data Warehouse Administration Console (DAC), BI Publisher, Smart View, Tableau 8
• Confidential Financials (r12 and 11i): General Ledger, Accounts Receivable, Accounts Payable
• Confidential Data Query Tools: Discoverer3.1, Application Desktop Publisher (ADI), Brio

PROFESSIONAL EXPERIENCE

Confidential

Senior BI Developer

Responsibilities:

• Gather Requirements related to migrating Hyperion Enterprise reports to OBIEE
• Document requirements based on meetings with client personnel
• Design data warehouse facts and dimensional tables used for reporting, Realtime tables vs Warehouse tables
• Update BI Analytics RPD based on requirements, create physical tables and data model, create logical fact and dimensional data model, and create presentations subject areas folders and columns
• Create reports, saved filers, dashboard filters, and prompts based on users requirements
• Resolve performance issues by implementing best practices solutions in the data warehouse and metadata, using SQL and PL/SQL
• Train super users and admin users to operate and maintain OBIEE environment
• Build prototype migration from OBIEE 12.2.1.4.0 to OAS 5.5.0 and BICS

Environment: Confidential Business Intelligence Enterprise Edition 12.2.1.4.0 (OBIEE), Confidential Analytics Server 5.5.0 (OAS), Confidential BICS ( Confidential Business Intelligence Cloud Services)

Confidential

Senior Solutions Consultant

Responsibilities:

• Manage onshore and offshore resource
• Gather Requirements
• Document requirements based on meetings with client personnel
• Design data warehouse, ETL, and metadata customizations to support business reporting needs
• Update BI Analytics RPD based on requirements
• Resolve performance issues by implementing best practices solutions in the data warehouse and metadata
• Train super users and admin users to operate and maintain OBIEE environment
• Provide users support, security configuration, and maintenance of OACS environuts

Environment: Confidential Business Intelligence Applications (OBIA), Confidential Analytics Cloud Services (OACS)

Confidential

Senior Solutions Consultant

Responsibilities:

• Configure BICS
• Review Discoverer reports to be replaced by BICS
• Implement RDC (Remote Data Connect)
• Install and configure BI Admin Tool with local RPD to work with BICS
• Create financial dashboards and reports used to support GL month end close process

Environment: Confidential BICS ( Confidential Business Intelligence Cloud Services)

Confidential

Responsibilities:

• Configure BICS
• Gather Requirements
• Document requirements based on meetings with client personnel
• Design warehouse tables
• Update BICS data modeler to support financial reporting
• Create financial dashboards and reports used to support GL month end close process
• Train super users and admin users to operate and maintain BICS environment

Environment: Confidential BICS ( Confidential Business Intelligence Cloud Services)

Confidential

Responsibilities:

• Install and configure OBIEE 12c (for Confidential Windows x86 - 64-bit)
• Gather Requirements
• Document requirements based on meetings with client personnel
• Design data warehouse, ETL, and metadata to support business reporting needs
• Update BI Analytics RPD based on requirements to build new sales reporting system
• Create sales tracking dashboards and reports
• Resolve performance issues by implementing best practices solutions in the data warehouse and metadata
• Train super users and admin users to operate and maintain OBIEE environment

Environment: OBIEE 12c (12.2.1.1.0 ) (Business Intelligence Answers and Intelligence Administration Tool)

Confidential, NC

Responsibilities:

• Convert legacy reporting systems to Confidential Business Intelligence Applications and Tableau 8
• Gather Requirements
• Document requirements based on meetings with client personnel
• Configure OBIA with ODI to import data from Confidential EBS applications
• Update BI Analytics RPD based on requirements to replace legacy reporting systems
• Modify create custom dashboards and analysis required to replace legacy reporting systems
• Configure Confidential Business Analytics Warehouse using the Business Intelligence Application Configuration Manager
• Build custom reports based on client requirements
• Modify out of the box dashboard menus based on client requirements
• Generate ODI Load Plans data from EBS OOTB tables
• Environment: OBIEE 11g (11.1.1.7.8 ) (Business Intelligence Answers and Intelligence Administration Tool), Confidential Business Intelligence Applications Fusion Edition (OBIA) Version 7.9.6.4, Tableau 8

Confidential, PA

Responsibilities:

• Support users of Confidential Business Intelligence Applications
• Gather Requirements related to the BI Financial Analytics and Projects Analytics
• Document requirements based on meetings with client personnel
• Update BI Analytics RPD based on client requirements
• Modify out of the box dashboard menus based on client requirements
• Modify Informatica/DAC load plans

Environment: Confidential Business Intelligence Applications Fusion Edition Version 7.9.6.4, OBIEE 11g (11.1.1.7.8 ) (Business Intelligence Answers and Intelligence Administration Tool), Financial Analytics. Projects Analytics, Informatica, DAC

Confidential, PA

Responsibilities:

• Implement Confidential Business Intelligence Applications
• Gather Requirements related to the BI Financial Analytics, Fixed Assets Analytics
• Document requirements based on meetings with client personnel
• Configure Confidential Business Analytics Warehouse using the Business Intelligence Application Configuration Manager
• Update BI Analytics RPD based on client requirements
• Modify out of the box dashboard menus based on client requirements
• Generate ODI Load Plans data from EBS OOTB tables

Environment: Confidential Business Intelligence Applications Fusion Edition Version 11g, OBIEE 11g (11.1.1.7.1 ) (Business Intelligence Answers and Intelligence Administration Tool), Financial Analytics. Fixed Asset Analytics Confidential Data Integrator 11g

Confidential, MN

Responsibilities:

• Implement Confidential Business Intelligence Applications
• Gather Requirements related to the BI Supply Chain Analytics
• Document requirements based on meetings with client personnel
• Configure Confidential Business Analytics Warehouse using the Business Intelligence Application Configuration Manager
• Update BI Analytics RPD based on client requirements
• Build custom reports based on client requirements
• Modify out of the box dashboard menus based on client requirements
• Generate ODI Load Plans data from EBS OOTB tables
• Build custom ODI Procedures to import data from custom EBS tables

Environment: Confidential Business Intelligence Applications Fusion Edition Version 11g, OBIEE 11g (11.1.1.7.1 ) (Business Intelligence Answers and Intelligence Administration Tool), Supply Chain Analytics. Confidential Data Integrator 11g

Confidential, Carnival, FL

Responsibilities:

• Implement Confidential Business Intelligence Applications
• Gather Requirements related to the BI Financial Analytics, Procurement and Spend Analytics
• Document requirements based on meetings with client personnel.
• Configure Confidential Business Analytics Warehouse using the DAC client
• Update BI Analytics RPD based on client requirements
• Build custom reports based on client requirements
• Modify out of the box dashboard menus based on client requirements

Environment: Confidential Business Intelligence Applications Fusion Edition Version 7.9.6.4, OBIEE 11g ( 11.1.1.7.0 ) (Business Intelligence Answers and Intelligence Administration Tool), Financials Intelligence, KPI Fixed Assets

Confidential,UGI, PA

Responsibilities:

• Gather Requirements related to building custom BI repository based on data the users plan to build reports.
• Design and Build data warehouse tables to support data rendered in dashboards and reports
• Build SQL data extract, transform, and load (ETL) process to extract data from OLTP system into the custom data warehouse
• Build custom BI Analytics RPD based on client requirements
• Build custom BI Dashboard and reports using Confidential Business Intelligence 11.1.1.7.0
• Conduct knowledge transfer sessions to train client support staff to maintain and extend BI Analytics RPD going forward

Confidential, PA

Responsibilities:

• Install OBIEE 11g (11.1.1.6.0 ) (Business Intelligence Answers and Intelligence Administration Tool)
• Gather Requirements related to building custom dashboards loosely based on current reports
• Build data warehouse to support data rendered in dashboards and reports
• Build data extract, transform, and load (ETL) process to extract data from OLTP system into the custom data warehouse
• Build custom BI Analytics RPD based on client requirements
• Create custom dashboards and reports based on client requirements

Environment: OBIEE 11g (11.1.1.6.0 ) (Business Intelligence Answers and Intelligence Administration Tool)

Confidential, Financial, PA

Responsibilities:

• Upgrade Confidential Business Intelligence Applications from 7.9.6.1 to 7.9.6.3
• Gather Requirements related to the BI Financial custom reports
• Document requirements based on meetings with client personnel.
• Customize Confidential Business Analytics Warehouse using the DAC client
• Customize out of the box Informatica mappings and workflows using Informatica clients
• Update BI Analytics RPD based on client requirements
• Create custom reports based on client requirements

Environment: Confidential Business Intelligence Applications Fusion Edition Version 7.9.6.3, OBIEE 11g (11.1.1.6.0 ) (Business Intelligence Answers and Intelligence Administration Tool), Financials Profitability Intelligence, Procurement and Spend Intelligence, and Supply Chain Intelligence

Confidential

Responsibilities:

• Implement Confidential Business Intelligence Applications
• Gather Requirements related to the BI Financial Analytics, Procurement and Spend Analytics, and Supply Chain Analytics
• Document requirements based on meetings with client personnel.
• Configure Confidential Business Analytics Warehouse using the DAC client
• Complete setup documents used to setup production
• Update BI Analytics RPD based on client requirements
• Create custom reports based on client requirements
• Customize Financial Analytics for complex GL reporting requirements and external Account Segment data integration

Environment: Confidential Business Intelligence Applications Fusion Edition Version 7.9.6.3, OBIEE 11g (11.1.1.3.0 ) (Business Intelligence Answers and Intelligence Administration Tool), Financials Profitability Intelligence, Procurement and Spend Intelligence, and Supply Chain Intelligence

Confidential

Responsibilities:

• Implement Confidential Business Intelligence Applications
• Gather Requirements related to the BI Financial Analytics, Procurement and Spend Analytics
• Document requirements based on meetings with client personnel.
• Configure Confidential Business Analytics Warehouse using the DAC client
• Update BI Analytics RPD based on client requirements

Environment: Confidential Business Intelligence Applications Fusion Edition Version 7.9.6.3, OBIEE 11g (11.1.1.3.0 ) (Business Intelligence Answers and Intelligence Administration Tool), Financials Profitability Intelligence, Procurement and Spend Intelligence

Confidential

Responsibilities:

• Implement Confidential Business Intelligence Applications
• Gather Requirements related to the BI Financial Analytics, and BI Projects Analytics,
• Customize Financial Analytics for complex GL reporting requirements and external Account Segment data integration
• Enhance performance for Financial Analytics due to large source data set and complex reporting requirements
• Configure Confidential Business Analytics Warehouse using the DAC client
• Update BI Analytics RPD based on client requirements
• Complete setup documents used to setup production
• Conduct for end users related to UAT

Environment: Confidential Business Intelligence Applications Fusion Edition Version 7.9.6.3, OBIEE 11g (11.1.1.3.0 ) (Business Intelligence Answers and Intelligence Administration Tool), Financials Profitability Intelligence, Projects Intelligence

Environment: OBIEE (Business Intelligence Answers and Intelligence Administration Tool) 10.1.3.3.2, Toad for Confidential

Confidential, OH

Responsibilities:

• Implement Confidential Business Intelligence Applications
• Gather Requirements related to the BI Financial Analytics, BI Sales CRM Analytics, BI Procurement Analytics, and .BI Supply Chain Analytics
• Configure Confidential Business Analytics Warehouse using the DAC client
• Update BI Analytics RPD based on client requirements
• Create and/or modify Dashboards and Reports based on client requirements
• Complete setup documents used to setup production
• Conduct for end users related to UAT

Environment: Confidential Business Intelligence Applications Fusion Edition Version 7.9.6, OBIEE (Business Intelligence Answers and Intelligence Administration Tool), Financials Profitability Intelligence, Sales CRM Intelligence, Procurement Intelligence, Supply Chain Intelligence

Confidential, PA

Responsibilities:

• Implement Confidential Business Intelligence Applications
• Gather Requirements related to the BI Financial Analytics.
• Configure Confidential Business Analytics Warehouse using the DAC client
• Complete setup of development instance
• Update BI Analytics RPD based on client requirements
• Create and/or modify Dashboards and Reports based on client requirements
• Complete setup documents used to setup production
• Conduct for end users related to UAT.

Environment: Confidential Business Intelligence Applications Fusion Edition Version 7.9.6, OBIEE (Business Intelligence Answers and Intelligence Administration Tool), Financials Profitability Intelligence, Financials Payables Intelligence, Procurement and Spend Intelligence

Confidential, PA

Responsibilities:

• Implement Confidential Business Intelligence Enterprise Edition
• Design Dashboards and Requests using Confidential BI Answers.
• Create and maintain repository using the Confidential BI Administration Tool.
• Develop Star schemas used to support data needed for sales scorecard dashboards
• Document Entity Relationship Diagram (ERD) to support the reporting process.

Environment: OBIEE (Business Intelligence Answers and Intelligence Administration Tool) 10.1.3.3.2, Toad for Confidential

Confidential, PA

Some of the activities / responsibilities include:

• Creating Interactive Dashboards and Using Confidential Business Intelligence Answers
• Update Repository Using the Confidential Business Intelligence Administration Tool
• Conduct analysis of DBI requirements
• Complete setup of development instance
• Conduct DBI CRP
• Complete setup documents used to setup production
• Train supper users

Environment: Implemented OBIEE (Business Intelligence Answers and Intelligence Administration Tool), Implemented Payables Intelligence for DBI 7.2, Implemented Purchasing Intelligence for DBI 7.2, Implemented Financial Intelligence 7.2, Extend Daily Business Intelligence

Confidential

Some of the activities / responsibilities include:

• Production Support Analysis
• Conducted analysis and configuration for Accounts Payable and General Ledger
• Created custom reports using Developer 6i.
• Conducted analysis and configuration for Order Management
• Conduct end user
• Support end users after go live

Environment: BI Publisher 7.6.3, Implemented Daily Business Intelligence 7.3, Confidential Accounts Payable 11.5.10, Confidential General Ledger 11.5.10, Confidential Accounts Receivable 11.5.10, Confidential Order Management 11.5.10, Confidential Purchasing 11.5.10, Confidential Reports 6i, Discoverer 4.0, TOAD 7.6, Confidential Projects, Visio

Confidential

Contractor Instructor

Responsibilities:

• Conduct classes for Confidential students at Confidential facilities
• Conduct classes private classes for Confidential clients

Environment: OBIEE 10.1.3.2, BI Publisher 5.6.3, Daily Business Intelligence 7.3, Order to Cash Business Flow 11i, Procure to Pay Business Flow 11i, Confidential Accounts Receivable 11.5.10, Confidential Order Management 11.5.10

Advance Pricing 11.5.10, Customer Data Management 11.5.10, Confidential Inventory 11.5.10, Confidential Configurator 11.5.10, Confidential Advance Pricing 11.5.10, System Administration Fundamentals 11i

Confidential

Responsibilities:

• Conduct analysis of DBI requirements
• Complete setup of customized DBI KPI’s Dashboards, and reports development instance using DBI Designer
• Configure standard dashboards using DBI Administration
• Conduct knowledge transfer sessions on DBI technical and functional setups and configuration.
• Configure custom views for DBI reports and DBI dimensions
• Create custom DBI reports and KPIs
• Create custom DBI dashboards
• Create custom DBI Responsibilities and Menus

Environment: Extend Daily Business Intelligence 7.3

Confidential

Responsibilities:

• Conduct analysis of requirements for DBI Payables, Purchasing, and Financial Intelligence
• Complete setup of development instance
• Conduct DBI CRP
• Complete setup documents used to setup production
• Train supper users
• Configure custom views for fact tables and dimensions
• Create custom dimensions
• Create custom reports and KPIs
• Create custom dashboards.

Environment: Implemented Payables Intelligence for DBI 7.2, Implemented Purchasing Intelligence for DBI 7.2, Implemented Financial Intelligence 7.2, Extend Daily Business Intelligence 7.2