DESIGN AND DEVELOPMENT OF WEB-BASED CRM (CUSTOMER RELATIONSHIP MANAGEMENT) SYSTEM WITH MVC PATTERN
The reflexology business competition, especially in Pontianak City is increasing. Therefore, a new strategy is needed to assist companies within managing customer relationships, so that they can increase customer loyalty and retain existing customers. One of the business strategies that can help manage customer relationships is using CRM technology. CEO Reflexology is one of the MSMEs located in Pontianak City who will implement CRM technology. The purpose of this research is to built a web-based system using the MVC pattern by implementing CRM as a marketing tool. The CRM features that will be implemented are SMS Marketing as a marketing tool to promote and provide the latest information related to product using the SMS Gateway API and the customer segmentation to group customers using the K-Means Clustering method based on the customer's RFM model. The results of the CRM implementation in this research were customer segmentation by obtaining 3 customer groups based on the level of customer loyalty and the results of the SMS gateway API implementation on the SMS Marketing feature successfully sent to the recipient. The results of this research is a customer relationship management system that has been functionally tested and obtained results in accordance with the functional design of the system. Meanwhile, the interface testing for the general public received a very good predicate with a percentage of 87.37%.
 Hidayat, A., & Surarso, B., 2012, Penerapan Arsitektur Model View Controller (MVC) dalam Rancang Bangun Sistem Kuis Online Adaptif, Seminar Nasional Teknologi
Informasi dan Komunikasi 2012 (SENTIKA), pp. 57-64, Yogyakarta.
 Nurhayati, Leni, 2019, Rancangan Aplikasi Customer Relationship Management pada UKM (Studi Kasus CV. AlBaru)., Jurnal Informan’s, vol. 13, no.1, pp. 43-57.
 Son, Andrees., 2012, Penerapan SMS Gateway Sebagai Customer Touching Application Untuk Melayani Kebutuhan Informasi Pelanggan Pada PT. Sukses Gemilang
Jaya Abadi, Jurnal Expert, vol. 2, no. 2, pp. 62-65.
 Khusna, Arfiani N., 2016, Penerapan Customer Relationship Management (CRM) Berbasis SMS Gateway Pada Online Shop Tokofarah, Jurnal Telematika, vol. 13, no.
01, pp. 40-45.
 Hevner, A. R., March, S. T., Park, J., & Ram, S., 2004, Design Science In Information Systems Research, MIS Quarterly, vol. 28, no. 1, pp. 75-105.
 Buttle, F., 2007, Customer Relationship Management : Concepts and Tools, Elsevier Publishing.
 Kalakota, D., & Robinson, M., 2001, e-Business 2.0 : Roadmap for Success, Addison-Wesley, US.
 Srivastava, J., Lim, E.-P., Wang, J.-H., & Hwang, S.-Y .,2002, A Case for Analytical Customer Relationship Management, Springer-Verlag Berlin Heidelberg, pp. 14-27.
 SendPulse Inc., What is SMS Marketing: Definition and Guide Application Software, 30 Maret 2020, Available: https://sendpulse.com/support/glossary/bulk-sms-
marketing, Accessed 25 Maret 2021.
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
JATIS oleh http://jurnal.mdp.ac.id/index.php/jatisi disebarluaskan di bawah Lisensi Creative Commons Atribusi-BerbagiSerupa 4.0 Internasional.