Konstantin Malykhin Email & Phone Number

Almaty, Kz

Almaty, Kazakhstan

Product owner of time-spatial dynamic pricingLed one of the main company’s internal products as a data engineer & analyst: created metrics for dynamic pricing based on time-spatial criteria that boosted revenue by up to 35% compared to basic flat pricing. Created and led A/B testing processes including machine learning techniques.Product owner of the internal spatial analytical & visualization toolDeveloped and headed an internal web tool benefiting hundreds of business, analytical, and operational team members in everyday tasks. The developed tool optimized operational and analytical work processes by up to 90%.Spatial Data Engineering & AnalyticsCreated and maintained the majority of spatial ETL processes and optimized the previous ones up to 10-50 times processing time and IO, which saved thousands of USD monthly.In this role, I utilized various technical skills to analyze and manipulate data using Python, SQL, and AWS tools (Athena, Redshift, PostgreSQL, etc.). Airflow & DBT were used as ETL/ELT solutions. I used libraries and tools like geopandas, GDAL, folium, geopy, PostGIS, and QGIS for spatial analysis.ManagementLed an internal team: overseeing work processes, task assignment, and monitoring, ensuring efficient project execution. Spearheaded numerous spatial analytics projects, managing tasks from inception to completion, and delivering presentations and reports in BI tools to stakeholders and customers. Conducted comprehensive training sessions to empower colleagues in working with spatial data and databases, enhancing team capabilities.Skills: Python, SQL, PostgreSQL, PostGIS, AWS Redshift, ETL/ELT, API, Airflow, Dagster, DBT, Geopandas, GDAL, geopy, Foilum, Plotly

Moscow

- Writing services for data collection, structuring and storage (ETL/ELT solutions, API, Web Scarping)- Automation of data processing processes (Python / SQL / Airflow / Docker )- Geospatial analytics in Python (geopandas, shapely, GDAL, geopy, Folium, Plotly), PostGIS and in QGIS- Basic development and maintenance of an internal company web tool (JS, React)

Almaty, Kazakhstan

Team participation as data geoanalyst in the competition of the Ministry of Construction of the Russian Federation "Comfortable urban environment"- Collecting, including digitization, structuring, updating, analysis and visualization of spatial data (Python, QGIS)- Preparation of visual materials (maps, slides, graphics) and album layout (QGIS, InDesign)

Moscow

Data Engineer / GIS analyst in "Magistral" team- Writing services for data collection, structuring and storage (ETL/ELT solutions, API)- Automation of data processing processes (Python/ SQL/ Airflow/ Docker / Telegram bot)- Geospatial analytics in Python (geopandas, shapely, GDAL, geopy, Folium, Plotly), as well as in QGIS- Preparation of analytical reports- Backend-development for dashboards- Creation and management of databases (PostgreSQL / MySQL)- Participation in the development and analysis of technical documentationComplete data preparation, as well as assistance in the backend development of an interactive map of the new route network in the center and south of Moscow with more than 1M views at the start.https://t.mos.ru/transport/marshruty/magistral/map

Moscow, Russia

Analyst, GIS/GEO AnalystTeam participation as data geoanalyst in the competition of the Ministry of Construction of the Russian Federation "Comfortable urban environment"- Collecting, including digitization, structuring, updating, analysis and visualization of (spatial) data (R, QGIS)- Assistance in the preparation of visual materials (QGIS, InDesign)- Assistance in developing a strategy for the use of the projected siteResults:According to the results of the work, the project of transformation of the central part of the city of Safonovo, Smolensk region, is included in the list of winners in the category "Small towns: from 20 to 50 thousand people"

Saint Petersburg, Russia

Analyst- Project program preparation (timings, participants, limitations and etc.)- Management of a team of five people, including the distribution of roles and responsibilities- Compilation of a list of data required for data collection, including "field" data- Data collection, cleaning, structuring, analysis and visualization (R, QGIS, Excel, PowerPoint)- Formation of the final report on the work performed

Master'S Degree, City/Urban, Community And Regional Planning, 8.6

Bachelor'S Degree, Public Administration, 8.8