Юлія

BLAHII YULIIA
DATA ANALYST (Full-time)

 [open contact info](look above in the "contact info" section)
Five years ago, I had already tried my hand as a Data Analyst. After taking courses in SQL and R, I was
[open contact info](look above in the "contact info" section), convinced that this is what I wanted to do. Probably because I feel that in such a job, I will be able to
 https://github.com/YuliyaBl realize my long-standing love of mathematics and analysis. But at that time the choice of such work in
Temporarily live in Michigan, USA. Ready my city (Mykolaiv) was absent, and distance form is not so widespread. Now I am no longer tied to the
town and have a lot of experience working remotely for a foreign customer in IT, so in recent months I
 to come back in Ukraine or relocate in
other country am recovering the necessary knowledge. I’ve already taken five intensive SQL, Python and Power BI
courses. I think my ability to get into the heart of things and my years of experience in the analysis
will help me quickly learn all the nuances of this job.
Skills

MS Excel – high level (10-years of Experience
experience), Google Sheet
Microsoft Excel IT Specialist May 2017 - Present time
Understanding of relational
Nexteum (maintenance of a network of online stores in the field of auto-tuning,
databases, knowledge of SQL
motorsports,andoutdoor activities)
Power BI Mykolaiv, Ukraine

Python (Numpy, Pandas, Functional responsibilities:
Matplotlib)
working with price and application files from vendors - data extraction, aggregation, processing,
Familiar with the technique analysis of inconsistencies, correction, consolidation into a single form - a generalized check file,
SCRUM based on which other teams load brand products into the online store. In the process of work I
Jupiter Notebook, Google Collab came across all possible data storages, various data formats, and methods of their processing,
mainly in MS Excel.
Communication with data suppliers when controversial issues arise.
Certification

SQL Fundamentals (MySQL) Analyst August 2011 - May 2017

hyperskill.org Epicenter K (DIY chain of building and home improvement hypermarket) Mykolaiv, Ukraine
November 2022 -
Functional responsibilities
creating and preparing operational and final reports of the department, analysis of various
metrics (sales in the context of product categories, stock balances, cash receipts, indicators of
Analyzing and Visualizing Data with
saleable goods, orders in the context of suppliers and product groups, etc.)
Power BI
establishment of forecast planned indicators per month, control over their implementation.
DavidsonX on Edx
Thanks to my prompt analysis and recommendations to improve sales of certain product groups, my
August 2022 - October 2022
department often fulfilled the sales plan for the month and consistently showed a positive sales
trend up to last month. My work on product ordering and constant recommendations on unsold goods
Data analysis with Python ("dead goods") also contributed to my department holding the first place in the network for unsold
www.freecodecamp.org goods ("dead goods").
July 2022 - August 2022

Education
Numpy
www.freecodecamp.org Faculty of Economics. Speciality Finance. Master’s degree with honors. 2003 - 2008
July 2022 - Petro Mohyla Black Sea National University of Ukraine, Mykolaiv, Ukraine

Databases and SQL in data processing
Languages
and analysis
IBM Skills Network on Coursera English - Upper Intermediate (the written level is higher)
June 2022 - July 2022 Ukrainian
Russian