Dancan Odira Email & Phone Number

Rwanda

Kigali City, Rwanda

Kigali, Kigali City, Rwanda

Designed data collection pipeline to ensure a structured data architecture; Analyzed, and visualized collected data using Tableau, prepared reports and dashboards, and presented insights and actionable recommendations.

Geneva, Switzerland

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%; Automated operations processes by creating simple how-to video guides to reduce human involvement costs.

Orlean, Virginia, United States

Built project management system using airtable to reduce manual work allocation and facilitate easier task tracking.Created automations using Zapier for a streamlined data collections pipeline and ease of operation: less work.Performed data extraction, cleaning, and visualization and presented actionable recommendations insights to the CEO and the board enabling the company to acquire 14 new high-value clients.Developed comprehensive project plans, including defining project objectives, deliverables, timelines, resource allocation, and risk management strategies.

Nairobi, Kenya

- Designed and implemented an automated attendance system for in-person fellows registration.- Designed and automated mass calendar booking system and data collection system for marketing activities.- Designed and maintained dashboards from different data pipelines.- Analyzed data and provided insights for the marketing department that resulted in a 25% increase in new customer acquisition.

Rwanda

- Used R and Python tools to prepare, clean, manipulate, visualize, and interpret data sets, paying particular attention to trends and patterns that could be valuable for diagnostic and predictive analytics efforts to find the best way the school could tackle attendance absence.- Used SQL to manage, manipulate, and query databases and drew ERD diagrams to create relationships.

Remote

- Developed land pages for clients on freelancer.com and Upwork.

Nairobi, Kenya

- Designed and facilitated Leadership and professional development programs with my co-mentors to ensure the career and academic readiness of the mentees who will secure admissions and scholarships abroad.- Used Microsoft Excel to analyze data scholars' performance on the SAT and ACT test to predict suitable aptitude tests - Mentored and guided Equity Leadership Programs(ELP) scholars to get admission into top global universities.

Nairobi, Kenya

- Served 250+ clients daily with high accuracy and handled complaints, developing and strengthening customer relationships by leveraging interpersonal and communication skills, thereby learning to remain poised and professional even in high duress situations and when dealing with irate individuals.- Consistently met upsell and cross-sell goals by highlighting target merchandise with strategic promotional approaches, thereby increasing sales by 6%.

Bachelor'S Degree, Computer Science

Bachelor'S Degree, Computer Science

Activities and Societies: Entrepreneurial Ventures; Co-founder of Student Safaris Travel AgencyMaking fun of Data and AI models.