Career Overview

Over fifteen years of experience in several large corporate information service environments, encompassing all aspects of the system development life cycle. Mr. Rose has designed, developed, implemented and maintained several large sophisticated manufacturing, financial, e-commerce and HR Applications in numerous industries. He has an extensive technical as well as a functional background with the unique ability to develop strong client partnerships.

Education:

B.S., Computer Science

Summary of Experience:

• Fifteen plus years experience in design and development of data base applications using Oracle tools.
• Significant experience using Oracle Applications version 9.5 - 12.1
• Extensive experience in system integration between Oracle Financials and third-party products.
• Extensive experience leading projects from conception through implementation.
• Strong cross platform expertise.
• Extensive experience in e-Commerce Gateway, XML Gateway, Payables, Purchasing, Oracle Workflow, XML Designer, BPEL Process Manager, Procure-to-Pay, Order-to-Cash, Cash Management, Manufacturing, and Human Resources, Workflow.
• Designed and implemented bar-code standards for the Ag Chemical Industry.

Experience:

Consultant, 1997 to Present.

Confidential - Configured, mapped and implemented the outbound 810 transaction in a managed serviced approach. Responsible for the mapping of XML and EDI invoices to support the business requirements.

Confidential - Completed the configuration of the e-Commerce Gateway in a very customized environment. Transactions included 810, 850, 855, 856, 820 & 997.

Confidential - Developed custom integration between Oracle Apps and ADP for electronic payment and check generation.

Confidential - Implemented and configured the XML Gateway to support the production and consumption
of valid, well-formed XML messages between Oracle e-Business Suite and the client' s trading partners. Utilized the XML Designer to accurately format messages to support the integration. Complete implementation supporting the OAG format for all inbound and outbound messages. Implemented the e-Commerce Gateway to support standard and custom transactions. Implement Oracle WMS functionality and develop integration between Oracle Application and shop floor systems using Clear Orbit - CLM. Conversion of routings, and BOMS. On Hand Balance conversion. Inventory conversion including customer items and customer item cross reference. Provided quality support for Purchasing and Accounts Payable.

Confidential - Implemented the 810 inbound invoice and the 820 outbound payment for most supplier payments and all employees expense reimbursement.

Confidential - Implemented and configured Oracle Cash Management in a highly customized environment. This included, but was not limited to the design and development of interface program, end user training and application setup.

Confidential - Technical lead for the implementation of Order Management, Advance Pricing, Inventory, WIP, BOM and the e-Commerce Gateway (855, 856, 810, 850, 860, 865). Documented, developed, tested and implemented all conversion program for the above modules. Worked extensively with off-shore contractors and the design of additional custom work.

Confidential - Technical lead on an Oracle Human Resources (HRMS) and Oracle Advance Benefits (OAB) implementation. Duties include but not limited to the conversion of employee data and employee benefits as well as the development of several custom Oracle Discover reports, Oracle Alerts, project management / administration.

Confidential(Jamaica) - System Administration and pre upgrade evaluation. Documented all interfaces used to support an extensively customized 10.7 character installation and assisted with the installation and upgrade of the database and application.

Confidential - Implemented and configured the e-Commerce Gateway in an Oracle ii1 environment to support several transactions including outbound 820, 824, 827, 850 and 860. Developed extensive custom code to support electronic payment for global suppliers and all employee reimbursement. The customization supported numerous banking formats and multiple languages.

Confidential - Assisted with the development of outbound interface and the implementation and configuration of the Oracle e-Commerce Gateway for inbound 850 and inbound 856 documents.

Confidential (Canada) - Implemented the Oracle e-Commerce Gateway in an R11i environment to support numerous standard and non-standard transactions. Developed several conversion and interface programs using packages, procedures, and triggers to satisfy the client unique business requirements. Worked closely with Oracle Development for future enhancements to the current e-Commerce Gateway. Worked extensively with the configuration and Oracle Order Management and Oracle advance pricing. Developed conversion documents and programs to facilitate the conversion of existing order from a legacy system to Oracle Order Management.

Confidential - Assisted with the implementation of the Oracle e-Commerce Gateway in an R11i environment to support numerous inbound (810,850) and outbound (810, 820, 832, 850, 856, 860) transactions. Instructed the client on new features and functionality available in the e-Commerce Gateway. Developed specifications to support a custom inbound (832) transaction. Worked closely with Oracle Development for future enhancements to the current e-Commerce Gateway.

Confidential - Developed several custom EDI transactions for a major manufacturing organization utilizing Oracle version 10.7. Developed extension to the core financial and manufacturing package including DB triggers, packages and procedures.

Confidential - Designed, developed and implemented an outbound ADP interface from Oracle Payables and Oracle HRMS R11i as well as inbound interface to Oracle GL.

Confidential - Technical Lead on a fast forward implementation. Developed the HR/ADP Interface for Release 11.02; assisted in the design and development of a Shop Floor Control System using barcodes. Custom forms and reports from Inventory, WIP and BOM, UNIX System Administration, Oracle System Administration and DBA responsibilities. Converted open AR invoices and open orders from the client' s legacy system to Oracle AR and Oracle OE. Developed numerous database trigger and procedures. Designed, developed and implemented a custom. Developed custom code to support the integration of Oracle Payable and numerous banking formats to facilitate electronic payment of supplier invoice and employees expense reimbursements.

