mariobarrantes05

- Designed and maintained advanced Power BI dashboards & Power Apps to track KPIs across onboarding, lead conversion, production targets, and regional sales performance, increasing data visibility for stakeholders across LATAM. - Developed automated data pipelines using Power Query and Power Automate to integrate sources such as Smartsheet, Dynamics 365, Excel, and SharePoint, reducing manual reporting time by 40%. - Created custom HTML templates for automated notifications (e.g., AWS-EMEA tier alerts), enhancing internal communication and branding consistency. - Led data cleaning and transformation efforts with Power Query, ensuring data accuracy and consistency across multiple reporting systems. - Delivered actionable insights through compelling data storytelling and interactive reports, supporting cross-functional decision-making. - Maintained constant and assertive communication with stakeholders to validate business requirements, ensuring that all reporting solutions aligned with operational goals and data integrity standards.

- Analyze open purchase orders to gather transportation milestone statistics, identifying delayed, inactive, or undetected orders by the geofence tracking system or those with specific issues. - Execute project plans using Gantt charts and task tracking tools, managing timelines and deliverables aligned with business objectives. - Execute weekly reporting and analysis of the company's main importation KPIs, applying critical and analytical thinking to review the previous week's KPI performance, adjust KPIs based on stakeholders' rules, and create new indicators when necessary to provide functional, data-driven, and innovative solutions for KPI reporting and visualization. - Map processes, organize, clean, and analyze data to identify improvement opportunities, design changes, and propose ideas and initiatives for continuous improvement - Conduct periodic follow-up meetings with external technology suppliers for tracking purchase orders via geofence, addressing issues related to tracking accuracy of transportation milestones, and applying project management principles to ensure effective vendor coordination. - Support colleagues in the Continuous Improvement department with various tasks and daily activities through assertive communication and meticulous attention to detail, leveraging project management tools like MS Project to track progress and milestones.

-Developed and optimized ETL processes using Alteryx to manage and transform large datasets from SAP ERP systems, ensuring outputs met stakeholder requirements. -Implemented streamlined workflows for data extraction, cleaning, and processing, ensuring data quality and integrity while providing clear, actionable insights through well-structured reports. -Managed projects under the Scrum methodology, where the backlog was worked on in sprints, ensuring deliverables and tasks were aligned with project goals. -Maintained constant and effective communication with internal clients and fellow analysts, streamlining data management processes with efficient data analysis techniques.