SUMMARY:

• Business Intelligence System Development and Maintenance (SPOTFIRE, TABLEAU, Microsoft BI)
• Custom Oracle and SQL - Server ETL Confidential 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
• Confidential Development utilizing Full Confidential Development Life Cycle Services and Review
• Project Management - Waterfall and Agile teams
• Change Management
• Strategic and Team Building
• Web Confidential Development and Maintenance
• Information System General Control installation and review

PROFESSIONAL EXPERIENCE:

Senior Migration Specialist

Confidential

Responsibilities:

• Confidential needed to migrate client’s older e-discovery POSTGRES database and SOLR data to the latest version of their software. Issues we clients had newer number scheme in latest app that could collided with from the older system Complete 3-6 month project in 7 weeks using migration transformation views for POSTGRES databases and PERL scripts for SOLR meta data updates.

Senior Database Developer/Consultant

Confidential

Responsibilities:

• North American Well Analysis Tool - develop and maintain Spotfire Visualizations based on Oracle and SQL server tables and views. Develop and implement ETL procedures to load and prepare data for SPOTFIRE visualizationsusing 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.
• Global Economic Model ETL utilizing materialized views, PL/SQL packages, dynamic SQL, triggers, ref-cursorsSQL*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.

Tools: used: TOAD for Oracle, TOAD for SQL Server, SQL Developer, SQL-LOADER, SPOTFIRE, Python, R Studio, Microsoft SSIS, SSMS, BI, Visual Studio 2015, M/S Office (word, excel, project, access), TextPad, SVN, BITBucket, TABLEAU.

Senior Database Developer/Consultant

Confidential

Responsibilities:

