Ayak

Data Analyst and Business Intelligence professional with progressive experience transforming complex operational and financial datasets into actionable insights that drive measurable impact. I specialize in data modeling, ETL pipeline optimization, KPI dashboard development, and cloud-based analytics across GCP and Azure environments. Using SQL, Python, Power BI, Tableau, and Snowflake, I have improved resource allocation by 20%, increased decision-making efficiency by 30%, and reduced reporting errors by 40%.

With expertise in data governance, workflow automation, and performance analytics, I bridge technical execution and strategic planning to deliver scalable, data-driven solutions in distributed, fast-paced environments.

Data Analyst at Social Enterprise Organization Ltd (2017-01 – Present)

• Conducted exploratory and trend analysis on operational and impact datasets, identifying performance gaps that improved resource allocation efficiency by 20% across social programs.
• Designed and deployed interactive Power BI and Excel dashboards tracking KPIs, variance trends, and performance metrics, enabling leadership to improve data-driven decision-making speed by 30%.
• Performed cohort and retention analysis on community engagement initiatives, uncovering behavioral insights that increased participant retention rates by 25%.
• Automated and standardized data collection workflows using structured validation rules and reporting templates, reducing manual errors by 40% and increasing reporting accuracy for stakeholders and funders.
• Executed financial performance and ROI analysis on fundraising campaigns, translating insights into actionable recommendations that contributed to a 15% increase in donor revenue.

National Coordinator at MasterPeace South Sudan (2015-03 – 2016-12)

• Conducted exploratory and trend analysis on operational and impact datasets, identifying performance gaps that improved resource allocation efficiency by 20% across social programs.
• Designed and deployed interactive Power BI and Excel dashboards tracking KPIs, variance trends, and performance metrics, enabling leadership to improve data-driven decision-making speed by 30%.
• Performed cohort and retention analysis on community engagement initiatives, uncovering behavioral insights that increased participant retention rates by 25%.
• Automated and standardized data collection workflows using structured validation rules and reporting templates, reducing manual errors by 40% and increasing reporting accuracy for stakeholders and funders.
• Executed financial performance and ROI analysis on fundraising campaigns, translating insights into actionable recommendations that contributed to a 15% increase in donor revenue.

Business Analyst at South Theatre Academy (2012-01 – 2015-02)

• Conducted historical trend and variance analysis on event and stakeholder datasets, identifying attendance drivers and optimizing coordination strategies that increased participation rates by 20%.
• Performed donor segmentation and revenue performance analysis, uncovering high-value funding patterns that improved campaign conversion rates and increased funds raised by 30%.
• Designed and deployed interactive Excel and Power BI dashboards to monitor partnership pipelines and engagement KPIs, enabling data-driven decisions that expanded strategic partnerships by 25%.
• Analyzed proposal performance metrics and approval trends, identifying success factors and process gaps that improved funding approval rates by 15%.
• Streamlined cross-regional reporting workflows through standardized data visualization and structured communication dashboards, reducing response times by 35% and improving reporting accuracy across multiple states.

Bachelor of Business in Information Technology – Strathmore University

Master of Arts in International Relations – University of Westminster

Bachelor of Arts in International Relations – United States International University-Africa