CV

Informatiker Datenbank Administration - Fulltime

Staatliche Führungsakademie für Ernährung, Landwirtschaft und Forsten (FüAk)
Oct 2024 - Present
Germany

Supporting automation workflows for Quality Assessment (QA) in the Area Monitoring System in Germany utilizing SQL, R, and Python programming.
Managing a Linux server for application deployment, security enhancement, and ensuring uptime.
Developed a user-friendly desktop application (pgDBman) in C#, to streamline the use of command-line PostgreSQL client tools (pg_dump, pg_restore, psql).
Authored concise documentation for the Land Parcel Information System (LPIS) QA, consolidating relevant infomation from multiple technical documents into a single reference document.
Implemented optimization strategies that decreased the processing time of a PostgreSQL data management workflow by 86%.
Key Accomplishment: Automated consistency checks for LPIS QA results across 13 federal states in Germany using R programming, significantly reducing task completion time to under 5 minutes.

Werkstudent Data Analyst - Hybrid

HereWeGrow gGmbH
Jul 2023 - Sep 2024
Hamburg, Germany

Developed maps for Ethiopia and Uganda using ArcGIS and FME by combining administrative layers, multiple third-party data sources and georeferenced layers to support HereWeGrow staff in project-related decision making.
Verified raw data of a one-year research project executed by an external service provider, the so-called Farm Diary Uganda, by using advanced Excel analysis and automated programming in R.
Developed a comprehensive use-case walk-through manual on ArcGIS Online for mapping and conducted a training session to support team capacity building.
Key Accomplishment: Automated the manual process of quarterly reviewing the status of PII for over 500 files in ArcGIS Online and Enterprise

Mgr. GeoDevelopment Dept. - Volunteer

Where Geospatial
Jun 2018 - Sep 2022
Accra, Ghana

Mgr. DB Dev., Modelling and Mapping - Fulltime

International Fertilizer Development Center
Jun 2022 - Aug 2022
Accra, Ghana

Led the development of a relational database and custom spatial analysis workflows.
Co-Supervised 2 international MSc interns' research in the application of predictive modelling to map cereals yield gaps in Morocco and Ghana.
Supervised 3 staff in statistical methods and crop-soil modelling, database development, and remote sensing data analysis.
Key Accomplishment: Successfully developed a custom workflow to automate the data preparation, crop modelling and spatial prediction of potential yields, for over 5000 data points using R Programming.

DB Admin and GIS Specialist - Fulltime

International Fertilizer Development Center
Jun 2020 - June 2022
Accra, Ghana

Promoted to manager role after 2 years due to high performance and value of work.
Reduced the time-consuming steps in the modelling of large datasets using R-scripts yielding a processing time of less than 5min.
Co-Supervised 2 MSc interns research in geostatistical and machine learning analysis of yield response to fertilizers in Ghana.
Key Accomplishment: Performed a soil variability combinations spatial analysis as decision support towards FERARI field trial site selection which generated 9,000+ views with significant interests within 1 week after posting the output map on LinkedIn

Web and Application Developer - Contract

Results for Development
Jun 2020
Accra, Ghana

Developed and implemented a Geospatial Contact Tracing mobile application for collecting COVID-19 bio-sample data which provided real-time access to 3 major labs in Ghana (Noguchi-NMIMR, National Public Reference Lab - NHPRL, Veterinary Services Department -VSD), which improved average tests per day by 55%.
Trained 315 officers spanning across Frontline Epidemiologists, Lab officers, regional and district supervisors with the requisite knowledge needed to use the system.
Produced 3 detailed self-guide user manuals on the mobile and web portals, for the short to long term capacity building.
Key Accomplishment: Resolved the challenge of data losses by developing a python tool to sync un-synced data, improving overall data coverage by 97%.

Senior Technician - Fulltime

University of Ghana
Mar 2018 - May 2020
Accra, Ghana

Supported teaching and hands-on training in GIS and web based courses and assisted with the review and assessment of students' final year projects for 2 academic years.
Created a solution that provided the ability to visualize and make meaning of 10 Ghana demographic variables for use in taking informed decisions for policy making.
Administered 2 Terabytes of ArcGIS Enterprise and Microsoft SQL Server Geodatabases to ensure security, reliable data storage and availability for academic purposes.
Key Accomplishment: Successfully taught 205 MSc Geoinformation Science students in Geodatabase Management (GEOS 608), GIS Programming and Automation (GEOS 604) and Distributed Web GIS (GEOS 609)

Geospatial Engineer - Contract

Nimba Research and Consultancy Limited
Nov 2018 - Oct 2019
Freetown, Sierra Leone

Designed and implemented a Geodatabase model containing 44 different utility assets for use in a GIS survey in Freetown, Sierra Leone, to establish the utility and customer base as part of a $44.4 million threshold program funded by the Millennium Challenge Coordinating Unit, U.S (MCCU).
Automated quality assessment report generation tasks for a survey area of 81.48sqkm comprising of 73,000+ customer meters to cut down manual checks.
Improved data verification by configuring offline tiled maps used for on-field validation to maintain a GPS accuracy range of 1cm − 5cm.
Assisted with the establishment of a Geodetic GPS base station and trained 40 field engineers on the use of Collector for ArcGIS to achieve sub meter accuracy.
Key Accomplishment: Minimized the stress on QAQC engineers by designing a data review workflow and trained 10 engineers on the effective use of ArcGIS Pro Data Reviewer, increasing work rate by 15% a day.

GIS Software Engineer - Freelance

Henson Geodata Technologies
Sep 2015 - Oct 2017
Accra, Ghana

Led the development of a customer location information system (CLIGIS) to serve as a location-based solution for banks.
Guided the data team through the handling of PostgreSQL relational database management and Geoserver, a map rendering application for displaying over 100 different features in a big data of Africa.
Managed a 1.6 terabytes PostgreSQL spatial database which also hosted a web map for the African continent.
Assisted with the establishment of a Geodetic GPS base station and trained 40 field engineers on the use of Collector for ArcGIS to achieve sub meter accuracy.
Key Accomplishment: Landed the company a $15,000 sales with the development of a mobile banking system (Banikudi) that interfaced with the client's Core Banking System which greatly reduced the manual work and improved their revenue returns by 38%.

Graduate Teaching Assistant - Fulltime

Kwame Nkrumah University of Science and Technology
Sep 2014 - Aug 2015
Kumasi, Ghana

Taught student groups from 4 departments to understand Geomatic Engineering field works.
Developed a program in Python and VB.Net accessible by the entire Geomatic Engineering department of 400+ students, for computing levelling and traversing data after redundant field observations.
Assisted 2 lecturers with the development of software programs as part of their PhD research.
Key Accomplishment: Led a team of 5 teaching assistants to design and develop an inventory system to track engineering instruments collection and returns.

Curriculum Vitae