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 15 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 |
 Fabric (Data Factory) |
 .Net Framework |
 Tableau |
 SQL Server |
 Fabric (Warehouse/Lakehouse) |
 |
 |
 Microsoft Access |
 Fabric (DAX and PowerBI Integration) |
 C# |
 DAX Studio, Tabular Editor |
 |
Fabric (Direct Lake Mode) |
 |
|
|
 API |
Fabric (Dataflows Gen2, Pipelines, Notebook) |
 Github, Git |
 Python (seaborn, pandas, machine learning, modeling) |
|||
 Anaconda  Visual Studio Code  Visual Studio  Office  |
|||
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 8, 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.
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 data availability and decision-making.
PostgreSQL, Power BI, C#, Entity Framework, Dapper, T-SQL, Power Query, Dataflows, DAX
BI and Data Consultant, UNICEF(Remote)
09/2022 – 11/2023
- Led the development of a data warehouse integrating multiple data sources, optimized ETL workflows to reduce load times by 60%, and created 30+ Power BI dashboards for real-time analytics.
- SSIS, Power BI, Python, T-SQL, Microsoft SQL Server, Power Query, Dataflows, DAX
Health Informatics Advisor, MSH
09/2020 – 10/2021
- Provided strategic guidance on HIS databases, supported leadership in data-driven planning, and implemented integration and visualization tools to enhance project tracking and impact assessment.
- Data Warehousing, ETL, SSIS, Power BI, HMIS
Power BI Developer, The Palladium
01/2020 – 08/2020
- Developed interactive Power BI reports, improved data modeling and extraction, and trained technical teams to utilize dashboards for investment planning.
- Power BI, SQL Server, DAX, Power Query, Excel, ETL
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)
Nutrition Systems Developer, MoPH-EU/WB
01/2016 - 10/2018
- Managed the development of a Health Expenditure MIS, optimized ETL processes, and built interactive dashboards to track healthcare expenditure trends.
- SQL Server, ASP.NET MVC Core, Entity Framework Core, JavaScript, jQuery, MS Access
HEMIS Developer, UNICEF
11/2018 - 12/2019
- Led the full project lifecycle of a nutrition management system, developed a SQL Server database, and built a full-featured web application using ASP.NET MVC Core.
- SQL Server, ASP.NET MVC Core, Entity Framework Core, JavaScript, jQuery, MS Access
Pharmaceutical IS Advisor, MSH
06/2012 - 12/2015
- Led a team to develop pharmaceutical regulatory and supply chain databases, integrated WHO standards, and streamlined inventory management for pharmacy outlets.
- Microsoft Access, SQL Server, VBA, ASP.NET, C#, Excel
Database Developer, MSH
04/2008 - 05/2012
- Designed and implemented 12+ national database applications, upgraded HMIS modeling for 2,000+ data flows, and developed a centralized data warehouse for efficient reporting.
- Microsoft Access, SQL Server, ADO.NET, ASP.NET, JavaScript, jQuery, HTML, CSS
Certifications
Fabric Certified
Microsoft Certified: Fabric Analytics Engineer Associate (2024)
Power BI Certified
Microsoft Certified Professional
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
- Dashboard
- Warehouse
- Database
- SQL
- Python
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.
