Геннадій

Bilichenko Hennadii
[відкрити контакти](див. вище в блоці «контактна інформація») (Viber, Telegram) Data Analyst
[відкрити контакти](див. вище в блоці «контактна інформація»)
Kramatorsk (temporarily in Kropyvnytskyi)

Summary of Qualifications:
 Experience in data processing and analysis, reporting, visualization, presentations
(Excel: macros + VBA, SQL queries, pivot tables/charts, Plex, Power Query;
PowerPoint; Word).
 Many years of experience in IT as a system administrator (Windows: 450 PCs,
Server, Active Directory..) and as a user (business software applications, MS
Office, 3D/2D design etc.)
 Automation tools: scenarios, macros, scripts.
 Understanding of OOP, CMS, HTML, CSS, JSON and using databases(SQL).
 Technical style of writing documentation, office workflow.

Experience and knowledge:
Courses 2023-2024:
1) A self-study Python «Basics of Programming course», “Python Data Analysis
and Visualization” Certificate Codefinity
2) A self-study the course as “Introduction to Data Analytics on Google Cloud”
Google Cloud Skills Boost.
3) A self-study Power BI (Data Preparation, Transformation, Modeling, DAX,
Visualization on Datacamp.com).
4) Experience in using AI.

Novokramatorsky Mashinostroitelny Zavod (NKMZ, nkmz.com)
in the design department until 28.02.2022:
Head of bureau of information and analytical support- 9 years
Tasks Technologies Used

Analysis of data on key indicators: documentation issue Word,
deadlines, order fulfilment in production, shipment of Excel (macros+VBA,
finished products, specific order indicators, fulfilment of the SQL queries, pivot
plan for new equipment, etc. tables/charts, Plex,
Summarizing final KPIs on a decadal, monthly, quarterly, Power Query)
annual basis.
Creation of presentations, reports, infographics, layout of
advertising materials.
Work with corporate software applications (e-document
workflow, bonuses accounting, staff accounting, planning of
program orders, etc.).
Records management, ad-hoc analytics, report creation.
Information and advertising group manager - 7 years
Tasks Technologies Used

Search for management queries, reviews, reports, search for CorelDraw,
standards, patents. Photoshop,
Creation of presentations, 3D animations, advertising PowerPoint,
materials for product nomenclature (writing articles, layout SolidWorks,
design), preparation of competition applications/materials. AutoCAD

Administration and content of the intranet site (IIS). HTML, CSS
CMS: Dotnetnuke,
OpenCart
MySQL
System administrator - 8 years
Tasks Technologies Used

System maintenance of PCs with Windows OS, Windows Windows Script Host
Server. (WSH), Ghost (clone),
Print-server, IIS,
VMWare

Local network administration of 450 computers TCP/IP
Active Directory:
Access administration,
GPO, Goverlan
(Admin script, Remote
control…)
Other knowledge and skills:
Experience in providing specialist training and courses:
 MS Office (Word, Excel, PowerPoint)
 Solidworks (3d volume modelling, teaching certificate)
 Elements of the Theory of Inventive Problem Solving (TRIZ) - a practical method
of developing creative thinking.

English level - Intermediate. (Certificate TP60362724 IT English )

Graduated course in QATestLab Training Center “The Fundamentals of Software Testing”:
Certificate QATestLab № 436421 from 04.09.2022

Soft skills:
Participated in negotiations with customers, in technical meetings, as a stand assistant at
exhibitions, as a guide about the company
Result-oriented, responsible, sociable, conflict-free, optimistic person with a sense of
humor.

Education:
Higher - Donbass State Engineering Academy, Kramatorsk - Systems Engineer.

Hobbies:
Football, volleyball, table tennis, tourism.