Adilakshmi J.

Sr.Power BI Developer/Data Engineer with over 8 years of experience in Business Intelligence and Data Warehousing. • Strong command of Power BI for data import, transformation, and analysis from multiple sources, including SQL Server, Azure, Oracle, APIs, and Excel. • Advanced proficiency in crafting DAX (Data Analysis Expressions) formulas to create custom measures and calculated columns for in-depth data analysis. • Extensive experience in designing optimized data models in Power BI, establishing relationships, and creating hierarchies. • Skilled in developing visually-rich charts, matrices, maps, slicers, and gauges to deliver actionable insights. • Proficient in designing and developing multidisciplinary Power BI reports and dashboards that integrate data from diverse sources, providing a holistic view of business performance and enabling comprehensive data-driven decision-making. • Expertise in implementing Power BI features such as subscriptions, scheduled refresh, and data alerts using Power BI Gateway. • Proven ability to embed Power BI reports within internal portals and websites. • Strong familiarity with the Microsoft Power Platform, including MS Power BI, Power Automate, and Power Apps. • Proficient in SQL, including stored procedures, triggers, views, user-defined functions, sub-queries, and joins. • Strong expertise in SQL Server Integration Services (SSIS) for data integration and complex package development.. • Experience in developing and extending OLAP Cubes using SQL Analysis Services (SSAS). • Proven track record in deploying and scheduling reports using SQL Server Reporting Services (SSRS) for various reporting frequencies. • Proficient in connecting to diverse data sources within Azure Synapse, including SQL pools, serverless SQL pools, Azure Data Lake Storage, and Azure Blob Storage. • Expertise in Microsoft Azure, focusing on Azure storage, Azure SQL, Azure Synapse, Azure Data Factory (ADF), Databricks, and Azure Analysis Services (AAS). • Experience in designing and developing data pipelines in Azure Data Factory (ADF) for data extraction from multiple sources • Dedicated to providing training and support to end-users