Enterprise Power BI · i-3PL Analytics
Designed and delivered operational dashboards, interactive KPI reports, and reusable semantic models for logistics stakeholders. Developed advanced DAX measures, Power Query transformations, dynamic slicers, bookmarks, parameters, buttons, and drill-through experiences; optimized SQL queries, views, functions, data models, and report performance across enterprise data sources.
Custom Default View & Secure Reporting
Conceptualized and developed a reusable Default View feature that personalizes a report's initial KPIs and visuals through username-aware DAX measures. Unlike Row-Level Security (RLS), Default View does not restrict the underlying dataset: users initially see their assigned facility but can select other facilities from the slicer to analyze shared business data. Also implemented RLS where access restrictions were required, and built cross-report navigation that preserves filter context across reports.
BI Modernization · SSRS to Power BI & Microsoft Fabric
Led migration strategy and source mapping for 100+ SSRS reports and the transition from on-premises Power BI Report Server to Power BI Service. Designed Microsoft Fabric solutions with OneLake, Lakehouse, Warehouse, Data Factory pipelines, Bronze/Silver/Gold layers, and star/snowflake semantic models; supported reconciliation, incremental refresh, gateways, workspace access, deployment, and performance tuning.
AR / DSO Analytics & Delivery Leadership
Supported receivables and days-sales-outstanding analytics by designing automated SharePoint/Excel → Power Automate → AWS SFTP → Amazon Redshift data flows. Coordinated requirements, sprint planning, Jira delivery, stakeholder demonstrations, and technical guidance across BI and engineering teams.