Yahaya's Portfolio

About Me

Data Analysis & MEL Specialist.

I am a sasoned MEL Specialist/Data analyst with a strong background in Mathematics, Statistics & ICT, I help Programs/Projects to build strong MEL systems, frameworks, and robust data collection tools for effective measurement of program indicators (KPIs), program monitoring, and learning. Having four years of experience while working with MasterCard-funded programs, I specialize in building tools that take data directly from the sources to upper-level management while performing necessary analysis in real-time, this ensures accountability, and transparency of data, and enables program management to make informed decisions to improve the project’s processes, activities, and policies.

Skills

Here are some skills I have exhibited
• Experienced in data mining, cleaning.
• Proficient using Microsoft Word, Excel, Access, PowerPoint, Outlook, and the internet.
• Managing & Developing Databases.
• Quantitative and qualitative research, report writing.

SQL Expert

Excel Expert

PowerBI Expert

GIS intermediate

HTML intermediate

CSS intermediate

Python intermediate

JAVAScript intermediate

Resume

Data analyst with four years of experience in data collection, cleaning, visualization, and interpretation. I am proficient in using tools such as Excel, Python, SQL, Excel, and PowerBI to deliver insights and solutions that drive business decisions. I have successfully completed several projects that involved data analysis.

Sumary

Yahaya Yusuf Danladi

Power BI Developer with 5 years of experience delivering data solutions that cut costs, improve decision-making, and automate reporting pipelines by up to 30%. Increased data availability and real-time analytics by 40% through dashboard implementation. I have a background in Mathematics, Statistics & ICT, and experience in data analytics and applying data-driven solutions to various business problems. Proficient in leveraging Power Query, DAX, and advanced analytics to transform complex data into actionable insights. Effective communication skills with a proven ability to collaborate effectively with stakeholders to understand business requirements and deliver data-driven solutions. Core-specific objectives include to:
▶ Design and deploy gender-sensitive and robust results monitoring system with strong feedback routes
▶ Track progress towards achievement of stated outputs and provide early warning signals of possible deviations
▶ Institutionalize data quality to ensure that data collected adheres to quality specifications of validity, integrity, timeliness, completeness, and precision.
▶ Carryout periodic results measurementsto benchmark and establish the status of project outcome indicators.
▶ Support data and knowledge management, including identification and application of lessons learned.
▶ Support the development of periodic reports to the donor.

Education

Master in Information Management

December 2024

Ahmadu Bello University, Zaria - Nigeria

Some of the course and topic I covered include:

Project Management

Database Management

Information Consulting

Information Policies

Information Service Personnel

Research Principles and Analysis

Preservation Management

Post Graduate Diploma In Digital Communications

March 2019

National Open University of Nigeria

Some of the course and topic I covered include:

Internet programming

Computer networks

Wireless communication, and

Digital modulation

Bachelor of Science In Mathematics

December 2012

Ahmadu Bello University Zaria, Kaduna State, Nigeria

The various core courses and topics that I have covered include:

Algebra

Differential Calculus & Vector Calculus

Integral Calculus & Trigonometry

Vector Analysis & Geometry

Probability

Permutation and Combinaiton

Advanced Calculus

Professsional/Upskilling Certification

Innovative Strategy, Data Analysis and Impact Assessment

Crown Agents (UK) – 2023

Data Analyst

Udacity – 2022

Certified CommCare Application Builder

Dimagi Academy – 2021

Designing and Implementing Monitoring and Evaluating Systems

Alison Academy – 2021

Jobberman Soft-Skills Certificate

Jobberman – 2020

Diploma in Databases and T-SQL

Alison Academy – 2020

Professional Experience

Data Analytics Consultant

November 2024 - March 2026

Propcom Plus, Abuja Nigeria.

Designed, developed, and implemented comprehensive Power BI dashboards and reports, enabling real-time data visualisation, reporting, and providing actionable insights, and supporting data-driven decision-making.
Developed interactive Power BI dashboards to communicate KPIs, monitor service performance, identify business trends, and support continual service improvement.
Collaborated with cross-functional teams to gather requirements, understand business processes, and identify key metrics.
Reduced dashboard load times by 40% through optimisation of the data model, improving the user experience and enabling faster access to operational performance reports
Design and refine relevant MEL documentation including Theory of Change, MEL frameworks, MEL Plans and Indicator Tracking tools.
Design and implement project-specific Monitoring Information Systems (MIS) for data collection analysis and visualization.
Lead the execution of field-level data collection activities in the project including farmer registration and profiling, GIS data collection, routine monitoring of farmers' performance, surveys, and assessments.
Lead the development of data collection methodologies, plans, tools, and budgets for every routine and periodic (surveys) data collection activity.
Quality assure all data collection activities in the project through the development of cutting edge questionnaires, rigorous training of data collectors, supervising the data collection process, and reviewing data input and quality.
Train and Provide supervisory support, mentorship and capacity building to State MEL officers, enumerators, and extension agents on the use of digital data collection technologies.
Update and maintain the project's central electronic database.
Perform monthly analysis of monitoring data generated from activities and provide feedback (using charts, tables, narratives, etc) to management indicating where project activities and interventions are falling short, meeting, or exceeding the expected outputs and outcomes.
Lead the development of periodic reports.
Ensure gender considerations are mainstreamed throughout all monitoring activities and processes.

Database Manager/PowerBI Developer Consultant

May 2024 - May 2025

Sanekonsult, Abuja Nigeria.

