Odira Dancan

African Leadership University, Program Associate | Kigali, Rwanda                          January 2024 - April 2024

• Developed ALU's Student Ventures Programs application and selection criteria that allowed the university to select the most promising ventures that got funded up to $150,000;
• Designed and coordinated the Student Ventures Program and guided students through ideation, prototyping, and validation of business ideas. Sourced and collaborated with experts and mentors to support student ventures.

Entreprenarium, Business Data Analyst | Kigali, Rwanda                                          March 2023 - January 2024 

• Designed data collection pipeline to ensure a structured data architecture; Analyzed and visualized collected data using Tableau/ Google Looker; prepared reports and dashboards; presented insights and actionable recommendations;
• Developed robust project plans and ensured the country operations moved smoothly and quarterly goals were met. 

Sucafina, Data & Research Analyst | Geneva, Switzerland                                February 2023 - December 2023

• Developed databases using MySQL and MS Access to store coffee farmers for easier data access, tracking, and manipulation.
• Designed automated PowerBI dashboards for Trading and Finance teams to monitor and forecast sales, increasing efficiency by over 18%, and automated operations processes by creating simple how-to video guides to reduce human involvement costs.

Knowledge Impact Network, Data Analyst & Project Manager | Virginia, USA            May 2023 - August 2023

• Automated company operations processes using Zapier; Developed data preprocessing pipeline that facilitated easier data collection and cleaning through different data preparation methods; 
• Web Scraped data, visualized, and presented executable recommendations from the insights.

The Room & ALX, Business Data  & Research Analyst | Nairobi, Kenya                  May 2022 - December 2022

• Designed an automated attendance system using Python to collect data for in-person events, increasing efficiency by 30%.
• Prepared dashboards and reports for using PowerBI; Used SQL to extract data from Superset database, performed analysis, and presented insights and recommendations, resulting in a 25% increase in new customer acquisition. Conducted market research and segmentation, helping ALX identify a new high-value customer segment with high ROI.

African Leadership University, Data Analyst Intern | Kigali, Rwanda                     September 2021 - April 2022

• Used Looker and Python tools to prepare, clean, manipulate, visualize, and interpret data sets to find the best way the school could tackle attendance absence and provided recommendations on how to improve experiential learning.

Equity Bank (K) Limited, ELP Head Peer Mentor | Nairobi, Kenya                                  May 2020 - August 2021

• Designed Leadership and professional development programs to ensure the career and academic readiness of the mentees. 
• Used Microsoft Excel and Looker to analyze data on scholars' performance on the SAT and ACT tests to predict suitable aptitude tests 

Equity Bank (K) Limited, Relationship Officer Intern | Nairobi, Kenya                    January 2018 - August 2018

• Consistently met upsell and cross-sell goals by highlighting target merchandise with strategic promotional approaches, thereby increasing sales by 6% and serving 250+ clients daily with high accuracy, learning to handle high-stress situations.                                                

SKILLS

Proficient: Python, Javascript, Machine Learning, Advanced Excel & Google Sheets, Tableau, PowerBI, SQL, Looker, MS Office, PowerAutomate, Product Design, Business Intelligence, Google Suite, ETL, Google Analytics, Github, Market Research, Project Management, Big Data, Superset, CRM, Python  NLP, OpenCV/YOLO, Sentiment Analysis, Apache Spark, Kafka.

PROJECTS

• Wibena Impact Volunteer - Taught computer literacy in basic Microsoft Office and GSuite packages to the local community
• Notable Externships: Energy Innovation Capital, Silicon Valley - Research and Data Analytics Extern
• Other Internships:   Souk Farms - Digital Marketing and SEO Specialist,  Research and Data Analyst.

African Leadership University - BS. Computer Science (Artificial Intelligence/Machine Learning Specialization)                                          

Holberton School Software Engineering Program - Software Engineering - Backend Developer 

Udacity - Data Analyst                                                                                                                                                    

CFI -  Business Intelligence & Data Analyst (BIDA)