Position: Software Developer
Category: SQL
English level: upper
Years of experience: 4

1) Microsoft Technology Associate: Database Fundamentals
2) Microsoft Certified: Azure Data Fundamentals
3) Microsoft Certified: Power BI Data Analyst Associate
4) Microsoft Certified: Azure Enterprise Data Analyst Associate
I am an Azure-certified engineer with a keen interest in data-related technologies. I have practical experience in implementing databases and creating Power BI reports from scratch, as well as supporting existing solutions (Logistics and transportation, banking and finance, and government industries)

Projects
ERP system for Canadian recycling and recovery management company
Responsibilities:
•	Supported OLTP/OLAP databases design, creation, and testing activities
Responsibilities:
•	Supported OLTP/OLAP databases design, creation, and testing activities
•	Created complex views, functions, and stored procedures to support application development
•	Implemented optimized T-SQL queries for satisfying customer’s business needs
•	Monitored performance and performed script tuning to improve database efficiency
•	Created dashboards and interactive visual reports using Power BI 
•	Ensured effective communication with the client, regularly clarified requirements, and provided demos to showcase our progress and gather feedback
Tools and technologies: Azure SQL Database, Azure Data Factory, Power BI, Profiler, Azure Portal, Git.
------------------------------------------------------------------------
Implementing reporting system for a Canadian finance company
Responsibilities:
•	Requirements analysis and clarification
•	Writing complex DAX functions in Power BI
•	Creating and writing logic for the proper functioning of the report elements according to the specified requirements
•	Creating complex Power BI reports with a lot of KPIs, charts, tooltips, measures, calculated columns etc 
Tools and technologies: 
MS SQL Server, DAX, Power Query M, Power BI, Power Query