SUMMARY:

Work Experience: Over 10 years development and functional hands - on experience with Oracle EBS Applications Suite; Release 11.5.10, R12.1.3, R12.2-R12.2.5 projects with emphasis on development with Confidential Extensions; Vast experience developing integrated solutions using Java/PLSQL/BI Publisher/SOA/AME; OBIEE/Discoverer; Data Conversion; Workday; Integrations with Amazon (AWS)

SKILLS:

APPLICATIONS: Oracle Applications R11i/ 12.1.3/12.2. x; Modules Oracle Purchasing, iProcurement, Accounts Payables, iExpense, Accounts Receivable, General ledger, Oracle Projects, Approval Management Engine, Confidential, SOA Gateway, HRMS, Payroll, Enterprise Asset Management (EAM), iRecruitment, iSupplier, Payments, Manufacturing, INV, eBTax; WORKDAY

RDBMS: ORACLE V9, 10g, 11g, 12c, 11g/12c-EX, SQL Server

ORACLE TOOLS: Oracle Application Framework ( Confidential ), Oracle Developer (Forms10g and Reports 10g), Discoverer, ADF, APEX, Workflow Builder 2.6, XML Publisher, Oracle JDeveloper, OBIEE, SQL Developer, Web ADI, Confidential

LANGUAGES/TECH: JAVA, C#, SQL, PL/SQL, ASP.net, MVC, JSP, XML, XSL, XSLT, XDOFX, C/C++, ColdFusion, FoxPro, PHP, Perl, JavaScript, HTML, iOS/Objective-C, shell scripting, MCL, MVC Frameworks, REST and SOAP, JAX-WS, JAX-RS, JSON, WSDL, XSD

OTHER: PVCS, TFS, SVN, Git, Visual Studio, Eclipse, VirtualBox, Informatica

EXPERIENCE:

Technical Developer/Consultant

Confidential

Responsibilities:

• Confidential Extensions to iProcurement pages for Project/Task ( Confidential ) information using Favorites and allowing the selection via a custom poplist on the requisition distribution; accommodate additional Shipment details from R12.1.3 to R12.2.4/R12.2.5 using view object substitutions and Application Module code
• Confidential Controller Extensions to Supplier Maintenance pages for conditional read-only/update privileges using PVO
• Confidential Controller/AM Extensions to eBusiness Suite Login Page to allow for enhanced approval routing during password reset
• Customizations to PO Approval and Requisition Approval workflows in support of modified requisition document and approval hierarchy based on dollar limits
• Oracle HR/Payroll data conversion to Workday using PL/SQL and INFORMATICA including worker compensation, withholdings, address/personal info, allocations, benefits
• XML mappings to Workday web services
• Confidential Extensions to Enterprise Asset Management (EAM) as part of R12.2.5/R12.2.6 upgrade including VO substitutions, conditional page UI rendering (PPR)
• Design/Develop custom Lockout/Tagout solution which leveraged existing EAM Permits module to allow multi-use of functionality across multiple Organizations - functionality was previously implemented in Maximo
• Provide extensible Advanced Search capabilities within Work Orders to allow searches of Confidential Attribute columns for Work In Process (WIP)
• Develop dynamic poplists using OA Framework for Project/Task/SubTask within EAM Work Orders
• Application setups include FlexFields, Menus, Responsibilities, Functions, Lookups, Securing Attributes, and ValueSets allowing for the implementation of a custom module specific to JEA
• Design custom BI Publisher ( Confidential ) reports using EAM module Confidential extension for auto-submission within the HTML pages; data file selected against custom table data for Lockout/Tagout application

Confidential

Responsibilities:

• Confidential extensions to iProcurement which allowed for custom business logic validations at the Distribution level for project/task, dynamic Confidential poplists, and shipment details
• UI enhancements to display additional inventory item data which required VO extensions and controller mods in conjunction with R12.2.5 upgrade
• Extensions to Buyer Work Center document types that allowed for Confidential support in the Confidential pages within BWC to match Purchase documents within Forms; provided consistency among users and lessened PO interaction time from the buyers iExpense Confidential extensions to include additional validation on expense approval workflow with AME which also addressed an issue with the seeded WF; approver list validation during expense submission allowed maximum flexibility to iExpense users and accommodated ad-hoc approval insertions

Confidential

Responsibilities:

• Upgrade data model from 11.5.10 to R12 including data for Suppliers ( Confidential ), General Ledger ( Confidential ), UMX/Securing Attributes, Accounts Payable, Payments in support of Online Patching
• Upgrade Discoverer EUL to 11g data model with R12 eBusiness Suite Application integration; modified existing DB objects for R12.2.x compliance including Materialized Views and standard views
• Update Discoverer reports to run in Desktop application and Viewer within EBS

Confidential

Responsibilities:

• Confidential Extensions to iSupplier pages for external supplier registrations and internal supplier maintenance for purchasing users that included the update of the UI into runtime dynamic radio groupings and custom business logic validations which provided a reduction in the manual labor required to set up suppliers
• Confidential Extensions to Buyers Work Center supplier information pages to maintain supplier business information, including tax data that was previously done via email or other paper process
• Data conversion, customizations, extensions and BI publisher reports that gave users access to newly gathered supplier data during registrations and subsequent supplier maintenance

