Kyrylo Kostiukov, Developer in Munich, Bavaria, Germany
Kyrylo is available for hire
Hire Kyrylo

Kyrylo Kostiukov

Verified Expert  in Engineering

Business Intelligence Developer

Location
Munich, Bavaria, Germany
Toptal Member Since
December 22, 2020

Kyrylo has experience in business intelligence (BI), data analytics, and machine learning projects for Magento merchants. He is the author of an extension for the integration of Magento with Power BI who prefers data-related projects and offers Power BI reports and dashboards development services, such as BI reporting, forecasting, and embedded analytics. Kyrylo has a background in business management and statistics to support companies in data analytics and KPI development.

Portfolio

Senacor Technologies, AG
Linux, IBM Db2, Data Vaults, Ab Initio, ETL, Business Intelligence (BI)...
BEONTRA, GmbH
MDX, Embedded Business Intelligence, Business Intelligence (BI), Pentaho...
Flagbit, GmbH & Co. KG
R Programming, JavaScript, PHP, MySQL, Magento 2, Magento 1, Composer...

Experience

Availability

Full-time

Preferred Environment

Ubuntu 18.04, Windows Subsystem for Linux (WSL), PhpStorm

The most amazing...

...thing I've developed is the Power BI integration solution for Magento. This fully-fledged BI solution can be set up in hours for new companies using Magento.

Work Experience

Senior BI Developer | ETL and Enterprise Data Warehouse Developer

2019 - 2020
Senacor Technologies, AG
  • Developed the ETL pipelines with Ab Initio ETL software.
  • Collaborated with a team of 40 to 50 consultants to build an enterprise data warehouse (EDW) for one of Germany's largest banks.
  • Automated business processes with ETL software and Bash scripting for continuous integration and quality control.
  • Gained experience working in one of the largest Banks in Germany.
Technologies: Linux, IBM Db2, Data Vaults, Ab Initio, ETL, Business Intelligence (BI), Data Modeling

BI Developer | Data Visualization Expert

2016 - 2019
BEONTRA, GmbH
  • Built the BI front-end architecture, data visualization, and data modeling, specifically star and snowflake schemas or dimensional models.
  • Used R language to develop the prototypes for data mining components, such as data clustering and prediction models.
  • Developed BI software based on Pentaho Suite, HP Vertica, and web technologies.
  • Created data visualization components using Highcharts and other charting frameworks. Developed the dashboards with JavaScript UI.
  • Took part in analyzing available data and brought new ideas for the product.
  • Created the visualization of financial data and data based on airport traffic forecasting and planning data.
  • Collaborated with ETL developers to agree on the optimal data models.
  • Monitored the BI market for the new modern BI platforms. Evaluated Power BI, Tableau, QlikView, and other BI and data visualization solutions.
Technologies: MDX, Embedded Business Intelligence, Business Intelligence (BI), Pentaho, Pentaho Mondrian OLAP Engine, Ext JS, JavaScript

Magento Developer | BI Developer

2014 - 2016
Flagbit, GmbH & Co. KG
  • Conducted web development and provided IT support for eCommerce companies.
  • Developed and supported Magento extensions for different Magento merchants.
  • Developed a business intelligence platform for eCommerce projects.
Technologies: R Programming, JavaScript, PHP, MySQL, Magento 2, Magento 1, Composer, Back-end Development, eCommerce, Magento Community Edition

Software Developer | IT Consultant

2010 - 2013
Consileon Business Consultancy, GmbH
  • Managed deployment, software requirements analysis, second and third-level IT support, and automatic and acceptance testing.
  • Led project planning, control, requirements analysis, and team management.
  • Developed an international pricing management system for a wide range of complex products.
  • Built a customer management system (CRM) supporting the creation of offers for corporate customers. Integrated a price management system with Salesforce CRM.
  • Developed a core back-end system for a premium car-sharing service startup, including the development of car-sharing web interfaces for internal users such as fleet managers and call centers.
Technologies: Oracle, Enterprise, Ext JS, PHP, Back-end Development

Web Developer

2009 - 2010
Freelance
  • Developed an online taxi ordering system, including an RIA user interface and API integration.
  • Built and implemented UI solutions with Ext JS library in different short-term projects.
  • Developed custom Ext JS components for various clients.
Technologies: Ext JS, MySQL, PHP, JavaScript

PHP Developer

2007 - 2009
iTyre
  • Assisted in the development of custom-built online shop ityre.com.
  • Developed the customer relationship and retail management system with a large database of suppliers and products.
  • Created a custom-built content management system (CMS) solution for the quick setup of online stores.
Technologies: MySQL, PHP, JavaScript, eCommerce

Master-Test | Online Testing Service for Educational Purposes

Development and support of a web project for public use. This is my own startup project that brought me experience in all aspects of web product delivery:

