US Postal Service
G&E Systems recently completed the design for reengineering the United States Postal Services' main productivity measurement system. Two systems were reengineered simultaneously - a twenty-five year old mainframe system and a somewhat similar PC version. Harmonizing the data structures of the two systems was challenging. The mainframe used sequential files (on tape for all data more than a week old). The PC version utilized Btrieve, Paradox, ISAM and sequential files with radically different architectures. The reengineering target was a geographically distributed Oracle database. The reengineered system was designed to provide users with all the facilities available on the mainframe, but with a powerful, flexible, user-friendly Windows GUI. The reengineered system will be a fully client/server structured system with distributed ORACLE7 databases resident at the 85 districts, replicating automatically to a national database.
Polaroid Tektronix to PC Reengineering
Early in 1994, G&E Systems constructed a PC/LAN based system for replacing manual data entry into fifteen year old Tektronix equipment. The new system facilitates manual data entry into a relational database on a PC (in this case the database is Microsoft Access). With the application system provided by G&E, other PCs connected to the LAN at Polaroid's Norwood complex can access that database , "at the push of a button," to retrieve and display that data in graphs and tables. On one page, the system summarizes 25 days of production in a table along with three charts that graphically synopsize the data. At the push of another button, the operator can automatically print a similar page of data for all performance parameters in the database.
After creating a new, reengineered, system for Polaroid's manually recorded data, G&E devised a procedure for removing data from the obsolete Tektronix equipment. This was no simple task, because the Tektronix media were so old that they were physically incompatible with any modern equipment -- for example, the data was stored on eight inch floppies. This system was fully documented for operation by Polaroid employees. Training was provided to Polaroid employees so that they could utilize the system effectively.
Polaroid VAX RDB to PC Reengineering
In late 1993, G&E Systems constructed a system to allow PCs attached to the LAN at the Polaroid's Norwood complex to flexibly retrieve and display data stored in a relational database on a VAX server (in this case DEC's RDB). This outputs for this system are similar to the above in that the PCs can access the database , "at the push of a button," to retrieve and display data in graphs and tables. On one page, the system summarizes 25 days of production in a table along with three charts that graphically synopsize the data. Data can easily be selected by date range, time of day, type of data, etc. At the push of another button, the operator can automatically print a similar page of data for all performance parameters in the database.
BayBank Mortgage Backed Securities Analysis
In 1996, G&E Systems reengineered the system used by the merged Bank of Boston/BayBank mortgage companies to construct mortgage rates and publish them to branches and the outside sales force. The mortgage system evaluates selling prices in the secondary market to set points and to indicate how to adjust points to raise or lower interest rates. The system computes initial payments and Annual Percentage Rates (APR) on all mortgage types to satisfy disclosure laws. By replacing many steps with one process, the daily time needed to construct and distribute the mortgage rate sheet was cut from four hours to 45 minutes.
G&E constructed a mortgage backed securities analysis system for BayBank in 1995. The system helps the BayBank Mortgage Company bundle individual mortgages into groups eligible for sale in the secondary market. The analysis section determines the most profitable route for selling the mortgage backed securities, whether through FNMA "Fannie Mae", FHLMC "Freddie Mac", Merrill Lynch, etc.
|
|
|
|
|
|
|
|
|
|
For more information E-Mail or contact us at
G & E Systems, Inc.
250 Edge Hill Road, Sharon, MA 02067-1017
(781) 784-1007 (Voice) (781) 784-1737 (Fax)