Направление: недвижимость- Комплексные и обширные исследования- A/B тестирование- ETL / Работа с объектами DWH: написание витрин, вью, оптимизация- Построение дашбордов- Систематизация: данных, отчетности, процессов- Ad-hocИнструменты: SQL, Vertica, Bitbucket (Git/stash), Redash, Python, RStudio, Excel, PowerQuery, JIRA, Confluence, Miro

Направление: недвижимость- Построение дашбордов- Ad-hoc- Небольшие исследования- Систематизация и построение аналитических процессов- Планирование и прогнозированиеИнструменты: SQL, Vertica, Bitbucket (Git), Tableau, Redash, Python, RStudio, Excel, PowerQuery, JIRA, Confluence, Miro

• Building and maintaining dashboards for the commercial and logistics departments • Ad hoc analysis in following areas: logistics and monitoring of transport, export of petroleum products, completeness and correctness of data in the 1C Enterprise system• Supervision of 6 existing projects of the bitumen business digitalization program. Working with teams within Agile. Product analytics, development and maintenance of product metrics, formulation and testing of hypotheses. Setting business requirements and prioritizing product backlogs based on the results of the analysis. Product examples:o Website for buyers of bitumen (b2b), CRM system for selling bitumen products through distributors, mobile application containing theory about bitumen productso Online marketplace with dynamic pricing mechanism (DS & ML)o A series of dashboards for the commercial department, creating a data warehouse. Tools: Excel, PowerQuery, Power Pivot, Power BI, DAX, Qlik Sense, Yandex.xn--metria-mrf, Google Analytics, RStudio, Atlassian Jira, Confluence, Miro, draw.io, 1С Enterprise, Python

BI, Dashboard building, Data analytics, Visualization, Building data models, Automation of data collection processesAchievements:• Built and maintained a dashboard on the performance of one branch in Power BI• Built and maintained a dashboard in Excel (PowerQuery) to analyze the factors influencing the marginal profit of a branch in various time frames from 2018 to 2021• Set up and maintained automation of data collection and implemented a project to visualize the financial performance of the Holding for 2019 - 2021 on the Power BI Report Server• Set up automation of data collection from contractors' acts (analysis of text documents using PowerQuery)Tools: SQL, MDX, Power BI, PowerQuery, Power Pivot, DAX, Excel, OLAP, Microsoft Dynamics AX (Axapta)

• Checked examination, control and test work• Drafted examination, control and test papers• Was a member of the commission that accepts examination and design work (oral defense, presentations)

Research project "Geovisualization of Regional Socio-Economic Indicators"• Supervised a group of 3 people• Searched and loaded data from OpenStreetMap, DivaGis• Calculated socio-economic indicators• Visualized the results obtained and provided 3 reports in the form of shapefiles, pdfs, xls and csv tables• Tools: (RStudio, Excel, QGIS, GeoDa)

- Conducted an economic analysis of the production and economic activities of the Company and its divisions in the MS Excel environment: - Compiled summary tables for contracts with counterparties - Compiled a reporting calculation of the actual costs of the state defense order for the maintenance of ships of the Russian Navy (MF) - Visualized the results obtained, made dashboards in Excel- Worked in the integrated information system (IIS) "Admiral"

Research project "Preparation of Analytical Materials on Key Trends in World Economic Development"• Supervised a team of 7 people• Collected data and formed a database for African countries in Excel• Calculated socio-economic indicators• Visualized the results obtained and compiled a brochure with an analytical overview of trends in the field of demography, living standards of countries• Tools: (RStudio, Excel)

Center of Applied Research in NRU HSEResearch project "Rating of 250 largest companies in the Northwestern Federal District"• Conducted a survey of 80 organizations (calls, emails)• Filled in the company database in the form of Excel tables• Worked with the Spark Interfax database• Prepared an analytical report on the surveyed companies in the form of a presentation• Tools: (Excel, PowerPoint)

• Conducted interviews with 7 foreign interns• Was engaged in the search and service of project partners (hostels, spaces, libraries, buddies) (Podio) | supervised 1 hostel, 2 foreigners• Was engaged in paperwork for trainees• Organized and conducted 2 culinary master classes | made a schedule of events for 4 weeks | organized a Halloween celebration at the hostel site• Organized conversational English courses with trainees as teachers• Maintained pages on social networks dedicated to the project and did advertisements for partner organizations (Facebook, Instagram, Vkontakte)