Technical Developer/consultant Resume
Las Vegas, NV
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 OAF Extensions
- Vast experience developing integrated solutions using Java/PLSQL/BI Publisher/SOA/AME; Data Conversion; Workday; Integrations with Amazon (AWS)
TECHNICAL 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, ISG, SOA Gateway, HRMS, Payroll Enterprise Asset Management (EAM), iRecruitment, iSupplier, Payments, Manufacturing, eBTax, WORKDAY
RDBMS: ORACLE V9, 10g, 11g, 12c, 11g/12c-EX, SQL Server
ORACLE TOOLS: Oracle Application Framework (OAF), Oracle Developer (Forms10g and Reports 10g), Discoverer, ADF, APEX, Workflow Builder 2.6, XML Publisher, Oracle JDeveloper, OBIEE, SQL Developer, Web ADI, ISG
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
PROFESSIONAL EXPERIENCE:
Technical Developer/Consultant
Confidential
Responsibilities:
- OAF Extensions to iProcurement pages for Project/Task (PTAEO) 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
- OAF Extensions to eBusiness Suite Login Page to allow for enhanced approval routing during password reset
- Oracle HR/Payroll data conversion to Workday using PL/SQL and INFORMATICA
- OAF Extensions to Enterprise Asset Management (EAM) as part of R12.2.5 upgrade
- 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 DFF 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 (BIP) reports using EAM module OAF extension for auto-submission within the HTML pages; data file selected against custom table data for Lockout/Tagout application
- OAF extensions to iProcurement which allowed for custom business logic validations at the Distribution level for project/task, dynamic DFF poplists, and shipment details; provide 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 DFF support in the OAF pages within BWC to match Purchase documents within Forms; provided consistency among users and lessened PO interaction time from the buyers iExpense OAF 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
Consultant/Technical Lead Developer
Confidential
Responsibilities:
- Upgrade data model from 11. including data for Suppliers (TCA), General Ledger (SLA), UMX/Securing Attributes, Accounts Payable, Payments
- 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
- OAF 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
- OAF 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
- 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 (ISG) web services within the Inventory module and develop custom Java and PL/SQL web services for integration with existing in-house applications
- REST and SOAP web services using JAX-RS and JAX-WS integration with WIP and AWS
- OAF 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 TCA
- 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. An EFT template was also designed for use with automated banking payment submissions
Confidential, Las Vegas, NV
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; OAF extensions to iPro Receiving for custom receipts
- SOAP web services written in PL/SQL and Java with OAF integration and invocation using ISG; 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 EFT 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
- (ISG) custom web services for integration with other in-house applications using WSDL technology
- OAF 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 OAF 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 OAF to support rules and routing
- AME with OAF 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 OAF 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. .1.3 with modules/tables including Purchasing, iProcurement, AP, iExpense, GL, SLA, 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 TCA architecture.
Confidential, Las Vegas, NV
Software Specialist
Responsibilities:
- Provide daily 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
- OAF extensions to iProcurement to enable line type DFF support in shopping cart.
- Advanced expertise in OAF development including self-secured pages to allow users access to compliance review questions/rules for approval routing (use of UMX), OAF pages for creation/modification of rules used by the review process, integration pages for access to external applications (residing outside of eBS)
- Implemented complex BIP templates executed as concurrent programs; JAVA Concurrent Prrograms
- Created custom XSL stylesheets using BI Publisher for use by the PO Communicate functionality
- Extensions to AME rule for parallel approvals in Requisition Approval Transaction type
- Design and implement .NET applications (C#) using MVC framework; FoxPro and ColdFusion app support
- Development work on pilot program integrating iOS (Objective-C) mobile apps with Oracle SOA
Software Developer
Confidential
Responsibilities:
- Integrate Amazon's AWS with in-house application and Oracle eBS for image manipulation and storage
- OAF 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 EFT, ACH, and Checks
- 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
