APEX, ORDS & Related Technologies

2022  |  APEX 21.2 Upgrade
  • Upgraded 4 environments.
  • 33 APEX Applications with 700 pages.

2021  |  APEX Security Advisory
  • AWS Security Design.
  • MFA using Twilio.
  • Tomcat hardening.
  • Upload File Virus Scanning.

2020  |  APEX 20.1 Change Management Request Application
  • Capture IT change management requests.
  • Single Sign on using Active Directory.
  • Approval management using Oracle Workflow.
  • Integration with employees form e-Business suite.

2020  |  APEX 20.1 Access Request Application
  • Capture requests for access to systems within the organization.
  • Single Sign on using Active Directory.
  • Approval management using Oracle Workflow.

2020  |  APEX 19.2-20.1 Upgrade (EBS)
  • Upgraded 4 environments.
  • 33 APEX Applications with 700 pages.
  • Project completed in one week.

2020  |  APEX 19.2, ORDS 19.1, EBS, AWS & APEX Office Print
APEX Order Capture Application
  • Rapid entry of orders through an easy to use customized UI in APEX.
  • Utilize master data from EBS (items, customers, suppliers etc.)
  • Batch Shipping and Invoicing Solution.
  • Orders interface to EBS for invoicing and accounting.
  • Development of customer facing emails and documents.
  • Attachments stored in AWS S3.

2020  |  APEX 19.2, ORDS 19.4, EBS, AWS
Build Cloud GRC Controls Application for Oracle EBS for software company
  • AWS APEX and ORDS install for Production and Development.
  • Multi-tenant framework allowing fast, secure onboarding of new customers.
  • Simple data extraction from Oracle EBS to Cloud using REST and an EBS Concurrent Program.
  • Extensive reporting and charting of GRC issues and EBS access information.
  • Email enablement using Amazon Simple Email Service (SES).
  • DBMS_SCHEDULER Job Management using custom scheduling engine.

2020  |  APEX 19.2, ORDS 19.4, AWS RDS
Advisory services for software company building their product on APEX & ORDS
  • Provided architecture guidance to help client determine the right platform to run APEX
  • Implemented APEX and ORDS on AWS RDS, EC2 and AWS Load Balancer
  • Developed dual Microsoft and custom sign on solution for APEX
  • Provided guidance on best practices for ORDS architecture and development

2020  |  APEX 19.2, APEX Office Print and EBS
Integrate New Acquisition into an EBS Environment
  • Mass update of EBS Blanket Purchase Orders using APEX
  • Convert EBS Items, On-Hand Balances, and Categories using APEX Excel upload
  • EBS Engineering job tracker with APEX and APEX Office Print

2019  |  AWS RDS, APEX 19.1, ORDS 19.2
Amazon RDS Migration from Exadata Express
  • Deploy APEX and ORDS on AWS RDS, EC2 and Application Load balancer
  • Migrate APEX applications and ORDS services from Exadata Express to AWS RDS

2019  |  APEX 18.1-19.2, ORDS 18.4-19.1
APEX and ORDS Upgrade
  • Over 30 APEX Applications and 500 pages
  • 25 ORDS Handlers​

2019  |  APEX 18.2, ORDS 18.4 and Oracle Service Cloud
APEX Integration with Oracle Service Cloud
  • Build custom authentication scheme using ORDS to allow Oracle Service Cloud users to authenticate into an on-premise APEX application and display APEX pages within tabs in Service Cloud.

2019  |  APEX 18.2, ORDS 18.4 and EBS 12.1.3
APEX and ORDS Upgrade in EBS Environment
  • Upgraded 400 Page APEX App from ​APEX 4.2.6 to APEX 18.2

2019  |  ORDS 18.4, Oracle Integration Cloud and EBS 12.1.3
Integrations to/from Oracle Service Cloud
  • Build OIC Connectors to allow Service Cloud to call ORDS web services and integrate Service Cloud data to Oracle EBS
  • Build outbound integrations from EBS to OIC web service connectors to integrate data from EBS to Oracle Service Cloud.
  • Build a framework to facilitate monitoring of inbound and outbound integration from/to Oracle Service Cloud.

