e
excelerma

Juan Lerma

@excelerma

Supply Chain Data Analyst, Power BI and Excel

Colombia
Engels, Spaans
Sommige informatie wordt in het Engels weergegeven.
Over mij
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.... Lees meer

Skills

e
excelerma
Juan Lerma
offline • 
Gemiddelde reactietijd: 1 uur

Bekijk mijn diensten

Data dashboards
I will build an automated supply chain dashboard in excel or power bi
VanafUS$ 75 / projectMeer informatie
Data dashboards
I will automate your excel dashboard and reports with power query
VanafUS$ 50 / projectMeer informatie

Portfolio

Werkervaring

Hyundai

Dispatch Coordinator

Hyundai • Fulltime

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.