SRC-POSM: Transformación digital del proceso de consolidación regional de materiales para el área retail GTM de Huawei Colombia.

Abstract

SRC-POSM—the Regional Smart POSM Materials Consolidation System—is a solution designed and implemented during an internship at Huawei Colombia’s Go-To-Market (GTM) Retail Department, in response to a systemic inefficiency that completely fragmented the coordination of point-of-sale material requests between Colombia and the six countries in the region and the parent company in China. This process consumed between 18 and 20 hours per week in manual follow-ups, with 42% of requests arriving late and an equal proportion containing incomplete information, resulting in validation cycles of up to 25 additional days and logistics costs up to five times higher than the standard. To resolve this, an integrated system was designed and implemented on Microsoft 365, consisting of a smart form in Microsoft Forms, a centralized database in Excel-SharePoint, and a dashboard in Power BI with automated alerts and predictive capabilities based on approximately 100 historical requests. The system went live in January 2026, successfully processing the first 25 real requests during its launch month, validating its end-to-end functionality, and laying the groundwork for a reduction of over 50% in incomplete information, more than 60% savings in manual follow-ups, and a 40% decrease in total regional consolidation time.