Alex

Senior Data Analyst

Coca-Cola South Africa • Tiempo completo

Jun 2024 - Present • 2 yrs 1 mo

Lead analyst on the Coca-Cola Beverages Africa (CCBA Kenya) commercial analytics programme — delivering weekly sales, operations and marketing dashboards used to calculate sales team incentives and market execution performance across the country. Built end-to-end financial reporting in Power BI including P&L, Balance Sheet, and Cash Flow vs Budget. Extracted and modelled data from Sage X3, Sage 200 Evolution, and Salesforce. Delivered executive-ready dashboards and led full project lifecycle from requirements through client handover.

Data Architect / Modeler

Meier - Online Marketing & Consulting • Tiempo completo

Jun 2022 - Feb 2023 • 8 mos

Worked remotely on retail analytics data architecture for Meijer, a large US-based retailer. Designed conceptual, logical and physical data models and maintained mapping logic between source systems and the enterprise data model. Built ETL technical mapping documents, transformation and cleansing rules, and data source discovery documentation for data engineers. Extracted and profiled data from Oracle, SQL Server, and Teradata. Contributed to an end-to-end Lakehouse Architecture pilot. Tools: Microsoft Fabric, Azure Data Factory, Databricks, SQL Server, ER Studio, PowerDesigner, DBeaver.

Logistics Engineer — Data & Analytics

Synergy • Tiempo completo

Jan 2021 - Jul 2022 • 1 yr 6 mos

Built Power BI and Excel dashboards to monitor logistics operations and programme KPIs. Developed SQL queries and forecasting models for demand planning and resource optimisation. Conducted root-cause analysis on operational inefficiencies contributing to cost reduction. Automated recurring reports, reducing manual effort and turnaround time significantly.