Elena Ustimenko Email & Phone Number

Barcelona, Ct, Es

Barcelona, Catalonia, Spain

- Ad Campaign Setup: Implementing ad campaigns tailored to clients' KPIs and specific requirements.- Data Analytics: Conducting in-depth data analysis to uncover insights, suggest enhancements, and compile comprehensive reports.- Campaign Optimization: Performing A/B testing on various settings and features to optimize campaign performance.- Collaborating with Sales, Account Management, Creative, and other teams to ensure top-tier service for clients.

- Conducting hypothesis testing to validate business assumptions and measure the efficacy of new initiatives- Creation of calculators and dashboards in Microsoft Excel and Google Sheets- Cohort and LTV analysis- Calculated different indicators and metrics using PostgreSQL: window functions, subqueries, aggregate functions, CTE etc. - Reports: preparing materials and presenting them via video-callsKey achievements:- Completed 4 study cases using Microsoft Excel, Google Sheets and PostgreSQL- Prepared 2 final reports with data visualization and presentations (Retail points functioning / GameDev)

Barcelona, Catalonia, Spain

- Luxury property management. Costs analysis and costs optimisation. Negotiation with suppliers/sellers/buyers.- Administrative support for the company. Customs clearance of merchandising. Office maintenance and supplies.- All kinds of documentation procedures & visas for Spain and other countries- Organisation of day-to-day activities for CEO and their extended family anticipating any possible needs - Organisation of business & holidays trips at all stages- Coordination of staff (driver, cleaning & maintenance). HR (posting jobs, selecting and interviewing candidates).

Barcelona Area, Spain

- Clients database analysis. Marketing&advertising management. Negotiating special conditions and closing agreements. Completing bureaucratic procedures to purchase advertising space from local authorities.- Project planning of concert tours across Europe. Choosing the most suitable venues for existing programme. Coordinating logistics and calculating budget.- Negotiation with Portuguese venues (theatres and concert halls). Closing agreements on dates, programme and venue conditions.- Proofreading contracts. Key achievements:- Launched 2018-2019 marketing&advertising campaigns in 35 cities of Spain and Portugal for more than 250 concerts. - Planned 3 orchestra tours and 2 ballet tours in Portugal for season 2019-2020- Closed agreements with 11 main venues in Lisbon, Porto, Braga and other locations.

Moscow, Russian Federation

- Administrative tasks (planning and paperwork)- Language assistance (translation from/to English and Spanish)- Inspection of flags and fan performance requests according to operational policies and procedures. - Match-day inspection of security staff performance.Key achievements:- Learnt how major sport events work from the inside: procedures, paperwork, communicating with FIFA on a daily basis.

Master'S Degree, Sport Management

Master'S Degree, Sport Management

Bachelor'S Degree, World Economy