MUHAMMAD HASNAIN

BI Developer

Algo•  June 2022 - September 2023

• Collaborate on supply chain projects like Inventory Control, Forecast Accuracy, and Decile Report Chunks Analysis. • Develop and maintain seamless data processing pipelines using Azure Data Factory and Synapse Analytics. • Manage SQL Server data accurately with stored procedures, ensuring precision for Inventory Control and forecasting. • Apply organized data warehousing techniques to support supply chain data needs. • Efficiently structure large data volumes for insights into Forecast Accuracy and Decile Report Chunks Analysis. • Use SQL DAX Studio and SSAS Tabular for advanced analysis in supply chain analytics. • Monitor and troubleshoot data pipelines for reliable Inventory Control and forecasting. • Recommend continuous improvement through automation and optimization strategies. • Utilize Power BI with DAX for interactive dashboards, aiding decision-making in supply chain projects.• Collaborate on supply chain projects like Inventory Control, Forecast Accuracy, and Decile Report Chunks Analysis. • Develop and maintain seamless data processing pipelines using Azure Data Factory and Synapse Analytics. • Manage SQL Server data accurately with stored procedures, ensuring precision for Inventory Control and forecasting. • Apply organized data warehousing techniques to support supply chain data needs. • Efficiently structure large data volumes for insights into Forecast Accuracy and Decile Report Chunks Analysis. • Use SQL DAX Studio and SSAS Tabular for advanced analysis in supply chain analytics. • Monitor and troubleshoot data pipelines for reliable Inventory Control and forecasting. • Recommend continuous improvement through automation and optimization strategies. • Utilize Power BI with DAX for interactive dashboards, aiding decision-making in supply chain projects. Skills: Data Models · Azure Synapse Analytics · DAX · SQL Server Analysis Services (SSAS) · Microsoft Power BI

BI Developer

The Pentagon Food Group Ltd•  May 2021 - June 2022

• Conduct meetings with department stakeholders to gather report requirements. • Design prototype reports and dashboards, incorporating stakeholder feedback. • Translate Excel reports into Power BI reports for enhanced visualization. • Design star schema and snowflake models using Power BI Desktop. • Define dimensional hierarchies to structure data effectively. • Create SQL Server views for optimized report performance within Power BI. • Develop complex DAX measures to calculate user-defined KPIs. • Utilize DAX Studio and Tabular Editor for debugging and optimizing DAX. • Publish reports using Power BI Service for broader accessibility. • Establish workspaces in Power BI Service to organize reports department-wise. • Monitor report usage, data refreshes, and ensure security access compliance. • Conduct meetings with department stakeholders to gather report requirements. • Design prototype reports and dashboards, incorporating stakeholder feedback. • Translate Excel reports into Power BI reports for enhanced visualization. • Design star schema and snowflake models using Power BI Desktop. • Define dimensional hierarchies to structure data effectively. • Create SQL Server views for optimized report performance within Power BI. • Develop complex DAX measures to calculate user-defined KPIs. • Utilize DAX Studio and Tabular Editor for debugging and optimizing DAX. • Publish reports using Power BI Service for broader accessibility. • Establish workspaces in Power BI Service to organize reports department-wise. • Monitor report usage, data refreshes, and ensure security access compliance. Skills: Business Requirements · DAX · SQL · SQL Server Analysis Services (SSAS) · Microsoft Power BI