In this section we will give you an impression of accomplished projects in the past. The first case (CURGAS) will be presented in such way that apart from the solution, a high-level process description is given of how AIS engages with its customer when developing a solution.  This case will be analyzed according to: problem definition, inventory, design & development, and the end results.
Case 1

Problem definition
In 1995 Curgas realized that it had a problem concerning the delivery time of their products to its customers. The delivery time of the cylinders was way over 6 weeks in those days, which resulted in a big customer dislike, but also in inefficient workflows. This all resulted in a very high outlay? backlog. For the product delivery, Curgas was totally dependent on the experience of the drivers in choosing the optimal delivery-route. On the other hand the internal organization (management) was dying for information concerning financial and performance indicators and wanted to have more grip on her buyers market. A large part of the sales were 20 lbs. cylinders, which were sold by various resellers. This made the distribution complex and also pressed the revenues. The Curgas management wanted to increase the sale of larger cylinders, because of efficiency and also the difference in the margin. The margin on a small cylinder is less than on a 100 lbs. cylinder. All of this made Curgas decide that they needed to make some drastic changes if they still wanted to be competitive towards potential competitors and improve their customer service in the near future. AIS was chosen by Curgas to design, accompany and implement a solution.
Inventory
AIS started with an investigation to get a good overview of the total inventory Curgas had at that time. After the research it was clear that not all technical inventory could be used to serve the goals that were set for the future. The custom-made application from 1984 was at its end of life, considering that major changes that had to be implemented in order to reach the goals set forth by management. The existing Unix server of Curgas was in the eyes of AIS able to fulfill the need for a central point for all information flow and data within the company in the future. Curgas chose to switch to a Windows NT server for the new situation.
Design & Development
After the analysis phase, AIS and Curgas decided that the best solution for the problem, in a practical and financial way, would be an Oracle based system in combination with a Windows NT server. From this moment on the whole custom made system got the name COAS (Curgas Order Administration System). COAS has been designed and developed between 1996 and 1997 with the development tools of Oracle. For the analysis phase Designer/2000 1.6 was used, and for the implementation Forms 4.5 and Report writer 2.5.
Currently the system developed from a version 1.0 to version 1.5. The Oracle development tools used for this version are Forms 5 and Report writer 3.2. The modifications cover mainly, new requirements of the users and small changes to facilitate the processes of COAS.
Results
One condition of the project was that, both Curgas and AIS compromised that after the implementation of the system, it had to serve the future goals of Curgas. After a short period, AIS measured the system and came to the following conclusions:
· The cylinder delivery time was reduced to a maximum of 2 weeks
· All hierarchical levels in the company were able to [create] produce reports with financial and performance indicators at any time
· The most economical delivery route for the cylinders was now generated automatically
· The whole process from the problem definition till the final stage took approximately 5 months including a testing period.
· The existing open system protocol made online exchange with other applications possible, for example: banking payments
The end results that AIS achieved for Curgas were:
COST REDUCTION and CUSTOMER SATISFACTION.
In the recent years the system was further developed to keep track of the distribution from ordering until delivery. It also was enabled to prioritize Customers. Recently the application was migrated to Oracle10g Internet and updated for barcode reading and was made accessible for the end- user and the customer on internet.
Partners Involved
Oracle
Case 1

Problem definition

The pension payment administration of the customers was manual and was difficult to check on completeness and auditing the process to verify that the updates were being processed correctly, and the rules for payment of the pension were being executed to the point was a real challenge.

Solution
The application PAIS was developed by AIS using Oracle Designer6i. This was later migrated to Oracle Designer10g, Oracle Forms6i and Oracle Reports6i
The goal of the application was to handle the payment administration in an automated way according to the established laws. The administration process between SVB Aruba and the local banks regarding the payment of the customers was also automated. A special feature in this application is that changes in the local laws can be easily appended to the application.

Partners Involved
Oracle
Case 1

Problem definition
Aqualectra wanted the possibility to consolidate their critical business data on a centrally managed interconnected Storage arrays to insure continuous data availability and daily operations in the event of a server breakdown.

Solution
The implementation of the two (2) CX300 and one (1) CX500 provided the a high available infrastructure, due to its redundant internal parts, robust operating environment and the benefit to be monitored 24x7 gives Aqualectra the possibility to upgrade or service this solution while in production.

Partners involved
EMC
Case 1

Problem definition

Selikor wanted the possibility to consolidate their critical business data on a centrally managed Storage array to insure continuous data availability and daily operations in the event of a server breakdown or desktop failure.

Solution
The implementation of the CLARiiON CX3-10 provided the first step in implementing a high available infrastructure, due to its redundant internal parts, robust operating environment and the benefit to be monitored 24x7 gives Selikor the possibility to upgrade or service this solution while in production.

Partners involved
EMC
Case 1
Problem definition
Vanddis wanted to offer their (both business and private) customers a way to pay with a “gas card” issued by Vanddis. This card enables customers to purchase gas and pay periodically (bi-weekly / monthly) for their usage of gas.

Solution
AIS has assisted Vanddis in developing an application for automating the pump station operations, actually running at Vanddis NV. This application complements the control of the users on Credit limit, consumed amount, Balance, time/date of transaction, type of fuel etc. This application was developed using Oracle Database F-orms6i and Reports6i front end developing tool Oracle10g Database & Oracle10g Internet Forms and Reports

Partners involved
Oracle

Case 2

Problem definition
Vanddis was using Excel for their daily consolidation of sales and stock management. Each station was managing its own information and whenever a change needed to take place either by adding /deleting or re-pricing items, this had to be done for all stations and propagated to all days of the calendar year. Furthermore daily the totals had to be manually inserted into Vanddis' accounting system.

Solution
AIS has assisted Vanddis in developing an application “DAS” (Dailysheets Administration System), a Web based application, that would take care of assigning user types to control input, display and reporting, closing of a day and interfacing to Vanddis' accounting system. A database would be used to take care maintaining the products with their changes and the system should be tamper free. This application was developed using Oracle Database and PHP for the WEB and Database(s) Interface. Oracle10g Database was used as the Database.

Partners involved
Oracle
Case 1

Problem definition

Create an application that supports KADASTER’s core business here on Curacao.

Solution
This Government Company deals in registering the property objects viz. residential and commercial buildings, lands.  The information about the rights/ownership of the properties, mortgages on the properties and also the partners/relations of the owners is registered and this information is used against the queries from the customers that want to purchase the properties. 
The data is organized island-wide and within each island again in location and street-wide that helps the customers according to their priorities. 
AIS built the application KARES which has the functionality as to the split and join properties referenced with the rights/ownership. It has the capacity of manipulation, store and share satellite images, graphical images in the Database called Oracle Spatial. KARES was developed in Oracle Forms6i and can be executed in the Database Oracle8i and later. 

Partners Involved
Oracle
Case 1

Problem definition

The administration and distribution of the ordering and delivery process of the different kinds of liquors was not optimal. Due to this client history of ordering was not recorded, except for the holidays in December. 

Solution
AIS developed LICORES ADMIN which main functionallity is to record the distribution of liquors. By retaining the recorded distributions Licores Maduro is able to build a history of ordering information of their customers. The application further enables Licores Maduro to make several reports of this history. 

Partners involved
Oracle

© Copyright 2011 AIS N.V. All Rights Reserved.