2018  |  EBS 12.1.3, APEX 18.1 and ORDS on AWS RDS
Employee SMS Messaging Solution using Twillio
  • Build generic outbound and inbound SMS messaging system with Twillio
  • Allows business to send and receive SMS messages to/from Oracle EBS
  • Facilitate the timely communication of time sensitive information to employees
  • Capture SMS responses from employees using ORDS web hooks

​2018  |  EBS 12.1.3, APEX 18.1 and ORDS on AWS RDS
Employee Document of Record
  • Facilitate the capture of employee acknowledgments to key documents
  • EBS document of record functionality used to generate documents
  • Employee acknowledgment captured in APEX on RDS
  • Acknowledgements interfaced back to EBS using ORDS

2018  |  ORDS 18.1 and iOS
Material Inspection iOS App
  • Facilitate the capture of the condition of processed material using bluetooth connected devices
  • Feed the data back into the Oracle Database to be used for analysis and the creation of Quality Certificates
  • ORDS services used by iOS App to communicate with the Oracle Database
  • Over 50 iOS devices processing hundreds of readings each per day

2018  |  APEX 5.1, EBS 12.1.3
Employee Performance Management System
  • Provide modern, user friendly APEX UI to replace Oracle EBS Performance Management
  • Integrates with EBS via standard HRMS and Performance Management PL/SQL APIs
  • Used by over 600 employees to enter and manage 2018 objectives and appraisals

2017  |  APEX 5.1, EBS 12.1.3
Rapid Time Entry APEX Application on Oracle Time and Labor (OTL)
  • Provide user friendly APEX UI on OTL, integrates with EBS via standard HRMS PL/SQL APIs
  • Provided the ability to rapidly enter time cards which posted directly into Oracle Time and Labor
  • Increased speed an accuracy of time entry, provided reporting on completeness of weekly time entry

2017  |  APEX 5.1 and EBS 12.1.3
Mobile (Responsive) APEX Application to Capture Scale Weights
  • Provided ability for scale operators to capture material weights via an iPad
  • Part of an APEX solution used to manage 41 plants

2017  |  ORDS 3, EBS 12.1.3 and IOT
Developed ORDS REST services to allow an Internet of Things (IOT) company to interact with Oracle EBS
  • Spec driven design of ORDS REST services using RAML 1.0 on the Anypoint API Platform
  • Build of ten resources and over 20 handlers in ORDS 3

2017  |  APEX 5.1 and EBS 12.1.3
Comprehensive plant management system to manage production at 40+ plants 
  • Modules included; work order management, production entry, approvals, inspection and inventory management
  • Provide management with up to the minute views on production across all 40+ plants
  • Tight integration with EBS 12.1.3 to create and update Sales Orders as material is processed in the plant
  • Application translated into both French and Spanish

2017  |  APEX 5.1, EBS 12.1.3 and ORDS 3
APEX dashboard replacement project for a major packaging company.
  • Architecture, Install and Configuration of: GlassFish 4.1.1, APEX 5.1 & ORDS 3.0.8
  • Active Directory integration framework to:
    • Allow users to authenticate using Active Directory credentials
    • Perform authorization using Active Directory groups
  • Built more than 50 dashboard pages on top of EBS data using APEX 5.1

2016  |  Apache, GlassFish 4.1.1, ORDS 3 and APEX5
Architected APEX and ORDS infrastructure for an external customer facing APEX application.
  • Installed, configured and tuned ORDS 3 & GlassFish 4 on AWS EC2
  • Installed and configured Apache as a reverse proxy
  • Perform load testing using Apache JMeter

