Freelancer profile translated to English.
Back to original languageAbout Ana
I transform administrative chaos and data leakage into interactive dashboards that allow you to make confident business decisions.
I am an Industrial Engineer and Data Analyst with experience structuring data architecture for manufacturing, logistics, and retail (F&B) companies. My goal is not only to deliver visually appealing charts but to build automated models that expose your true profit margins and eliminate the time your team wastes on manual reports.
My areas of expertise:
📊 Financial Dashboards: Advanced modeling in Excel/Google Sheets for real-time monitoring of income, expenses, and profitability.
⚙️ Operational and Industrial Efficiency: Capacity analysis (OEE), waste control, and bottleneck identification in plants and dispatch logistics.
🍷 F&B Cost Modeling: Creation of dynamic simulators to calculate exact margins per recipe and inventory in the gastronomic sector.
I work with agile methodologies, adapting perfectly to the European time zone to ensure timely deliveries and fluid communication. Shall we talk about optimizing your data this week?
Spanish
Native or bilingual
English
Conversational
Remote only
Primarily works remotely
Experience
- Alvilla S.A.S.Data AnalystApril 2024 - Today (2 years and 3 months)Bogotá, ColombiaApplied Business Intelligence: I designed and automated interactive dashboards in Power BI • • Excel for 6 productive areas, digitizing data collection and reducing report generation time from days to hours.Process Optimization (Kaizen & VSM): I led Value Stream Mapping (VSM) and time studies, achieving a proven 11% improvement in operational efficiency by identifying and eliminating bottlenecks.Operational KPIs Control: I defined, structured, and monitored critical production and logistics indicators, ensuring compliance with monthly goals and optimizing On-Time Delivery.Quality Management and Audit: Responsible for ensuring compliance with operational standards as an Internal Auditor (ISO 9001), promoting a 5S culture and continuous improvement in the plant.
- IndependienteData & Strategy ConsultantJanuary 2025 - Today (1 year and 6 months)Financial Visualization: Development and implementation of dashboards • • Google Sheets and Advanced Excel, incorporating progress bars, interactive charts, and automated income and expense tracking systems for agile business decision-making. Structuring of cost and profitability models for new business concepts (e.g., standardization of recipes for signature cocktail lines and gastro-bars).
Recommendations
Be the first to recommend Ana
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Professional in EngineeringFundación Universitaria Empresarial de la Cámara de Comercio de Bogotá (Uniempresarial)2026Profesional en Ingeniería
- Power BI and Advanced Excel(Polisura2025Power BI y Excel Avanzado