This project is for a Fortune 500 leader in banking and payment technologies.Our client is a leader in the Merchant Services (credit card processing) division of the financial industry and needed to overhaul the way they cleaned, managed, and reported on their residual commissions.
In order for them to correctly pay out the sales agents connected to their company they have to ingest data from credit card processing companies, combining that information with payee profiles, and finally calculating the income, fees, and net payout for each merchant and payee in the system. When the customer first came to us, that process was handled manually in Excel spreadsheets. But, they knew that process would not scale as the data management process was slow, fragile, and error prone. None of which you want when dealing with paying your sales people.
Due to our prior experience building data solutions in the merchant services industry, we were able to jump into the project rapidly, starting with:
- refining and documenting the specification of how residuals were calculated in the then-current manual system
- automating and encrypting transfer of data files from the customer's servers to ours
- parsing of multi-line, fixed-width record format input files (holdovers from the mainframe era)
- generating payee residuals reports