Shivanchal Khare

• Served leading Energy provider in US as a Lead Data Engineer to provide data migration solutions using Azure technology
• Worked on ADF, Databricks, ADLS, Azure SQL Database, Azure Event Hubs, and Qlik replicate to process batch and streaming data.
• Data sources/format handled: relational databases, JSON data stream from Event hubs, Rest APIs, Sharepoint, Smartsheet, SFTP CSV and Excel files,
• Resolved SNOW tickets and incidents during Ops rotation process with optimal solutions
• Led an organizational initiative to build Retail use cases on Azure Synapse to attract retail clients to the Organization
• Did ETL/Report migration for Internal IT project from On-prem to Azure platform. Used ADF, SSIS, Power BI, Azure SQL Database, and Azure Devops.

• Provided an optimum In-house BI Solution using Azure Cloud Data platform and Power BI
• Developed & Monitored various ADF pipelines to bring in the Enterprise data into staging from various sources
• Developed & maintained a centralized Data warehouse using Azure SQL Database and Tabular model on Azure Analysis services for reporting purpose
• Optimize various Financial, Operational, Accounting and KPI Reports using Power BI dataflows
• Solely developed CI/CD pipelines for ADF code deployment from Development to Test and Production environments using Release pipelines in Azure DevOps by leveraging Azure Key vault, Git & Blob storage
• Implemented Row level security on AAS Tabular model & PBI report to restrict data access to given users

· Served multiple clients in Real estate, Retail, and Energy domains to provide Data warehousing & BI solutions on Microsoft and Azure Platform

• Provided Data processing using SSIS packages to provide ETL solutions to store data in required format from sources like Azure DB, Sharepoint Lists, Denodo, Salesforce, Excel, etc
• Provided Centralized Enterprise data model on SSAS Multidimensional cube for OLAP solution
• Developed, Optimized & Automated numerous reports on Power BI (Service/Report Server) & SSRS
• Served as a Release Manager to deploy Developers' code to various environments using TFS
• Worked in Pre-sales team to develop several Power BI Dashboards leveraging features like Drill-down, Drill-through, bookmarks and Q&A to convince & attract potential prospects

• Served multiple US Healthcare clients as ETL & Report developer using MSBI platform (SSIS, SSRS & SSAS)
• Created SSIS packages to migrate data from various sources to SQL Server datawarehouse
• Created & Optimized SQL server stored procedures as well as MDX queries for SSRS Reports
• Completed CATP training on Informatica, UNIX, MySQL & Oracle