Design of Internet Provider E-CRM System on CV. Ahyein Pratama

CV. Ahyein Pratama Mandiri currently conducts its business activities by waiting for customers to come to the office or customers providing information about places, privileges and products to other potential customers. Inadequate reporting of customer complaints makes it difficult to know the level of customer satisfaction, causing the opportunity to get potential customers to the maximum not to be fulfilled. Dissemination of information that is not neat makes it difficult for customers to know the latest information, thus influencing customers to switch to other providers. Therefore CV. Ahyein Pratama Mandiri requires CRM (Customer Relationship Management) which is applied to the information system, where this system can facilitate CV. Ahyein Pratama Mandiri in managing services for customer satisfaction. In carrying out this research, the researcher uses a qualitative research method which is a method that discusses the problem by describing, interpreting and writing down a situation or event that will be analyzed and then draw a general conclusion from the problems discussed. As a result, the application of CRM on CV. Ahyein Pratama Mandiri can make it easier for companies to provide information to consumers, provide convenience in ordering products that can be done anytime and anywhere, and increase customer loyalty. This is an open access article under the CC BY-SA license.


INTRODUCTION
The continuous increase in economic growth leads to increasingly fierce business competition. The growth of e-commerce itself will depend heavily on an effective IT security system, where the necessary legal and technological regulations must be continuously applied and enhanced immediately [1]. An Internet Service Provider is an organization or business that connects a user's computer to an Internet computer. Indonesian ISPs are members of the Indonesian Internet Service Providers Association (APJII) [2]. In Indonesia, Jurnal Teknologi Informasi dan Pendidikan Volume 15 programming language. PHP is one of programming language that used to create webbased applications. It means that the applications can change its content under certain conditions and the applications may provide feedback to the user [12]. With this system is expected to facilitate CV. Ahyein Pratama Mandiri Air Joman in managing services for customer satisfaction. So that customers remain loyal and on the other hand also get new customers from time to time.

RESEARCH METHOD
The framework is a stage or flow that is carried out in solving problems that will be carried out in designing an Internet Provider sales application on CV. Ahyein Pratama Mandiri Air Joman using the PHP and MySQL programming languages. The stages of the framework carried out are as follows: Based on the picture of the research framework above, the research framework can be described as follows: (1) Researchers must identify problems that will be faced in the process of designing sales of Internet Providers on CV. Ahyein Pratama Mandiri Air Joman with the aim of anticipating problems that will be faced later. And the author can also immediately fix and resolve the problems at hand. (2) Data collection is the method used by the author to collect data. Data collection was carried out in order to obtain the information needed in order to achieve the research objectives. In the case of researchers collecting data by means of interviews, observations, and brochures. (3) System analysis aims to determine the application of CRM Internet Provider sales on CV. Ahyein Pratama Mandiri Air Joman. Analysis of the existing system needs to be done before analyzing the problems, system P.ISSN: 2086 -4981 E.ISSN: 2620 -6390 tip.ppj.unp.ac.id weaknesses, and system requirements. (4) System design means making a design about the system you want to make. In designing applications on CV. Ahyein Pratama Mandiri Air Joman, the researcher divides the process into several stages, namely the login display, the menu for all types of packages, and the menu for ordering. (5) Testing the system is done to find out whether the website designed is as expected, as well as re-checking for writing. In addition, to test whether there are still problems with the designed website and then fix any errors on the website. (6) After the system is tested, the next stage is the implementation of the system where this stage is the stage of implementing the system which will help reduce and eliminate existing problems. (7) The system that has been implemented the results will be used by the company employees CV. Ahyein Pratama Mandiri Air Joman in running the business.
When conducting this study, researcher used qualitative research methods. Qualitative research methods is a method of discussing a problem by describing, interpreting and writing about a situation or event to be analyzed and then drawing general conclusions from the issues discussed. This form of research is conducted through interviews or direct observations, with the aim of describing a fact or situation that exists in the place where the research is conducted.

