Lead Power BI Developer - ProArch IT Solutions
(2025-07)
Client: Almunajem Foods
- Designed and delivered demand-planning dashboards for Forecast Accuracy, Forecast Bias, Statistical Forecast, Consensus Forecast, Actual Demand, and Revenue Impact.
- Developed advanced DAX measures for rolling 12-month analytics, YTD calculations, forecast accuracy/bias, and dynamic time-intelligence reporting.
- Built slicer-driven forecast comparison logic to switch dynamically between Statistical Forecast and Consensus Forecast.
- Developed forecast heatmaps and KPI-driven dashboards across product, region, and channel dimensions to highlight planning trends and exceptions.
- Designed interactive Power BI reports using KPI cards, matrices, tables, charts, drill-downs, and slicers to support business decision-making.
- Partnered with business stakeholders to gather requirements, validate KPI definitions, document logic, and deliver reporting solutions.
- Optimized semantic models, DAX measures, SQL queries, and report layouts to improve performance and user experience.
- Implemented Row-Level Security and Azure AD/Entra group-based access in Power BI Service.
Sr. Power BI Developer - ProArch IT Solutions
(2025-12 - 2026-04)
Client: Clicket Valley
- Developed Power BI reporting solutions in Microsoft Fabric for high-frequency industrial IoT telemetry and operational analytics.
- Designed semantic models for minute-level streaming data and optimized the model/report experience for responsive visual performance.
- Built analytical visuals combining real-time operational metrics with dynamic baseline curves to support operational monitoring.
- Applied advanced DAX, Power Query transformations, drill-throughs, bookmarks, buttons, hierarchies, and interactive navigation.
Sr. Power BI Developer - ProArch IT Solutions
(2024-11 - 2025-02)
Client: CDNY
- Designed a scalable multi-model Power BI enterprise reporting architecture across Executive, Enrolment, Finance, and SLT reporting domains.
- Built Power Query data integration logic combining multi-source SQL forecast data with enterprise fact data for rolling predictive analysis.
- Developed optimized DAX using DATESBETWEEN, EDATE, EOMONTH, and other time-intelligence patterns for variance and cumulative analysis.
- Resolved complex data-modelling scenarios involving many-to-many relationships, role-playing dimensions, and USERELATIONSHIP.
- Improved report performance by leveraging database-optimized SQL Server views and implementing dynamic Row-Level Security.
Power BI Developer - Tezo IT Solutions
(2021-08 - 2023-10)
Client: Itron Inc.
- Developed Power BI and Paginated Reports for business reporting, including invoice reporting and role-based data access using RLS.
- Built dimensional models by integrating fact and dimension data through SQL views and SSAS sources.
- Developed DAX calculations using filter, date/time, time-intelligence, logical, and text functions.
- Performed SQL and DAX query optimization and improved report usability through effective page layouts and interactive navigation.
- Created Power Query transformations including Merge, Append, Derived Column, Split, and Aggregate operations.
Azure Data Engineer & Power BI Developer - Tezo IT Solutions Grant Thornton
(2023-04 - 2024-02)
Client: Grant Thorton
- Developed and maintained Azure Data Factory pipelines for data integration between Azure and on-premises sources.
- Configured integration runtimes, linked services, datasets, control-flow/data-flow activities, incremental loads, and pipeline monitoring.
- Implemented audit tracking and archival processes to improve pipeline reliability and operational control.
Power BI Developer - Acmetek
(2018-11 - 2021-06)
- Developed analytical Power BI reports and transformed multi-source data using Power Query for optimized reporting datasets.
- Created Power BI data models and reporting structures aligned with business requirements and reporting workflows.
- Optimized long-running SQL queries using execution plans, SQL Server Profiler, and indexing techniques.
- Configured Power BI Enterprise and Personal Gateways and supported Power BI Service reporting operations.
