COLLINS ONDIEK

• Gather, clean, and validate large-scale datasets to ensure accuracy and data integrity.
• Conduct exploratory data analysis (EDA) to identify trends, anomalies, performance bottlenecks, and failure patterns.
• Apply Python analytics tools (Pandas, NumPy, Scikit-learn, Matplotlib) for statistical analysis and insight generation.
• Extract, structure, and manage data efficiently using SQL.
• Develop automated reports and interactive dashboards using Power BI and Google Sheets.
• Translate analytical findings into actionable, data-driven recommendations for projects and stakeholders.
• Design data structures and data quality assessment processes to support AI/ML model evaluation environments.
• Collaborate with developers to diagnose technical issues, and improve system reliability.
• Detect data inconsistencies, and optimize workflows to enhance operational efficiency.
• Structure and integrate program data into the SUN Welfare System.
• Train teams on the effective use of the welfare system and data tools.
• Monitor and analyze key impact metrics, including member retention, and project outcomes.
• Create data pipelines aligned with project objectives to ensure timely, accurate, and reliable data availability.

Community Engagement and Leadership (Additional Responsibilities):

• Supports community outreach and engagement activities within informal settlements in Kenya.
• Assists in mobilizing community members for youth, education, health, and social development initiatives.
• Acts as a liaison between community members and program teams to enhance participation and inclusion.
• Contributes to mentorship and leadership activities for youth and community groups.

• Managed end-to-end accounts payable and receivable processes, including invoicing, billing, collections, and reconciliations.
• Prepared and filed statutory tax returns and deductions in compliance with regulatory requirements.
• Processed vendor payments and staff reimbursements, ensuring accuracy and timely approvals.
• Resolved billing and payment discrepancies with clients and suppliers.
• Supported month-end closing, reporting, and audit processes through accurate financial documentation.

• Managed inventory control processes to ensure optimal stock levels, accurate tracking, and minimal variances.
• Conducted pricing and menu analysis to support profitability and cost recovery objectives.
• Implemented cost control measures to monitor food and beverage expenses and improve margin performance.
• Reduced waste through monitoring consumption patterns, enforcing portion controls, and improving stock handling practices.

• Updated account opening forms and client records in the new system.
• Prepared and organized archival materials for easy retrieval.
• Performed data cleansing to ensure accuracy and consistency.
• Received, recorded, and tracked files to maintain proper documentation.