PROFESSIONAL SUMMARY:

• 14 years of technical experience customizing and supporting Oracle applications
• 11 years of IT experience within the Oil and Gas Industry (10 yrs - Upstream and 1 yr-downstream)
• 3 years of IT experience in Oracle Supply Chain (OM/INV/PO/MFG)
• 10 years of experience in Oracle PL/SQL, Forms 6i/10g, Reports 6i/10g), Oracle Applications R12/11i
• Extensive experience as Oracle Apps Technical consultant in implementations, upgrades and customizations of Oracle e-Business Suite Applications. This includes requirement gathering, design, development, and post implementation maintenance.
• Experience in developing/Customizing/Migration/Support of Oracle E-Business Suite with major focus in General Ledger (GL), Account Payables (AP), Account Receivables (AR), Purchasing (PO), Inventory (INV)
• Detailed knowledge of Oracle Architecture, Data Dictionary and DBMS Packages
• Expert with application tools including TOAD, SQL Developer and Oracle Data loader
• Experience with UNIX scripting, .NET programming, XML/SOAP, Java, C, C++, HTML
• Experience with reporting using Crystal Reports
• Expert in data modeling for complex third-party enterprise applications
• Expert in P2ES Enterprise Upstream and Tobin Enterprise Land System
• Expert in Enterprise Application Integration development (webservices)
• Experience with developing ETL mappings and scripts using Informatica
• Petrotechnical and Geoscience Application Experience: OpenWorks, Recall, Interactive Petropysics
• Working knowledge with Oracle SOA
• Excellent communication skills and customer service relations
• Proven ability to provide 24x7 production support

WORK EXPERIENCE:

Confidential

Software Engineer

• Worked with cross-functional team including Order Management and Supply Chain
• Developed and maintained Oracle PL/SQL objects including procedures, functions, packages and database triggers
• Wrote complex ad-hoc SQL queries for analysis
• Used traces and explain plans to troubleshoot Oracle performance issues
• UNIX Shell Scripting to automate procedure execution
• Developed enhancements to existing monitoring jobs including Oracle Concurrent Programs, UNIX scripting and Oracle PL/SQL packages.
• Tidal Enterprise Scheduler
• Collaborated with off-shore resources to ensure solutions are implemented on time
• Used Salesforce, Remedy and ServiceNow for incident management
• Reverse Logistics

Confidential

Consultant, Bartlesville, OK

• Developed and maintained Oracle Objects including PL/SQL procedures, functions, packages and database triggers
• Developed customizations using Oracle Application Framework
• Wrote complex SQL queries used to extract data for migration to SAP PRA
• Interacted with end users and functional architects for mapping legacy data to SAP PRA
• Used explain plans and SQL tuning to optimize query performance
• UNIX Shell Scripting to automate procedure execution
• Developed PL/SQL stored procedures to import/export flat files and perform data transformations
• Worked closely with business SMEs to conduct highly complex business process analysis and needs assessments
• Provided enhancements and client specific coding for Data Warehouse solution using Informatica
• Provided 24x7 production support for Third Party Crude applications

Confidential, Houston, Texas

Enterprise Application Developer

• Worked with team to successfully implement P2ES Tobin Enterprise Land (TEL)
• Worked closely with key business users to develop custom QA tool using MS Access for upper level management within Land department
• Provided support and customization for integration between Oracle E-Business Suite and P2 Enterprise Upstream
• Developed and maintained system documentation, including technical specifications, data mappings, program logic, and flowcharts for Land applications
• Collaborated with 3rd party vendors to debug multiple issues after go-live.
• Assisted with re-architecting TEL configuration to improve performance by 66%
• Enhanced application security controls ensuring 100% SOX compliance across Land applications.
• Provided 24x7 production support for entire suite of Land related applications

Confidential, Houston, Texas

IT Consultant, Petrotechnical and Geoscience Systems

• Upgraded Recall version 5.0 to 5.3 for worldwide implementation
• Collaborated with key business users to develop detailed test cases
• Developed Linux scripts to move Well Log data from FTP site for loading into the Corporate Log database

Confidential, Houston, Texas

IT Consultant, Land Management

• Developed enterprise application customizations using Oracle Forms and Reports 6i.
• Provided support and customization for integration between Oracle E-Business Suite and P2 Enterprise Upstream
• Worked on a project to convert and migrate data from Quorum Division Order (QDO) application to in-house developed Property Ownership System application using PL/SQL coding
• Performed data mapping and loading for several acquisition projects
• Acquired in depth knowledge of Quorum DOD and QLS database schema
• Developed an ASP.NET solution integrating Quorum Division Orders (QDOD) and FileNet for scanning, storing and retrieving Land Documents, streamlining the process for document retrieval and viewing
• Provided production support for Quorum Land System QLS and QDOD

Confidential, Houston, Texas

IT Specialist, Enterprise Application Integration

• Developed solutions integrating enterprise applications consisting of Oracle, MS SQL, MySQL and proprietary backend databases
• The integration application was built on a UNIX platform utilizing the OpenWorks SDK to integrate Log Data between RECALL and PowerLog as well as Well Data between OpenWorks, RECALL, PowerLog, Petrel, P2000, and IRIS21
• Developed an integration solution using webMethods (XML/SOAP) to pull daily KPI data for displaying in a management dashboard

Confidential, Houston, Texa

IT Summer Intern, Land Management

• Worked on a team to provide daily support and custom development for all Land Management applications