1. Capital Program Management

Business Problem:

A Class I railroad has 14 maintenance plants across the US where locomotives and passenger cars are repaired and maintained. Included in these are 4-5 major facilities that do Capital Improvements on the rolling stock, including complete overhauls. The Procurement Department prepares its capital funding requirements annually.

Procurement had no automated tools to evaluate the Planned Production Schedules from the Engineering Systems and compile capital purchase requirements. Inventory Planners spent months meeting with directors of the major facilities to obtain capital work projections and corresponding material requirements. The requirements were manually analyzed to create purchase orders to suppliers.

Solution:

Dumas Software automated the entire process by developing a Web Application that imports Planned Bills of Material from the Engineering System and ultimately translates the material requirements into Supplier Orders for the ERP (Enterprise Resource Planning system). The tool applies the plant schedules, sums all locations, evaluates existing inventory levels and calculates the material to be purchased. Extensive management analysis and reporting is included to facilitate annual funding requests to the FRA (Federal Railroad Administration.) The Capital Program analysis process was reduced from many months to a matter of weeks.

2. Inventory Material Photos

Business Problem:

A customer with warehouses and maintenance facilities coast to coast needed to reduce the time required to accurately identify a part. Incorrect parts were being pulled for maintenance work, resulting in costly delays and part returns.

While electronic order fulfillment and catalogs were in use, shop clerks still struggled to identify the right part by item number, text description, and schematics.

Solution:

Dumas Software designed a web application where photos of parts are captured upon receipt or via exception reports. Each photo is linked to the unique part number in the ERP and the electronic catalog, and a watermark of the ID is applied to the image. Images are available across the enterprise immediately, allowing all locations to verify that work orders are being fulfilled with the right part, the first time. To date, warehouse personnel have captured more than 20,000 photos and part returns have been dramatically reduced.

3. Web-based Material Request/Purchase Order approval

Business Problem:

An international manufacturing company with many locations was using a mainframe legacy VSAM ERP system. Approving managers in the United States, Europe, and Mexico required an easy way to review and approve Material Requests and Purchase Orders from their desktops and handheld devices, without the hassle of obtaining access to the legacy system.

Solution:

Dumas Software designed and implemented Web based software that works directly with the mainframe VSAM database without the expense and overhead of third-party middleware. Screens have a bilingual option, Spanish or English. The Web interface allows managers to easily review, add, change, or delete MR’s and PO’s via a web browser. The application also includes e-mail notification to managers. The email includes hyperlinks allowing them to approve or deny PO’s with one click.

4. Supply Chain Business Analysis – European High Speed Rail

Business Problem:

A European railroad was upgrading and modernizing 400 miles of rail and stations to accommodate high speed trains. The existing supply chain process was fragmented, with most of the responsibility delegated to installation contractors. The railroad needed someone to analyze the supply chain, identify problems and opportunities, and make recommendations to streamline and manage the process.

Solution:

Dumas Software interviewed program stakeholders to document existing information flows and business systems in use. Four major problems were identified and Dumas developed a plan for incremental process improvement that provided immediate benefit with minimal risk or up-front investment. The plan allowed the railroad to identify capacity constraints with suppliers, initiate volume buying and improve the efficiency of the supply chain.

Technology Used

Systems: .Net and Java Web technology, Crystal Reports, IBM CICS mainframe technology.
Databases: SQL Server, Oracle, DB2, VSAM, AS400.
Integration: XML, SOAP, RFC, Web Services, IBI iWay, DB2 Connect, FTP, EDI.