Rosa - Data Analyst

Experiencia demostrada en Sales & Commercial Analytics.

Experiencia demostrada en KPI Tracking.

Experiencia demostrada en Inventory Analysis.

Experiencia demostrada en Data Cleaning & Transformation.

Experiencia demostrada en Trend Detection.

Analyze large-scale commercial and digital datasets to surface actionable insights and support client strategy across banking, government, and beverage industries; managing 15 concurrent monthly campaigns in collaboration with a cross-functional team of 10.. Track and report social media KPIs: reach, engagement rate, impressions, and sentiment, for influencer marketing campaigns using Brandwatch, serving clients across banking, government, and beverage industries; delivering monthly executive decks to a major bank.. Design and execute market research surveys; build KPI dashboards and data visualizations to inform strategic decisions for cross-functional stakeholders.. Leverage Claude (Anthropic) and AI-assisted workflows to automate report generation, streamline recurring analyses, and multiply team output capacity, saving up to 5 hours daily on monthly deliverables; work within Agile-Scrum methodology.

Analyzed purchasing and sales data across local and international supplier relationships using Advanced Excel and Odoo ERP, identifying cost-reduction and efficiency opportunities.. Developed and monitored commercial and operational KPIs supporting executive decisions; built dashboards and reports for quarterly planning cycles in coordination with a 5-person commercial team.. Optimized inventory availability through data-driven stock analysis, reducing estimated stock gaps by 15-20%; coordinated with suppliers to streamline procurement workflows.

Analyzed large-volume sales datasets (62,000+ rows) to identify performance trends, revenue gaps, and improvement opportunities for the commercial department.. Prepared statistical reports; supported data cleansing, validation, and database organization using Advanced Excel, Power Query, and Power Pivot to strengthen commercial reporting integrity.

Analizar datos de compras y ventas con proveedores locales e internacionales, identificando oportunidades concretas de reducción de costos y mejora operativa.. Construir tableros e informes para respaldar decisiones de la alta dirección.. Manejar y optimizar la disponibilidad de inventario a través de análisis de stock basados en datos.. Realizar procesos de compra internacional y local de maquinarias e insumos, así como manejar procesos de venta con clientes.. Manejar procesos logísticos de importación de mercancía internacional.. Coordinar con proveedores internacionales para agilizar procesos de abastecimiento.

Analizar bases de datos de ventas de gran volumen (más de 62,000 registros) para identificar tendencias de desempeño y áreas de mejora en el área comercial.. Elaborar reportes estadísticos para la toma de decisiones de la dirección comercial.. Dar seguimiento y reportar hallazgos de métricas comerciales establecidas.. Apoyar los procesos de limpieza, validación y organización de datos con Excel, Power Query y Power Pivot.