Олексій

Oleksii Rud
Ukraine

Tel: [open contact info](look above in the "contact info" section)
Telegram: Oleksii Rud
E-mail: [open contact info](look above in the "contact info" section)

Summary
- 2 years in Data Analytics
- 2 years as Legal Adviser

- Specialist of Protection of Restricted Information; Karate teacher
- Knowledge of MySQL
- Knowledge of PowerBI
- Basic knowledge of Python
- Creative, communicable, responsible, self-motivated, supportive, kind, persistent, purposeful

Technical Skills
Skill Category Skill list

Data Analysis Technologies SQL, PowerBI, DAX, Basic Python, Excel,
Google sheets

Programming Languages and Python (Pandas, NumPy, Plotly, Matplotlib,
Frameworks Sklearn)

RDBMS MySQL

Development Tools MySQL Workbench, VS Code, Jupiter Notebook,
Version Control Systems (GIT)

Operating System Windows

Foreign languages skills

Language Written Spoken

English intermediate intermediate
Work Experience:

2007- present - karate teacher
2013 - 2015 - legal adviser, Ukrsibbank
2022 - 2023 – served in the Armed Forces of Ukraine

Data Analyst, Researcher
Students DB Analysis Project
2023-2024
Project Development and implementation of analytical panels for effective analysis of data on the return and
ordering of fashionable clothes, shoes, and accessories.
- Studied the requirements and needs of the business regarding the analysis of return and order data.
- Cleared data from duplicates and anomalies.
- Using MySQL extracted and processed data from sources.
- Using Python (Pandas, NumPy, Plotly) developed scripts for data analysis and visualization.
- Using DAX (Data Analysis Expressions) performed calculations and formulate metrics.
- Developed formulas for determining important sales, procurement, and strategic planning indicators.

Technologies:
- MySQL for processing and extracting data.
- Python (Pandas, NumPy, Plotly).
- PowerBI to create dashboards and BI reports.
- Google Sheets to store and share data.

Data Analyst, Researcher
Enterprise Data Analysis and Visualization
2024
Project Development and implementation of a data analysis and visualization project to support strategic planning
and enterprise management.
- Collected and prepared data from a variety of sources, including MySQL databases.
- cleaned and checked data for accuracy and completeness.
- Used Python libraries (Pandas, NumPy, Plotly) for data analysis and processing.
- Using PowerBI created visuals such as graphs and charts.

Education:
In 2011 year: National Academy of the Security Service of Ukraine. Specialist in the organization of protection of
information with limited access.
In 2016 year: National University of Physical Education and Development. Specialist. Karate Coach.
Courses: English, B1+.
Interests: data, research, English, philosophy, karate-do.