Vera Shcherbina Email & Phone Number

Edinburgh, Gb

Edinburgh, Scotland, United Kingdom

Remote

Data insights analyst. I regularly do projects for Social Element, Canvas8 and Freemavens.• Analysed social media content related to the pharmaceutical company brand (2019) available on Facebook, Twitter, VKontakte, and Instagram; identified and constructed portraits of 4 types of customers to inform the brand strategy for the target market.• Worked collaboratively with a distributed team of 4 members (based in Russia, Poland, Japan, and France) to discuss the marketing insights findings and create a final report. • Designed and delivered a PowerPoint presentation and Excel document reporting on findings in line with the client’s requirements.• Successfully performed customer perception analysis for the Coca-Cola brand (2022) in the Russian market, using web tools such as Keytool, Brandwatch, Crimson Hexagon, Affinio, Yandex.Direct.• Developed a Google Slides presentation highlighting the key findings for the target market.

Edinburgh, Scotland, United Kingdom

R programming language: Data wrangling and analysis (tidyverse)Data visualisation and interactive visualisation (ggplot2, RShiny)Geospatian mapping (Leaflet), Basics of model building and machine learningText mining and manipulationPythonJupiter Notebook

• Performed data mapping, analysed fact sheets and financial disclosures using advanced Excel functions.• Worked collaboratively with the team on Proxy Solicitation projects, liaising with Goldman Sachs, JP Morgan Chase, Mitsubishi UFJ, and Société Générale to forecast the shareholders’ voting results.• Successfully identified the underlying shareholder structure including beneficial holders, investment decision-makers, and vote mandate holders for a wide range of world-leading companies such as Nokia, VTB, Wolters Kluwer, Nordea, and Lukoil.• Liased with client companies and banks across borders (USA, Spain, Russia, and Japan) including Barclays, UniCredit, HSBC, Citibank, and Credit Agricole obtaining relevant information and updating the shareholder database.

Intern at proxy solicitation team.Data mapping (Excel)Translating market reports and contracts (Eng/Rus).Research, obtaining contacts in Russian and English.

Stoke-On-Trent, United Kingdom

Project role.Delivering localised translations of the company website content (Eng/Rus) and legal documents (Rus/Eng) according to the company policies, requirement and guidelines. Working with texts consisting HTML-tags, and with various software (OmegaT, MS Excel, Dreamviewer). Proofreading and quality control of the translations.

London, United Kingdom

Project role.Creating and posting SEO-optimised content in Russian for the company website and social media channels according to guidelines, working with images and photos. Analysing the website data to gain customer insights.

Moscow, Moscow City, Russia

Prepared custom qualitative research reports (in English and Russian), based on user-generated content, according to clients’ needs and budgets. Research techniques included real-time online-listening, competitor research, reputation research and insight analysis. Selected, hired, mentored and supervised a remote team of analysts (11 team members): statisticians, content-analysts, a proofreader, a designer, and a translator.Managed the team, helped with testing new service features.Efficiently delivered services to client companies including: Nokia, Sanofi, Danone, L’Oreal, Ford and others.KEY ACHIEVEMENTBuilt a successful team to provide social media insight analysis to companies engaged in food, pharmaceutical, cosmetics, electronic, automotive and service industries.

Moscow, Russian Federation

Created and proposed business strategies for the project. Administered SEO campaigns, project website, book reviews, blog posts and wrote SEO-optimised texts.Lead a web-based crowdfunding campaign for the project “Tramway – Reprint”. Actively communicated with translators and designers, researched copyright law questions, also dealt with manuscripts and old out-of-print books.KEY ACHIEVEMENT— Republished Tramway, a Russian illustrated magazine for children which initially was issued in 1990-1995, was made by most talented and wittiest authors and artists and was extremely popular with the whole generation. There were 5 books published by us (each included 12 monthly issues of the magazine, from 1990 to 1995, and a foreword written by the former Chief Editor, with memoirs how the magazine had been made). It became the company's signature project and brought it a lot of media attention. Over 50,000 copies were sold, with orders from the whole ex-Soviet Union and beyond.

Managing daily film crews’ schedules, developing ideas and topics for a TV show, communication with subject matter experts and production management assistance. News fact-checking.

Moscow, Russian Federation

Story assistant, script coordinator. Archive research (photo and video materials). Audio&video transcriptions, story editing, simple video editing.

Moscow, Russian Federation

Moscow, Russian Federation

Copywriter in online-game “Rushka” (stock exchange training emulator). Writing satirical and parody news, interacting with users, users’ tech support.

Data Analytics Essentials

A full-time coding boot camp.

Master Of Science (Msc), Web Science

Relevant modules • Foundations of Web Science (sociotechnical theories) • Further Web Science (contemporary issues) • Interdisciplinary.

Master Of Arts (Ma), Religion/Religious Studies, 4.4 Out Of 5.

Relevant modules: • Logic (history of logic, argumentation theory, propositional and first-order logic) • Advanced maths • Psychology.