Keith Ewen, Developer in Davenport, FL, United States
Keith is available for hire
Hire Keith

Keith Ewen

Verified Expert  in Engineering

PL/SQL Tuning Developer

Location
Davenport, FL, United States
Toptal Member Since
June 18, 2020

Keith has nearly 40 years of experience in the IT industry with the last 20+, designing and developing using Oracle database and Oracle eBusiness Suite. He's also delivered presentations at Oracle Open World and Oracle Application User Group conferences. Keith has made individual contributions as well as managing on-shore/off-shore teams of up to ten resources. Keith is very detailed-oriented and always delivers a quality product.

Portfolio

KB Information Solutions
Accounts Receivable, Oracle Database, Oracle ERP, PL/SQL, SQL, Bitbucket, Jira...
KB Information Solutions
Oracle, SQL, PL/SQL, EBSr12, Oracle PL/SQL, Database Development
Keste
Oracle, Salesforce, PL/SQL, Oracle E-Business Suite (EBS) R12, Oracle PL/SQL...

Experience

Availability

Part-time

Preferred Environment

Subversion (SVN), PL/SQL, Oracle Database, Unix

The most amazing...

...out-of-the-box design I've worked on was a unique way to interface many different data sets that cut the development time frame from months to weeks.

Work Experience

Owner

2019 - PRESENT
KB Information Solutions
  • Tuned multiple long-running PL/SQL procedures to produce gains of 70-90%. These improvements enabled the business to reduce the period end GL close process from fifteen to six hours.
  • Provided production support to the account receivable department. This included diagnosing production issues and designing/developing enhancements to existing processes. All issues and enhancements were tracked using Jira.
  • Helped with the migration of all code from CVS to Bitbucket.
Technologies: Accounts Receivable, Oracle Database, Oracle ERP, PL/SQL, SQL, Bitbucket, Jira, Database Development

PL/SQL Developer

2018 - 2019
KB Information Solutions
  • Designed and implemented an interface to import customers accounts, contacts, and addresses into EBS from the external system. The interface was to be used for initial customer conversion and ongoing maintenance.
  • Ensured that new customers were placed on hold in the interface tables for business review; implemented Web ADI to review and update the required mappings to existing customers.
  • Composed shell scripts to aid in the migration of code and app setup.
  • Supported all phases of testing and production cutover.
  • Created and maintained all required documentation for custom design and development.
Technologies: Oracle, SQL, PL/SQL, EBSr12, Oracle PL/SQL, Database Development

EBS Architect

2014 - 2018
Keste
  • Led discussions to identify gaps between Salesforce and EBS.
  • Architected, designed, and led the implementation of integrations from Salesforce to EBS for customer and invoice data using Cast Iron as the integration tool.
Technologies: Oracle, Salesforce, PL/SQL, Oracle E-Business Suite (EBS) R12, Oracle PL/SQL, SQL, Database Development

OBIEE Architect

2014 - 2018
Keste
  • Implemented OBIEE for company employees using standard security features and enabled specific access types to ensure that the customer only had access to their data and specific reports and dashboards; the next phase of the project was to enable customer’s access to BI data via dashboards and reports.
  • Prototyped a security solution to enable AD to display member-specific BI dashboards and reports.
  • Implemented a security solution in production.
  • Aided in the redesign of a data model.
  • Developed with JavaScript to enable BI Publisher reports to open on mobile devices.
Technologies: Oracle, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle PL/SQL, Database Development

Data Architect | Developer

2014 - 2018
Keste
  • Designed and developed database objects to support a high-traffic eCommerce website.
  • Collaborated with onshore and offshore teams to support development and testing.
  • Built a proof of concept (POC) with Apache Spark, Python, and WSO2 Complex Event Processing engine to support a new functionality within the eCommerce website.
Technologies: Oracle, Agile, PL/SQL, Oracle Database, eCommerce, Oracle PL/SQL, SQL, Database Development

Oracle Database Architect

2014 - 2018
Keste
  • Consolidated seven Oracle databases into a single instance using the virtual private database (VPD) concept to ensure data segregation and minimize the application code changes.
  • Designed and developed an app that generated VPD context; due to an existing procedure, a small number of Oracle views were required to be modified to support the data segregation.
  • Implemented configuration changes to the existing applications that accessed the seven Oracle databases.
  • Conducted performance testing and tuning of the consolidated database.
Technologies: Oracle, Oracle Database, Oracle PL/SQL, PL/SQL, SQL, Database Development

Technical Project Manager

2014 - 2018
Keste
  • Converted Oracle Discover Workbooks to OBIEE Analysis which consisted of approximately 200 workbooks that contained nearly 500 worksheets to BI Analysis—the project was delivered on time and under budget.
  • Liaised between business users and the offshore development team.
  • Planned and monitored report conversion.
  • Coordinated OBIEE updates between onshore and offshore teams.
  • Reviewed data model changes with developers and the client.
  • Composed weekly status reports to monitor progress and attended weekly status meetings.
