BILLY FRANKLIN ADWAR
Nairobi
Summary
Results-driven Data Analytics Engineer with expertise in Python, SQL, Machine Learning, successfully optimizing operations at agriBORA. Spearheaded the development of data-driven tools, enhancing efficiency and reducing logistics costs by 25%. Adept at fostering collaboration and implementing innovative solutions to drive growth and improve decision-making processes.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Business Engineer & Data Analyst
agriBORA
09.2024 - 09.2025
- Spearheaded ERP system deployment and optimization, streamlining workflows across departments.
- Automated critical processes in inventory, finance, and sales for enhanced efficiency.
- Created a route optimization tool using QGIS, OSM Data and PostgreSQL to plan and schedule deliveries to customers leading to a 25% reduction in logistics costs.
- Leverage SQL to create insights and models that optimize operational efficiency, advising operations team and identifying avenues for growth.
- Developed reporting tools for external agriBORA partners to monitor key metrics including credit scores, loan repayments, and customer success.
- Created customer segmentation for targeted chatbot interactions, enhancing engagement for customer success team at agriBORA.
- Implemented training and internal capacity development on metabase for self-service analytics, solidifying culture of data-driven decision making at Agribora.
Earth Observation Engineer
agriBORA
06.2023 - 08.2024
- Developed and maintained ML pipelines to automate and streamline the training, deployment and monitoring of machine learning models, ensuring scalability and reliability of models and infrastructure for continuous updates and predictions.
- .Developed and trained machine learning models to forecast yield at field level for over 1000 small-holder farmers in western Kenya leading to enhanced risk monitoring.
- Developed workflows for extracting vegetation indices using DEA STAC-enabled data-cube, supporting seasonal field monitoring and improving credit scoring.
- Designed the spatial database, queries and query optimization to support route optimization for logistics at agriBORA.
- Leveraged expertise in SQL to develop data products (dashboards and queries) using Metabase, which have enabled data-driven decision making.
- Created loan monitoring system for tracking individual farmer loans, streamlining repayment tracking and reducing loan default risks for over 1000 farmers in Western Kenya.
- Facilitated field mapping operations and conducted training data collection and quality testing for crop-cut and crop type surveys.
- Implemented data collection surveys using the KOBO open data kit for collecting non spatial data and QField for conducting crop type mapping.
Business Intelligence & Data Analyst
Oduk Tech Limited
01.2022 - 05.2023
- Customized the company's ERP systems to incorporate advanced data analytics products, facilitating business intelligence (BI) reporting.
- Implemented Metabase for comprehensive reporting, addressing data inconsistency through robust validation and real-time synchronization between ERP databases and BI dashboards.
- Led the development and customization of ERP systems tailored for manufacturing processes, focusing on digitizing workflows and automating key operational tasks.
- Customized ERPNext and Frappe framework for ERP systems, integrating SQL for seamless database connectivity.
- Addressed challenges of legacy system integration by developing APIs and ensuring seamless data migration, resulting in improved production tracking and resource planning.
- Developed web-based GIS platform for port-to-port sea routing, utilizing GeoDjango, GeoServer, Leaflet JS, PostgreSQL, and pgRouting to enhance maritime navigation.
- Designed and developed a Loan Management System for tracking loan life-cycles, including disbursement, repayment schedules, and interest calculations.
Geospatial Engineering Intern
Geo-Explicit Systems
01.2020 - 06.2020
- Deployed web map services with Geo Server and Geo Node to facilitate access to geospatial data.
- Managed spatial databases and synchronized with open source spatial databases using PostGIS on PostgreSQL to ensure data consistency.
- Conducted digital image analysis for land use and land cover using ERDAS Imagine and ENVI to support environmental assessments.
Education
Bachelor of Science - Geomatics and Geospatial Information Systems
Dedan Kimathi University of Technology
Nyeri, Kenya01-2022
Kenya Certificate of Secondary Education -
Kakamega School
Kakamega, Kenya01-2016
Skills
- Data analytics: dbt
- Data visualization
- ETL processes
- Python, Pandas, Numpy
- SQL databases
- Machine learning
- Workflow orchestration
- Workflow Automation: n8n, Makecom
- ERP Systems: ERPNext, Frappe Framework
Websites
Certification
- Git & GitHUB: Code Academy
- Advanced SQL: LinkedIn
- ESRI Spatial Data Science: The New Frontier in Analytics
- ATINGI: Machine Learning on Earth Observation
Hobbies and Interests
- Photography
- Graphic designs
- Public speaking
- Hiking
- Running
References
- Mr. Simon Ngarari, Geo Explicit Systems, info@geoexplicitsystems.co.ke, 0722 865 427
- Ms. Caroline Gikwa, Dedan Kimathi University of Technology, carolyne.gikwa@dkut.ac.ke, 0722 274 248
- Mr. Victor Omondi Mandela, OdukTech Limited, info@oduktech.com, + 0726 444 005
- Mrs. Gladys Agumba, agriBORA, gladys.agumba@agribora.com, 0722 287 116
Volunteer Experience
- Geospatial Engineering Intern, Geo-Explicit Systems, 01/01/20, 06/01/20, Managing spatial databases and syncing with open source spatial databases based on PostGIS on PostgreSQL., Deploying web map services using Geo Server and Geo Node., Carrying out digital image analysis for land use and land cover using ERDAS Imagine and ENVI.
- Volunteer, HOTOSM Humanitarian Mapping, 03/01/19, 03/01/19, Digitization of ground features, editing attributes and mapping of remote areas affected by disasters in Northern Kenya.
- Organizer, GeoDev, Dedan Kimathi University of Technology, 01/01/18, 01/01/22, Organizing meet ups and events at the Geo Dev community in Dedan Kimathi University.
Timeline
Business Engineer & Data Analyst
agriBORA
09.2024 - 09.2025
Earth Observation Engineer
agriBORA
06.2023 - 08.2024
Business Intelligence & Data Analyst
Oduk Tech Limited
01.2022 - 05.2023
Geospatial Engineering Intern
Geo-Explicit Systems
01.2020 - 06.2020
Bachelor of Science - Geomatics and Geospatial Information Systems
Dedan Kimathi University of Technology
Kenya Certificate of Secondary Education -
Kakamega School