Design and implementation of merchant acquirer data warehouse at PT. XYZ

Abstract

Merchant acquirer is a business of acquiring debit card, credit card, and prepaid card transactions using EDC (electronic payment terminals) in merchants. It is included in one of the top business priority areas in PT. XYZ. It is in the area of retail payments and deposits. It increases fees based incomes, cheap funds, and high yield loans. In order to improve its business performance, PT. XYZ needs the best strategy. However, a good strategic decision needs an adequate of useful information. Currently, information that is provided by reporting staffs involved many manual tasks in the process. In consequence, the data cannot be provided quickly, and it has some complexity limitation. As a solution for this problem, PT. XYZ needs a data warehouse for its merchant acquirer business. This research will focus on the design and the implementation of the data warehouse solution using a methodology that is developed by Ralph L. Kimball. Finally, data warehouse is developed which is suitable for merchant acquirer PT. XYZ's needs.