Viktoriia

Victoriya Dragliuk
[відкрити контакти](див. вище в блоці «контактна інформація»)

Data analyst / BI analyst

English level B2+

Summary:
Analytics-focused Data Specialist with 2 years of hands-on experience working with analytical
environments in IT industry. Contributed to maintaining and enhancing existing data models and
ingestion workflows in Microsoft Fabric using Python/Spark Notebooks and SQL. Supported ongoing
analytical systems by improving data integrity, and optimizing transformations based on business
requirements. Additionally have hands-on experience to work with AWS databases and Azure
Synapse, supporting data migration and transformation processes. Assisted in maintaining data
pipelines, validating data consistency across environments, and adapting existing SQL logic during
system transitions to cloud infrastructure.

Familiar with Spark-based notebook development environments, including Microsoft Fabric
Notebooks, with understanding of similar Databricks workflows and Medallion architecture concept.

Tech summary:

Data Platforms:
Microsoft Fabric (Lakehouse – Raw/Stage layers, Dataflow Gen2, Fabric Notebooks (Python, SQL,
Spark), SQL Endpoint), Spark (PySpark, DF)

Cloud & Warehousing:
AWS (S3, EC2, relational databases, Glue), Azure Synapse Analytics

Databases:
PostgreSQL, Microsoft SQL Server (T-SQL, SSMS, SSIS ETL)

Programming & Querying:
Python (pandas, PySpark, API integration),
SQL (T-SQL, PostgreSQL)

Data Modeling & BI:
Semantic Models, Power BI (DAX, Power Query), BI reporting

Development & Collaboration:
Git, Azure DevOps, PyCharm, Bash
Project Experience

Red Cross Ukraine National Committee

Data analyst of consolidated information | Nov 2025 – Feb 2026

 Consolidate data across operational divisions (humanitarian aid, MHPSS services, emergency
response calls) for maintenance of a centralized indicators framework for donor reporting and
performance analysis.
 Collaborate with teams to validate data accuracy, align business logic, and improve report
visualization.
 Iteratively communicate with main stakeholders to receive feedback regarding correctness of
applied technical approaches and improving data collection.
 End-to-end monitoring and troubleshooting of data pipelines and semantic models
 Implemented a retry and delay strategy in Fabric Notebooks using Python to handle timeout
errors during API ingestion to improve stability
 Ensured historical data integrity by replacing full dataset overwrite mode to partition-based
incremental ingestion using Spark

Tech:Microsoft Fabric (Dataflow Gen2, Fabric Notebooks – Python/Spark/SQL, Lakehouse – Raw &
Stage layers, SQL Endpoint – Views, Semantic Models, Reports),
Power BI (PQ, DAX)
SQL (T-SQL in SQL Endpoint environment)
Python (pandas, NumPy, PySpark, requests, API integration)
Airtable, KOBO Toolbox (data source)

EPAM Systems

Data Analyst | Manufacturing Industry | Jun 2025 – Nov 2025

 Work with semantic models, PQ, dataflows and DAX measures for reporting.
 Check data consistency across operational and reporting DB. Work with application data.
 Monitored AWS Glue jobs for stable SM updates
Tech: Power BI (PQ, DAX), PostgreSQL (DBeaver), AWS (EC2, S3, Glue)

Data Engineer | Healthcare Industry | Jan 2025 – May 2025

 Migrated Sybase DB objects (procedures, triggers, functions) to PostgreSQL. Check
consistency and correct operation of migrated objects
 Automated unit testing with pgTAP
 Work with Python code to automate DB scripts migration with LLM solutions
Tech: PostgreSQL, Python, AWS, Git, pgTAP, PyCharm, Bash

Junior BI Developer | Retail Industry | Jun 2024 – Dec 2024
 Correct Power BI dashboards and semantic models with SQL optimization.
  Migrate report from legacy system (Cognos) to Power BI

Tech: Power BI, SQL, Azure Synapse, Cognos

Junior ETL Developer | IT Consulting / Financial Systems | Apr 2024 – Jun 2024

 Work with DB objects (procedures, views, triggers) in MS SQL & PostgreSQL.
 Work with SSIS ETL pipelines (including C# scripts).
 Optimized SQL queries and monitored ETL workflows.
Tech: MS SQL, PostgreSQL, SSIS, Azure DevOps.

Lean Institute Ukraine (Lean Global Network)

Data analysis & reporting

Nov 2019 - Apr 2024 (4 years 6 months)

Analytics both for internal purposes (financial, workload, product) & consulting (connected to
increasing of company business performance) Lean mentoring activities
Analytics Responsibilities:

 Financial analytics – collection and interpretation of KPIs across finance, operations,
marketing, and administration (Google Sheets, Excel, 1C, Power BI, Miro).
 Product analytics – evaluation of user engagement, progress, mentor interactions, and
satisfaction (EducateMe LMS, CRM Pipedrive, Tableau, Power BI).
 Marketing & CRM analytics – analysis of promotion activities, conversion, retention,
feedback, and registration trends (CRM Pipedrive, Google Sheets, Miro).
Industries: Automotive components, plastic packaging, furniture, stainless steel pipes, food service,
retail (food & non-food), logistics.

Tech: Trello, SQL, Oracle BI, Miro, Google Workspace, drawio, CRM Pipedrive, 1C Enterprise Team:
Consultants: 4 Marketing: 1 Sales: 2 Admin & analytics: 3 Methodologist:1

Sumitec Ukraine (Sumitomo Corporation Group)

Head of Logistics and parts administration | Management of inbound/outbound, warehouse
logistics, Product analytics (spare parts & components), Inventory management, Risk
management (in terms of goods & shipment) | Logistics and Administration division

Sep 2005 - Apr 2019 (13 years 8 months)

E2E Supply chain management, reporting, product analytics (spare parts & components), inventory
management

Responsibilities:
  Product & SKU analytics (5000+ SKUs): categorization, seasonality, ABC-XYZ, FMR,
turnover, MOH/DOH, COGS, gross margin.
 Automation of analytics: reporting & dashboards (1C, OLAP cubes).
 Order management analytics: (EOQ, min-max), inventory & obsolescence analysis.
 Reporting: gross margin, MOH/turnover, inventory, cash-flow, and departmental expenditures.

Tech: OLAP cubes, Microsoft Excel, 1C Enterprise Team: Analyst:1 Admin:2

Education:

 National Aviation University (2000 – 2005)
Transport management and organizational engineer
 Chartered Institute of Management Accountants (CIMA) certification,
P1 & P2 level at PriceWaterhouseCoopers (PwC) , Kyiv, 2015