Data analytics on transaction and payment card data

About VISA
Visa Inc. is an American multinational financial services corporation headquartered in Foster City, California, United States. It facilitates electronic funds transfers throughout the world, most commonly through Visa-branded credit cards, debit cards and prepaid cards. Visa is one of the world’s most valuable companies.
We are a global payments technology company working to enable consumers, businesses, banks and governments to use digital currency.
Customer Requirements
VISA was looking for data analyst services for the Czech branch of a significant multinational bank for smoother payment card portfolio migration. The bank had two basic requirements – to obtain support for the business department from the bank core systems data collected in data warehouse and to design and create regular reporting of the payment card portfolio. In both cases the bank knew that the source of data is spread and undocumented databases, hence the ability of fast orientation in database scheme was a necessary condition for the project.
Delivery
The delivery stretched for 7 months and included a regular cooperation with the client bank, several dozen individual data analyses were processed and delivered for the business, marketing, and IT departments. Also, the system of regular reports of payment cards portfolio was designed and created, separately for credit and debit cards. The solution was adopted by the bank. An integral part of the solution were also SQL scripts for easy preparation of monthly data for individual reports.
Solution Benefits
- Fully automated generation of regular reports
- Year-on-year and month-on-month comparison of requested values
- Graphical representation of the progress of the bank's portfolio
- No additional cost for the bank after the project delivery, the reporting solution can be fully supported by the bank operations team
- No need to manage the source DB and perform queries
Get in touch with us!
We would be happy to help you succeed!