Olga Andreeva Email & Phone Number

Moscow, Russia

• Development of Global Dashboards in Tableau, MicroStrategy (all stages)• Creation of data models on SQL,, optimization of SQL code• Communications with stakeholders, requirements gathering • Bug fixing in existing dashboards• Leading Tableau Developers community • Writing Python Scripts for automation• Mentoring newcomers in the teamAchievements:✔ Created ecosystem of dashboards (7 dashboards) describing business processes in B2B department that became the most popular at Gett✔ Build strong relationships with stakeholders and highly improved requirements gathering process. It increased the speed of development and made customer satisfaction higher✔ Made BI Server optimization multiple times, which is improved server stability✔ Global BI Team was awarded for collaborative work on migration project to the new server (‘Ninja Award’)

Moscow, Russia

Moscow, Russia

• Regular and ad-hoc reporting, dashboards based on CRM data• Data quality check of CRM data, loading data to the system• Routine task automation (programming on R)• Analysis of contract profitability and department budgets• Creating presentations in Power Point• Communications with global teamAchievements:✔ Automated process of data collection in RStudio for 5 analysts - time reduction from a few hours to 15 minutes for each analyst✔ Implemented dashboards from scratch – the growth of the data-driven culture in On Premise Department✔ Conducted more than 30 trainings for managers and sales representatives (topics: reporting, CRM, data visualization in presentations)

Moscow

Duties:♦ Regular reporting in Excel;♦ Oral and written consultation about made reports;♦ Consolidation of information from distributors and sales representatives;♦ Bringing information to the established standards;♦ Regular checking of the quality of the provided and stored data on reliability, validity, consistency and completeness;♦ Correction of errors in the database (MS SQL Server);♦ Analysis of the effectiveness of the regional teams.Key achievements:✔ Developed methods of detection of database errors (more than 1500 errors detected and corrected);✔ Improved report from manual filling to automate filling by macros.Note: I was hired for the duration of the project, which was completed at the end of 2015.

Moscow

Duties:♦ Data analysis based on data from Yandex.Metrica and Google Analytics;♦ Market research of target audiences and competitors;♦ Translating English content into Russian for publication on the site;♦ Collecting key words for promotion (yandex.words);♦ Making recommendations devoted to developing services, structure and marketing communications of Avtology website.Key achievements:✔ Conducted internet-survey of automotive B2B-segment and analysis of potential auditory;✔ Identified the current position of the site in a competitive environment;✔ Determined key promotional channels;✔ Developed promotional strategy.Note: I worked as an intern while studying.