HIFSU الرحمن

• Leading enterprise BI migration to PAL NG ERP, rebuilding 50+ reports across HSQE, PMS, Crew, and Procurement.
• Mapped legacy ERP schemas to PAL NG data structures ensuring seamless migration of enterprise BI assets.
• Developed complex T-SQL solutions and rebuilt legacy reports maintaining full functional parity across business domains.
• Completed HSQE domain migration (~50 reports) now in UAT; currently progressing to PMS domain.
BI Development & Data Warehousing
• Designed and delivered enterprise MIS Dashboard covering fleet-wide KPIs across Technical, Operations, Budgets, Crew,
HSQE, and Procurement.
• Integrated multiple enterprise data sources into a centralised analytics platform supporting executive decision-making.
• Developed advanced DAX measures, calculated columns, and calculated tables for KPI Reporting and self-service BI.
• Translated complex SQL Server logic including vessel active-period expansion into DAX calculated tables in Power BI.
• Resolved critical data integrity issue in crew manhour reporting — re-engineered vessel joins from name-based to
IMO-number-based.
• Optimised dashboard load time by 30% and reduced report delivery time by 35% through automation and model tuning.
Platform Migrations & Cloud Analytics
• Led migration from Power BI PRO to Microsoft Fabric capacity across all workspaces and assets.
• Migrated SSRS reports to Fabric Paginated Reports including subscriptions and data-driven alert configurations.
• Migrated SSAS tabular cubes to Azure Analysis Services supporting cloud analytics modernisation.
Fabric Administration & Data Engineering
• Manage end-to-end Fabric/Power BI service: gateway connections, scheduled refreshes, workspace access provisioning, and
RLS role assignments.
• Configure and manage data-driven alerts and subscriptions in Microsoft Fabric for stakeholder reporting distribution.
• Write complex T-SQL using window functions (ROW_NUMBER, RANK, LEAD/LAG), CTEs, and correlated subqueries.
• Design and maintain views, stored procedures, and indexes; analyse execution plans and optimise query performance.
Environment: Power BI, Microsoft Fabric, SQL Server, T-SQL, DAX, SSAS Tabular, Azure Analysis Services, Paginated Reports, PAL
NG, NSE, Compas, IMOS, Docmap

Delivered Business Intelligence and Data Warehousing solutions for finance sector clients across loans, credit cards, and insurance
verticals.
• Designed end-to-end BI solutions for Royal Bank of Canada (RBC-PFS Data Warehouse — Loans, Credit Cards, Insurance,
Accounts) and SanDisk (Sales Analytical System).
• Optimised data models and data warehousing structures achieving 50% reduction in dashboard refresh times.
• Automated key financial reports saving 10+ hours of manual work per week for finance teams.
• Built executive dashboards with drill-through, drill-down, bookmarks, and conditional formatting.
• Implemented RLS in Power BI and SSAS tabular models; managed many-to-many relationships and active/inactive
relationships.
• Integrated multiple enterprise data sources (Azure SQL, Blob Storage, Data Lake Gen2, SQL Server) reducing retrieval time
by 50%.
• Migrated on-premise databases to Azure SQL using DACPAC, BACPAC, and Data Migration Assistance (DMA).
• Streamlined data collection pipelines with IT teams, reducing data processing time by 25%. Improved self-service BI capabilities through interactive visualisations, user engagement