Position: PHP Developer
Category: PHP
English level: intermediate
Years of experience: 11

/////ALL open and closed ticket
select table1.closedate AS "time", DATE_FORMAT(table1.closedate,'%b %y') AS metric, table1.count1 + 
(CASE
    WHEN table2.count2 IS NULL
    THEN 0
    ELSE table2.count2
END) AS count2
from
(select COUNT(table1.id) as count1, table1.date, table1.closedate from glpi_tickets as table1 where users_id_lastupdater = 12535 AND status = 6 GROUP BY DATE_FORMAT(closedate,'%Y%m') ORDER BY closedate ASC) as table1
LEFT JOIN
(select COUNT(table2.id) as count2, table2.date from glpi_tickets  as table2 where users_id_lastupdater = 12535 AND status <> 6 GROUP BY DATE_FORMAT(date,'%Y%m') ORDER BY date ASC) as table2
ON DATE_FORMAT(table1.closedate,'%Y%m') = DATE_FORMAT(table2.date,'%Y%m')
Veo, France/Romania — Full Stack Developer(php 5 and 7, symfony(2.8, 3.4, 5.4), javascript. bootstrap)
December 2021 - PRESENT
The company has a lot of websites. All are written on the symfony framework (from 2.7 till 5.4 versions). Our team for strict adherence of high quality of coding, uses such technologies: git, gitlab (ci/cd:phpcs, phpstan, sonar, qualys etc), Docker, Complicated SQL queries .e.g two queries to one table through left join etc (triggers)


AIT, USA — Full Stack Developer(php7, yii2, javascript. bootstrap)
January 2019 - December 2021
My job description is to develop new features of an own CMS through which the clients can add and do changes inside the pages of their websites. It was a universal system to manage different sites: from a small website with 3-5 pages to a catalog of goods with hundreds pages.
I have developed a webmaster portal with the aim when  webmasters  create a new project don't use phpmyadmin. When a new project has been created, the webmaster portal inserts new rows to several tables, connecting them by foreign keys. 

mymagicbrides.com, Lviv Ukraine —Full Stack Developer(php7, yii2, javascript. bootstrap)

march 2016- december 2019
A social network. Now it is closed .
Altertech company, Lviv Ukraine — web developer
april 2012 - october 2013
A social network.

FREELANCE, Ukraine — Full Stack (php, mysql)
may 2009 - april 2012
A social network.
To learn new technologies, improve my skills. get an English language practice