Home :
Infinite Menus, Copyright 2006, OpenCube Inc. All Rights Reserved.

Sampling of Customers and Projects

New!  See a recent application modernization project:
Case Study: Veolia Environmental Services

                          Click a Topic when preceded by to Read the Details.
Americold Logistics
  • AmeriCold is a leading third-party provider of supply chain solutions in the consumer packaged goods industry.
  • AmeriCold is the largest provider of temperature-controlled food distribution services in the country.

(more...)

  • By managing over 4 billion pounds of freight per year, AmeriCold has the leverage to deliver superior service.
  • Our unique Multi-Vendor Consolidation (MVC) program lets you lower transportation costs and pass the savings on to your customers.
  • i-3PL centralizes information and simplifies communication to produce opportunities for cost savings throughout the supply chain.
  • AmeriCold offers significant holiday /seasonal opportunities for retailers and their suppliers to improve financial profitability.
  • AmeriCold custom designs, builds, and maintains facilities to meet your product and service requirements.
  • AmeriCold offers leading edge technology to evaluate and optimize customer supply chains to provide high-profit solutions.
LEGACY SYSTEMS MODERNIZATION:

Labor Management Tracking

The creation of a Web-based Labor Management System. Developed using ASP.NET, with Visual Basic; 2.0 .NET Framework; MS SQL Server 2003. Including the following elements:
  • Manager Home Page, Today’s snap shot
  • Manger my Staff_day Today’s info
  • Manager my Staff_week Weekly view
  • Supervisor Home Page Today’s snapshot
  • Supervisor Today’s info
  • Supervisor weekly view

Convert Legacy Device-Based WMS Screens to System I

This project converted all of the legacy device-based WMS RF application menus, displays, navigation, and validation logic to the iSeries to a strictly telnet solution. The project involved breaking up three existing RPGLE server programs into logical units and adding the appropriate screens using standard 5250 display file technology. The following modules and functions were converted.
RF Receiving Programs;
Unload/Check
Stock Inbound
Pallet Transfer
From Production
Adjust Production
RF Shipping Programs;
Order Pick
Replenishment
Check/Load
To Production
Production Return
RF Inventory Programs;
Various Inquiries
Relocate Stock
Physical Inventory
Put away Blast
Pallet X-Ref
 
Motor Coach Industries
  • Manufacturer of luxury inter-city buses.
  • Support their customers and the industry through a nationwide network of Sales, Financing, Parts and Service/Repair facilities in the US and Canada.
LEGACY SYSTEMS MODERNIZATION:

eCommerce Website - General Public

Designed, developed and implemented an IBM Websphere Commerce website to provide a seamless and completely integrated customer access portal for customer self-service order management. Credit card validation and charges are handled through the "Automated Credit Card Authorization" system listed below. Complete integration between the website and Motor Coaches' ERP includes immediate visibility and status tracking of the complete order cycle for internal personnel as well as external customers. implemented providing “zero-maintenance” concepts equates to instantaneous availability of item and order information to all parties while requiring no intermediate upload / maintenance steps by Motor Coach.

eCommerce Website - Dedicated Customer

Designed, developed and implemented an IBM Websphere Commerce website to provide a seamless and completely integrated single-customer access portal for the companies largest customer for use in the customer's service centers by the Mechanics repairing their own fleet of coaches. Using "P-Cards" - equivalent to a credit card - the Mechanics can charge inventory to specific coaches by VIN for complete history tracking. Replenishment orders from Motor Coach Industries' prime warehouses are automatically generated based on consumption in the customer's available inventory levels. "P-Card" validation and charges are handled through the "Automated Credit Card Authorization" system listed below. Complete integration between the website and Motor Coaches' ERP includes immediate visibility and status tracking of the complete order cycle for internal personnel as well as external customers. implemented providing “zero-maintenance” concepts equates to instantaneous availability of item and order information to all parties while requiring no intermediate upload / maintenance steps by Motor Coach.

Automated Credit Card Authorization

Integration of immediate online credit card and "P-Card" approvals and charges into the existing legacy ERP system running on an IBM iSeries. Shared services between the website and ERP for single-logic-services.

APlus ERP to Outsourced Logistics Company's SAP ERP

A customer had begun the process of outsourcing it's logistics operations to a third party logistics company. The base ERP was modified to send and receive inventory transaction, using WebSphere MQ, to a SAP WMS systems.
 
Utility Trailer
  • Utility will continuously improve the standard of living by being the world’s leading producer of quality, high value, light weight trailers and other transportation products and services.

