Samuel Chege Email and Phone Number

• Providing technical support in deploying ETL/ELT packages to production.• Administration of Oracle Data Integrator(ODI), Informatica Power Center, Oracle Application Server(OAS), WebLogic 12C and Oracle Databases.• Enforcing compliance to specifications, standards and procedures to ensure proper integration for data consistency.• Troubleshooting and fixing issues in the ETL/ELT data pipelines • Performance Tuning & Capacity Monitoring of the data warehouse• Analyzing architectural issues and proposing alternative solutions.• Developing and maintaining the data warehouse technical documentation. • Assisting in the development and implementation of data workflows, aggregated tables and views to enhance the data warehouse.• Providing proactive and reactive support to minimize downtime and ensure fast query responses• Implementing data warehouse changes by applying new patches and versions when need be.• Monitoring the performance of hardware and software to maintain a healthy data warehouse environment.

• Analyzing the current IT landscape in the Authority to detect critical deficiencies and recommend solutions for improvement to ensure alignment of technology with business initiatives• Conducting AS-IS and TO-BE architectural reviews for agility and performance enhancement of the Authority’s core systems:• Conducting business capability modeling to document KRA’s business architecture in order to provide a comprehensive overview of the enterprise, and purpose of all business functions within each department.• Documenting KRA’s information systems architecture and conducting GAP analysis in order to develop recommendations for IT resource and cost optimization.• Developing KRA’s current data architecture• Developing KRA’s current application architecture• Assisting in the development of proposals, business cases, work plans as well as budget estimates of Enterprise solutions:• Researching on emerging technologies and developing proof of concepts for technology scouting and screening to evaluate the feasibility of proposed solutions/projects. • Developing KRA’s baseline enterprise architecture using the TOGAF ADM approach• Assisting in technology solution design, planning, and estimation of enterprise-wide implementation effort.

• Formulating soil health decision support systems using the best practices for the design of database systems.• Working with data architects and software engineers in the development of data management systems for Africa’s soils using MongoDB, PostgreSQL, Python, and Django.• Support as necessary the daily administration and performance of the ICRAF's SpecLib system for users at the headquarters and external partners.• Performing cross-referencing, merging and blending data from multiple sources.• Developing interactive interfaces for enhanced ad-hoc querying that aids in downstream analytics.• Developing feature engineering and batch processing scripts for soil data.• Data pipeline development for seamless flow of data through the sequential phases of collection, cleaning, and standardization for archiving, retrieval, and analysis.• Liaising with data analysis experts to optimize data processing by application of parallel and distributed computing in ICRAF's data servers.• Working with the ICRAF soil data team to build machine learning systems for chemometric studies.• Developing python scripts for ETL & QC (Extract, Transform, Load, and quality control check) operations while migrating large historical datasets from legacy systems to the cloud.• Creating technical and user documentation of the systems developed and the various data workflows as well as conducting training for new users.• Providing technical guidance on the process of data and information migration from legacy systems to new solutions.• Providing technical support in the implementation of the ICRAF Soil Spectral Library System.• Designing data collection forms with ODK and harvesting the data collected.• Assists in the development of standalone R Shiny Dashboards for data visualization.

Developing Database solutions and Analytical tools that enhance soil health research through;• Data portal development using Python, Django & Flask.• Developing high-performance APIs to support mobile applications.• Performance monitoring and optimising PostgreSQL and MongoDB.• Performance monitoring of NGINX web servers.• Creating technical manuals of system and database configurations.• Handling and warehousing large soil datasets.• Writing Python Scripts for job scheduling and data processing.• Optimising machine learning scripts for soil health analytics. • Data wrangling, data integration, and data modelling.• Creating procedures and scripts for ETL.• Developing interactive Python Dash and R Shiny Dashboards.• Soil Database portal administration.

Building web applications and websites.• E-commerce systems development and integration.• CMS development. (Joomla and WordPress).• Digital Marketing and Search Engine Optimization.• Web application development using Python Django Web Framework.

Web application development.I learned to develop Web application systems using the PHP - YII, and Code Igniter framework. I also gained a lot of Database design and development skills using SQL and I enjoyed learning MySQL, PostgreSQL as well as Oracle databases. The internship also helped me get the practical skills of system analysis and design as we did the requirement analysis of the Hostel management system and library portal in-house. In addition to those tasks, I offered the School Portal support by responding to mail requests of students who had technical difficulties while dealing with the school portal.