I help leaders and institutions make better decisions with data.
Policy & strategy data analyst turning complex operational and governance data into clear, actionable recommendations.
Policy & strategy data analyst turning complex operational and governance data into clear, actionable recommendations.
Analytics is not simply a technical discipline, but a strategic lever for real-world governance and impact.
I'm Pet Emmanuel Akiliya, an International Policy & Strategy Data Analyst driven by a passion for transforming raw data into intelligence that informs better decisions, strengthens institutions, and creates meaningful impact.
My experience across Nigeria's public sector has given me a unique perspective on intelligence, governance, operations, and organizational strategy. Working within national institutions has strengthened my ability to analyze complex information, recognize patterns, evaluate risks, and communicate insights clearly.
Deep grounding in national governance, operational security data, and public sector decision dynamics.
Evaluating high-stakes operational risks, detecting anomalies, and mitigating organizational vulnerability.
Moving beyond intuition to ground long-term strategic planning in validated empirical data.
Translating complex multi-source analytics into clear, compelling executive dashboards & policy briefs.
Managing the complete analytics lifecycle - from raw database queries to interactive executive storytelling.
Extracting, cleaning, and structuring complex relational datasets across multi-agency databases. Specialized in window functions, CTEs, subqueries, and performance tuning.
WITH RegionalCrimeStats AS (
SELECT
state_id,
crime_category,
COUNT(incident_id) AS total_incidents,
AVG(response_time_hrs) AS avg_response,
RANK() OVER (
PARTITION BY state_id
ORDER BY COUNT(incident_id) DESC
) AS severity_rank
FROM national_security_logs
WHERE incident_date >= '2025-01-01'
GROUP BY state_id, crime_category
)
SELECT * FROM RegionalCrimeStats
WHERE severity_rank <= 3;Leveraging Pandas, NumPy, and Statsmodels for exploratory data analysis, predictive forecasting, risk modeling, and automating report generation pipelines.
import pandas as pd
from datetime import datetime
# Ingest Bill of Lading manifests & terminal logs
df = pd.read_excel('MASTER.xlsx', sheet_name='MASTER')
today = datetime.now()
# Compute dwell time & dynamic risk tier
df['DAYS_WAITING'] = (today - df['DATE_ARRIVAL']).dt.days
df['RISK_LEVEL'] = df.apply(
lambda r: 'HIGH RISK' if r['DAYS_WAITING'] >= 7
else ('MEDIUM' if r['DAYS_WAITING'] >= 5 else 'ON TRACK'),
axis=1
)
# Generate sequential tracking audit ID
df['OUTSTANDING_ID'] = [f"OUT-{i+1:04d}-{today:%Y%m%d}" for i in range(len(df))]Creating interactive executive-level dashboards with dynamic DAX measures, row-level security (RLS), and custom visual KPI cards for decision-makers.
// Policy Allocation Variance Measure
PolicyAllocationVariance % =
VAR ActualBudget = SUM(Disbursements[ActualSpent])
VAR ApprovedBudget = SUM(Allocations[ApprovedBudget])
RETURN
DIVIDE(
ActualBudget - ApprovedBudget,
ApprovedBudget,
0
)Designing interactive GIS spatial heatmaps, policy storytelling story points, and multi-dashboard operational control rooms.
// Regional Risk Index Calculation
IF [Security Threat Level] = "HIGH" AND [Infrastructure Density] < 0.3 THEN
"CRITICAL INTERVENTION NEEDED"
ELSEIF [Security Threat Level] = "MEDIUM" THEN
"MONITORING REQUIRED"
ELSE
"STABLE ALLOCATION"
ENDBuilding automated VBA macros, dynamic array formulas (XLOOKUP, INDEX/MATCH, LET, LAMBDA), Power Query ETL cleanups, and scenario pivot tables.
# Dynamic Policy Risk Index Formula
=LET(
Budget, Allocations[Approved],
Spent, Disbursements[Actual],
Variance, (Spent - Budget) / Budget,
RiskCategory, IFS(Variance > 0.15, "High Risk", Variance > 0, "Moderate", TRUE, "On Track"),
RiskCategory
)Selected projects demonstrating evidence-based recommendations and measurable outcomes across national institutions.
Engineered an automated Python desktop tracking application deployed to monitor container dwell times, flag high-risk delayed cargo, and streamline customs clearance across maritime terminals.
Developing a predictive spatial-temporal crime analytics model to support law enforcement resource deployment and proactive threat mitigation.
Evaluating internal institutional workflows to pinpoint operational bottlenecks, risk exposure, and governance compliance metrics.
Test the operational logic powering the CIU Tracking Application. Adjust transit and examination dwell thresholds to observe real-time container risk triage and escalation alerts.
Authoritative briefs on advisory scope, analytical frameworks, regional coverage, and institutional collaboration.
Pet Emmanuel Akiliya is an International Policy & Strategy Data Analyst based in Abuja, Nigeria. She advises public sector bodies, international development institutions, and maritime customs commands by turning complex administrative datasets into high-confidence intelligence, strategic policy architectures, and risk mitigation systems.
Pet applies full-lifecycle quantitative analytics using SQL (PostgreSQL, BigQuery), Python (Pandas, NumPy, Scikit-learn), Power BI, Tableau, and automated spreadsheet data modeling. Her core methodologies encompass spatial hotspot correlation, anomaly detection algorithms, econometric policy modeling, and automated institutional audit dashboards.
Yes. The proprietary CIU Tracking architecture incorporating multi-tier risk scoring, manifest cross-verification, and automated bottleneck isolation is fully adaptable for international logistics hubs, revenue authorities, and multi-agency border enforcement operations seeking measurable clearance speedups and audit visibility.
Pet is based in Abuja, Federal Capital Territory, Nigeria, and operates both in-person across West Africa and remotely worldwide. She accepts selective mandates for public sector reform, institutional data strategy, security intelligence analytics, and conference keynotes.
Whether seeking public sector policy consultation, institutional data strategy, or full-lifecycle analytics implementation.
I am open to collaborations with governments, international institutions, research bodies, and forward-thinking organizations looking for evidence-based strategic leadership.