Davendra Kumar

Led and implement Data and BI modernization initiatives migrating ERP data from SAP S4/HANA with help of Datasphere to Azure Databricks Lakehouse architecture for Manufacturing domain. Review TDD documents updated/created by team based upon FDD/mapping received from business related to Supplier Master Validation, timesheet, Project Month to End Report etc. Allocation & monitoring of allocated task in team while implementation. Led & review addition of new data sources with ADF pipeline to place in Landing zone in ADLS-GEN2. Led data architecture design using Medallion framework (Bronze, Silver, Gold layers). Implemented Unity Catalog governance, role-based access control (RBAC), and data security standards. Established CI/CD pipelines using Azure DevOps for automated deployment of Databricks notebooks and workflows. Managed cross-functional to deliver to fixed price project. Conduct & Review SIT with team and UAT with customer and update the feedback accordingly. Led new reports in Power BI and pointing to Databricks SQL end point.

Led enterprise Data and BI modernization initiatives migrating legacy on-prem SQL and SSIS systems to Azure Databricks Lakehouse architecture. Defined target-state data architecture using Medallion framework (Bronze, Silver, Gold layers). Implemented Unity Catalog governance, role-based access control (RBAC), and data security standards. Established CI/CD pipelines using Azure DevOps for automated deployment of Databricks notebooks and workflows. Managed cross-functional teams using Agile methodology, sprint velocity tracking, and burn-down analysis. Conducted executive-level stakeholder reporting, risk mitigation planning, and roadmap alignment.

Led Sales Analytics transformation program using Azure Databricks and Delta Lake. Gathered business requirements and translated them into scalable data engineering solutions. Designed centralized analytics platform integrating Salesforce and SQL data sources. Delivered executive dashboards and KPI reports using Power BI.

Led Aviation Data Warehouse modernization and Azure cloud migration initiatives. Designed enterprise DWH architecture and migrated SQL workloads to Azure Managed Instance. Developed ETL pipelines using SSIS and Azure Data Factory. Implemented performance tuning and data validation frameworks.

Delivered healthcare analytics and reporting solutions supporting large operational teams. Designed and optimized enterprise ETL workflows using SSIS and SQL Server. Developed stored procedures, indexing strategies, and performance tuning solutions. Built operational dashboards using Power BI and SSRS. Automated SLA reporting systems improving operational transparency and reporting efficiency. Collaborated with business stakeholders to convert healthcare requirements into scalable data solutions.