Publication Search

Penelitian ini bertujuan: (1) mengembangkan sistem input nilai kinerja karyawan agar lebih akurat dan efisien; (2) merancang Entity Relationship Diagram (ERD) dan struktur basis data untuk mendukung pengolahan data karyawan; serta (3) membangun backend sistem dengan autentikasi dan otorisasi berbasis peran. Ruang lingkup mencakup pengelolaan data kinerja individu yang sebelumnya dilakukan secara manual menggunakan spreadsheet dan rentan terhadap kesalahan input. Metode yang digunakan meliputi pengumpulan data kinerja kuartal kedua, perancangan ERD, serta pengembangan backend web application IHSAN POS menggunakan JavaScript dan framework Express yang terintegrasi dengan PostgreSQL, DBeaver, dan Prisma ORM. Implementasi keamanan dilakukan melalui middleware validasi input, sanitasi data, perlindungan dari serangan SQL injection dan XSS, serta pengelolaan sesi menggunakan enkripsi JWT (JSON Web Token). Sistem yang dikembangkan mencakup enam fitur terintegrasi: Halaman Login, Halaman Profil, Formulir Edit Profil, Halaman Nilai Kinerja Individu dan Kontrak Kerja, Formulir Kontrak Kerja, serta Pratinjau Surat Kontrak Kerja. Hasil pengembangan menunjukkan bahwa sistem backend yang dibangun mampu meningkatkan efisiensi proses evaluasi kinerja, memperbaiki integrasi data, serta mempermudah validasi dan pelaporan secara digital dan terstruktur. Kesimpulannya, pengembangan sistem ini memberikan kontribusi signifikan dalam peningkatan efisiensi, akurasi, dan transparansi evaluasi kinerja karyawan, serta mendukung pengambilan keputusan strategis terkait insentif dan pengembangan karier pegawai.

Usaha Mikro, Kecil, dan Menengah (UMKM) sering menghadapi tantangan dalam pengelolaan data operasional, khususnya pada aktivitas penjualan dan persediaan. UMKM Sirup Cap Manggis sebagai produsen minuman lokal masih mengandalkan pencatatan manual, yang sering menyebabkan ketidaksesuaian data stok, keterlambatan pelaporan, serta alur kerja yang kurang efisien. Kondisi tersebut menunjukkan perlunya sistem informasi terintegrasi yang mampu mendukung pengelolaan data secara akurat dan real-time. Penelitian ini bertujuan untuk merancang dan mengembangkan sistem Enterprise Resource Planning (ERP) yang berfokus pada modul penjualan dan persediaan berbasis Odoo guna meningkatkan efektivitas operasional UMKM. Penelitian ini menggunakan pendekatan penelitian terapan dengan metode Rapid Application Development (RAD) untuk mempercepat proses pengembangan sistem. Pengumpulan data dilakukan melalui wawancara dengan administrator UMKM, observasi langsung terhadap proses bisnis, serta analisis dokumentasi. Perancangan sistem didasarkan pada kebutuhan fungsional yang telah diidentifikasi, kemudian diimplementasikan menggunakan Odoo Community Edition dengan basis data PostgreSQL. Pengujian sistem dilakukan menggunakan metode black-box untuk memastikan setiap fitur berjalan sesuai dengan kebutuhan pengguna. Hasil penelitian menunjukkan bahwa sistem ERP yang dikembangkan mampu mengintegrasikan proses penjualan dan persediaan secara efektif, memungkinkan pemantauan stok secara real-time, pencatatan transaksi otomatis, serta peningkatan akurasi data. Selain itu, sistem ini terbukti meningkatkan efisiensi operasional dengan mengurangi kesalahan pencatatan manual.

Public complaint services are an essential part of public service delivery in supporting the government’s rapid response to various social issues and emergency situations. In West Tanjung Jabung Regency, public complaint services are provided through the HALO USTAD 112 Call Center managed by the Department of Communication and Informatics. However, the existing service still faces several limitations, including the lack of optimal integration in complaint data management, inadequate documentation of reports based on regional classifications, and limited capabilities in storing and retrieving complaint data. This study aims to optimize the HALO USTAD 112 Call Center service through the design of a mobile-based public complaint information system, so that the processes of receiving, managing, and monitoring reports can be carried out more effectively and in a structured manner. The system development applies the Waterfall method, which consists of requirement analysis, system design, implementation, and testing stages. The designed information system includes key features such as user and admin login, complaint submission, report management and verification, report monitoring, statistical visualization of complaint data, and regional-based report recapitulation. The application is developed using the Flutter framework with the Dart programming language, while Supabase is utilized as the backend integrated with a PostgreSQL database. The results of this study are in the form of a system design and prototype that are expected to improve the quality of public complaint services and support more accurate, integrated, and efficient data management.

