About Me

Hafizullah Mahmudi, the Data Solutions Specialist

Hi, welcome to my portfolio website! I'm Hafizullah Mahmudi, and I’m passionate about turning data into actionable insights and building innovative data solutions as well as software solutions. Over the past 16 years, I’ve had the privilege of designing, developing, and optimizing data-driven systems that empower businesses to thrive. From creating advanced tools for data collection, integration, and visualization to driving quality improvements across diverse domains, my journey has been all about solving problems through technology.

My expertise spans a wide array of technologies, including Power BI, ASP.NET Core, MVC, C#, VBA, Python, DAX, SQL Server, PostgreSQL, and data warehousing tools like SSIS and SSAS. I take pride in crafting solutions that not only work seamlessly but also deliver meaningful outcomes for teams and organizations.

Feel free to check out my portfolio to explore some of my favorite projects and accomplishments. If you’re looking to collaborate or just want to connect, I’m always a message away—whether here, on LinkedIn, or GitHub. Let’s turn your data challenges into opportunities!

My Toolkit

Power BI	PostgreSQL	Microsoft Fabric	Python
Tableau	SQL Server		C#
	Microsoft Access
Microsoft Excel	API

Key Strengths

Data Analytics & Business Intelligence

Data Transformation: Expertise in cleaning and transforming raw data for analysis.
Data Wrangling: Preparing complex datasets for analysis.
Data Mapping: Aligning data elements from different sources to a target schema.
Exploratory Queries: Writing SQL queries to extract meaningful patterns and insights.
Custom Dashboards: Designing visually engaging and dynamic dashboards in Power BI.
SQL Subqueries: Proficient in optimizing queries with subqueries for performance.
Dynamic Data Refresh: Implementing dynamic refresh logic in Power BI.
Storytelling with Data: Communicating insights through visualizations and presentations.
PivotTables & VLOOKUP: Advanced Excel techniques for reporting and data analysis.
SVG Custom Charts: Designing specialized visualizations, including conditional coloring and stacked bar charts.
Descriptive Analysis: Summarizing data insights using statistical measures.
Visualization: Crafting advanced interactive dashboards, using DAX for complex measures, and embedding reports.

Database, Data Modeling & Presentation

Relational Databases: Skilled in designing and managing relational database schemas.
SQL Server & PostgreSQL: Writing optimized SQL queries, stored procedures, and using advanced features.
Data Warehousing: ETL processes, dimensional modeling, and SSIS integration.
Data Presentation: Presenting insights to stakeholders with clarity and impact.

Software Development

C# and ASP.NET Core Framework: Experience with .NET 9, MVC Razor, and building APIs.
Frontend Development: JavaScript, TypeScript, HTML, CSS, and Bootstrap.
Version Control: Git and GitHub for code management.
VBA Development: Automating tasks using Excel and Access.

Resume
(download)

Professional Experience

BI Consultant, OHI (Remote)

07/2024 – 11/2024

Designed and implemented a data warehouse, optimized ETL processes, and developed Power BI dashboards to enhance decision-making.
PostgreSQL, Power BI, C#, Dapper, SQL, Power Query, Dataflows, DAX

BI and Data Consultant, UNICEF (Remote)

09/2022 – 11/2023

Led development of a data warehouse, optimized ETL workflows, and built 30+ Power BI dashboards.
SSIS, Power BI, Python, T-SQL, SQL Server, Power Query, DAX

Health Informatics Advisor, MSH

09/2020 – 10/2021

Strategized HIS database integration and implemented visual tools for tracking impact.
ETL, SSIS, Power BI, HMIS, EMIS

Nutrition Database Developer, MoPH-UNICEF

11/2018 – 12/2019

Led development of a full nutrition database and web app using ASP.NET MVC Core.
SQL Server, ASP.NET Core, EF Core, JS, jQuery

Power BI Developer, The Palladium

01/2020 – 08/2020

Developed dashboards and trained teams on data-driven tools.
Power BI, SQL Server, DAX, Excel, Power Query

HEMIS Developer, MoPH-WB

01/2016 – 10/2018

Built MIS systems and dashboards to monitor health expenditures.
SQL Server, ASP.NET MVC, JS, EF, T-SQL

Pharmaceutical IS Manager, MSH

06/2012 – 12/2015

Developed pharmaceutical supply systems and trained pharmacy staff.
MS Access, SQL Server, VBA, .NET, Excel

Senior MIS Specialist, MSH

04/2008 – 05/2012

Created national databases and improved HMIS data flows.
Access, SQL Server, ADO.NET, HTML, CSS

MIS Specialist, MSH

04/2004 – 03/2008

Managed health databases, trained teams, and built GIS reports.
Access, SQL Server, VBA, Excel

Education

Master of Science in Data Science

Liverpool John Moores University (UK) + IIITB (India) (09/2019 – 08/2021)

Bachelor of Science in Computer Science

Kateb University (Afghanistan) (04/2011 – 12/2014)

Diploma in Business Administration

Kardan Institute (Afghanistan) (05/2005 – 06/2006)

Certifications

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
SQL
Python

CapitalBikeShare

GDPAnalysis

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.

HIID

A Power BI dashboard to analyze healthcare investment opportunities across five provinces, enabling stakeholders to filter data by facility type, specialization, resources, and services.

HCDEval

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.

NutriETL

NISDatabse

SCAD

TracerIndicators

PRIS

EMISDatabase

EMLLML

PPOR database

Nutrition Web App

EMIS Database

Strategic Aid Allocation

ESales

p4p

Testimonials

Necessitatibus eius consequatur ex aliquid fuga eum quidem sint consectetur velit

Proin iaculis purus consequat sem cure digni ssim donec porttitora entum suscipit rhoncus. Accusantium quam, ultricies eget id, aliquam eget nibh et. Maecen aliquam, risus at semper.

Saul Goodman

Ceo & Founder

Export tempor illum tamen malis malis eram quae irure esse labore quem cillum quid malis quorum velit fore eram velit sunt aliqua noster fugiat irure amet legam anim culpa.

Sara Wilsson

Designer

Enim nisi quem export duis labore cillum quae magna enim sint quorum nulla quem veniam duis minim tempor labore quem eram duis noster aute amet eram fore quis sint minim.

Jena Karlis

Store Owner

Fugiat enim eram quae cillum dolore dolor amet nulla culpa multos export minim fugiat dolor enim duis veniam ipsum anim magna sunt elit fore quem dolore labore illum veniam.

Matt Brandon

Freelancer

Quis quorum aliqua sint quem legam fore sunt eram irure aliqua veniam tempor noster veniam sunt culpa nulla illum cillum fugiat legam esse veniam culpa fore nisi cillum quid.