2016  |  Tomcat, ORDS 3.0.9 and APEX
Advisory services for an external APEX application used by a large payment processor to service their customers.
  • Provided recommendations on Tomcat and ORDS tuning and best practices
  • Built a comprehensive APEX and database monitoring dashboard using APEX
  • Built a Boomtown chatbot integration with APEX

2016  |  APEX5, EBS 12.1.3 and ORDS3
Architected a major upgrade of APEX and ORDS in an Oracle EBS environment for a large industrial company.
  • Planned and executed to upgrade of the following components:
    • APEX from 4.2.5 to 5.0.4, GlassFish from 4.0 to 4.1.1, ORDS from 2.0.8 to 3.0.7
  • Refactored ORDS 2.0 REST services to work in ORDS 3
  • Upgraded eight application with over 150 pages to APEX 5
  • Configured single GlassFish and ORDS instance to serve multiple APEX and ORDS requests

2016  |  APEX5, ORDS3 Upgrade
Re-implementation of a large APEX 3 system to APEX 5 for a medical services company.
  • Installation and configuration of APEX, GlassFish 4.1.1 and ORDS 3.0.8
  • Re-development of fifteen APEX 3 pages in APEX5
  • Configured the authentication of APEX users against Microsoft Active Directory

2016  |  ORDS3 REST and WebLogic
Advisory services for a software company who wanted to integrate their product with another product using REST services built using ORDS 3.
  • Provided mentoring on installing, configuring and running ORDS within WebLogic.
  • Implemented OAUTH2 authentication in ORDS.
  • Mentored development team on best practices for developing REST services using ORDS.

Oracle ERP Cloud & Integration

2022  |  Oracle ERP Cloud Financials for US Bank (NY)
  • System Architecture
  • Integration Assessment

2022  |  Oracle ERP Cloud Financials for Professional Services
  • Cloud to Cloud Data Migration
    • Customers and Open AR
    • Suppliers
    • Employees
    • Projects and Contracts

2022  |  Oracle ERP Cloud Financials for US Bank (MO)
  • System Architecture
  • Integration Design (Accounting Hub, Employees, Payments)
  • Security Design (Users, Roles, LBAC, SSO)

2021  |  Oracle ERP Cloud Financials for UK Healthcare
  • PaaS Extension using APEX to Replicate Journals
  • Concur Integration

2021  |  Oracle ERP Cloud Financials for US Bank (TX)
  • Single Sign On Configuration using Azure.
  • Audit Reporting.
  • Commissioning of Oracle Integration Cloud (OIC) running on Oracle Cloud Infrastructure Gen 2.
  • Job conversion and integration from Workday using OIC.
  • Location conversion and integration from Workday using OIC.
  • Employee conversion and integration from Workday using OIC.
  • Accounting Hub integrations (Core Banking, ADP) using OIC.
  • Banking Integrations (NACHA, statements).
  • IPP Check Printing.

2021  |  Oracle ERP Cloud Financials for US Financial Services
Rapid implementation of Oracle ERP Cloud.
  • Data Migration.
  • SSO Configuration using Azure, Okta and Auth0.
  • Banking Integrations (NACHA, statements).
  • Commissioning of Oracle Integration Cloud (OIC) running on Oracle Cloud Infrastructure Gen 2.
  • ADP Integrations (costs to GL, time to PPM).
  • Planning and Cutover Management.

2021  |  Oracle ERP Cloud Financials for US Insurance
Integrations using Oracle Integration Cloud.
  • Commissioning of Oracle Integration Cloud (OIC) running on Oracle Cloud Infrastructure Gen 2.
  • One Time Payments integration using OIC.
  • Accounting Hub integration using OIC.

2020  |  Oracle ERP Cloud PaaS Migration and Upgrade
Successful migration of ERP Cloud Mashup Extensions and custom APEX applications running on Oracle Schema-as-a-Service with APEX 18.2 to Oracle Autonomous Database (ATP) running APEX 20.1.   
  • Data Migration.
  • Code Migration and Remediation.
  • APEX Upgrade from APEX 18.2 to APEX 20.1.
  • Customization Testing.
  • Planning and Cutover Management.

2020  |  Oracle ERP Cloud Financials for US Retailer
ERP Cloud PaaS Extensions using Oracle APEX 20.1.
  • OKTA SSO Signon.
  • Job Management Framework.
  • Embedded and Standalone APEX extension pages for Self-Service Invoice Upload.

2020  |  Oracle ERP Cloud Financials for Merchant Bank
ERP Cloud Implementation replacing existing R12.1.3 EBS system.   Technical leadership covering
  • Data Conversion.
  • Audit Extracts to Splunk.
  • ACH Payments, Internet Check Printing and Positive Pay.
  • Intellimatch Integration for balance and transaction reconciliation.
  • OKTA SSO Configuration.

2020  |  Oracle PPM Cloud with Workfront AMS
Workfront is an activity management system being implemented by the client to manage and resource projects.    Workshops were held to understand the flows required to integrate this with the PPM Finance system.
  • Sent Projects, Task, Budgets and Customers to AMS Workfront leveraging Dell Boomi and BI Publisher.
  • Sent AMS Time to Oracle PPM as Expenditure Batches using Dell Boomi and Oracle APEX as an ERP Cloud Page Integration.

2019  |  ERP Cloud GRC Controls Framework Application
Build the initial framework for a GRC Controls Application for Oracle ERP Cloud for software company
  • APEX 19.1, ORDS 19.1, ERP Cloud, AWS
  • AWS APEX and ORDS install.
  • Multi-tenant framework allowing fast, secure onboarding of new customers.
  • Simple and secure data extraction from Oracle ERP Cloud using BI Publisher SOAP web services.

2019  |  Concur Global Rollout and R19 Upgrades
Rollout of ERP Cloud Concur solution to additional legal entities.   Planning and new feature analysis for quarterly upgrades.   
  • Concur rollout to Canada and Europe, extending the existing APEX PaaS solution to map the Standard Accounting Extract SAE accounting into Oracle Projects.
  • Cloud environment management and upgrade planning.
  • Deliver BI Publisher reports to identify and analyze issues with PPM Accrued and Deferred accounting process.
  • Deliver BI Publisher reports to collate and analyze profit across all projects and contracts worldwide by customer.
  • Extract and analyze user access supporting efforts to understand and reduce license impact of users roles and privileges.

2018  |  Cloud ERP Global Rollout and R13 Upgrade
Rollout of R12 ERP Cloud to 20 additional legal entities spanning 13 countries in Europe and USA.   Planning and new feature analysis for R13 upgrade.
  • Dell Boomi Integration Ariba, Tungsten, Banks, Healthcare Billing systems and Credit Card Providers.
  • Regression testing of existing solutions from original implementation.
  • BI and OTBI reporting.
  • Procurement and provisioning of cloud databases to support ERP Cloud development.
  • PaaS Custom Forecasting, Billing and Absence Reconciliation Applications developed in APEX.
  • PaaS Mashup UI Design and Build using APEX, simplifying Concur cost uploads.

2017  |  Cloud ERP R11 Implementation and R12 Upgrade
Technical team leadership for a global healthcare provider's implementation of ERP Cloud Financials, Project Portfolio Management, Procurement and HCM.
  • Dell Boomi Integration with Workday, MS Dynamics, ADP Payroll, Banks and Credit Card Providers.
  • Conversions using SOAP, REST, HCM Data Loader, FBDi and ADFDi.
  • BI and OTBI reporting.
  • PaaS Mashup UI Design and Build using APEX, simplifying Payroll cost uploads and absence reconciliation.

2016  |  Cloud ERP Advisory Services & Development
  • Conducted workshops to advise customers on best practices for extending Oracle Fusion Cloud ERP.
  • Build and deployment of OTBI and BI Publisher reports in Cloud ERP.
  • Provide advisory services for best practices for integrating with Cloud ERP.
  • ​Designed PaaS solutions for Cloud ERP using Oracle APEX.