Article Per Year (5 Year)
p-Index From 2019 - 2024
1.853
P-Index
This Author published in this journals
All Journal Journal of Information System JSiI (Jurnal Sistem Informasi) Journal of Information Systems and Informatics G-Tech : Jurnal Teknologi Terapan JIKA (Jurnal Informatika) International Journal Of Science, Technology & Management (IJSTM) Jurnal Informatika Ekonomi Bisnis
Wiratama, Jansen
Unknown Affiliation
Aerospace Engineering Agriculture, Biological Sciences & Forestry Automotive Engineering Biochemistry, Genetics & Molecular Biology Chemical Engineering, Chemistry & Bioengineering Chemistry Civil Engineering, Building, Construction & Architecture Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management Earth & Planetary Sciences Economics, Econometrics & Finance Education Electrical & Electronics Engineering Energy Engineering Industrial & Manufacturing Engineering Mechanical Engineering Transportation

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

Found 2 Documents
Search
Journal : International Journal Of Science, Technology

 1 
Improving the Data Management: ETL Implementation on Data Warehouse at Indonesian Vehicle Insurance Industry Wiratama, Jansen; Abhinaya Bagioyuwono, Michael
International Journal of Science, Technology & Management Vol. 4 No. 5 (2023): September 2023
Publisher : Publisher Cv. Inara

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.46729/ijstm.v4i5.936

Abstract

Unknowingly, risk is an essential part of an individual's life. Every day individuals have the potential to be threatened by possibilities that can produce something that has fatal social, human, and financial consequences. Insurance can help individuals to relieve the financial burden caused by unwanted things by transferring individual losses to insurance companies. This transfer of losses will distinguish individuals from possible bankruptcy and financial security. Automotive insurance is a liability for loss or damage to motorized vehicles. This time we will take the example of an insurance company specializing in automotive insurance, namely Top Gear Insurance (TGI). This company uses customer data storage using an ordinary manual database that does not yet use a data warehouse system. This ordinary manual database makes it difficult for TGI to retrieve data for reprocessing and makes data inaccessible from anywhere, asynchronous, concise, and inefficient. There is a solution to the TGI problem of creating a data warehouse with a star schema approach for storing and processing data. The data warehouse is likely to make the data within the company more accessible, efficient, simple, and understandable so that TGI can develop its business through data analysis from the data it already has. Datawarehouse has many business advantages, such as increasing Business Intelligence, data quality and consistency, saving time, and supporting historical data analysis and queries. The data warehouse consists of datamart, OLTP, OLAP, and Star Schema. Using Mondrian as a visualization showed that TGI can get information about customer data, policies, and claims easily, quickly, and concisely. That can also help TGI create customer profiles and targeted marketing and company evaluation based on the visualization provided.
Development of Web-based School Uniforms order Application in a Private School with Prototyping Model Wiratama, Jansen; Ady Sanjaya, Samuel; Santoso, Hari; Brian Kurniadi, Reinardus
International Journal of Science, Technology & Management Vol. 4 No. 6 (2023): November 2023
Publisher : Publisher Cv. Inara

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.46729/ijstm.v4i6.977

Abstract

Strada SMK Daan Mogot, a private school in Tangerang City, oversees several operations. Student registration, academic exams, uniform measurements, and book purchases are carried out at the beginning of each school year. The Uniform Team tasked with handling this activity experienced difficulties due to the large volume of data, making conventional techniques inefficient to carry out. This research focuses on simplifying uniform ordering procedures from the uniform team to the uniform manufacturing supplier. The Uniform Team recorded and measured orders by hand, which resulted in time-consuming management and limited real-time data monitoring for the Principal. A web-based solution that allows easy access to uniform ordering data is needed to speed up these operations. The successful development and installation of this application at SMK Strada Daan Mogot is a significant achievement, with good User Acceptance Test results and confirming alignment with user needs. This progress is an essential step toward optimizing school operations.
Co-Authors Abhinaya Bagioyuwono, Michael Ady Sanjaya, Samuel Angga Aditya Permana Brian Kurniadi, Reinardus Dharmada, Tralya Faza, Ahmad Halim, Frans Ati Hari Santoso Johan, Monika Evelin Jonathan Melvin, Melvin Putra, Muhamad Calvin Syah Ramadhan, Glenn Ramadhan, Muhammad Chezar Sanjaya, Samuel Ady Santo Fernandi Wijaya Sobiyanto, Sobiyanto Subianto, Tan Andreas Dwi Pratama Sugara, Victor Ilyas Sulaiman, Agus Sutomo, Rudi Wijaya, Matthew Chandra Wijaya, Willsen Yang, Angelina