Senior Data Analyst

• Jul 2023 - Present

Product Analyst

• Oct 2022 - Jun 2023

Have evaluated business-intelligence platforms and picked one, Preset, for company-wide use.Perform analysis of experimental and observational data.Transform, model and validate data with Snowflake and Preset and expose it to business users.Extract data from tools like Google Analytics, Google Optimize, and B2C, B2B and recruiting CRM systems.Educate the team on self-servicing in data analytics.

Data Analyst @Ride-hailing Driver Experience (SQL, Looker, R)

• Sep 2018 - Jul 2022

Built SQL/Looker-based data layers for the driver retention model, the driver leads funnel, and the recency, frequency, and monetary value (RFM) tool. Conducted and supported multiple A/B tests in the domain of driver experience. Developed in-house software package (R programming language) for querying data from AWS Redshift database and Google Cloud Looker API. Represented and defended the interests of data analysts while developing new features with product managers and engineers. Built data visualizations used by C-level executives and the public policy team. Supported local operation teams across 50 countries with analytics and reporting in Looker BI. For team members, delivered learning sessions on Looker, R, SQL and the relational model. Show less

Managing partner / R developer

• Feb 2016 - Aug 2018

Ad-hoc research, analytical and training projects, and developing data science products. - Developed an R package to accept online payments in web applications through Paymill API (http://bit.ly/paymiller). - Developed R package to manage users in web applications through Backendless API (http://bit.ly/belpkg). - Developed R Shiny web application to run automated univariate time series forecasts (http://bit.ly/forecastbox). - Developed R package to maintain personal job history and to build vacancy-specific resumes (http://bit.ly/resumer1). - Developed R package to retrieve through Wikipedia API word pronunciation transcription and audio from English Wiktionary (http://bit.ly/dictr1). - Conducted hands-on seminars on various R topics for the R Ladies Tbilisi group. - Developed demo R package to extract time series data from official Excel reports of the Kazakhstan Committee of Statistics (http://bit.ly/readxldemo). Show less

Statistician (remote)

• Oct 2016 - May 2017

Technical support in the conversion of food commodity codes from WTO and EU standards to FAO classification: - Extraction of vast pieces of FAO experts' knowledge on world trade over a period of 14 years, stored in semi-automated, poorly documented databases. - Software package updated to convert world food trade data from the WTO Harmonized System and the EU Combined Nomenclature Technical support in the conversion of food commodity codes from WTO and EU standards to FAO classification: - Extraction of vast pieces of FAO experts' knowledge on world trade over a period of 14 years, stored in semi-automated, poorly documented databases. - Software package updated to convert world food trade data from the WTO Harmonized System and the EU Combined Nomenclature

Data Scientist

• Feb 2015 - Dec 2015

Developing a statistical methodology to evaluate and correct annual world trade data and to estimate per-country food reserves. - Methodology developed to align trade data presented in various commodity classifications (WTO HS, EU CN, FAO FCL), area nomenclatures (UN M49 and its variations, EU Geonomenclature, FAO area list). - Software package created to process trade data, convert multiple units of measurements, detect outliers and impute missing values. - Usability inspection role during the development of in-house data warehouse solution. - Interactive data visualization tool created to evaluate trade reports quality. - Training and consultations in data processing, visualization and R statistical software. Show less

Senior Lecturer

• Oct 2011 - Jan 2015

Lectures and seminars in Data Analysis and Marketing Research. - Hands-on courses on Statistics for Public Relations specialists employing R software developed and conducted. - Courses for adults on Marketing Research with the participation of students in real-world projects developed and conducted. Lectures and seminars in Data Analysis and Marketing Research. - Hands-on courses on Statistics for Public Relations specialists employing R software developed and conducted. - Courses for adults on Marketing Research with the participation of students in real-world projects developed and conducted.

Data Analyst / Consultant

• Nov 2009 - Jan 2015

Various ad-hoc projects in fields of sociological research, data analysis, training delivery, and software systems: - Optimization of pizza order delivery with queue and spatial-temporal modelling. - Natural language processing and regression modelling based on data from the Russian-language social network Odnoklassniki. - Mining association rules and frequent itemsets for pizza restaurant chains. - Series of seminars on R basics, data processing, and data visualization for higher education audiences. - Webinars on marketing research, public relations, and IT applications for small enterprises. - Analysis of family (genealogy) data with prototype-based programming. - Visual interactive spatial analysis of the legitimacy of house distribution by electoral districts. R-script converts all registered addresses of voters in the city into coordinates, draws the distribution of houses for each district and allows users to get information about outliers. - Interactive web reports with Shiny-server at Amazon Web Services (server.r: http://bit.ly/mav110, ui.r: http://bit.ly/mav112). - Presentation “Creating of cartograms based on Grammar of Graphics with R-package ggmap” at the conference “Open GIS” in Moscow, Russia (slides in Russian bit.ly/mav103). - Seminar “GNU/Linux Ubuntu for system administrators of marshal service” in Pskov, Russia (video in Russian bit.ly/mav101). - Adaptation of open-source software for small businesses (WordPress, Magento, SugarCRM, LimeSurvey). Show less

Data Scientist

• Aug 2011 - Aug 2013

Essential function: processing opinion poll data, statistical analysis and producing reports. - Saved at most minuscule 84 man-hours by developing R-code to generate reproducible reports for every from 28 districts of the region based on opinion poll data (R-code: http://bit.ly/mav108, template: http://bit.ly/mav109). - Made significant improvements in exit-poll procedure: got the Institute rid of the necessity to hire temporary telephone operators (8 men / 96 man-hours), increased speed of update of the report (close to real-time), enriched the report with dynamic interactive charts and tables (R-code: http://bit.ly/mav106). - Implemented previously unused in the Institute data visualization with high-scale city maps without software license expenses (OpenStreetMap data, R + QuantumGIS). - Increased speed and accuracy of manual data input from paper-based questionnaires by replacing storing data in separate files for each operator with a single database (MySQL + LimeSurvey). - Evaluating of the Data Documentation Initiative specification as standard for documentation for opinion-poll datasets in the Institute. - SPSS technical support and consultations. Show less

Expert in marketing research

• May 2008 - Dec 2010

- Training and consultations of educational facilities staff in sociological and marketing research. - Developing a software system for questionnaire design, opinion poll data input and computing descriptive statistics (based on LimeSurvey and queXML). - Composing a manual for staff of educational facilities on methods of sociological research and using of the developed system. - Training and consultations of educational facilities staff in sociological and marketing research. - Developing a software system for questionnaire design, opinion poll data input and computing descriptive statistics (based on LimeSurvey and queXML). - Composing a manual for staff of educational facilities on methods of sociological research and using of the developed system.

Head of Sociological Lab

• Nov 2004 - Aug 2010

Management of sociological research projects. Marketing research training. Start to use R in the field of research projects and the education of students-sociologists. Delivering training on the OpenOffice.org suite for the teaching staff. Engaging in negotiation with representatives of the Council of the Baltic Sea States. Management of sociological research projects. Marketing research training. Start to use R in the field of research projects and the education of students-sociologists. Delivering training on the OpenOffice.org suite for the teaching staff. Engaging in negotiation with representatives of the Council of the Baltic Sea States.

Communications Coordinator

• Jun 2005 - May 2006

Journalist

• Jun 2002 - Oct 2002

Teacher of computer skills

• Apr 2002 - May 2002