During my three-month internship at DoHome Public Company Limited in the Logistics Department, I gained hands-on experience in logistics operations, data analysis, and process optimization. I was responsible for analyzing truck operations using Microsoft Excel, tracking and calculating truck trips across multiple branches to monitor performance and identify areas for improvement. I contributed to the Logistics Management System (LMS) Project by designing user interfaces, calculating operational timelines, and implementing solutions to improve delivery accuracy and workflow efficiency. Additionally, I automated distance calculations for approximately 2,000 locations using Google Sheets and Apps Script, which reduced manual workloads and improved accuracy in route planning. I also created and documented logistics workflows, enhancing process transparency and collaboration between teams. My work involved cost analysis, where I evaluated fixed and variable transportation costs to provide insights for cost optimization and improved delivery performance. This internship allowed me to strengthen my technical skills in Microsoft Excel (advanced functions), Google Apps Script, and data analysis, while also developing problem-solving abilities and a deeper understanding of supply chain operations.
ประวัติการฝึกอบรม
ความสามารถ
ความสามารถทางภาษา
พูด (พอใช้) อ่าน (พอใช้) เขียน (พอใช้)
พูด (พอใช้) อ่าน (พอใช้) เขียน (พอใช้)
ไทย คำ/นาที อังกฤษ คำ/นาที
Mi
crosoft Excel : Pivot Tab
le
, Vlookup, Hlookup,
Xlookup,I
f
, And
, Or,Power Query, Index, Match
data cleaning
.
Mi
crosoft 365 (
O
ff
ce)
i
Mi
crosoft Word
PowerPoint
Power B
I (basi
c)
Tab
leau (basi
c)
Google Sheets
Drawio
A
I : Prompt