🇷🇺|🇬🇧













Georg Riehakainen's Place on the Internet









scroll down for more

Hi!
Welcome to my website.
 I am Georg Riehakainen, a student of CentraleSupelec University in Paris, 🇫🇷

I work at Yandex Maps and I am proficient in Python, SQL and eager to meet new challenges.

By the way, your current IP is: 216.73.216.91

My Life

|Vector search over images|Map with local recommendations|Online Jupyter server|

My technical skills

  • Python

  • DBMS: SQL, Clickhouse

  • Server Management: Linux (Flask configuration)

  • Data Analysis: Pandas, Numpy, Matplotlib

  • Data Visualisation: Yandex Datalens, Leafmap

  • Web Development: HTML, CSS

  • Git, cron for this website deployment workflow

My work experience

Technical Manager, Yandex Maps, Remote, RU / Sept 2024 - present

  • Operational Data Project
    I have lead my colleagues through a project of ETL process on hypothesis regarding existing Yandex data. This allowed to exclude 3 people in the adjacent teams from manual labor and control.

  • Ultimate ETL process and Dashboard
    The project was intented to store and display information from 5+ not natively related databases. Using SQL and text processing, I managed to combine data from 2 different Issue Trackers and 3 various internal API sources into single data mart.
    The dashboard is now used by several teams.
At the time, I have experimented with:

Telegram bot API
With my subordinate, we are programming a bot placed to a special group chat, that will be integrated with Issue Tracker

Missing footprints analysis
I've tried to explore possibility to cluster geolocation Data and POI Data with purpose to create missing buildings hypothesis
However the results were not satsifactory.

Technical specialist, Yandex Maps, Moscow, RU / Jul 2023 - Sept 2024

  • International Expansion support
    I've contributed to Yandex Maps goals in accuracy and recall of the real world by formulating new ideas for my team to enhance data and providing adhoc analytics for required action items.

  • Adjacent teams support
    I was consulting colleagues on the data retrieval from the database of my department and modifying database with API calls



Additional Useful Information
My school courses
I am pursuing double degree of the 2nd best engineering school in France CentraleSupelec and business school ESSEC.
Of 1st year, these are most significant courses:
  • Linear algebra and topology
  • Programming for data science
  • Introduction to Statistics
  • Optimization
  • Introduction to Algorithms
  • Introduction to Data Structures


My languages

Russian Native, English C1
IELTS 8.0 Certificate, Je parle un peu Français

What I built in web-dev
Some goals to build or explore

  • Create a map of all wikipedia articles in France (maybe graph knowledge database)

  • Explore open transit data of Paris and London




What I built offline

  • I implemented a local image search feature leveraging embeddings, using Clickhouse example To lay the groundwork, I extracted metadata, generated vector representations of the images, and configured a Clickhouse database. I customised the existing codebase to suit my specific requirements and set up a user-friendly interface using Flask

  • I have deployed and am administering a Linux server with a Flask-based web interface for adding points to a map via a Telegram bot, and Jupyterhub for collaborative work in Jupyter Notebook with my mates.

Let's talk!

My Linkedin Message Me