Article Per Year (5 Year)
p-Index From 2021 - 2026
0.408
P-Index
This Author published in this journals
All Journal Biner : Jurnal Ilmu Komputer, Teknik dan Multimedia Journal of Information Systems and Business Technology
Liestiani Hasan
Universitas Pamulang
Humanities Computer Science & IT Engineering Industrial & Manufacturing Engineering Library & Information Science Materials Science & Nanotechnology Transportation

Published : 2 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 2 Documents
Search

 1 
Rancang Bangun Sistem Informasi Penjualan Terintegrasi Customer Relationship Management (CRM) Berbasis Web dengan Metode Agile pada Optik Handayani Diki Setiawan; Liestiani Hasan
BINER : Jurnal Ilmu Komputer, Teknik dan Multimedia Vol. 4 No. 3 (2026): BINER : Jurnal Ilmu Komputer, Teknik dan Multimedia (INPRESS)
Publisher : CV. Shofanah Media Berkah

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

Optik Handayani is a business specializing in the sale of eyeglasses and contact lenses, where sales transactions, customer information, and sales reporting are still handled through manual processes. The use of these processes can reduce the efficiency of data management, increase the possibility of recording errors and data loss, and make it more difficult to prepare sales reports and manage customer relationships. This study focuses on designing and developing a web-based sales information system integrated with Customer Relationship Management (CRM) by applying the Agile method at Optik Handayani. The required data were obtained through observation, interviews, and literature reviews to determine the system requirements. The system development process followed the Agile method through five stages: planning, design, development, testing, and review. PHP was used as the programming language, with MySQL serving as the database, while Unified Modeling Language (UML) was applied to model the system design. Black Box Testing was conducted to evaluate the system functions and ensure their conformity with user requirements. The results demonstrate that the developed system can integrate the management of product information, customer data, sales transactions, memberships, vouchers, and sales reports within a single system. The implementation of the system also facilitates data management, accelerates transaction processing, improves the accuracy of sales reports, and supports CRM implementation in improving service quality and maintaining stronger relationships with customers at Optik Handayani.
Sistem Informasi Penjualan Berbasis Business Intelligence dengan Fitur Rekomendasi Promosi pada PT Bon Kreasi Indonesia Michael Todo Rafael Nainggolan; Liestiani Hasan
Journal of Information Systems and Business Technology Vol 2 No 4 (2026): Journal of Information Systems and Business Technology
Publisher : PT Jurnal Cendekia Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

This study designs and implements a Business Intelligence platform named BitesBI to address the operational challenges of PT Bon Kreasi Indonesia (Bonbonbites). The primary issues identified are product naming inconsistencies in the exported Point of Sales (POS) Olsera data—which generate dirty, unconsolidated historical data—and the absence of an analytical dashboard that forces management to determine promotion strategies based on intuition rather than empirical data. BitesBI was developed using the Rapid Application Development (RAD) method, implemented in Python 3.11 with the Flask framework. The system employs an Extract, Transform, Load (ETL) process equipped with a Mapping Alias feature to standardize Stock Keeping Unit (SKU) naming inconsistencies. Cleansed data is subsequently processed by a Rule-Based Engine to automatically generate next-period sales projection estimates (T+1) and objective promotion strategy recommendations per product. Black Box Testing validated all five functional scenarios as correct, while White Box Testing verified that the ETL pipeline and Rule-Based Engine algorithms are free from logical defects. The implementation of this system successfully transforms management's tactical decision-making process from intuition-based to fully data-driven.
Co-Authors Diki Setiawan Michael Todo Rafael Nainggolan