Done
Power BI that leaders can use

Building data products for better decisions.

I design, build, deploy and maintain reporting platforms, analytics, BI, and practical AI systems that turn complex data into clear decisions across Corporate Security, UN migration, humanitarian programmes (NGOs), Commercial and Insurance.

9+
Years Experience
17
Projects & Working Demos
75%
Faster Reports
12+
Countries Supported
9+
Years Experience
75%
Reporting Time Saved
41%
Processing Time Cut (IOM)
12+
Countries of Impact
20+
Analysts Enabled
Intelligence Console · Live
ACTIVE
Interactive demonstration · Synthetic portfolio data
Guards Active
1,247
↑ 3.2% vs yesterday
Churn Risk Score
14.3%
↑ 1.1% flag
Pipeline Health
98.7%
↑ All systems green
AI Confidence
91%
↑ Model v4.2
SIGNAL Guard deployment gap flagged · Mombasa Zone 3
DATA WorkIQ churn model retrained · Accuracy 94.1%
AI Ask Pharaoh knowledge base refreshed · impact path ready
ALERT Report automation triggered · 41% faster processing
What the work changed.

Read the problems, the systems delivered and the results teams could measure afterwards.

KES 1.2M exposure identified 41% faster processing 75% reporting time saved
GardaWorld Security

False-alarm reporting moved from manual Excel to Power BI.

I built alarm intelligence reporting to help response teams identify repeated false-alarm causes, reduce avoidable deployments and track operational accountability.

KES 1.2Mestimated monthly cost exposure identified
BIPower BI operational tracking
International Organization for Migration

Exit-permit analytics exposed bottlenecks in processing stages.

Delivered Fabric, SQL and Power BI reporting that helped teams monitor cases, reconcile exceptions, and focus attention where delays were occurring.

41%processing time cut
12+countries of impact
Regional BI Delivery

Reporting automation reduced preparation time for decision reviews.

Standardized dashboards, KPI logic and data workflows so leaders could review trusted metrics faster instead of waiting on repeated manual reporting cycles.

75%reporting time saved
20+analysts enabled
Tangible proof

Choose the proof that matters: hiring evidence, client outcomes or technical demos.

Hiring evidence Client delivery Technical validation
For hiring teams

Senior data analytics, BI and AI delivery.

I help teams understand messy operations, structure the work and deliver trusted systems.

  • 9+ years across security, UN migration, humanitarian programmes and insurance.
  • Evidence available through resume, LinkedIn, job card and live project demos.
  • Strong bridge between business users, executives and technical delivery teams.
For clients

Scoped data products with measurable outcomes.

Start from one business problem, define the success metric, then build the reporting, analytics or AI product around it.

  • Power BI, Snowflake, Fabric, SQL, Python, CRM analytics and automation.
  • Experience reducing reporting time, processing bottlenecks and avoidable operational cost.
  • No private dataset is needed for the first conversation.
For technical reviewers

Working demos, not presentation slides.

I include inspectable sandbox projects with sample data, filters, assistant flows and case-study context.

  • AI, BI, ML, automation, document intelligence and dashboard sandboxes.
  • Case study, live demo and GitHub links are separated for quick review.
  • Project pages use synthetic data where real operational data is private.
Products built.
Outcomes measured.

Review the below 3 flagship proof points: enterprise BI, self-service analytics, and AI development. 17 projects & working demos available.

Showing 3 flagship proof points for fast review.
BIData Platform
Regional Enterprise BI Platform
Multi-source data platform pattern for governed regional reporting.
In this Demo Project:
  • Inspect medallion architecture
  • Review governed BI layer
  • Trace source-to-report flow
5
Source systems
RLS
Governed BI
12+
Countries
🔎
BIAnalytics
DataLens BI - Self-Service Analytics Platform
Upload data, clean it, profile it, and build instant BI insights.
In this Demo Project:
  • Upload or use sample data
  • Clean and profile columns
  • Build instant BI visuals
