Key skills
Programming
I use PHP + mySQL, Yii and Code Igniter frameworks as a base for most of my sites. Interfaces are built with JavaScript (preferring TypeScript and Vue.js as a framework).
Below is a video of financial analysis system, built by me with PHP+mySQL+JS. Huge 'raw' sales database is being rapidly parsed and analyzed by several criterias. Interactive result is easy to work with:
I use Python and GoLang to process large text, data and to build interactive data plots.
Below is the utility written in Go to parse 1.1Gb XML file, process data and build an interactive plot in seconds:
My first sites were launched in 2000, and one of them worked till 2018. Good code lives long!
Also I worj with jQuery, programmed animation in CSS3/HTML5 Canvas and Adobe Flash AS2/AS3 (still actual for animated promo video).
Server Control
Tune up Apache+Nginx, debug mod_rewrite, correct the mySQL/MariaDB config, trace atop/htop performance - usefull skills that help quickly determine bottlenecks oand performance issues. And quite often in helps answering "why my site is so slow and I receive low rank in Google PageSpeed?" or "why my CMS output differs from what I did in admin area?".
Being friendly with SSH terminal, bash, nano & systemctl is a way to make sites faster and more stable. Also that's the way to provide reliable support from anywhere in the world.
Online shops
I do develop online shops on different engines. Different engines has different options, design, templates, modules. But all of them need to be tailored to your needs.
Web site portfolioPublishing
Isn't it great when the design is made with concern to your specific framework? And when designer knows how to user JS + CSS for animation effects?
Adaptive publishing for mobile devices, supporting gestures and using animations, mobile-first, BEM, SASS, LESS, Gulp, Webpack - every modern technology of 2024.
CMS support
Sometimes I build sites from a scratch or a prototype, be it a landing page, online shop, one-page 'business card' or a large sompany site. Most of them are based on one of frameworks or site engines, like WordPress, Drupal or Joomla. Sometimes they use their own engine.
A common task is to fix or extend such engine for some new functionality. Supporting sites created 5-10 years ago can be complicated, but I have a lot of experience with this sort of engines and not afraid of legacy code.
Latest cases
Logistics calculator
Frontend+backend (Vue+Vuex, Laravel, PHP, mySQL, JS)
Integration with Yandex.Maps
This app is a route price calculator for logistics company.
Based on around 30 parameters it suggests the suitable truck that will fit the freight
Maps API is used to calculate the route, nearest points and special zones
All the data are controlled via admin backend based on Laravel / Backpack
Mechanic.Online
Design, publishing, programming (Laravel, PHP, mySQL, JavaScript, SASS)
Integrations: MapBox,Robokassa payments, Telegram
Site for company providing the field repair mechanics specialists
UПользователи сайта делятся на 4 группы: клиенты, мастера, модераторы, администраторы
Clients may post their cases with photos, location and description. Mechanics are placing bids in response. Then the users are choosing the suitable offer by rating and the range. MapBox API is used to calculate travel time and distance matrix. After the repair is complete, the payments are wired via Robokassa API. Later both mechanics and clients could leave their feedbacks and ratings. The feedbacks are controlled by moderators, and the whole site is operated by administrators.
Backend built with Laravel / Backpack
Event service landing page
Design, programming (JS)
Intergrations: Tilda, Google Sheets, Telegram
Tilda was choosen by client request. But built-in Tilda scripts were not sufficient, so I had to write own scripts and integrate in Tilda code
All the data gathered are placed in Google Sheets and sent to Telegram.
Web shop of remote controllers
Design, publishing, programming (PHP, JS, mySQL), server administration (Centos 7 / Apache+Nginx / mariaDb / Sphinx)
A huge shop with about a million of goods.
Started with migration from old Drupal and PHP 5 to modern technologies, I had to rewrite many queries, rebuild caching and storing logics.
Also it was redesigned to be light, mobile-ready and stable.
На сайте вместе с новым лёгким дизайном была реализована адаптивная мобильная вёрстка, выполнена SEO-оптимизация, зависимая от контента, микроразметка.
Instant search was built with a Spnix search engine using proprietary SphinxQL language
Backend was uprgaded with financial statistics modules and integration with delivery services.
StatEx - Financial Stats & Analysis
UI/UX, JS, PHP, SQL, Telegram, RusPost delivery.
Financial analytics system for a net of hundreds of web-shops. Allowed the owners to control the sales flow on thousands of goods, gather and analyize statistics on didfferent data slices, produce sales forecats.
An easy interface was built together with fast backend providing complicated queries.
Integrated with Telegram and Russian Post delivery service (delivery tracking, price calculator, SOAP, XML).
InSoft
UI/UX design
The mission was to build an easy interface for controlling large arrays of data. Users should be able to work with it for a long terms, but without errors caused by fatigue.
A library of typical components was developed together with special controls for quick switching of the contexts.
Fairy House
design publishing, programming (PHP, mySQL, JS), CRM Bitrix (JS, PHP), Google Sheets
All the data is controlled with Google Sheets tables. Data is filtered and integrated into the site and CRM.
The site is also PageSpeed and SEO optimized
IBMC Moscow Institute of Biochemistry
Design, publishing, programming (PHP), CMS Joomla
Site was migrated from legacy system to a modern one. That required processing of thousands of tables, images and other data with a custom crawler.
For easy content management some plugins were developed allowing the non-IT personnel to use shortcodes that transform usual text to pre-designed blocks. Avatars, article images and tables, links and phone numbers are pre-designed, requiring no knowledge of HTML or design and used in visual content editor.
Additionally the site was extended with local search engine
Simple Virus Scanner
Programming (PHP)
Heuristic file virus scanner for common PHP-based viruses.
The scanner analyzes more than 30 parameters and finds threats when other antiviruses give up, even commercial (like VirusDie).
Works both in web and console modes.
Helped to restore hundreds of sites back to work!