Barcelona, Cataluña, España
1 mil seguidores Más de 500 contactos

Unirse para ver el perfil

Acerca de

I have more than 10 years of experience in Data Engineering, Data Warehousing, and Data…

Actividad

1 mil seguidores

See all activities

Experiencia y educación

  • Wix

Mira la experiencia completa de Pavel

Mira su cargo, antigüedad y más

o

Al hacer clic en «Continuar» para unirte o iniciar sesión, aceptas las Condiciones de uso, la Política de privacidad y la Política de cookies de LinkedIn.

Licencias y certificaciones

Cursos

  • Business Intelligence

    COURSERA

  • Oracle SQL 12c

    Специалист, Oracle SQL Pr

Proyectos

  • Geospatial Data Tool for Real Estate Insights

    -

    **Project Overview:**
    Recently, I collaborated with a partner to develop a tool for accessing property data in Tel Aviv, targeting B2B clients like real estate agencies.

    Project Description:
    Our tool retrieves detailed property information using a Telegram bot and a REST API developed with FastAPI. Users can get data on building details, such as the year of construction and number of floors. We integrated additional data on trees, parks, kindergartens, shelters, beaches, and air…

    **Project Overview:**
    Recently, I collaborated with a partner to develop a tool for accessing property data in Tel Aviv, targeting B2B clients like real estate agencies.

    Project Description:
    Our tool retrieves detailed property information using a Telegram bot and a REST API developed with FastAPI. Users can get data on building details, such as the year of construction and number of floors. We integrated additional data on trees, parks, kindergartens, shelters, beaches, and air quality into a PostGIS-powered Data Warehouse (DWH).

    We used Tel Aviv’s public API (ESRI GIS) and other APIs, employing machine learning techniques like classification and kernel density estimation. We scraped data from sites like yad2 using BeautifulSoup, Chromium, Puppeteer, Selenium, and Playwright. Our goal was to create clusters indicating whether a property's price is below average, normal, or above average.

    Technologies and Tools:
    - *Programming Languages & Libraries:* Python, Geopandas, Polars, BeautifulSoup
    - *Databases:* PostGIS
    - *Data Analysis & Visualization:* QGIS, Jupyter Notebooks
    - *Asynchronous Programming:* asyncio
    - *ORM:* SQLAlchemy
    - *APIs & Data Retrieval:* Requests, Public APIs (ESRI GIS), Scraping APIs
    - *Frontend:* Telegram bot, REST API (FastAPI)
    - *Containerization:* Docker

    *Impact and Conclusion:*
    Although we didn't achieve a perfect product-market fit, this project was a significant learning experience. It showcased my ability to design data pipelines, implement machine learning techniques, and develop user-centric products. This project highlights my skills in data engineering, geospatial analysis, and product development, demonstrating my passion for creating impactful solutions.

Calificaciones de pruebas

  • ÖSD Sprachdiplom | B2

    Puntuación: Bestanden

    Deutsche sprache

Idiomas

  • English

    Competencia básica profesional

  • Deutsch

    Competencia básica profesional

  • Russian

    Competencia bilingüe o nativa

  • Hebrew

    Competencia básica

Ver el perfil completo de Pavel

  • Descubrir a quién conocéis en común
  • Conseguir una presentación
  • Contactar con Pavel directamente
Unirse para ver el perfil completo

Perfiles similares

Añade nuevas aptitudes con estos cursos