Position: Solutions Architect/ Developer
Category: SQL
English level: fluent
Years of experience: 11

Designed from scratch Azure BI Cloud solution for Canada's largest direct online-only mattress store. Integrated Shopify online store, UPS/FedEx/Frontier shipping companies with Azure SQL DB using Azure Data Factory, Azure SSIS Integration Runtime, and Azure Logic Apps and Azure Blob storage account. Deployed framework for implementing “learning machine” solutions for advertisements/sales performance predictive analysis. Designed BI reporting solution using Power BI.
Migration of existent SSRS reports from on-premises VM to Power BI Reporting Services and to Power BI Workspaces (Premium Capacity). SSRS reports changes with Power BI Report Builder. SQL DBs migration planning from on-premises VMs to Azure. Azure Migrate and Database Migration Services. Migration of SSIS projects from on-prem to Azure Data Factory. Redesign and performance optimization of ADF pipelines with SSIS IR to pure ADF pipelines. Azure subscription cost optimizatuon.
20+ years of experience in a Information Technologies software development in various fields including business and system analysis, design, development, deployment, testing, implementation and long term software support.
Specialties: Support, design and development using contemporary software tools and platforms (MS Azure, Azure Data Factory, AWS, SQL Server, SSIS, SSRS, SSAS, MDS, MQS, Power BI, SharePoint, Office 365)
Cloud Technologies: MS Azure (IaaS; DBaaS; Data Factory V2; Blob Storage; SSIS Integration Runtime;  Azure Logic Apps; Active Directory; Office 365 Integration; Automation Account; Cosmos DB; Migration from on-promises; Azure Gateway)
Systems Analysis and Design Methodologies, Environments, and Tools: Distributed System Designers in Visual Studio; MS Visual Database Tools/Server Explorer for MS SQL Server and Oracle database design
Business Intelligence (BI) Methodologies, Environments, and Business Intelligence Development Studio in MS SQL Server 2005/2008/2012/2016/2019 Analysis (SSAS), Reporting (SSRS), Integration Services (SSIS), Master Data Services (MDS), Data Quality Services (DQS) and Data Transformation Services (DTS) as part of MS SQL Server 2000; MS Excel (Pivot Tables), MS Power View/Pivot, Query; MS Power BI Desktop and Service 
RDBMS and Related Technologies: Client-Server; MS SQL Server 4.21-2000/2005/2008/2012/2014/2016; SSIS, SSRS, SSAS, MDS, DQS; Oracle 10g DB; ADO.NET , OLE DB, ODBC for data exchange with different data sources including MS SQL Server and Oracle DBs; MS Access 2.0-2013; FoxPro
I am looking for 100% remote job in support, design and development using contemporary software tools and platforms (MS Azure, SQL Server, ADF, SSIS, SSRS, SSAS, MDS, MQS, Power BI, SharePoint, Office 365).
Arcitecture, design and implementation of clmplex BI DWH solutions in MS Azure and on-prem environments.