Electronic Resource
Article - Extract transform load process in banking reporting system "Volume 8, Artikel 101260"
Banks 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.
Tidak tersedia versi lain