Roman Shipovskoy

Creation of reports in Power BI with KPIs of department productivity ( automated preparation - implementation to existing reports - delivered to stakeholders) data structure optimization for better efficiency and work stability of reports (SQL query enhancement) data extraction and preparation for the analysis from different sources (SAP HANA, SAP Cloud, MSS) Text analytics of customer feedback (automated machine translation of comments, segmentation of topics, sentimental analysis, defining keywords)

8-month studies and work with actual employees of Yandex in data analysis groups in the field of product analytics -A/B testing for e-commerce -Cohort analysis, LTV/CAC/ROMI metrics calculation -Data science and predictions projects -Analyzing current advertising market in mobile games -Creation of Tableau Dashboards -Setting pipelines SQL-Python-Visualization tool

- Creation and conduction of surveys for medical companies - Survey data analysis - Cration reports for the customers with the results of survey in Power BI - Preparation of consolidated tables

- Working in the sphere of social media marketing - Setting targetting instuments to increase KPIs of marketing - Preparation of reports with the results of ads campaign (convertion rate, LTV, CAC) - Reporting about best ways of ads optimization - Creation of dashboards with spend analysis