Looking for a job

Tonny Ogeda

@tonnyogeda

Business Intelligence Analyst at Britam Insurance who automated reporting workflows and cut dashboard data requests by 80%.

Kenya

Message

At Britam Insurance, I built and maintained a real-time Power BI dashboard ecosystem that cut ad-hoc data requests by 80%. I also engineered Power Automate workflows that eliminated manual processes and reduced report turnaround from two days to under 30 minutes.

I integrated SQL Server, Azure cloud warehouses, ERP systems, and third-party APIs into a governed data pipeline, creating a trusted semantic layer and saving more than 20 hours of manual reconciliation each week.

Previously, I worked on digital media campaigns and reporting at Peak and Dale Limited, and as a Data Science Intern at Kenyatta University Referral Hospital, where I worked with healthcare datasets and REDCap across two research studies.

Experience

Work history, roles, and key accomplishments

Current

Business Intelligence Analyst

Current

Britam Insurance

Dec 2023 - Present (2 years 11 months)

Engineered AI-powered Power Automate workflows that automated data extraction, transformation, validation, and stakeholder delivery, cutting report turnaround time from 2 days to under 30 minutes. Built and maintained a real-time Power BI dashboard ecosystem with advanced DAX and Direct Query, reducing ad-hoc data requests by 80%.

Power BI DAX Power Automate SQL Server Azure ERP APIs Data Pipelines Data Governance Data Literacy

Media Buyer & Planner

Peak and Dale Limited

Feb 2023 - Dec 2023 (10 months)

Spearheaded multi-channel digital media campaigns across paid search, social, and display platforms, driving above-target ROI through A/B testing and real-time bid optimization. Engineered automated performance dashboards and client-facing reporting pipelines, cutting reporting effort by 60%.

Digital Media Paid Search Social Media Display Advertising A B Testing Bid Optimization Audience Segmentation Competitive Intelligence Performance Dashboards Reporting

Data Science Intern

Kenyatta University Referral Hospital

May 2022 - Jan 2023 (8 months)

Led end-to-end data cleaning, transformation, and validation pipelines on healthcare datasets spanning 40,000+ patient records, achieving a 99.6% accuracy rate. Translated healthcare data into 12+ visualizations and analytics reports, and managed data collection via REDCap across 2 research studies with 100% IRB compliance.