Claim Missing Document
Check
Articles

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

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.
Capability Assessment of IT Governance Using the 2019 COBIT Framework for the IT Business Consultant Industry Brian Hardjadinata, Maximillian; Wiratama, Jansen
International Journal of Science, Technology & Management Vol. 4 No. 4 (2023): July 2023
Publisher : Publisher Cv. Inara

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

Abstract

Most Indonesian businesses need help with business alignment with information technology. COBIT is one of the frameworks controlled by IT Governance. COBIT 2019, the most recent COBIT framework, assesses information technology governance and capability levels at PT Kwadran Lima, Indonesia. Capability is measured by interviews regarding COBIT operations using a specified process domain. The COBIT Design Toolkit was used to establish the process domains. The process domains acquired were APO12-Managed Risk, BAI10-Managed Configuration, and DSS03-Managed Problem. These three domains solve challenges at PT Kwadran Lima in Indonesia. The process domain was assessed through interviews using the RACI Chart. Following the collection of measurement results, suggestions are made based on the findings of the evaluation results. According to the findings, PT Kwadran Lima Indonesia is still at level 2 to reach level 3. As a result, a proposal is made to develop or design a team whose tasks and responsibilities are to plan and execute ways of collecting categorization and associated data analysis of Information Technology risk for the Company to achieve level 3.