Led the migration of legacy BI and data management systems into a centralised real-time MIS with zero downtime.
Performed end-to-end ETL processes using Power Query and SQL, integrating data from MySQL, Excel, CommCare, KoboToolBox, and ActivityInfo into Power BI.
Developed advanced DAX measures, dashboards, and analytics to uncover trends, anomalies, and actionable insights for management.
Designed and implemented project-specific Monitoring Information Systems (MIS) for digital data collection, analysis, and visualization.
Updated and maintained the organisation’s central electronic database, ensuring data accuracy, consistency, and accessibility.
Designed and refined MEL documentation including Theory of Change, MEL frameworks, MEL Plans, and Indicator Tracking Tools.
Led field-level data collection activities such as farmer registration, profiling, GIS mapping, routine monitoring, surveys, and assessments.
Developed data collection methodologies, tools, plans, and budgets for routine monitoring and periodic surveys.
Ensured high-quality data collection through rigorous tool design, enumerator training, supervision, and continuous data quality reviews.
Provided training, mentorship, and capacity building to State MEL officers, enumerators, and extension agents on digital data collection technologies.
Conducted monthly analysis of monitoring data and produced charts, tables, and narratives highlighting performance gaps and achievements.
Led the development of periodic project reports for internal and external stakeholders.
Ensured gender considerations were fully integrated into all monitoring processes and reporting.

MEL Specialist/Data Analyst

November 2022 - May 2024

Sanekonsult, Abuja Nigeria.

Design and refine relevant MEL documentation including Theory of Change, MEL frameworks, MEL Plans and Indicator Tracking tools.
Design and implement project-specific Monitoring Information Systems (MIS) for data collection analysis and visualization.
Lead the execution of field-level data collection activities in the project including farmer registration and profiling, GIS data collection, routine monitoring of farmers' performance, surveys, and assessments.
Lead the development of data collection methodologies, plans, tools, and budgets for every routine and periodic (surveys) data collection activity.
Quality assure all data collection activities in the project through the development of cutting edge questionnaires, rigorous training of data collectors, supervising the data collection process, and reviewing data input and quality.
Train and Provide supervisory support, mentorship and capacity building to State MEL officers, enumerators, and extension agents on the use of digital data collection technologies.
Update and maintain the project's central electronic database.
Perform monthly analysis of monitoring data generated from activities and provide feedback (using charts, tables, narratives, etc) to management indicating where project activities and interventions are falling short, meeting, or exceeding the expected outputs and outcomes.
Lead the development of periodic reports.
Ensure gender considerations are mainstreamed throughout all monitoring activities and processes.

Monitoring and Evaluation Officer

November 2020 - November 2022

Agrolog LTD, Kaduna Nigeria.

Designed and refined MEL documentation, including Theory of Change, MEL frameworks, MEL Plans, Indicator Tracking Tools, and built robust M&E systems and feedback mechanisms for effective resource use.
Designed and implemented project-specific Management Information Systems (MIS) for digital data collection, analysis, and visualisation.
Led field-level data collection activities such as farmer registration, profiling, GIS mapping, routine monitoring, surveys, and assessments.
Developed survey questionnaires for ODK, KoboToolBox, Ona, CommCare, and GIS tools, ensuring alignment with project indicators and data quality standards.
Maintained high data quality at the point of collection through rigorous tool design, supervision, and continuous quality assurance checks.
Cleaned, analysed, and visualised data, generating actionable insights and producing coherent MEL reports enriched with charts, graphics, and compelling storytelling.
Conducted monitoring visits to field and programme activities to verify data accuracy, compliance, and performance against targets.
Implemented M&E, research, and learning frameworks, mining data from primary and secondary sources to support evidence-based decision-making.
Provided ongoing support to ensure effective use of MIS tools and adherence to data quality protocols across field and programme teams.
Trained 25 support staff and over 1,000 field staff on digital data collection tools (ODK, CommCare, ArcGIS Survey123) and Power BI, improving data accuracy from 65% to 93%.
Built capacity of field staff and MEL officers through mentorship, supervision, and continuous technical support.
Participated in annual project evaluation and planning workshops, contributing data-driven insights for strategic decision-making.
Collected and developed project success stories to strengthen organisational visibility and stakeholder engagement.
Optimised transportation routes for input distribution, achieving a 20% cost reduction through data-driven analysis.

Researcher/Data Collector(Enumerator)

February 2007 - August 2008

TNS/RMS, Kano Nigeria.

Maintained quality standards of data at the point of collection and through the data lifecycle.
Verify that collected field data is accurate and complete.
li>Cleaned, analysed, and presented data to dashboards, ensuring real-time insights and accurate reporting.
Prepared detailed reports.

Services

As a data analyst, I translate data into valuable and comprehensible insights. My goal is to improve results, make the right decisions and save costs.

Data Analytics (Data Analysis)

Provides data analysis using tools like Excel and Python, and creating accurate and comprehensive reports tools like that present the findings, patterns and suggestions derived from the data.

Dashboards

My expertise is in creating PowerBI Dashboards that display the latest data in a dynamic manner. You can explore and analyze the data yourself by using the click and drill features.

GIS data collection & Analysis

I have worked extensively on various spatial data projects. I can use GIS software tools, such as ArcGIS, QGIS, and Google Earth, for data processing, and geostatistical analysis.

infographics (interactive)

Present your data in an inspiring way by using an infographics rather than a piece of text. I create interactive infographics which can be used within or outside clients organization

Data Collection & Processing

I'm trained and highly Experienced in questionnaire design, and have worked with KoboCollect, CommCare, Survey123, Google forms and to collect and process data.

Training

I can coach/train other staff member to enhance their skills, knowledge and abilities to perform their tasks effectively, increase productivity and foster a positive work culture.

Portfolio

In this portfolio, you can find some of the projects that I have completed or contributed to, along with the details of the project, the technologies used e.t.c. I hope you enjoy browsing through my portfolio and feel free to reach out to me if you have any questions or inquiries.