Overview
Work History
Education
Skills
Websites
Timeline
Generic

EDWARD ODHIAMBO

Nairobi,Nairobi, Kenya

Overview

4
4
years of professional experience

Work History

Sales Automation Analyst

Reckitt
09.2024 - Current
  • Developed and maintained automated Power BI dashboards, integrating sales and operational data from multiple ERP systems, reducing manual reporting by 80% and enhancing data-driven decision-making
  • Extracted, transformed, and analyzed large datasets to generate KPI reports, sales performance analysis, and market trend insights, supporting strategic business decisions
  • Managed and optimized data pipelines, performing data validation, cleaning, and transformation to ensure accuracy in SKU master data, customer data, and pricing structures
  • Conducted predictive and statistical analysis, identifying key sales trends and forecasting business performance using SQL, Python, and Excel
  • Collaborated with cross-functional teams to provide actionable insights, automate reporting workflows, and enhance business intelligence capabilities, leading to a 20% improvement in tool adoption and efficiency

Data Analyst

PZ Cussons
11.2023 - 08.2024
  • Managed end-to-end data integration by onboarding, training, and supporting sales teams in Solutech SFA, ensuring accurate data collection and KPI tracking through well-maintained master data
  • Administered and optimized databases, ensuring data integrity, security, and schema adjustments for enhanced system performance and scalability
  • Extracted, transformed, and analyzed large datasets, querying sellout data from databases, performing in-depth analysis, and delivering insightful reports and recommendations to stakeholders
  • Developed and maintained automated KPI dashboards using Power BI and PostgreSQL, tracking sales performance, HR metrics, system utilization, brand availability, and on-shelf availability
  • Led first-line technical support and troubleshooting for the PZ Cussons Sales Team, ensuring seamless system utilization and compliance across distributors and agencies

Data Analyst - Fuel

Egypro East Africa LTD
01.2021 - 02.2023
  • Data Analysis: Collect, clean, and analyze fueling data to optimize operations and reduce costs by 30%.
  • Incident Tracking: Record and analyze fueling incidents to identify trends and prevent future disruptions
  • Stakeholder Collaboration: Work with procurement, operations, and finance teams to align fueling strategies with business goals
  • Risk & Predictive Analytics: Identify supply chain risks and use data insights to develop contingency plans
  • Supply Chain Optimization: Monitor fuel movement and improve efficiency by 65% using data-driven decision-making.
  • Compliance Monitoring: Ensure regulatory compliance through data tracking and reporting

Education

BSc - Statistics and Programming

Kenyatta University
Nairobi, Kenya
12.2021

Certificate - Leadership Studies

Kenyatta University
Nairobi, Kenya
12.2018

Skills

  • SQL
  • Power BI
  • Excel
  • Python
  • Schema Optimization
  • SFA and ERP Automation
  • Cross-functional Insights
  • SFA and ERP System support
  • User acceptance testing
  • Business process analysis

Timeline

Sales Automation Analyst

Reckitt
09.2024 - Current

Data Analyst

PZ Cussons
11.2023 - 08.2024

Data Analyst - Fuel

Egypro East Africa LTD
01.2021 - 02.2023

BSc - Statistics and Programming

Kenyatta University

Certificate - Leadership Studies

Kenyatta University

Similar Profiles

CREATE PROFILE
EDWARD ODHIAMBO