Technologies: Oracle, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle PL/SQL, SQL, Database Development

EBS Solution Architect

2014 - 2018
Keste
  • Migrated from a file-based B2B integration to EBS XML Gateway for purchase orders and AP Invoices to/from external suppliers. The integrations were required to utilize existing FTP processes.
  • Configured and extended the standard purchase order (Out) XML transaction conforming to OAGIS extension standards.
  • Configured and extended the standard invoice (Inbound) XML transaction.
  • Designed and developed a process to import the XML file that was received on the FTP server.
  • Designed and developed a process to capture the outbound PO transactions and save them as a file to be sent to the FTP server.
Technologies: Oracle, PL/SQL, XML, Oracle E-Business Suite (EBS) R12, Oracle PL/SQL, SQL, Database Development

EBS Solution Architect

2014 - 2018
Keste
  • Guided the set up of an Approvals Management Engine (AME) for purchase requisitions when using a smart form from iProcurement. Based on the values from the smart form the requisition needed to have multiple FYI notifications sent and then be routed to multiple parallel approvers. All of the purchase requisitions needed to be routed up a management chain depending upon the dollar value of the requisition.
  • Modified a requisition approval workflow to meet business requirements.
  • Designed and developed prototype procedures to be used in the approvals manager to generate the required management chains.
  • Set up smart forms to be used as noncatalog requisition types, information captured on the smart forms determined the approval hierarchy.
Technologies: Oracle, PL/SQL, Workflow, Oracle E-Business Suite (EBS) R12, Oracle PL/SQL, SQL, Database Development

EBS Solution Architect

2014 - 2018
Keste
  • Personalized and extended an existing iProcurement OAF pages to include new business logic and the display of additional data.
  • Designed and implemented new OAF pages for iProcurement.
  • Modified a PO approval workflow to send notifications back to the original requestor.
  • Setup multiple iProcurement stores and approved supplier lists.
  • Designed and implemented a custom approval process using AME.
  • Integrated payables with Vertex (Oracle eBTax and geography setup as well as Vertex configuration).
  • Planned the migration and supported all phases of testing and production cutover.
  • Maintained design documentation, configuration documents (BR-100s, MD070s, and MD120s), and obtained client sign-offs.
Technologies: Oracle, PL/SQL, Workflow, Oracle E-Business Suite (EBS) R12, Oracle PL/SQL, SQL, Database Development

Technical Project Manager

2014 - 2018
Keste
  • Coordinated the migration of approximately 120 Oracle Forms from version 10g to 12c—utilizing both onshore and offshore resources.
  • Resolved technical issues with an Oracle Forms configuration.
  • Configured Oracle WebLogic for Forms 12c.
  • Planned out the migration.
  • Supported all phases of testing and production cutover.
  • Created weekly status reports for client and attended status meetings.
Technologies: Oracle Forms, Forms, Oracle, Oracle PL/SQL, SQL

Technical Project Manager

2007 - 2013
ABeam Consulting
  • Worked as a technical manager for the Oracle Application upgrade to R12, overseeing a team of developers migrating all existing customizations to the R12 environment. Liaised with the DBA team to manage the actual upgrade to 12.1.3.
  • Successfully completed unit testing and retrofitting all of the customizations to the R12 environment—making it ready for testing on time (including an end-to-end system test).
  • Provided expert knowledge on the Pepsi Bottling Group initiative to map their processes to Oracle AR and Advanced Collections, created and managed RICEW items. Led a team of 13 designers and developers.
  • Worked as a solution architect of the PepsiCo PeopleSoft AR conversion and migration to an existing Oracle Financials AR system; was fully responsible for all design, managed a team of designers and developers, and collaborated with business stakeholders to help define requirements.
  • Managed hands-on the project plan, requirements gathering, solution design, program development, and testing.
Technologies: Oracle, PL/SQL, EBSr12, Oracle PL/SQL, SQL

EBS Architect

2007 - 2013
ABeam Consulting
  • Upgraded standard financial modules, implementation of Order Management, Purchasing, and XML Gateway.
  • Provided technical oversight and assistance in all areas of the upgrade and implementation.
  • Architected, designed, and led the implementation of integrations from a third-party warehouse using XML messages for purchases and sales orders; this involved extending existing OAGIS XML maps and creating new maps.
  • Setup Oracle Applications to be accessible from the Internet via a DMZ and reverse proxies.
  • Assisted with the design and development of implementing order management and purchasing.
  • Designed and developed multiple customizations to OAF pages to meet business requirements.
Technologies: Oracle, XML, PL/SQL, Oracle E-Business Suite (EBS) R12, Oracle PL/SQL, SQL

Technical Architect

1995 - 2007
EDS
  • Managed onshore and offshore teams (design and development).
  • Designed and developed with Oracle SQL, PL/SQL; including performance testing.
  • Scripted Unix batch jobs to be run as part of the daily/ weekly/monthly run schedules.
  • Designed and implemented a strategy for a company split up to ensure the integrity of the database for each company.
  • Designed a data model for a supplier MDM solution.
