Healbe Corp.

Achievements: - Built from scratch a data warehouse (DWH) based on GCP services. Set up ETL processes to collect data from third-party services via API. Automated data transfer with subsequent processing and recording in DWH. - Built a stable end-to-end analytics system that helps to evaluate the effectiveness of advertising channels from displaying an ad to buying. - Developed dashboards for departments for specific requests and requirements. - Set up event tracking on the site and in the application, which allows you to quickly make decisions to improve user experience and increase conversion. - Developed and implemented a product analytics system based on Firebase and Google Cloud Platform.

Healbe Corp.

Responsibilities: - Marketing analytics. Building an end-to-end analytics system based on the Google Cloud Platform. Creating dashboards for data visualization and solving business problems (Google Data Studio, Tableau). Building attribution models and CJM analysis. Event tagging on the site (Google TagManager). Calculation of the main marketing performance indicators of advertising campaigns (CPM, CPC, CPO, CAC, CR, ROMI). Anomaly search, forecasting, paid traffic optimization. - Product analytics. Active participation in product development: generating hypotheses, developing and calculating metrics (DAU, LTV, Retention, NPS), conducting A/B tests, analyzing results, building forecasts and searching for growth points. Accompanying the launch of new features and ad-hoc analytics. Analytics CusDev. Building reports (SQL, Python) and dashboards (GDS) for making decisions based on data (Data-Driven). - Data engineering. Building a data warehouse (Data Warehouse) and a data mart (Data Mart) based on the Google Cloud Platform. ETL and ELT: development and implementation of data pipelines (Data Pipelines) in Apache Airflow. Big Data processing on Apache Spark (PySpark). - Data Science. Direct participation in the development of ML algorithms together with the R&D department. Exploratory Data Analysis (EDA) in SQL and Python (numpy, pandas, matplotlib, seaborn). Statistical analysis, search for patterns and hidden relationships in data (Python: scipy, statsmodels). Building predictive models: regression, support vector machine, ensembles of algorithms, clustering, etc. (Python: scikit-learn, CatBoost).

Marketing agency "Zolle"

Responsibilities: - Briefing and debriefing for the client: identifying goals and objectives in numbers, building plans and identifying KPIs; building hypotheses, due to which actions it is possible to achieve the desired results. - Digitization of marketing: building a system of end-to-end analytics and creating dashboards for data visualization and solving business problems. - Research of the target audience and identification of the most promising segments in terms of sales; - Study of the market and competitive environment. - Development of a marketing promotion strategy: selection of the most effective channels that can bring tangible results in the near future. - Elaboration of promotion tactics and setting tasks for traffic specialists: contextologist, targetologist, PR specialist, etc. - Building a system of regular reporting on the effectiveness of marketing channels, key indicators of funnels on the site, conversions, cohorts. - Formation based on the available data hypotheses to improve conversions for different sales funnels, participation in testing these hypotheses together with the marketing team, post-analysis. Achievements: - Managed a key client of the agency and increased its revenue by 5 times by optimizing advertising activities, increasing coverage and expanding the geography of sales. - Built a system of end-to-end analytics and implemented transparent reporting. - Built a healthy relationship with the client, within which we began to set realistic, feasible and ambitious plans. - Established the work of traffic specialists by setting clear tasks and competent budget planning.