Position: BI Developer/Data Analyst
Category: Data Analyst
English level: intermediate
Years of experience: 5

- optimized Excel reports which are provided on daily basis (time for preparing reports takes 1-2 minutes instead of 2-4 hours)
- Implemented BI system for company with different domains such as logistics, sales, HR, retail
- created hard DAX measures, created complex data models (100+ tables)
- written program for processing data in the PowerBI tables (SSAS)
- mentoring junior team members
- rebuilt BI internal reports (united 15+ complex reports to one data model - previously each report had its data model)
- written complex SQL queries (recursive CTE, triggers, merge, functions, window functions, procedures, pivoting/unpivoting tables, dynamic SQL)
- Data Analyst (automated Excel reports with VBA, SQL, PowerPivot, ad-hoc reports)
 - BI Developer (implementation BI system for internal users, strong PowerBI data modeling, DAX, SQL, PowerQuery, data visualization, reports with any level of complexity, gathering requirements from stakeholders, Optimization of existing internal PowerBI reports (rebuild data model))
 - Mentoring junior team members
 - Working with SSAS