David Loop Email & Phone Number

St Louis, Missouri, United States

Dublin 2, Ie

Bellevue, Washington, Us

Bellevue, Washington, Us

Bellevue, Washington, Us

Bellevue, Washington, Us

Technical Manager providing Oracle Value Chain Planning solutions support and problem resolution to manufacturing clients. • Technical Manager of Value Chain Plus cloud based offering, providing DBA, Unix host and network support, as well as providing sizing and pricing information for prospective clients• Technical consultant to several large clients providing technical support, upgrade and problem resolution for client planning instances (all VCP applications including Demantra, ASCP, RP, and APCC)• Technical trainer for application DBAs

Chesterfield, Missouri, Us

Senior IT officer managing a staff of seven to ten IT professionals responsible in all areas of information technology for the entire corporation, including all network and communications systems, ERP and engineering support systems. Maintains yearly budgeting process and IT vision statement, reporting to corporate IT steering committee.• Lead the team that Implemented Oracle Configurator in 2005.• Lead the team that converted to Multi-Org and Implemented ASCP in 2007.• Migrated all server processes to virtual machine technology to conserver power and increase reliability using VMWare ESX.• Installed enterprise backup system with central management and tape library, replacing 12+ server centric backups.• Installed central enterprise NetApp SAN system to consolidate storage and hardware resiliency.• Installed corporate wide hybrid phone system utilizing both digital and VOIP technologies, enabling integrated inter-facility calling and remote home offices as extensions.• Upgraded equipment room power and climate control systems, including redundant air conditioning and backup generator.• Lead the team to Implement Oracle eBusiness suite in three European facilities in 2010, multi-currency, multi-lingual.• Completed Sun hardware refresh in 2010.• Implemented Oracle Mobile Supply Chain Applications in 2011 for shop floor WIP and inventory control.

Chesterfield, Missouri, Us

Primary responsibility was to upgrade Oracle eBusiness suite applications from 10.7 GUI to 11i, converting from HP UX infrastructure to Sun Solaris and upgrading the database. Led team of 11 from all functional areas of the organization to test and implement the new version. Project was completed on time and under budget.• Revised and developed project plan and task list.• Managed unit and CRP testing• Replaced custom developments with delivered functionality in 11i.• Migrated and tested 300+ custom reports and forms.• Trained users.

Chesterfield, Mo, Us

Tasked in early 2003 with the project to build a server farm and bring Applications instances in-house from the ASP. Continued to be responsible for technical/DBA duties, with a staff of two.• Team lead on daily support of Oracle Applications and other Oracle systems databases, including performance tuning, cloning and patching.• In late 2003 tested and successfully performed upgrade to 11.5.9, and over Christmas holiday moved production databases from 8.1.7.4 to 9.2.0.4.• Main point of contact for Oracle technical issues, Metalink administrator. Manage and over TARs to provide technical information for issue resolution.• Negotiated and procured servers and disk farm from Sun Microsystems, backup system from ADIC with Veritas Netbackup DataCenter, including Oracle MML.• Installed and configured server systems and disk farm.• Managed rebuilding of existing IT server room and infrastructure, including new 30 KVA UPS, 10-ton climate control system, 200KW diesel generator unit and wiring to support.• Developed and tested successful procedure to move instances from ASP in New Jersey to local site in June 2003.• Developed and maintained daily operating procedures, policies and tape retention and rotation pertaining to backup using Veritas Netbackup for Oracle.• On-going work in financial reporting, including latest BIS system. Developed data warehousing system for timely reporting of growing inventory transactions system tables.

Chesterfield, Mo, Us

Silgan uses Oracle application software hosted at an ASP. The primary packages include Oracle Financials, HRMS/Payroll w/OAB and Oracle Discrete Manufacturing w/OASCP. At that time using Application Suite version 11i.7.• Work in a project team environment with functional project managers (twelve person team). Train existing IT staff members in Oracle environment and development tools. • Responsible for all technical Oracle application and database related issues, including performance, patching and interfaces.• Primary interface between Silgan and the ASP. Brought up Oracle Financial Analyzer Current running eight separate instances of Oracle applications.• Work with third party barcode system vendor to resolve technical issues.• Implemented OBIS (Oracle Business System) for Financials, HR and MFG. Customized workbooks for OBIS to meet requirements.• Issue TARs (Technical Assistance Requests) as needed. Write scripts on UNIX.• Use Quest SQL Navigator to develop procedures, packages.• Write reports using Discoverer and Developer 6i as needed.• Develop conversions and interfaces to Inventory, HR/Payroll, and MFG, including INV Items, BOMs, routings and other objects needed for plant implementations.• Develop Workflows, both seeded and custom.• Develop FastFormulas for payroll and benefits.

Avon Lake, Oh, Us

Managed a staff of eight IS professionals responsible in all areas of information technology for the entire corporation.Personally responsible for the following:• Technical and project lead to implement Oracle Primary Financials and HRMS/Payroll, including the install, design of server systems and databases, assist in functional setup, maintenance and ongoing patching to resolve issues.• Primary technical contact with Oracle to issue TARs. Responsible for developing integrations between custom manufacturing system and Oracle Applications.• Technical architect for conversion of client-server manufacturing systems to thin client web based system on Oracle’s 9iAS application server using web based forms server and reports server through Oracle Portal using LDAP authentication.• Responsible for database administration of all Oracle systems, both in-house developed and purchased applications (Oracle DBA).• Designed, purchased and installed all Sun Microsystems enterprise systems for Oracle projects.• Preparing yearly budgets for technical projects as proposed by the technical guidance committee.• Use Quest Software’s Spotlight on Oracle (Instance Monitor) and Quest Space Manager.Managed staff and last line of support for the following areas:• Implement and maintain 48 node frame relay WAN and local switched Ethernet LAN systems, including installation and maintenance of ports – PVC’s, Cisco and 3Con router and switch equipment, and local wiring plants in the facilities.• Implement and administer Novell Netware network, including NDS directory tree and GroupWise email system.• Implement and maintain Oracle HRMS/Payroll system.

Avon Lake, Oh, Us

Assisted in the design, development and implementation of custom plastic manufacturing system using client-server technology written in C++, moving from IBM S36 to PC client-server environment.• Interfaced manufacturing system with purchased financial/payroll package (Great Plains). Directly responsible for the following modules: Order Entry, Invoicing, Scheduling and Finished Goods inventory.• Designed, developed and implemented automated time and attendance system utilizing Panasonic Panaentry electronic time clock terminals interfacing Great Plains payroll system.• Implemented network (Novell, LAN/WAN) and software (purchased and custom) systems in new plant acquisitions (approximately 35) as they were acquired.