toptal.com
Contact us: +1.888.867.7001
Kyrylo Kostiukov, Business Intelligence Developer in Munich, Bavaria, Germany
Kyrylo Kostiukov

Business Intelligence Developer in Munich, Bavaria, Germany

Member since December 14, 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.
Kyrylo is now available for hire
Hire Kyrylo

Portfolio

Experience

Location

Munich, Bavaria, Germany

Availability

Part-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.

Employment

  • 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

  • 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

Experience

  • 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.

Skills

  • Languages

    JavaScript, PHP, MDX

  • Frameworks

    Ext JS, Zend Framework

  • Tools

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

  • Paradigms

    Business Intelligence (BI), Management, ETL

  • Platforms

    Magento 1, Magento, Magento 2, Pentaho, Oracle, Linux

  • Storage

    MySQL, IBM Db2

  • Other

    Software Deployment, Data Analytics, Software Security, Data Analysis, Embedded Business Intelligence, DAX, Power BI REST API, OData, Back-end Development, Magento Front-end Development, Magento Back-end Development, APIs, Reporting, System Administration, Statistics, R Programming, Machine Learning, Data Vaults, Windows Subsystem for Linux (WSL), Ubuntu 18.04, Networking, Business Administration, Finance, Cryptography, Statistical Modeling, Statistical Inference, Enterprise, Data Modeling

  • Industry Expertise

    Marketing, Accounting

Education

  • Bachelor's Degree in Business Administration
    2011 - 2013
    National Technical University of Ukraine "Igor Sikorsky Kyiv Polytechnic Institute" - Kyiv, Ukraine
  • Bachelor's Degree in Computer Networking
    2004 - 2011
    Kyiv College of Communication - Kyiv, Ukraine

Certifications

  • Data Visualization and Communication with Tableau
    JANUARY 2016 - PRESENT
    Duke University | via Coursera
  • Cryptography Specialization (First place for the Capstone Project, 2016)
    NOVEMBER 2015 - PRESENT
    University of Maryland | via Coursera
  • Magento Certified Developer Plus
    MARCH 2015 - PRESENT
    Magento
  • Introduction to Finance
    FEBRUARY 2015 - PRESENT
    Coursera, Inc.
  • Introduction to Computational Finance and Financial Econometrics
    JULY 2014 - PRESENT
    Coursera, Inc.
  • Magento Certified Front End Developer
    MAY 2014 - PRESENT
    Magento
  • Mathematical Biostatistics Boot Camp 1 and 2
    MARCH 2014 - PRESENT
    Johns Hopkins University | via Coursera
  • Cryptography I
    MARCH 2014 - PRESENT
    Stanford University | via Coursera
  • Social and Economic Networks: Models and Analysis
    MARCH 2014 - PRESENT
    Stanford University | via Coursera
  • Computing for Data Analysis
    FEBRUARY 2014 - PRESENT
    Johns Hopkins University | via Coursera
  • Machine Learning
    JANUARY 2014 - PRESENT
    Stanford University | via Coursera

To view more profiles

Join Toptal
Share it with others
Hire the top 3% of freelance developers TM