Tapiwa Mesa

Senior Data Analyst | BI Specialist | Data-Driven Strategist

Transforming raw data into actionable insights through analytics, visualization and machine learning.

View My Work Download Resume

About Me

A Data Analyst dedicated to developing business intelligence solutions that leverage best practice technologies to deliver data-driven insights. With over 5 years of experience in data analytics and reporting, statistical analysis and business intelligence.

Skills & Tools

Technical Skills

  • Data Analysis & Manipulation
  • Database Management
  • Data Visualization
  • Machine Learning
  • Cloud Computing

Tools

  • Power BI
  • Excel
  • Google Sheets
  • SQL
  • Python

Work History

Feb 2022 – Sept 2024

Data Analyst

Nestlé – Harare, Zw

  • Designed and developed a BI Report for daily sales tracking, BU targets monitoring and business analysis improving decision-making efficiency
  • Developed an Accounts Receivables Report in Power BI, integrated with SAP BW and automated via Power Automate, enabling real-time financial oversight for management
  • Led the Zimbabwe Sales Automation Project, training the Merchandising Agency and Distributors to enhance sales operations
  • Created a consolidated dashboard for Sales and Inventory using SAP Business Objects, integrating SAP BW with Microsoft Excel for improved reporting
  • Conducted market research and category share analysis, guiding strategic marketing initiatives
  • Performed value chain analysis and competitor price indexing, ensuring competitive pricing for the BU's products
  • Simulated profitable volume and product mix scenarios for monthly production and sales planning
Sep 2019 – Jan 2022

Inventory Analyst

Zuva Petroleum (formerly BP & Shell Zimbabwe) – Harare, Zw

  • Led business dynamic forecasting for monthly sales planning, inventory optimization and product loss management
  • Tracking fleet statistics and route optimization, reducing costs and improving delivery efficiency
  • Product reconciliations with all Terminals and regional LPG suppliers, ensuring accurate stock management
  • Managed inventory across three product warehouses (LPG storage, LPG accessories and Lubricants & Oils), maintaining product variances
  • Developed an Automated Operations Dashboard, streamlining planning, product allocation and resource utilization across all terminals in Zimbabwe

Featured Projects

ETL Pipeline

Stock Price prediction using LSTM on ZSE

A modified RNN that solves the vanishing gradient in LSTM using the three gates architecture.

  • Python
  • Colab
  • Data Viz
  • ML
View Project
ETL Pipeline

Zimbabwe Housing Market ETL Pipeline

Python web scraper, SQL Server storage, and Power BI visualization for housing market analysis.

  • Python
  • SQL
  • Power BI
View Project
Superstore Analysis

Global Superstore Analysis

SQL analysis of shipping costs, profit and discounts to optimize business operations.

  • SQL
  • Analytics
View Project
Housing Prediction

Housing Price Prediction App

Streamlit app for the housing price prediction, continuation of project #2.

  • Python (scikit-learn)
  • Stream-lit
View App
Fraud detection

Financial fraud detection using Machine Learning

Fraud detection using Logistic Regression, Random Forest and Gradient Boosting on a class-imbalanced dataset.

  • Python (scikit-learn)
View Project
L2 Regularization

Effectivesness of L2 Regularization on Polynomial Features in Prediction

A comparative analysis of OLS and Polynomial regression in prediction.

  • Python (scikit-learn)
View Project
Customer churn

Customer churn prediction for MTN Nigeria

A model that identifies customers who are at high risk of churning based on their historical behavior. (data source: kaggle)

  • Python (scikit-learn)
View Project
India Covid State Analysis

Indian States Covid-19 Analysis

A basic python notebook analyzing Indian States covid-19 statistics.

  • Python (pandas, maplotlib)
View Project

Get in Touch

Contact Information

  • tapiwamesah@gmail.com
  • +263 778 911 774
  • Harare, Zimbabwe