Keith Osogo

I am a qualified and skilled analyst with a track record of eliciting requirements, streamlining processes, and solving problems using data. My skills are in handling big data, cloud computing, and analytics. I also possess vast knowledge in visualization of data using software such as R, Python and Power BI to solve complex problems using data driven techniques.

Odoo Implementation and Support at AFRICA STRATEGIC COMMUNICATION HUB (2026-05 – Present)

Acted as the technical lead in Odoo implementation and customization project.

• Technical lead for extending Odoo's native capabilities; engineered inherited models and created custom modules in Python to handle unique, non-standard enterprise operations.
• Developed and deployed production-grade ETL data pipelines connecting Odoo Enterprise ERP with Microsoft Azure Data Lake and Synapse Analytics for real-time performance reporting.
• Structured relational database designs and optimized complex PostgreSQL queries within Odoo, significantly improving server response times and transaction speeds.
• Configured and customized advanced automated workflows for inventory routing (multi-warehouse configurations), procurement, and pricing matrices inside Odoo.
• Translated complex commercial pricing structures and supplier agreements (e.g., Unilever) into programmatic logic within Odoo's Sales and Purchase apps.

Technology Manager at ON DEMAND DISTRIBUTION HOUSE (2023-04 – 2026-05)

As part of the Accounting & Finance team, I work closely with sales and technology departments to interpret, streamline and visualize organizations' data to optimize operational performance.

• Developed and deployed enterprise-grade data pipelines integrating Odoo Enterprise ERP with Microsoft Azure Data Lake and Synapse Analytics, enabling real-time retail performance monitoring and reporting.
• Managing the entire commercial profit and loss statement, ensuring that topline sales growth balances perfectly with healthy gross profit margins.
• Building and maintaining Joint Business Planning (JBP) relationships with major international suppliers (e.g., Unilever, IOEC). They negotiate commercial terms, pricing matrices, and distribution agreements.
• Ensuring strict accountability for New Product Developments (NPD). They mandate that no product is launched without a risk-assessed margin plan, a solid marketing framework, and clear 90-day volume targets.
• Structuring route-to-market strategies, mapping out sales territories, and designing performance-driven incentive structures for the sales force to maximize market coverage.
• Directing and governing the trade marketing budget to ensure that advertising and promotional investments are routed toward high-ROI channels.
• Digging into the numbers to prepare weekly and monthly commercial performance reports. They track exact Gross Profit (GP) variances and SKU-level performance to identify where the business is leaking cash or losing margin.
• Building complex data models to evaluate how changes in supplier pricing or operational costs affect profitability, providing direct data support for pricing strategies and procurement negotiations.
• Translating operational goals into forward-looking financial plans, contributing heavily to cash flow forecasting, commercial budgeting, and revenue projections.

Data Analyst at ADROIT PRO CONSULTING (2023-04 – 2023-12)

• Developed and maintained analytical dashboards in Microsoft Excel and Google Sheets, using advanced formulas, pivot tables, and data visualization tools to support retail performance reporting.
• Cleaned and prepared raw sales, inventory, and customer datasets for analysis using Excel Power Query, improving data consistency and reliability.
• Created automated reporting templates in Google Sheets with dynamic charts and query-based data pulls, reducing manual reporting time by over 50%.
• Collaborated with cross-functional teams through Asana, Trello, and Zoho Projects, managing analytics tasks, tracking project timelines, and ensuring transparent workflow updates.
• Utilized Miro boards to visualize data processes, map analytical workflows, and co-design data dashboards with project teams and managers.
• Assisted in building Power BI dashboards to visualize sales trends and category performance, connecting data from Excel and cloud-based sources.
• Analyzed retail KPIs such as product turnover, sales velocity, and customer purchasing patterns to inform demand forecasting and inventory planning.
• Supported migration of spreadsheets to shared Google Workspace environments, enabling real-time collaboration and centralized data management.
• Conducted quality checks and validation on data imported from POS systems, ensuring accuracy before reporting or visualization.
• Developed performance summaries and visual reports for management presentations, highlighting key business insights and actionable recommendations.
• Documented analytical workflows and data models to support reproducibility and onboarding of new analysts.
• Participated in team planning sessions using Asana and Trello to prioritize reporting requests and ensure timely delivery of insights.
• Provided ad hoc analytical support using Excel macros and formulas for finance, marketing, and operations teams.
• Assisted in defining data governance practices by standardizing spreadsheet templates, column naming conventions, and validation rules.

ICT Technician at INTEGRATED CENTRE FOR SUSTAINABLE SYSTEMS (2022-01 – 2023-04)

Helped develop and implement policies and practices for network protocols, web applications, database management, etc.

• Web development and maintenance.
• Leveraged statistical techniques to analyze and model operational, financial, and performance data, delivering reports to meet management requests.
• Working with other departments to solve issues using information technology.
• Designed and implemented data collection systems and strategies, optimizing statistical efficiency and enhancing data quality.
• Facilitated faster and more accurate reporting, contributing to increased operational efficiency.

Attaché at NATIONAL HOSPITAL INSURANCE FUND (2022-01 – 2022-04)

• Registration of new members.
• Compliance officer in the registration department
• Office work
• Data manipulation and analysis of assigned tasks within the department.

Bachelor of Science in Applied Statistics with Computing – Moi University (2017 – 2022)

Kenya Certificate of Secondary Education – Kakamega School (2013 – 2016)