Fernandi Wijaya, Santo
Unknown Affiliation

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

Found 2 Documents
Search

Android-based Mobile Application with Rapid Application Development model for Village Administration Services Johan, Fanny; Jansen Wiratama; Sunardi Oetama, Raymond; Ady Sanjaya, Samuel; Fernandi Wijaya, Santo; Sony Eko Nugroho, Antonius
The Indonesian Journal of Computer Science Vol. 12 No. 5 (2023): The Indonesian Journal of Computer Science (IJCS)
Publisher : AI Society & STMIK Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33022/ijcs.v12i5.3407

Abstract

Village administration services are essential in a village's progress and villagers' satisfaction with village officials. There are many villages in Indonesia where services still need to be more optimal because they have limitations in disseminating information, unclear procedures, and the status of service applications that cannot be monitored. Mobile-based applications can optimize village administration services, which can bridge between villagers and village officials. From the results of several previous studies, the Rapid Application Development (RAD) model is relevant to be applied in designing Android-based village service applications with the Flutter framework. The SHA-512 algorithm is implemented to increase security by hashing passwords to strengthen database security in village service applications. The application produced in this research has been tested using the User Acceptance Test (UAT) method, and it was concluded that this system is suitable for use by villagers and improves Cihuni village services.
Sales Analysis on Garment Industry with Datawarehouse and ETL Implementation on Star Schema Tan, Dasmond; Wiratama, Jansen; Fernandi Wijaya, Santo
The Indonesian Journal of Computer Science Vol. 13 No. 1 (2024): The Indonesian Journal of Computer Science (IJCS)
Publisher : AI Society & STMIK Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33022/ijcs.v13i1.3770

Abstract

In the current industrial era, clothing companies face increasingly complex challenges in maintaining the quality and sales of their products. To overcome these obstacles, companies must have a good vision, mission, and decision-making capabilities supported by efficient data management. Data is becoming a valuable asset in Industry 4.0, pivotal in process management, increased productivity, and competitive advantage. This research explores the implementation of Data Warehouse (data warehouse) and ETL (Extraction, Transformation, and Load) processes on star schema for PT Golden Flower Tbk. A data warehouse is a container for storing company data, supporting decision-making, and providing business insights. Meanwhile, the ETL process ensures that the data entered into the warehouse is clean, structured, and ready for analysis. PTA garment manufacturing and exporter company, USPT Golden Flower Tbk, uses the Pentaho application to carry out the ETL process. Pentaho, a Business Intelligence tool, facilitates easy data processing and analysis. This research also explains the use of dimension tables and fact tables in star schemas, which form the basis for more in-depth data analysis. Through visualization and analysis using star schema, Mondrian, and schema workbench, companies can identify sales patterns in each branch and understand which products are most in demand by consumers. The results of the star schema, moMondrianand schema workbench provide a better understanding of the company's sales performance, enabling more informed decision-making and more effective strategies.