Learn Data Skills
Beta
Volodymyr Panchenko

Volodymyr Panchenko

Data Analyst

EU Business School | Ukraine

Technologies

My Portfolio Highlights

My New Course

Introduction to SQL

Data virtuoso, transforming raw numbers into a masterpiece of understanding.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Intermediate SQL

course

Joining Data in SQL

DataCamp Course Completion

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

My Work Experience

Where I've interned and worked during my career.

Daymon | Dec 2022 - Present

Category Management Analyst

N/A

Епіцентр К | Jun 2020 - Nov 2022

Procurement Manager

-Budget & Supply management for 12-month supply -Managed $10M retail portfolio of company's flagship products -Increased year over year sales 4% while increasing profit margin 2.5% through coordination of new promotions, SKU rationalisation, and planogram development -Achieved cost-effective procurement outcomes by establishing strong partnerships -Work closely with key stakeholders to develop and implement effective sourcing strategies -Supervised custom clearance process and audit of documents -Utilised ERP system reports, Microsoft Excel, Power BI, and Pivot Tables to build and analyse reports in order to find problem areas and create solutions.
Show More

Епіцентр К | Mar 2018 - May 2020

Supply Chain Analyst

-Supply planning for 12-month turnover -Optimized supply chain tactical activities to increase supplier on-time delivery by 25% -Made forecast recommendations to ensure proper level of inventory in warehouse for more than 5K SKUs -Served as liaison between distribution center, purchasing, inventory management and logistic departments to ensure proper flow of product through supply chain. -Improved forecast accuracy to 94% from initial 78% accuracy -Tracked, analysed and interpreted trends in sales and inventory data and created reports using Power BI to track inventory at over 75 stores and 3 distribution centers. -Created visualisations of data and live dashboards using Power BI

Епіцентр К | Oct 2016 - Mar 2018

Business Data Analyst

-Process data and develop reports and dashboards for assigned projects, including the use of SQL, advanced Excel & Power BI -Supported customer service department and increased customers' positive feedback rate from 83% to 95% Predicted customers preference based on order history to maximize sales efficiency using logistic regression & SQL Troubleshoot issues with obtaining supplier product/process issues to ensure all required information is accurately captured and implemented within global ERP system. -Utilized SQL server for select statements needed to access data from different schemas containing data stored. -Use reporting tools for analysis and manipulation of large sets of data for data driven decision making -Worked in analysing and mining data to design analytics -Analysed and wrote SQL queries in database environment. -Developed Key Performance Indicators and to monitor product sales and operations of vendors and fulfilment centers.

My Education

Take a look at my formal education

Bachelor of Business Administration - BBA, Business Administration and Management, GeneralEU Business School | 2022
Business Administration and Management, GeneralInternational University in Geneva | 2016
Business Administration and Management, General  · (SeptemberAmerican University of Sharjah | 2013

About Me

Volodymyr Panchenko

Achievement driven and result oriented

Powered by

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