Mapping Company data flow
Internally, the management team at Votexa had no idea how their current IT systems are laid out and how they communicate with each other. In essence, they had no idea how their data landscape looked like, as different members of the staff knew about different processes of the company. So I was asked to communicate with different members of the team and external clients/suppliers to figure out how everything talked together.
After some time, I managed to design the current Data Landscape of the company (figure 1) and what direction the company should head towards in the short-term (figure 2) and long-term (figure 3). I then compiled this knowledge into a rapport and made a short presentation explaining how different parts of their company work and how CLS can reduce costs and improve.
Votexa currently spend around, ±1500 euros a month whilst only using about 8% of their cloud resources. This meant some drastic changes had to be made to reduce the costs. You can read more about this on the project page.
After creating the rapport, I was asked to have another round of talks with members of the staff to see what process I could automate, improve and simplify at Votexa. I have found some processes that could be automated, but the main bottleneck I found was the way the ERP and (SMS) Supply Management System communicate with each other. As each sale had to be manually written on paper and about 3 different online platforms, before it was submitted to the ERP.