Okoth O

Sr Data Analyst

Turing • Período integral

Jun 2024 - Dec 2025 • 1 yr 6 mos

Dorsia is a members-only platform that partners with premium restaurants to optimize inventory and enhance guest experience using data-driven decisions. Led a cancellation and rebooking analysis that identified high-risk cancellation windows within 24–48 hours of reservation time, contributing to a 12–18% improvement in same-day and next-day table refill rates after operational and policy adjustments. Built inventory performance and seat-range analytics, enabling better pricing and allocation decisions, and improving average table utilization by approximately 8–12% across priority restaurants. Reduced last-minute cancellations 10-15% by analyzing user behavior to identify habitual cancellers. Created dashboards highlighting GMV drivers and zero-GMV restaurants. Enhanced leadership visibility, sped up interventions, reducing zero-GMV restaurants by 20% month-over-month. Improved metric standardization and data validation processes, reducing reporting discrepancies and rework by approximately 25–30%, and increasing stakeholder trust in analytics outputs.

Data Scientist

Metra Vision • Período integral

May 2022 - Jun 2025 • 3 yrs 1 mo

Metravision consults on data, digital platforms, and emerging tech. Services: IT strategy, business intelligence, product/project management, UX/UI design, cloud/DevOps, and front-end development. Led data science projects leveraging cutting-edge technologies and APIs to extract actionable insights from diverse datasets. Utilized tools including Snowflakes, Power BI, dbt, BigQuery, Looker Studio, Tableau, R, Fivetran, Airbyte, and various Marketing Analytics APIs to drive data-informed decision-making. Designed and implemented an uninterrupted time series model to evaluate interventions aimed at reducing product returns. Delivered measurable impact by enabling an 8% reduction in returns, achieved through introducing targeted return fees based on model insights

Sr SQL Developer

Men of Action • Meio período

Apr 2024 - Jan 2025 • 9 mos

Men of Action is a mentorship and personal-development organization focused on optimizing client performance and engagement through datadriven insights. Monitored client performance and subscription revenue trends, ensuring accurate and timely performance tracking. Built and optimized complex PostgreSQL queries to extract and transform client data for analytics and reporting. Developed and deployed Grafana dashboards to visualize client metrics and provide real-time insights to management. Designed and implemented an RFM-based membership cohorting model using SQL to segment clients by engagement and value. Enabled a 20% improvement in Annual Recurring Revenue (ARR) by empowering the marketing team to execute more targeted campaigns based on customer activity patterns.