Harvey Diaz, the newest architect to join TIQQE, has a solid 15+ years of software development experience, providing solutions for various business verticals – ranging from digital ad service providers, to enterprise resource management vendors, to platform integration specialists, earning him a mark as well- rounded software architect. But the last 7 years has been more focused on specializing on the e-commerce industry and its integrations with shipping carriers and third- party logistics providers.
He was one of the main developers of an ecommerce software which proudly features self-integration with marketplaces, shipping and warehouse management, and which automates order syncing, label printing, bin pickup allocations, AI-assisted on-demand packing and pack railways, among others.
He was previously a volunteer-trainer for free and open source software in Southeast Asia as part of the International Open Source Network, a United Nations Development Programme regional capacity building initiative. At free time, besides learning new technologies, he engages in community service and volunteerism, trying his best to make a positive change in society. He is currently the president of a local chapter of the Junior Chamber International in Cebu City.
In November last year I was contacted by Mathias and Oskar who attend their last year of the Information technology program at Örebro University. They wondered if they could do their SUP (System Development Project) at TIQQE during this semester and now they will finally present what they came up to!
Who we are and what is the SUP?
We are two students from the Information technology program at Örebro University, who have studied together since the beginning of our studies. We are currently in our last semester. Our last semester involves carrying out a system development project, where you either do your own project or you carry out a collaboration project with external actors (such as a company).
The point of the SUP (system development project) is to apply and develop previously acquired skills in a longer project. The project means that we plan and carry out independent work where the focus is problem solving and application. This involves all parts of the system development, from analysis to implementation.
How did we end up at TIQQE?
For us, there was no doubt that we wanted to do the SUP at a company. So last year in November, we started thinking about what kind of company would suit both of us. For us, it was important to find a company that could offer a challenging project. But it was at least as important that the company’s culture and values were in line with our own, this was important because we wanted the best opportunities for personal and professional growth. We wanted to be in a place where it feels good and that we actually contribute something. So we came in contact with an TIQQE:r who told us about TIQQE, the culture, values and what technologies they use. This caught our interest, so we contacted TIQQE because we wanted to know more about them and if they could possibly be interested in offering us a project. We had an interview, where it turned out that they were interested in a SUP project. They were able to offer us what we were looking for and best of all we got the same good feeling from those as we got from the TIQQE:r that we had spoken to earlier. So the journey started from here.
What is the project and what was the result?
TIQQE had a time reporting and salary system that was working but the current processes were time-consuming and not sustainable for the future. It involved a lot of manual work, so TIQQE wanted us to review this and see if we could automate this instead.
We started by reviewing the current time reporting- and salary system to identify unnecessary time-consuming processes and then investigate what can be done smarter and what can be automated. After investigating we came up with a new design, created and implemented it.
The solution for the new salary system ended up to work like this:
First we are collecting all the absence time entries from the past month from Clockifys API by making some GET requests. This data is then sorted so only TIQQE employees’ time entries are left. The data is then transformed into an XML file and saved in an S3 bucket. This is done with AWS Lambda. The Lambda then creates a temporary link for the file to be downloaded within 7 days. The link gets mailed out with SES to a group mail owned by TIQQE. From here the person responsible for the salary can just download the XML file from the group mail and import it to Visma (The salary system).
When the automation of the salary system was implemented we started to work on creating an analyze tool with AWS Quicksight. This is done by getting a detailed report from Clockifys API by making a POST request from a Lambda. The data arrives in CSV format and gets transformed into JSON and saved in an S3 bucket. When the data is in the S3 bucket, a Crawler creates metadata for an ETL which transforms some data types into other data types and saves the newly formatted data as parquet into an S3 bucket. This data is then crawled to create metadata about the parquet files. With the new data in place, all we needed to do from here is to create SQL questions that are used in Quicksight to pick out relevant data. Then create the Diagrams to display the data. And now TIQQE can see things like total profit per month/year, profit per customer, and much more.
We have done some testing and everything seems to work. So now we are eager to put it in production.
How has it been to do SUPEN at TIQQE?
It has been a great experience. Everyone at TIQQE is super nice and we felt as if we were a part of the team since day one. They included us in meetings and activities if we wanted to join. We never got the feeling that we are “less worth” only because we are there and doing a school project, which is great. TIQQE also provided us with a good project at a perfect difficulty level. We also got a person to give us technical advice when things got a bit tricky. When we have talked to other students, some of them didn’t even get any technical specialists or advice, and this held them back quite a lot. Both from learning and from progressing with the project. We did not experience any of what some of our fellow students explained. So this was well done by TIQQE. Lastly, we want to thank everyone involved and TIQQE for allowing us to do this project. We learned a ton of new stuff.
We been very happy to have you with us and great job with your SUP!!
I knew that TIQQE worked with Amazon Web Services and that the company strived for a good company culture, which basically was what made me interested. I was looking for a job with something interesting to work with (AWS) and where I would enjoy going to work everyday and TIQQE ticked both those prerequisites off. I also knew Jacob (TIQQE’s CEO) from before, and knowing how good of a person he is, I also knew that TIQQE would be a great place to work at since he worked there!
What was your first impression of TIQQE your first week? Since we’ve been working from home the whole time it’s been a bit different compared to other jobs, but I’m also quite used to talking to people through Slack, Google Hangout and similar services so I didn’t think too much about it. But we started off with a couple of meetings and introductions during my first days so I got into contact with multiple colleagues straight away and got assigned a mentor that has been very helpful.
What is your role at TIQQE? Full Stack developer, currently working with PostNord.
How has your first time been at TIQQE? It’s been great! Everyone at TIQQE has been very nice and friendly, and I’ve gotten into a great team at PostNord. It’s a lot of fun and rewarding to work with something that is used daily!
What are you looking forward to in the nearest future? I haven’t thought too much about that – since I just recently joined both TIQQE and the team at PostNord I’m just trying to get up to speed with everything and do my best!
What do you know about TIQQE now?
That it indeed is a great company, and I’m very happy that I joined! Looking forward to see what the future brings!
If you want to read why Joakim joined TIQQE follow the link here!
Edwin is an innovative web developer who manages all aspects of the development process. He’s passionate about solving problems, creating ideas, and learning new technologies. He has a lot of experience working on different technologies such as Python, PHP, Typescript, Angular, VueJS, Docker, and so much more. He is more focused on backend development, and how to automate things.
When not at work, Edwin loves biking and motorcycle riding. He also loves playing MMORPG games and spending time with his family. For Edwin, work, hobbies, and family should be well-balanced.
What is required to build a sustainable organization, where employees choose to stay and where they can develop in an innovative environment? How can we make employees feel “this is the last company I will work for”?
Last week we listened to the first part of the podcast where we got to know Joakim and he covered: why sneakers are the best to wear, why a pizza oven should be in used in every household, the importance of taking a nice nap and what it was like to work on “the dark side “. He will also share his insights and experiences on how to build a sustainable community where the people choose to stay. And create an innovative environment where people who are part of the community feel that this will be the last company they will ever work for.
The second part of “Culture and innovation”, we will delve into culture and innovation – the symbiosis between them and how important it is that they exist within the organization. Joakim also shares his top 5 list of books to read.
We are proud to welcome Bring as a new customer toTIQQE. Bring has chosen TIQQE as their Integration partner for onboarding customers.
Bring solves everyday logistics for small and large businesses in the Nordic region, through efficient and sustainable deliveries. Bring handles parcels, goods and couriers, and can assist their customers with both small and large deliveries in the entire Nordicregion, both regionally and internationally. Together with you, Bring will find the best solution for your business – to you or directly to your customers.
Following a strong growth in e-commerce, Norway Post and Bring are now making major investments in what will be Norway’s largest fully automated warehousing solution.
This new warehousing solution, together with new digital solutions and automated processes, will take care of all logistics from the moment the customer presses the buy button in the online store up until the item is delivered. The parcels will be picked up and delivered to online retailers throughout Eastern Norway until nine o’clock in the evening.
This creates a large demand for automation and in 2020 TIQQE was chosen to be Bring Warehousing’s Integration partner.
Bring looked for a partner who will be able to work together with them on their journey, and that can provide help and support when and where it will be needed. This is where TIQQE comes in. We’re proud and honored to be part of Bring’s journey and look forward to a long-term partnership!
Last week TIQQE’s Joakim Restadh was a guest at ZervicePoints Podcast.
He will share real life experiences both from the past and present and most importantly the lessons learned down the road.
In the first part we will get to know Joakim where he will share: why sneakers are the best to wear, why a pizza oven should be in used in every household, the importance of taking a nice nap and what it was like to work on “the dark side “. He will also share his insights and experiences on how to build a sustainable community where the people choose to stay. And create an innovative environment where people who are part of the community feel that this will be the last company they will ever work for.
The second part will be connected to “Culture and innovation”, we will deep dive into culture and innovation – the symbiosis between them and how important it is that they exist within the organization.
Joakim also shares his top 5 list of books to read.
Anomaly detection is the notion of automatically looking at data and finding outliers, i.e. data points that do not fit in well with the rest of the dataset. Finding an outlier is usually a sign that something exceptional has happened that should trigger further investigations or actions. Anomaly detection can be performed on existing historical datasets e.g. when you are pre-processing your AI training data. It can also be used on a real time data stream from your business transactions or sensor readings to almost instantly flag a data point as anomalous. This is a great example of AI automating things that a human can do and with a glance at a graph see a problem. In this article Torbjörn will discuss anomaly detection from a few different perspectives and with this new tool under your belt you will start to look at the world with different eyes!
Follow the link below to read more about Torbjörn’s blog
The 8th March Johan Karlsson joined TIQQE. After two weeks with us we asked a few questions to see if the reasons he had to join us have been met so far.
What did you know about TIQQE before you started? I worked at Enfo when TIQQE was founded and I’ve kept on eye on the company ever since.
Why did you want to join TIQQE? Because I believe in what the company stands for and because several friends and former colleagues already work here. I wanted to have a lot of smart, inspiring tech nerds around me and I like the technologies that TIQQE work with.
What was your first impression of TIQQE your first week? There is a warm and friendly atmosphere here. We’ve been a few people at the office which helps with the intro. It has felt like a big re-union.
What is your role at TIQQE? Developer and tech lead.
How has your first time been at TIQQE? I’ve got a good introduction to people, processes and tools by Cajza. Clearly I’m used to working remote but starting from scratch remote is a bit different. A lot of new things to learn.
What are you looking forward to in the nearest future? I’ve started in the PostNord retail team. I’m looking forward to learning the business side, learn AWS, getting to know the team better and whole TIQQE.
What do you know about TIQQE now? It’s as nice I hoped it would be.