Kyrylo Kostiukov
Verified Expert in Engineering
Business Intelligence Developer
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
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
Availability
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
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.
BI Developer | Data Visualization Expert
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.
Magento Developer | BI Developer
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.
Software Developer | IT Consultant
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.
Web Developer
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.
PHP Developer
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.
Experience
Master-Test | Online Testing Service for Educational Purposes
• 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/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.htmlMain 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/pawboThis 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.htmlEducation
Bachelor's Degree in Business Administration
National Technical University of Ukraine "Igor Sikorsky Kyiv Polytechnic Institute" - Kyiv, Ukraine
Bachelor's Degree in Computer Networking
Kyiv College of Communication - Kyiv, Ukraine
Certifications
Data Visualization and Communication with Tableau
Duke University | via Coursera
Cryptography Specialization (First place for the Capstone Project, 2016)
University of Maryland | via Coursera
Magento Certified Developer Plus
Magento
Introduction to Finance
Coursera, Inc.
Introduction to Computational Finance and Financial Econometrics
Coursera, Inc.
Magento Certified Front End Developer
Magento
Mathematical Biostatistics Boot Camp 1 and 2
Johns Hopkins University | via Coursera
Cryptography I
Stanford University | via Coursera
Social and Economic Networks: Models and Analysis
Stanford University | via Coursera
Computing for Data Analysis
Johns Hopkins University | via Coursera
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
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring