• Desing the Intial Cloud migration Stretagy for the on Prem Data Warehouse.
• Developed the comonent with parallel execution for the faster cloud data migration
• Designed the data model, deployment architecture, hardware sizing for the Data Services requirement implemented using SQL Server.
• Worked on design for the Azure migration approach of the On-Prem Data Warehouse.
• Implemented Self-service BI solution.
• Created SSIS packages tothe data from legacy data source system to SQL Server. Implemented a variety of transformations, for example Slowly Changing Dimensions, Look up, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Involved in creation of Tabular Data Model and DAX calculations for SSAS.
• Hosted the SSAS services on IIS for the HTTP Access

Technical Skills :Azure SQL Database, Azure DWH, Azure Data Lake Store, SQL Server 2016/14/12, SSAS, SSRS, SSIS, Power BI, Tableau, SAP BO

• Desing the Intial Cloud migration Stretagy for the on Prem Data Warehouse.
• Developed the comonent with parallel execution for the faster cloud data migration
• Designed the data model, deployment architecture, hardware sizing for the Data Services requirement implemented using SQL Server.
• Worked on design for the Azure migration approach of the On-Prem Data Warehouse.
• Implemented Self-service BI solution.
• Created SSIS packages tothe data from legacy data source system to SQL Server. Implemented a variety of transformations, for example Slowly Changing Dimensions, Look up, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Involved in creation of Tabular Data Model and DAX calculations for SSAS.
• Hosted the SSAS services on IIS for the HTTP Access

Technical Skills :SQL Server 2016/14/12, SSAS,SSRS,SSIS,Power BI, SharePoint 2013 BI, Azure SQL Database ,Azure ML, Azure DWH, Azure Data Factory

• Involved on the requirement gathering and effort estimations for the different RFPs
• Provided data model, Deployment architecture, hardware sizing, Conceptual architecture for the Enterprise dashboard requirement implemented using SQL Server
• Implemented Self-service BI solution using Power BI and SharePoint BI.
• Developed the XMLA Scripts to automate the SSAS Cube Partition processing and process logging operations of SSAS objects using PowerShell
• Created SSIS packages included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion
• Developed Calculations including the time intelligence and KPIs using MDX in the multi-dimensional cube.
• Involved in creation of Tabular Data Model and DAX calculations for SSAS 2014
• Created the reports with various Microsoft reporting platforms like SSRS, Power View, Power Pivot and Performance Point Services
• Designed Ad hoc reports, Drill down reports, stepped reports, matrix reports, and table reports.
• Designed and Deployed reports in SQL Server Reporting Services (SP Integrated) and SharePoint PerformancePoint Services.

Technology : SQL Server 2014, SSIS, Power BI

• Involved on the requirement gathering and effort estimations
• Designed the end to end System Architecture along with the Data Model, Deployment architecture
• Created the SSIS Packages to Load the data from On-Premise database to Azure Blob storage on scheduled bases.
• Designed and Deployed Power BI Dashboards and Reports with the scheduled data refresh.

Technical Skills :SQL Server 2012,SSIS, Power BI, Share Point,SSAS

• Proactively involved to find business problem and proposed the best suited solution using existing stack of software and skills.
• Designed the end to end System Architecture along with the Data Model.
• Developed the Power view reports integrated with Share Point using Power Pivot SSAS Instance.
• Designed Deployment architecture and implemented the same on Share Point Power Pivot Instance of SSAS.

Technical Skills : Azure DWH, Azure Machine Learning, R ,Azure Data Factory, Power BI, Azure Stream Analytics

• Created ADF jobs to load the data to the Azure DWH.
• Created the Azure ML model to classify the sentiment of the Tweets using classification algorithms.
• Created R scripts for the data cleansing and formatting.
• Designed and Deployed Power BI Dashboards to show real time tweet analytics using Stream Analytics.

Technical Skills : SQL Server 2014,Windows server 2012,SSRS,SSIS,SSAS.

• Created SQL Agent job for SQL Server Profiler Analysis Services trace data.
• Designed and Deployed SSIS packages for Loading the trace data in to the Data base using automated SQL Agent job.
• Configure the Management Data Warehouse to collect Analysis Services Performance counters.
• Designed and Deployed SSRS, Power View Reports for visualizing the performance related data.

Technical Skills :SQL Server 2014,SSAS,SSRS,Share Point 2013, SharePoint BI, Power BI,Azure Machine learning ,R

• Involved in designing the data model for the Banking Analytics solution
• Involved to planning and designing SSAS 2014 Cubes
• Worked on building attribute relationships, Hierarchies and Fact Dimensions.
• Created the Azure ML model to predict customer churn using classification algorithm.
• Designed and Deployed the reports with various Microsoft reporting platforms like SSRS, Power View, Power Pivot and Performance Point Services

Technical Skills : SQL Server 2005, SSAS 2005 and 2008, SSIS 2005, SSRS,.NET

• Involved in Business Process, Client and prospective business demo’s and interaction with BA and end users.
• Investigating and gathering the requirements.
• Deployment of SSIS packages, SSAS Cubes and SSRS reports
• DevelopedStored Procedures, Triggers,andSQL scripts for performing automation tasks for SQL Server 2005.
• Involved in Creation, Development and Deployment of SSIS packages
• Responsible for Effort estimation, Analysis, Design, Development, UAT Support, Implementation, Post Implementation Support and Quality