The company is locksmith services provider for Car and Home lock repair with their technicians network across US and Canada. They were using app built on MS Access in their internal network with limitations about capabilities and scalability.
Client markets their services from website and other classified portal posts. They receive inquiries by call, many times for urgent requests for cases like “Got Locked out of cars with keys inside”. Calls are received by call center agents and the job is assigned to a technician based on customer’s location. Once the job is completed, payment received is shared between the Company and the technician.