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).

read more

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 portfolio

Publishing

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 2022.

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

View on YouTube

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

View on YouTube

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)

GitHub link

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!