文章基本信息

标题：Extract transform load process in banking reporting system
本地全文：下载
作者：Mokhamad Hendayun ; Erwin Yulianto ; Jack Febrian Rusdi 等
期刊名称：MethodsX
印刷版ISSN：2215-0161
电子版ISSN：2215-0161
出版年度：2021
卷号：8
页码：1-17
DOI：10.1016/j.mex.2021.101260
语种：English
出版社：Elsevier
摘要：AbstractBanks must maintain, calculate, and monitor liquidity using the Liquidity Coverage Ratio (LCR) indicator. In Indonesia, they reported daily, monthly, or quarterly online through a paper template prepared by the Financial Services Authority (OJK). This reporting must accurate and on time or be subject to penalties. For banks that are still processing LCR semi-automatically, this reporting system is an obstacle that they continue to face and resolve. This article discusses the automation process method developed using the concept of Extract Transform Load (ETL), with a waterfall software development model, so that daily reports are generated automatically. This article proposed a methodology to anticipate problems in integrating banking with regulators by applying one of the Basel III frameworks, primarily based on Indonesia's case studies. The finding of the research is a method for the LCR report process through ETL. The proposed ETL method in this research had proven used success in processing LCR in the banking industry. This method is a solution and recommendation for banks in making reports based on Basel III to complete LCR reporting through the ETL method.•Maintain, calculate, and monitor liquidity using the Liquidity Coverage Ratio (LCR) indicator in Banking .•Automation process method developed using the concept of Extract Transform Load (ETL).•Recommendation for Banks to complete LCR reporting through the ETL method).Graphical abstractDisplay Omitted
关键词：Liquidity coverage ratio;Extract transform load;Core banking;Data warehouse;Banking reporting system;Basel III