Keith Ewen, PL/SQL Tuning Developer in Davenport, FL, United States
Keith Ewen

PL/SQL Tuning Developer in Davenport, FL, United States

Member since February 16, 2019
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.
Keith is now available for hire

Portfolio

Experience

Location

Davenport, FL, United States

Availability

Part-time

Preferred Environment

Unix, Oracle Database, PL/SQL, SVN

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.

Employment

  • 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: EBS R12.1.3, PL/SQL, SQL
  • 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: EBS R12.1, PL/SQL, Salesforce
  • 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: OBIEE 11g
  • 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: eCommerce Website, Oracle Database, PL/SQL, Agile
  • 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 Database, Virtual Private Database (VPD)
  • 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: OBIEE
  • 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: EBS 12.1, XML Gateway, PL/SQL
  • 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: EBS R12.2, Workflow, PL/SQL
  • 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: EBS R12.2.4, OA Framework, Workflow, PL/SQL
  • 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 10g, Oracle Forms 12c, WebLogic
  • 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: EBS R12.1.3, PL/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: EBS R12.1, PL/SQL, XML Gateway, OA Framework
  • 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: EBS 10.7 to 11i, PL/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: Progress 4GL, Database
  • 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: Point of Sale, Back Office Systems

Experience

  • Integrating Third-party Cloud Apps with the Oracle E-Business Suite (Development)
    https://www.slideshare.net/slideshow/embed_code/key/1ckd4OVHwR8RAJ

    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 (Development)

    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 (Development)

    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 (Development)

    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 (Development)

    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 (Development)

    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 (Development)

    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.

Skills

  • Languages

    SQL, Java
  • Tools

    Oracle ERP, Oracle E-Business Suite (EBS), Oracle EBS General Ledger, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle BI Publisher, Oracle Reports, JDeveloper, Toad, Erwin
  • Paradigms

    Waterfall Development, Agile
  • Storage

    PL/SQL, PL/SQL Developer, Oracle PL/SQL, SQL Loader, Oracle 11g, Oracle DBMS, SQL Performance
  • Other

    Oracle Trading Community Architecture (TCA), Collections, Accounts Receivable, Order Management, PL/SQL Tuning, Software Development Lifecycle (SDLC), XML Gateway, Workflows, Oracle Web Applications Desktop Integrator, Cash Management, Accounts Payable, Accounting, Order to Cash, Oracle iProcurement, Purchasing, Approvals Management Engine (AME), Unix Shell Scripting, Procure to Pay
  • Frameworks

    Oracle Application Framework (OAF)
  • Platforms

    Unix, Linux, Oracle
Certifications
  • Salesforce
    FEBRUARY 2014 - APRIL 2017
    Salesforce

To view more profiles

Join Toptal
Share it with others