End-to-end BI & Data Engineering across Azure and Microsoft Fabric — 7+ years building scalable ETL pipelines, data platforms, and Power BI dashboards that turn raw enterprise data into decision-ready insights.
End-to-end ETL pipelines using Azure Data Factory, Microsoft Fabric, SSIS, and PySpark. Built scalable ingestion frameworks with incremental loads, control tables, Delta tables, and automated scheduling across ERP, CRM, APIs, and databases.
Automated data extraction from REST APIs using Python, PowerShell, and Postman. JSON transformation into structured warehouse layers and real-time ingestion pipelines.
Scalable Star & Snowflake schema design across Fabric, Synapse, SQL Server, and Snowflake with SCD handling and performance-optimized data models.
End-to-end data security across database and semantic layers — implementing Row-Level Security (RLS) at SQL/database level and DAX-based RLS/RBS in Power BI semantic models. Includes workspace access control, gateway configuration, audit logs, and secure enterprise reporting.
Optimized queries, indexes, stored procedures, and large reporting views for high-performance analytics workloads.
On-prem to Azure migration with full data mapping, validation, and BI continuity across ERP, CRM, and legacy systems.
Tabular models and enterprise datasets with optimized relationships and live Power BI connectivity.
Interactive executive-grade dashboards with advanced DAX, paginated reports, bookmarks, hierarchies, and automated email subscriptions for Finance, HR, Operations, and KPI scorecards.
Automated reporting, alerts, and workflow triggers for business events and KPI monitoring.
Configure and maintain IIS to embed Power BI dashboards into enterprise web portals with secure access, seamless report integration, and enhanced user interactivity.
Integrated D365 ERP, CAFM, Joget, Oracle Unifier, and SharePoint into Fabric OneLake Warehouse. Delivered Finance, Procurement, and HR dashboards tracking revenue, collections, intercompany fund flows, payroll, attrition, and investment performance. Configured IIS for Power BI enterprise web portal embedding. Automated weekly investment and PO notifications via Power Automate.
Transformed data from Salesforce, Genesys, and Monday Board into Fabric OneLake Warehouse. Developed KPI dashboards tracking Utilization, SLA Compliance, Quality Evaluations, and CSAT Scores. Automated dynamic KPI scorecard emails via Fabric Flows and implemented Paginated Reports with daily Excel auto-distribution to team leaders. Maintained Power BI Data Dictionary via Python and APIs.
Led end-to-end BI for Digital Operations, Internal Auditing, CRM, ERP, and HR teams. Managed CRM on-prem to cloud migration, Pentana → K10 Vision, and HPSM → ServiceNow transitions. Extracted API data via PowerShell & Python into warehouse via SSIS. Implemented Paginated Reports and full Power BI admin — audit logs, gateways, and workspace access.
Extracted and integrated jobseeker, vacancy, and company data from TakAfo systems via web scraping and APIs. Automated Python scripts for JSON extraction and SSIS pipeline orchestration. Built SQL stored procedures for JSON-to-table transformation and reporting views for Power BI and external applications.
Designed operational dashboards tracking Total Insurance Coverage, Revenue, User Renewals, and Revenue Forecasts on Snowflake. Created wireframes, implemented advanced DAX (Time Intelligence, Aggregation, Filter), and managed the full Power BI delivery lifecycle from data modelling to production migration.
Created and maintained Power BI dashboards for Operations, Sales, Warehousing, and HR. Ensured SSIS integrations and SSAS cube reliability. Live connection from Power BI Desktop to SSAS cubes. Built Card, Bar, Pie, Filled Map, Table, Matrix, and Line Chart visualizations for multi-department reporting.
Holding two active Microsoft certifications covering the full modern analytics and engineering stack — from Power BI reporting to Fabric data pipelines.
Whether it's a Power BI dashboard, an end-to-end Fabric pipeline, a cloud migration, or IIS web portal embedding — I deliver complete, enterprise-grade BI solutions tailored to your business.
Click the WhatsApp button below to start a conversation right now!
💬 Discuss on WhatsApp