Informe final de práctica profesional: plan de mejora en la gestión operativa, documental y logística de adquisiciones

Abstract

This final professional internship report presents the development and implementation of an improvement plan aimed at automating documentary and contractual control in the purchasing department of Smart Training Society S.A.S. (Smart Language Academy). The initial diagnostic revealed that SAGRILAFT vendor compliance tracking, contract expiration monitoring, and monthly invoice recording were conducted manually without historical records or timely alerts, resulting in delayed notifications and transcription errors. A participatory action research methodology was adopted, incorporating direct observation, iterative design, and live production testing. The solution comprised four systems built with Google Apps Script on pre-existing Google Workspace licenses at zero financial cost: an automated SAGRILAFT compliance pipeline, an automated contract expiration notification system, an invoice cross-referencing tool with live preview, and a weekly supplier folder synchronization workflow. Consequently, complete traceability was established across 201 active suppliers with 71% compliance achieved, contractual notices advanced to 60 days prior to expiration, and technical handbooks were delivered to ensure institutional continuity.