Techno Functional Developer Oracle Ebs Resume
Austin, TX
SUMMARY:
- Oracle EBS application developer (forms/reports/plsql/xml) with 15+ years of experience.
- Experience creating PL/SQL/XLM code and database packages to gather data from the database in order to create detailed interfaces and reports with applicable information.
- Experience with Linux shell scripting (csh, bash, Perl) along with application integration/interfaces.
- Documentation AIM Methodology of both technical and functional (MD50 /MD70)
WORK EXPERIENCE:
Confidential, Austin, TX
Techno Functional Developer Oracle EBS
Responsibilities:
- Support Technical and Functional OM/SC/SO - Orders, PTP, Service Contracts and Renewals, AR invoices, and Revenue Recognition
- Use of Miro (shared virtual white boards), Jira (Kanban) and SAFe (Scaled Agile) methodology (scrum master)
- Up to Oracle EBS version 12.2.9
- Working with users and developer team in global environment to provide support helping with processing issues and provide solutions
- PL/SQL and SQL tuning (including using SQL profiles) and testing 11g
- Oracle Agile PLM - inventory configuration
- Surround SCM - change management and source control tool
Confidential, Omaha, NE
Application Developer
Responsibilities:
- Support Technical and Functional (Procure-To-Pay, Project Billing) - maintain and enhancements
- Provided daily user support helping with processing issues and training regarding process flow
- PL/SQL and SQL tuning (including using SQL profiles) and testing 11g
- Custom XML Reports 11g - using XML Publisher
- Customized processes using WebADI interface to load data
- HPQC/Stat version control / change management
- Custom Desktop Integrators for PA, GL and HR
Confidential, Torrance, CA
Application Developer/Systems Administrator (Remote)
Responsibilities:
- Supported GL/AR/AP-IBYFA/PA/SLA (Project Billing/HR/OTL/ Procure to Pay process) EBS version 12.2.5
- Provided daily user support helping with processing issues and training regarding new processes
- Customized invoicing formats and custom Desktop Integration using standard API
- Convert existing accounting to new SLA generation.
- PL/SQL and SQL tuning and testing 11g
- Custom Forms Personalization
- Modules Finance/Projects (AR/AP/FA/GL/PA)
Confidential, Hilton Head Island,
Oracle Developer/Systems Administrator (Remote)
Responsibilities:
- Supported in-house custom application that supported order entry, customer service and service management.
- Rewrote Perl Script to interface with new upgraded software, dealing with customer’s orders, such as equipment ordered and customer information.
- Developed Oracle Forms reports, on the back end, in a Unix environment, and created Perl Scripts to embed Oracle Calls.
- Worked with Oracle 11g Forms, Fusion 10g and created Forms and Reports 11g.
- Working experience with PL/SQL including Procedures, Functions, and Cursors & Triggers.
- Created UNIX shell scripts and crontab for repeating tasks.
- Configured Perl Scripts in new RedHat Server, to ensure proper performance.
Confidential, Torrance, CA
Application Developer/Systems Administrator
Responsibilities:
- Supported GL/AR/AP/PA Project Billing/HR/OTL/FA and created internal customized application modules and implemented Oracle HR.
- Upgraded existing 11.0.3 Oracle applications, a financials and projects modules application, to 11i and to 12.2.3
- Performed user testing and converted existing customized processes, such as Forms and Reports 10g.
- Enhanced various custom oracle forms to help users resolving the bugs in productions system.
- Provided daily user support helping with processing issues and training regarding new processes.
- AR interfaces - Banking statements, ACH deposits, reconciliation, positive pay
- Customized Check Printing
- Installed, setups and configured Oracle Time and Labor module (OTL) with Project Interface.
- Created several customized timecards by modifying standard timecard layouts and objects.
- Workflow Builder - customize
- Installed and setup a Linux based DMZ to interface timecard module to the internet, including external workflow email notifications.
Confidential, Venice, CA
Oracle EBS Developer/User Support
Responsibilities:
- Provided user support on application’s functionalities, such as OM/GL/AR/AP/PO/PA (Procure-To-Pay) Project Costing/HR and FA and developed customized timekeeping and payroll application modules on Oracle Financials 11.i.
- Upgraded new functions and implemented Oracle HR, Advanced Benefits (OAB) and Compensation Workbench (CWB).
- Developed custom interface, developed on 9i/6, to external ADP payroll system along with WebADI/XML applications for both updating and reporting HR contracts and VISA data.
- Upgraded existing 11 Oracle applications, both financials and custom modules, to 11i in 2005 as well as to version 12.1.3 in .
- Custom timecard using Forms and applications development
Confidential, Torrance, CA
Functional EBS Application Support
Responsibilities:
- Maintained old character based (vt100) and release Oracle 10.5 version for company’s Canadian division’s accounting and manufacturing system.
- Modified AP check printing process to support new legal check format, which was previously using a 4.5 version.
Confidential, San Dimas, CA
EBS Technical Oracle Applications Support
Responsibilities:
- Converted existing 11.0.3 reports/Sql programs’ functions, such as AR/OE/OM, P2P, Manufacturing, and Shipping, to 11.5.10.2.
- Rewrite the PL/SQL store procedures codes.
- Customized AR, consolidated Invoice Billing, Invoice Creation, Sales Tax and Invoice Transactions Report.
- Customized Order Management and Shipping modules by creating new functions for Bill of Lading, Shipping Container Reports, Sales Backlog Aging and RMA forms.
- Developed and implemented custom forms, to include Sales Order and Ship Confirmation screens.
Confidential, Santa Barbara, CA
Oracle Developer
Responsibilities:
- Developed and modified large scale customized healthcare application using Oracle Forms and Reports.
- Created Medi-Cal health care claims form processing applications and interfaces.
Confidential , La Palma, CA
Technical EBS Application Developer
Responsibilities:
- Worked on the implementation of Oracle Apps CRM 11.5.8, a Customer Support and Service Requests application, creating JTA Tasks, Business Rule Workflows and Resources.
- Modified existing forms and reports to support user required functionalities.
- Created new custom forms, for Contact Center and UWQ, and reports.
- Configured Security Functions for resources and groups.
Confidential , Fort Walton Beach, FL
Lead Technical EBS Application Developer
Responsibilities:
- Part of the team implementing a new Oracle Application, version 11.5.5, focused on Manufacturing and Financials modules.
- Trained existing programmers on Oracle Forms and Reports using them with Oracle Applications, such as OAL, Custom.pll and Template.fmb.
- Developed interfaces to PA (expenditures, projects), AR invoices and customers, PO suppliers and open PO’s from legacy system and customized OM billing to PA.
- Created new custom transaction controls for PA and workflows for Order Management and customized shipping modules to interface with PA to only bill when item shipped.
- Interfaced AR’s auto-invoice and customers along with inventory information to load initial parts information.
