Senior Business
Data Analyst
Backend Software Engineer
5+ Years of Experience.
About Me
A highly analytical and detail oriented Senior Business Data Analyst. Experienced in analyzing extremely complex data sets, developing data models, and creating data visualizations. Skilled in using SQL, Python, Excel, Tableau and Microsoft Power BI to extract insights from data, improve business processes, and support decision-making. Adept at collaborating with stakeholders and presenting findings to non technical audiences.
Skill Bars
EXPERIENCE
Data Analyst, BSA | Systems and Analytics | Research, Assessment and Monitoring Unit
JULY 2023-UNITED NATIONS WFP | UGANDA
1. Supported in the building and implementation of data collection tools (AMS, S04, Social Protection, S05, SO6) to standardize data collection across UN WFP Uganda Country Office.
2. Supported in the establishment and maintainance of data quality protocols to ensure data met UN
WFP's privacy and protection guidelines.
3. Utilized data cleaning techniques (Excel, SQL, Python) to refine critical datasets from Arua, Karamoja and South West Area Offices. Delivered clean, reliable data for analysis.
4. Leveraged data analysis skills to support the supervision of UN Missions in hard-to-reach districts
(Moroto, Abim, Kaabong, Kotido) during data collection.
5. Assisted the Monitoring and Evaluation team in automating data monitoring workflows, improving efficiency and data accessibility.
Business Data Analyst Consultant
2nd Feb 2020 - 1st July 2023EMBAKASI RANCHING COMPANY | KENYA
1. Reduced data ingestion and processing time for datasets exceeding 10 million records by 85% using SQL optimization techniques.
2. Collaborated with the Embakasi Ranching Company's data team to understand their business needs and translate them into actionable Power BI reports.
3. Enabled the data team to generate customer insights 20% faster through data cleaning, transformation, and preparation using Python, SQL, Excel, and Power BI.
4. Identified and rectified outdated information collection processes, leading to a 15% improvement in data accuracy for the Embakasi Ranching Company's database.
Business Data Analyst Consultant
1st April 2022 - 15th Feb 2023AIDKONEKT DATA | COLORADO | USA
1. Leveraged SQL, Python, and Excel to analyze large, complex public USAID datasets, extracting valuable insights and identifying key trends.
2. Built data-driven reports and dashboards rich with forecasts and KPIs, empowering management to make informed decisions.
3. Developed robust data models and performed thorough data profiling to guarantee data quality and data integrity.
4. Collaborated effectively with cross-functional teams to optimize business processes and pinpoint opportunities for data-driven decision-making.
5. Enforced project management skills to see that the initiated data projects met the assigned deliverables.
6. Enabled the data team to generate customer insights 20% faster through data cleaning, transformation, and preparation using Python, SQL, Excel, and Power BI.
7. Assesed, identified and rectified outdated information collection processes, leading to a 15% improvement in data accuracy for the AIDKONEKT DATA's database.
Volunteer
Nov 2016 - Mar 2020YALI NETWORK | KENYA
1. Led the organization of 3 events focused on Gender-Based Violence and Human Rights, contributing to a more informed community and raising awareness in Uganda. These events Increased human rights and gender-based violence awarenness by 68%, sparked conversations reaching 820 people.
2. Empowered women in Rakai District by providing technical skills in computer studies through a collaborative summit organized with VEROWGDEC.org. These skills included data coding, web development, business management and project management basics.
3. Leveraging knowledge gained from the YALI Network entrepreneurship course, spearheaded fundraising efforts that secured UGX 25 million in donations for the Ddembelyabato Primary School project under VEROWGDEC.org. This impactful initiative resulted in:
a. Installation of solar power for improved learning conditions.
b. Enhanced security with installation of metallic doors.
c. Improved learning environment with glass windows in classrooms.
d. Upgraded dormitories for orphaned children.
e. Improved sanitation through renovated pit latrines.
f. Access to clean water with a new tap, eliminating the need for children to walk long distances.
TRAINEE
Jun 2017 - Aug 2017C-CARE HOSPITAL | UGANDA
1. Concentrated on Networking, Databases, Hardware Repair, Systems Administration and ERP so that the medical personnel could have stable and running systems
LCVP BUSINESS DEVELOPMENT
Sep 2016 - May 2017AIESEC
1. Identified and secured partnerships with 56 Training Network (TN) organizations, generating an estimated $20,000 USD in additional revenue/resources for AIESEC activities.
2. Developed and delivered training programs for staff, resulting in a 60% increase in project management skills. Mentored junior staff, fostering their growth and knowledge.
3. Led the development and execution of a strategic outreach plan, resulting in 56 new partnerships established with key stakeholders.
EDUCATION & PUBLICATIONS
a) UNIVERSITY EDUCATION
Msc in Data Science
Nov 2022 - Nov 2024
Manipal Academy for Higher Education, India
Bsc I.T
Sept 2015 - Dec 2020
Uganda Christian University Mukono
Elements of A.I
2020 - 2020
University of Helsinki, Finland
b) DATA ANALYTICAL BADGES
c) DATA SCIENCE CERTIFICATIONS
Business Analyst Career Track
Advanced Microsoft Excel : Pivot Tables, V Look Up, H Look Up, Index Match, Circular References, Visuals...
Data Analysis : Excel Pivot Tables
Python Programmer Bootcamp : Loops, Functions, Classes, Unit Tests...
Microsoft Power BI : DAX, Power Query, Visuals, Power BI Service & Desktop
SQL : Joins, Aggregate Functions, Views, Constraints...
Generative A.I : Artificial Intelligence, Generative A.I tools
d) PUBLICATIONS
VIOLENCE AGAINST WOMEN
The UN describes violence against women and girls (VAWG) as: “one of the most widespread, persistent, and devastating human rights violations in our world today. It remains largely unreported due to the impunity, silence, stigma, and shame surrounding it.”