Developed dashboards for strategic areas of Lotería Nacional, including General Management, Video Lottery, Trade Marketing, and New Channels. Monitored and validated dashboards to ensure the accuracy, consistency, and proper operation of reported metrics. Built complex SQL queries to extract, filter, analyze, and validate data for departmental reports. Defined and developed strategic KPIs to monitor sales performance across different Lotería Nacional products.

Researched international market trends in the U.S. and Europe using the TotalFob platform. Developed interactive dashboards in Power BI and Excel to analyze consumer behavior and support business decision-making. Processed, cleaned, and ingested datasets using Python, ensuring data consistency and quality. Defined and developed strategic KPIs for monitoring international markets and business performance.

Analyzed international consumption trends using TotalFob and developed analytical models in Power BI/Excel to support business and commercial decision-making.

Researched national and international markets (Colombia, Peru, Chile, China, and the U.S.) using TotalFob. Developed Power BI and Excel reports and dashboards for inventory turnover and stock control at Tienda D'mas, Colombia. Automated and cleaned complex data sources using Python to improve data processing and reporting workflows. Collaborated directly with the commercial team to analyze business information and develop strategies for different target markets.

Coordinated data collection activities and training processes for students and fishermen participating in census projects. Created, structured, managed, and validated databases using Excel and performed multivariate analysis using SPSS. Supported data quality through the organization, validation, and processing of collected information.

Built billing databases and prepared accounting reports for financial monitoring and decision-making. Managed supplier payments and supported the recovery of overdue accounts through data monitoring and follow-up.