Muhammad Zuhair Siddiqui

Designed and managed ETL processes using SQL to migrate tables between data warehouses, ensuring uninterrupted data flow and system integration. Developed complex queries using JOINs, Subqueries, case statements, and window functions to create tables from multiple sources while optimizing stored procedures for efficient data management. Integrated AI features of Power BI, such as Q&A, to enable intuitive, natural-language-based data exploration, enhancing user accessibility and decision-making efficiency.

Conducted comprehensive data analysis and performed data cleaning procedures to enhance database accuracy and reliability. Executed SQL queries to identify and rectify data inconsistencies, duplicates, and anomalies, resulting in improvement in data quality. Designed and built a visually engaging Power BI dashboards that provided actional insights by consolidating and visualizing complex datasets.

Led a data migration project for all the business units from the Oracle databases to Microsoft Dynamics 365. Utilized SQL queries to extract data and conducted data cleaning and conversion using MS Excel, ensuring accurate alignment with the revised Microsoft Dynamics 365 templates. Uploaded the cleaned and mapped data from Excel to Microsoft Dynamics 365 successfully, completing the project 30% ahead of schedule.