Owner
2019 - PRESENTKB 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 DevelopmentPL/SQL Developer
2018 - 2019KB 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 DevelopmentEBS Architect
2014 - 2018Keste- 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 DevelopmentOBIEE Architect
2014 - 2018Keste- 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 DevelopmentData Architect | Developer
2014 - 2018Keste- 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 DevelopmentOracle Database Architect
2014 - 2018Keste- 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 DevelopmentTechnical Project Manager
2014 - 2018Keste- 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 DevelopmentEBS Solution Architect
2014 - 2018Keste- 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 DevelopmentEBS Solution Architect
2014 - 2018Keste- 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 DevelopmentEBS Solution Architect
2014 - 2018Keste- 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 DevelopmentTechnical Project Manager
2014 - 2018Keste- 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: WebLogic, Oracle Forms, Forms, Oracle, Oracle PL/SQL, SQLTechnical Project Manager
2007 - 2013ABeam 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, SQLEBS Architect
2007 - 2013ABeam 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, SQLTechnical Architect
1995 - 2007EDS- 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, SQLProject Manager
1989 - 1995Allders 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/SQLTeam Lead
1988 - 1989Gresham 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