M. Rehan Maqbool
Abbottabad
Summary
Dynamic data analytics manager with proven expertise at PHC Global, specializing in data visualization and integration. Expert in Power BI and Python, I have successfully developed over 40 dashboards and streamlined data workflows, enhancing decision-making and project performance. Strong leadership and analytical skills drive impactful results in humanitarian programming.
Overview
14
14
years of professional experience
Work History
Manager Data Analytics
PHC Global
Islamabad
11.2021 - 11.2024
- Designed and implemented sophisticated data collection tools using Kobotoolbox, SurveyMonkey, and Survey CTO for health interventions and research studies
- Led the development of more than 40 Power BI dashboards, enabling real-time visualization and analysis of project performance data
- Conducted extensive data cleaning and integration, ensuring seamless migration of historical and live datasets for organizational use
- Produced comprehensive data insights reports for donors and senior management, incorporating tables, charts, and geospatial maps to enhance decision-making
- Oversaw task allocation within project teams, ensuring timely and accurate execution of data-related activities
- Tools Used: Python (Pandas, NumPy), Stata, Excel, SharePoint
- Tools Used: Power BI, Excel, Adobe Illustrator
- Key Projects: ACS-IR (District Haripur): Developed 03 MS Power BI Dashboards; utilized Python for data analysis
- Bhook Mitao Project (Sind): Designed data collection tools using KoboToolBox
- Covax-Round I, II & III: Created 04 MS Power BI Dashboards; automated questionnaire digitization via KoboToolBox
- Dareecha - Mental Health and Suicide Risk: Implemented KoboToolBox for data capture
- Emergency Health Relief Mental Health (Sindh & Balochistan): Integrated KoboToolBox with Python for advanced analytics
- MMS: Streamlined data workflows using KoboToolBox and Python
- NCDSS: Deployed MS Power BI dashboards alongside KoboToolBox
- Pak-Sehat: Combined KoboToolBox, MS Power BI, and Python for end-to-end data solutions
- NNS: Conducted statistical analysis using Python
- CDS: Developed dashboards (Power BI) and data tools (KoboToolBox, Python)
- Transforming EPI Vaccination Services: Digitized workflows via Survey Sparrow and Power BI dashboards
- LHW Impact Evaluation: Designed data collection frameworks with KoboToolBox
- 09 Additional Projects: Leveraged Survey Monkey, Python, and Power BI for analytics and reporting
Validation & Reporting Officer
RIZ Consulting
Islamabad
07.2019 - 10.2021
- Supervised field monitoring of vaccination activities in underserved tribal areas, ensuring compliance with Lot Quality Assurance Sampling (LQAS) protocols
- Validated and analyzed field data to assess program effectiveness, informing donor strategy and operational adjustments
- Regularly prepared detailed monitoring reports for stakeholders, highlighting progress, challenges, and opportunities for improvement
- Tools Used: Stata, SPSS, Excel
- Tools Used: Excel, Power BI, Stata, SPSS
Field Researcher
Coffey International
Peshawar/Charsadda/Mardan/Nowshera/Swabi
04.2015 - 08.2016
- Conducted qualitative and quantitative field surveys, including focus group discussions and in-depth interviews, to gather critical insights for governance and security programs
- Developed KMZ maps for survey areas, enhancing field team efficiency and planning
- Supported data analysis and reporting by developing tools, cleaning datasets, and generating actionable recommendations
- Tools Used: SPSS, Excel, Kobo Toolkit
- Tools Used: Stata, Excel
Senior Officer – Information Counselor & Reporting Officer
Norwegian Refugee Council (NRC)
Kurram Agency
07.2011 - 09.2014
- Designed databases and conducted statistical analysis using SPSS to support program evaluation
- Monitored the return of FATA beneficiaries, conducting surveys and providing detailed progress reports
- Created training materials, translated program content into local languages, and ensured dissemination to community stakeholders
- Tools Used: SPSS, Excel
- Tools Used: Excel
Monitoring & Evaluation Officer
Cordaid International
Kohat/Kurram/Orakzai
08.2010 - 06.2011
- Assisted in the development and adoption of M&E tools across project teams, ensuring consistent application of best practices
- Monitored program implementation, conducted evaluations, and documented lessons learned to inform future projects
- Prepared detailed progress reports for donors and internal stakeholders
- Tools Used: Excel
- Tools Used: Excel, Word
Education
Master’s Degree - Political Science
Gomal University
01.2010
Master’s Degree - Information Technology
Gomal University
01.2006
Skills
- Data Management
- System Development
- Data Analysis
- Data Visualization
- Python
- Pandas
- NumPy
- Matplotlib
- Seaborn
- Power BI
- Stata
- SPSS
- MS Excel
- Humanitarian Programming
- Data Migration
- Data Integration
- Kobo Toolkit
- SmartSheets
- SharePoint
- Monitoring
- Evaluation
- Learning
- Reporting
- Documentation
- Data Analytics
- Data Systems
- SQL
- Visualization
- Adobe Illustrator
- MS Office Suite
- M&E Systems
Accomplishments
- Successfully developed and deployed a centralized database for tracking the performance of donor-funded resilience programs.
- Migrated over 10 years of historical data into an interactive, user-friendly system for AA and other organizations.
- Designed and implemented MEL systems that improved accountability and demonstrated impact in humanitarian programs.
- Created dynamic dashboards that increased stakeholder engagement and informed high-level decision-making.
Certifications Trainings
- Machine Learning and Python Programming (Coursera)
- Advanced Data Analytics and Visualization (Online)
- Project Management Essentials
- Sustainable Development & Project Cycle Management
- Epidemiology and Biostatistics
Technical Expertise
Python (Pandas, NumPy, Matplotlib, Seaborn), Power BI, Stata, SPSS, Microsoft Excel, Kobo Toolkit, Survey CTO, SmartSheets, SharePoint, SQL, Power BI Dashboards, Adobe Illustrator, MS Office Suite, Development and implementation of frameworks for Monitoring, Evaluation, and Learning.
Timeline
Manager Data Analytics
PHC Global
11.2021 - 11.2024
Validation & Reporting Officer
RIZ Consulting
07.2019 - 10.2021
Field Researcher
Coffey International
04.2015 - 08.2016
Senior Officer – Information Counselor & Reporting Officer
Norwegian Refugee Council (NRC)
07.2011 - 09.2014
Monitoring & Evaluation Officer
Cordaid International
08.2010 - 06.2011
Master’s Degree - Political Science
Gomal University
Master’s Degree - Information Technology
Gomal University
Similar Profiles
Shah HaroonShah Haroon
IT Project Manager at PHC GlobalIT Project Manager at PHC Global
Jessyka LopezJessyka Lopez
HR Attendant Coordinator at Pride PHC ServicesHR Attendant Coordinator at Pride PHC Services
Amiya NayakAmiya Nayak
Pharmacist at Tihidi CHC Under Tiadisahi PHC HospitalPharmacist at Tihidi CHC Under Tiadisahi PHC Hospital
Sardar Waqas Riaz Logistic CoordinatorSardar Waqas Riaz Logistic Coordinator
Senior Logistics Coordinator at Italian Mall Supply BranchSenior Logistics Coordinator at Italian Mall Supply Branch
Zubair KhanZubair Khan
Restaurant Waiter at Islamabad Serena HotelRestaurant Waiter at Islamabad Serena Hotel