4
Workflow stages
8
Cleaning ops
No SQL
Self-service
AIRAG
MamaCare AI
Pregnancy-stage guidance demo using trusted maternal-health knowledge and safe response guardrails.
In this Demo Project:
  • Ask trimester-aware questions
  • Trigger safety guardrails
  • Review source-grounded guidance
RAG
Guidance
Safe
Guardrails
AI
Prototype
🛡
BISaaS
Guard Management System
Full-stack security workforce platform. Guard deployment, incident tracking, shift coverage analytics, and geospatial site mapping. Vercel + Supabase deployment.
Live
On Vercel
Maps
Site coverage
Real-time
Supabase
💬
AI
AI Sentiment Engine
Real-time NLP sentiment analysis. Flask backend with white-theme React frontend. Positive/Negative/Neutral scoring with emotion breakdown and word-level highlighting.
Real-time
Analysis
3 labels
POS/NEG/NEU
Flask
Backend
The Lab

Interactive browser demos that show the product thinking, retrieval flows, and analytics behavior behind the full systems.

GROUNDED PORTFOLIO ASSISTANT AI

Ask Pharaoh AI

A portfolio intelligence agent that answers from verified resume, project, impact, skills and writing evidence.

Structured answers with short paragraphs and bullets
Grounded evidence from my portfolio work
Best for hiring teams, clients and project-fit questions
LIVE · AI Sentiment Engine
Positive
30%
Neutral
45%
Negative
25%
Analysing... type to update
LIVE · Document Intelligence
📂
Click to load sample document
Load a document to ask questions about it. The system will chunk the content, embed it, and retrieve the most relevant passages to answer your query.
Interactive Dashboards

Interactive analytics dashboards rendered directly in the browser.

Workforce Margin & Capacity Control Tower
18 months Open
Country AllPeriod 18 months
Labour margin17.8%
Coverage94.2%
Revenue at riskKES 6.4M
0 50 100 KE UG RW TZ ZM Margin trend
Guard Deployment Coverage — Monthly Trend
↑ 3.2% Last 12 months Open
Region AllShift All
Coverage96.8%
Open gaps12
SLA protected92%
800 1000 1200 Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May
Incident Categories
YTD 2026 Open
Region AllSeverity All
Incidents402
SLA met84%
High / critical21%
Theft Access Vandal Assault Other 142 97 74 51 38
The pipeline & the stack behind it.

Four connected practices from raw data to AI-enabled decision support, backed by enterprise BI, AI engineering, and modern product infrastructure.

4-Practice Pipeline Power BI & Fabric Python & RAG Product Engineering
📊
Business Intelligence
Enterprise analytics at scale
Power BI Advanced DAX Tableau Snowflake Azure Databricks SQL Server SSRS Microsoft Fabric
Power BI / DAX
Advanced · Production reporting · Semantic modelling · RLS · Executive BI
Snowflake
Enterprise integration · Warehousing · Reporting pipelines · Governed regional data
Tableau / Excel
Dashboarding · Exploratory analysis · Stakeholder-ready operational reporting
🤖
AI Development & ML
From model to production
Python LangChain RAG Systems AWS Bedrock Amazon Q FastAPI XGBoost Microsoft Foundry pgvector Docker
Python / ML
Applied analytics · Predictive modelling · Automation · Model evaluation
RAG / LLM Ops
Grounded retrieval · Knowledge chunks · Source-aware assistant workflows
FastAPI / Docker
API demos · Container-ready services · Prototype-to-product delivery paths
🚀
Product & Engineering
From idea to deployed product
Next.js React Supabase Vercel QGIS GeoPandas TypeScript Tailwind CSS PostgreSQL
Next.js / React
Interactive portfolio apps · Demo interfaces · Responsive product experiences
Supabase / SQL
Relational data apps · Browser demos · Query-backed workflows
Geospatial
Operational maps · Location analytics · Risk and coverage visualization
War Room

See evidence, risks and change requests move from signal to accountable action.

Open War Room ->
Live risk filters CAB workflow Decision audit trail
🎯 Operation Shield — Nairobi Region Synthetic simulation
6 Active Tasks
Rejected / On Hold
📋 CAB Activity Log Audit trail — every intake, vote, approval, and rejection
The experience behind the delivery.