(more...)

  • Utility Trailer Manufacturing Company is America’s oldest privately owned, family-operated trailer manufacturer. Founded in 1914, our company designs and manufactures dry freight vans, flatbeds, refrigerated vans, and Tautliners®, curtain-sided trailers. We are the largest producer of refrigerated vans and the third-largest trailer manufacturer in the United States.
  • Utility currently operates five trailer factories across the United States: two for refrigerated trailers located in Marion, Virginia, and Clearfield, Utah, two for dry vans located in Glade Spring, Virginia, and Paragould, Arkansas, and a flatbed and Tautliner® factory in Enterprise, Alabama. We also feature an extensive dealer network with 100 locations throughout the United States, Canada, Mexico, and South America.
  • Our historical position as America’s largest producer of refrigerated vans is a direct result of our management’s focus on providing innovative solutions to customer problems. At Utility, we have always responded to the changing needs of the market, but one thing that will never change is our dedication to providing satisfaction to each of our customers.
LEGACY SYSTEMS MODERNIZATION:

Online and Offline (Batch Data Collection)

Designed and wrote an inventory tracking system When a user is in range of the company's wireless network, the data would be collected in a traditional online fashion. When the user would travel to a remote location with no network, the application would collect and store the data until the user reconnected with the wireless network.

Dealer Quote System Migration

This project involved the migration of a Visual Basic client application to a browser based, System i hosted application. The new application was developed using BCD’s Websmart development tools. The application was designed to use a two-tiered architecture. One System i partition will run the application while another will serve the database. This is the first phase of a multiphase project that will result in a unified ERP for Utility Trailer.
 
Veolia Environmental Services (formerly Onyx)

 The four divisions of Onyx North America providing solid waste, technical solutions, industrial and waste-to-energy services, have been brought together under our shared Corporate name, Veolia Environmental Services. Our parent company, Veolia Environnement, has worked hard to establish this worldwide brand. The decision to operate globally under a single brand name reflects the guarantee of our expertise and know-how to manage both services and resources in the waste and environmental industries.
REGULATORY COMPLIANCE:

Uniform Manifest

This project was commissioned because the customer was required to comply with the new EPA Uniform Hazardous Waste Manifest rule, effective September 5, 2006. The new Uniform Manifest Form was developed for use in ALL States, eliminating all State Manifest Forms that currently exist. Shipments made prior to September 5, 2006 will be managed using current System i programs.

The project included the modification of more than 1400 objects. All programs and processes must behave exactly the same until September 5, 2006. After which, the programs must conform to the new rules. This project lasted about seven months.
 
 
 Non-Attributed to Specific Clients

 At the request of our valued clients who wish to remain un-named for competitive reasons, the following projects are listed to show the scope of services we have been providing for years without too many specifics. We would be happy to discuss in more detail verbally without breaking confidences.
LEGACY SYSTEMS MODERNIZATION:

(Advanced Inventory Management) 		Aerospace and Aircraft Hardware Testing and Distribution

Direct Stock Inventory Allocation

Hardware products (nuts, bolts, screws, o-rings, washers, etc.) for military, aerospace and aircraft use must track and report full tracability of parts beyond simple lot-level from the original manufacturer. Part of the value-add this client supplies to the industry is their QA and testing capabilities which extend to individual items within manufacturers' lots. Individual item attributes and testing results must be traceable throughout the process. The client's customers can specify the detailed attributes and requirements of the items at the time of ordering and the entire ERP must recognize and accommodate the MRP planning, identification, allocation, shipping verification, and tracking of all attributes.

Corporate Systems Interfacing

Interfaced order, commitment, shipping and invoicing systems between parent corporation systems and this division's legacy systems. Allows the parent corporation's customers to place a single order for items from multiple divisions seamlessly. Avoided the requirement for the client to replace existing system with parent company's ERP that did not support the organization nearly as well - see above item for an example of requirements not contained in parent company's systems.

Barcode System with Detailed Traceability

Complete inventory receiving through shipping barcode system. System provides all required documentation and certification to meet military specifications of testing and tracking along with producing all required barcode labels for proper item/attribute identification. Full documentation requirements are met at the time of shipping by reproducing appropriate forms (including the Inspector's and QA Management's signatures) along with packaging labels. The system then validates the items being packed for shipment meet all of the customer's requirements.

Barcoded Shop-Cart Auto Replenishment

Part-Cart remote replenishment system that allows the client's customers to use a client-supplied barcode reader to replenish shop-carts (supply carts in repair and manufacturing work centers) by scanning the item part and attribute information label inside the cart compartment and have the items replenished within 24 hours by our client. The scanned data is uploaded directly from the cart location and creates all required orders and allocations in the client's ERP automatically.

Customer MRP Output to Client MPS

Created method for transferring a customer's MRP requirements output into the client's MPS for proper planning and inventory reservation. The customer sends their inventory levels, gross, and net requirements which is confirmed prior to loading into the client's planning system to insure the two systems are properly planning all parts to pre-negotiated stocking levels at the customer site as well as available stock levels (3 months inventory) in the client's warehouse.