Confidential

Responsibilities:

• Implementation and setup of Release 12.1.3 version of EBS (WIP, Supply Chain, and Financials).
• Design and develop Java concurrent program via Amazon web services API to transfer images to Amazon S3 for inventory items and updates to Oracle document tables (mobile phones)
• Development of objects and data conversion in support of eBS 11.5.10/12.1.3 - supplier, payments, and invoices using custom PL/SQL programs and SQL Loader
• Design solution using SOA Gateway ( Confidential ) web services within the Inventory module and develop custom Java and PL/SQL web services for integration with existing in-house applications; this included sizing and compression of phone images for storage in AWS S3 buckets with source-level security from EBS tables and placement of URL reference from AWS S3 into corresponding inventory item Confidential
• REST and SOAP web services using JAX-RS and JAX-WS integration with WIP and AWS for mass updates of images via scheduled concurrent requests
• Confidential extensions to Supplier Maintenance pages to allow for a customized supplier management for a separate subset of business users. This included modified view/update/create functionality, updated tabbed browsing of pages, customized lists, other redesigned pages
• Data conversion process of supplier data from client's existing system into the R12 AP supplier tables and Confidential
• Designed Payment documents including customized Purchase Order BI Publisher Templates to import custom logo, automated signature, and other advanced formatting features of dynamic invoices within a check payment.
• Confidential template was also designed for use with automated banking payment submissions

Confidential

Senior Software Specialist

Responsibilities:

• Currently developing a replacement solution for existing Pcard Web Solutions third party application that leverages PO Line types with a custom reconciliation process with APEX integration and the existing Oracle Pcard module for credit card setup and management; Confidential extensions to iPro Receiving for custom receipts
• SOAP web services written in PL/SQL and Java with Confidential integration and invocation using Confidential ; SOA Gateway integration with iOS
• APEX application development with CRUD operations and validations as replacements for ColdFusion applications
• Implementation of a custom Check printing and Confidential processing solution for the Oracle Payments module which is new in R12; Modified seeded XML check template in R12 Payments using a custom BI Publisher RTF layout
• SOA Gateway/( Confidential ) custom web services for integration with other in-house applications using WSDL technology
• Confidential extensions to Supplier Maintenance to allow function and role-based access to control read-only and full access; custom pages created for invoice import with header/line level detail including associated import errors
• AME approval list generation - developed custom compliance review process using Confidential within iProcurement which expanded checkout to 3 steps to allow for rule-based routing using input from users in real-time requisition creation within the shopping cart; this includes a custom Oracle eBS module written in Confidential to support rules and routing
• AME with Confidential extensions in 11.5.10 and migrated to 12.1.3 for Requisition Approval (transaction type) to include parallel approvals since this wasn't available in 11.5.10 - WF customization in addition to Confidential for approval list generation to include ad-hoc approvers, run-time manipulation of approvers, and optimization to the AME-generated approval list
• Oracle Discoverer 10g support with eBS 11.5.10 transactional data; Custom Data Warehouse upgrade to 12c which includes transactional data upgrade from 11.5.10 to R12.1.3 with modules/tables including Purchasing, iProcurement, AP, iExpense, GL, Confidential, Projects, Payments, and Noetix Views
• Design OBIEE Answers/Dashboards/web services as alternatives to obsolete Discoverer reports
• Design and develop Web ADI worksheets via Excel with eBS integration including data validation to reduce kickouts
• Designed and developed new bank interface process which would create Supplier banks, bank branches, Bank accounts and assign them to employee suppliers with the use of the R12 Banks Confidential architecture.

Confidential, Las Vegas, NV

Software Specialist

Responsibilities:

• Provide daily production support and maintenance of production Oracle e-Business Suite GL, AP, PA, AR, Purchasing, Receiving, iExpense, and iProcurement; Custom JSP application development that uses public Oracle APIs
• Confidential extensions to iProcurement to enable custom line type Confidential support in shopping cart.
• Advanced expertise in Confidential development including self-secured pages to allow users access to compliance review questions/rules for approval routing (use of UMX), Confidential pages for creation/modification of rules used by the review process, integration pages for access to external applications (residing outside of eBS); this allowed flow of data from external applications into EBS
• Implemented complex Confidential templates executed as Java Concurrent Programs
• Created custom XSL stylesheets using BI Publisher for use by the PO Communicate functionality including line level file attachments of multiple types
• Extensions to AME rules for parallel approvals in Requisition Approval Transaction type
• AME setups to support complex requisition approvals of 45+ approving organizations within EBS
• Design and implement .NET applications (C#) using MVC framework
• FoxPro and ColdFusion application production support
• Development work on pilot program integrating iOS (Objective-C) mobile apps with Oracle SOA; concept was receiving on iPhone and Confidential web service integration for import of receipt information into EBS including Confidential XML templates for the barcoded receipt (3-of-9)
• Integrate Amazon's AWS with in-house application and Oracle eBS for image manipulation and storage
• Confidential extensions to supplier and customer pages to include customized menu based on responsibility and various UI updates for data security by organization
• Develop BI Publisher templates for Confidential, Confidential, and Confidential
• APEX application development with CRUD user interfaces, reporting pages, and read-only views and search options
• ADF model applications using Oracle VirtualBox for demos/feature visualization