Ethica Wines North America & Asia PacificSenior Business Analyst
Feb. 2021 - Apr. 2023Miami, Florida, United States• Coordinated creating an Analytical Report for the sales force with Power BI, connecting AZURE COSMOS DB database to the analytical tool, and creating reports and dashboards for each sales force member. ◦ Creating reports using drill-through functionality helps connect multiple information and visualize various data. • Led the management of the chain of value management from producer to retail, managing all the internal and external costs to create a final price at each stage, importer, wholesale, and retail. • Evaluated the regional sales managers' budgets and creation of sales forecasts for future years and months.
• Created sales tools, such as apps and business automation to improve processes and reducing waste. ◦ Integrated an algorithm that blocks the sales order confirmation when clients have overdue invoices.
◦ Advis the regional sales manager that they have sales orders blocked.
• Shaped the It team, to carry out projects and everyday tasks. ◦ Created it Help Desk
◦ Regulated business process flow for the invoicing software
• Integrated Automation to reduce waste and boost efficiency.