SUMMARY:

Since 2003, I have been focused on Oracle database development in various capacities. Moreover, the involvement has been in the implementation, upgrade, support, and development of Oracle EBS applications since 2005, starting with Oracle applications 11.5.10 and the P2 Energy Enterprise Upstream products. This includes modules such as General Ledger, Purchasing, Accounts Payable, Accounts Receivable, Cash Management, Inventory, Core HR, Self - Service, OTL, EAM, the workflow engine and the approvals management engine. The implementations and upgrades included many facets of analysis, design, development, setup, and conversion of Oracle Applications from both technical and functional perspectives. My proficiency is in the design and development of custom applications, interfaces, reports, conversions, enhancements, and ETL through the utilization of Oracle methodologies and best practices realized through an algorithmic method for problem-solving. This technical capacity is complemented by a breadth of knowledge of various industries, including the oil and gas industry, functional understanding, business acumen, and continual learning to augment this capacity.

TECHNICAL SKILLS:

Languages: PLSQL, SQL, Shell script, Perl, Python, Java, JSP / JSF, C++, C, XML, and XPATH.

Concepts: Object-Oriented design principles, relational / dimensional design principles, data-warehousing concepts, abstract data types concepts, and data science.

Databases and Operating Systems: Oracle 8.5, 9g, 10g, 11g. Solaris/UNIX, Linux.

Technologies and Applications: Toad, PLSQL Developer, Oracle Reports 10g, Oracle Developer suite and XML publisher, sqlplus, sqlldr, J2EE, Oracle ADF / OAF, Eclipse, Apache HTTP/Tomcat servers, Oracle OC4J, and MySQL, and MS SQL Server.

Oracle modules: PO, GL, AP, AR, CM, HR, FND, INV, TCA, Install Base, Field Service, EAM, OM, IProcurement, and Service Contracts.

P2 Energy modules: EU, EB, JVA, AFE, ET, and ER

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Developer

• Purchase order & Purchase order detail - Created a new optimized purchase order and purchase order detail process as part of the data feed from JDE. Optimized internal queries used to fetch and process data, added modularity, and took advantage of bulk operations to enhance performance.
• Account Balance, Account Summary, and Budget Data Feed from JDE - Created a new optimized processes for account balance, account summary, and budget to realize a significant performance & efficiency gain. As part of development added process tracking and error logging to gain more insight into process level and table level errors. Additionally, added email notification that reports on process statistics. Extraordinary gains were realized in the execution time of the year-end process, which took a full week before to now about 2.5 hours.
• Payroll History Process - Created an optimized the processes for loading payroll history to realize a significant performance & efficiency gain. As part of development added process tracking and error logging to gain more insight into process level and table level errors. Finally, added email notification with process statistics.

Confidential

Oracle Developer

• While at BHP, I gained a deep & valuable understanding of the oil and gas industry from an operational perspective and its associated set of challenges including data integrity, integration with other systems, communication and interfacing of disparate systems and the management of data and complexity. To address these set of challenges, we worked with the business to use technological solutions to drive efficiencies in the day to day work of production analysts via loaders, interfaces, and reports to reduce manual steps involved in business processes in order to reduce complexity, reduce errors, and improve workflows. Additionally, validations and reconciliations were provided to alleviate users from this responsibility. Finally, issues and errors encountered during loader or interface runs were reported so that they could be corrected, thus providing an avenue for improvement.
• MPRT (Monthly Production Reporting Template) - Created a forecasting / accounting package that tracks production volumes from an engineer's estimate, to estimated daily production, to actual monthly production, and finally to what revenue actually books. First it takes an engineer’s estimated production, then applies daily and monthly true ups from the production system using various inputs from different sources into the calculation. Additionally, auto reversals are applied to each accrual type based on a defined and configurable threshold. Additionally, there may be volumes associated with joint venture exceptions, volumes in legal accrual, and top level adjustments. Finally, volumes are actualized using volumes coming from SAP PRA, the revenue system. This is the transactional component of the solution, which feeds into a star-schema reporting layer.
• MPRT OBIEE dashboards - Involved in creation, modification, and maintenance of processes that take MPRT transactional tables and transform to a star-schema dimensional data model and reporting layer consumed by OBIEE for management dashboards.
• Flowcal to Quorum Gas Analysis Interface - Created interface to take gas analysis data from the Scada system (Flowcal) into Quorum (the marketing system) using pipelined functions which stream data and are called within web services called by Informatica. Informatica subsequently unparses the XML and after validating loads into staging tables within Quorum. The data is then moved from staging to interface tables, and finally to core tables.

