Maksym Natalchuk Email & Phone Number

Kyiv, Ua

Kyiv, Ukraine

- Successfully provide informational support for coordinating the activities of the Food Security and Livelihoods Cluster (FSLC) of the United Nations in Ukraine in 10 regions of the country;- Facilitate high-quality and timely mobile data collection, form development, and data management from more than 30 non-governmental organizations (NGOs), which are partners of the FSLC, using Microsoft Excel, Power BI, Kobo Toolbox, RStudio. - On a regular basis, analyze the data on the food and livelihood activities, provided by more than 30 partner NGOs of FSLC, using Power BI, Excel, R;- Attend, organize and/or support more than 15 coordination meetings of the FSLC partners monthly;- Support, host and/or provide capacity building in-person and online trainings (in English and in Ukrainian) for partner organizations' representatives (for example, training on data management in Excel for national and international organizations in Ukraine);- Create PowerPoint presentations of the FSLC for coordination meetings, trainings, etc.- Create regular reports, maps, charts, graphs on FSLC activities provided, using ArcGIS, PowerPoint, Power BI, Excel, Word and internal organization tools;- Provide other information management activities, such as translations, mailing lists, reports, dashboards, newsletters, organograms, Terms of Reference, etc.);- Regularly support newcome colleagues and FSLC partner representatives with face-to-face consultations and trainings on data and information management, different software like Excel, Kobo, Power BI, PowerPoint, etc.

Remote

- using data cleaning methods in SQL, fixed the mistakes in analysis those wrong results affected healthapp effectiveness;- with the magic of Tableau, R, data analysis and presentations found a strategy to increase the numberof company's annual members up to 15% in one year.I have completed the Google Data Analytics Certification and two case studies based on this course:1. Analyze annual and casual memberships of a bike sharing company to make a decision how to increase the number of annual members (made in RStudio, Tableau and Google Slides). 2. Analyze health app usage to find trends that help make the app better and come on the global market (RStudio, SQL Server). The work was positively reviewed on Kaggle.Responsibilities:1. Importing all the data into one database (.csv to SQL or to R). 2. Reviewing all the data.3. Perform data cleaning (removing duplicates, checking data types, consistency, accuracy, spelling, extra spaces, completeness), processing, manipulations and additional calculations.4. Perform quantitative exploratory, statistical, cluster analysis using R, SQL Server or Excel.5. Make compelling visuals in Excel, RStudio or Tableau.6. Make presentations in Microsoft PowerPoint / Google Slides / Canva / Visme.7. Make clear insights based on the analysis and make some recommendations how to make a product better.8. Transform data insights into meaningful data-driven decisions.9. Provide reports (R Markdown, Jupiter Notebook).Skills improved:1. SQL Server (Intermediate, queries, window functions, common table expressions, mathematical and data functions).2. Excel (Upper Intermediate, macros, VLOOKUP, SUMIF, conditional formatting, data cleaning, visuals, analysis functions, pivot tables).3. R (Upper Intermediate, tidyverse, dplyr, lubridate, ggplot2 and other libraries).4. Tableau (Intermediate, charts & graphs, dashboards).5. Google BigQuery (Intermediate).6. Data analysis (full process from data importing to presentations).