Контактна інформація

Шукач приховав свої особисті дані, але ви зможете надіслати йому повідомлення або запропонувати вакансію, якщо відкриєте контакти.

Досвід роботи

Risk Analyst

з 07.2024 по нині (2 роки 3 місяці)

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

з 10.2022 по 07.2024 (1 рік 10 місяців)
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

з 01.2010 по 04.2022 (12 років 4 місяці)
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

з 08.2005 по 08.2014 (9 років)
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.

Знання і навички

• Здатність до навчання
• 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