Lokesh D.

Microsoft Fabric & Power BI Architect and Developer with 16+ years building data warehouses, lakehouses, ETL pipelines, DAX data models and Power BI dashboards that leaders trust for decisions. I've delivered enterprise BI and Azure data engineering for Pfizer, EY, PwC, Applied Materials and Daiya Foods. Microsoft Certified: Fabric Analytics Engineer (DP-600) and Fabric Data Engineer (DP-700). SERVICES • Microsoft Fabric: lakehouse and data warehouse architecture, OneLake, medallion (Bronze, Silver, Gold), Data Factory pipelines, Dataflows Gen2, Spark notebooks (PySpark), Direct Lake • Power BI development: dashboards and reports, DAX, Power Query (M), data modeling (star schema), semantic models, Row-Level Security (RLS), paginated reports, Power BI Service, deployment pipelines • Power BI performance optimization: slow reports fixed through DAX and data model redesign and refresh tuning • Finance and FP&A reporting: Budget vs Actuals, forecasting, What-If analysis, KPI scorecards • Azure data engineering and ETL/ELT: Azure Data Factory, Azure Synapse Analytics, Azure Databricks, Azure SQL, Azure Data Lake (ADLS Gen2), SQL Server, T-SQL, SSIS • BI migrations: SAP BusinessObjects (WebI, Universe), Tableau, SSRS, SSAS and Excel reporting to Power BI and Microsoft Fabric • Power BI Embedded and AI: customer-facing analytics, Copilot and Fabric Data Agents on governed data • Data integration from SAP ECC, Salesforce, Dynamics 365, SQL Server, MySQL, MariaDB, Snowflake and Excel RESULTS • Pharma supply chain: SAP ECC data unified in Microsoft Fabric, giving global executives supplier, procurement and inventory KPIs that helped reduce stockouts • Daiya Foods: ERP, CRM and e-commerce data in one Azure data warehouse, improving reporting accuracy across sales, production and finance • EY Assurance: data warehouse and embedded Power BI giving audit teams client and engagement information in one place • Healthcare: data platform behind e-procurement, inventory and cost analysis for 400+ US hospitals WHY CLIENTS HIRE ME • One version of the truth: governed KPIs replace conflicting reports and spreadsheets • Earlier decisions on sales, inventory, supplier and financial performance, not at month-end • Lower cost: legacy BI and on-prem ETL consolidated onto one cloud platform • Secure access at scale: every region and role sees exactly its own data HOW I WORK I start from the decision the business needs to make, not the dataset. I own delivery end to end through UAT and adoption, with regular progress updates at agreed checkpoints. INDUSTRIES Pharma and life sciences, healthcare, FMCG and retail, manufacturing and semiconductors, professional services. Solution accelerators for banking, oil and gas, airlines and supply chain planning. TOOLS Microsoft Fabric · Power BI · DAX · Power Query · Azure Data Factory · Azure Synapse · Azure Databricks · PySpark · Python · Azure SQL · SQL Server · T-SQL · SSIS · SSAS · SSRS · Azure Analysis Services · Snowflake · dbt · BigQuery · Tableau · SAP BusinessObjects · Power Apps · Power Automate Need a Power BI developer, Microsoft Fabric architect or data warehouse expert? Send me your current setup and goals.