← Back to list
Registration: 29.07.2025

Anna Smelkova

Specialization: Product Analyst

Skills

Python
SQL
Jira
Redash
Confluence

Work experience

Strategic Partnerships / Analyst
since 07.2021 - Till the present day |Aviasales
SQL, Python, Redash, Jira, Confluence
● Analyzed the performance of 25+ major partner integrations (including Booking.com, Agoda): revenue trends, traffic quality, conversion rates, and integration stability. ● Analyzed user and brand behavior within the Travelpayouts ecosystem to improve retention and increase LTV. ● Conducted partner performance analysis: built SQL reports in Redash to track revenue trends, drop-offs, and integration accuracy. ● Participated in exploratory testing and monitored integration success using Redash and custom SQL reports ● Defined and implemented growth strategies, including joint promotional campaigns, new product feature development, and API integrations. ● Segmented partners by revenue and traffic sources, forming the basis for launching personalized incentive programs. ● Prepared reports for cross-functional teams (product, marketing, business) with key metrics related to the partner channel.
Traffic Manager
07.2021 - 10.2022 |Aviasales
SQL, Python, Redash, Jira, Confluence
● Performing operational tasks for the partner network development team (over 500k partners and 110 brands). ● Collecting and analyzing brand performance data, generating ideas for retention and revenue growth. ● Integrating 10 new brands onto the platform.

Educational background

Data analytics for business and economics (Masters Degree)
2023 - 2025
HSE SPb
Economics of power industry (Bachelor’s Degree)
2019 - 2023
SPbPU

Languages

RussianNativeEnglishAdvanced