Technologies: Oracle, PL/SQL, Oracle E-Business Suite (EBS) R12, Oracle PL/SQL, SQL

Project Manager

1989 - 1995
Allders International
  • Oversaw the development and implementation of a point-of-sale and back-office system at duty-free locations worldwide, this included airports and high-street stores.
  • Planned projects including resource allocation.
  • Performed onsite implementations.
Technologies: Database Applications, Progress 4GL, Oracle PL/SQL

Team Lead

1988 - 1989
Gresham Consulting
  • Oversaw the development and implementation of point-of-sale systems at duty-free locations in Gatwick airport, downtown Auckland, and Hawaii.
  • Developed and provided training sessions to shop and back-office staff.
Technologies: Systems, Point of Sale

Integrating Third-party Cloud Apps with the Oracle E-Business Suite

This is a presentation on how I implemented the integration between Salesforce and Oracle E-Business Suite. It highlights areas of concern, e.g., security and suggestions on how an implementation could be done.

Database Consolidation Using VPD

After acquiring multiple companies over the years, the IT department had a separate app and database tier for each acquired company's time and attendance system.

The number of companies that could be added to this model was at the limit of what the IT department could support. With a new proposed merger that would add an additional 21 divisions, a new solution was required for the time and attendance system.

As each individual time and attendance system had not diverged very much over the years, I developed a proof of concept to consolidate all of the databases into a single database using the virtual private database (VPD) technology. After extensive performance testing, this solution was adopted and additional divisions were added.

AR Statement Generation

As part of an accounts receivable implementation, we discovered that many customers needed statements in a specific format (e.g., CVS, XML, EDI, consolidated for selected locations within a group, or individual statements for each location and type of delivery method).

I redesigned the solution, developed the statement process, and reduced the run for the statement process from 30+ hours to four hours. This reduction in time was achieved by performance tuning the SQL statements and rewriting the PL/SQL to be more efficient.

Salesforce to E-Business Suite Integration

When a client reached a particular stage within the sales cycle in Salesforce, they then needed to be interfaced into Oracle E-Business Suite. Once complete, it could be maintained via either system, but any update also had to be uploaded to the other one.

Our main goals were to ensure a correct update sequence and that once updated, it did not cause the update to be sent back to the source system. For example, a Salesforce update needed to be applied to the Oracle E-Business Suite system, however, it shouldn't also double-back and attempt to update the Salesforce system. To prevent this type of double-backing of updates, I designed a solution that made sure that the updates only interfaced with the target system.

Purchase Requisitions Approvals

When a purchase requisition was created for a non-catalog item, the approval routing would be based on the information provided in the purchase requisition.

I designed and developed the procedures to be used by Oracle E-Business Suite's approval management engine (AME) to route the requisition. The routings included FYI notifications, parallel, and serial approvers; and once the requisition had been fully approved it would automatically create the purchase order.

E-Business Suite Customer Integration

After a merger, it was necessary for a list of customers to be imported into E-Business suite from an MDM solution. I designed and developed the customer import process using Oracle EBS standard trading community APIs for the initial customer load and ongoing data maintenance.

Drop Ship Order Items

Typically when a customer placed an order, some items would be sourced locally and others would be sent to a third party for shipment.

I designed and developed the solution to send the required items to the third-party supplier and receive updates on the status of the delivery. The status of the order in EBS needed to be maintained to reflect the status of the third-party delivery so that the the order could be invoiced on completion of the shipment from either the third-party supplier and/or the internal warehouse. The confirmation of the shipment by the third-party supplier would also cause an AP invoice to be created.

Languages

SQL, XML, Java

Tools

Oracle E-Business Suite (EBS) R12, Oracle ERP, Oracle E-Business Suite (EBS), Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Progress 4GL, Oracle EBS General Ledger, Oracle BI Publisher, Oracle Reports, JDeveloper, Toad, Erwin, Subversion (SVN), EBSr12, Oracle Forms, Bitbucket, Jira

Paradigms

Database Design, Database Development, Waterfall Development, Agile

Platforms

Oracle Database, Oracle, Unix, Linux, Salesforce

Storage

PL/SQL, PL/SQL Developer, Oracle PL/SQL, SQL Loader, Oracle 11g, Oracle RDBMS, SQL Performance

Other

Data, Oracle Trading Community Architecture (TCA), Collection, Accounts Receivable, Order Management, PL/SQL Tuning, Software Development Lifecycle (SDLC), Data Architecture, Data Engineering, XML Gateway, Oracle Web Applications Desktop Integrator, Cash Management, Accounts Payable, Order to Cash (O2C), Oracle iProcurement, Purchasing, Approvals Management Engine (AME), Unix Shell Scripting, Procure to Pay, Forms, Workflow, eCommerce, Database Applications, Point of Sale, Systems

Frameworks

Oracle Application Framework (OAF)

Industry Expertise

Accounting

FEBRUARY 2014 - APRIL 2017

Salesforce

Salesforce

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring