Mokereri Kelvin

MOKERERI KELVIN NYAMBAGACHA - ⋄ Nairobi, Kenya-⋄ Github ⋄ Portfolio OBJECTIVE Data Analyst with 2+ years of experience in Supply Chain, seeking full-time Data Analysis roles. EDUCATION Data Analytics, ALX AFRICA May - Dec 2023 Bachelor of Procurement and Logistics Management, Multimedia University of Kenya Second Class Honours Upper Division. 2017 - 2021 SKILLS Data Analysis Soft Skills Procurement SQL, Python, SPSS, Power BI, Excel Communication, Problem-solving, Collaboration, Organization Negotiation, Sourcing, SAP, Customer Service EXPERIENCE Fulfillment Assistant Kapu Tech Africa • • • • • Jan 2024 - June 2024 Nairobi Gathering data related to order processing, inventory levels, and shipment. Analyzing order data to identify trends, patterns, and anomalies in the fulfillment process. Generating regular reports on order processing time, inventory turnover, and stock levels. Implementing data-driven strategies to streamline warehouse operations and logistics. Creating interactive dashboards using Excel and Power BI to present data-driven insights. Data Analyst Intern Kenya Revenue Authority Jan 2022 - Dec 2022 Nairobi • Developing and maintaining dashboards and reports to visualize key business metrics. • Extracting and manipulating data to ensure accurate and timely information is available for reporting. • Analyzing data to identify trends, patterns, and insights to inform business strategies and decision-making processes. • Ensuring the accuracy and consistency of data reported by implementing quality checks and validation processes. • Providing technical support for other departments to understand and utilize dashboards and reports. • Facilitation of clearance of cargo (imports and exports). Attachee PCEA Kikuyu Hospital Dec 2020 - March 2021 Kiambu • Assisted in data collection, cleaning, and preparation for analysis. • Collaborated with cross-functional teams to present findings and recommendations. • Providing technical support for other departments to understand and utilize dashboards and reports. PROJECTS Supply Chain Analysis. Analyzed data to optimize the supply chain processes and revenue generation for a company engaged in producing and selling skincare, haircare, and cosmetic products by using SQL and Power BI. (Dashboard) Company Sales Report. This Power BI report shows the sales performance of a company across different regions, products, and time periods. (Dashboard)