From 8/2015 to 5/2018 I worked for a Swiss company named ETC Transport Consultants as senior data analyst and developer on a part-time basis (60%). Within this time period, in less than three years, I developed a complete solution for Travel and Assignment Planning in Python -with the help of ETC team of course- that accomplished following tasks in an integrated process:
- Top-down distribution of measurement requirements (see introduction)
- Travel Planning (based on 60+ logical search conditions & constraints)
- Assignment Planning (based on 20+ assignment conditions + nonlinear/discrete optimization)
- Export of results into excel files (reporting)
You may download my official work certificate from ETC (pdf file) which provides a good overview about this development project.
Searching, evaluating and sorting optimal tours (with public transport vehicles like train, tram or bus) that are found according to given set of search conditions in planning software…
The planning software is based on central timetable data (HAFAS data) for Switzerland, that include information like departure and arrival times for every transport line. In the simple central architecture of this planning software there are Python modules and PostgreSQL database containing the timetable data, and nothing else. Continue reading