• Developed in-house R package for streamlining connections with Looker API and RedShift. • Developed an approach for spatial heatmaps overcoming limitations of Redshift and Looker. • Prepared visualizations for communication with investors and policymakers. • Developed compliance reports for Transport for London and other governmental bodies. • In SQL/Looker, implemented various reports including driver retention, life cycle value, the RecencyFrequency-Monetary classification. • Coordinated the technical implementation of a company-wide business metric. • Estimated the business impact of planned product features through A/B experiments and historical data analysis. • Identifying information needs of business users and city teams.

• Extraction of vast pieces of FAO experts’ knowledge on world trade for 14 years, stored in semiautomated, poorly documented databases. • Software package updated to convert world food trade data from the WTO Harmonized System and the EU Combined Nomenclature.

• Developed 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 retrieve through Wikipedia API word pronunciation transcription and audio from English Wiktionary (http://bit.ly/dictr1). • Conducted a series of hands-on seminars on various R topics for the R Ladies Tbilisi group. • Developed R package to maintain personal job history and to build vacancy-specific resumes (http://bit.ly/resumer1). • Developed demo R package to extract time-series data from official Excel reports of Kazakhstan Committee of statistics (http://bit.ly/readxldemo).

• 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). • Training and consultations in data processing, visualization, and R statistical software. • Software package created to process trade data, to convert multiple units of measurements, to detect outliers, and to 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

• Face-to-face practical training on data processing and visualization. • Developing R-functions to gather data from Oracle DB (http://bit.ly/mav113). • Evaluating legacy R-code for duplication, performance optimization.

• 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.

• Questionnaire design, sampling, data analysis, and visualization in longitude household research. • Saved at least 84 man-hours by automation of preparing reproducible reports for each of 28 districts of the region based on opinion poll data. • Made significant improvements in exit-poll procedure: got the Institute rid of a 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. • 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). • Evaluated the Data Documentation Initiative specification as standard for documentation for opinion poll datasets in the Institute. • SPSS technical support and consultations.

• Series of seminars on R basics, data processing, data visualization for higher education audience. • Numerous field projects employing focus groups, face-to-face interviews, phone interviews, observation, cabinet research. • Wide range of full-cycle research projects on marketing and political topics. • Webinars on marketing research, public relations, IT applications for small enterprises. • Seminar “GNU/Linux Ubuntu for system administrators of marshal service”. Pskov, Russia. • Optimization of pizza orders delivery with queue and spatial-temporal modeling. • Mining association rules and frequent itemsets for a pizza restaurant chain.

• Trained and consulted educational facilities staff on topics of sociological and marketing research. • Composed a manual for staff of educational facilities on methods of sociological research and using of the developed system. • Developed and managed research project on needs of Small and Medium Enterprises. • Developed a software system for questionnaire design, opinion poll data input, and computing of descriptive statistics (based on LimeSurvey and queXML).

• Started to use R in the field of research projects and the education of students-sociologists. • Developed training materials for the Develop Your Business programme in partnership with the Swedish Institute of Management and Stockholm School of Economics in Saint-Petersburg. • Conducted fieldwork and data analysis in project Social problems of informal economy development in near-border villages of Chudskoe lake project in partnership with EURASIA Fund. • Organized full-cycle research project on pupils’ preferences in higher education. Results were broadly discussed in local mass media. • Codeveloped and comanaged External EU Border Monitoring Project: Better Efficiency at Border Crossing Points as a Precondition for the Improved Cross-border Cooperation. • Execution of research projects for external clients provided the Institute with additional income. • Delivered training and technical support on OpenOffice.org software suite for the teaching staff. • Engaged in negotiation with representatives of the Council of the Baltic Sea States. • Organized Students Schools in the frame of Youth Democracy Development programme by Olaf Palme Foundation (Sweden).

• Pupils got intensive computer skills course and were able to get a pass.