Migración de Datos del Sistema Comercial en una Empresa de Servicio Público

Abstract

This project will reveal how the data migration process is performed as part of the implementation of a new trading system in a company whose functions are to supply of drinking water to the inhabitants of the city of Guayaquil, expanding its coverage and constantly improving its operation. One of the aims when changing the system used was the opportunity presented to evaluate internal processes and improve business area using a specialized in the management of basic services international system, optimizing the care provided to them to external and internal customers; but by the nature of the company it was required to migrate much of the information from the previous system making this a challenge due to the difference between the processes of the previous system and the new system to be implemented and the sensitivity of not fulfilling any of the regulations imposed by the municipal body that regulates the company. In the analysis phase of this project the decision to divide by processes, these being 9 in total bank addresses, serializable, measuring elements, Customers, Invoices, readings and consumption, network elements, and Deferred Work Order was made; the successful migration of data after the implementation of the new system would allow the correct execution of processes such as criticism, billing, collections, claims attention first, second and third instance, in addition to integration with the Trading System Information System Geographic and Financial Management System.