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
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.
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
