e
excelerma

Juan Lerma

@excelerma

Supply Chain Data Analyst, Power BI and Excel

Colômbia
Inglês, Espanhol
Algumas informações são exibidas no idioma inglês.
Sobre mim
Industrial Engineer and Supply Chain Data Analyst with 3+ years of experience in logistics, dispatch operations, transportation, production, and operational reporting. I transform raw business data into practical Excel and Power BI dashboards for KPI monitoring and decision-making. My work includes data cleaning, Power Query, data modeling, interactive reports, and performance analysis focused on OTIF, lead time, deliveries, routes, costs, and operational efficiency. I communicate clearly, work carefully, and deliver structured, easy-to-use solutions.... Saiba mais

Habilidades

e
excelerma
Juan Lerma
offline • 
Tempo médio de resposta: 1 hora

Conheça meus serviços

Painéis de dados
I will build an automated supply chain dashboard in excel or power bi
A partir deUS$ 75 /projetoMais detalhes
Painéis de dados
I will automate your excel dashboard and reports with power query
A partir deUS$ 50 /projetoMais detalhes

Portfólio

Experiência profissional

Hyundai

Dispatch Coordinator

Hyundai • Período integral

Jun 2026 - Present • 2 mos

Coordinate dispatch planning, transportation providers, route tracking, delivery performance, costs, backorders, and operational KPIs such as OTIF and lead time. Create Excel and Power BI reports to support logistics decisions and coordination with commercial, production, warehouse, and foreign trade teams.