Position: Junior data analyst
Category: Data Analyst
English level: upper
Years of experience: 0


07.2022 - 03.2023 - 
Student Trainee Data Analytics Engineer (EPAM Systems)
Internship and training in the specialty of data engineer.
Projects:
- development of reports using SQL (SQL Server, MySQL)
- development of ETL processes using MS SSIS
- Python programming
- data processing, cleaning, transformation, visualization using Tableau, MS Power BI.

07.2017-02.2023 - Cofounder of ("Cukerna" - production and distribution of confectionery products)
IT RELATED PROJECTS:
1. Web site development:
- gathering the requirements
- writing technical requirements
- managing UX/UI specialist
- choosing the optimal CMS (Wordpress, Woocommerce for e-commerce tasks)
- managing the web-developer
- managing the content manager
- optimising site for SEO

2. Automation of B2C business.
- ETL process (sales, returns, cash, bank operations) - creating with 1c devepoler. All transactions from cash registers came to SQL server and then to DB.
- automation (the calculation, reports) of sale managers salary.
- automation of calculation of retail shop demand in production.
- financial reports creating.

MANAGEMENT TASKS:
- creating the salary system and KPI of sale managers (online, offline).
- employees recruitment, training.
- financial planning
- procurements functions.
- management of SMM manager, marketer, content managers.
- management of web developer, 1c developer, system administrator
- from zero. Development of market place direction: cooperation with rozetka ua, prom ua, crafta ua, allo ua.

11.2012-07.2017 - Deputy of comercial director
- the same tasks and responsibility as team lead of analytics department and: 
- management of retail stores chain
- management of online store (content, SEO, SMM, PPC)
- business planning
- 10 people in direct subordination, 30 - in indirect subordination

01.2007 - 11.2012 - Team Lead of Analytics
- business processes improvement (requirements gathering, design, writing the technical tasks)
- business processes automation (based on 1c, excel, google services), training users
- search for "bottle necks" in business
- financial analysis of project
- team of 4 people (2 analysts, 1c developer, QA spesialist)
- distribution of tasks, control of execution
- full cycle of software development management: gathering the requirements, design, technical tasks writing, testing, users training.
- Projects examples: accounts receivable model, KPI dashboards for employees, integration onlina and offline sales, different interfaces development ets.