🚀Projects and achievements
Collection of implemented projects with description of goals, roles, technologies and practical business impact results
Personal resume-portfolio website
Personal website implementation - from conceptualization and systematization to development with AI programming
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Development of concept, structure and content relationships
Website development using AI
Web hosting deployment
Web analytics setup and testing
Fully functional resume-portfolio website
Data object model for future expansion
FinTracker (Remix Framework)
Custom-built financial tracker for working with finances, budget planning, statistics and analytics
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Monobank API integration
Wallets, incl. credit limit
Transactional model with detail
Scheduled payments
Statistics and analytics
+3 exclusive features
Automation of 80% of operational actions for financial management
100% transparency and clarity of finances
Reduction of analytical conclusion time from 30 minutes to 1 minute
Detection of anomalies and errors in external service data
FinTracker (Django Framework)
Custom-built financial tracker for understanding and transparency of finances with automatic data collection
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Monobank API integration
Basic transactional model with detail
Statistics and analytics
+2 exclusive features
Automation of 40% of operational actions for financial management
Basic transparency and clarity of finances
Cinema Tracker (Remix Framework)
Information system for managing own movie library, statistics and analytics
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
ETL/ELT process development from Internet Movie Database API (200 million rows of "raw" data)
Search and add movies to collection
Movie viewing planning
Displaying watched movies
Statistics and analytics
Reduction of time for systematic movie library management from 3 minutes to 30 seconds
Everything in one place - without dozens of tabs and saved bookmarks
100% IMDb-standard data compliance
Detection of incomplete IMDb data and editing
Cinema tracker (Django Framework)
Systematic management of own movie library with web interface, basic statistics and analytics
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Manual movie library management in web interface
Basic statistics and analytics with visualization
Interactive movie library management
Basic understanding of own movie statistics
AI chatbot in Telegram
AI chatbot development in Telegram with local LLM for general communication, conversation context preservation and autonomous access
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Adding user to database
Adding/managing chats
Context preservation within chat
Request processing through local AI/LLM
Autonomous access to AI communication
Research of local AI/LLM in diverse tasks
Conducting research of local AI models for autonomous and confidential access for task solving
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Evaluation of available AI/LLM models
Evaluation of local hardware usage possibility
Testing 15 AI/LLM models in 10 tasks (Programming, Analytical tasks, Text processing)
Identification of 3 local AI/LLM models for daily use in tasks
Task Management (Django Framework)
Solution development for task management with time, cost estimation and statistics for workflow optimization and analysis
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Create, edit, delete, view tasks
Task calendar
Task time estimation with execution tracking
Task cost estimation (in salary terms)
Reduction of operational task management costs from 30 to 15 minutes
Transparency of efficiency assessment through analytics
B2B Department DWH Construction
Centralized data warehouse (DWH) construction from company internal systems for automation and optimization of analytics department workflow
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Audit and assessment of company internal systems and data availability
ETL/ELT pipeline construction
Analysis, assessment, documentation and reporting regulation
DWH architecture implementation (Staging/Core/Marts)
Pipeline execution orchestration (Task Scheduler, Jobs, Procedures)
Centralized data warehouse for analytics team
Systematization and standardization of internal reporting
85% automation of analysts' operational actions
Power BI B2B Datagroup & Volia & Lifecell
Operational implementation of automated tool for management decision making during Datagroup & Volia & Lifecell merger
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Data collection from internal and external sources
Process automation (ETL/ELT)
Commercial indicators display in Power BI
Calculation methodology description for users
Tool creation for operational decision making
Reporting methodology regulation for users
100% automated reporting
Cold B2B contact base formation
Analytical support for B2B client cold base formation project through collection, processing of open data and result evaluation
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Search for open information sources and testing information relevance
Obtaining raw data from open sources
Segmentation and prioritization
Activity result evaluation
Methodology and process creation for open data collection
Base of 500+ contacts for cold calls
Conclusion on effectiveness of working with cold base
SLA notification
Daily automated SLA violation notification implementation for client request processing
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Data retrieval within parallel ETL process
Data breakdown by hierarchy structure
Links to requests for quick review in internal system
Daily email sending to managers & executives
100% automation of request data preparation process
Increase in requests within SLA by 65 percentage points
Happy Birthday notification
Automated notification-reminder about department employee birthdays to support team spirit and communication between colleagues
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Data retrieval and formation
Monthly/weekly email sending to managers & executives
100% process automation
Increase in employee birthday greetings
Possibility of planning greetings in advance
B2B Power BI reporting
Power BI dashboard for operational control of own indicators by managers and executives, sales, commercial indicators
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Sales channel analysis
External activity analysis
Commercial indicators analysis
User training and support
Tool creation for convenient operational control
Reduction of reporting preparation and presentation time from 10 hours to 1 hour
Plan-Actual+Forecast
Daily sending of plans, facts and plan execution forecast to managers and executives via email
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Plan indicators administration
Data retrieval and forecast calculation
Data breakdown by hierarchy structure
Daily email sending to managers & executives
Reduction of operational reporting work time from 15 minutes/employee to 2 minutes/employee
B2C Power BI operational reporting
Power BI dashboard for operational control of own indicators by managers and executives
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Specialist personal page
Information for operational control
Specialist rating
User training and support
Reduction of operational reporting work time from 1 hour to 5 minutes
Competitive environment research in Kyiv
Detailed competitive environment analysis for PON network construction strategy definition in Kyiv
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Data collection from open sources (35 providers)
Data systematization and transformation
Statistical and interactive report formation
Conclusion presentation and justification
Methodology and competitor evaluation model formation
Methodology formation for working with competitor data
PON network construction strategy definition in Kyiv
Network dislocation and topology correction
Address and geolocation data normalization and correction in company internal systems
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Work scope assessment and prioritization
Data normalization algorithm development
Automatic file creation algorithm development
Additional manual data verification
Data correction process and methodology formation
Data quality increase by 3 percentage points
B2C Power BI Telegram
Power BI reporting construction for Telegram traffic effectiveness evaluation in corporate chat bot
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
UTM analysis with detail
Monthly analysis
Sales funnel
Callback requests
Geographic analysis with visualization
Tool creation for operational decision making
CRM AppSheet to CRM Creatio migration
Full participation in Appsheet functionality transfer to another platform
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
CRM Appsheet system and business process description
Creatio technical specification verification and correction
Developed functionality testing on Creatio platform
Integration implementation with company internal services for Creatio
User training for new system
User feedback collection
General Power BI reporting preparation
CRM AppSheet functionality migration to Creatio platform
Telegram channel analysis for advertising placement
Full research and analysis cycle for Telegram channel placement - from search and verification to effectiveness analysis and recommendations
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Search and analysis of Telegram channels for placement
Placement result forecasting
Placement effectiveness evaluation (Funnel + ROI + reactions)
Recommendations for further placements
Telegram channel evaluation methodology definition for placement
Conclusion on advertising placement effectiveness in Telegram channels
Telegram bot for work time tracking
Telegram bot for earned amount, lunch break and end of work day reminders
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Hourly earned amount status
Lunch break reminder
End of work day reminder
Automation of earned amount viewing process
Increase in lunch breaks to 1 break/day
Network reservation in Kyiv
Network reservation analysis through working with open data and interaction with technical division
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Outage schedule information collection
High-level competitive environment analysis
Data systematization and grouping
Process and user analytical support
Methodology definition for working with schedule and competitor data
Network reservation strategy and priority definition
CRM AppSheet Field Force Management
END-to-END systematization and automation of Fields Ops direction at national level (21 regions, 50+ employees)
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Full mobile app with offline mode, filtering and search
Interactive map and visual route planning
Automated Excel reporting with detail
Integration with internal systems
Partner reporting integration
Automatic information about completed work
Reduction of reporting time by 1.5 hours/day/employee
Reduction of reporting work time from 3 hours to 15 minutes
Additional saving of 50 hours/month due to system process expansion
Business process systematization and standardization
B2C Manager operational dashboard
Operational Excel dashboard that solved tasks - from manager activity and sales registry to statistics, forecasting and analytics for operational control
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Manager activity registry
Lead and sales registry
Work day normalization and evaluation
Quick info for managers (scripts, message texts, services)
Statistics and analytics
Reporting and KPI implementation for manager efficiency evaluation
Reduction of manager operational reporting time by 1.5 hours/day
Reduction of operational task time for managers by 30 minutes/day
CRM AppSheet Field Force Management Pre-production
Replacement of manual Excel and Google Maps reporting with unified and convenient CRM AppSheet
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Full mobile app with offline mode, filtering and search
Interactive map and visual route planning
General statistics about completed work
Work result information in Telegram
System scaling for Kyiv team
Reduction of reporting time 1 hour/day/employee
Transparency and reporting automation for department
Telegram Bot everyday
Telegram bot for automatic everyday information sending to user and time optimization for everyday decisions
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Adding user and their information to database
Horoscope retrieval from web resource
Random selection by request (what to cook, yes/no, quote)
Sending everyday information to user
Automation of everyday information retrieval
Reduction of everyday decision time to 1 click
Class schedule in Telegram
Telegram bot for automatic class schedule sending to group chat
🎯Goal
👤Roles
🛠️Tools and technologies
💡Implemented tasks
Schedule change detection on university website
Schedule Excel file download
Excel schedule conversion to photo
Schedule photo sending to student group chat
Zero time cost for schedule retrieval
100% information relevance