Mohammed Kamil Hussain

About Mohammed Kamil Hussain

6+ years of experience as a Power BI Developer and ETL Developer, delivering end-to-end data solutions for business intelligence, analytics, and reporting across industries using cloud and on-premise environments. • Skilled in developing interactive Power BI dashboards and reports using Power BI Desktop, DAX, and Power BI Service, providing insights into key performance indicators (KPIs), financials, and operational metrics. • Expertise in designing and managing ETL pipelines using SSIS to extract, transform, and load data from multiple sources, including on-premise and cloud-based systems like Azure SQL Database and Azure Data Lake. • Proficient in data modeling, creating calculated columns, measures, hierarchies, and relationships in Power BI to drive effective decision-making and self-service analytics for business users. • Hands-on experience in data transformation using Power Query and SSIS, ensuring data quality, cleansing, and consistency across multiple data sources. • Integrated diverse data sources such as SQL Server, Azure Synapse Analytics, Azure Blob Storage, flat files, and Excel into Power BI for real-time reporting and dynamic data visualization. • Strong knowledge of incremental loading, SCD (Slowly Changing Dimensions), CDC (Change Data Capture), and data warehousing concepts to manage large datasets and ensure accurate historical reporting. • Implemented row-level security and Azure Active Directory (AAD) authentication in Power BI to control data access and maintain robust security standards. • Experience with Azure Data Factory (ADF) for orchestrating data workflows, automating data integration, and optimizing ETL processes across cloud-based environments. • Proven ability to optimize Power BI performance through performance tuning techniques such as query optimization, data compression, and efficient data model design to reduce refresh times and enhance user experience. • Experienced in leveraging Azure SQL Database, Azure Data Lake, and Azure Synapse Analytics for storing and managing large datasets, enabling seamless integration with Power BI for real-time reporting. • Collaborated with cross-functional teams to design and implement cloud-based data solutions, including Data Flows, Azure Logic Apps, and Data Gateways, for hybrid environments connecting on-premise and cloud systems. • Delivered training and support to business teams on Power BI and self-service analytics, empowering them to create their own reports and dashboards, increasing overall data literacy within the organization.

Experience

1. Technical Lead

   HCLTech

   Jan 2025 — Present · IN

Education

• Osmania University

  Bachelor of Science - BS