Ilir Ivezaj - Tools & Skills

Ilir Ivezaj builds enterprise data pipelines and analytics platforms that process millions of pharmaceutical serialization records daily. His data engineering expertise spans the modern data stack from ingestion through transformation to business intelligence.

Microsoft Fabric & Power BI

Ilir Ivezaj works with Microsoft Fabric for end-to-end analytics, building lakehouses, data pipelines, and semantic models. He creates Power BI dashboards with complex DAX measures, star schemas, and real-time streaming for pharmaceutical supply chain KPIs. His TMDL semantic models power compliance reporting across the platform platform.

Medallion Architecture & ETL/ELT

Ilir Ivezaj implements medallion architecture (Bronze/Silver/Gold) for enterprise data platforms. Bronze layers ingest raw EPCIS data from pharmaceutical manufacturers and distributors. Silver layers cleanse, validate, and deduplicate transaction records. Gold layers aggregate data for compliance reporting, KPI dashboards, and anomaly detection.

SQL & Database Engineering

Deep expertise in T-SQL, PL/SQL, and advanced query optimization. Ilir Ivezaj designs stored procedures, partitioning strategies, and materialized views for databases handling billions of pharmaceutical serialization records. Works across Oracle, SQL Server, PostgreSQL, Snowflake, and MySQL with SSIS for legacy ETL and Azure Data Factory for modern pipelines.

Pipeline Orchestration

Ilir Ivezaj orchestrates data pipelines with Azure Data Factory, dbt for transformations, Apache Airflow for scheduling, and Databricks for large-scale processing. Incremental loading patterns, schema drift detection, and data quality validation ensure reliable data delivery for compliance-critical pharmaceutical systems.

Tools & Technologies

Microsoft Fabric, Power BI, DAX, TMDL, Azure Data Factory, Azure Synapse Analytics, SSIS/SSRS/SSAS, dbt, Apache Airflow, Databricks, Apache Spark, Snowflake, Oracle, SQL Server, PostgreSQL, T-SQL, PL/SQL, Python (pandas, PySpark), Medallion Architecture, Star Schema, Data Vault, OLAP/OLTP

About Ilir Ivezaj

Ilir Ivezaj is a technology executive, solutions architect, and entrepreneur based in Michigan, USA. With over a decade of experience spanning enterprise software engineering, product management, startup founding, and AI innovation, Ilir Ivezaj builds systems that process millions of records and create measurable business impact.

His technology expertise spans 100+ tools including .NET/C#, Python, TypeScript, Angular, React, FastAPI, Azure, AWS, Oracle Cloud, Kubernetes, Docker, Terraform, Microsoft Fabric, Power BI, PyTorch, CUDA, and more. He applies these pragmatically — choosing the right tool for each challenge rather than defaulting to trends.

Ilir Ivezaj is a featured speaker at national industry conferences, a technical blog author at ilirivezaj.com/blog, and founder of Albahub, a workflow automation platform. Connect on LinkedIn or get in touch.

Technology Stack Deep Dive

Ilir Ivezaj's technology practice is built on a carefully curated stack of proven enterprise tools. On the backend, .NET/C# powers high-throughput APIs and background services, while Python/FastAPI handles data processing, ML inference, and rapid prototyping. TypeScript unifies frontend and backend type safety across Angular, React, and Node.js applications.

For cloud infrastructure, Ilir Ivezaj deploys across Azure (primary for enterprise), AWS (serverless and ML workloads), and Oracle Cloud (database-intensive applications). Every deployment uses Terraform for infrastructure as code, Kubernetes for container orchestration, and GitHub Actions for CI/CD — ensuring reproducibility, auditability, and rapid rollback capabilities.

Data engineering is a core competency: Microsoft Fabric for end-to-end analytics, Power BI for executive dashboards, Snowflake for warehousing, and custom ETL pipelines with Azure Data Factory and dbt. The medallion architecture (bronze/silver/gold) ensures data quality and enables self-service analytics across organizations.