• M&E Consultant of a UNDP Public Health project entitled:
 COVID-19 Socio-Economic Impact Assessment / Socio-Economic Response Plan.
• Activities being carried out :
 Creating Reports Tracker for Use in Data Collection and Analysis;
 Designing an online questionnaire file for data collection;
 Designing an excel file for data importation;
 Importing existing data within the online M&E tool;
 Training SEIA/SERP team on data entry, data cleaning, data validation and data analysis within the online M&E tool;
 Populating the covid-19 SEIA/SERP questionnaire within UN countries;
 Supervising the collection of data across UN countries;
 Administrating data stored within the online M&E tool.
 Leading a team of 4 persons (Cameroon:1, USA:1, Russia:1, China:1)

• M&E UNV of a UNDP Environmental project entitled:
 Economics of Climate Change Adaptation Programme in Asia and Africa Regions;
• Activities carried out :
 Working in collaboration with others M&E to come out with project indicators;
 Designing mobile and web Survey Tools using odk, XLSForm, and Kobotoolbox for data entry;
 Pushing old survey data into new forms to allow former data collectors to update their answers without duplication;
 Merging all databases;
 Establishing an M&E System for Data Visualization using Dhis2 on a VPS;
 Linking Survey platform and Stata data to the M&E System through Excel, VBA, XSD, XML, dhis2- Kobotoolbox Connector;
 Integrate data resulting from the Survey platform and Stata analysis into the M&E system;
 Performing additional analyses and Creating Dashboards, Visualizers, Querying spaces, etc.
 Leading a team of 4 persons (Cameroon:1, USA:1, Zambia:1, Uganda:1)

• Uncovering the Strategist's Data Analysis Tool
• Collecting and Organizing Information
• Assessing the Situation
• Cleaning Data, modeling interactions
• Create predictive models using regression analysis,
• Complete hierarchical linear regression (HLR) analysis
• Predicting outcomes using regression models
• Developing and assessing potential strategies
• Creating resource-focused custom functions
• Determining the number of resources required to achieve the desired outcomes
• Incorporating logistic constraints into predictions
• Assess the viability of achieving the outcomes predicted by regression models.
• Planning for the future, organizing the Plans.
• Consider the statistical and practical significance of our analyses.
• Communicate our raw R data analyses in the most effective manner.

• M&E Officer of UNFPA/SOGOC Mentoring project entitled:

 Mentoring of Reproductive Health Service Providers and Community Health Workers of Far-North, North, Adamaoua, Center and East Regions in Cameroon.

• Activities carried out :

 Writing of the Proposal, the Logic plan & the Annual Work Plan;
 Budgeting various work plan activities;
 Implanting the Monitoring & Evaluation Service;
 Writing of the Logic Monitoring Framework;
 Writing of the Monitoring Plan;
 Elaborating Terms of reference and data collection tools for each project activity;
 Establishing the Accounting System (Sage 100 Compta, Sage 100 Gest. Com.);
 Establishing the Monitoring System (Dhis2, PostgreSQL 10, R extension);
 Linking the monitoring system to the Google service API to display project map layers.
 Performing Desk Review Analysis on Project Indicator’s Models;
 Collecting, Cleaning, Analysing and Storing Project Results;
 Performing three Months Progress Reports;
 Planning for the next three months activities, finance, and human resources;
 Gathering Project Output and Developing Project Indicators for the Monitoring Dashboard;
 Using of UNFPA’s finance and program management tool (GPS2) for project reporting and finance demanding.
 Coaching “mentors” in health facilities fields;
 Following “mentees progress” through a dhis2 dashboard to ensure a good quality of reproductive health service delivery.
 Leading a team of 178 collaborators across the regions of Cameroon.

• Deploy Oracle 12c under Windows 10 and Ubuntu 14.04 LTS according to the OFA model.
• Design a Shell script to automate the startup of the deployed database.
• Explore the different modes of starting an instance and the associated administrative tasks.
• Allocate and oversee the evolution of the memory space (PGA and SGA) of a database.
• Understand the mechanism of an instance, anticipate and recover an instance crash.
• Allocate and oversee the physical and logical evolution of the size of a 12c database.
• Benchmarking and upgrading multiple databases on a single root.
• Optimize storage space, prepare tables for recursive truncated operations.
• Prepare Flashback operations, create archives, tablespaces, and allocation of quotas.
• Track Data modification over a period of time.
• Virtualize columns, create views, restrict some users' access to data.
• Execution of dimensional queries.
• Navigating between versions of the data to search for models.
• Look for links between data, interpret and predict trends.
• Analyze and interpret the data stored in the database thanks to the SQL functions.
• Create and associate error tables with their main tables in the database.
• Securing database data by granting privileges and roles.
• Import and export database data, create external tables.
• Feed the database with applications built on other databases.
• Normalize tables in the database with Pivot Insert, Unpivot, and Pivot.

• Install an MS SQL Server 2008
• Create an MS SQL Server project with Migration Wizard.
• Define project conversion, migration, and type mapping options.
• Connect an instance of the SQL Server database to an existing Oracle 11gR2 database.
• Map the Oracle database schemas to the SQL Server database.
• Create evaluation reports of SQL server database objects to convert.
• Convert Oracle database schemas to SQL Server schemas.
• Generate, review and run a script in SQL Server.
• Synchronize the objects in the database.
• Migrate data to SQL Server.
• Understand the BI environment for data updates.
• Import, visualize, analyze data through Cognos Insight V10.2

• Design, install and configure an Oracle 10gR2 database.
• Define and manage the security policy of the installed database.
• Ensure the storage and availability of database data.
• Make a back-office communication between the installed base and other existing databases.
• Writing SQL queries from the database layer.
• Automation of business processes by stored procedures and triggers.
• Creation of PL / SQL functions / procedures to generate reports.
• Front-end development to display the generated states.
• Leading a team of 3 persons (Cameroun:1, Gabon: 2)