02/03/2024 updated


100 % available
Certified Professional Data Analyst
Zambia
Worldwide
BSc. Economics and Econometrics; MBADocumentation of the ProcessesA/B TestingAmplitudesData AnalysisApache HTTP ServerConfluenceJIRAMicrosoft AzureBusiness Process ImprovementBusiness ReportingSoftware as a ServiceComputer ProgrammingCustomer AnalyticsMarket SegmentationData Cleansing
A/B testing, Redshift, Azure data lake, Google BigQuery, Programming, Data Analyst, Analytics, data governance, data migration, Github, Google Data Studio, JIRA, Looker, Azure, Excel, Microsoft Excel, Power BI, Python, SQL, SQL (Programming Language), Scrum (Software Development), SaaS, software integration, Tableau, Amplitude, Confluence, MS Projects, Apache Superset, GCP, Sage ERP
Languages
EnglishNative speakerFrenchGood
Project history
100% digital bank serving global mid-affluent
Fintech * Cryptocurrency * Banking * SaaS
Tools: SQL Python Looker Redshift Amplitude BigQuery JIRA Data Studio
* Implemented a streamlined monthly KPI reporting process using Google Data Studio, integrating data from
multiple sources to provide comprehensive insights across departments.
* Developed and enacted a data governance framework for monthly reporting, reducing data collection time by
30% and eliminating errors through the use of Google Forms script.
* Conducted market research to establish segmentation criteria for the Total Available Market (TAM) by country,
enabling more targeted marketing strategies.
* Created a dynamic GTM dashboard illustrating ideal customer profiles by country, supporting informed
decision-making within the team.
* Collaborated on A/B testing initiatives to improve engagement and conversion rates by tailoring landing pages
and campaign messaging to specific customer segments.
* Co-built self-service dashboards with HR, Product, and Customer Acquisition Teams in Looker and Google
Data Studio, enhancing stakeholder communication and collaboration.
* Streamlined onboarding procedures by developing a data platform business case template and collaborating on
a Data Quality Management query template, reducing new case time by 20%.
Fintech * Cryptocurrency * Banking * SaaS
Tools: SQL Python Looker Redshift Amplitude BigQuery JIRA Data Studio
* Implemented a streamlined monthly KPI reporting process using Google Data Studio, integrating data from
multiple sources to provide comprehensive insights across departments.
* Developed and enacted a data governance framework for monthly reporting, reducing data collection time by
30% and eliminating errors through the use of Google Forms script.
* Conducted market research to establish segmentation criteria for the Total Available Market (TAM) by country,
enabling more targeted marketing strategies.
* Created a dynamic GTM dashboard illustrating ideal customer profiles by country, supporting informed
decision-making within the team.
* Collaborated on A/B testing initiatives to improve engagement and conversion rates by tailoring landing pages
and campaign messaging to specific customer segments.
* Co-built self-service dashboards with HR, Product, and Customer Acquisition Teams in Looker and Google
Data Studio, enhancing stakeholder communication and collaboration.
* Streamlined onboarding procedures by developing a data platform business case template and collaborating on
a Data Quality Management query template, reducing new case time by 20%.
Yalelo is a farm to retail FMCG
Industry: B2C * Retail * B2B * Agriculture
Tools: SQL Excel Power BI Azure Sage
* Developed a Commercial Data Catalog to streamline onboarding for new users and provide stakeholders with
clear, concise business process concepts.
* Led software integration of data across the value chain as the project manager. Collaborated with Production,
Supply Chain, Customer Service and Retail teams to map out and optimize business process and reporting. This
system resulted in a 5% monthly reduction in stock loss and over $500,000 in revenue savings each year.
* Implemented accountability measures for stock movements along the Supply Chain, which decreased
distribution losses from 2.5% to 0.5% through the use of BI reports. * Conducted analysis on commercial
reporting systems and improved processes for retail store stock/revenue reporting, route planning, and fleet
optimization.
Industry: B2C * Retail * B2B * Agriculture
Tools: SQL Excel Power BI Azure Sage
* Developed a Commercial Data Catalog to streamline onboarding for new users and provide stakeholders with
clear, concise business process concepts.
* Led software integration of data across the value chain as the project manager. Collaborated with Production,
Supply Chain, Customer Service and Retail teams to map out and optimize business process and reporting. This
system resulted in a 5% monthly reduction in stock loss and over $500,000 in revenue savings each year.
* Implemented accountability measures for stock movements along the Supply Chain, which decreased
distribution losses from 2.5% to 0.5% through the use of BI reports. * Conducted analysis on commercial
reporting systems and improved processes for retail store stock/revenue reporting, route planning, and fleet
optimization.
* Initiated and implemented data-driven processes that reduced retail stock losses from 6% to 2.5% per month, and
decreased reconciliation accounting time for FP& A Team by two days per reporting month through introducing
a cash reporting system.
* Collaborated with operational teams on data migration projects to build out an Azure data lake. * Streamlined
reporting to invoicing time, resulting in cost savings and faster billing of Accounts Receivables by migrating the
system from manual excel to ERP based fleet management.
* Led a Consumer Insights survey project which identified new channels for key accounts, resulting in gaining
repeat customers and establishing "voice of the customer."
decreased reconciliation accounting time for FP& A Team by two days per reporting month through introducing
a cash reporting system.
* Collaborated with operational teams on data migration projects to build out an Azure data lake. * Streamlined
reporting to invoicing time, resulting in cost savings and faster billing of Accounts Receivables by migrating the
system from manual excel to ERP based fleet management.
* Led a Consumer Insights survey project which identified new channels for key accounts, resulting in gaining
repeat customers and establishing "voice of the customer."




