Bob Ochoa

Senior ETL/ELT

Security Clearance

Microsoft SSIS, SQL Server, Integration Services Service, Integration Services Object Model, SSIS Designer, Query and Expression Builder, Data Flow and Packages design and development. and Oracle ODI, ETL/ELT, ODI 11g, Topology, Operator, Design, Oracle FUSION 11 Adaptor custom interfaces, Oracle FTS FUSION design and support interfaces which are used to populate the SDS schema/tables Analytics Packages include Financials, EAM, Project, Human Resource, Procure and Spend, Sales and Supply Chain Analytics

Multi-Billion Annual Revenue US and International Clients in the Past 7 years include Federal (DOT/FAA),Oracle Corp, Reed Elsevier, ICG,Chevron, Chiquita Intl, Ascension Healthcare and Howard Industries

561-***-**** cell

adcb7v@r.postjobfree.com

Technical Business Intelligence, Database and Data Warehouse skills summary

•Microsoft SSIS, SQL Server, Integration Services Service, Integration Services Object Model, SSIS Designer, Query and Expression Builder, Data Flow and Packages design and development.

•ODI 11g, 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. Financials, Human Resource, Supply Chain, Procure and Spend, Projects and Sales Analytic data integration design and enhancements. Install and Configuration of ODI 11g Repositories (Master/Work), and Client toolset. ODI Studio, Agent and product suite.

BSBA - Accounting/MIS - University of Southern Miss 1989

Professional Experience

Highland Technology Group – ETL/ELT consultant 3/2018 – Present

Microsoft SSIS, SQL Server, Integration Services Service, Integration Services Object Model, SSIS Designer, Query and Expression Builder, Data Flow and Packages design and development.

Informatica ETL and Oracle ODI 11g ETL design and development. ODI Designer, Operator, Topology Physical, Logical soure/target definition. Interfaced, Procedures, Load plan, Agent design, development and implementation. Install and Configuration ODI Repository,

Oracle Corp – Business Intelligence BI Consultant 10/2017 – Present

ETL Golden Gate SDS and ODI SDE/SIL/PLP design and development, functional and technical guidance and design role. Oracle FUSION 11 Adaptor custom interfaces, Oracle FTS FUSION design and support interfaces which are used to populate the SDS schema/tables from the BICC extracts (.csv) from Fusion. SDE_FUSION design and support interface, which use used to populate the DW temp and staging tables from the SDS tables/columns. 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.

Federal – Department of Transportation/FAA 1/2016 – 9/2017

Senior Data Integration/BI Consultant

Oracle FUSION 11 Adaptor custom interfaces, Oracle FTS FUSION design and support interfaces which are used to populate the SDS schema/tables from the BICC extracts (.csv) from Fusion. SDE_FUSION design and support interface, which use used to populate the DW temp and staging tables from the SDS tables/columns.

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.

Akorn Pharmaceutical), Chicago, IL 10/2015 –4/2016

Peoplesoft/MS SSIS ETL and ODI Financials, Human Resource, Procure and Spend and Sales implementation and Support

•Microsoft SSIS, SQL Server, Integration Services Service, Integration Services Object Model, SSIS Designer, Query and Expression Builder, Data Flow and Packages design and development.

•Oracle ODI 11g ETL design and development. OBIEE RPD design and development. OBIEE Administration duties. ODI Designer, Operator, Topology Physical, Logical soure/target definition. Interfaced, Procedures, Load plan, Agent design, development and implementation. Install and Configuration ODI Repository, ODI Client Studio and Agent products.

Cigna, Bloomfield, CT 03/2015 – 9/2015

ODI and MS SSIS OBIA Consultant,Peoplesoft, OBIA/ODI Human Resource and Financials Analytics

•Microsoft SSIS, SQL Server, Integration Services Service, Integration Services Object Model, SSIS Designer, Query and Expression Builder, Data Flow and Packages design and development.

