· Cortana Intelligence Suite – Stream Analytics, Azure SQL DWH, Azure Data factory, Power BI, HDInsight, Machine Learning.
· Azure Data factory
o ADF Map Reduce Activity for Training/Scoring pipeline using R-Script.(Predictive Analysis)
o Training/Scoring pipeline for consuming Azure Machine learning Web Service using web service parameters.
o Data Ingestion from On Premise Sources like CSV,SQL Server to Azure Blob Storage using ADF.
o ADF Stored Proc Activity for Data Transformation.
· Data Ingestion from external sources like FTP servers and files hosted on Share point servers via Azure Logic Apps
· Data Ingestion from On Premise Data sources (CSV,SQL Server) to Azure Storage services using SSIS packages with Azure Feature packs.
· Spinning and deletion of HDInsight Cluster using Azure Automation runbooks.
· Experience in developing and managing reporting solutions, dashboards & scorecards using Microsoft BI technologies (Power Pivot, Excel pivot tables, Power Pivots, Power BI, SSRS).
· Feature Extraction and Feature Engineering using R.
· Building Predictive models using Azure Machine Learning, Microsoft R Machine Learning Library.
· Broad experience in Query Optimization and performance tuning of SQL queries using SQL Profiler and Database tuning advisor.
· Experience in OLTP/OLAP system, Analysis and modelling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modelling.