Home
/
Experts
/
Robert Oichi

Robert Oichi

Systems and Data Operations Officer

Highest degree :

Bachelors

Field of study :

. Computer Science

Location :

Kenya

Citizenships :

Kenyan

Experience :

6 Year(s)

Countries :

Kenya

Gender :

Male

Sectors :

Digital ICT Expert | Data Scientist (AI/ML) | Digital Healthcare Technologist | Cloud & Data Center Specialist

Experience

Systems and Data Operation Officer

Nairobi

SHOFCO

June 2021

-

Present

• Developed and maintained data transformation pipelines using dbt, pushing changes to GitHub repository to ensure data quality, consistency, and reusability for analytical purposes. • Designed and implemented data models within dbt, optimizing for performance and scalability, leading to more efficient data querying. • Collected user requirements for developing data marts from staging data, ensuring alignment with business needs. • Extracted and ingested data from various sources, including CommCare and Google Sheets, by designing survey forms, creating applications for different programs, and collaborating with users and user departments on data collection requirements, ensuring data integrity and timely availability for reporting. • Performed extensive data cleaning and validation processes to identify and resolve discrepancies, improving the accuracy of downstream analytics. • Integrated diverse data sources with Dalgo Superset to create interactive dashboards and build data visuals for various programs, including youth employability, education, sustainable livelihood, gender, WASH, and women empowerment. • Managed database creation, table normalization, and developed SQL query scripts, optimizing database performance through indexing. • Managed code versions and collaborated effectively with team members using Git and Visual Studio Code. • Participated in the design and implementation of new data solutions, contributing to architectural discussions and best practices.

Innovation Manager

Nairobi

iHub

May 2018

-

May 2019

• Spearheaded innovation processes including development of Business Model Canvas and scaling Matrix models for early-stage innovators. • Provided hands-on support with prototyping tools such as InVision and Figma, enabling rapid iteration and user-centered design. • Conducted Design Thinking and Human-Centered Design trainings to enhance creative problem-solving and process improvement. • Designed and implemented database management systems and web content applications using Wordpress, Javascript, CSS, and HTML. • Delivered technical assistance in data science, including data mining, visualization, interpretation, and dissemination via knowledge management platforms. • Guided social entrepreneurs in developing product prototypes, sketches, and customer-centric design assets. • Planned, organized, and facilitated innovation workshops and Demo Days to showcase emerging solutions. • Coached innovators in refining their pitching and presentation skills for stakeholder engagement and funding opportunities. • Monitored and tracked training sessions and workshops to evaluate impact and ensure continuous improvement. • Explored strategic partnerships and connected entrepreneurs with industry mentors to accelerate enterprise growth. • Documented innovation processes and authored reports for internal and external stakeholders. • Developed detailed work plans and schedules for innovation activities and capacity-building programs. • Supported stakeholder mapping, customer journey mapping, and persona development to align innovations with user needs. • Managed the operations and strategic direction of the DEPP Innovation Lab, fostering inclusive, community-led innovation across disaster-prone regions

GLD-Web Lead

Nairobi

International Humanity Foundation

September 2019

-

May 2021

• Development of the new website for International Humanity Foundation, www.ihfonline.org • Maintenance of the website and making changes when needed • Designing flow charts, prototypes and sketches for the website during website development • Coordinating volunteers from different countries and training them on how to carry out website maintenance and updating content on the website.

Awards & Certificates

Data Engineering

Online

Edx

2024

This is a professional course that covared the following courses: Data Engineering Capstone Project Apache Spark for Data Engineering and Machine Learning Big Data, Hadoop, and Spark Basics Data Warehousing and BI Analytics Building ETL and Data Pipelines with Bash, Airflow and Kafka Relational Database Administration (DBA) Linux Commands & Shell Scripting SQL for Data Science Python for Data Engineering Project Python Basics for Data Science Data Engineering Basics for Everyone Relational Database Basics SQL Concepts for Data Engineers NoSQL Database Basics Certificate link: https://credentials.edx.org/credentials/64bc21710f6d40cdb296dae022f73831/

Power BI Fundamentals

Online

DataCamp

2024

This is a course offered online and covers the following courses: Data Modeling in Power BI Data Preparation Case Study: Analyzing Customer Churn in Power BI Data Visualization in Power BI Introduction to DAX in Power BI Introduction to Power BI

Data Analyst in Python

Online

DataCamp

2023

The course covers the following units: Exploratory Data Analysis Hypothesis Testing in Python Sampling in Python Importing and Cleaning Data with Python Data Manipulation in Python Introduction to Data Visualization with Seaborn Introduction to Statistics in Python Joining Data with Pandas Intermediate Python Introduction to Python

Languages
English
Speak
Very Good
Read
Very Good
Write
Very Good
Swahili
Speak
Very Good
Read
Very Good
Write
Very Good
Skills

Power BI, Tableau, Advanced Excel, SQL, Oracle, MongoDB, PostgreSQL, Redis, Miro, Diagrams.net, SAP APM, Mapping & Spatial Analysis, AWS, Azure, Spring, Java, Node.js

SQL language

dbt

Apache Superset

Apache Sparks

PostgreSQL

Python