Project Title: Digital Design Streamlines Interleasings Vehicle Leasing System Using Microsoft and Oracle Technologies

The Challenge

For many years Interleasing, owned by General Motors, has used a standalone file-based application to manage their vehicle leasing operations. These operations include car leasing (primarily to business customers, from a single car to a corporate fleet), technical service, and resolution of issues such as accidents and insurance. Interleasing's system provided a standard set of operations to maintain the company business requirements. Customer interface was provided primarily through vehicle operation control and report production.

To improve customer interactions, the leasing system was installed at a number of customer sites to unify the information process and improve data distribution between companies using email and floppy disk.

While Interleasing was successful at improving customer interaction, the increase in maintenance and data distribution was time and resource intensive; this in turn impacted service levels. To resolve the problem, Interleasing decided to implement a Web interface to the leasing system that would enable online report production and quick data transfer to the leasing operators.

The Solution

Based on Interleasing's business requirements, Digital Design created a Web interface that integrates with the present leasing system using Microsoft and Oracle technologies.
The online functionality includes:

• Detailed information browsing:
  • Vehicles;
    
  • Drivers;
    
  • Allocations.
• Report production:
  • P11D reports;
    
  • P46 (car) Vehicle Movements;
    
  • Business Mileage;
    
  • Miscellaneous expenses;
    
  • Data accuracy checking reports.
• Web transaction production:
  • Vehicle and Driver Allocations;
    
  • Driver Fines, Mileage and Contributions;
    
  • Allocation Enquiries.

All queries (viewing details of drivers, vehicles, allocations and report production) are performed online. The Interleasing customer selects the appropriate menu item, completes the information, query form, or report in the browser.

To reduce volume, all reports have a separate query form to specify what part of the information is required. In addition, all reports are produced page by page.

The Web system uses an off-line model to update data. Users do not update information in the leasing system or the Web interface database directly. These updates are performed in two stages. The first is a special off-line transaction in the legacy system database. The second is a data loop back to the Web interface database.

For administrative purposes, a Database Administrator utility has been developed. This utility manages:

• Web interface database client company schema;
  
• Data Loading Agent parameters;
  
• Leasing company operator mailing list;
  
• Security within the Web interface.

Client authorization and SSL2 encryption within the Microsoft Internet Information Server provides secure browsing. Customer privacy is also supported. A user can only access his company data set. The Web site ASP pages have restrictions to access only the current authorized user schema. To access service information, the Web site uses a special COM component.
Solution features:

• Web interface to the present file based system;
  
• Microsoft and Oracle technologies integration;
  
• SSL2 protocol.

Tools and Technologies

To integrate with the existing system, Digital Design developed a tool to be used by the Web server to upload data to the Oracle database. They also designed a tool to administer the Web interface and uploading process.

The Web implementation used Microsoft Internet Information Server 4.0 as the Web server, Active Server Page technology on the server, and JavaScript on the client side.

Digital Design created an Oracle database that includes a separate schema for each customer as well as data and a set of PL/SQL procedures to manage complex queries.

The solution was developed using the following tools:

• Microsoft Visual Basic 6.0;
  
• Microsoft Visual Interdev 6.0;
  
• Microsoft Visual SourceSafe 6.0;
  
• Platinum Erwin 3.5.2;
  
• Visio 5.0.

The solution used the following technologies:

• Microsoft Active Server Page (ASP);
  
• Secure Socket Layer Protocol (SSL2);
  
• Microsoft OLE DB;
  
• Oracle PL/SQL;
  
• Java Script.

Post Your Story, Tell All About Your Success!

If you want the story of your company to appear on the portal please fill out this form and send it to [email protected]. We would also like you to leave contact information (name, e-mail, phone) of a person who is responsible for filling the form to clarify any questions, which could appear.

Available Success Stories From Companies:

Disclaimer

All information contained in this Section is owned by RUSSOFT.org and its Participants and is protected by Russian and international copyright laws. Any reproduction or republication of all or part of this Section has to remain intact and include a notice on the copyright of RUSSOFT.org or the Participants, as applicable.

While the information of this Section has been presented with all due care, RUSSOFT.org does not warrant the accuracy, completeness, usefulness and truth of Section’s information, links and logos derived from third parties. RUSSOFT.org is not liable for any loss or damage occurring from the use of this Section’s materials.