SUMMARY:
Confidential has over 20 years of management consulting experience and has spent the last 15 years specializing in all phases of design, development, and implementation of Business Intelligence and Data Warehousing applications. He has conducted Business Intelligence. He has worked for clients within the consumer financials, products, healthcare, and services industries as well as the Confidential . His area of expertise includes Oracle Business Intelligence, Oracle Public Cloud, SAS, and SPSS. Confidential is highly recommended for his analytical skills and his attention to detail.
SKILLS SUMMARY:
Oracle Business Intelligence Entreprise Edition
12c, 11g, 10g
Aggregation
Performance Tuning
OBIA/Siebel Analytics
11.1.1.10.2 , 7.9.6.4, 7.9.6.3, 7.9.6.2, 7.5, 7.7, 7.8
Aggregation
Delivers
Disconnected Analytics
Performance Tuning
Oracle Data Integrator
11.1.1.9.0
Informatica
7.1.4
8.1.1
8.6.1
9.1.0
Reporting
SAS
SPSS
MS Excel
Non - Oracle Databases
SQL Server 2000
MS Access
MS Excel
Oracle Linux
Unix
Windows NT
Windows Server 2000, 2008, 2012
Windows XP, 7, 8, 10
PROFESSIONAL EXPERIENCE:
Confidential
Lead OBIEE/OBIA Architect
Responsibilities:
- Responsible for implementing OBIA 11.1.1.10.2 Financial Analytics (GL/AP/FA) in the Oracle Public Cloud (OPC) as a Platform as a Service (PaaS).
- Responsibilities included provisioning all cloud instances and lifting OBIEE artifacts to Oracle Analytics Cloud (OAC).
- Also responsible for transferring Informatica mappings to Oracle Data Integrator to preserve customizations from 7.9.6.4 OBIA.
- Provided RPD/Dashboard guidance to client developer during the engagement.
Confidential
Lead Business Intelligence/OBIA Architect
Responsibilities:
- Responsible for modifying Informatica mappings to ensure Service Level Agreements were met.
- Also responsible for upgrading single tier and multi - tier OBIEE environments to 11.1.1.9.0 from 11.1.1.6.11.
- For Pay CRM, lead architect using OBIA 11.1.1.10.2 and Oracle Data Integrator.
Confidential
Lead Business Intelligence Architect
Responsibilities:
- Responsible for all aspects concerned with the Enterprise Data Warehouse including using PSFT 9.1 and Taleo as sources.
- Responsible for all aspects of OBIEE, including DAC, Informatica, RPD, Reports/Dashboards, and Security.
Confidential
OBIEE Upgrade Architect
Responsibilities:
- Upgrade Architect upgrading all components of OBIEE 10g to OBIEE 11g including going from BI Apps version 7.9.4 to 7.9.6.4 pulling data from Siebel OLTP.
- Responsibilities included validating data stored in Siebel matched what was being extract into OBIEE.
- Interacted with the project team and project architects team to support the upgrade deliverables.
- Interacted with Quality Assurance team members to ensure requirements meet the needs to the business
Confidential
Lead Business Intelligence Architect
Responsibilities:
- Responsible for all analyzing all aspects concerned with the Enterprise Data Warehouse including using Siebel CRM as a source and various other custom sources for Pension Modernization.
- Responsible for providing recommendations on the data models and transformation procedures in Informatica to ensure data warehouse best practices were followed at all times.
- Also analyzed and recommended an upgrade from OBIEE 10g to 11g in both single node and multi-node environments.
- Interacted with project architects during the entire project duration
Confidential
Subject Matter Expert
Responsibilities:
- Assisted in overall architecture review in regards to items related to OBIEE health check.
- Was also responsible for providing best practices in regards to report creating, metadata design and datawarehouse design.
- Was also responsible for reviewing Informatica mappings prior to upgrade.
- Provided support during and upgrade from BI Applications version 7.9.4 to 7.9.6.1.
- Interacted with project team members to ensure the application meet the needs of the business
Confidential
Metedata Architect
Responsibilities:
- Responsible for all aspects of metadata configuration and customizations to OOTB AR star schema.
- Also assisted in knowledge transfer to production support team and provided guidance to other team members in other subject areas for customizing the metadata.
- Provided guidance with dashboard and report development to business users.
- Interacted with project team members to present report design to obtain feedback
- Responsible for reviewing and analyzing legacy reporting systems and offer suggestions for reporting and dashboards.
- The application was replacing several legacy spreadsheet reports and gave greater flexibility to users to data than previously experienced.
- Dashboards were created to allow users quick access to critical reporting areas within the organization.
