Background
A global corporate giant had an important sales commission calculation process.
The commission processing team received daily input data from data preparation team. This data included sales per product, daily sales per territory, territory to sales representative alignments, product list, list of a few thousand sales representatives etc.
The commission processing team would pull this data from secure FTP location, run some Quality checks and process the same through multiple steps like data clean-up, data load, commission processing, quality checks, generating incentive reports per sales representative per day and uploading those reports to 2 online systems of the company.
These daily incentive reports would then be ready to be accessed by sales representatives, to help them understand incentives they could expect to be paid. These daily and fortnightly reports were also used by the company’s HR team to make fortnightly incentive payments to their sales representatives.
