Volodymyr Gorovet

Offer Volodymyr work on your next project.

Kyiv, Ukraine

3 days 13 hours back

available for hire

on the service 1 year

Rating

Successful projects

Average rating

Rating

Social Media Page Design

256 place out of 1843

Databases & SQL

145 place out of 1204

Language proficiency level

Skills and abilities

Programming

Databases & SQL

Writing

Portfolio

SQL Query Optimization (Performance Improvement)

SQL Query Optimization (Before / After)

BEFORE (slow and unoptimized query)
SQL
… SELECT *
FROM orders o
WHERE o.customer_id IN (
SELECT customer_id
FROM customers
WHERE status = 'active'
)
AND o.order_date = (
SELECT MAX(order_date)
FROM orders
WHERE customer_id = o.customer_id
)
Problems:
use of subqueries in WHERE
repeated table scans
low performance on large data
AFTER (optimized version)
SQL
SELECT o.*
FROM orders o
JOIN customers c
ON o.customer_id = c.customer_id
AND c.status = 'active'
WHERE o.order_date = (
SELECT MAX(o2.order_date)
FROM orders o2
WHERE o2.customer_id = o.customer_id
)
Improvements:
replacement of IN with JOIN
fewer repeated calculations
better performance on large tables
more readable structure
Result:
query speed ↑ by 30–70% (depends on data volume)
less load on the database
easier scalability
Data extraction from PDF and conversion to Excel

Data extraction from PDF and conversion to Excel
Task: Convert data from PDF documents into a convenient format for analysis.
Problem:
data was in unstructured PDFs
… tables were misaligned
manual copying took a lot of time
Solution:
data extraction from PDF
structuring information into tables
conversion to Excel / CSV format
preparation of data for further analysis
Result:
fully structured data
automation of manual work
ready files for use in analytics or databases
Data processing and automation in Excel

Data processing and automation in Excel
Task: Process large tables and prepare structured data for analysis.
Problem:
chaotic data in Excel
… manual processing took a lot of time
errors in copying and filtering
Solution:
cleaning and structuring data
automation of table processing
use of formulas and data processing logic
optimization of file structure
Result:
significant reduction in processing time
clean and structured data
ready files for analysis
Data collection automation (parsing 24/7)

Data collection automation (parsing 24/7)
Task: Implement continuous data collection from the website.
Problem:
frequent requests to Google Sheets API
… stopping due to limits
unstable operation
Solution:
added record buffering
moved storage to SQLite
optimized synchronization frequency with Google Sheets
Result:
stable operation 24/7
no freezes
fast data processing
SQL optimization and data processing

Databases & SQL

Task: Processing a large volume of data and building reports. Initial queries were slow and created a load on the system.
Problem:
Slow SELECT queries
High load on the database
… Lack of optimization (JOIN, indexes, aggregations)
Solution:
Rewrote SQL queries (optimized JOIN, WHERE, GROUP BY)
Used indexes for acceleration
Reduced the amount of processed data
Optimized calculation logic
Result:
Acceleration of queries by 3–5 times
Reduced load on the database
Stable operation with large volumes of data
Technologies: SQL (Oracle / PostgreSQL / Hive), query optimization, data analytics
Examples of optimization:
-- Was
SELECT * FROM table

-- Became
SELECT col1, col2
FROM table
WHERE date >= CURRENT_DATE - 30
The world of video games — like the life of the future.

The World of Video Games: How Games Became More Than Just Entertainment

Just a few decades ago, video games were considered a simple way to pass the time. Primitive graphics, simple mechanics, limited possibilities — all of this was perceived as children's entertainment or a short-term hobby. But with technological development, the situation has changed dramatically: modern games have become true works of art that combine cinematography, music, literature, and interactive experience.

… The Influence of Games on Culture

Today, the gaming industry not only competes with cinema and music — it surpasses them in profits. Major releases like The Last of Us, Elden Ring, or Cyberpunk 2077 attract millions of fans worldwide. But the essence is not only in revenue — games are shaping a new cultural reality. Cosplays, fan art, themed events, music from games — all of this is becoming part of the daily life of millions of people.

Gaming as a Means of Communication

Multiplayer games connect players from different continents. Communication in online battles, team cooperation, creating guilds and communities — all of this opens new horizons for social interaction. For many people, video games have become a tool that helps find friends, develop communication skills, and even learn foreign languages.

