ABOUT

Alex is a data analyst with an engineering and educational background. He sees his goal as an analyst in becoming an operator for businesses which create value, utilizing various analytical tools (e.g. Python, SQL, R, Tableau). He feels great when he's able to find solutions for a company that will affect the profit, customer acquisition, clarity, scalability, providing data-driven answers to the questions raised by business. He loves the team spirit, when people work smart towards big aims and support each other on the way.

Downloads:
Resume
Analytical project presentation

Links:
Kaggle Profile
Github Projects
Blog

DATA ANALYTICS PROJECTS

Cyclistic | Divvy Bike-Sharing Data Analytics
A capstone project for the Google Data Analytics Certificate program. Goal: Analyze the Cyclistic historical bike trip data to identify trends in how annual members and casual riders differ, why casual riders would buy a membership, and how digital media could affect the company's marketing tactics.

  • Explored the bike-sharing trip data, using BigQuery, SQL, and R. Generated three hypotheses why casual riders wouldn't want to get a membership.
  • Performed data cleaning of 8 million observations with R programming and filled missing values. Created visualizations for different customer segments for further analysis with ggplot.
  • Created combined visualizations for 2020-2021 in Tableau and listed the top used bike stations for future targeting ad campaigns.
  • Analysed the trends and featured a set of recommendations to overcome the anticipated issues in the Kaggle notebook.
  • Filed the presentation with data-driven insights involving pricing plans changes and customer journey map towards an annual membership.



    • Keywords: SQL, R, Data cleaning, Data Analysis, Tabeau, ggplot, Kaggle
    Github repository

    Nov 2021 - Dec 2021


    WORK HISTORY

    Member of Technical Staff
    Perplexity AI

  • Engineered and scaled data collection and processing pipelines using Python, Airflow, and distributed AWS infrastructure, supporting continuous dataset ingestion across multiple parallel machines.
  • Built and maintained Airflow-orchestrated workflows for automated data ingestion, deduplication and storage; managed AWS server environments ensuring pipeline reliability and uptime.
  • Part of the early team supporting Perplexity’s community growth; helped grow the Discord to 380K+ members and the subreddit to 90K+ weekly visitors; channelled community signal into product and data decisions as the platform scaled.

    • Keywords: Python, Airflow, AWS, Data Pipelines, Dataset Collection, SQL, PostgreSQL, LLM, AI Search

    Aug. 2022 – Present

    Data Labeling Team Lead
    Perplexity AI

  • Led an annotation team building training datasets for Bird SQL and early Perplexity AI search. Ran coding sessions, QA reviews and annotator onboarding.
  • Authored and validated SQL query templates covering advanced patterns (window functions, CTEs, multi-join logic). Coordinated with engineering on model feedback loops and AI-generated query verification.
  • Built and curated primary dataset source material through multi-source data collection pipelines; structured demo environments to support model training.

    • Keywords: Data Labeling, SQL, NLP, LLM Evaluation, Dataset Construction, Team Lead, Airflow, Python

    Sept. 2022 – Jan. 2023

    Data Analyst
    Shenzhen Ok Panda Ltd.

  • Project-based work. The latest ones:
    Created dashboards and reports for the marketing analytics department of a mortgage broker using SQL, Metabase. Partly, data engineering — fixed and updated 100% of ETL scripts contributing to our PostgreSQL database, using R, Python, Docker, Gitlab, BigQuery, Google APIs. Devised and maintained data pipelines.
  • Analysed business/dental clinic products using Power BI, clusterization, cohort analysis, RFM, churn/retention analysis, user survey results and QFD matrix. Devised recommendations for marketing decisions.
  • Extracted token pairs, swap and trade data for a crypto exchange. Data collection via blockchain APIs, Python, Pandas, BeautifulSoup, Selenium.

    • Keywords: SQL, PostgreSQL, Airflow, Data Engineering, Data Pipelines, CRM, Data Analysis, R, Python, BigQuery

    July 2021 – Aug. 2022

    Marketing Data Analyst
    Dorogo-lom

  • Increased direct ads conversion rate by 68% by audience segmenting and launching a series of marketing campaigns in Google Adwords, Yandex Direct, Avito classifieds for each product.
  • Analysed and built a semantic kernel and launched a CRM system with distinct customer source segmentation.
  • Devised a digital marketing strategy for the company & performed data collection and analysis via CRM, Google Analytics, Yandex Metrica.

    • Keywords: Google Analytics, Metrica, CRM, digital, marketing, CR

    Jun. 2020 - Mar. 2021

    Co-Founder
    Ponchitos Coffee Shop

  • Set up a family coffee shop in Yevpatoriya city with 4.8★ average customer rating. It was a startup, where everything was done from scratch.
  • Managed the following operations daily: buying necessary equipment, renting commercial property, and getting supplies.
  • Hired staff, ran social media campaigns and events to attract customers, gain credibility and loyalty for the coffee shop.

    • Keywords: Startup, CRM, Coffee, Sales, SMM, Customer aquisition, CJM

    May 2015 - May 2020

    NOC Engineer
    Vimpelcom

  • Monitored and handled network equipment events primarily on Ericsson, Nokia, and Huawei infrastructure (BSS, NSS, GPRS core network) at mobile network operations center.
  • Managed incidents in Helpdesk system, communicating and coordinating resolution with different support levels including third-party partners and vendors.
  • Maintained planned and recovery works, such as performing backups and system restoration.

    • Keywords: Mobile, Ericsson, Nokia, Huawei, Helpdesk, Support

    Feb. 2008 - Oct. 2011 2020


    PUBLICATIONS

    1. Alex Romanov, "How to write Chinese characters: Handwriting Practice Notebook", series, It's Ok Press, ISBN 978-0990319634, 2021
    Purchase

    2. Alex Romanov, "Skazia", It's Ok Press, ISBN 978-0990319603, 2017
    Purchase


    EDUCATION & CERTIFICATIONS

    Google Data Analytics Professional Certificate
    Google
    Credential ID ZT6XXRU7YYMZ

    Dec. 2021


    Python and Statistics for Financial Analysis
    The Hong Kong University of Science and Technology
    Credential ID HC24YGYMR7KR

    Nov. 2021


    SQL
    Sololearn
    Credential ID 17600988-1060

    Nov. 2021


    Python Core Course
    Sololearn
    Credential ID 1073-17600988

    May. 2020


    Masters in Radio Engineering
    The Bonch-Bruevich Saint-Petersburg State University of Telecommunications

    2003 - 2008


    TECHNICAL SKILLS

    Data Engineering & Pipelines
    Docker, Git, PostgreSQL, BigQuery, Airflow, AWS (S3, EC2)

    Data Analysis
    Python (Pandas, Seaborn), SQL, R, Tableau, GGPlot, Power BI

    AI / ML & Languages
    LLM evaluation, dataset construction, NLP; Python, R, GCP (BigQuery, Cloud SQL), HTML/CSS/JS


    Python
    Data Analysis
    BigQuery
    Tableau
    Data cleansing
    PostgreSQL
    R
    Google Analytics
    Docker

    ADDITIONAL INFORMATION

    Languages
    English; Russian; Elementary Chinese;

    Interests
    Traveling, IT, hockey, guitar, reading