Bernard Kilonzo - Consultant

Experience

• 

  KCB Bank Group

  Dec 2014 - Jan 2016

  BANCASSURANCE OFFICER

  This was a one year contract where by my duties involved majorly growing insurance business ( a newly introduced business channel) within the branch.This included a number of assignments;1. Training branch staffs and customers on matters of insurance.2. Marketing insurance business at branch level.3. Placing all branch insurance business with the various insurance companies within the banks panel.4. Booking all claims received at branch level.5. Advising customers on various insurance policies within the branch.6. As a custodian of insurance business at branch level, one of weekly assignment was writing reports on branch business and filling insurance documents. Show less

• 

  Africanstats

  Feb 2016 - Feb 2018

  Data Analyst

  • Conducting data needs assessment for businesses.• Collecting and integrating secondary data with mainstream datasets to aid in decision making.• Maintaining data quality through data cleaning – removing duplicates, errors, outliers etc.• Identifying, analyzing, and interpreting trends or patterns in complex data sets.• Generating interactive reports and dashboards on need basis.• Designing, developing, and deploying knowledge sharing tools for modern data analysis, visualization and data gathering. Show less

• 

  Rigor Data Solutions

  Feb 2018 - now

  • Collaborate with clients to identify their analytical requirements and develop solutions that extract valuable insights.• Create compelling data visualizations that enable clients to gain valuable insights. Develop interactive dashboards and reports to facilitate data-driven decision making.• Designing, developing, and delivering enterprise-grade analytics solutions that utilize SQL server, Tableau, and other technologies. • Provide data analytics and visualization technical leadership and advisory for clients.• Create comprehensive documentation on data analytics products.• Capacity building - mentor data analysts and junior consultants (through coaching) and provide guidance on best practices and methodologies.• Build and maintain strong client relationships and uphold exceptional customer satisfaction. Show less

  • Principal Analytics Consultant

    Jul 2020 - now

  • Tableau Trainer & Consultant

    Feb 2018 - now

  • Data Visualization Lead

    Feb 2018 - now
• 

  Days for Girls International

  Jun 2019 - Jul 2020

  Data visualization volunteer

  Worked with the Days for Girls (DfG) team to map its entities globally which include over 100 enterprises that are locally owned and operated small businesses producing and selling DfG kits and providing access to menstrual health education and social change in their own communities. And over 800 chapters and teams whose efforts include advocacy and awareness rising, fundraising, hosting events, sewing, and donating DfG kits, facilitating menstrual health education.With this mapping project, partners can spot where DfG operates and quickly get in touch with a chapter or team for assistance. Show less

• 

  Evidence Action

  Aug 2019 - Sept 2019

  Data Visualization Trainer

  Conducted a two-day training on best practices for data visualizations.TRAINING SCOPE• Introduction to data visualizations• Why visualize data and importance of context• Data visualization framework and process• Data visualization concepts and practices• Choosing the right charts and graphs• Building dashboards and stories

• 

  Copia Global

  Feb 2020 - Jun 2020

  Data visualization consultant

  Services offered;1. Cleaning and redefining the Tableau platform2. Reconfiguring and updating of dashboards3. Improving visualizations of all dashboards4. Creating a master KPI table for all departments

• 

  United Nations Population Fund (UNFPA)

  Jul 2020 - Nov 2020

  Data visualization consultant

  SCOPEDevelop Emergence obstetric and newborn care (EmONC) data visualization on the functionality of life saving maternal and newborn health services in East and Southern Africa region.DELIVERABLESPrepared, cleaned, and structured existing EmONC data for analysis, including translating some of the data from French to English.Analyzed and visualized EmONC data for six countries from the East and southern Africa region on the indicators of availability of EmONC services, incidence of obstetric complications, signal function performance and reason for non-performance, infrastructure, human resource for health, equipment and supplies, governance, abortion and post abortion care, referral indicators, geographical distribution of EmONC facilities etc.Developed interactive dashboards/reports with Tableau to help UNFPA better understand life saving maternal health services including abortion/post abortion care and gender-based violence. Show less

• 

  United Nations Population Fund (UNFPA)

  May 2021 - Dec 2021

  Data visualization consultant

  SCOPEPrepare existing data set collected by UNFPA ESARO on various knowledge products, and develop dashboards, interactive digital reports, charts, and other visual representations that can help display connected information for enhancing evidence-based actions.DELIVERABLES1. Developed dashboard on impact of COVID-19 on continuity of Sexual Reproductive Maternal Neonatal Child and Adolescent Health (SRMNCAH) service.2. Developed dashboard on Sexual and Reproductive Health and Rights (SRHR) trend analysis dashboard (1994-2020).3. Developed dashboards on Emergency Obstetric and Newborn Care (EmONC) on the functionality of life saving maternal and newborn health services for Malawi and Rwanda.4. Developed dashboard on the State of the World Midwifery Report (SoWMY) 2021 regional data.5. Developed dashboard on Maternal and Perinatal Death Surveillance and Response (MPDSR) status update 2021.6. Developed dashboard on Adolescent Youth Friendly Services (AYFS) in South Africa. Show less

• 

  Social Impact

  Feb 2023 - Dec 2023

  Tableau Dashboard Consultant

  1. Hold consultation with USAID Haiti to understand their needs.2. Design and build an interactive USAID Haiti mission wide dashboard using Tableau interfacing with the mission GIS and DIS platforms.3. Design an elaborate one week’s training schedule and develop training materials.4. Conduct Tableau training, including hands-on training regarding dashboard use.5. Liaise with Third Party Monitoring (TPM) team to understand their data needs.6. Design and develop the TPM dashboard.7. Deliver comprehensive hands-on training allowing the TPM team gain competence in developing interactive dashboards with Tableau. Show less

• 

  United Nations Population Fund (UNFPA)

  Nov 2023 - Dec 2023

  Data Visualization Consultant

  Develop data visualization dashboards for Uganda EmONC Survey data collected in the year 2023. 1. Prepare existing data for analysis. 2. Apply statistical methods or data mining to discern patterns on access to EmONC services. 3. Develop dashboards (data visualizations) enabling UNFPA easily identify trends and patterns and have a better insight into the data analytics.