Automatización de Reportes Logísticos en Lean Solutions Group

Abstract

Lean Solutions Group, founded in 2012 in Cartagena, Colombia, provides nearshoring services to North American companies, focusing on operational support, technology, marketing, and sales. Its mission is to offer efficient remote services to the logistics sector through advanced communication technologies and skilled personnel, with a vision to become a national leader in nearshoring by 2025. Operating in Colombia, the U.S., Guatemala, and the Philippines, the company's improvement plan aims to automate shipment tracking reports in Excel using Power Query and VBA. This initiative seeks to optimize processes, reduce human error, and enhance efficiency within the Client Services team. The implementation faces challenges such as learning curves and technological dependencies but offers significant benefits, including time savings and improved accuracy. The automation process involves collaboration with specialized teams and is validated by Points of Contact (POCs) to ensure effectiveness and approval.