Flood is a frequent natural disaster in Indonesia, often exacerbated by delays in information delivery from conventional manual monitoring systems. This study aims to design and build an automatic flood early warning system based on the Internet of Things (IoT) integrated with a web dashboard and WhatsApp notifications. The system utilizes the ESP32 microcontroller and MaxBotix MB7389 ultrasonic sensor for real-time water level data acquisition. The Research and Development (R&D) method was employed, focusing on device accuracy validation and system integration. The measured data is transmitted to a .NET-based server and stored in a PostgreSQL database. Results indicate that the system functions according to design. Sensor accuracy testing demonstrated a high degree of precision (99.12% - 100%) compared to manual measurements. Furthermore, the system successfully sends timely warning notifications via WhatsApp when water levels exceed predefined thresholds, providing a more effective solution than manual monitoring to enhance community preparedness.

In line with the rapid advancement of digital technology, the need for an efficient, integrated, and technology-based financial management system has become  critical, particularly for educational institutions such as STT-NF. The manual management of financial reports, especially cash flow statements used spreadsheets continues to pose significant challenges, including the risk of data entry errors, delayed reporting, and the lack of real-time visibility into the institution's financial condition. This study aims to develop a web application for cash flow monitoring system using the waterfall methodology to address these issues. The waterfall model was selected due to its systematic and structured approach. The system was developed using ReactJS for the frontend, NodeJS for the backend, and PostgreSQL as the database management system. To verify system functionality, testing was conducted using the black box testing method. The results of the testing indicate that all developed features of the cash flow monitoring system functioned according to the specified requirements and operated optimally. Therefore, the system is expected to provide tangible benefits in supporting the performance of the Finance Department at STT-NF as well as the foundation, by enhancing real-time financial visibility and delivering accurate information to facilitate faster & more informed decision-making.

This study is dedicated to the design and implementation of a web-based inventory management platform for PT. Paramata Baraya International. replacing the manual Excel system that is ineffective and susceptible to mistakes. The Rapid Application Development (RAD) method is chosen for its quick and iterative approach to software development. The system is built using the Next.js framework and PostgreSQL as the database, with Prisma ORM for database management. Key features include item management, real-time status tracking, calibration, maintenance, equipment rental, and automatic notifications. The implementation results show a 60% increase in item search efficiency, 95% data accuracy, and an 80% reduction in manual input errors. This study is significant as a solution for companies engaged in calibration and maintenance of measuring instruments.

This research aims to develop and implement the design and front-end transition of a web-based admin dashboard to facilitate information access and support digitalization at PT Kalbe Farma Tbk, particularly in managing the weekly production schedule. The main issue faced is that the preparation of weekly production schedules at PT Kalbe Farma Tbk is still conducted manually using paper and spreadsheets, making it prone to errors and inefficiency. Established in 1966, PT Kalbe Farma Tbk has become a leader in Indonesia's pharmaceutical industry, with a strong commitment to innovation and quality. In addressing modernization challenges, the company seeks to enhance operational efficiency through advanced technology implementation. The platform was developed using the Laravel framework and Tailwind CSS, with PostgreSQL as the database. Key features of the platform include production scheduling, approval submissions, real-time schedule adjustments, and informative data visualization. This research focuses on implementing interface design, transitions, and page routing to improve employee productivity, expedite schedule approvals by production managers, and simplify schedule adjustments by warehouse staff, while reducing errors and improving information accuracy. The methodology used in this study is Rapid Application Development (RAD), which allows for rapid and flexible development with user involvement at every stage. The research also addresses system architecture, implementation processes, and the integration of key features, as well as testing to ensure the platform is accessible across various devices and browsers. The results of this research are expected to significantly contribute to improving operational efficiency and the competitiveness of PT Kalbe Farma Tbk in the pharmaceutical industry.

Databases play an essential role in modern information systems because they enable the efficient storage, management, and retrieval of structured data. This study focuses on the implementation of a simple database using two relational database management systems (RDBMS), namely MySQL and PostgreSQL. The research stages are carried out through requirements analysis, designing entity-relationship diagrams, implementing tables and their relationships, and testing the system to assess functionality. The case study used is student data recording, where both RDBMSs are tested through a series of basic CRUD (Create, Read, Update, Delete) operations. The results show that both MySQL and PostgreSQL are capable of carrying out these operations effectively while maintaining data integrity and consistency. However, PostgreSQL offers additional advantages due to its support for more complex data types, a better level of compliance with SQL standards, and advanced features that support the needs of large-scale application development. Conversely, MySQL remains superior in terms of ease of use and application to simpler needs, making it more practical for small projects or applications with standard workloads. Based on these findings, it can be concluded that both RDBMSs are equally suitable for use, but the ideal choice depends heavily on the context of the needs; PostgreSQL is more suitable for applications that demand high scalability and size, while MySQL remains relevant for lightweight and efficient implementations.

