Kazim Meraj

Engaged as an independent BI and data engineering consultant on a confidential contract, delivering solutions across Azure Synapse Analytics, Azure Data Factory, Power BI, and Databricks. • Design and build ETL/ELT pipelines and semantic data models to support enterprise reporting • Develop Power BI dashboards and DAX-driven measures for stakeholder-facing analytics • Apply CI/CD practices via Azure DevOps for pipeline and report deployment Client name and industry withheld under NDA.

• Architected and deployed 20+ ETL/ELT pipelines using Azure Data Factory and Azure Synapse Analytics, reducing pipeline processing time by 40% and enabling near-real-time data availability for downstream Power BI reports across five business units • Designed and published an enterprise Power BI reporting suite of 15+ interactive dashboards with advanced DAX measures, time-intelligence calculations, and drill-through navigation, cutting stakeholder reporting latency by 30% and eliminating manual Excel-based reporting • Built and optimized a centralized star-schema data model in Power BI Desktop, consolidating data from SQL Server, Azure Data Lake, and third-party APIs into a single source of truth, improving report load times by 35% • Implemented row-level security (RLS) in Power BI Service for role-based data access across executive, regional, and operational user groups, enforcing enterprise data governance policies • Developed complex Power Query (M) transformations for data cleansing, reshaping, and merging across heterogeneous sources, reducing data preparation time by 50% for the analytics team • Designed and built Power Apps integrated with Azure services and SharePoint to automate business processes, delivering user-friendly interfaces that reduced manual data entry by 35% • Monitored and maintained Azure Synapse, Data Factory pipelines, Power Apps, and Power BI dashboards, proactively resolving incidents to sustain 99%+ system uptime • Collaborated with business stakeholders to translate KPI requirements into Power BI specifications, delivering self-service analytics that reduced ad-hoc BI team requests by 40%

•  Led a cross-functional team of 3–5 BI developers across the full SDLC, establishing Power BI development standards, DAX coding conventions, and a shared data model governance framework that reduced rework by 30% •  Designed and delivered advanced Power BI dashboards with DAX-driven KPIs, dynamic slicers, drill-down, drill-through, and conditional formatting, improving end-to-end reporting efficiency by 50% over legacy SSRS reports •  Migrated existing self-service and ad-hoc SSRS reports to Power BI, implementing custom calculated measures and columns in DAX to satisfy complex business rules •  Engineered SSIS packages and T-SQL stored procedures to ingest data from SQL Server, Excel, OLE DB, and flat-file sources into a unified Power BI semantic layer, enabling reliable scheduled refresh in Power BI Service • Developed Power Query (M) transformations and tabular pivot/unpivot T-SQL queries to support efficient analytical reporting across yearly, quarterly, monthly, and daily time horizons • Conducted knowledge-transfer sessions on Power BI Service administration, workspace management, and scheduled refresh, ensuring long-term client self-sufficiency post-engagement

• Designed and developed a full data warehouse architecture (dimensional modeling, star schema, ETL) on the Apache stack, supporting KPI scorecards and executive dashboards in Apache Superset •  Administered a distributed DWH environment using Kafka, Apache NiFi, Druid, PrestoDB, and PostgreSQL, processing high-velocity event streams for real-time analytics •  Implemented row-level security in Apache Superset, managing multi-tier application security models for role-based dashboard access across business units •  Delivered end-to-end BI solutions including data ingestion, transformation, visual report development, and KPI scorecard design using Apache Products, Hive, and Hadoop

• Designed and developed data warehouses, focusing on dimensional modeling and ETL processes. • Created and optimized SSIS packages and OLAP cubes for enhanced data analysis. • Developed business intelligence reports using Microsoft Power BI and Tableau, improving data visualization. • Worked with Microsoft Azure SQL Database and Data Lake Store to streamline data integration processes.

- Design and Development of Data warehousing - Design and Develop ETL jobs - Handling of data over 100 million rows. - Designing the dimension models using the star schemas. - Schema Optimization and Data warehousing Optimization. - Checking the data correction and consistency while loading the data into data warehouse - Migrating the data from data marts & log files from S3 server to centralized data warehouse - Finding and fixing the bugs (Redundant Data). - Write complex SQL queries using condition statements for the generation of user reports. - Designing and creating the aggregate tables for some huge data sets.

- Develop & Administration of Database - Responsible for the physical as well as logical design of physical configuration on the storage media. - Performance Tuning (Both OS and Databases) - Backups (Migration, Full Backups and Backup through binary logs) - Replication(Master & Slave) - Analyzed data access controls and provided suggestions in enhancing the security - Evaluated, examined and implemented user roles and assigned relative database access privileges