Educational and Therapeutic Potential

Few know, but games are actively used in education. For example, Minecraft: Education Edition helps children learn geography, physics, or architecture. And some simulators — like Kerbal Space Program — develop logic, engineering thinking, and imagination.

Moreover, games have a therapeutic effect. Psychologists use gamification in working with children and adults, and some projects are created specifically to reduce anxiety, post-traumatic stress disorder, or depression.

Esports — The Profession of the Future

Another rapidly developing area is esports. Tournaments in Dota 2, CS:GO, or League of Legends gather millions of viewers, and professional players become true stars. This is no longer just a hobby — it is a full-fledged career that requires skills, endurance, analytics, and continuous self-improvement.
How to make math a favorite subject: tips for parents and

Mathematics is one of the most important school subjects that develops logic, critical thinking, and analytical skills. However, for many children, studying mathematics becomes a real challenge. How to change the attitude towards this subject? How to make it interesting and understandable even for those who "don’t get along with numbers"? In this article, we will consider effective ways to make learning mathematics easier and show how online education can become a reliable assistant in this.

Why does mathematics cause difficulties?
The difficulty in learning mathematics is often related not only to the content but also to the approach to learning. Typical reasons:
…
1. Unclear explanation of the topic by the teacher;
2. Missing basic knowledge;
3. Fear of making mistakes or appearing "not smart enough";
4. Lack of practical application in real life.

When a student does not understand the logic of solving problems, they begin to avoid the subject. Therefore, it is important to find a way to present mathematics simply, visually, and interestingly.

Online mathematics: how do modern educational platforms help children?
Educational platforms open new opportunities for learning mathematics:

- Interactive tasks — the child not only listens but actively interacts with the material;
- Video lessons with explanations — topics are presented in an accessible language, with examples;
- Adaptive tests — help assess progress and identify gaps in knowledge;
- Motivational systems — points, rewards, ratings encourage learning.

Thanks to this, online mathematics becomes not only understandable but also exciting!

How to develop a love for mathematics?

1. Solve problems together: parents can show by their own example that making mistakes is normal.
2. Explain the connection to real life: for example, how to use fractions when cooking or calculating a budget.
3. Praise effort, not correctness: support is more important than grades.
4. Use game elements: mobile apps with math problems are a great way to learn through play.
5. Choose the right educational platform: it is important that the content is age-appropriate, interesting, and understandable.

Conclusion

Learning mathematics is not about abilities but about the right approach. If you create a friendly environment, provide support, and use the opportunities of educational platforms, this subject can become one of the most favorite. Try online learning, and you will see how your child's attitude towards numbers, formulas, and problems will change.
Top 5 gifts for Mother's Day

SEO-optimized article in a warm, feminine style for an online store. Contains useful tips for shoppers, structured for easy reading, with keywords and a call to action. Suitable for a blog, email newsletter, or advertising content on a website.
One-year crisis in a child — informational article for parents

AI Content Creation

Informational article for a blog or website aimed at young parents. The text explains what a one-year crisis is, why it occurs, and how to properly respond to behavioral changes in a child. The material is written in simple language, with practical advice, based on modern psychological knowledge.

Format: 500-word article
Style: friendly, informative, with support for parents
… Target audience: parents of children up to 2 years old, readers of parenting blogs, social media users

Activity

Latest proposals 10	Budget	Added	Deadlines
Translate jpg logo to vector. Image editing 113 USD	113 USD	1 May	5 days
Adding cards to the Kasta marketplace 34 USD	34 USD	30 Apr	2 days
Cost and Logistics Calculator 70 USD	70 USD	29 Apr	3 days
Translate PDF documents into German using AI 93 USD	93 USD	29 Apr	2 days
Data entry-simple copy-paste task 1600 USD	1600 USD	29 Apr	2 days
Optimize parsing 23 USD	23 USD	22 Apr	2 days
Combine 2 parts of the text in the same style 11 USD	11 USD	Jun 2025	1 day
Translation of equipment instructions 23 USD	23 USD	Jun 2025	1 day
Administrative Tasks Assistant (Part-time) 16 USD	16 USD	Jun 2025	1 day
Looking for a message template sending manager 271 USD	271 USD	Jun 2025	1 day