Alexander Dyatchenko Email & Phone Number

Ukraine

Ukraine

- Created and developed the QA team including QA Lead. Reporting based on Testrail. BrowserStack for mobile testing. Crowd testing scenarios preparation and estimation.- Created and developed the Data analyst team with Grafana tool and PowerBI - Created and developed the Support department with integration to JIRA service desk and Opsgenie.- Created and developed the HR department, internal HR system for candidates was improved, DISC profiling improved, LightBot tests improved.-… Show more - Created and developed the QA team including QA Lead. Reporting based on Testrail. BrowserStack for mobile testing. Crowd testing scenarios preparation and estimation.- Created and developed the Data analyst team with Grafana tool and PowerBI - Created and developed the Support department with integration to JIRA service desk and Opsgenie.- Created and developed the HR department, internal HR system for candidates was improved, DISC profiling improved, LightBot tests improved.- MGA certification successfully passed in 4 month.- Company Addtech established and Salary accounting for 60 employees organized and CFO role taken.- Virtual machines technology for 15 new developers was built on 2 servers.- Internal PHP Academy was conducted and 2 new developers were hired.- Service expenses management system was developed from scratch to be quick and fully customisable for 100+.- Conducted 300+ interviews of PHP developers, QA managers/leads, accountants, techwriters, front-end devs.- JIRA projects migration from Next-gen to Classic type. 26 automations on transition of tasks configured Show less

Ukraine

FTP manager was developed and allows to decrease files uploading 3 times excluding errors at all.Time zones provided for all reports in CRM system.Livechat integration improved with adding fields for managers to see details of a customer.Refactoring translation module to use cache MemCached and query amount to DB lowers 2 times.Grafana tool was implemented with 6 dashboards for TV in the office and monitoring department. 100+ queries, alerts to telegram.Regexp creation for… Show more FTP manager was developed and allows to decrease files uploading 3 times excluding errors at all.Time zones provided for all reports in CRM system.Livechat integration improved with adding fields for managers to see details of a customer.Refactoring translation module to use cache MemCached and query amount to DB lowers 2 times.Grafana tool was implemented with 6 dashboards for TV in the office and monitoring department. 100+ queries, alerts to telegram.Regexp creation for elimination html parts inside translations for games and CRM elements after copy/paste Show less

Dnipropetrovsk Region, Ukraine

• Server Side and Client Side application development with rights assignment.• Apache 2.4 web server installation/administration.• Fully implemented integrations with web API: docdoc.ru, calltouch.ru, telecontact.ru• SQL queries for the reports and data analysis, backups, maintenance.• Accomplished automatic email generation with HTML tables and links.• Implemented checklists system for typical tasks that allows preventing common errors.• Find best decision on customer… Show more • Server Side and Client Side application development with rights assignment.• Apache 2.4 web server installation/administration.• Fully implemented integrations with web API: docdoc.ru, calltouch.ru, telecontact.ru• SQL queries for the reports and data analysis, backups, maintenance.• Accomplished automatic email generation with HTML tables and links.• Implemented checklists system for typical tasks that allows preventing common errors.• Find best decision on customer needs, estimate tasks, support on customer side.• Optimized a lot of SQL database queries to migrate to PostgreSQL with the same speed.• Designing and filling complex print forms with barcodes and blocks with diff. columns.• Online web cabinet for customers with task management.• Develop conversion rules for migration data from one system to another.• Client-bank systems integration, parsing XML, TXT formats.Technologies: PHP, MySQL, JS, HTML, CSS, JQuery, CMS API, SOAP, PostgreSQL, Apache, IIS, Bitrix CRM, 1C Enterprise 8, Google Maps API, Zend Framework Show less

Dnepropetrovsk

