Ibnu Gunawan

The Implementation of Customer Relationship Management: Case Study from the Indonesia Retail Industry

PD.Cemara Sewu is a company engaged in distributor and selling photography product. Nowadays, system of sales and storage of goods still be done manually. So, company needs a system in order to improve good relationship with customers, and storage goods could be more effective and efficient. In this research, the application process begins with the design to the implementation of the system. Designs are made include the manufacture of DFD and ERD. Application of Electronic Customer Relationship Management that have been implemented to make the buying and storage of goods in PD. Cemara Sewu become more organized, well-structured and have relationship with customers. The application of this system has been created with features that have been planned and tailored to the needs of previously so customer have loyalty to company and reports of sales, card stock and forecasting from the application are accurately, because have the same result with manual calculations. Based on the evaluation, 85% of users said that the features in the application made is considered good and in accordance with company needs.

Securing Client-Server Application Design for Information System Inventory

This paper will discuss how to design a client server application for the building supply store located at 3 different locations along with the networking system design as well as how to secure it. Santoso Building Stores is a company engaged in the sale of construction materials. The current system for the inventory in the store is still done manually, making frequent errors in the data and the resulting delay in presenting information. Based on these problems, the company needed a system to record the inventory through purchase and sale transactions, so that the report can be presented quickly. In order to meet these needs, it developed an application to support the activities of the company so that all inventory record scan be performed quickly and report scan also be presented in real time. Applications are developed using Microsoft Visual Basic 2010 and SQL Server 2008 R2 includes SQL Encryption feature. The experiments results showed that the application was able to meet the needs of the company, inventory system that is accurate, fast and safe.

Varnish Web Cache Application Evaluation

Websites today have static and dynamic contents that concern many people about the performance. People will leave or not returning the website because of loading time that is taking too long. One way to speed up a website access is by utilising web applications using Varnish cache. Varnish will store static content from a website in the memory. Static data is data that changes infrequently or rarely updated. A front end for web administrators was built for Varnish application so that the configuration can be done easily. The configuration that will be simplified through the front end of this Varnish application is detecting SQL injection and Cross Site Scripting (XSS), block files and folders, HTTP header manipulation, detects the original file whether it is deleted or blocked and error handling configuration. The front end application is implemented on Linux platform. Varnish application was tested using ApacheBench where the number of requests from the client and the response time become the main parameters of the test.