Michael Egbe Email & Phone Number

Nigeria

Federal Capital Territory, Nigeria

Nigeria

As Database Administrator and GIS lead, I design, implement and administer multiple database management systems and Data processing workflows to support the PACE projects and operations. I currently lead the design and development of a National Agricultural Assets database and electronic farmer directory to facilitate the implementation of three of the Federal Government of Nigeria's (FGN) Agricultural transformation programs viz: the National Livestock Transformation Plan (NLTP) – an initiative of the FGN to foster peaceful co-existence between farmers and herders (and curb farmer-herder clashes) through the introduction of modern ranching models, the Green Imperative (GI) - a partnership with Brazil to improve access to the knowledge and use of modern mechanized farming equipment in Nigeria through the establishment of service centers and assembly plants across States of Nigeria, and the Agriculture for Food and Jobs Plan (AFJP) - which in line with the Nigeria Economic Sustainability Plan (NESP) is designed to help mitigate the impact of COVID-19 on smallholder farmers and the entire agricultural value chain through the provision of input financing, extension services and subsidies to farmers to boost local food production. Over 6 million farmers have been enumerated so far along with the geospatial locations, shapes, and sizes of their farms across the 36 states of Nigeria and the FCT, with the data being processed (cleaned, validated, standardized) and integrated into the database.

Facilitated the use of innovative technology to advance the achievement of UNAIDS 95-95-95 targets on the USAID-funded Strengthening Integrated Delivery of HIV/AIDS Services (SIDHAS) project.• Developed M&E platforms to track project performance on service delivery indicators• Facilitated the setting up of measures for key performance indicators (KPIs) in the situation room• Supported the automation of key processes to ensure efficiency in the situation room• Contributed to the design of dashboards & reports to show KPIs & tech. area-specific cascades• Supported research and development of manuscripts for publications and reports• Facilitated the use of GIS to drive project implementation in the state and inform resource allocationAchievements:• Developed interactive dashboards used at the Daily Situation Room meetings to track community and facility achievements across the 3 95's [please see sample at URL: https://bit.ly/3h787ra]. In developing the dashboards I met with prospective users to gather requirements, identified KPIs and data elements, and developed automated ETL processes to link key data elements from DHIS2/other sources to the dashboard using the APIs. Mapped entity relationships, developed DAX models, and prepared interactive visualizations using PowerBI• Deployed ODK/Kobotoolbox to map the locations of HIV testing points in the community• Applied geostatistical methods to infer new ‘hot spots’ (high yield locations) for targeted testing• Supported the development of abstracts and research papers (in press), concept notes and contents (narratives, data analysis, charts, and GIS maps) to service presentations and organization’ blogs• Initiated the procedures for migrating historic community HIV-testing data from ODK to LAMIS-lite DB• Pioneered the use of GIS to enhance HIV case-finding in the state published in the UNAIDS 2020 global AIDS report - URL:https://bit.ly/3tnZmPu (p.115)

Kano

• Planned, supervised and coordinated the daily activities of 17 fulltime technical staff including Associate Technical Managers, GIS Analyst and Data Analysts while ensuring the quality and timeliness of outputs• Led the execution of all data management activities on the GRID3 project resulting in the development of a robust Spatial Database, Population Estimates Model and Data Portal for the Nigerian government• Designed and executed DB architectures, back-up/restore and DQA processes to ensure database integrity • Developed a methodology for integrating geospatial technology to substitute the manual and error-prone procedures for conducting ‘Nutrition and Health Indicator Surveys’ by the Kaduna State Bureau of Statistics. Streamlined data collection and QA procedures, improved the quality of survey data collected and strengthened the integrity of data analysis results derived from the annual statewide survey• Supported business development including proposal drafting, contract negotiations, and preparation of weekly donor reports. Collaborated on proposals amounting to $5,000,000 won on contracts and grants• Planned and facilitated staff and client-based capacity building activities and training sessions

Kano

• Devised GIS and ICT integration strategies for data management in support of the organization’s projects• Developed a variety of automated data management solutions including ‘MISTAR’ designed to support offline daily ‘microplan’ settlement level coverage reporting thus allowing teams in remote areas to increase vaccination coverage and reduce the number of previously ‘missed’ population by 28%• Supervised the processing, QA, and integration of primary and secondary data into the GIS database• Worked with the Software development team to implement data management requirements for the Field Tracking Systems (FTS), Micro planner and Health Facility Registry (HFR) applications• Undertook the administration of PostgreSQL server relational database and maintained database integrity and security through standardized user roles and privileges

Kano, Nigeria

• Coordinated the automation of over 80% of the geodatabase data quality assurance processes, improved the database integrity and achieved timely publication of the database ahead of vaccination campaigns• Designed and developed database systems, web portals and data interoperability procedures to facilitate data sharing or exchange with requesting parties, data analysis and integration to reporting dashboards• Oversaw the deployment of mobile data collection tools (ODK, aggregate server, offline imagery tiles, map guides, and data quality monitoring systems) to facilitate the acquisition of accurate geospatial data• Combined the use of geospatial and statistical analysis techniques to analyze data and presented findings in the form of graphs, charts, maps and reports to support programmatic decision making• Conducted state level engagements and capacity building/training to encourage the use of Routine Immunization (RI) microplan maps by the state RI (SERICC) team to improve immunization coverage

Kano, Nigeria

• Performed complex geospatial analysis and geoprocessing to support map creation and other products • Prepared and delivered training to junior GIS Analyst, field officers and implementing partners on various aspects of GIS, mobile data collection including diagnosing and troubleshooting of related software issues• Facilitated the transitioning of departmental operations from proprietary to Opensource technologies• Provided specifications for software and hardware to facilitate organizational needs regarding GIS

Kano, Nigeria

• Prepared map guides to ease field navigation and feature identification associated with data collection• Oversaw the collation, processing, and transfer of field data into the GIS• Utilized tracks and satellite imagery to complement the capture of settlement and points of interest data• Performed map corrections on existing Polio Vaccination Tracking System (VTS) geographic datasets• Conducted GIS analysis, queries, searches, and data manipulation to support the production of maps, displays, and figures as needed for project related activities

Kano, Nigeria

• Utilized a variety of geoprocessing and spatial analysis techniques to identify and correct errors within an inherited geodatabase covering 6 Northern states of Nigeria in a view to achieving an accurate reference base map to support Vaccination Tracking and other Polio eradication efforts in the region• Prepared mobile applications, field map guides, and navigational apps to support over 20 rounds of field data collection held across 6 Northern states of Nigeria between the months of July and December 2013

Calabar, Nigeria

• Supported the development of a digital cadastre and automated land registry system for Cross River state• Conducted data conversion, coordinate transformation, digitization and attribution of parcel data from scanned survey plans, data validation and linking of parcels to registry files for the preparation of C of O

Calabar

• Conducted a desk study of groundwater geology and geophysical survey data where available• Examined the drill cuttings at the well site to infer formation characteristics and determine porous and permeable formations (depth intervals) for screening and casing of the borehole• Maintained a Microsoft Access database of well locations and aquifer characteristics or attributes

Master'S Degree, Petroleum Geology With Applied Gis And Remote Sensing

Thesis: Sedimentological Controls on the Reservoir Properties of Deep Water Sediments of 'X' Field, Offshore Niger Delta, Nigeria

Health, Safety And Environment (Hse)

Activities and Societies: Elementary First Aid, Fire Prevention and Fire Fighting, Personal Safety and Social Responsibilities, Personal.

Bachelor'S Degree, Geology/Earth Science, General