The Challenge: Abimar Foods Inc. (USA) needed to guarantee business continuity and manage production tracking remotely from Colombia due to key personnel shortages. The process required handling end-of-shift data, raw SQL databases, and SAP inventory reconciliation across different plants and production lines without causing operational downtime or communication bottlenecks. The Solution: > I designed and standardized a complete, end-to-end remote operation model from scratch within 6 months. My implementation included: Data Structuring: Extracted SIP system data (process orders, quantities, scrap) and organized SQL databases using pivot tables by plant/line to streamline notifications and eliminate idle time. Cloud Collaboration: Built a real-time consolidation hub for order and inventory management using Google Workspace (Sheets, Drive, Gmail) to enable simultaneous cross-border workflows. SAP Variance Automation: Engineered a custom formulated tool that imports SAP inventory data to automatically calculate and redistribute material variances (shortages/excesses) proportionally across process orders, dictating accurate SAP 261 and 262 transactional movements. Bilingual SOPs: Authored highly detailed Standard Operating Procedures in both English and Spanish to document this entirely new workflow and ensure easy onboarding. The Impact: 100% Business Continuity: Successfully sustained US manufacturing operations through a remote LATAM support model. * Corporate Recognition: Earned 4 international corporate awards for the design and flawless execution of this remote integration.