We provide IT Staff Augmentation Services!

Oac Administrator Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • Oracle OBIEE 12c BICs/Dbaas/Oracle(OAC/BICC) Cloud Services setup/configuration/administration/ 10G/11G, Peoplesoft Financials and HCM 9.x Source ODI Data Integration, Oracle Cloud Financial/HCM implementations report development, BI Publisher, OTBI, SmartView, OBIEE/OBIA Analytics Packages includeFinancials,EAM, Project,Human Resource, Procure and Spend, Sales and Supply Chain Analytics, OBIEE Administration, ODI, Informatica ETL/ELT
  • Technical Business Intelligence, Database and Data Warehouse skills summary
  • Oracle R11/R12, OBIEE 10.1.x/11g/12c BICS Cloud,OBIA 7.9.x, BI Publisher/Smartview,Peoplesoft, SAP, EBS R11, R12, JDE Embedded BI Publisher, RTE templates, JDE Template object, Report definition objects
  • Experience with OBIA 12c BICS, Oracle Cloud Financial/HCM implementations report development, BI Publisher, OTBI, SmartView OBIEE10g - 11g, OBIA Financial Analytics, Procurement and Spend Analytics, Sales, Supply Chain and Order Management Analytics, Human Resources Analytics, Project Analytics.
  • OBIEE 12c BICS, 11g - 8 BI Instances/12 Node Horizontal and Vertical Cluster/500 US based users, 2.5 Terabytes Data Warehouse. Data Source includes Siebel Real-time, Seibel Analytics, Essbase.
  • Over 7 years OBIEE 10G/11G Administration and operational support. Configuration of Cache, Logs, Presentation, Java, Schedular, Job Manager, BI Administrator tool configuration.

TECHNICAL SKILLS:

  • Design and Develop Business Intelligence and Data Warehouse Reporting Systems utilizing OBIEE,OBIA, Tableau, BI Publisher, Answers, Informatica, Siebel, RPD, SQL Server 2000/2005/2008 and Oracle 11i supporting 400 branch offices throughout the United States.
  • Database, Data Mart and OLAP applications. Database Software tools include OBIEE, Oracle 9i/10/11i, SQL Server SSRS, SSAS, SSIS, Informatica, Hyperion Essbase, Crystal Reports/Seagate Info, Cognos 8
  • Web n-tier, 3-tier Application Development, SDLC Application and .NET, Visual Studio, C/C++, Apache/Linux/Red Hat Linux, Java and Cold Fusion

PROFESSIONAL EXPERIENCE:

Confidential

OAC Administrator

Responsibilities:

  • BICS/Dbaas/Oracle(Autonomous OAC/RDC) Setup Users, OCI Object Storage/DB Cloud Service/OBIA Financials Implementation, OBIEE custom rpd, dashboard and report development, ODI Data Integration Custom design and development. ODI 11/12g migration to OAC, Topology, Operator, Design, OBIA knowledge modules, Peoplesoft HCM and Financials source data, Financials, Supply Chain, Procure to Pay, Project and Human Resource Analytical Packages. Functional configuration toolset, ODI custom design of Interfaces, Packages, Procedures Load Plans and Source, Staging and Target Object design and definition.

Business Intelligence BI Consultant

Confidential

Responsibilities:

  • BICS/Dbaas/Oracle(OAC/BICC\RDC) Oracle DB 12.1.0.2, Red Hat Linux 6.9, WLS 12.2.1, OBIEE 11.1.1.9, ODI 11.1.1.9, OBIA 11.1.10.2 Oracle Golden Gate 12.2.0.2. Oracle Cloud Financial/HCM implementation report development, BI Publisher, OTBI, SmartView Financials, Procure and Spend, Install and Configuration duties.
  • Webcat RPD and Golden Gate SDS and ODI SDE/SIL/PLP design and development, functional and technical guidance and design role.
  • Support final UAT and QA issues with end users. Interface with Key Business and Technical team members in defining End User Business Requirements.
  • Define OBIEE/Exadata Architecture and provide technology alternatives to Client IT Infrastructure team members.