The development of information and communication technology in Indonesia has grown significantly over the past few years. Thus, there are many opportunities to digitize the business process of a business or business ecosystem. One of them is in the field of digital economy by adapting business processes into a digital platform, such as designing an e-commerce platform in a village that has commodities in it so that related commodities can increase the visibility of their products. This research uses Belega Village as a case study location considering that this village has a commodity in the form of bamboo crafts. Research was conducted to build a web-based bamboo handicraft e-commerce application that would be expected to increase product visibility. The application itself is built using the Agile Development method using the sprint model. This application is built with a microservice architecture with Express.js technology as a backend service and Next.js to create client applications and PostgreSQL as a DBMS. The result of this research is a web-based e-commerce application that is expected to increase the visibility of products from bamboo crafts from Belega Village.

Berdasarkan hasil penelitian yang telah dilakukan CV Marecayasa Media diperoleh data bahwa yang menjadi masalah yaitu dalam proses melakukan presensi yang masih menggunakan cara manual seperti karyawan harus mengisi google form yang di buat terlebih dahulu menyebabkan seringnya terjadi manipulasi data seolah olah karyawan tersebut masuk dikarenakan sulit untuk mengenali karyawan hanya dalam bentuk namanya saja pada saat melakukan presensi.   Dari permasalahan tersebut di atas maka penulis membangun Aplikasi Presensi Berbasis Mobile Dengan Face Recognition dengan tujuan Aplikasi ini agar memudahkan karyawan dalam melakukan presensi masuk, presensi keluar, izin sakit dan izin cuti, serta membantu meminimalisir manipulasi data.   Metode penelitian yang digunakan adalah metode pengembangan perangkat lunak (Scrum) yaitu dari Analisis Kebutuhan, Product Backlog, Sprint Planning, Sprint Backlog, Sprint, Sprint Review  dan Pengujian (Testing). Untuk peracangannya pada aplikasi presensi berbasis mobile dengan face recognition  ini di bangun menggunakan Bahasa pemrorgraman Dart, dengan framework Flutter, serta untuk databasenya menggunakan Postgresql dan Backend API menggunakan baha pemrograman Golang dengan framework GO-Fiber.   Berdasarkan uji coba yang telah di lakukan menggunakan pengujian system black box rancang bangun aplikasi presensi berbasis mobile dengan face recognition berhasil di bangun dan menggunakan uat testing (User Acceptance Testing) mendapatkan presentase sekitar 95% dari aplikasi tersebut.

Internet technology is currently developing rapidly, the need for internet in the community in the current era of the COVID-19 pandemic is increasing because studying and working can be done at home. By utilizing technology, processing customer bill payment data will be faster because of the ease of use. To support the implementation of this inseparable development of Information and Technology, a website-based internet bill payment system was created with the aim of making it easier for customers to make payments and check payment history and provide convenience for the field of collection in checking accounts receivable data so that they can be followed up in accordance with standard operating procedures. applicable. So that customers feel comfortable because they don't need to be constantly reminded regarding missed payments. The design of the internet service bill payment system is described by Data Flow Diagrams (DFD) and Entity Relationship Diagrams (ERD). The design of the system prototype uses the PHP programming language and the PostgreSQL database. From this study, it was found that the website-based internet bill payment system was running well. In appearance, the website is responsive to many browsers. Meanwhile, in terms of functionality, the system can perform the functions of each feature.

Pencucian pakaian dan layanan dry cleaning, yang saat ini dapat dijalankan di rumah atau melalui bisnis yang tersedia, menjadi semakin populer. Hal ini telah menyebabkan persaingan sengit di industri ini. Untuk mengatasi persaingan ini, diperlukan usaha untuk memperkenalkan dan mempromosikan layanan pencucian pakaian dengan menggunakan metode Customer Relationship Management (CRM). Tujuan utamanya adalah menarik lebih banyak pelanggan, menjaga hubungan baik dengan pelanggan yang sudah ada, serta efektif mengelola data pelanggan dan keuangan bisnis pencucian pakaian. Penelitian ini bertujuan untuk mengembangkan sistem informasi yang menggunakan metode CRM untuk meningkatkan interaksi yang positif dan nyaman dengan pelanggan. Dalam pengembangan sistem ini, bahasa pemrograman seperti PHP dan HTML digunakan, dengan penggunaan database PostgreSQL dan framework Laravel. Hasilnya adalah sebuah sistem informasi yang kompatibel dengan penerapan metode CRM, memberikan kemudahan bagi pelanggan dalam mencari informasi tentang layanan pencucian pakaian. Saran dari penelitian ini adalah untuk terus meningkatkan penggunaan metode CRM agar interaksi dengan pelanggan dapat lebih aktif dan efektif.

Dengan perkembangan dunia IT (Information Technology) yang begitu pesat saat ini,memberikan alternatif software yang begitu banyak, terutama software database. Dengan begitu banyaknya software database, baik dari yang komersil maupun yang gratis (bebas lisensi). Dalam hal ini PostgreSQL tampil sebagai salah satu database server yang bebas lisensi, dengan berbagai macam kemampuan yang tidak kalah tangguhnya dibandingkan dengan database server yang komersil.