Position: BI analyst, Data analyst
Category: Data Analyst
English level: upper
Years of experience: 4

BI developing:
- In 6 months developed 12 dashboards from zero for 3 group of companies (Retail and Distribution);
- Organizing and designing appropriate data warehouse for more than 1 billion rows data;
Data analysis:
• Active participation in stretch planning processes: sales base cleaning, trade activities and promo calculations, demand planning accuracy, forecasting;
• Improved method of calculating Sell In forecast by categories Mars, Wrigley and Skittles: Demand planning accuracy (DPA) – 98%
- Coaching and mentoring BI developers and analysts team (5 members);
- Developing strategic, operational dashboards from zero, using Qlik Sense and Power BI, implementing best practices of data modeling (Snowflake, Star Scheme) and visualizations;
- Importing data from PostgreSQL, MSSQL databases using a query (join, aggregation functions);
- Performing ETL processes at the script part while importing data;
- Organizing and designing appropriate data warehouse using QVDs and daily updating data with task planning (QMC) – Fact tables (sales, orders, stock) and dimensions;
- Creating documentation and guidance of dashboards for users.