•Implementation utilizing ODI integration with Operating Expense activities within Cigna 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)

Valdosta State University, Valdosta, GA 1/2014 – 2/2015

Peoplesoft/ODI, Senior Business Intelligence Consultant, OBIA Financials implementation.

Peoplesoft integration with ODI OBIA Financials platform. Oracle RDBMS, OBIEE 11g, OBIA Financials, RPD, Catalog, Physical, BMM and Presentation Layer design and enhancement, ODI ETL Install/setup/Configuration/Gap Analysis/Extension of ETL and OBIA software, Migrate and design Budget and Actual Report migration from legacy

Reed Elsevier 10/2012 –1/2014

Consultant, Senior Business Intelligence Architect

-ETL Design and Development - 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.

-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

Oracle Corp 2/2012 – 10/2012

Senior BI Consultant (/Clients include Walmart, Disney, Vulcan, ESPN, ABC)

ETL 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.

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

And Vertical Clustering, 3000 users worldwide installations, 50 countries)

Howard Industries, Ellisville, Ms 12/2010 – 2/2012

Consultant – Data Warehouse Architect

Worlds Largest Transformer Producer.Responsibilities include

1)OBIEE 11g/10g product implementation and configuration

2)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.

3)BI Publisher/Smartview/Answers Report and Dashboard design and implementation.

Ascension Healthcare System 4/2010 – 12/2010

Business Intelligence Architect

$14 Billion National Healthcare system, 70 Healthcare Ministries.$800 Million, MIC Data Warehouse project.Responsibilities include

1)OBIEE 11g/10g product implementation and configuration

2)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.

3)BI Publisher/Smartview/Answers Report and Dashboard design and implementation.

4)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.

5)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)

6)OBIEE data access of Hyperion BI Product Suite 7/9/11 OLAP/Essbase data source implementation

7)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

Chevron, Inc. 12/2009 – 4/2010

Consultant – Solutions Architect

Business Intelligence and OLAP reporting solution development supports Legal, Compliance, Refinery Operations, and Human Resources systems support.

Oracle Data Warehouse design and support. PL/SQL programmingoptimization and stored procedures design, development, and support, OLTP and Datta Warehouse Data Modeling design and implementation, ETL Data Integration design

-Capital Project Management – $800 Million budget vs actual monitoring of all Refinery Capital Projects for Chevron Project Engineers. 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..

-Refinery Operations Management – Monitor refinery pump interface data for flow and pressure trends. Downloaded hourly flow data of all Chemical/Oil through Chevron Pipeline and equipment operations. Estimated $250 Million in savings as a result of prevention of Refinery Shutdown process.

Infinite Corp, Project, Danville, CA 3/2008 – 12/2009

Database Architect Director

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.

Fresh Express, Salinas, CA, 6/2005-3/2008

Senior Technical Manager, Business Intelligence Architect

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.

Infinite Corporation 6/2000-Present

Data Warehouse Systems Architect, Mgr

Staff and Budget Management supporting.Oracle Data Warehouse ETL Creation, Update and Performance Tuning.

-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.

Arch Wireless 6/1999 - 6/2000

Data Warehouse Architect

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.

-$2 Billion in Financials Supported Monthly Close process. Improved monthly close process by 40% reducing close time.

-$40 Million IT Budget vs Expense tracking duties. 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.

Exterra Credit, 6/1998 - 6/1999

Data Warehouse Architect

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.

Lifeguard HMO 9/1997-5/1998

Applications and Database Architect,

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.

Adecco International 9/1994 - 8/1997

Oracle Data Warehouse Architect

National Payroll and Invoicing Data warehouse for over $3 Billion in Clients and Key National Accounts.

-Reduced Client Invoicing electronic process from 5 days to 3 days by facilitating trend analysis and accuracy of associate assignment tracking at Adecco 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.

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

Education

BSBA - Accounting/MIS - University of Southern Miss 1989

Contact this candidate