National Transport Association, the largest bus passenger carrier in Russia with business in 11 cities and an annual traffic volume of 720 million passengers.- Created from scratch the dashboards and regular reports for company business in 2 new cities with key financial and transport metrics.- Automated the creation of regular reports, saving 14 hours of work per month.- Was responsible for 7 important dashboards in Power BI, had been optimising them, consulted stakeholders regarding their work.I can collect data, model pipeline and create dashboard of any complexity and take responsibility for data quality.

Wrote 5 large SQL queries using DuneSQL (dune.com);Prepared two large analytical projects with a presentation to investors on the situation on the NFT crypto loan market;Conducted web-analytics of the Startup's website using Google Analytics and Yandex Metrics.

Analyti (Datasfera), the company creates complex dashboards for marketplace sellers what covers their full sales analytics.- Сreated 3 new and significantly improved 1 dashboards in Power BI for different clients, connected them with clients’ sources.- Consulted clients regarding the functionality of dashboards, discussed clients’ needs at meetings.

- Performed due diligence analysis and identified tax risks on ₽40m for the Russian entity of German Company.- Successfully appeared in 6 court hearings, prepared legal position and with the team won about ₽2bn in total for the clients in the tax and customs disputes.I participated in different complex consulting and litigation projects as a junior and middle consultant. My daily tasks included working in Excel, writing legal and consulting texts, meetings with clients, business trips. Big part of the work was in English.