Data Entry Clerk (Remote) Applicant John Mbote

JOHN MBOTE

Nairobi, Kenya +254********* *************@*****.*** LinkedIn GitHub

EXPERIENCE

LIYANA Healthcare 2025 - 2026

Data Analyst Intern

• Cleaned and analyzed large datasets using SQL and Excel pivot tables and formulas.

• Automated report generation with Excel macros to improve reporting speed and consistency.

• Built interactive dashboards in Power BI and Tableau.

• Monitored KPIs using Tableau to visualize regional sales performance. Winners Chapel International 2025 - Present

Youth Leader

• Led a team of 50+ youth, applying time management skills to organize weekly community events.

• Mentored junior members on personal and professional development, applying strong communication skills.

• Planned and executed large-scale youth conferences and workshops.

• Liaised with senior management to align youth goals with the organization. Kenya Education Fund 2025 - 2026

Design Thinking Coach

• Mentored scholarship students in creative problem-solving skills.

• Trained diverse teams on human-centered design methodologies. EDUCATION

Mount Kenya University 2023 - 2026

Bachelor, Business Information Technology

Word Of Faith Bible Institute 2024

Certificate, Leadership

PROJECTS

PharmaInsights - Pharmacy Analytic Dashboard Aug 2025 Nairobi, Kenya

• Developed a multi-page Tableau dashboard for sales, inventory, and expiry tracking, improving visibility into key pharmacy metrics

• Built a data preprocessing pipeline in Python using Pandas with automated validation checks to ensure data accuracy and completeness

• Created interactive visualizations in Tableau to deliver actionable insights on sales trends and inventory levels Customer segmentation Sep 2025

Nairobi, Kenya

• Applied K-means clustering in Python with scikit-learn to segment customers based on purchasing behavior and demographic attributes

• Presented marketing insights and customer segment profiles in Excel, enabling targeted campaign strategies Sales Data Analysis and Forecasting Jun 2025

Nairobi, Kenya

• Perfomed EDA and built forecasting Models

• Visualized Trends and Patterns

SUMMARY

Final-year BBIT student and aspiring junior data analyst with hands-on experience cleaning and analyzing large datasets, automating reports, and building interactive dashboards in Tableau and Power BI. Proficient in Excel formulas, pivot tables, basic SQL querying, and Python libraries for data manipulation. Strong attention to detail and time management, eager to support data operations and client-facing reporting. SKILLS

• Programming Languages: Python, JavaScript, HTML, CSS

• Data Analysis Libraries: Pandas, NumPy, Scikit-learn

• Data Visualization Tools: Plotly, Power BI, Matplotlib, Stremlit, Tableau

• Data Manipulation & Analysis: Data Cleaning, EDA, Statistical Analysis, excel, Sql

• Soft Skills: communication, Leadership

KEY ACHIEVEMENTS

• Dashboard Engagement Increase:Increased dashboard engagement by 30% over six months.

• Data Cleaning Efficiency:Saved 20% data cleaning time using optimized pipelines.

• Enhanced Forecasting Accuracy:Improved sales forecasting accuracy by 15% through advanced modeling.

• Youth Program Coordination:Coordinated 10+ events with attendance over CERTIFICATION

• Google Data Analytics: Google

• Python for Data Science: Coursera

• Design Thinking: KEF(Wesleyan Uni)

• Leadership Certificate: WOFBI

Contact this candidate