Implementación de soluciones tecnológicas para la automatización y optimización de procesos empresariales en García Vega S.A.S

Abstract

This document presents the implementation of technological solutions at García Vega S.A.S, where tools were developed to automate processes and optimize operational efficiency. As part of the professional internship, an AI chatbot was designed using OpenAI and Google Apps Script, enabling the automation of prospect filtering and sales management through WhatsApp. Additionally, advanced Excel reports were created to analyze historical data on inventories and product performance, using both formulas and Visual Basic programming. The project also included the development of a mobile application in Kotlin with Firebase for inventory management, implementing user authentication and MVVM architecture with Jetpack Compose design. These solutions contributed significantly to improved decision-making and operational efficiency in the company. The document covers the phases of development, from conceptualization to implementation, and provides recommendations for future improvements in scalability and continuous monitoring. This work demonstrates how technological solutions can transform internal processes and enhance productivity within a company.