Arun Kumar Email & Phone Number

PROFILE SUMMARY (19 Years of experience) Experienced and dedicated Senior BI Specialist and Architect with several years of experience. I have been involved with customers for business requirement discussions, DB Design, and Data Modelling. Certified DP-600 - Fabric Analytics Engineer Associate , DP-203 - Azure Data Engineer Associate.I have rich experience working at customer locations in Telford, UK, and Hamburg, Germany. Having German knowledge around A2 and enhancing my German skills.Have exposure to designing pipelines in Synapses Dedicated Pool, Serverless Pool, Azure Data Factory, Delta Architecture, Medallion Architect(Bronze layer, Silver layer, Gold layer) Using DataBricks, PySpark notebooks in DataBricks, Synapses, and Hive Metastore. Having knowledge in Delta LiveTable, and Auto Loader.Involved in transforming and processing the data using Azure SQL Database, Azure Data Factory, Azure Synapses, C#, Power Automate, Azure Analysis Services, Azure Key Vault, Power BI, DAX, and SharePoint, JSON, XML.Exposure in Datalake Gen2, Blob Storage, Azure Analysis Service. Have Exposure to DAX Studio and knowledge of Tabular Editor and having knowledge in Elastic Pool - Azure SQL PaaS.I have been involved over the years in performance tuning in SQL Server and Oracle databases, cube optimization for Azure Analysis Service, and Power BI Data, I have worked in ETL and ELT tools technologies like Oracle Data Integrator (ELT), Iway Data Migrator (ETL), SSIS(ETL)Have been involved in writing TSQL Code, optimization, reading the plan and usage of optimization hints, Analytical functions, cursors, constraints, column store index, system version, Change Data Capture, external table, Execution plan, indexing, defrag in cluster index, bulk insert, BCP utility, partitioning.I have exposure to tools like DAX Studio, SQL Profiler, data modeling in Visio, and knowledge of tabular editor. I have exposure to Performance Analyzer, Vertipaq engine, Storage Engine, and Formula Engine and exposure in Logic Apps , Power Automate with Graph API, teams.Involved in designing the Power BI dashboards having various visualizations like cards, bar charts, etc., and refreshing the Power BI dashboard using the logic app and Power Automate flows. Connecting PowerBI dashboards with Synapse dedicated pool, serverless pool, and Azure Analysis Services.Involved in C# code integration with Power BI Share Dataset, knowledge in Python integration with Power BI using libraries like matplotlib, seaborn, and pandas.Oracle Certified (OCA SQL & PL/SQL).