Developing procedures for loading data from external and internal sources;— designing databases on Microsoft SQL Server for optimal data storage and processing;— organizing data showcases for analysts using data build tool (dbt);— translating existing scripts to asynchronous code to speed up data processing;— team development (Jira, Confluence, Git).— Developing ETL processes using SQL Server Integration Services (SSIS) to integrate data from various sources into the data warehouse;— creating reports and mailings to various teams using SQL Server Reporting Services (SSRS).

Introduction to commercial development and teamwork. — Developing API applications in Python, Sanic;— Drawing documentation with Swagger;— Working with the database MongoDB;— Containerization using Docker/docker-compose— Using message broker RabbitMQ— Setuping CI/CD pipeline for the projectPython 3, MongoDB, Docker, Sanic, pytest, Git, RabbitMQ, OOP, Redis, Celery, CI/CD, linters.

— Using Python language to write scripts to increase the experience. — Dashboard development with Paid Ads data. Stack: Python, Yandex.Direct API, Yandex.Metrika API, Docker, pandas, PostgreSQL, DataStudio BI.— Developing a digital ads strategy. Media planning for tour operators Coral Travel and Sunmar, hotel chains, Royal Flight.— Developing and optimizing ad campaigns at Google Ads, Yandex.Direct, VK.— Web analytics in Yandex.Metrika, Google Analytics;

International Marketing Agency MediaOption, the part of Yengo holding.— Developing and optimizing ad campaigns at Google Ads, Yandex.Direct, MyTarget, Facebook Ads;— Developing chatbots on Facebook and LINE for MediaOption TH.— Media planning for potential clients.— Working with landings on Tilda;— Installing Google Analytics, Yandex.Metrika and goals there. — Creating ad banners;— Developing sales auto funnels for searching clients for a marketing agency

— Developing and optimizing ad campaigns at Yandex.Direct, Google Ads;— Analyzing the effectiveness of ad campaigns;— Making reports about ad campaigns.