Kyrylo is available for hire
Hire KyryloKyrylo Kostiukov
Verified Expert in Engineering
Business Intelligence Developer
Munich, Bavaria, Germany
Toptal member since December 22, 2020
Bio
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
- PHP - 15 years
- JavaScript - 15 years
- MySQL - 15 years
- Magento 1 - 5 years
- Microsoft Power BI - 5 years
- Business Intelligence (BI) - 5 years
- Embedded Business Intelligence - 5 years
- Magento 2 - 2 years
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, REST APIs, Amazon Web Services (AWS), CSS, HTML, API Integration
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, REST APIs, Symphony, CSS, HTML, API Integration
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, REST APIs, CSS, HTML, API Integration
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, REST APIs, CSS, HTML, API Integration
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, CSS, HTML
Project History
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.
• 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
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.
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
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.
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
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.
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
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.
Education
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
Certifications
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
Skills
Libraries/APIs
Power BI REST APIs, REST APIs
Tools
Pentaho Mondrian OLAP Engine, Ab Initio, Composer, PhpStorm, Microsoft Power BI, Tableau, MATLAB
Languages
JavaScript, PHP, MDX, CSS, HTML
Frameworks
Ext JS, Zend Framework
Paradigms
Business Intelligence (BI), Security Software Development, Management, ETL
Platforms
Magento 1, Magento, Magento 2, Pentaho, Magento Community Edition, Oracle, Linux, Ubuntu 18.04, Amazon Web Services (AWS)
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, API Integration, 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, Symphony
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