Oracle ERP Developer Resume

SUMMARY:

Accomplished Systems Analyst/Developer with over 20 years of experience utilizing Oracle Applications including Forms, Reports
Oracle Application Framework and PL/SQL modules to improve productivity, reduce costs and streamline processes.
With a diverse functional and technical background brings insight into developing solutions to problems.
Work well on all with all members of assigned team or project.

TECHNICAL SKILLS:

Databases: ORACLE (12c 11g, 10g, 9i, 8i)

Operating Systems: Solaris, HP - UX, AIX, Linux

Languages: SQL, SQL*Plus, PL/SQL, SQL*Loader, Unix Shell Scripting

Oracle Reports: (11, 10g, 9i, 6i), Oracle Forms (11, 10g, 9i, 6i)

Tools: TOAD, SQL Browser, PL/SQL Developer, PVCS, Clear Case, FTP, Maximo, Remedy, Data Loader, Team Track

Applications: Oracle 11i Financials (AP, PO, AR, GL), HR/Payroll, Inventory (INV) and Workflow) Oracle 12 Financials (AP, AR, PO), Workflow and Approval Management Engine(AME) Oracle 12c Financials (AP, AR, PO, GL)

Additional Oracle Training: Oracle Application Object Layer, Oracle Workflow

PROFESSIONAL EXPERIENCE

Confidential, Maryland

Oracle ERP Developer

Responsibilities:

Assisted with conversion from Oracle R11 to Oracle 12, Identified several coding changes needed to custom processes used throughout the system
Investigated Oracle 12c impacts on coding standards and practices
Changed and tested reports, interfaces, BI reports, and other processes for Oracle 12c
Regression test high exposure interfaces and processes for major patch application
Assist the functional team members with technical analysis for help desk issues
Convert Excel spreadsheets with Visual Basic Macros to Oracle processes

Confidential, Pennsylvania

Oracle ERP Systems Analyst/Developer

Responsibilities:

Provide production support for R11 iSupplier, Purchasing, Accounts Payable and Workflow
Provide production support for R12 iProcurement, Purchasing, Accounts Payable and Workflow
Systems Analyst to third party packages for Proposals/Pricing and Accounts Payable Imaging
Perform needed changes for converting from R11 to R12
Create and/or maintain custom PL/SQL packages, forms and reports
Created process to streamline AP invoice creation saving the company considerable time and money
Perform performance tuning on high cost queries.

Confidential, Augusta, Maine

Oracle Developer

Responsibilities:

Created Excel based reports that saved end users time (several hours per week) by not having to enter data from printed reports into Excel for data manipulation
Developed text based reports that saved operations staff several days at yearly billing time
Mentored junior staff members in techniques and capabilities of Oracle Forms and Reports to increase output within the department
Built reports that can be printed in house saving costs ($600 a month) with external provider
Wrote PL/SQL processes for batch data manipulation that saved operations several hours per process
Upgraded software which allowed for utilization of new functionality to streamline processes
Initiated enhancements to existing application which allowed for expanded services to customers
Ensured compliance for government tax reporting purposes by making necessary enhancements
Converted Oracle Forms 6i to 10g

Confidential,St. Louis, Missouri

Oracle Developer

Responsibilities:

Initiated online Task Reminder process so staff can keep track of upcoming contract renewals and changes which increased efficiency and allowed for management oversight
Initiated audit process for contracts so management can get an overview of status
Created methodology to interface XML data coming from an outside vendor into internal database to ensure data integrity
Tuned Oracle PL/SQL modules to run more efficiently to improve processing time by 10%
Create extensions to Oracle application using custom tables and Oracle Forms to provide additional data outside the base application to the user community
Added necessary program logic to make modules Sarbanes-Oxley compliant
Worked as an analyst to gather requirements from user community freeing up time for Functional Analyst to take on additional responsibilities

Confidential, Rochester, New York

Senior Programmer Analyst

Responsibilities:

Cost Studies identified unused reports that were retired, which in turn decreased mainframe chargeback costs saving the department money
Conversion of mainframe reports to distributed system reports using ACTUATE further reduced departmental overhead.
Created Oracle Alerts to identify employee status changes to create or delete computer access
Worked as front person for TAR support
Developed and ran test scripts to ensure system functionality after patch or upgrade installation
Proved support to third party software implementation

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship