About Me
Hafizullah Mahmudi, the Data Solutions Specialist
Hi, welcome to my portfolio website. I’m Hafizullah Mahmudi, a Business Intelligence, data, and software development professional with more than 15 years of experience designing data platforms, reporting systems, analytical solutions, and business applications.
My work focuses on transforming complex and disconnected data into reliable, governed, and actionable information. I have designed SQL reporting databases, star-schema data warehouses, ETL workflows, semantic models, Power BI dashboards, data-quality processes, and web-based information systems for healthcare, nonprofit, public-sector, private-sector, and operational environments.
My technical experience includes Power BI, DAX, Power Query, Microsoft Fabric, SQL Server, PostgreSQL, SSIS, ASP.NET Core MVC, C#, Entity Framework Core, Python, JavaScript, Microsoft Access, VBA, Azure fundamentals, Snowflake SQL, and GitHub. I also use AI-assisted analytics and agentic AI to improve data exploration, automate reporting workflows, generate insights, and make complex information easier for users to access.
One of my recent projects involved developing an agentic AI assistant that translates natural-language questions into safe, parameterized data queries and presents the results through tables, charts, KPI cards, crosstabs, maps, and analytical summaries. I am especially interested in combining business intelligence, data engineering, software development, and AI to create practical solutions that improve decision-making and user productivity.
Explore my portfolio to see examples of my dashboards, databases, data platforms, reporting solutions, and software projects. You can also connect with me through LinkedIn or GitHub to discuss business intelligence, data engineering, software development, AI-enabled analytics, or potential collaboration opportunities.
My Toolkit
 Power BI |
 PostgreSQL |
 Microsoft Fabric |
 Python |
 Tableau |
 SQL Server |
 |
 C# |
 |
 Microsoft Access |
 |
 |
 Microsoft Excel |
 API Development |
 Agentic AI |
GitHub |
Key Strengths
Data Analytics, Business Intelligence & AI
-
Data Transformation: Cleaning, standardizing, validating, and transforming raw data into reliable datasets for reporting and analysis.
-
Data Integration & Mapping: Combining data from multiple systems and mapping source data elements to consistent reporting structures and target schemas.
-
SQL Analytics: Writing advanced SQL queries using joins, subqueries, common table expressions, window functions, aggregations, and performance-optimization techniques.
-
Power BI Dashboards: Designing professional, interactive dashboards, KPI scorecards, drill-through reports, maps, trend analyses, and executive reporting solutions.
-
DAX & Semantic Models: Developing reusable measures, calculated tables, time-intelligence calculations, relationships, hierarchies, and governed business metrics.
-
Power Query, Dataflows & Refresh: Building repeatable transformation processes, reusable dataflows, parameterized queries, and reliable refresh workflows.
-
Report Migration: Modernizing Excel, Access, Tableau-style, and legacy reports into governed Power BI dashboards and reusable reporting datasets.
-
AI-Assisted Data Analytics: Using AI to accelerate data exploration, SQL development, documentation, quality reviews, insight generation, and reporting workflows.
-
Agentic AI Solutions: Building AI assistants that translate natural-language questions into safe, parameterized data queries and return tables, charts, maps, KPI cards, and analytical summaries.
-
Data Visualization & Storytelling: Communicating trends, comparisons, risks, performance indicators, and actionable insights through clear visual narratives.
-
Advanced Excel Analysis: Using PivotTables, lookup functions, Power Query, formulas, charts, data validation, and VBA automation for business reporting.
-
Custom Visualizations: Creating specialized charts, SVG-based visuals, conditional formatting, infographics, embedded reports, and interactive analytical experiences.
-
Security & Governance: Implementing Row-Level Security, controlled access, reusable datasets, documentation, validation rules, and trusted reporting standards.
Database, Data Engineering & Data Modeling
-
Relational Database Design: Designing scalable relational database schemas, relationships, constraints, and data structures for operational and reporting systems.
-
SQL Server & PostgreSQL: Developing optimized SQL queries, views, stored procedures, functions, and reporting databases.
-
Data Warehousing: Building staging layers, ETL/ELT pipelines, fact and dimension tables, data marts, and star-schema data warehouses.
-
Dimensional & Semantic Modeling: Designing reusable data models, relationships, measures, hierarchies, and trusted KPI layers for analytics.
-
Data Quality & Validation: Implementing validation rules, exception reports, plausibility checks, reconciliation processes, and quality-control workflows.
-
Documentation & Data Presentation: Creating data dictionaries, mapping documents, QA checklists, technical documentation, and clear presentations for business stakeholders.
Software & AI-Enabled Application Development
-
C# & ASP.NET Core: Developing secure, maintainable web applications using ASP.NET Core MVC, Razor, Entity Framework Core, and modern .NET technologies.
-
Web & API Development: Building REST APIs, application services, data-entry workflows, validation processes, and system integrations.
-
Frontend Development: Creating responsive and user-friendly interfaces with JavaScript, HTML, CSS, Bootstrap, jQuery, and DataTables.
-
AI-Enabled Applications: Integrating agentic AI, natural-language querying, prompt management, and AI-assisted analytics into reporting and business applications.
-
Python & VBA Automation: Automating data preparation, reporting, validation, and repetitive business processes using Python, Excel VBA, and Access VBA.
-
Version Control: Using Git and GitHub for source-code management, collaboration, documentation, and controlled software delivery.
Resume
Professional Experience
Data Integration & BI Developer, 3V (Remote)
Aug 2025 – Mar 2026- Architected a SQL Server star-schema data warehouse, built custom ETL pipelines, and converted Access-based reporting processes into structures optimized for Power BI analytics.
- SQL Server, ETL, Data Warehousing, Power BI, DAX, Stored Procedures, Microsoft Access
BI/Data Developer, Part-Time Consultant, UNICEF (Remote)
Aug 2025 – Jun 2026- Enhanced a national nutrition information platform, expanded self-service analytics, improved Power BI dashboards, and developed an agentic AI assistant that converts natural-language questions into safe, parameterized reporting queries.
- ASP.NET Core MVC, C#, EF Core, SQL Server, Power BI, DAX, JavaScript, Agentic AI
Report Migration Consultant, OHI (Remote)
Dec 2023 – Dec 2024- Designed a PostgreSQL reporting warehouse and migrated manual Excel and legacy reports into reusable SQL views, Power Query transformations, DAX measures, and governed Power BI dashboards.
- PostgreSQL, Power BI, SQL, Power Query, DAX, ETL, Data Warehousing, Row-Level Security
Data Developer, UNICEF (Remote)
Mar 2022 – Oct 2023- Re-engineered a legacy application into a multi-user ASP.NET Core system, developed a SQL Server nutrition data warehouse, and migrated more than 30 reports into Power BI dashboards and governed datasets.
- ASP.NET Core, C#, SQL Server, Power BI, SSIS, DAX, Power Query, Dimensional Modeling
Data Systems & Digital Health Solutions Lead, MSH
Sep 2020 – Feb 2022- Led digital-health strategy and supervised a multidisciplinary technical team working across DHIS2, ETL, data quality, dashboards, software development, reporting, and user support.
- DHIS2, ETL, SSIS, Power BI, Data Quality, HMIS, Digital Health Strategy
Professional Experience
Power BI & Data Visualization Consultant, Palladium
Jan 2020 – Aug 2020- Built an interactive Power BI dashboard suite with more than 32 linked reports for analyzing over 14,000 private healthcare providers across multiple operational and service-delivery dimensions.
- Power BI, SQL Server, DAX, Power Query, Excel, Data Modeling, Data Validation
Health Expenditure Management System Developer / Data Analyst, MoPH–EU
Jan 2016 – Dec 2019- Led the design and modernization of health-expenditure, contract, grant, and inventory systems, including the migration of an Access desktop application to an ASP.NET MVC and SQL Server platform.
- SQL Server, ASP.NET MVC, C#, Entity Framework, T-SQL, JavaScript, Microsoft Access
Pharmaceutical Information Systems Developer, MSH–USAID Project
Jun 2012 – Dec 2015- Led the development and maintenance of pharmaceutical registration, medicine classification, pharmacy outlet, and logistics information systems supporting more than 3,000 health facilities and hospitals.
- Microsoft Access, SQL Server, VBA, .NET, Excel, Pharmaceutical Logistics Information Systems
Health Management Information System Developer, MSH–USAID Project
Apr 2008 – May 2012- Led the development and administration of 12 national and sub-national databases, data marts, synchronization processes, ETL workflows, indicators, and reporting tools used across government and partner programs.
- Microsoft Access, VBA, SQL Server, ETL, Data Warehousing, ADO.NET, HTML, CSS
Education
Master of Science in Data Science
Liverpool John Moores University, United Kingdom
Bachelor of Science in Computer Science
Kateb University, Afghanistan
Languages
- English: Professional working proficiency
- Dari/Persian: Native
- German: Intermediate
Certifications & Training
Microsoft Certified: Fabric Analytics Engineer Associate
Microsoft Certified: Power BI Data Analyst Associate
Microsoft Certified Professional
Additional Technical Training
Microsoft Azure Data, Tableau, SQL Server, Business Intelligence, Data Warehousing, Python, and Data Visualization
Projects
Below is a list of projects I've worked on, highlighting my expertise in data consulting, software development, and business intelligence. Each project reflects my commitment to building efficient, data-driven solutions that deliver real impact.
- All
- Health
- Financials
- Supply
- PowerBI
- Tableau
- Dashboard
- Warehouse
- Database
- Sport
- SQL
- Python
Diamond IQ
An end-to-end baseball analytics platform that turns raw game data into readable analysis. It covers team and player performance across batting, pitching and fielding, with matchup comparisons, trend analysis, a raw-data explorer, and an insight engine that converts statistics into plain-language findings.
The application runs on either a live data provider or a fully simulated season, and it always tells the user which one it is showing. It was built around a single principle: never display a number the data does not support.
Live demo: diamond-iq.pages.dev · Source: github.com/hafizmahmudi/diamond-iq
EMISD
A Business Intelligence (BI) solution to help the Ministry of Public Health (MoPH) and donors monitor and analyze expenditures in the health sector. This project leverages data from the Expenditure Management Information System (EMIS) to provide clear and insightful visualizations, enabling better financial planning and transparency.
NISDashboard
This is a robust Business Intelligence (BI) solution to enable UNICEF, the Ministry of Public Health (MoPH), implementers, and provincial health managers to monitor and analyze nutrition-related services across over 3,000 health facilities. This project leverages data from multiple sources to provide clear and insightful visualizations, facilitating informed decision-making and enhancing the effectiveness of health programs.
Latest Blog Posts
Insights, tutorials, and stories from my work and experience.
No blog posts available yet.