Shivanchal Khare

Badges

Certifications

shivanchalkhare has not earned any certificates yet.

Work Experience

Senior Software Engineer
Planon• August 2019 - Present
Provide an optimum In-house BI Solution using Azure Cloud Data platform and Power BI Develop & Monitor various ADF pipelines to bring in the Enterprise data into staging from various sources Develop & maintain 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 Automate several alerts and data hygiene checks in Data warehouse using Azure Logic Apps Implement Row level security on AAS Tabular model & PBI report to restrict data access to given users
Senior Software Engineer
Technovert• December 2017 - August 2019
Served multiple clients in Real estate, Retail, and Energy domains to provide Data warehousing & BI solutions on Microsoft and Azure Platform Provided Data cleansing, munging, and shaping 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
Software Engineer
Cognizant Technology Solutions• November 2014 - December 2017
Served multiple Healthcare clients as ETL & Report developer using MSBI platform (SSIS, SSRS & SSAS) Created & Optimized SQL server stored procedures as well as MDX queries for SSRS Reports Developed various SSIS packages to create SCD-1/SCD-2 Dimensions and Facts in EDW on SQL Server Completed CATP training on Informatica, UNIX, MySQL & Oracle