• Data ETL for Drilling, Completions, Production, and Reservoir Management for internal Confidential, 3rd party Confidential
• (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, racle 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 Confidential 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: SPOTFIRE, TOAD, SQL Developer, SQL-LOADER, M/S Office, TextPad, Microsoft VSS, TFS

Senior Database Developer/Consultant

Confidential

Responsibilities:

• Implement various system enhancements to accommodate HAMP Directives
• Customize and Install BPO and Property Inspection System (PEARL)
• Develop and Implement Supporting Comps Order System (LEAP) (Red Bell & LPS interface)
• Customize and Administer Investor Reporting and G/L Feed to Oracle Financials
• Implement Support System Administration and Monitoring of C - BASS Confidential
• Collateral Document Tracking system interface to Litton s UDM Oracle System
• Assist in migrating Oracle applications from 9i to 10gR2 and current migration to 11gR2.
• Develop prototype HTML direct load data base application for addition product ordering/tracking.
• Example System Design and Oracle Related Tasks related to above:
• Business Requirements gathering, interface design between multiple vendors (LPS, Redbell, BPO vendors, Property
• Inspection Vendors, security profiles, general controls, application controlsDocumentation like Entity Relationship Diagrams, Swim-Lanes, etc.
• Data Base Design: relational tables, xml tables, indexes, views, objects, types, foreign keys, other constraintsref-cursors, sequences, database links, roles, grants, synonyms, directories, etc.
• Stored procedure development of packages, procedures, functions, table triggers, database triggersdynamic sql, procedure debugging, query optimizing with explain plan, TKPROF, etc.
• Data Imports and Exports, Transforms, and Loads - flat tables, xml documents, SQL loader, utl fileTOAD table import/export

Tools: used: TOAD, Sql Developer, SQL-LOADER, M/S Office (word, excel, project, access) TextPadMicrosoft VSS, Job Scheduling - TIDAL Scheduler, UNIX/SOLARIS CRONS System Migrations from Access to Oracle environment.

Principal Confidential Analyst/Consultant

Confidential

Responsibilities:

• Legacy system conversion to Confidential Enterprise Resource Planning (ERP) Confidential: General Ledger, Financial Reporting, Budgeting, Billings, Accounts Receivable, Purchasing, Accounts PayableProject/Grant Accounting, Payroll, personnel, student administration, Utility Customer Information Confidential, etc.
• Web Confidential development utilizing Oracle pl/sql packages, procedures, triggers.
• Oracle Reports and Forms development and implementation
• Oracle data base trigger development and implementation.
• DBA tuning services (indexing, sizing, backups, etc.)

Senior IT Consultant

Confidential

Responsibilities:

• Provide appropriate services to meet client needs such as:Legacy system conversions to Enterprise Resource Planning (ERP) Confidential (SCT Banner):
• General Ledger, Financial Reporting, Budgeting, Billings, Accounts Receivable, Purchasing, Accounts Payable, Project/Grant Accounting, Payroll, personnel, student administration, Utility Customer Information Confidential, etc.
• Project/System evaluation (tuning, control adequacy)
• Web Confidential development utilizing Oracle pl/sql packages.
• Oracle Reports and Forms development and implementation
• Oracle data base trigger development and implementation.
• DBA tuning services (indexing, sizing, backups, etc)
• UNIX administration
• Example projects:
• Informatica Mapping from IBM MQ Series into Oracle partitioned Data Base
• Custom reporting for SCT Banner utilities release (2.2.1.2.1).
• Web purchasing card and travel card system interface into SCT Banner Finance.
• Custom Web portal pages for SCT Banner student system.
• Web Based operational reporting system for SCT Banner Finance.
• Custom SCT Banner finance interface into state of Arkansas' financial reporting system.
• Custom reports for Oracle Financials - General Ledger, A/P A/R
• Oracle Financials flex-key design, conversion, and load
• PVCS - Source Control/Management installation and Modification
• Staffing Supervised: Various client personnel based upon project needs.
• Equipment Utilized: Various client environments: Sun, DEC, IBM, Compaq, Dell, etc.

Software Used: O/S:Microsoft NT, .net server, UNIX (AIX, SOLARIS), DEC-VMSORACLE: OAS, IAS, Oracle Reports, SQL*FORMS, SQL*Loader, Pro*C, Pro*COBOL, pl/sql, etc.

Consultant

Confidential

Responsibilities:

• Provide clients with needs determination, alternative solution generation, feasibility studies, action plan development, RFP generation, vendor selection, bid, project management, post implementation review, security review, internal control review, etc.Provide presales support, implementation support with custom modification, user, DP staff, etc.

Software Used: UNIX (NCR, HP-UX, DEC-ultrix, AIX), ORACLE, SQL*Report, SQL*FORMS 2.3, SQL*Report WriterSQL*Loader, MicroFocus COBOL, pro*C

UNIX System Administration

Consultafdsfnt

Responsibilities:

• Provide clients with needs determination, alternative solution generation, feasibility studies, action plan development, RFP generation, vendor selection, bid, project management, post implementation review for clients' financial, accounting, personnel, and payroll Confidential .
• Provide implementation support with custom modification, user, DP staff, EDP control and security procedures, etc.
• Staffing Supervised:
• Various client personnel based upon project needs.
• Equipment Utilized:
• Client Dependent

Software Used: Client Dependent: Concentration on PC Applications

Director of Information

Confidential

Responsibilities:

• Automate the Audit process
• Provide administrative support Confidential
• Operations & Capacity Planning
• System Software Support
• Application System Development Maintenance
• Confidential Development
• EDP Staff
• Office Staff
• Client Management Advisory Services
• System adequacy evaluations
• Confidential requirement definitions
• RFP Development
• Proposal Evaluation Support
• Implementation Support
• Post Implementation Review
• Staffing Supervised:

Senior Confidential Analyst

Confidential

Responsibilities:

• The EDP section personnel are expected to perform in the PC, Mini, and Mainframe environments that are encountered in our clientele and to adjust quickly to changing environments. Section performs as internal consultants to management and audit staff.
• Equipment Used: IBM 4381 - MVS/XA; WANG VS90 / VSOS; PC's (8088, 286, 386) / MSDOS
• HP, Wang, COMPAQ, KAYPRO, ZENITH, DELL (Portables & Desktops)
• Software Used:
• SAS, COBOL, Utilities, JCL, ISPF, 370 Assembler, COBOL, BASIC, Assembler, PACE, Utilities, PROC, EDITOR, WP, WP Plus, Wang OFFICE, IWSCORE, LOTUS 123, EXCEL, Wang PC WP, Wang PC, WP Plus, WORDSTAR, MS-MASM, MS-C, GW BASIC, RBASE, DBASE IV, Ventura, SUPER
• EDP Audit function:
• Developed and Implemented
• Internal Control Adequacy Review
• Internal Control Adequacy Review related to Financial/Compliance Audit
• Data Collection, Summarization, Stratification, Sampling, Reporting.
• Perform control reviews on statewide, parish (county), and local governmental entities' financial, accounting, personnel, and payroll Confidential .

EDP Auditor

Confidential, Baton Rouge, LA

Responsibilities:

• Implement EDP Audit function at bank to provide for internal control review in EDP General Controls and review of internal controls for each computerized application)
• Provide computer support to audit staff independent of EDP Staff.
• Assist external auditors in audit of Fin. Stmts. (i.e. generate confirmations, samples, summary runs, etc. using AUDIT Analyzer (4gl).
• Provide the CEO & Board of Directors with independent and objective information on EDP related matters.
• Staffing Supervised: Staff assigned on a project basis.
• Equipment Utilized: IBM 3031 OS/MFT
• Software Used:Audit Analyser (a 4GL), SPF, FORTRAN IV, CICS
• Various progressive MIS positions -

Programming Manager

Confidential

Responsibilities:

• Managed staff of 20 programmers and analysts organized into three system development and implementation groups for Individual taxes, Business Taxes, and Natural Resource Related tax Confidential .Development effort followed the system development life cycle approach utilizing structured programming in a top- down development effort. Each year was a major development effort since the legislature changed taxes every July for implementation the following January.
• Developed, implemented, and maintained state classified personnel system for the department.
• Provide system programming support for IBM CICS online transaction monitor and IMS-DL/1 hierarchical data base involved staff on functionality of products, maintaining and tuning products.
• Staffing Supervised:Each tax team consisted of a Confidential Analyst and two Senior Programmer Analysts and 3-5 junior programmer analysts.

Analyst

Confidential

Responsibilities:

• Design, modify, implement and maintain large state business, individual, and natural resource tax Confidential . Assigned tasks, monitored progress, compared against expected results, modified plans as required, provided guidance and in technical matters, scheduling work hours, approving leave requests and functioning
• Supervised Senior Programmer Analyst and 3-5 junior programmer analysts.

Programmer Analyst

Confidential

Responsibilities:

• Modify, implement and maintain large state business, individual, and natural resource tax Confidential .
• Staffing Supervised: Supervised Senior Programmer Analyst and 3-5 junior programmer analysts.
• Equipment Utilized: IBM 370/3031, 370/148, 370/145

Software Used: JCL, OS/VS1, OS/MVT, COBOL, VM, CMS, 360/370 Assembler, CICS Macro, CICS CommandFORTRAN, PL/1