Odira Dancan

Odira Dancan

Data Analyst
Rwanda

About Me

Data professional with experience in data analysis, business intelligence, research, and project coordination across education, banking, and operations environments. Skilled in Python, SQL, Tableau, Power BI, Looker, Exc…

Experience

Program Associate

African Leadership University
Jan 2024 - Present · 2 years 6 months

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.

Program Associate

African Leadership University, Kigali, Rwanda
Jan 2024 - Apr 2024 · 3 months

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.
Guided students through ideation, prototyping, and validation of business ideas.
Sourced and collaborated with experts and mentors to support student ventures.

Business Data Analyst

Entreprenarium, Kigali, Rwanda
Mar 2023 - Jan 2024 · 10 months

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

Data & Research Analyst

Sucafina, Geneva, Switzerland
Feb 2023 - Dec 2023 · 10 months

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.
Increased efficiency by over 18%.
Automated operations processes by creating simple how-to video guides.
Reduced human involvement costs.

Data Analyst & Project Management Consultant

Knowledge Impact Network, Virginia, USA
May 2023 - Aug 2023 · 3 months

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 data.
Presented executable recommendations from the insights.

Business Data & Research Analyst

The Room & ALX, Nairobi, Kenya
May 2022 - Dec 2022 · 7 months

Designed an automated attendance system using Python to collect data for in-person events.
Increased efficiency by 30%.
Prepared dashboards and reports using PowerBI.
Used SQL to extract data from Superset database.
Performed analysis.
Presented insights and recommendations.
Resulted in a 25% increase in new customer acquisition.
Conducted market research and segmentation.
Helped ALX identify a new high-value customer segment with high ROI.

Data Analyst Intern

African Leadership University, Kigali, Rwanda
Sep 2021 - Apr 2022 · 7 months

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

ELP Head Peer Mentor

Equity Bank (K) Limited, Nairobi, Kenya
May 2020 - Aug 2021 · 1 year 3 months

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.
Predicted suitable aptitude tests.

Relationship Officer Intern

Equity Bank (K) Limited, Nairobi, Kenya
Jan 2018 - Aug 2018 · 7 months

Consistently met upsell and cross-sell goals by highlighting target merchandise with strategic promotional approaches.
Increased sales by 6%.
Served 250+ clients daily with high accuracy.
Learned to handle high-stress situations.

Skills

Conflict Resolution Strategies Constant Contact Google Suite Microsoft PowerPoint Microsoft Word Public Speaking Salesforce Leadership Quality Administrative Experience Asset Oversight Office Experience Python JavaScript Machine Learning Advanced Excel Google Sheets Tableau Power BI SQL Looker MS Office Power Automate Product Design Business Intelligence ETL Google Analytics GitHub Market Research Project Management Big Data Superset CRM Python NLP OpenCV YOLO Sentiment Analysis Apache Spark Kafka MySQL MS Access Zapier
Report this Profile?