Learn Data Skills
Iaroslav Cherkashyn

Iaroslav Cherkashyn

Data Analyst

Freelancer | Hungary

Technologies

My Portfolio Highlights

My New Course

Reporting in SQL

My New Course

Introduction to Snowflake SQL

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
Intermediate Python
AI Ethics
Understanding Data Science

My Work Experience

Where I've interned and worked during my career.

Sanofi | Mar 2024 - Present

Data Analyst

Data Governance and Integration: Implement and maintain data quality controls, governance processes, and integration methodologies for customer interaction data from multiple sources including sales force, medical interactions, HQ interactions, CRM systems, and websites. Business Rules and KPI Management: Develop, optimize, and manage business rules and KPIs that effectively categorize, analyze, and align with various types of customer interactions across all channels. Multichannel Data Analysis and Reporting: Perform in-depth analysis of integrated customer interaction data from all channels, creating comprehensive reports and dashboards to communicate insights and trends that support decision-making. Continuous Improvement and Stakeholder Management: Stay updated with industry best practices, propose improvements to data processes, and act as a liaison between technical teams and business users, providing guidance on multichannel data interpretation and usage. Customer Interaction Analytics and Insights: Develop and implement analytics models to identify trends, patterns, and opportunities from integrated multichannel data, providing actionable insights to improve customer engagement strategies across all interaction points
Show More

EPAM Systems | Apr 2022 - Jan 2024

BI Analyst

of a proactive product manager. Collaborated closely with stakeholders to meticulously define project objectives and expectations, ensuring a comprehensive understanding of deliverables and outcome * Devised a structured roadmap for feature implementation, breaking it down into granular tasks and orchestrating the development team's efforts. Conveyed the intricate technical solution to stakeholders through engaging presentations, demonstrating a clear alignment of the solution with business objectives. * Architect a robust (ETL) mapping framework, facilitating seamless data movement between systems. Utilized advanced data profiling techniques to meticulously analyze data sources, ensuring accuracy, consistency, and adherence to quality standards * Created meticulous documentation encompassing all project facets, from requirements and design to implementation details. Precisely outlined the technical solution, enabling seamless knowledge transfer and future reference for team members and stakeholders alike * Personally executed comprehensive manual testing of report implementations, meticulously validating their accuracy and functionality. Ensured data quality through rigorous testing procedures, upholding the highest standards of precision and reliability * Skilfully developed interactive dashboards using Grafana and Looker Studio, enabling stakeholders to visually comprehend intricate data patterns. These visually appealing and user-friendly dashboards empowered stakeholders with real-time insights, enhancing operational efficiency

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

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