Business Intelligence Analyst
Mérieux NutriSciences | Aug 2023 - Present

• Developed 8+ upper management dashboards in Power BI for sales, operations, finance, customer service, and market analysis, serving decision-making in both Peru and Colombia branch offices.
• Created dashboards and automated report deliveries for the top Key Account clients, enabling them to visualize and analyze their laboratory results.
• Automated the ETL processes, data cleaning, and report updates using SQL and M, increasing data delivery frequency by 200%.
• Monitored sales team KPIs and provided actionable recommendations, leading to a 6% improvement in sales performance.
• Forecasted sales using statistical models in R, improving revenue predictions by 4%.
• Automated Excel daily reports with VBA and macros, freeing up 8% of daily work time, boosting productivity.
• Developed models for client prospecting using neural networks and linear regression in R, identifying and prioritizing more than 50 potential clients.
• Answered business queries and delivered both on request and periodical reports.
• Developed price optimization models in R.
• Consistently collaborated with international team members across multiple business departments.
• Worked closely with stakeholders to understand business needs and deliver clear insights and recommendations that directly supported their strategic goals.

Commercial Assistant
Mérieux NutriSciences | Feb 2023 - Jul 2023
Performed the same functions as the current role of Business Intelligence Analyst.