Dilip Padala

Background

About Dilip Padala

Experience in MS SQL Server suite of products(SSIS, SSRS, SSAS, OLTP, OLAP, SCD & Data Migration)and involved in all phases of SDLC from planning, gathering requirement, designing, development, testing, implementation, operations & maintenance. Developed plans aligned to strategy, driving actions & staying focused on the right priorities & outcomes. Created complex Stored Procedure, Functions, Views, Indexes & used Temp tables, Table variables & CTE’s depending on the requirement. Checking in every code into TFS & using Azure DevOps GIT for creating pull request to deploy pipelines to ADF. Created service principle using app registration & Azure Key Vault to grant access to our data lake files. Experience in high level design of ETL/ELT pipelines for integrating data from heterogeneous data sources into On-prem DB, Azure data lake gen1/Azure SQL Server using SSIS, Informatica Intelligence Cloud Services(IICS) & Azure ADF V1 & V2. Created U-SQL/data flow for SCD type2 transformation and file archiving process inside every pipeline & deployed to Azure blob container. Scheduled jobs to run on specified frequency using SQL agent, UC4 Automic and triggers in Azure ADF. Designed & developed various complex reports such as Drill down, Drill Through, Sub reports, Tabular, linked, Parameterized, Pie charts etc. using expressions, global variables and hierarchy structure in Visual Studio TFS/Power BI/Report Builder/tableau and published to SSRS, SharePoint Services & Power BI premium workspaces to export into PDF, PowerPoint & Excel. Designed analytical data models(cubes) using SSAS to source data from azure data lake gen1, SQL server & created measures/KPIs using DAX expressions, row level security using AD groups which later used in Power BI/Tableau reporting & self-service model for back office associates. Automated the model to run on scheduled frequency using logic app which is triggered through a pipeline in ADF. Perform performance tuning, debugging, code implementation and troubleshooting for any issue reported by business users using Azure Databricks, U-SQL & develop technical & user documentation of process & upload it to SharePoint & MS teams. Having strong business acumen & sharing that knowledge with others. Leading onsite & offshore teams by training on the current processes/standards & provided business/technical guidance. Building talent by providing timely & specific feedbacks, both positive & constructive, to maximize performance. Excellent technical, communication & interpersonal skills with very good troubleshooting & problem-solving skills.