e
excelerma

Juan Lerma

@excelerma

Supply Chain Data Analyst, Power BI and Excel

Colombia
Inglese, Spagnolo
Alcune informazioni sono riportate in lingua inglese.
Chi sono
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.... Continua a leggere

Competenze

e
excelerma
Juan Lerma
offline • 
Tempo di risposta medio: 1 ora

Consulta i miei servizi

Dashboard dati
I will build an automated supply chain dashboard in excel or power bi
A partire da75 USD / progettoMaggiori dettagli
Dashboard dati
I will automate your excel dashboard and reports with power query
A partire da50 USD / progettoMaggiori dettagli

Portfolio

Esperienza lavorativa

Hyundai

Dispatch Coordinator

Hyundai • Full time

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.