Program Personnel Matters
Client Assiut University
Problem Accumulation of files of more than 3000 person working at the university between members of the faculty staff, employees and workers. These files occupy a large area of about 50 m2 of the tires, It might take weeks to access an information such as countless faculty stuff members who obtained a doctorate from Germany.
Solution An easy to use system interface has been designed,containing all the employees information. The people managing the system have made a great effort to introduce this large amount of data. The result was that all the employees data are now registered on an easy system, and it became so easy to access any complex information such as getting the number of employees having a certain qualification with a specific grade and had a specific job is done in seconds.
 
Program Cultural relations
Client Assiut University
Problem Accumulation of files of conferences, scientific missions and tasks of the stuff members, and the difficulty of access the data.
Solution A sestem has been designed depending on personal matters files, and addition detailed information about the conferences, scientific missions & tasks, researches and leaflets, with the ability of searching according to any specifications determined by the user.
 
Program Check ups
Client Assiut University Hospital
Problem A check up unit has been established to serve the stuff members, where the tests & medical examinations are done. These data were saved in data models designed specifically for that purpose. But doctors faced a great difficulty counting this large amount of information and using it to make their researches.
Solution A program has been designed with an easy interface to record the stuff members medical data with Smooth Statistical reports.
 
Program System of shops licensing
Client Jeddah Province Secretariat
Problem The difficulty and complexity of getting shops licenses, the municipalities are so crowded with citizens, put the employees under pressure and the possibility of losing the documents.
Solution A system has been designed works on the Internet and intranet, where the citizen can provide his application and attaching the required documents, then he can follow-up his application over the Internet. Finally he can go to the municipality to pay the fees and receive his license.
 
Program Costs accounts
Client Assiut CEMENT Company
Problem Calculating the cost of tons of cement for each type and identify the reasons of the cost increase.
Solution A system has been designed to guide the costs, then , it calculates each production stage costs till the stage of final product. Finally, extracting detailed reports for each product include the cost elements.
 
Program Sales, shipping and customer accounts
Client Assiut CEMENT Company & Misr Cement company (Qena)
Problem Methods of selling cement, as the merchant reserves an order, gets shipping bills in various categories, then he ships the cement using those bills .The problem was the possibility of authorizing shipment of more than once, and the difficulty of following-up his account and the remaining bills.
Solution A multi-user system has been designed, using the program in the sale process from beginning of reserving the order and printing the bills, then following-up the shipping, and make detailed reports on each step of the sale and shipment.