Confidential

Oracle Developer

• At Swift, I developed technical and functional proficiency in Oracle and more specifically, the Oracle EBS suite. This includes Oracle SQL, PLSQL, UNIX shell scripting, Reports 10g, BI publisher, Discoverer, and Oracle applications. Gained exposure to core Oracle modules such as AP, AR, PO, GL, etc. Additionally, broadened horizontally the skills needed for Oracle development. Worked with the business directly for requirements gathering and to formulate those into technical solutions. Greatly enhanced my understanding of business processes like purchasing, accounts payable and receivable and the flow of transactions to the general ledger from various sources.
• Oracle applications Implementation & R12 upgrade - Core member of Oracle EBS team involved in conversions, requirements gathering, analysis, and design, and development during the year-long implementation and its subsequent transition to support mode. Additionally, for the R12 upgrade project involved in modifications of packages, reports, interfaces, and SQL queries impacted directly or indirectly by the R12 upgrade process. Through the upgrade process, gained understating of changes in financial modules, sub ledger accounting, structural and process changes, file system architecture changes, and changes in the tech stack i.e. greater emphasis on XML publisher and OAF / ADF framework, with customizations, extension to the OAF / ADF pages.
• Interfaces & processes - Responsible for numerous (both automated and non-automated) processes for the transformation, extraction, and loading of data into and out of the ERP. These interfaces were implemented through a combination of sqlldr, SQL, PLSQL, Shell scripting, and Perl on Oracle apps 12.1.3 with an Oracle 11g backend.
• ADP Open Invoice Interface - Responsible for creation of interfaces that connect ADP Open Invoice system to the Oracle ERP system. This involves communication in both directions. Cost centers, AFEs, Purchase Orders, users and their approval groups are all imported into ADP. Invoices are imported into the ERP system.
• Custom Checks interface - Involved in separation of custom checks process loads from the accounts payables table. As part of this checks are now stored in a custom table, viewable through forms. In addition, a check clearing process was created to reconcile these checks.
• JVA process - Created process to explode out details of Cost Management transactions that flow through to the JVA module, specifically from Receiving and Inventory sources in the sub ledger, and get DFF values such as AFE numbers, service dates, and bill codes and populate tables in the P2 JVA modules.
• PO Workflow - Modified custom PO workflow process to display both positional and approval hierarchy as part of the email notification and work items. This extensive work involves customizations to the standard Oracle workflow to include Standard Purchase Orders, Blanket Purchase Agreements, and Blanket Releases. Very knowledgeable of the workflow engine, approvals management engine, approval assignments, and approval groups. Worked with consultants on the set up and configuration of AME for both proof of concept and implementation. Finally, worked with the team to implement business rules such as PO approvals through the use of AME when possible to reduce customizations in the code.
• Revenue Accrual Process - Created automated revenue accrual process to extract daily volumes, which are subsequently fed through P2’s revenue accrual process via a file transfer mechanism.
• Total flow / Clearscada Interface - Involved in the creation of interfaces that facilitate imports of data from external systems into ERP. The interfaces range from collection of data from Scada systems in the field, currency loaders, and checks import processes.

Confidential

CGI Programmer

• Web-based reports - Core area of responsibility included the creation, maintenance, and modification of web-based reports written in Perl with Oracle database backend. Created a web-based domestic production report that encompasses volumetric production of oil, gas, and ngl from all areas of the company’s operations and non-operated wells.