Skip to content

Open to software & BI roles

Jonas Kankam

Software Developer & Business Intelligence Analyst

4+ years building enterprise software in Laravel and the data warehouses, ETL pipelines and Power BI dashboards that turn it into decisions, across insurance, telecom and financial services.

View WorkDownload CVGet in Touch
Accra, Ghana
Isometric illustration of an application stack: API node, server rack, services and database cluster

01About

From First Class Computer Engineering to enterprise systems and data.

My path started at Kwame Nkrumah University of Science and Technology, where I graduated with First Class Honors in Computer Engineering. While still finishing my degree, I was writing PHP business applications at Emmarianto Limited, helping teams keep operating remotely through COVID-19.

As a Business Intelligence Analyst at AirtelTigo Ghana I went deep on data: building OLAP cubes and dimensional models in the enterprise data warehouse, tuning SQL on mission-critical BI queries, automating Python ETL, and forecasting footfall across 200+ retail outlets for the executives who allocate resources.

Most recently, at Phrontlyne Technologies (2022 to 2026), I brought both halves together for the CDH Holdings group: Laravel platforms for insurance, health and investments, the APIs that connect them, and the KPI portals, retention analytics and ERP-to-BI pipelines that leadership ran the business on. I care about audit-compliant workflows, fast queries and data you can trust.

Education · 2021

B.Sc. Computer Engineering

Kwame Nkrumah University of Science and Technology (KNUST)

First Class Honors

Notable achievements

  • Led end-to-end development of an enterprise insurance system with integrated financial reporting and dimensional data models, now deployed across multiple client organizations.
  • Delivered a 40% query performance improvement at AirtelTigo through SQL optimization, execution plan analysis and index tuning.
  • Built forecasting models for customer footfall across 200+ retail outlets, translating data mining into staffing decisions.
  • Designed real-time Power BI and SSRS reporting assets giving leadership governed financial and operational insight.
  • Implemented audit-compliant data governance frameworks, including access controls and reconciliation checks, across enterprise systems.

02Core competencies

Two disciplines: shipping software and making data useful.

Deepest in Laravel and relational databases on the engineering side, and in data warehousing, SQL and Power BI on the BI side. Most of my work sits where the two meet.

Laravel & PHP

Backend architecture, the full Laravel ecosystem and API design.

  • Laravel
  • Eloquent ORM
  • Artisan CLI
  • Queues
  • Events
  • Middleware
  • Blade
  • PHP 8+
  • RESTful API Design
  • Sanctum / Passport
  • MVC Architecture
  • Composer
  • PHPUnit

Database Systems

Designing, tuning and administering production relational databases.

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server
  • Oracle
  • Schema Design
  • Database Administration
  • Backup & Recovery
  • Migrations

Frontend

Responsive interfaces that sit cleanly on top of solid APIs.

  • React
  • JavaScript
  • TypeScript
  • HTML5
  • CSS3
  • Tailwind CSS
  • Axios

DevOps & Tools

Version control, environments and delivery pipelines.

  • Git / GitHub
  • Linux
  • Docker (basic)
  • CI/CD pipelines

Languages & Scripting

Automation and tooling beyond PHP.

  • Python
  • Go
  • PowerShell
  • Bash
  • JavaScript / TypeScript

03Experience

Production software in insurance, telecom and financial services.

Programmer Analyst

Phrontlyne TechnologiesAccra, Ghana2022 — 2026

Subsidiary of CDH Holdings, supporting Phoenix General Insurance, Phoenix Health Insurance, CDH Securities and Gilead Medical Center.

30%

