i
irfan_ahmedpas

Irfan Ahmed

@irfan_ahmedpas

Excel VBA Automation, Power BI Dashboards, Google Sheets, Data Cleaning

Pakistan
Engels, Urdu, Pasjtoe
Sommige informatie wordt in het Engels weergegeven.
Over mij
I build Excel and Google Sheets automation, Power BI dashboards, and clean, reliable datasets for teams tired of manual reporting. 7 years in data and information management for humanitarian and development programs, including UNICEF-supported work across 200+ facilities and 7 districts. Tools: Excel VBA, Power Query, Power Pivot, Power BI, Google Apps Script, Python. You get clean, commented code or a documented file, plus a short walkthrough so your team can run it without me. Send your file and a short brief, and I'll reply with a clear scope and quote.... Lees meer

Skills

i
irfan_ahmedpas
Irfan Ahmed
offline • 

Bekijk mijn diensten

Programmering en technologie
I will build vba macros and power query automation for your excel reports
VanafUS$ 10 / projectMeer informatie
Automatiseringen
I will do google sheets custom automation
VanafUS$ 20 / projectMeer informatie

Portfolio

Werkervaring

UNICEF

UNICEF

3 yrs 6 mos

Information Management Officer

Dec 2024 - Present • 1 yr 9 mos

Information management for UNICEF's Integrated Service Delivery (ISD) programme covering Health, Nutrition, WASH, SBC and Polio. - Compile, clean and validate programme data from reports, surveys, campaigns and health facilities so it is accurate and ready for decision-making - Develop and maintain ISD indicator databases and dashboards (MITS), and support dashboard scale-up across Sindh, Balochistan and South KP - Build Excel VBA and Power Query tools that automate nutrition data import and conversion for the MITS portal - Set up and update baseline and end-line datasets for all ISD components to keep monitoring consistent - Map health facilities, outreach teams and programme assets to identify service coverage gaps and resource-use trends

Data Analyst

Jun 2023 - Dec 2024 • 1 yr 6 mos

Compiled and maintained accurate Section data on the 5W matrix for Health, Nutrition, and WASH sectors, ensuring timely reporting to support evidence- based decision-making. Produced comprehensive weekly and monthly progress reports, highlighting key achievements and challenges for donor reporting and program planning. Coordinated with partners to ensure seamless data uploads into the Management Information Tracking System (MITS), enhancing data accuracy and accessibility for Health, Nutrition, and WASH programs. Regularly updated the Emergency Response Planning Tracking System (ERPTS), contributing to Sitrep and situation analysis for donors and country- level stakeholders.

Monitor & Quality Assurance Officer

Jan 2023 - Apr 2023 • 3 mos

Responsible for leading the development and implementation of a plan to monitor progress, evaluate effectiveness, ensure the quality of birth registration data, and disseminate results of the project activities. Conduct Data Quality Assessment visits to Health facilities sites and Union Councils with relevant Supervisors and birth registration facilitators. To compile weekly, monthly and quarterly data and share trends with the Local government and UNICEF for information and decision-making. To provide technical support to the UC secretaries and birth registration facilitators in the use of the mobile application and train them to use the application effectively for daily reporting.