⚡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

Forecasting and generating quarterly sales plan indicators

Administration, updating and development of files for 50+ people

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

ETL/ELT for loading data into DWH

Automation of operational reports to email

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

Creating consolidated sales reports

Calculating net growth by clients

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

B2B commercial reporting DVL (50+ users)

B2C motivational reporting (100+ users)

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

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

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

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

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

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

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 users

projects

Main responsibilities

Functionality planning and testing

Functionality and requirement validation

Bug and issue documentation

🐍

Python Developer

Developing solutions for practical business tasks

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

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

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

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

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

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

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

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

projects

Main responsibilities

DWH architecture implementation (Staging/Core/Marts)

Building ETL/ELT pipelines

Process setup and automation