• Development using PHP, Zend Framework, Ext JS, and MySQL.
• Experience in modern frameworks like Ext JS and Zend Framework.
• Developing a wide range of custom JavaScript components.
• SEO and marketing.
• IT support.

Wrote unit tests using PHPUnit, Unit JS, and Selenium. The service is currently up and running for ten years and has, on average, over 6,000 visitors per day.

Magento Website for Selling Magento Extensions

https://www.bimproject.net/
Website running on Magento 1 with the integration of a private Composer repository and software license management workflows.

I performed all design, development, and support activities without other developers' involvement.

Migrated the website design from Magento 1 to Magento 2. The migration of other functionalities is still in progress.

Power BI Integration Solution for Magento

https://www.bimproject.net/en/products/extensions-for-magento/power-bi-integration.html
Development of extensions for a Magento eCommerce platform that delivers BI functionality to the platform. The solution is based on integration with the Microsoft Power BI solution.

Main functional parts:
• Incremental sales data extraction from Magento.
• Building a data warehouse (DWH) with sales data of Magento.
• Integration with Power BI REST API for data delivery to Power BI service.
• Providing OData API access to DWH inside Magento.
• Embedding of Power BI content to Magento pages.
• Customizations of the solution for different clients.

Additionally, I performed all activities related to sales:
• Project management, SEO, and marketing.
• Visiting conferences and communicating with potential customers.
• Providing all levels of support.
• Building the website.
• Writing documentation.
• Branding.

Used different technologies, including Power BI Online, Power BI Desktop, DAX, Power BI REST API, PHP, MySQL, Linux, Magento 1 and Magento 2, and R.

Pawbo | Command-line Interface for Power BI Service Management

https://www.bimproject.net/en/pawbo
Pawbo is a command-line tool that works with Power BI REST API to integrate with the Power BI service. It can create a dataset in the Power BI service and populate it with data. Internal scheduler and small ETL framework may help perform basic data preparation and incrementally load data to Power BI.

This could be used, for example, as an alternative to on-premise Power BI Gateway. Pawbo CMD tool could also work on Linux.

BIM R Analytics Extension for Magento

https://www.bimproject.net/en/products/extensions-for-magento/r-analytics.html
BIM is an extension for Magento that uses R language to implement advanced analytics and data visualizations within the Magento platform. Without dependencies on external services, analytics could be performed within Magento itself with immediate usage of results inside Magento logic.
2011 - 2013

Bachelor's Degree in Business Administration

National Technical University of Ukraine "Igor Sikorsky Kyiv Polytechnic Institute" - Kyiv, Ukraine

2004 - 2011

Bachelor's Degree in Computer Networking

Kyiv College of Communication - Kyiv, Ukraine

JANUARY 2016 - PRESENT

Data Visualization and Communication with Tableau

Duke University | via Coursera

NOVEMBER 2015 - PRESENT

Cryptography Specialization (First place for the Capstone Project, 2016)

University of Maryland | via Coursera

MARCH 2015 - PRESENT

Magento Certified Developer Plus

Magento

FEBRUARY 2015 - PRESENT

Introduction to Finance

Coursera, Inc.

JULY 2014 - PRESENT

Introduction to Computational Finance and Financial Econometrics

Coursera, Inc.

MAY 2014 - PRESENT

Magento Certified Front End Developer

Magento

MARCH 2014 - PRESENT

Mathematical Biostatistics Boot Camp 1 and 2

Johns Hopkins University | via Coursera

MARCH 2014 - PRESENT

Cryptography I

Stanford University | via Coursera

MARCH 2014 - PRESENT

Social and Economic Networks: Models and Analysis

Stanford University | via Coursera

FEBRUARY 2014 - PRESENT

Computing for Data Analysis

Johns Hopkins University | via Coursera

JANUARY 2014 - PRESENT

Machine Learning

Stanford University | via Coursera

Libraries/APIs

Power BI REST APIs

Tools

Pentaho Mondrian OLAP Engine, Ab Initio, Composer, PhpStorm, Microsoft Power BI, Tableau, MATLAB

Frameworks

Ext JS, Zend Framework

Languages

JavaScript, PHP, MDX

Paradigms

Business Intelligence (BI), Security Software Development, Management, ETL

Platforms

Magento 1, Magento, Magento 2, Pentaho, Magento Community Edition, Oracle, Linux, Ubuntu 18.04

Storage

MySQL, IBM Db2

Industry Expertise

Marketing, Accounting

Other

Software Deployment, Data Analytics, Data Analysis, Embedded Business Intelligence, DAX, OData, Back-end Development, Magento Front-end Development, Magento Back-end Development, APIs, Reporting, Architecture, Integration, eCommerce, System Administration, Statistics, R Programming, Machine Learning, Data Vaults, Inventory, Windows Subsystem for Linux (WSL), Networking, Business Administration, Finance, Cryptography, Statistical Modeling, Statistical Inference, Enterprise, Data Modeling

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring