David Kapindula

About

With a Bachelor of Science in Actuarial Science from the University of Lusaka, I have developed a strong foundation in data analysis and business intelligence. My professional journey began as a Graduate Trainee at Advantage Insurance Zambia, where I honed my skills in statistical analysis and financial data management. I contributed to the IFRS17 implementation team and gained proficiency in Python and Excel for data extraction and analysis. Currently, I am a Data & Analytics Associate at Yalelo Zambia, where I lead projects to enhance business workflow efficiencies using Power BI, VBA, Excel, and SQL. I am responsible for visualizing key performance indicators and conducting stock and sales data analysis to guide strategic business decisions. Additionally, I conduct training sessions for staff on business reporting tools and prepare monthly business review documents, playing a pivotal role in implementing new processes within the Data & Analytics team.

Experience

• Data & Analytics Associate · Yalelo Zambia10-01-2023

  •Project Lead: Drove workflow improvements for efficiency and transparency using Power BI, VBA, and Excel. •Data Cleaning & ETL: Cleaned datasets and developed Python ETL pipelines to ensure reliable data for dashboards. •Automation: Automated tasks with Python & PowerShell, cutting processing time and improving accuracy. •KPI Dashboards: Built Power BI dashboards for real-time tracking of critical KPIs, enabling data-driven decisions. •Sales & Stock Analysis: Analyzed stock and sales data, delivering insights that informed strategic business decisions. •Staff Training: Trained Yalelo store staff on reporting tools, boosting data literacy across teams. •Business Review Prep: Created monthly review documents, summarizing key trends and actionable insights. •Process Improvement: Implemented new processes within the Data & Analytics team to enhance data handling and reporting. •Data Quality Assurance: Improved data accuracy with validation checks in ETL workflows. •Cross-Functional Collaboration: Partnered with Sales, Operations, and Finance to align on data needs and integrate insights. •Documentation: Documented processes to support training, continuity, and troubleshooting.

• Graduate Trainee · Advantage Insurance Zambia11-01-2022 – 10-01-2023

  •IFRS17 Data Validation: Contributed to the IFRS17 implementation team by rigorously validating critical data sets, ensuring compliance with new financial reporting standards. •Motor Insurance Analysis: Conducted statistical analysis on the motor insurance portfolio, providing insights to refine risk assessment and pricing. •Reinsurance Coordination: Liaised with reinsurers on specialized agreements outside the treaty, ensuring clear alignment on terms. •Treaty Statistics Preparation: Compiled and analyzed treaty statistics for reinsurers, providing accurate data for risk-sharing arrangements. •Claims Data Analysis: Performed claims data tracking to identify distribution trends over the company’s lifetime, aiding in underwriting and reserve management. •Financial Document Analysis for Reinsurers: Analyzed essential financial documents, such as the Unearned Premium Report and Bordereaux, providing reinsurers with accurate data for assessment and underwriting purposes. •Employee Loan Schedules: Constructed accurate loan schedules for employees, supporting financial needs and ensuring correct repayment tracking. •Insurance Underwriting (Motor & Aviation): Underwrote motor and aviation policies, assessing risk and setting terms aligned with company standards.

Education

• University of LusakaBachelor of Science - BS, Actuarial Science
• Matero Boys Secondary SchoolGrade 12 Certificate

Similar talent on Pangea

Judith V.Data Analyst | Business Intelligence Strategist | Driving Growth with Data-Driven Decisions | Power BI | SQL | Python | Empowering African Businesses with InsightsNairobi, KenyaSrijan D.Business Analyst | Data-Driven StrategistBengaluru, KarnatakaGaniu A.Business Intelligence and Data Analyst | Helping Business Leaders and Data Teams Unlock Insights with Automated Data Transformation, Visualization using Power Query, Power BI, Sisense, Python, and SQL | PL-300 CertifiedCarla K.BI/Data AnalystPort Shepstone, South Africa