Diseño e implementación de una base de datos para el seguimiento y control de clientes y/o prospectos en el área comercial de Volvo Group Colombia

Abstract

Volvo Group Colombia is an international organization recognized worldwide for guaranteeing quality in its products and above all providing safety. Volvo Group Colombia currently has a presence in the market with its bus products, both mass-urban and highway-intermunicipal buses. Currently the practice is carried out in the commercial area, supporting the general manager and the regional commercial manager, with strong support in the highway or inter-municipal bus sector. Within this area, a great problem has been identified and it is the diverse information of customers and prospects divided by the different areas of the company, that is, there is no possibility of handling condensed information unilaterally. On the other hand, difficulties were evidenced with monitoring the process carried out by the commercial area with customers, this because from the moment an order is made for it, it is quite extensive and complex because it is carried out in parallel to the request for documentation, bus bodywork and other situations with external actors that make the loss of customers possible. Based on the above, the decision is made to create and implement a database that condenses the information divided into the company and additionally generate support through the creation of control formats that will allow the correct monitoring of clients which help to improve efficiency in the commercial area.