imcs
|
Inbound Material Carrier System -
Upgrade and consolidation of the planning, data input, and invoicing program for carriers Subproject 1: Carrier Application renewal Subproject 2: Datenbase re-design and data cleansing Subproject 3: Migration of the Cool:Gen modules to Java and PL/SQL |
|
| Client: |
Worldwide leading automotive company - Department "Material Planning & Logistics" (MP&L)
|
| Duration: |
October 2009 – December 2010
|
| Software: |
Linux, Windows XP, Java, Swing, IBM Websphere Server, Web-Services, IBM Rational
Application Developer, Oracle 10g, SQL, PL/SQL, SQL Navigator, ERwin, SQL-Squirrel,
Serena Version Manager |
| Description: |
IMCS is an important program for the department Incoming Material Logistics. It allows carriers
to plan their trips, to input data, and to generate invoices. The program is subject to the S-Ox
regulations and belongs to the highest requirements class regarding data integrity. The goal of this project is to upgrade and standardize the application - relative to the technologies it uses - as well as to consolidate it from the point of view of data and program quality. In the first subproject, the Carrier Application - a data input tool installed at the carriers' sites, which can be used both connected to the main database and in stand-alone mode - is migrated from MS-Access and Visual Basic to Java, Derby, and Swing. Subproject 2 comprises the creation of a data model for IMCS, cleansing the production data, and structuring and consolidating the database (by removing unused tables and fields, creating constraints, defining new tables, etc.). This phase is a prerequisite for future enhancements of the system, as well as for subproject 3. The third subproject encompasses re-writing in Java and PL/SQL the modules written in the outdated technology Cool:Gen, as well as optimizing the code. |
| Own tasks: |
|