Open to opportunities

John Kirwa User

@johnkirwauser

Message

Senior actuarial analyst specializing in insurance pricing, risk placement, and data-driven business strategy.

Kenya

Message

What I'm looking for

I seek roles combining insurance pricing, data analytics, and strategic business impact—collaborative teams, modelling/product design responsibility, and clear growth opportunities.

I am a results-driven actuarial professional with 5+ years’ experience in insurance pricing, financial modelling, and data-driven business analysis. I design and price agricultural insurance products, supported automation used in multi-million-dollar products for smallholder farmers, and improved reporting and decision TATs by 30% through Power BI and Smart App automation.

I work cross-functionally with commercial, field, and tech teams, manage and mentor actuarial analysts, and translate analytics into strategic insights for senior stakeholders. I am advancing through actuarial exams and pursuing an MBA in Finance & Strategic Management to deepen my impact at the nexus of data, insurance, and business strategy.

Experience

Work history, roles, and key accomplishments

Current

Senior Actuarial Analyst

Current

Pula Advisors

Oct 2022 - Present (2 years 10 months)

Led pricing, actuarial modelling and risk placement for agricultural insurance across Africa and Asia, supporting automation for multi-million-dollar products and improving reporting and decision TATs by 30%. Managed a team of actuarial analysts and liaised with insurers and reinsurers to secure product adoption.

Pricing Advanced Excel Power BI R

Sales Operations Analyst

SC Johnson

Feb 2021 - Sep 2022 (1 year 7 months)

Provided analytical and financial insight to sales and category teams, building executive dashboards and financial models to support contract negotiations and optimize territory coverage. Delivered SKU-level sell-in/sell-out analysis to reduce stockouts and inform shipment strategies.

Sales Operations Financial Modelling Excel Power BI Territory Planning

Sales Operations Analyst

SC Johnson Kenya

Feb 2021 - Sep 2022 (1 year 7 months)

Provided analytical and financial insight to sales and category teams, built executive dashboards and demand-forecast models that informed pricing, promotions and shipment strategies to reduce stockouts.

Sales Analytics Forecasting Advanced Excel Dashboarding Financial Modelling Stakeholder Management

Data Analyst – Sales & Merchandising

Smollan Kenya Ltd

May 2020 - Jan 2021 (8 months)

Designed and automated performance dashboards for retail execution KPIs and delivered weekly/monthly business reviews, improving outlet-level deployment and field team impact. Conducted territory and on-shelf availability analysis to inform tactical field responses.

Data Analysis Dashboarding Power BI Excel Retail Execution Performance Tracking

Data Analyst - Sales & Merchandising

Smollan Kenya

May 2020 - Jan 2021 (8 months)

Designed and automated performance-tracking dashboards for retail KPIs, improving field force impact and delivering weekly/monthly business reviews and actionable insights to client stakeholders.

Dashboard Automation KPIs Excel Competitor Analysis Reporting

Graduate Trainee - Data & Operations

Smollan Kenya

May 2019 - Jan 2020 (8 months)

Developed MIS reporting and Excel-based dashboards, automated routine sales reports to reduce reporting time by 30% and supported sales trend analysis and client-ready performance reviews.

Excel Dashboard Data Automation Sales Analysis Report Automation

Graduate Trainee – Data & Operations

Smollan Kenya Ltd

May 2019 - Jan 2020 (8 months)

Compiled and presented daily sales and merchandising reports and built Excel-based dashboards to support client reviews. Automated routine sales reports, reducing reporting time by 30% and improving data reliability.

Excel Dashboarding Report Automation Sales Analysis