Top of page

⚡Skills & Competencies

Detailed overview of technical skills with usage examples

💻Key tools and technologies

📊

Excel

Working with spreadsheets, data analysis and automation

4 years
commercial experience

📊 Skill levels

Basics
Formulas and functions (IF, VLOOKUP, INDEX, etc.)
Filtering and sorting, conditional formatting and dropdown lists
Creating charts and graphs
Advanced
Pivot tables
Multi-level formulas and arrays
Protection and access restrictions
Automation
Links to external spreadsheets
Power Query to databases/Power BI
Automatic reports and dashboards

💡 Usage examples

1

Forecasting and generating quarterly sales plan indicators

2

Administration, updating and development of files for 50+ people

3

Creating navigation and multi-page reports

🐍

Python

Process automation, data processing and solution development

4 years
commercial experience

📊 Skill levels

Data Processing
Pandas for data manipulation
Openpyxl for working with Excel
Connectors to relational databases
API & Integration
Requests for interacting with internal and external resources
Google Cloud/Microsoft Graph for integrations
Data collection from open sources
Automation & ETL/ELT
Selenium for web automation
ETL/ELT pipelines for DWH
Orchestration, logging and monitoring

💡 Usage examples

1

ETL/ELT for loading data into DWH

2

Automation of operational reports to email

3

Data collection from open sources for strategic projects

⚡

SQL/Databases

Working with relational databases, creating queries and data analysis

2 years
commercial experience

📊 Skill levels

Basic
Data selection (SELECT, FROM, WHERE)
Data aggregation (GROUP, HAVING, CASE)
Subqueries (WHERE, IN, EXISTS) and JOIN relationships (LEFT, RIGHT, FULL)
Advanced
CTE (Common Table Expressions)
Window Functions (ROW_NUMBER, RANK, LAG)
Query optimization, execution plan analysis (EXPLAIN)
DWH Architecture
Building DWH architecture (Staging/Core/Marts)
Procedures, Views, Indexes
Indexes (B-Tree, Composite, Covering Index)

💡 Usage examples

1

Creating consolidated sales reports

2

Calculating net growth by clients

3

Creating DWH for business tasks

📊

Power BI

Creating interactive dashboards and data visualization

1.5 years
commercial experience

📊 Skill levels

Basic
Creating interactive dashboards
Filters and slicers
Calculated fields and measures
Advanced
Connecting to various data sources
Data modeling and relationships
DAX expressions
Administration
Setting up automatic refresh
Row-level security (RLS)
Report subscriptions for users

💡 Usage examples

1

B2B commercial reporting DVL (50+ users)

2

B2C motivational reporting (100+ users)

3

Operational control of SLA and indicators

🛠️Additional tools and technologies

📝

Microsoft Word

Description, creation and development of documents, instructions and technical documentation

📧

Microsoft Outlook

Corporate email communication, organizing meetings in calendar

💬

Microsoft Teams

Efficient communication and teamwork

📋

Jira

Management of development team projects and tasks

🔧

Git

Centralized code repository and version control

📊

PowerPoint

Creating training, commercial and reporting presentations

📐

Visio

Systematization, description of diagrams and business process schemas

📱

Telegram API

Using API for chat bots and sending messages

🤖

HuggingFace

Search, analysis and work with AI/LLM models

🗺️

Google Maps API

Working with geolocation data

🔗

Microsoft API

Using API for Microsoft services - Excel, Emails, Power BI

📋

Forms

Creating forms for systematic work with users and data

✅

Todoist

Task management, planning and prioritization, operational reporting

🧠

LM Studio

Working with local AI models, building AI endpoint APIs

🔍

Dev Tools

Analyzing web page elements, viewing errors, spot testing

🎯Work Areas

🔍

Analysis

Data analysis and business insights

19
projects
• Telegram channel analysis with advertising placement effectiveness assessment
• Forming cold B2B contact base with subsequent result evaluation
• Competitive environment research in Kyiv: analysis of 35 providers for PON network strategy
⚡

Optimization

Business process optimization and work efficiency improvement

19
projects
• CRM AppSheet: saving 1.5 hours/day/employee daily by Field Operations automation
• Network dislocation correction: developing process for data entry and address data correction for 500+ users
• Creating Excel dashboard for B2C department head for team convenience and routine optimization
⚙️

Automation

Automation of business processes and routine operations

18
projects
• SLA notification: automatic daily sending of emails about SLA violations to managers
• Plan-Actual+Forecast: daily automated sending of plan execution status
• Telegram bot for work time tracking: automatic time tracking and reminders
🎯

Strategy

Strategic planning and management decision making

17
projects
• Network reservation in Kyiv: determining strategy for providing internet without electricity
• Forming cold B2B base: strategic support for new client development
• Building department DWH: architectural planning of centralized data warehouse
📊

Data Visualization

Creating interactive dashboards and reports for managers and executives

16
projects
• B2B Power BI commercial reporting: motivational reporting for 50+ users
• B2C Power BI reporting: operational control for 100+ users
• Telegram Power BI analytics: UTM analysis and sales funnel
🔬

Research

Conducting in-depth research and presenting findings and conclusions

11
projects
• Competitive environment research in Kyiv: analysis of 35 providers for PON network strategy
• Local AI/LLM research: testing 15 models in 10 different tasks
• Telegram channel analysis: research of marketing channel effectiveness

👥Roles and responsibilities

🔍

QA

Ensuring proper functionality quality for internal and external users

22
projects

Main responsibilities

Functionality planning and testing
Functionality and requirement validation
Bug and issue documentation
🐍

Python Developer

Developing solutions for practical business tasks

20
projects

Main responsibilities

Python application and script development
Business process automation
Integration with internal and external systems
📈

Data Analyst

Data analysis, report creation, and business insight presentation

12
projects

Main responsibilities

Creating reports and dashboards
Data analysis and pattern identification
Working with analytical tools
🎨

UI/UX Designer

Designing user interfaces for systems and dashboards

10
projects

Main responsibilities

Visual concept and prototype development for Excel/Power BI reporting
Creating positive user experience when working with analytical tools
UX optimization for complex data and metrics in Power BI and Excel
🎯

Product Owner

END-TO-END product management and development

8
projects

Main responsibilities

Product management from concept to implementation
Interaction with end users and stakeholders
Initiative and feature evaluation, task and development prioritization
🤖

Web Developer(AI-coding)

Web solution development using AI

5
projects

Main responsibilities

Describing concept, structure and step-by-step actions for AI
Web application development using AI
Testing and validation of developed AI functionality
📊

Business Analyst

Workflow analysis and optimization

5
projects

Main responsibilities

Current business process analysis
Developing new or optimizing existing business processes
Justifying proposed solutions
👤

Researcher

Conducting context research to ensure effective delivery of business value

5
projects

Main responsibilities

Analysis and pattern identification
Hypothesis formation and verification
Business conclusion justification
📊

Power BI Developer

Creating interactive dashboards and data visualization for business

4
projects

Main responsibilities

Dashboard and report creation
Working with DAX and Power Query
Training users to work with the tool
⚙️

Data Engineer

Building infrastructure for further data work

3
projects

Main responsibilities

DWH architecture implementation (Staging/Core/Marts)
Building ETL/ELT pipelines
Process setup and automation