fewer data discrepancies

  • Built and maintained enterprise insurance and accounting software in Laravel/PHP, with role-based access control, audit-ready database architecture and dimensional data models for financial reporting.
  • Built risk assessment and pricing modules for Phoenix General Insurance, enabling NIC-compliant, risk-tailored premium pricing across motor, bond and marine lines.
  • Designed RESTful APIs for internal and external clients using resource controllers, form requests and Sanctum/Passport authentication.
  • Designed revenue and KPI reporting portals tracking premium collections (YTD, MTD, day-over-day and period-over-period), giving executives real-time visibility into commercial performance.
  • Developed customer retention analytics that model renewal behavior and identify dormant policyholders for targeted re-engagement.
  • Built investment recommendation and portfolio-tracking modules for CDH Securities, including self-service portfolio, maturity and roll-over tracking and cross-sell of Phoenix insurance products.
  • Built ERP-to-BI integration pipelines in PHP and Python powering real-time Power BI dashboards, with data quality checks and reconciliation controls that reduced data discrepancies by 30%.
  • Engineered data migration scripts and ETL workflows moving legacy insurance data into the new applications, with schema mapping and validation for a reconciled cutover and zero data loss.
  • Applied AI-assisted techniques to query drafting, anomaly identification and trend summaries, cutting turnaround on ad hoc stakeholder requests.
  • Laravel
  • PHP 8
  • Sanctum
  • MySQL
  • PostgreSQL
  • Python
  • Power BI
  • SSRS

04Systems built

Enterprise software running real businesses.

Most of this work lives inside client infrastructure, so the code is private. Happy to walk through architecture and decisions in an interview.

Production · Multi-tenant

Enterprise Insurance Platform

Led end-to-end development of a Laravel insurance platform covering the full policy lifecycle (quotation, underwriting, payment, renewal), with NIC-compliant risk pricing, integrated financial reporting and audit-compliant accounting workflows.

Deployed across multiple client organizations

  • Laravel
  • PHP 8
  • MySQL
  • RBAC
  • Dimensional Models
Data Engineering

ERP-to-BI Integration Pipelines

PHP and Python pipelines that move ERP data into a governed BI layer, with data quality checks and reconciliation controls, feeding real-time Power BI financial dashboards for executives.

30% fewer data discrepancies

  • PHP
  • Python
  • PostgreSQL
  • Power BI
BI · Executive Reporting

Revenue & KPI Reporting Portal

Reporting portals tracking premium collections YTD, MTD, day-over-day and period-over-period, giving executive stakeholders real-time visibility into commercial performance.

Real-time commercial visibility for leadership

  • SQL
  • Power BI
  • SSRS
  • Laravel
Data Warehousing

Telecom Data Warehouse & OLAP Cubes

OLAP cubes and dimensional models in AirtelTigo's enterprise data warehouse, structuring large-scale telecom data for fast multidimensional analysis, backed by heavily tuned SQL.

40% faster mission-critical BI queries

  • SQL Server
  • SSAS
  • Star Schema
  • Tableau
Predictive Analytics

Retail Footfall Forecasting

Statistical and machine-learning models forecasting customer footfall and usage behavior across AirtelTigo's retail network, fed by automated Python ETL.

200+ outlets informing staffing decisions

  • Python
  • SQL
  • Forecasting
  • Power BI
Insurance Analytics

Customer Retention Analytics

Analytics modeling policy renewal behavior and surfacing dormant policyholders, giving teams data-driven targets for re-engagement.

Proactive renewal and re-engagement insight

  • SQL
  • Python
  • Power BI
Healthcare · Full-Stack

EMR System — Gilead Medical Center

An electronic medical records system managing patient records and clinical history, with role-scoped access on a relational schema designed for integrity and fast lookups.

Patient records and clinical history in one place

  • PHP
  • Laravel
  • MySQL
Fintech · APIs

Investment & Portfolio Platform

Investment recommendation and portfolio-tracking modules for CDH Securities, with client self-service for portfolio, maturity and roll-over tracking, and cross-sell of Phoenix insurance products.

Self-service tracking for investment clients

  • Laravel
  • REST APIs
  • MySQL

05Contact

Building something that needs a solid backend? Let's talk.

I'm open to full-stack and backend engineering roles, remote or on-site. The fastest way to reach me is email.

Email me directly

knkmjonas@gmail.com

Opens your email client with the message prefilled.

LOADING_