Confidential - Primary responsibilities included the conversion of data including suppliers, employees and tax codes from a legacy application as well as the development of an invoice interface between the client' s Oracle AP Application and external suppliers. Developed an interface between Oracle Payable and Bottomline to facilitate electronic payment of supplier invoices and employee expense reimbursements.

Confidential- Purchasing lead for the international multi-currency implementation of Oracle Government Purchasing version 10.7 SC. Interviewed employees to gain knowledge of the current system and gather requirements. Worked closely with the Accounts Payable team. Developed conversion programs to load Oracle Purchasing, Accounts Payable and Accounts Receivables from the legacy application.

Confidential (Germany) - Developed, tested and implemented custom code to convert purchase orders from a legacy application to Oracle Purchasing in a localized install of Oracle Applications version 10.6. Assisted with the conversion of items and development of interfaces between Oracle AP and a legacy GL Application.

Confidential- Developed, tested and implemented numerous interface processes from an existing legacy system into Oracle Manufacturing version 10.5. This included Items, BOM, categories and routings.

Successfully completed Oracle Manufacturing training program. This included AIM 2.0, Inventory, Bill of Material, Engineering, Cost Management, Master Scheduling/MRP, Purchasing, Work in Process and Order Entry. Provided technical and practical assistance to other students during this extensive seven-week training program.

Senior Technical Specialist, Confidential, 1991 to 1997.
Analyzed, modeled, developed and implemented a UNIX/Oracle based product tracking application utilizing Developer/2000, radio frequency and bar code technology. Assisted in the development and system integration of several PLC' s on a production line requiring a print and apply bar code application. Additional duties included co-development of bar coding standards for the Agricultural Chemical Industry as well as developing and implementing numerous interfaces between Oracle applications with PLCs, scales, controllers and external systems.

Additional responsibilities included the development and maintenance of numerous systems and application programs utilized in the company' s daily operation. Maintenance of a HP3000 Oracle forecasting application utilizing SQL*Forms and SQL*Menu. Analyzed, modeled, designed, developed and documented an Emergency Response System. Provided continuous quality support by performing the required maintenance and enhancements requested in a timely method.

Also traveled to various sites through the country to install and train production facilities on radio frequency and bar code technology. All work performed utilizing Oracle version 6 and 7 relational database and SQL tools in a UNIX and/or HP3000 operating system environment.

Designed, developed and implemented several applications using Powerhouse in a HP3000 environment.

Enhanced and maintained Material Management (MM/3000) and its interfaces with Arizona Industrial Management Systems (AIMS) purchasing and accounting applications.

Supervised six employees and numerous consultants during the development life cycle.

Account management responsibilities for internal clients.

Programmer Analyst, Confidential, 1988 to 1991.
Responsibilities consisted of all aspects of HPPO and MM3000 software packages. This included all administration, enhancements as well as all client support at corporate and production facilities. Developed and implemented security procedures and policies for the HP3000. In addition was involved in all development and maintenance of in-house created accounts payable system. Responsible for traveling to various plants throughout the country updating applications that entailed rewriting existing systems to meet corporate standards. Additional duties involved coordinating all data communication for the key remote facilities concerning Purchasing, Accounts Payable and Manufacturing systems. Computer Room Supervision.

Programmer, Confidential, 1986 to 1988.
Responsibilities encompassed the design and implementation of the following systems: List Rental, Merge/Purge and Zip correction for a large direct mail company. Additional duties included converting custom tapes to be used for in-house reporting. All programming was accomplished in COBOL on the HP3000 series 58 utilizing KSAM files running under MPE V operating system.

Hardware: HP9000, HP3000, HP1000, IBM PC/XT/AT, Numerous Intermec Equipment, IBM 4341
Software: PL*SQL, SQL*Plus, SQL*Forms 3.0,SQL*Loader, XML, JAVA, Shell scripting, Oracle Forms 4.5, SQL*Forms 2.3, SQL, SQL*Menu 5.0, SQR, Shell scripting, PC-IRL, COBOL, Query, Powerhouse, BRW, View/3000, PROTOS.
Data Bases: Oracle V8, V7 & V6, IMAGE, MSAccess, Paradox.
OperatingSystems: HP-UX, SCO-UNIX, MPE-IX, MPE-XL, MPE, Windows 3.1, Windows 95, DOS.
Applications: Oracle Manufacturing / Financials Versions 10.7SC, 11i, 12; MM/3000, MNT/3000, HPPO, AIMS.
Miscellaneous: ERWin, Reflections, Loftware, MPEX, Security/3000, Gentran, MSWord, MSProject, MSPowerpoint, MSExcel, Lotus.
Training: System Administration and Customization, Oracle e-Commerce Gateway, XML Gateway, Oracle Discoverer, AIM Methodology, Oracle Accounts Payable, Oracle Receivables, Oracle Workflow, Oracle Purchasing, Oracle Order Management, Oracle Order Entry, Oracle Human Resources. Oracle Payroll, Oracle Advance Benefits, Oracle WMS, Clear Orbit.

Professional

Affiliations: Pursuing APICS CPIM Certification.