Senior Oracle Developer
Desired Position: Senior Data Base Developer/Architect
. Custom oracle and SQL-Server Systems’ development with table creation, triggers, procedures, packages, functions, query optimizations (hints, indexes, partitioning), forms, reports, web pages, job scheduling, in RAC and Non-RAC.
. Information Technology System Development, Management and Implementation Services, Oil and Gas Upstream, Operational Data Capture, Custom Development for Banner Finance, Banner Student, Banner Payroll, Banner Utilities
. Data Base Design, Administration, Performance Tuning
. Systems Development utilizing Full Systems Development Life Cycle Services and Review
. Project Management - Waterfall and Agile teams
. Change Management
. Strategic Training
. Team Building
. Expert in many computer languages
. Web Systems Development and Maintenance
. Business Intelligence System Development and Maintenance
. Information System General Control installation and review
. Information System Application Control installation and review
Education: 1975 - iana State University at Baton Rouge
B.S. - Computer Science - minor in Mathematics and Accounting
10/2017–12/2017 - Senior Migration Specialist - Client: Servient, Inc.
Servient needed to migrate client’s older e-discovery POSTGRES database and SOLR data to the latest version of their eDiscovery software. Issues were mainly clients had newer number scheme in latest app that could collided with data from the older system Completed 3-6 month project in 7 weeks.
10/2014 – 09/2017-Senior Database Developer/Consultant - Client: Wood Mackenzie, Ltd.
Global Economic Model ETL utilizing materialized views, PL/SQL packages, dynamic SQL, triggers, ref-cursors, SQL*loader, external tables etc. for the Field, Plant, Integrated Plant, Prospects modules. Processes loaded vertical tables and pivoted selected verticals tables to horizontal for reporting, created program to generate ETL PL/SQL packages based on metadata definitions.
North American Well Analysis Tool ETL utilizing materialized views, PL/SQL packages, SSIS packages, T-SQL stored procedures, dynamic SQL,, triggers, ref-cursors, external tables etc. for the Oil and Gas well production in costs – brought in to stabilized the process, reduced runtime to 9 hours from 30 hours by refactoring. Reduced run time to 60 minutes from 9 hours by redesign and rewrite. Conversion of SPOTFIRE C# wrapper code from oracle calls to SQL SERVER calls.
Well Exploration Tool – convert system from C# to SPOTFIRE and SQL Server.
Refinery Benchmark Tool – convert system from C# to SPOTFIRE and SQL Server.
Tools used: TOAD for oracle, TOAD for SQL Server, SQL Developer, SQL-LOADER, SPOTFIRE, Python, R Studio, Microsoft SSIS, SSMS, Visual Studio 2015, M/S Office (word, excel, project, access), TextPad, SVN, BITBucket.
11/2011 – 10/2014 - Senior Database Developer/Consultant
- Client - EOG Resources Inc. (contract position with DISYS)
Data Extract, Transform, and Load for Drilling, Completions, Production, and Reservoir Management for internal systems, 3rd party systems ( Canrig PERC, Merrick PROCOUNT, P2 QBYTE, Peloton – WellView, SCADA data imports) utilizing materialized views, PL/SQL packages, dynamic SQL, triggers, ref-cursors, SQL*loader, external tables, oracle data cartridges, etc. PL/SQL Data retrieval packages for C# front-end applications
XML Data Extracts for external interfacing (FRAC-FOCUS)
Parallel Processing Design for oracle RAC 11gR2 systems table and index partitioning
Conversions from oracle 10g to 11gR2
oracle Job Scheduling and External Job Scheduling (adTempus)
Agile System Development and Project Management
Tools used: TOAD, SQL Developer, SQL-LOADER, M/S Office, TextPad, Microsoft VSS, TFS
07/2007 to 11/2011 Senior Database Developer/Consultant
Client - Litton Loan Servicing, LP (contract position with SoftPath)
Implement various system enhancements to accommodate Federal Directives.
Customize and Install External Vendor product interfaces extract-transform-load.
Develop extract-load scripts for Sybase-IQ columnar database (NOSQL).
Customize and Administer Investor Reporting and G/L Feed to oracle Financials.
Implement Support System Administration and Monitoring of Parent Company Systems.
Implement Document Tracking system interface to clients oracle Systems.
Assist in migrating oracle applications from 9i to 10gR2 to 11gR2.
Develop prototype HTML direct load data base application for addition product ordering/tracking.
Business Requirements gathering, interface design between multiple vendors (LPS, Redbell, BPO vendors, Property Inspection Vendors, security profiles, general controls, application controls, Documentation like Entity Relationship Diagrams, Swim-Lanes, etc.
Data Base Design: relational tables, xml tables, indexes, views, objects, types, foreign keys, other constraints, ref-cursors, sequences, database links, roles, grants, synonyms, directories, etc.