HMI webapp
HMI webapp developed for B2B customers in the logistics sector (Only sections not protected by NDA).
My Contribution
I worked on:
- Backend: Python, SQL, PostgreSQL (timescaledb), Redis
- Frontend: React, javascript (typescript)
API endpoints
- I developed new unit-tested API endpoints both to interact with other machines and to be consumed by the frontend.
- I maintained existing API endpoints, fixed bugs and deprecated + migrated endpoints when needed.
Statistics module
I developed the new frontend and optimized the backend, which resulted in a reduced load time of statistics module by ~93%, utilizing various optimization techniques for data aggregation in the database and data processing in Python, which enabled the team to assist customers faster.
- It can handle databases with tables consisting of millions of rows while maintaining low response times.
- It was praised by my managers and by the technical support team, since it allows them to assist customers much faster than with the previous system.
Overview and Errors pages
- Fixed multiple bugs and added features on the overview layout that represents the sorter view from the top.
- Display actual errors and warnings by querying the PostgreSQL database using SQL.
Initiatives I led to improve CICD processes (Long term thinking)
- Proposed and implemented improved coding standards and managed a quality gate which resulted in improving new code and increased the code coverage of the backend from 5% to over 50% in a period of 1,5 years.
- Detected that some microservices were tightly coupled so I proposed an architectural change that simplified the codebase and adapted it to my team's needs, which also reduced docker image sizes by -72.5% (measured in production for the backend)
- Reduced build time from 4min15 to 1min42 (-60%) by optimizing Dockerfiles and introducing multi stage builds.
