Pharaoh Chirchir brand markPharaoh Chirchir
Pharaoh Chirchir impact profile
Impact Room

Business impact from data products that people actually use.

This impact room brings together the data products I have delivered, the operational problems I worked on, the measurable results created and the skills I applied to make the impact repeatable.

Approximately US$9,300Estimated monthly false-alarm cost exposure identified
75%Reporting preparation time saved
41%IOM processing time cut
100K+Case records supported in migration
The problems these projects helped solve.

Across the work, I used analytics, BI, automation and AI to reduce avoidable cost, shorten processing time, improve reporting and give teams a clearer view of what needed attention.

Cost Leakage Reduction

Turn unclear operational activity into tracked categories, accountable follow-up and measurable savings.

ROIRoot causePower BI

Process Speed

Expose bottlenecks, aging work, exceptions and capacity gaps so leaders can reduce cycle time.

OperationsSQLAutomation

Trusted Reporting

Replace manual Excel reporting with governed dashboards, reusable rules and repeatable data pipelines.

BI governanceSnowflakeDAX
How the evidence is presented.

I separate measured delivery outcomes, estimated cost exposure, model performance and synthetic demo outputs so you can review the proof without exposing private operational data.

Measured outcomes

Used where the work has a clear before-and-after operational result, such as reporting time saved or processing time reduced.

Estimated exposure

Used where analytics surfaced avoidable cost or risk patterns that teams could inspect and act on.

Demo evidence

Used in public sandboxes with synthetic, sample or anonymised data to show workflow, logic, controls and decision outputs safely.

What I delivered, and what changed.

Each case shows the problem I worked on, what I built, what the team could measure afterwards and the technology that made the result repeatable.

GardaWorld Security · Africa & Middle East

Regional BI operating model made reporting faster and more trusted.

75%report preparation time saved

Business problem

Regional teams needed faster management reporting across countries, cleaner data quality rules and consistent KPI visibility for operational and finance reviews.

What I delivered

I built regional BI assets around Snowflake warehousing, Power BI reporting, CRM analytics, business-rule validation, SOP documentation and analyst enablement.

Business support

Leaders gained a clearer view of country performance, budget movement, operations trends and recurring reporting quality issues before month-end decisions.

Value created: Reduced report-preparation time by roughly 75%, supported regional month-end reviews during 98% budget-attainment visibility and enabled 20+ analysts through Power BI and SQL/MySQL training.
SnowflakePower BISQL / MySQLConfluenceGitHubData quality
International Organization for Migration (IOM)

Exit-permit analytics exposed bottlenecks and improved turnaround.

50 → 29days processing timeline

Business problem

Migration operations needed a clearer view of processing stages, aging cases, capacity constraints and exceptions affecting exit-permit turnaround.

What I delivered

I built Fabric, SQL and Power BI analytics that tracked stage-level movement, highlighted bottlenecks and supported operational capacity planning.

Business support

Management could inspect where work was slowing, adjust resources and communicate operational performance using evidence rather than fragmented status updates.

Value created: Helped improve exit-permit turnaround from 50 to 29 days, a 41% reduction, and supported capacity planning that increased daily fingerprinting appointments from 20 to 30.
Microsoft FabricPower BISQLProcess analyticsCapacity planning
International Organization for Migration (IOM)

KPI and reconciliation automation freed staff time for higher-value work.

70+staff-hours saved per month

Business problem

Recurring KPI packs, reconciliations and exception reviews required manual effort and slowed operational reporting cycles.

What I delivered

Automated recurring reporting workflows, created reusable business rules and built exception views for managers to inspect issues faster.

Business support

Teams spent less time assembling reports and more time reviewing risk, workload, quality and programme performance.

Value created: Saved an estimated 70+ staff-hours per month, reduced recurring reporting effort and improved management readiness for operational reviews and donor-facing updates.
AutomationPower BISQLData validationException reporting
CWS RSC Africa

Case-processing analytics strengthened pipeline visibility and quality control.

40+reporting assets across 15 departments

Business problem

High-volume resettlement operations needed reliable visibility into case movement, workload allocation, quality checks, departure readiness and system migration readiness.

What I delivered

I built Tableau, SQL and Python reporting workflows, supported UAT and data-quality reviews, mentored analysts and contributed to migration of 100,000+ case records to the START platform.

Business support

Departments gained better inspection of workload, processing quality and readiness signals across sensitive beneficiary operations.

Value created: Improved cross-department reporting discipline, supported 100,000+ record migration quality, contributed 40+ reporting assets and earned Innovation Excellence recognition for automated reporting impact.
TableauSQLPythonUATData migrationQA reporting
Resolution Insurance Kenya

Claims analytics connected data quality to financial risk control.

94%fraud-detection model accuracy

Business problem

Claims teams needed cleaner reconciliations, stronger visibility into inconsistent claims records and practical signals for fraud and payment-risk review.

What I delivered

I built claims reporting, reconciliation workflows, data-quality checks and an early fraud-detection model for medical claims analysis.

Business support

The work helped strengthen claims review discipline, reduce ambiguity in reconciliations and connect analytics to financial-risk monitoring.

Value created: Established a practical analytics foundation in insurance operations, including a fraud-detection model reported at 94% accuracy and repeatable claims-data review practices.
Excel analyticsReconciliationClaims dataMachine learningRisk analytics
Where to inspect the work.

Live demos

Use the sandbox to test my projects directly: DataLens BI, churn prediction, WorkIQ, document intelligence, forecasting and other interactive tools.

Decision workflow

Use the War Room to see how project risks, evidence, dashboards and decision movement can be organized for serious data and AI delivery.

Turn evidence into a scoped data product.

Start with one business pain point, one measurable success metric and a clear path from data source to decision.

Discuss a Project