Oracle Ebs Technical Support
Resume:
Ronald Danley, Jr.
Houston, Texas 77084
*******@*********.***
OBJECTIVE: Senior Oracle EBS Applications Developer/Oracle Admin/DBA 12c
Independent contractor open to full time.
QUALIFICATIONS:
Twenty-five plus years experience using the Oracle RDBMS and tools.
Experience includes requirements analysis, data modeling, database design, application development, administration, and technical support of Oracle based systems on various Microsoft, UNIX, and Legacy OS based platforms.
Work well independently or collaboratively
Able to perform multiple assignments, meeting crucial deadlines
Effective communicator able to relate well to people at all levels
Professional attitude and dedicated work ethics
ORACLE SKILLS:
AP, AR, GL, Purchasing, Distribution, P2 Enterprise (JIB, JVA, Revenue, P2Land, AFE and LOS), Oracle Alerts, HR, Payroll, SOX/Audit Compliance, OAB, JDK, System Administration, and XML Creation/Administration with RTF and XSLX.
ORACLE TOOLS:
Oracle Developer Suite 10g,11g,12.1,12C and 19C. APEX, Discoverer 11g and 10g BI, Noetix Views, Unix Shell Scripting, JAVA, PL/SQL Developer, Toad, Toad DBA, Toad Spotlight, Oracle Enterprise Manager, XML Publisher, and Microsoft Suite.
Operating Systems: All Windows, Digital UNIX, HPUX UNIX, and Oracle Linux.
EXPERIENCE HIGHLIGHTS:
May 2017 to Mar 2024
Independent Contractor/Coterra Energy Inc.
-System Admin/Dba
oPerformance tuning/monitoring.
oTrouble shoot and issues.
oPreform all Migrations to production.
oSupport 6 Test Environments with 1 Production Environment.
oMonitoring Unix/Database Performance along with size requirements.
-Setup and Install new P2land Environments that is a bolt on system to P2/EBS.
-Audit- Both internal and external. Provide Audit with all the information they request for all code migrations and system setups.
-Created and support custom interfaces that feed from Oracle EBS/P2 to ESSBASE for our Financial Reporting.
-Performed task in implementation of Oracle EBS 12c for Oil and Gas Energy Company.
-Currently working on implementation of Oracle Database 12c to 19c.
-Created Oracle Alerts to monitor database Performance.
-Use OEM to monitor and alert me of database issues.
-Use OEM to view AWR reports for performance issues.
Mar 2011- Swift Energy Operating LLC
Mar 2017 Senior Developer/Functional Analyst
Oracle EBS 11.5.10 & R12 (GL, AR, AP, PO, P2 Enterprise (JIB, JVA, Revenue, AFE and LOS), Sys Admin, HR, OAB, OTL, TOAD, Discoverer, XML (RTF/XSLX), APEX, and Java
-Upgraded Oracle (EBS and P2 Enterprise) from 11.5.10 to R12.
-ADP Open Invoice Interface - Responsible for maintaining 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.(Now Oildex)
-Supported and maintained Monthly Volumes with the API- NON ALLOC READINGS in Enterprise Upstream.
-Modified LOS DMRT MVIEWS to handle top side entries correctly.
-Modified and maintained a 3 stream report for volumes for Gas, Oil, and NGL.
-Created numerous of reports for Revenue, JIB, JVA, and AFE’s.
-Debugged and modified seeded P2 package APPS.EJ_GL_INTJE_PK to handle the source Receiving correctly.
-Created one report that took 3 reports for the LA taxes using a Revenue Tax Severance report, LA O-1d report and Operators Monthly Oil & Gas Production Report to group everything together for quick and easy analysis.
-Assisted in creation of the FSO (Field Service Order) custom software. Help create processes and interfaces that assisted in automating of Invoicing, Purchasing, Receipts, and Emails.
-Created a General Ledger Datamart that consists of every GL entry with all the sub ledger information from all the XLA tables since our GL is summarized.
-Created numerous event driven and periodic alerts.
-Created / Modified numerous reports many of which produced XML output utilizing the RTF and XSLX style sheets to produce Excel or PDF output files.
-Very knowledgeable of the Sysadmin duties.
-Assisted with the management of software selection and license negotiation.
-Modified the custom.pll to handle custom DFF’s validation.
-Worked with Internal and External Auditors for SOX compliance. Created many processes/reports in order to monitor compliance.
-Creation, modification and administration of Discoverer Reports.
-Utilized JAVA to develop interfaces to transfer data from SQL Server into Oracle.
-Performed DBA functions such as monitoring databases and managing system process performance.
-Created and maintained multiple interfaces between Oracle HR and external systems. Created Benefits interface to BCBS, OAB Resumes loader (Created a custom loader to load all resumes into Oracle), Employees Stock Purchase (Created a custom loader to load all the employees ESOP in Oracle OAB), Created reports to report to the state for the EEO filings.
Mar 2007- US Oncology, Houston, Texas
Mar 2011 Programmer/Functional Analyst
Oracle EBS 11.5.10 (Distribution, GL, AR, AP, PO, Sys Admin, AOL, Discoverer, XML, and TOAD, PL/SQL Developer)
-Created a set of reports for the 450 remote sites to maintain their operational expenses in Oracle E-Business 11.5.10.
-Create Service Request and follow-up with Oracle Support on Issues and Resolutions.
-Review and suggests Patches for Oracle EBS on technology issues.
-Use PL/SQL Developer, SQL/PLUS, Toad, Report Builder, Forms Builder, XML Publisher and Discoverer.
-Developed Customer Pricing Data Warehouse to support our Business needs. Developed several PL/SQL Packages and Procedures to extract all of the customer pricing information. Worked with our DBA’s to performance tune the process.
-Developed multiple Audit reports and business processes for SOX and State compliance for Oracle Applications and the Distribution of Cancer Drugs.
-Created multiple XML Publisher reports for Finance and Marketing Team.
-Wrote multiple Alerts to prompt Business users on Errors, Exceptions and Audit issues.
-Created multiple forms for our Custom Business Processes.
-Developed many Month-End reports for the Finance Team to assist in month end close.
-Develop and Modify Discoverer Reports for AP, AR, Purchasing, Order Entry, Security, Inventory, Pricing, GL, iStore and Auditing. Implemented Discoverer 4i to Corporate along with 500 remote sites.
-Worked with Web-Admin to use JDK instead of JInitiator.
-Reviewed the Discoverer 10g Patches and infrastructure. Planed, Upgraded and customized Discoverer reports to migrate to Discoverer 10g.
-Presented and taught many classes on using Oracle, Discoverer, and XML reporting in a class room setting and using Webcasts.
-Upgraded and customized Discoverer 4i to 10g.
-Developed XML Publisher reports to be distributed to different folders on a monthly basis.
-Migrated old Oracle databases into the current Production Oracle System.
-Created multiple Materialized Views to handle reporting and performance issues.
Nov 1999- Diamond Offshore Drilling Inc., Houston, Texas
Feb 2007 Programmer/HR & Payroll Analyst
Oracle EBS 10.7 – 11i (HR, Benefits, Payroll, GL, AR, AP, PO, Sys Admin, TOAD, and Discoverer Noetix and 11i Views
-Support and Troubleshoot Human Resources, Payroll and Purchasing issues with data, reports and application forms
-Created processes to export data and load into 3rd party system to report all 1099’s and W2’s.
-Troubleshoot Payroll run processes whether current set up or setting up new elements.
-Created the automated load of the BCBS load from Oracle to BCBS for all employees.
-Developed and Modified Reports and Forms for Human Resources, Payroll, Purchasing, AP, AR, GL and Training.
-Assisted in Oracle 10.7 to 11i application conversion and a 7.3.4.5 to 8.0 database conversion.
-Manage and maintain Discoverer with Noetix views for Human Resources, Accounting, Purchasing and Training.
-Created multiple Purchasing Forms to manage our custom purchasing logic.
-Performance tune Oracle reports, forms and packages.
-Manage and maintain systems for Treasury.
-Assisted in UNIX Admin and DBA functions for ongoing projects.
Apr 1998- Hydrochem Industrial Services Inc., Houston, Texas
Nov 1999 Programmer/Oracle Apps Analyst
Oracle EBS 10.7 (HR, Benefits, Payroll, GL, AR, AP, PO, Sys Admin, TOAD, and Discoverer Views, Unix Admin, DBA)
- Assisted in implementing Oracle 10.7NCA, 7.3.3.4 Database.
(Included Payroll, Financials, and Manufacturing)
- Developed and modified numerous reports using Report Builder 2.5, 3.0.
Also registered and applied appropriate security for the reports through the Concurrent Manager.
- Created new print styles and print drivers on the Concurrent Manager, along with
Setting up all printers and print drivers on the Unix box (HP4si, HP5si, HP 8100). Also set up and created Bitmap reports to allow Company Logos, etc.
- Performed System Admin on Oracle, Discoverer, and Unix.
- Supported approximately 60 people using all 3 modules.
- Developed/Modified a VB 5.0 program to track Payroll, Accounts Receivables, and
Accounts Payables for 50 remote locations.
EDUCATION & Training: Sam Houston State University, Huntsville, Texas
Bachelor of Science in Computer Science, 1995
Minor: General Business
Oracle Training – System Administration, SQ/PLUS, Report Builder, Forms Builder, Procure to Pay, Oracle Financials, and Discoverer.
IT Policies and Change Management
ACTIVITIES: Alpha Kappa Psi (Business Fraternity)
SHACS, Sam Houston Computer Club
REFERENCES: Available Upon Request
Contact this candidate