Services
References
Contact
Data engineering with passion
"Juha as a skilled data engineer helped VR Fleetcare to transform legacy analytical platform to modern era (cloud native aws). His contribution to the adoption of agile working methodologies was crucial as well"
Tuomas Savikangas, VR Fleetcare

Services

Data warehouse, Integrations, Cloud implementations
Maintenance, Reports, Monitoring & Testing

Gasgrid Finland Ltd
Gasgrid Finland Data warehouse
Integrations, Data modelling, Dabase design and structure
VR Fleetcare Ltd
VR Fleetcare Data warehouse
Integrations, Data modelling, Dabase design and structure
Tampere information system
Tampere city passenger information and traffic light benefit system
Backend system, Business logic, Integrations, Databases, APIs
Tram information system
Helsinki Regional Transport Authority information system
Backend system, Business logic, Integrations, Databases, APIs, Reporting

Data warehouse (Gasgrid Finland Ltd)

For data analytic purposes we are collecting data from several different sources with Azure Data Factory, Azure Functions and REST calls. Around 10 000 000 records a month.

Technologies used: Azure Data Factory, Azure Web App Service, Azure functions, Azure SQL Server: SQL & Stored procedures, Application Insights, Azure storage, Azure Dev Ops


Data warehouse (VR Fleetcare)

VR Maintenance's idea is to create a maintenance system that utilizes data from the trains in decision-making. Instead of a traditional kilometre-based maintenance system, maintenance needs and faults could be predicted in the future based on data. VR Maintenance has a separate data and analytics team that builds algorithms based on sensor data to predict maintenance needs. If successful, there could saving of tens of millions of euros if the whole train is not left on the track and maintenance can be carried out as planned. My job on the team has been to build a data warehouse for analytics. As well as integrating data from multiple sources into a consistent data model that makes reporting easy.
https://www.youtube.com/watch?v=fpDwV5wge_k

VR Fleetcare Data warehouse

Technologies used: Azure Data Factory, Azure Functions, Azure Storage, AWS Lambda, AWS Glue, Azure SQL Server, SSIS, Snowflake, SQL, Terraform


Public transport information system (City of Tampere)

At Mattersoft Ltd, together with CGI, we implemented the Tampere public transport information system. The total implementation included e.g. vehicle equipment, back end system, traffic light equipment and bus stop displays. I was in the role of coding architect for the project and was responsible for the background systems as a whole, database design, some integrations, some mapbased management interfaces, and reporting, monitoring, and testing design

Technologies used: JavaScript, jQuery, .Net Web API, REST, C#, SQL, Google Maps, OpenLayers

The operating principle of the IJ2010 system, simplified:
The location data according to the GPS positioning of the vehicle device in the buses is transferred to the service provider's backend system. The backend system controls the traffic light benefits using location-based traffic light request and acknowledgment points.
Vehicles connected to the system are granted traffic light benefits when the vehicles pass through the points mentioned above, if the vehicle also meets the criteria of the permitted limit values, in which case the vehicle can be granted a traffic light benefit. The request and acknowledgment of traffic light privileges takes place in the backend system, which can be easily managed through a web-based user interface. The backend system controls the traffic light devices installed in the traffic lights, which implement the traffic light benefits. In accident situations, for example, emergency vehicles are able to bypass the normal light cycle.
A strong advantage of this system is the absence of physical induction loops or similar sensor devices in the street infrastructure, but the traffic lights still require a traffic light device to implement the traffic light benefits.

The operation of the system required real-time and really small delays, because things had to be made to happen immediately when a fast-moving vehicle crossed the place selected on the map. System management, reporting and monitoring were also implemented in real-time, so all kinds of abnormal activity and error situations could be affected immediately. The life cycle of the system was from 2010 to 2019.

The planning and implementation of the system was a long and interesting project, the highlight of my career so far. I could write any number of long stories on the subject, but apparently at least a couple of theses have already been written on the subject:
ruotsalainen.pdf
matkustajainformaatiojarjestelma.pdf


Public transport information system (Helsinki City)

HSL Live service provides up-to-date information about public transport situation. Different transport modes, vehicle location and route information are displayed on a map. It is possible to monitor the movements of a single vehicle on its route and to see for example all the stops of a certain line on a map, or the estimated arrival or departure times of each vehicle to a certain stop. A public interface for software developers is included in the service, from where it is possible to get real-time information about vehicle movements. Login credentials can be requested from HSL and the same credentials are valid for all interfaces provided by HSL

Technologies used: JavaScript, jQuery, .Net Web API, REST, C#, SQL, Google Maps, OpenLayers


About me

I try to profile myself as a programming cloud & software architect, and a data engineer.
I've studied IT for 8 years, and most of my work life I've been working for public transport section (you couldn't imagine how high tech stuff they actually make!)
Past five years I've been building data warehouses and integration systems.


Story behind the company

Kaalimaa's story began in the 90s, when I started my internet life playing Diablo, and I created homepages for clans. We had several designated chat rooms and game places, the most popular of which was Kaalimaa I invented. The name was sympathetic enough and most importantly: fast to write. Kaali / maa was also a popular and easy username & password combination. Kaalimaa is always associated in my mind with a nice place where it's nice to spend time.

Kaalimaa

Contact information

LinkedIn: https://www.linkedin.com/in/juha-tikkanen-7151bb4/
E-mail: juha@kaalimaa.fi