Terence Kihato, Developer in Rome, Metropolitan City of Rome, Italy
Terence is available for hire
Hire Terence

Terence Kihato

Verified Expert  in Engineering

Database Developer

Rome, Metropolitan City of Rome, Italy
Toptal Member Since
November 25, 2022

Terence is an Oracle database PL/SQL expert with solid industry-tested data and database management skills honed over 20 years within fast-paced public and private sector organizations. He was engaged in some of the most complex data undertakings, such as transitioning from the United Nations System Accounting Standards to the International Public System Accounting Standards and several UN projects on individual data visualization infrastructure.



Preferred Environment

Oracle, Oracle SQL, Oracle PL/SQL

The most amazing...

...thing I've performed consistently is tuning database processes and reducing the FAO monthly field data refresh from one week to two hours.

Work Experience

Database Developer (Contract)

2021 - PRESENT
European External Action Service (EEAS)
  • Overhauled a key report previously based on the monthly materialization of static data to use live data with no deterioration in performance while using up less disk space, employing Oracle's pipelined function capability.
  • Optimized the performance of a key database view resulting in the view returning data in 8.5 seconds, down from the previous average of 1200 seconds (20 minutes).
  • Improved non-production database dumps by reducing their disk sizes by 80% without impacting the capability of the resulting databases, leading to faster, more frequent non-production refreshes and more reliable development and testing cycles.
Technologies: Oracle, PL/SQL, Excel VBA, Jira, Pivot Tables, Excel Macros, Database Management Systems (DBMS), Procedural Programming, Oracle Database, Business Analysis, Database Design, PL/SQL Developer, Relational Databases, Database Programming, SQL, Writing & Editing

Program Analyst

2002 - 2020
Food and Agriculture Organization of the United Nations
  • Developed the database layer of the tool used to report the Food and Agriculture Organization's (FAO) $128 million implementation, funded under the 2008 EU food facility program. The tool handled large daily volumes of transactions while ensuring compatibility with EU budget systems.
  • Collaborated with team members in developing a BI-based tool to track each FAO project, ensuring full compliance with donor fiduciary standards. The director general acknowledged the effort in an official letter.
  • Delivered training on ERP concepts, practices, and procedures in English and Spanish at the FAO regional office in Santiago de Chile.
  • Developed an Excel-based monthly reporting tool that consisted of worksheet formulae, VBA macros, and ODBC interfaces with an Oracle database. It generated over 250 global, country, and regional workbooks, each comprising 10 worksheets.
  • Oversaw the conversion of the FAO TeleFood database from Microsoft Access to Oracle RDBMS. TeleFood is a group of FAO microprojects with budget limits not exceeding 1,000 dollars.
Technologies: Database Management Systems (DBMS), Excel VBA, Pivot Tables, Excel Add-ins, ODBC, Oracle Database, PowerBuilder, Business Analysis, Database Design, Oracle, Procedural Programming, PL/SQL Tuning, Relational Databases, Database Programming, Technical Writing, SQL, Microsoft Excel, Writing & Editing

IATI Data Interface | FAO

The International Aid Transparency Initiative (IATI) standard is a set of rules and guidelines for open data publication by organizations, governments, and multilateral institutions. Being open to the public, publication using the standard increases an organization's transparency and helps improve accountability to taxpayers. IATI brings together more than 100 entities that publish data based on a specific detailed standard defined using XML.

I constructed the database process underpinning the data flow of FAO's field initiatives (65% of the overall budget) from the bespoke system to the ERP and onto IATI.

Online Environmental and Social Safeguards Screening Tool

This is a key component of the Food and Agriculture Organization (FAO) aid management compendium of tools. It is an Oracle/Java-based screening tool that checks if aid intervention given to a recipient country meets the "do no harm" conditions. It required a PL/SQL back end to validate the intervention against screening criteria (impact on water sources, forests, local communities, and so on). I developed the Oracle back end, which produced and maintained the SQLs for clearing, flagging, and messaging on the internet page and via email.

Water Management System

This project entailed implementing a water management system for water release and monitoring in the network of KenGen electricity dams. Working from Madrid, Spain, I developed a multi-language module so the system could be run in Spanish or English, depending on the user's choice. I also created two SQL-based reports, a monthly hydro station report showing daily water levels and spillage, and a report that shows the daily amount of electricity generated against dam levels. These reports were used in forecast generation in the ensuing months.

Monthly Financial Reconciliation Tool

I developed an Excel-based tool that deploys an Open Database Connectivity (ODBC) connection to extract data from SQL. It applies formulas to that data to prepare projection scenarios. Using a VBA-based macro, it generates more than 250 global, country, and regional workbooks, each having at least 10 worksheets.
2011 - 2013

Master of Science Degree in Computing for Commerce & Industry

The Open University - Milton Keynes, UK

1993 - 1997

Bachelor of Science Degree in Mathematics and Computer Science

University of Nairobi - Nairobi, Kenya




Microsoft Excel, Microsoft Access, Jira


Excel VBA, PowerBuilder, SQL, HTML


Procedural Programming, Database Design


Oracle, Oracle Database


Relational Databases, Database Management Systems (DBMS), PL/SQL Developer, Oracle PL/SQL, Oracle SQL, Database Programming, PL/SQL


Software QA, PL/SQL Tuning, Pivot Tables, Excel Macros, Business Analysis, Enterprise Resource Planning (ERP), Technical Writing, Writing & Editing, Software Engineering, Excel Add-ins

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.


Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring