Position: BI Architect
Category: Data Analyst
English level: upper
Years of experience: 10

•	Enterprise Data Warehouse
Developed an enterprise data warehouse solution from scratch for one of the biggest food-tech companies.
The data warehouse is based on the Microsoft technology stack–Azure Synapse and Power Platform. It is a low-cost, easy to develop, and scalable solution.

•	Single Version of Truth solution
State of the art OLAP database included all main business metrics based on Power BI Premium as a superset of Analysis Services. The solution provided blazing fast access not only to archived cold data but to the real-time operational data also. Data available from Power BI, Excel and API.

•	Master Data Management solution
Master Data Management application for responsibilities persons in the organization. Allows control access to business data in a convenient way. Based on SharePoint lists, Azure AD, and Logic Apps. Integrated with Power BI Services.
Ivan is a data enthusiast with over ten years of experience in the IT sector, working as a database developer and business intelligence solution architect. He is an expert in the Microsoft technology stack, including Azure SQL Database, Synapse Analytics, Data Factory, Logic Apps, Functions, Data Explorer, and Power BI. Ivan is looking for projects that will allow him to work with data and get valuable insights to solve business tasks.

•	Head of BI 2020 - PRESENT
o	Built a business intelligence platform for more than 5,000 employees.
o	Developed Single Version of Truth solution, based on Power BI Premium OLAP capabilities and Azure.
o	Created a CRM solution for the customer support department.
Technologies: SQL, Azure, Databases, Integration, Analytics, Microsoft Power BI, Business Intelligence (BI), Data Reporting, Data Analysis

•	Data Engineer 2018 - 2020
o	Developed the enterprise data warehouse solution from scratch. Based on Azure Synapse Analytics and Power Platform.
o	Built tons of ETL pipelines for data gathering and data processing. Based on Azure Data Factory, Azure Functions, Azure App Logic.
o	Managed a Data Team, providing best practices and tooling support.
Technologies: Azure Synapse, Business Intelligence (BI), Microsoft Power BI, SQL, ClickHouse, Azure, Python, C#, PostgreSQL, Windows PowerShell, Azure SQL Data Warehouse (SQL DW), Azure Data Factory, Data Engineering, ETL

•	Data Analyst
2017 - 2018 Samokat
o	Supported business by providing ad-hoc analysis for company top management.
o	Built a number of essential Power BI reports for the line of business.
o	Developed and support databases for data analysis purposes.
Technologies: SQL, Microsoft Power BI, Azure, Analytics

•	Data Model Architect
2017 - 2017 Magnit
o	Developed and supported business data models in the organization.
o	Optimized and analyzed SQL code and Data Warehouse solution.
o	Developed visualizations for Data Warehouse activities on Python.