Dennis Munderu

DENNIS MUNDERU - |-| LinkedIn | Github Nairobi, Kenya. SKILLS ● ● ● ● ● ● ● ● SQL (database management) Python and R Advanced Excel Tableau Data cleaning and preprocessing Cross-functional collaboration Data mining and extraction Data analytics and visualization WORK EXPERIENCE Nakala Analytics Nov 2023 - Present Data Analyst Intern Nairobi ● Helped to develop a data governance framework for a client resulting in 15% data quality. ● Conducted ad-hoc analysis and reporting, leading to cost-saving opportunities on overheads. ● Cleaned data entries preparing them for analysis by senior analysts. Single World Traders LTD Jan 2019 - Oct 2023 Supply Chain Manager Nairobi ● Analyzed historical inventory Data to identify opportunities for reducing carrying stocks while ensuring adequate stock level. This raised our stock holding accuracy to 95% plus. ● Developed an Excel-based system for route planning, resulting in a 35% reduction in transportation costs and over a 55% improvement in delivery time. This achievement led to my promotion from a logistics officer to a supply chain manager in 2021. ● Designed and generated reports and dashboards to track key performance indicators (KPIs) such as inventory turnover, fill rates, and order accuracy. PROJECTS ● ● Salary Survey Data Preprocessing for Analysis: This is a project that begins with scraping survey data on salary from the Ask a Manager website and proceeds to clean it on pandas preparing it for easy analysis. Link: https://github.com/Munderu-ndech/Data-cleaning-salary-survey Exploratory Data Analysis on Homicide by Country: an exploratory statistical and visualization analysis of homicide rate across countries. An in-depth investigation of how homicidal rates compare across the globe. Link: https://github.com/Munderu-ndech/Homicide-by-country EDUCATION University of Nairobi BSc leather science and technology Sep 2014 - Nov 2018 Second class honors - upper Division Our Lady of Fatima Highschool Diploma Feb 2010 - Nov 2013 Grade - A - CERTIFICATION Intro to programming (Python Language) Pandas SQL Kaggle.com kaggle.com kaggle.com