Projects Detail

The Indirect commission (IDC) team at Vodafone was using 10+ scattered MS Access databases and a MySQL database to investigate and process commissions claims made by store dealers.

There was to tracking of claims made by dealers hence no KPI's could be set leading to huge dissatisfaction amongst dealer community. It also left room for fraud without any centralised logging.

Megacube created a centralised "Claims System" that included 

• Creating a single application to serve end-to-end Indirect Commissions claims handling process

• Migrate data from legacy MS Access and MySQL databases into the new unified application

• Design self service reporting portal to enable other teams like Fin Control, Fraud etc to run financial reports themselves rather than being dependent on Indirect Claims team to send data to them on regular basis