Nykolai Hylka
Offer Nykolai work on your next project.
Rating
Language proficiency level
Skills and abilities
Portfolio
-
Smart PDF to Excel Parser & Web Automation Tool
PythonDeveloped a comprehensive solution based on Python for automating routine tasks related to processing technical documentation and interacting with web resources. The program allows transforming hours of manual catalog checking into mere seconds of automated work.
Key functionality:
Intelligent parsing (PDF Extraction): Automatic scanning of complex PDF files, extracting articles (NSN) and corresponding product descriptions.
…
Smart-Excel generation: Creating structured tables with embedded hyperlinks for instant access to the request form.
Web Automation (Playwright): Full automation of interaction with the website — the script independently opens the browser and fills in the necessary forms, eliminating human factors and errors.
Graphical User Interface (GUI): Developed a user-friendly control window on Tkinter with a progress bar for monitoring processing status in real-time.
Technology stack:
Language: Python
Libraries: Playwright (browser automation), Pandas (data manipulation), pdfplumber (text parsing), Tkinter (interface).
-
Development of an AI assistant for automating responses and analyzing logs
PythonCreated a complex Python robot ("SECRETARY_ROBOT") that integrates artificial intelligence capabilities into workflows.
Key functionality:
… Integration with Gemini 2.0 Flash: Utilizing modern LLM models from Google for processing text queries and generating content.
Smart quota management: Implemented an error handling algorithm for 429 RESOURCE_EXHAUSTED — the bot automatically analyzes API limits and goes into "sleep" mode for the necessary time to recover requests.
Real-time error handling: The bot independently diagnoses connectivity issues and request statuses (GenerateContentInputTokenCount, etc.).
Technologies: Python, Google Gemini API, HTTP status handling, Time-management algorithms.
-
Development of an autonomous order monitoring system (Python)
I created a script for automatic tracking of new projects on freelance exchanges. The program runs 24/7, mimicking user behavior, and instantly notifies about new opportunities in Telegram.
Key features:
… Stability: The script successfully passes check cycles every 10 minutes without failures.
Telegram integration: Using the Telegram API for instant messaging (HTTP 200 OK).
Error handling: The system automatically continues to operate even with changes in the website structure or temporary absence of new projects.