Андрій

EDUCATION:
BAIK ANDRII • The National Forestry and Wood-Technology University of Ukraine,
Data Engineer Department of Computer Technology Bachelor’s degree, 2011
Lviv, Ukraine • Lviv Polytechnic National University, Department of Computer
Technology Master’s degree, 2024
[open contact info](look above in the "contact info" section)
EXPERIENCE:
SKILLS:
Data Engineer
• Oracle Database SoftServe (2017 – Present):
• MS SQL Server
• SQL/PL/SQL • Design and implement Data Warehouse architecture using three-layer
• SQL/T-SQL structure (Staging, Core, and Data Marts), based on Star and Snowflake
• DWH schemas with fact and dimension tables.
• ETL • Collaborate with business analysts and product owners to design data
• SSIS models and implement technical solutions aligned with business
• SSAS requirements.
• OLAP • Optimize query performance in Azure Synapse by redesigning table
• Power BI distribution strategies and indexing (clustered columnstore and no
• Azure Cloud clustered indexes), reducing execution time and improving workload
• Azure Synapse SQL DW efficiency.
• Azure Data Factory • Implement structured tables and business-facing views within a
• Azure Data Lake Lakehouse architecture using Bronze, Silver, and Gold layers to support
• Databricks scalable data transformation and consumption.
• PySpark • Build and optimize ETL processes that consume data from multiple source
systems with incremental data loading.
• GIT
• Develop multidimensional OLAP cubes with complex calculated
• CI/CD
measures, hierarchies, and KPIs, supporting analytical reporting and
• English level – intermediate
decision-making.
• Design Power BI dashboards integrated with Data Warehouse layer.
CERTIFICATION:
• Deploy data platform solutions across environments using automated
CI/CD pipelines.
• Microsoft Certified: Azure
Fundamentals • Manage source control and versioning using Git repositories in Azure
DevOps, following structured branching and pull request workflows.
• Microsoft Certified: Azure Data
Fundamentals • Design and prepare data validation test cases to ensure data accuracy,
completeness, and consistency across data pipelines.
• Prepare technical documentation for client delivery.
• Perform production releases and post-deployment data validation.

PL/SQL Developer
KredoBank (2013 – 2017):

• Participated in the development and optimization of banking products,
including deposits, credit operations, and card transaction processing.
• Developed database objects including stored procedures, tables, views,
and triggers to support data platform processing and reporting workflows.
• Optimized existing procedures and processes.
• Prepared scripts for the collection of data for the audit department.
• Developed reports using Fast Report.
• Loaded data into warehouse tables using Oracle Data Integrator to support
structured data ingestion and transformation workflows.
• Collaborated with the different departments of business for the
requirements for new and existing bank products and implement them in
the system.