System Design
Basically, a system is a collection of entities (hardware, brains, software) that interact, cooperate and collaborate to achieve certain goals [13]. Systems design is the stage of drawing, planning, and sketching or knowing several separate elements into a unified and functioning whole. This includes configuring the software and hardware components of the system.

Running System Flow
The system carried out on the CV. Ahyein Pratama Mandiri Air Joman is still done manually, and can be explained by the following system flow: 1. Customers come to the store to buy products. 2. Administrator/Cashier serving customers and showing all kinds of products. 3. After the customer selects the product, then the administrator / cashier immediately processes the order and makes the payment process. 4. After the payment process, the customer receives the product. Administrator/cashier makes purchase invoices that are printed in 2 copies. 5. The purchase invoice is given 1 copy to the customer and 1 copy as a left for the administrator / cashier. 6. Based on the purchase invoice, the administrator/cashier makes a sales report in 2 copies. 1 copy is given to the owner and 1 copy is handed over to the cashier to be used as an archive.

Proposed System Flow
The system that will be proposed is a design system that is Customer Relationship Management to support the realization of a new system that can advance the sales process and deliver information about the products sold by CV. Ahyein Pratama Mandiri Air Joman, in order to be able to compete in this increasingly advanced product sales business world.
The flow of the system with Customer Relationship Management can be seen in the following figure:  Pratama Mandiri Air Joman and register customer accounts on the list menu which will be automatically stored in the database. 2. Next, the customer does the login process by entering the username and password then validating the username and password to the database. 3. Next, the customer will enter the customer page view that displays all types of products. 4. The customer selects the desired product, then fills in the order form provided, after placing an order, the customer checkout and confirms the order. 5. Then the customer confirms the payment by uploading the proof of payment. 6. The admin does the login process, then checks the order and proof of payment. 7. Next, the Admin processes the delivery of the product ordered by the customer. 8. After the product is sent, the Admin prints a sales report and submits it to the owner.

Unified Modeling Language
Unified Modeling Language (UML) is a standardized language used to document, specify, and create software. UML is an object-oriented system development methodology and also a system development aid [14].

Usecase Diagram
A use case diagram represents the interactions between one or more actors and the information system being created. Use Case is an abstraction of the interaction between the system and actors. Actors in the design of the system that will be designed on the CV. Ahyein Pratama Mandiri Air Joman is described in the following table:

Class Diagram
Class diagram describes the structure of the system in order to define the classes that will be generated to create the system. Classes must have properties and object methods or operations [14]. A class diagram shows the presence or existence of classes and relationships (relationships) in the logical design of a system. All processes performed by actors on the application will be identified by the product with a class diagram. A class diagram is a chart that will show and explain the database tables and the relationships between the tables that will be used in the system. For a clearer class diagram on the system in CV. Ahyein Pratama Mandiri Air Joman is shown in Figure 5.

Result and Implementation
System requirements contain the facilities required by the system, including user interface requirements, hardware requirements and software requirements.
Users will interact with these system applications using tools such as the following: 1. Keyboard, used to enter commands into the application. 2. Mouse, used to execute commands against applications. 3. Monitor, used to view the display in the application.
The hardware requirements used in this system are a set of computers or laptops with the following specifications:   The login page is a page to clarify administrator rights to enter the processing system. Administrators with a valid username and password have access to the system through the login page.  All products page is a page that contains a list of products on the CV. Ahyein Pratama Mandiri Air Joman.

Program Testing
Results of implementation and test results is that the design system on the CV. Ahyein Pratama Mandiri Air Joman is a system that brings convenience to administrators in handling data. Consumers can also quickly select and order products. In addition, the FAQ function allows consumers to easily ask questions about products and get answers directly from customer service departments, making it easy for purchasers to obtain the information they need.

CONCLUSION
Current marketing information systems still have weaknesses, especially in the dissemination of promotional information. Using a web-based computer system, the data storage process is stored more accurately and cleanly, the process of providing advertising information is faster, and the response to sales is faster. The proposed system meets the requirements and has the advantage of being able to integrate with customer relations and marketing related systems through the implementation of e-CRM systems.