Confidential

Senior BI Consultant

Responsibilities:

  • Oracle OBIEE 12c BICS/Dbaas/Oracle(OAC/BICC) OBIA 11g/12c BICS Financials, Procure and Spend, Project Analytics functional and technical guidance and design role.
  • Interface with Key Business and Technical team members in defining End User Business Requirements.
  • Define OBIEE/Exadata Architecture and provide technology alternatives to DOT/ Confidential IT Infrastructure team members.
  • ODI 11/12g, Topology, Operator, Design, OBIA knowledge modules, Functional configuration toolset, ODI custom design of Interfaces, Packages, Procedures Load Plans and Source, Staging and Target Object design and definition.

Confidential, Chicago, IL

Peoplesoft/OBIA Financials, Power BI, Human Resource, Procure and Spend and Sales implementation and Support

Responsibilities:

  • Oracle OBIEE 12c BICS/BICC/Dbaas/Oracle Analytics Cloud Services setup/configuration/administration.
  • Oracle Cloud Financial/HCM implementation report development, BI Publisher, OTBI, SmartView. OBIEE, OBIA and ODI 11g ETL design and development. OBIEE RPD design and development. OBIEE Administration duties. ODI Designer, Operator, Topology Physical, Logical soure/target definition.
  • Power BI setup, configuration and design/development of dual clusters WFE authentication and Back End cluster.
  • Azure Traffic Manager, Azure Content Delivery Network (CDN).
  • Peoplesoft integration and Design and Configuration of OBIA FinancialsJDEdward integration functional configuration of A/P, A/R, GL, Fixed Assets Custom Pre-Allocation Expense, Tax, JV Liability, Trade Payables, Transaction Monitor reporting. RPD, Web Catalogue(Dashboard and Reporting and ODI ETL Load Plan, Configuration Object design and development

Confidential, Bloomfield, CT

OBIA Consultant

Responsibilities:

  • Design and Configuration of Peoplesoft/OBIA Financials A/P, A/R, GL, Fixed Assets Custom Pre-Allocation Expense, Tax, JV Liability, Trade Payables, Transaction Monitor reporting. RPD, Web Catalogue(Dashboard and Reporting and ODI ETL Load Plan, Configuration Object design and development
  • Implementation utilizing OBIEE 11g, ODI integration with Operating Expense activities within Confidential Expense System (CES) and Oracle R12 suite:
  • ODI and Reconciliation Interface activities - both inbound and outbound data
  • Transactional processing (FAH), Payroll Conversion, Allocation processes (HPCM/Hyperion), Reporting and Analysis capabilities (OBIEE)

Confidential, Valdosta, GA

Peoplesoft/ODI, Senior Business Intelligence Consultant

Responsibilities:

  • Peoplesoft integration with OBIEE 11g/OBIA Financials platform. Oracle RDBMS, OBIEE 11g, OBIA Financials, RPD, Catalog, Physical, BMM and Presentation Layer design and enhancementHCM implementation report development, BI Publisher, OTBI, SmartView. Informatica/DAC ETL
  • Install/setup/Configuration/Gap Analysis/Extension of ETL and OBIA software
  • Migrate and design Budget and Actual Report migration from legacy

Confidential

Consultant, Senior Business Intelligence Architect

Responsibilities:

  • OBIEE 11.1.1.5/1117 - 8 BI Instances/12 Node Horizontal and Vertical Cluster/500 US based users, 2.5 Terabytes Data Warehouse. Data Source includes Siebel Real-time, Seibel Analytics, Essbase. Over 7 years OBIEE 10G/11G Administration and operational support. Configuration of Cache, Logs, Presentation, Java, Schedular, Job Manager, BI Administrator tool configuration. Catalog Manager toolset.
  • OBIA Financials, Procure and Spend, Sales Analytics, configuration and implementation utilizing Informatica/DAC data integration/data lineage configuration and customization of Mapplets, Mappings, Workflows, DAC Subject Areas, Execution Plans including Universal and ERP out-of-box adapters objects.
  • BI Administrator - RPD design and development including Physical, Business and Presentation layer. User/Application Role LDAP configuration. Hierarchy BMM implementation. Presentation layer Subject Area design/configuration.
  • BI Publisher/Smartview/Answers Report and Dashboard design and implementation.
  • OBIEE data source access and integration with Siebel, Hyperion BI Suite, Essbase/HFM Projects.
  • Hyperion BI Suite version 7/9/11 - Workspace, Hyperion Planning, Planning Modules, Essbase and EAS, Financial Reporting, Web Analysis, SmartView, Oracle Data Integrator, Strategic Finance, Financial Data Quality Management, Data Relationship Management

Confidential

Senior BI Consultant

Responsibilities:

  • OBIA - EBS R11/R12 configuration and implementation utilizing Informatica/DAC data integration/data lineage configuration and customization of Mapplets, Mappings, Workflows, DAC Subject Areas, Execution Plans including Universal and ERP out-of-box adapters objects.
  • BI Administrator - RPD design and development including Physical, Business and Presentation layer. User/Application Role LDAP configuration. Hierarchy BMM implementation. Presentation layer Subject Area design/configuration.
  • BI Publisher/Smartview/Answers Report and Dashboard design and implementation.
  • OBIEE data source access and integration with Hyperion BI Suite, Essbase/HFM Projects.
  • Hyperion BI Suite version 7/9/11 - Workspace, Hyperion Planning, Planning Modules, Essbase and EAS, Financial Reporting, Web Analysis, SmartView, Oracle Data Integrator, Strategic Finance, Financial Data Quality Management, Data Relationship Management
  • Client Architecture and Configuration review of OBIEE 11g/10g product implementation and configuration (100 Nodes/Instance, Horizontal

Confidential, Ellisville, MS

Data Warehouse Architect

Responsibilities:

  • OBIEE 11g/10g product implementation and configuration
  • BI Administrator - RPD design and development including Physical, Business and Presentation layer.
  • User/Application Role LDAP configuration. Hierarchy BMM implementation.
  • Presentation layer Subject Area design/configuration.
  • BI Publisher/Smartview/Answers Report and Dashboard design and implementation.

Confidential

Business Intelligence Architect

Responsibilities:

  • OBIEE 11g/10g product implementation and configuration
  • BI Administrator - RPD design and development including Physical, Business and Presentation layer. User/Application Role LDAP configuration. Hierarchy BMM implementation. Presentation layer Subject Area design/configuration.
  • BI Publisher/Smartview/Answers Report and Dashboard design and implementation.
  • OBIA configuration and implementation utilizing Informatica/DAC data integration/data lineage configuration and customization of Mapplets, Mappings, Workflows, DAC Subject Areas, Execution Plans including Universal and ERP out-of-box adapters objects.
  • OBIA Financials,, Procure and Spend, Projects, Human Resource, Supply Chain and Order Management Configuration and setup for Common Areas and Dimensions (Initial Extract Date, Global Currencies, Exchange Rate Type, Fiscal Calendars). Deploy Stored Procedures, DAC Parameters, Domain Values and CSV Worksheet Files, Configure AP Invoice Types, Configure Employee Expense, Config Transaction Types for Financial Analytics.
  • AP / AR Snapshot aging, Currency table configuration (What if Analysis), Group Account vs. Explicit Account configuration for P&L, Enabling DRM hierarchies in Oracle BI,, Maintenance of Security model (Data level), Time Series discussion. Year to Go and Full Year view (Projection)
  • OBIEE data access of Hyperion BI Product Suite 7/9/11 OLAP/Essbase data source implementation
  • Hyperion BI Suite version 7/9/11 - Workspace, Hyperion Planning, Planning Modules, Essbase and EAS, Financial Reporting, Web Analysis, SmartView, Oracle Data Integrator, Strategic Finance, Financial Data Quality Management, Data Relationship Management

Confidential

Consultant - Solutions Architect

Responsibilities:

  • Track Vendor, Equipment and Payroll (Contract and Fulltime staff) expenditures versus SAP Budget data. Prior to building ETL and data interfaces to Maximo Equipments purchase data, SAP Financials and Payroll database systems there was only manual capital tracking with published reports and spreadsheets.
  • Estimated $400 Million in savings due to proactive and threshold monitoring of Financial KPI’s and Expense trends within 150 capital project throughout refinery..
  • Monitor refinery pump interface data for flow and pressure trends. Downloaded hourly flow data of all Chemical/Oil through Confidential Pipeline and equipment operations.
  • Estimated $250 Million in savings as a result of prevention of Refinery Shutdown process.

Confidential, Danville, CA

Database Architect Director

Responsibilities:

  • ETL Informatica Design/Development/Support, SQL Server 2005/2008 SSRS, SSAS, SSIS - Create, Monitor and Performance Tuning of Nightly, Weekly and Monthly ETL Data Warehouse Loads/Data Feeds. Monthly/Quarterly/Annual Financial Reporting, ER/Win Data Modeling design and implementation.
  • Hyperion BI Suite version 7/9/11 - Workspace, Hyperion Planning, Planning Modules, Essbase and EAS, Financial Reporting, Web Analysis, SmartView, Oracle Data Integrator, Strategic Finance, Financial Data Quality Management, Data Relationship Management
  • Automate and Improved insight and tracking of company construction projects
  • Automate and Improved ability to monitor and report on bid process for organization.
  • Improved Asset and Warranty Tracking for 600 Clients, Customers and Inventory throughout California.
  • SQL Server 2005/2008/SSRS, SSAS, SSIS Crystal Reports - Warranty and Customer Maintenance Schedule BI/Dashboard review/reporting.
  • Oracle/SQL Server 2005/2008 Asset Database and Reporting.
  • Oracle/SQL Server 2005/.2008 . Net and SharePoint Web Portal and Document Management - Bid/Contract and Design Documentation Application and Database.

Confidential, Salinas, CA

Senior Technical Manager, Business Intelligence Architect

Responsibilities:

  • Configuration, Design, Gap Analysis and code OBIEE/OBIA Project, Financials, Transportation Mgt FTIL, Order Management, Supply Chain, Sales, Procurement, Human Resource Analytic Modules support/implementation. JD Edwards to OBIA OLAP Target data warehouse Data Lineage analysis and implementation.
  • Hyperion BI Suite version 7.x and upgrade to 9.0 - Workspace, Hyperion Planning, Planning Modules, Essbase and EAS, Financial Reporting, Web Analysis, SmartView, Oracle Data Integrator, Strategic Finance, Financial Data Quality Management, Data Relationship Management
  • Oracle Data Warehouse design and support. PL/SQL programming/optimization and stored procedures design, development, and support, OLTP and Datta Warehouse Data Modeling design and implementation, ETL Data Integration design
  • Tuning of Nightly, Weekly and Monthly Informatica version 6.2, 7.0, 8.0 ETL Data Warehouse Loads/Data Feeds.DAC 10, OBIEE 10, OBAW, Tableau, BI Publisher, OBIEE Answers, Monthly/Quarterly/Annual $1 Billion in Annual Financial Reporting, Profit and Loss Data Mart. Redbook and Transportation Management expenses. Reduced monthly close analysis process by 50 % from 10 days to less than 5 days.
  • Weekly Business Unit Interface and Project support. Define End User Business Requirements, Develop and Maintain Technical Functional requirements.

Confidential

Data Warehouse Systems Architect, Mgr

Responsibilities:

  • Improved Analysis and Tracking of $400 Million in Deposits and Treasury Daily Account balances
  • $50 Million Capital Asset Tracking Data Mart of all IT and Telecom equipment and assets.
  • Annual savings of $5 Million in improved monitoring of asset evaluation and improve Infrastructure service to 30 Banks throughout California.
  • SQL Server 2000 Database Systems Administration and Support - Mortgage and Account Management application.
  • ER/Win Data Modeling design and implementation.
  • Crystal Reports design/development.
  • Oracle and MS SQL Server 2000 Security and Maintenance Procedure.
  • Database and Application Morning Checklist Report Procedure.
  • Develop and Maintain Network Password Policy.
  • NT/2000 Server Setup Procedure and Checklist.

Confidential

Data Warehouse Architect

Responsibilities:

  • Staff and Budget Management.Daily and Weekly operational support for SQL Server 2000 and Oracle/Lawson Database Systems.
  • ER/Win Data Modeling design and implementation.
  • Oracle Data Warehouse ETL Creation, Update and Performance Tuning.
  • Improved monthly close process by 40% reducing close time.
  • Created Hyperion Data Mart resulted in reduction of actual expenses by $4 Million dollars.
  • Design, Development and Support. Manage Corporate Steering Committee and projects and reporting related to Corporate Data Warehouse, Data-mart and OLAP Systems support.
  • Project Management, Prioritization, Report/Data Extract needs, Issues/Resolution tracking.
  • Define and track Service Level agreements with Business Units.
  • Software technologies include SQL Server, Oracle, Lawson, Hyperion Essbase and Business Objects.

Confidential

Data Warehouse Architect

Responsibilities:

  • Architect Data Warehouse Systems. Projects and Initiatives included Design and Development of Data WarehouseArchitecture and SDLC Standards for SQL Server, Oracle and DSS Microstrategy. ETL Creation, Update and Performance Tuning.
  • ER/Win Data Modeling design and implementation.
  • Applications included Credit Modeling, Portfolio Analysis and Customer Service Rep productivity Data Warehouse, Data-mart and OLAP Systems.
  • Replaced spreadsheet based credit portfolio analysis process with Oracle Data Warehouse system. Reduced time from 7 days to 4 days of valuation of potential portfolio purchases.
  • Improved Account Collections by 40%. Increase Call Center Tracking of Customer Service Rep accounts for collections. Evaluate and assignment of Accounts assign and collection activity tracking for analysis.
  • Manage operations support of Oracle and SQL Server environment.

Confidential

Responsibilities:

  • Healthcare and HMO Applications and Database Systems. Corporate data and application migration from Legacy IBM/DB2 to SQL Server/Client/Server and 3-tier Architecture.
  • ER/Win Data Modeling design and implementation.
  • Visual Studio/Application Development. Crystal Reports Design and Development Duties.
  • SQL Server and Sybase Database and Data Warehouse reporting Systems development and support.ETL Creation, Update and Performance Tuning.
  • Facilitated Electronic Tracking and oversight of $300 in HMO Claims processing by building electronic interfaces to corporate Platinum Accounting Financials.
  • P&L, Budget and Analytics Systems ongoing design and support.

Confidential

Oracle Data Warehouse Architect

Responsibilities:

  • Reduced Client Invoicing electronic process from 5 days to 3 days by facilitating trend analysis and accuracy of associate assignment tracking at Confidential Clients.
  • Key Client Invoicing Data Warehouse efficiency allowed company to proceed with exponential growth from $3 Billion to $8 Billion over 2 years.
  • ER/Win Data Modeling design and implementation.
  • Manage Oracle Data Warehouse and SQL Server Data Marts.
  • Database Development projects for weekly and monthly payroll and billings.
  • Data Definition, Implement and Support Data Warehouse Architecture and SDLC Standards.
  • Crystal Reports Design and Development duties.
  • ETL Creation, Update and Performance Tuning.

We'd love your feedback!