e
excelerma

Juan Lerma

@excelerma

Supply Chain Data Analyst, Power BI and Excel

Colombia
English, Spanish
About me
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.... Read more

Skills

e
excelerma
Juan Lerma
Offline • 
Average response time: 1 hour

See my services

Data Dashboards
I will build an automated supply chain dashboard in excel or power bi
From$75 / projectMore details
Data Dashboards
I will automate your excel dashboard and reports with power query
From$50 / projectMore details

Portfolio

Work experience

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.