Learn Data Skills
Beta
Iaroslav Cherkashyn

Iaroslav Cherkashyn

Data Analyst

Freelancer | Hungary

Technologies

My Portfolio Highlights

My New Course

Reporting in SQL

My New Course

Introduction to Snowflake

My New Course

Reporting in SQL

Insights conductor, orchestrating a symphony of knowledge from data melodies.

My Work

Take a look at my latest work.

course

Reporting in SQL

project

Consolidating Employee Data

course

Reshaping Data with pandas

course

Reporting in SQL

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Google Cloud Cloud Digital Leader

Google Cloud Associate Cloud Engineer

Microsoft Power BI Data Analyst Associate

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to ChatGPT
Understanding Data Science

My Work Experience

Where I've interned and worked during my career.

EPAM Systems | Apr 2022 - Jan 2024

BI Analyst

• Supported migration project from on-premises servers to cloud (GCP) • Responsible for the preparation dashboards in Grafana and Looker Studio • Implementation of metrics required by client.
Show More

Bonbonetti Kereskedelmi Kft. | Mar 2019 - Jan 2022

Senior Analyst

* Prepare annual strategic plan per clients and SKU * Prepare monthly operation plan * Analyse market environment based on Nielsen's data and data about sell-out from chains. It helps to say what our competitors make better, and what should we do for increasing our volume sales * Analyse business process of the company, find "bottlenecks" * Development KPI for field sales team, support and development in IT system * Control process of movements SKU from head company. Management of stock * Promo planning and afterwards calculation of promo effect based on data from our accounting system and sales out from retailers * Data management. Responsible for catalogue of clients and goods in IT system * Write technical requests for development in IT system.

Global Spirits | Apr 2016 - Dec 2018

Head of analytical department

* Supported sales force, and optimised business process.  *Analyzed company’s sales performance by brands, by market segments, by customers. *Developed and launched KPIs for sales force. *Calculated P&L by brands, customers and regions *Controled and forecasted contract's profit *Created statistical models of sales in retails *Created plan, launch and support loyalty programmes for clients *Leaded analytical team

MMC "Baltika-Baku" | Dec 2013 - Mar 2016

Manager of CRM-system

*Developed clustering model of clients. That helped to optimize trade marketing investments and increase the effect of promo activities.  * Optimised sales representatives routs with support of CRM-system. As result, efficiency of work with clients increased.  * Developed and launched additional modules in CRM-system, thus improving the efficiency of the sales team *Leaded analytical team

Carlsberg Ukraine | Sep 2011 - Dec 2013

CRM Analyst

* Launched data exchange and supported it between CRM Carlsberg Ukraine and ERP-system of distributors. * Analysed of volume sales, identified weaknesses and ways to increase efficiency * Did presentations and analytical reports

UKRAINIAN AEROSOLS LLC | Sep 2010 - Jul 2011

Business Analyst

*Analysed sales dynamics and trends in the various sections and levels. * Wrought business plans for entering new markets, and spread the distribution network * Analysed of financial results of the company, accounts receivable. * Used to monitoring changes in raw material prices. * Supported prices calculation

Trading House "PE Butyrin" | Jun 2009 - Sep 2010

Business Analyst

* Description of business processes and their optimisation (IDEF 0, organizational structure, workflow)  *Launched system of electronic document management (EDMS "Motive", configured the server, created a corporate structure, launched user training, administrated database)  * Launched ERP-system for small business (controled developers team and worked with stakeholders, testing and commissioning, training of staff)  * Developed of analytical reports (monthly and weekly - turnover, profitability, accounts receivable, stock management, sales of subsidiaries and brands)

PE Tesnovsky - DeLine | Oct 2008 - Apr 2009

Project Team Lead

* Calculated project plan and coordinated project activities  * Lead and motivate project team  * Organized promo activities  * Negotiation with clients (direct sales & telesales)

My Education

Take a look at my formal education

Master's degree, Economic and mathematical modelingDonetsk State Institute of Artificial Intelligence | 2009

About Me

Iaroslav Cherkashyn

Combining data and analytics I turn information into answers. I believe that we can defeat chaos , when we build a system

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free