Key Engineer, Trinetix, LLC
Duration: Jun. 2023 - present
Summary: Inside project for one company from the “Big Four” - global subscription service.
Key responsibilities:
- Participation in architecting complex databases.
- Participation in architecting data and structure migration from legacy to modern product.
- Implementation of ETL for data migration (ADF, SSIS, GitHub Copilot).
- CI/CD improvement (Azure DevOps pipelines).
- Business logic implementation as part of the product (Azure SQL, Microsoft SQL Server).
- OLTP development, support, and data synchronization (implementation, performance tuning, optimization, best practices).
- AI multi-agentic flow creation for DQ tests and Code review processes • Code review via Azure DevOps.
Technologies: OLTP, ETL, SSMS, ADF, SSIS, Azure, Git, Azure DevOps, MS Visual Studio, MS SQL Server, VS Code, GitHub Copilot.
Team Lead (Part-time), Food Risk Management Agency (IT startup)
Duration: May 2023 - Dec. 2025
Summary: Data replatforming: migrating the data warehouse and ETL orchestration from Microsoft Azure to Google Cloud Platform for a predictive testing system assessing readiness of food industry enterprises to comply with European HACCP principles.
Key responsibilities:
- Architected and delivered a data warehouse on GCP across the full implementation lifecycle.
- ETL development (core SQL, Python for DAGs, Composer, Airflow, ADF, SSIS).
- Led replatforming and migration from Azure and MS SQL to GCP.
- Designed and implemented CI/CD for automated builds and releases (Azure DevOps, Azure Git, PowerShell).
- DB development (MS SQL: large fact tables, SCD2; Inmon and Kimball mixed approaches; partitioning, CCI, optimistic and pessimistic transactional modes).
- CI/CD via Azure DevOps and MS Visual Studio (automation: delivery to deployment using DAC packs).
- Code review via Azure DevOps; team mentoring and knowledge transfer.
- Troubleshooting in Git as git maintainer; collaboration with the customer.
- AI multi-agentic flow creation and Integration into the existing project ecosystem (Cursor, CLI, into BigQuery Airflow DAGs and Azure DevOps pipelines)
Technologies: Google Cloud BigQuery, Google Composer, Azure SQL for virtual machines, data warehousing, data integration (ETL/ELT), Azure DevOps, Azure Data Factory, SSIS, Microsoft SQL Server Analysis Services (tabular), Microsoft SQL Server on premises, Jira, Git, Azure Logic Apps, Apache Airflow, Key Vault, Google Secret Manager, Python for DAGs, PowerShell for Azure DevOps, Cursor, GitHub Copilot.
Key Engineer, Trinetix, LLC
Duration: Apr. 2020 - Jun. 2023
Key Engineer, Inside project from the “Big Four” company
Duration: Jul. 2020 - Jun. 2023
Summary: Inside project for one company from the “Big Four” - subscription service.
Key responsibilities:
- Participation in architecting complex databases.
- Data migration from on premises to Azure.
- ETL development (ADF, SSIS).
- OLTP development, support, and data synchronization (implementation, performance tuning, optimization, best practices).
- Code review via Azure DevOps.
Technologies: OLTP, ETL, SSMS, ADF, SSIS, Git, Azure DevOps, MS Visual Studio, MS SQL Server.
Key Engineer, Inside project from the “Big Four” company
Duration: Apr. 2020 - Jul. 2020
Summary: Inside project for one company from the “Big Four”.
Key responsibilities:
- Participation in architecting complex databases.
- Data migration from on premises to Azure (SSIS, linked servers).
- OLTP development, support, and data synchronization.
- ETL development (SSIS); synchronization between MS SQL Servers using linked servers.
- Code review via Azure DevOps.
Technologies: OLTP, DWH, ETL, linked servers, SSMS, SSIS (MS SQL Server 2014, 2017, 2019; SQL Azure), Git, Azure DevOps, MS Visual Studio, MS SQL Server, Microsoft Azure SQL.
DB Lead, Food Risk Management Agency (IT startup)
Duration: Feb. 2018 - Mar. 2021
Summary: Improving European HACCP principles into Ukrainian food production.
Key responsibilities:
- Architecting complex databases.
- OLTP development, support, and data synchronization (mobile and desktop applications).
- ETL development (SSIS); synchronization MS SQL Server <-> MySQL (linked servers).
- Participation in PRD creation; cooperation with customers; team leading.
Technologies: OLTP, DWH, ETL, reporting, SSMS, SSIS (MS SQL Server 2017), MySQL, Embarcadero RAD Studio, SSRS, MS SQL Server.
DB Lead, MS SQL Server Engineer, Sociological and data mining company
Duration: Feb. 2013 - Jun. 2019
Summary: Sociology and data mining.
Key responsibilities:
- Data warehouse architecting for BI (data mining + OLAP).
- ETL and data processing; OLAP multidimensional cubes for BI analysts.
- Reporting; development and support of auxiliary databases for OLTP.
- Customer cooperation; participation in PRD creation; team leading.
Technologies: OLTP, OLAP, DWH, data mart, Integration Services, Analysis Services, Reporting Services, replication, linked servers, distributed transactions, data mining; SSMS, SSIS, SSAS (OLAP multidimensional), SSRS (MS SQL Server 2008, 2012, 2017), MySQL, Embarcadero RAD Studio, Git, MS SQL Server.
MS SQL Server Engineer/Team Lead, Group of independent developers
Duration: Jan. 2006 - Jan. 2016
Summary: Multiple projects - CRM, ERP, BI, reporting.
Key responsibilities:
- Innovative “Alternative Vote Counting” system for political projects: OLTP (SSMS), ETL (SSIS), DW.
- “STOP Falsifications” system for political projects — data warehouse + reporting (SSRS).
- CRM, ERP, BI for business and charity: OLTP + ETL + DW + OLAP multidimensional cubes (SSAS) + RAD Studio.
- Sociological and statistical data processing (ETL + DW + SSRS).
Technologies: OLTP, OLAP, ETL, reporting, DWH, SSMS, SSAS, SSIS, SSRS, Embarcadero RAD Studio, Git, MS Visual Studio, MS SQL Server, local databases.
Full Stack Engineer/MS SQL Server Engineer/DB Lead, Large corporate agent of a Ukrainian billing operator
Duration: May 2004 - Feb. 2013
Summary: Providing billing services to Ukrainian companies.
Key responsibilities:
- Billing system architecting, development, and support.
- ETL and data processing; OLAP multidimensional cubes for BI analysts.
- Corporate and user reporting; back-end and front-end development.
Technologies: Data warehouse, OLTP, OLAP, reporting, ETL, MS SQL Server 2000 (OLTP, DTS), SQL Server 2005 (OLTP, SSIS), MS SQL Server 2008, 2008 R2, 2012 (SSIS, SSAS OLAP, SSRS), Git, Embarcadero RAD Studio, MS Access, MS SQL Server.
MS Access Engineer, Private enterprise
Duration: Jan 2003 – Jan 2006
Summary: Trading, software sales.
Key responsibilities:
- Desktop and network databases (SRM) for the enterprise (MS Access).
- ERP development (MS SQL Server, MS Access).
- Electronic document management for government agencies (MS SQL Server, MS Access): MS SQL Server 2000 (T-SQL, DTS) - database architecting, data migration, stored procedures and views for front-end applications.
Technologies: OLTP, ETL, MS Access, SSMS, DTS, VBA, MS SQL Server.