Іван

Ivan Dehtiarov
Data Analyst
📍 Kyiv, Ukraine | 📞 Telegram| ✉ [open contact info](look above in the "contact info" section) | 🔗 LinkedIn

Professional Summary
I'm an enthusiastic data analyst with a strong foundation in database management and data visualization tools. I specialize in turning
raw data into actionable insights that support strategic decision-making. With a background in procurement and project management,
I bring a unique business perspective to analytical work. Passionate about data-driven storytelling, I enjoy uncovering trends,
optimizing processes, and supporting cross-functional teams with clear, impactful reporting.

Skills Projects
• Spreadsheets (Google Sheets, 📌 Coffee Sales Dashboard (Google Sheets | SQL Logic) – [Mar 2025 – Apr 2025]
MS Excel); • Performed a data-driven analysis of daily coffee sales from a vending machine.
• SQL (Google BigQuery, MySQL, • Answered key business questions using spreadsheet formulas and SQL-style
logic to uncover revenue patterns, transaction types, product popularity, and
PostgreSQL);
customer behavior.
• Visualization Tools (Tableau); • Presented insights with dynamic charts and tables in Google Sheets.
• Python (Numpy, Pandas, Scipy, 📌 Videogame Sales Analysis (SQL | BigQuery) – [Mar 2025 – Apr 2025]
Matplotlib, Seaborn)
• Analyzed 40 years of global video game sales data to uncover market trends,
• Statistics; regional preferences, and publisher strategies.
• Product Metrics; • Used advanced SQL techniques in BigQuery to answer business-relevant
• GitHub. questions about platform popularity, genre distribution, and release timelines.
• Documented insights with annotated queries in Jupyter Notebook.

Languages 📌 Global Salary Insights Dashboard (SQL | Tableau) – [Mar 2025 – Apr 2025]
• English – B2; • Processed and cleaned international salary data using SQL.
• Explored trends across countries, job titles, age groups, education levels, etc.
• Spanish – A2;
• Designed an interactive Tableau dashboard to highlight salary distributions,
• Ukrainian – Native. uncover patterns tied to career progression and education, etc.
• Enabled dynamic filtering and metric selection for deeper user-driven
exploration.
Education
🎓 Master’s Degree, International
Economic Relations
Taras Shevchenko National Experience
University of Kyiv – [Dec 2024] 🏢 Procurement Manager / Deputy Team Lead of Procurement Unit
Internews Ukraine – [Sep 2023 – Mar 2025]
🎓 Bachelor’s Degree, International Key Responsibilities:
Economic Relations • Preparation of requests for donor approval of the selected suppliers;
Taras Shevchenko National • Tender database management;
University of Kyiv – [Jun 2023] • Preparation of procurement documentation.
Achievements:
• Integrated tender and supplier datasets in Google BigQuery;
• Utilized SQL to query information about suppliers;
• Conducted 150+ market analyses and bidding processes.