Contact information

This job seeker has hidden his personal information, but you can send him a message or suggest a job to him if you open his contact info.

Work experience

Risk Analyst

from 07.2024 to now (2 years 3 months)

1. Development and maintenance of analytical reporting for Risk, Collections, Marketing, and Management teams: creation of interactive dashboards, analytical reports, KPIs, data models, and automated reporting solutions to support management decision-making.
2. Development of analytical solutions in Power BI and Microsoft Excel using DAX, Power Query, Power Pivot, data models, PivotTables, PivotCharts, advanced formulas, and data-processing automation.
3. Gathering, analysis, and formalization of business requirements; collaboration with business stakeholders; preparation of technical specifications and analytical documentation.
4. Design and development of ETL processes for loading and transforming data from MySQL, PostgreSQL, BigQuery, Excel, CSV, and JSON sources.
5. Development, optimization, and maintenance of complex SQL queries, views, and stored procedures.
6. Design of data models in Power BI and Excel; development of calculated tables, measures, and KPIs using DAX; creation of data transformation processes using Power Query (M).
7. Data quality control, investigation of discrepancies between information systems, and identification and resolution of data loading, processing, and calculation issues.
8. Power BI Service administration: report publishing, workspace configuration, user access management, scheduled data refresh setup, and process monitoring.
9. Preparation, validation, and maintenance of regulatory reporting for the Czech National Bank (CNB), ensuring data accuracy and compliance with regulatory requirements.
10. Analysis of large datasets and preparation of analytical insights, presentations, and recommendations to support management decision-making.

Data Analyst

from 10.2022 to 07.2024 (1 year 10 months)
CompX, Дистанційно (Роздрібна торгівля)

1. Preparation of reports across key business areas: sales and plan-vs-actual analysis, ABC/XYZ segmentation, ROI, inventory, settlements with counterparties, employee incentive programs, web analytics, Telegram user acquisition, and call center performance.
2. Integration and analysis of data from multiple sources, including SQL databases, GA4, APIs, Google Analytics, Google Sheets, Microsoft Excel, and JSON.
3. Power BI administration, including user access configuration and workspace management.
4. Development and optimization of data models, DAX measures, and ETL processes in Power Query (M).
5. Improvement of report performance, optimization of data loading processes, and data quality control.

Assistant Project Manager

from 01.2010 to 04.2022 (12 years 4 months)
IT 2.0 LLC, Краматорськ (IT)

1. Development of project and analytical documentation for monitoring and research projects, including roadmaps, concepts, and technical specifications.
2. Data collection, preparation, and processing using SQL, Excel, Power BI, and Google Sheets.
3. Preparation of analytical reports, data visualizations, and presentations based on research results.
4. Participation in the development of web and desktop solutions, including requirements definition, preparation of bug reports, and manual testing.

Assistant Professor, Department of Economic Cybernetics

from 08.2005 to 08.2014 (9 years)
Donbas State Engineering Academy, Краматорськ (Освіта, наука)

1. Teaching courses in Economic Cybernetics and Economic Modeling.
2. Preparation of reports for two research projects.
3. Preparation of scientific publications, research reports, and departmental research activity reports.

Knowledge and skills

• Здатність до навчання
• 1С
• SQL
• API
• Google Analytics
• Написання ТЗ
• Ручне тестування
• MS Power BI
• MS Word
• MS PowerPoint
• MS Access
• MS Visio
• Google Sheets
• Git
• GitHub
• HTML
• XML
• JSON
• SourceTree
• Jira
• MS Visual Studio
• MS Excel
• Power Query
• DAX
• Power Query (M)
• MySQL
• PostgreSQL
• BigQuery
• GA4