• Payments approval and preparation time was two times decreased with implemented budgeting system, with storing scanned bills and email approval system• person independent workplace was made with transport logistics system developed and connected to Goggle API• 10% customers increase after web store (shop.wds.ua) was integrated, launched and reached 1000 users• Software requirements specification for sales planning sub system was prepared• 50% suppliers orders were closed while… Show more • Payments approval and preparation time was two times decreased with implemented budgeting system, with storing scanned bills and email approval system• person independent workplace was made with transport logistics system developed and connected to Goggle API• 10% customers increase after web store (shop.wds.ua) was integrated, launched and reached 1000 users• Software requirements specification for sales planning sub system was prepared• 50% suppliers orders were closed while settlements were cleaned up with developed reports• Rights management support significant reduction due to optimization of departments list and rights units• Developers community was created within corporation to exchange ideas and implemented modules• Due to security reasons 1C Projects – system to track the projects was developed and implemented by meTechnologies: SQL, 1C Enterprise 8, ServiceDesk, 1C Projects, Google API, DBF, XML, Web service, Visio Show less

Dnipropetrovsk, Ukraine

• Annual report was built on CF data and business revenue appears after 1 year of financial blindness• Automatic recognition of 95% incoming payments was made using special “similar records search” system (200 lines bank statement converts to Accounting system documents in 3 minutes)• Put in order of 20,000 customer orders by creating a semi-automatic closing system and 2 web reports• New cost calculating method in-memory was developed to spread direct and indirect cost to… Show more • Annual report was built on CF data and business revenue appears after 1 year of financial blindness• Automatic recognition of 95% incoming payments was made using special “similar records search” system (200 lines bank statement converts to Accounting system documents in 3 minutes)• Put in order of 20,000 customer orders by creating a semi-automatic closing system and 2 web reports• New cost calculating method in-memory was developed to spread direct and indirect cost to production (17 layers)• Offline orders input system was debugged with XML files errors definitionTechnologies: SQL, 1C Enterprise 8, XML data exchange, Mantis Show less

Odessa

• Bridge between old and modern data structures was built and allows to use web based tools for reports• Most difficult old errors were found by using non-standard approach for debuggingTechnologies: SQL, MySQL, DBF, 1C Enterprise 8/7.7, JIRA, MS Office integration, ODBC, JSON, VoIP routing

Dnipropetrovsk, Ukraine

• Current projects work distribution, projects content composing, projects portfolio management• Command spirit forming through common meetings and bright events• Video lessons preparation for all projects that were finished. Over 150 lessons recorded• Access rights managements to databases, subsystems, visibility of subsidiaries data, closing periods• Implemented projects for native plant departments and subsidiaries including Russian and European:• 2010 - Manufacture… Show more • Current projects work distribution, projects content composing, projects portfolio management• Command spirit forming through common meetings and bright events• Video lessons preparation for all projects that were finished. Over 150 lessons recorded• Access rights managements to databases, subsystems, visibility of subsidiaries data, closing periods• Implemented projects for native plant departments and subsidiaries including Russian and European:• 2010 - Manufacture accounting system implementation in Merseburg, Krasnodar, Kiev city divisions (20 users)• ERP system implementation in Mityschi (Russian division) of Retal (150 active users). Consolidated reports became available• Manufacture planning subsystem (month, day, workshop shifts level). Recalculation in memory. Allowed to avoid misunderstanding in details of production to produce.• Automated data register system for all laboratory devices (viscometer, scales, thickness gauge, caliper). Statistics analysis and standardized reports• Annual cost calculation automation with 40 parameter tables (30 workplaces, 15 subsidiaries) helped to get united products categorization and consolidated reports for whole group• 2008-2011 Controlling module implementation deployed on 12 subsidiaries including interactive approval system (80 users). It allows to prepare budget till 5th of the month compare to 15th of month before.• All Client – Bank systems integration allows to get all factual money movements consolidate in one system• 2008 - MRO (Maintenance Repair & Overhaul) system implementation was completed in Dnepropetrovsk, Russia and Kazakhstan in 2009• 2008 - Automated workplace for verification of measuring instruments and devices• 2009 - Payroll accounting module implemented in Dnepropetrovsk division Show less

Магистр, Компьютеризированные Системы Обработки Информации И Управления

Выпускник