Follow the journey from economics and field data to regional BI and AI delivery.

9+ years of delivery 12+ countries supported Microsoft certified
Pharaoh Kipkirui Chirchir
Senior Regional Data Analyst · GardaWorld Security
Data Analytics Development · BI · AI Development

I build decision systems for teams working across countries, programmes and operational pressure. The work spans BI platforms, data warehouses, AI tools, CRM workflows, migration operations and insurance analytics.

My portfolio connects enterprise delivery with practical products: DataLens BI, WorkIQ Analytics, Ask Pharaoh AI, Document Intelligence RAG and predictive analytics sandboxes.

View Pharaoh Chirchir's full profile
Microsoft Certified Power BI Data Analyst Fabric Data Engineer
🏅
Power BI Data Analyst Associate — Microsoft
🏅
Fabric Data Engineer Associate — Microsoft
🎓
MSc Data Analytics — Nexford University
Resume
Full career profile

Download the latest PDF resume with role details, certifications, project highlights, and measurable delivery outcomes.

📄 Download Resume
9+ years of analytics, BI and AI delivery 2016 - Present
Learning in public. Building with community.

Keynotes, hackathons and regional forums where data and AI ideas were tested in public.

Keynotes AI hackathons Regional technology forums
Pharaoh Chirchir at the CITO East Africa IT Leaders Summit
Data Governance · Cybersecurity
CITO East Africa IT Leaders Summit

Joined CIOs, CTOs and senior technology leaders in Nairobi for practical roundtables on data management, cyber resilience, governance, compliance and protecting enterprise assets.

View LinkedIn post ->
Pharaoh Chirchir presenting at AI Everything Kenya x GITEX Kenya
AI · RAG · Hackathon
AI Everything Kenya x GITEX Kenya

Presented the NexaMom Mama Care AI Assistant idea during ITU hackathon use-case sessions, then turned the concept into a working RAG prototype for maternal-health education.

View LinkedIn post ->
Pharaoh Chirchir speaking during the Nexford University open day keynote
Keynote · AI Risk · Data Protection
Nexford University Open Day Keynote

Delivered a keynote in Nairobi on data protection, cybersecurity and AI challenges, covering ethical AI, access controls, cyber awareness and responsible technology practice.

View LinkedIn post ->
Cybersecurity and data protection interface representing the ICRC symposium theme
Humanitarian Data · Cyber Resilience
ICRC Cybersecurity & Data Protection Symposium

Attended the Nairobi symposium on cybersecurity and data protection in humanitarian action, exploring consent, AI risk, misinformation, privacy and multi-stakeholder collaboration.

View LinkedIn post ->
Ideas behind the work.

Practical thinking on AI ROI, analytics platforms and useful data products.

Visit blog ->
AI return on investment Microsoft Fabric Practical analytics
Latest · Data Platform Mar 13, 2026

One Platform to Rule All Your Data — Microsoft Fabric

A practical look at Microsoft Fabric, OneLake, lakehouses, warehouses, Power BI, and whether one analytics platform can hold up when real data hits real pipelines.

Microsoft Fabric Power BI Data Pipelines
Read article ->
Featured · AI Development Feb 10, 2026

What AI Can Actually Do to Your Data — and What It Can't

Explains where AI genuinely helps analysts: cleaning, anomaly detection, automation, modelling support, and faster preparation without replacing human judgment.

AI Python Automation ML
Read article ->
Ready to scope a role,
project, or decision problem?

Use this for full-time roles, consulting, BI dashboards, practical AI builds, or project collaboration. A strong first message only needs the goal, timeline, data context, and success metric.

Open for full-time roles, consulting and project builds · Nairobi + Remote
Currently available for:
Open for Full-Time Roles BI / Analytics Consulting AI Product Builds Remote / Nairobi-based
Do you need any clarification?
A few details are enough: goal, timeline, data source, and what success should look like.
Goal Data context Timeline Success metric
Your message will be sent securely through the portfolio contact service.
Sends through the secure portfolio contact service