Claim Missing Document
Check
Articles

Found 3 Documents
Search

Implementation of a Gemini Api-Based Chatbot Integrated with Mysql Database for Social Security Service Nandito Ananda Ginting; Muhammad Irvi Hafizi Manullang; Yasir Riady; Habieb Pahlevi
Journal of Sustainable Software Engineering and Information Systems Vol. 1 No. 1 (2025): Journal of Sustainable Software Engineering and Information Systems
Publisher : CV Media Inti Teknologi

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.58723/jsseis.v1i1.70

Abstract

Background of study: The increasing demand for intelligent and responsive digital services in the public sector has encouraged government institutions to integrate artificial intelligence into their service systems. Social security agencies in Indonesia require an innovative solution to deliver faster, more accurate, and accessible information to citizens. Aims and Scope of Paper: This study aims to design and implement a Gemini API-based chatbot integrated with a MySQL database to enhance social security services through natural and interactive communication. The chatbot was developed during an internship program at the Social Security Office (BPJS Ketenagakerjaan) Medan Kota branch. Methods: The system was developed using Natural Language Processing (NLP) capabilities of the Gemini API to process user input and retrieve structured data from a MySQL database. An admin dashboard was built with the Laravel framework to manage PDF uploads, perform text extraction, and handle user queries in real time. Result: Testing showed that the chatbot could effectively respond to general and data-driven queries, extract and analyze uploaded documents, and improve response time compared to traditional service channels. The integration of Gemini API and MySQL ensures scalability, accuracy, and secure data management. Conclusion: The implementation of a Gemini API-based chatbot integrated with a MySQL database demonstrates how AI-driven conversational systems can modernize public services. It enhances operational efficiency, accessibility, and user satisfaction, supporting the digital transformation of social welfare institutions in Indonesia.
Implementation of a Gemini Api-Based Chatbot Integrated with Mysql Database for Social Security Service Nandito Ananda Ginting; Muhammad Irvi Hafizi Manullang; Yasir Riady; Habieb Pahlevi
Journal of Sustainable Software Engineering and Information Systems Vol. 1 No. 1 (2025): Journal of Sustainable Software Engineering and Information Systems
Publisher : CV Media Inti Teknologi

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.58723/jsseis.v1i1.70

Abstract

Background of study: The increasing demand for intelligent and responsive digital services in the public sector has encouraged government institutions to integrate artificial intelligence into their service systems. Social security agencies in Indonesia require an innovative solution to deliver faster, more accurate, and accessible information to citizens. Aims and Scope of Paper: This study aims to design and implement a Gemini API-based chatbot integrated with a MySQL database to enhance social security services through natural and interactive communication. The chatbot was developed during an internship program at the Social Security Office (BPJS Ketenagakerjaan) Medan Kota branch. Methods: The system was developed using Natural Language Processing (NLP) capabilities of the Gemini API to process user input and retrieve structured data from a MySQL database. An admin dashboard was built with the Laravel framework to manage PDF uploads, perform text extraction, and handle user queries in real time. Result: Testing showed that the chatbot could effectively respond to general and data-driven queries, extract and analyze uploaded documents, and improve response time compared to traditional service channels. The integration of Gemini API and MySQL ensures scalability, accuracy, and secure data management. Conclusion: The implementation of a Gemini API-based chatbot integrated with a MySQL database demonstrates how AI-driven conversational systems can modernize public services. It enhances operational efficiency, accessibility, and user satisfaction, supporting the digital transformation of social welfare institutions in Indonesia.
Counseling and Training on The Application of Criminal Sanctions for Violations of BPJS Ketenagakerjaan Ceria Cristy Kayani Sihombing; Sanco Simanullang; Habieb Pahlevi; Yasir Riady; Muhammad Ajmal
Aktual: Jurnal Pengabdian Kepada Masyarakat Vol. 3 No. 2 (2025): Aktual: Jurnal Pengabdian Kepada Masyarakat May 2025
Publisher : CV Media Inti Teknologi

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.58723/aktual.v3i2.389

Abstract

Background of the study: Employment social security is a basic right of workers guaranteed by the state through BPJS Employment.Purpose and scope of the paper: This research analyzes the effectiveness of implementing criminal sanctions based on Article 55 of Law Number 24 of 2011 for violations of BPJS Employment obligationsMethods: This study uses a juridical-normative approach, which aims to analyze laws and regulations relevant to the problem of company compliance with BPJS Ketenagakerjaan's obligations.Results: The results of this research recommend strengthening regulations, digitizing supervision, and incentives for compliant companies to ensure effective and equitable implementation of social security.Conclusion: The employment social security system in Indonesia, especially those managed by BPJS Ketenagakerjaan, has an important role in protecting workers from social risks. The implementation of this system still faces many obstacles, especially the low level of corporate compliance.