Особисті дані приховані

Kruk Vitalii
e-mail:[відкрити контакти](див. вище в блоці «контактна інформація»)
Lviv,Ukraine

Summary Education
National University'Lviv Polytechnic’
Data Analytics Specialist focused on improving Specialization: Computer Engineering
team efficiency. I build custom applications and
automated workflows using Power BI, Power Apps, Experience
and Power Automate. I also write SQL queries to
Junior Data Analyst
manage and transform complex data.
Nestle | ~ 1 Year
Skills Project Leadership: Independently led end-to-end data
analytics projects, taking full ownership from initial
SQL - Complex CTE queries, Advanced window
stakeholder requirements to final solution deployment.
functions
Power BI: Maintained existing dashboards and replaced
manual reports with automated dashboards. Created a
PowerBI - Connecting data sources, Data modeling,
Data Quality tracking dashboard. Processed datasets with
Creating dashboards, Writing DAX measures, Row- millions of rows from Snowflake, BigQuery, Excel, and
Level Security, Troubleshooting failed jobs Dataverse.
Power Automate: Automated email reminders, file
Power automate - Workflow automation, Automated distribution, and data exports from Power BI. Automations
notifications, Data integration saved about 12 hours of manual work per week (0.3 FTE)
across all projects.
Power apps - Canvas app development, Dataverse Power Apps: Replaced 12 manual Excel trackers with a
integration, User interface design single Power App and SharePoint list. Developed a data
tracking app accessible to 200,000 Nestlé employees.
Dataverse - Data modeling, Table architecture SQL, Dataverse & ETL: Engineered an automated ETL
optimization, Query folding, ETL pipeline integration pipeline using Power Automate and Dataflows to ingest
and transform reporting data into Dataverse. Leveraged
Query Folding to push transformation workloads to the
Languages database level, optimizing system performance. Wrote SQL
English - B2 queries to extract data from Snowflake and Google
BigQuery. Managed tables with over 2 million records.

.
DataLab Intern — EPAM | ~ 6 Months

MS SQL: Created databases and learned core concepts,
including indexes, execution plans, and ACID principles.
Azure & ETL: Built ETL data pipelines using Azure Data
Factory. Worked with Azure Storage and Key Vault.
Microsoft Fabric: Completed a data project using the
Microsoft Fabric platform.
Scripting: Practiced simple automation using Python and
Bash scripts.