Collins Tandui

Data Analyst with a proven track record of leveraging predictive modelling and statistical analysis to drive business outcomes and profitability. Experienced in managing high-volume data for global brands including P&G, Mondelez International and Red bull. Expert in gathering and cleaning complex datasets from databases and spreadsheets to generate actionable insights for senior stakeholders.

Highly proficient in SQL, Python, and Power BI, with a focus on automating KPI dashboards and improving ROI through data-driven trend identification.

Data Analyst – FMCG Sales Division (Mondelez - Cadbury) at Hasbah Kenya Limited (2025-05 – Present)

• Accomplished a 90% reduction in forecast actualization time as measured by immediate availability of month-end performance data by developing an automated SQL and Power Query tool to replace manual reporting workflows.
• Influenced strategic business growth and demand planning as measured by the identification of market gaps and price elasticity trends by conducting quarterly analysis of business performance across all banners, including Carrefour, Quick Mart, and Wholesale.
• Enhanced executive decision-making for the Mondelez Market Manager as measured by reporting accuracy and speed by transitioning legacy Excel reports into interactive Power BI dashboards for easier accessibility.
• Optimized revenue forecasting and target setting as measured by alignment with periodic performance trends by maintaining and updating the demand forecast file during cross-functional meetings with demand planners and sales teams.

Data Analyst – Sales Operations (P&G, Mondelez, MBU) at Hasbah Kenya Limited (2024-12 – 2025-05)

• Achieved 100% accuracy in monthly incentive payouts for a nationwide sales force (Nairobi, Kisumu, Mombasa, Nyeri, Nakuru) as measured by compliance with payout metrics by automating performance tracking for multiple global principals.
• Improved field sales efficiency and app adoption as measured by reduced technical downtime by providing technical support and onboarding for 200+ reps using the Solutech SFA tool.
• Optimized logistics and territory coverage as measured by route completion rates by creating data-driven route plans based on channel supervisor requirements and field performance data.
• Facilitated rapid market entry for new products as measured by weekly distribution growth by designing and distributing specialized tracking reports to monitor New Product Introduction (NPI) performance.

Merchandiser (P&G) at Hasbah Kenya Limited (2024-09 – 2024-12)

• Boosted promotional impact tracking as measured by retail visibility metrics by collecting and analyzing in-store pricing data for retail dashboard development.

IT Intern at Kenya Pipeline Company (KPC) (2024-05 – 2024-08)

• Supported enterprise data security as measured by infrastructure uptime by assisting with system documentation and ICT reporting processes.

Bachelor of Science in Information Technology – KCA University (2026-07)

Kenya Certificate of Secondary Education (KCSE) – Kabarnet High School (2021)