Mykola Vasyliv

Data architect and data engineer who designs and builds enterprise data platforms end to end — data lakes, warehouses, Spark and Airflow pipelines, and the relational systems behind them. Architected a distributed hybrid-cloud data lake handling 10B+ records and led its migration to AWS. Deep SQL foundation across PostgreSQL, MS SQL Server, Oracle, and Sybase, with extensive work in data modeling, ETL performance tuning, and legacy-to-modern data conversion.

Mentors engineers on SQL and data modeling practice.

Data Architect — Data Lake & Data Warehouse - ScalHive - Remote (Ukraine)

(2017-12)

Data Architect — B2B Marketing Suppression Platform - ScalHive - Remote (Ukraine)

(2020)

• Refactored core data models for a high-volume unsubscribe and suppression service, improving query performance and simplifying downstream reporting.
• Optimized ETL workloads across Spark and Hive, reducing processing time and cluster cost on recurring batch jobs.
• Migrated workflow orchestration from Oozie to Airflow DAGs, giving the team clearer dependency management, retries, and monitoring.
• Mentored new engineers on SQL and data modeling, raising query quality and reducing review cycles.

Data Architect — Data Platform Migration to AWS - ScalHive - Remote (Ukraine)

(2019 - 2020)

• Architected and prototyped a distributed data warehouse on AWS, defining storage layout, partitioning, and ingestion patterns.
• Reviewed the existing data lake and warehouse implementation and produced the migration and modernization plan.
• Redesigned batch and event-driven workflows for large-scale processing in the new cloud environment.
• Designed and implemented data ingestion pipelines feeding the migrated platform.

Data Architect — Hybrid-Cloud Data Management Platform - ScalHive - Remote (Ukraine)

(2017 - 2019)

• Architected a distributed data lake spanning on-premises and cloud infrastructure.
• Implemented the data warehouse and downstream data marts serving analytics consumers.
• Designed batch and event-driven workflows for big data processing across the platform.
• Built profiling and cleansing processes for 10B+ records, covering deduplication, filtering, and validation.

.NET Developer - ViknarOff - Ternopil, Ukraine

(2017-01 - 2017-08)

• Developed business applications against MS SQL Server using C#, ADO.NET, and Entity Framework.

Database & Application Developer - Independent Consultant (Upwork / oDesk) - Remote, International Clients

(2007 - 2017)

Delivered database design, application development, and data migration projects for clients in the US and Europe across a sustained 10-year freelance practice.

• Galactica Alianca (2015–2016): built automated ingestion of supplier price lists (XML, XLS, CSV) from URLs and file drops into MS SQL Server, plus a WinForms product-search application.

PowerBuilder Developer - Luxoft - Kyiv, Ukraine

(2006-12 - 2007-11)

• Built and maintained enterprise client/server applications on PowerBuilder and Oracle 9.2 for an international outsourcing client.

Project Architect / Database Designer - Kameo

(2005 - 2006)

Designed MS SQL Server 2000/2005 databases and client applications; data modeling in PowerDesigner.

Developer - Universalna Insurance Company

(2004 - 2005)

Built a nationwide compulsory-liability insurance system with SQL Remote replication across regional branch offices.

Programmer / Analyst - TernopilGas

(1999 - 2004)

Designed and delivered a 250+ table Sybase SQL Anywhere billing and metering system for natural gas subscribers; built a reusable conversion framework that migrated business data from multiple legacy sources into the new schema, with stored-procedure validation and reconciliation reporting.

Programmer - Industrial Investment Bank

(1993 - 1999)

Developed accounting, deposit, and credit-agreement applications for bank operations.

Bachelor's degree equivalent - Department of Physics and Mathematics - Ternopil State University