Data Analyst & Process Automation Specialist Color Líquido Impresión Digital S.A.S.
Built and maintained a MySQL/Xojo production-order platform supporting more than 50 users across sales, administration, production, dispatch, and installation operations. The platform tracked approximately 240 orders per month and improved visibility across operational workflows.
Defined and monitored operational and commercial KPIs for production throughput, pending orders, sales activity, and invoicing backlog. Automated bank reconciliation with the SIIGO API, Python/Pandas, and PDF statement extraction, reducing a two-to-three-day manual process to hours.
Automated biweekly sales commissions with Excel VBA, worked-hours and overtime consolidation for approximately 50 employees, and invoice extraction and normalization from Gmail using Google Apps Script. These automations reduced recurring processing work from days to minutes or hours.