Operational Model · Case Study

Jite Projekts
Operations Hub.

🔬 This is a self-initiated operational model built to demonstrate what systems infrastructure looks like for a firm in this sector — not a live client deployment.

A full-stack operational system built for an ISO 9001-certified
EPC & Marine Construction firm in Lagos, Nigeria.

₦13.3B
Contracts Managed
14
Linked Tables
10
Active Projects
4
Live Automations
Scroll
01
The Firm
Client Context

The reference firm. The operational model built around them.

This system was built as a self-initiated operational model — not commissioned by the firm. Jite Projekts Limited is a real ISO 9001:2015-certified EPC and marine construction firm incorporated in 1993, headquartered at Victoria Island, Lagos. Their publicly available profile, project portfolio, and industry context informed the architecture of this model.

The model was designed around the operational complexity of a firm managing multiple concurrent civil, marine, and geotechnical projects — with real data structures, real financial figures, and real workflow logic. What you are seeing is what a system for this firm could look like if implemented.

Reference Firm Profile
Incorporated
1993 — 30+ years in operation
Certification
ISO 9001:2015 Quality Management
Headquarters
6B Bendel Close, Victoria Island, Lagos
Specialisms
Bored Piling · Marine Works · Dredging · Geotechnical Investigation · Shoreline Protection
Active Portfolio
10 projects · 5 states · ₦13.34B contract value
Key Clients
Seplat · Oando · LASG · Africa Re · CCECC · Dangote · Federal Ministry
02
The Problem

Firms of this scale and complexity — running concurrent EPC, marine, and geotechnical projects across multiple states — share a common set of operational breakdowns. The following represent the pain points this model was built to address.

📊
No Live Financial Visibility
Outstanding balances were tracked manually across multiple Excel files with no single live figure. Payment delays were discovered weeks after due dates had passed. The CFO had no real-time view of the firm's financial position without preparing a report first.
Payment delays compound silently. By the time the figure is known, the follow-up window has already narrowed.
📱
Site Records on WhatsApp
Daily site progress reports were sent as voice notes and text messages to the project manager. No structured record. No searchable history. Programme slippages were identified weeks after they began because no system existed to surface them earlier.
Unstructured site reporting creates programme blind spots. Slippages are discovered after the fact, not before.
📁
Document Control Gaps
Method statements, ITPs, and submittals were managed through email threads and USB drives with no version control. The Operations Manager had no visibility of the approval backlog across ten simultaneous projects without calling or messaging each party individually.
Without a centralised register, approval backlogs accumulate invisibly — across ten projects simultaneously.
⚙️
Departments Running in Isolation
A cost change in procurement did not update the financial overview. An HSE incident logged on site required manual escalation to reach the MD. The firm's departments were already deeply connected — but the connections were invisible, informal, and unreliable.
Departments operate effectively in isolation. The failures occur at the handoffs — where data should cross but does not.
03
System Architecture

The system was architected before a single field was built. Discovery sessions with each department head produced process maps that defined exactly what data needed to exist, where it needed to flow, and what needed to be automated. The build followed the map.

14
Linked Tables
8
System Modules
4
Automations
11
Interface Boards
23+
Documents Indexed
COMMERCIAL Clients COMMERCIAL Enquiries & Tenders OPERATIONAL Team Members FINANCIAL Contracts & Variations FINANCIAL Financial Tracking CENTRAL SPINE Projects All 13 tables link here · Single source of truth COMPLIANCE HSE SITE Daily Site Records OPERATIONAL Procurement COMPLIANCE Documents & Deliverables OPERATIONAL Equipment & Assets Commercial Financial Site Operational Compliance
04
System Modules
MOD-01
Client Relationship Management
Clients
10 fields · Links to 4 tables
MOD-02
Project Operations Spine
Projects
14 fields · Links to 12 tables
MOD-03
Financial Management
Financial TrackingContracts & Variations
15 fields · Live balance formula
MOD-04
Procurement & Materials
ProcurementConsultants & Vendors
15 fields · Budget vs actual
MOD-05
HSE & Safety Compliance
HSE
11 fields · ISO 45001 aligned
MOD-06
Document Control Register
Documents & Deliverables
12 fields · 23 documents indexed
MOD-07
Site Operations
Daily Site RecordsInspections & QAEquipment & Assets
17 fields · 3 linked tables
MOD-08
Team & HR
Team Members
9 fields · Role-based access
05
Interface Design

11 interface boards across Operations, Financial Management, and Staff Boards sections. Each board is configured with role-based access — a site engineer sees a form with five fields; the MD sees the full operational picture. The complexity lives in the backend. What each person sees is clean, guided, and specific to their function.

Jite Projekts
Operations
📋 Projects
⛑️ HSE
📁 Documents
🛒 Procurement
Financial
💰 Financial Overview
📊 Procurement Tracker
Staff Boards
📌 Nkechi — PM Manager
🔰 Onoba — HSE Officer
📐 Sola — QS Surveyor
📌 Nkechi — PM Manager
👷‍♀️
Engr. Nkechi Obi
Project Manager · Engineering Department
Active Projects
4
Pending Approvals
3
Open Inspections
4
Docs Approved
11
Document Title
Type
Status
Steel Casing Material Submittal
Submittal
For Review
Bored Piling Method Statement
Method Statement
Approved
ITP — Bored Piling Works
ITP
Approved
06
External Intelligence Sites
LIVE
₦13.3B
Contract Portfolio
₦624M
Outstanding Balance
10
Active Projects
₦2.3B
Amount Invoiced
External Dashboard
Executive Intelligence Dashboard
A live-data dashboard pulling directly from the Airtable base. The MD opens one URL and sees the complete financial and operational position of the firm — project portfolio, payment status, phase breakdown, and outstanding balances — without opening Airtable.
Live Airtable API connection · auto-refreshes every 60s
Data-driven glow animations tied to actual field values
Clickable records with slide-in detail drawer
Phase donut chart · financial breakdown bars
View Live Dashboard ↗
LIVE
2
Open Status
3
Critical / High
14
Closed Out
3
Inspections
External Site · ISO 45001
HSE Compliance Register
A severity-sorted incident register pulling live HSE data from Airtable. Critical incidents glow red. Near misses surface above inspections. Click any record and the full description, corrective action, and close-out status expand inline. Generate a formatted monthly ISO 45001-aligned report with one click.
Severity-sorted with ambient glow animations
Filter by record type · open status · severity
Expand any record for full detail view
Generate Monthly HSE Report → print-quality PDF
View HSE Register ↗
07
Automated Intelligence

Four automations configured across Airtable and Make. Each fires without any manual action — triggered by a status change, a date threshold, or a field condition. The system notifies the right person at the right moment, every time, automatically.

⚠️
01 — HSE Alert
High Severity Incident → MD
Fires the moment an HSE record is saved with Severity set to High or Critical. A formatted email with incident details, corrective action, and status is delivered to the Managing Director without any manual escalation.
Recipient: Managing Director · Trigger: Status field change
02 — Overdue Payment
Invoice Overdue → CFO
Fires when Payment Status on any Financial Tracking record changes to Overdue. Sends a formatted overdue notice with client name, project, amount outstanding, and original due date to the CFO for immediate follow-up.
Recipient: Chief Financial Officer · Trigger: Status field change
📦
03 — Delivery Overdue
Expected Delivery Passed → Operations Manager
Fires when the Expected Delivery date on a Procurement record passes without the status being updated to Delivered. Sends an alert to the Operations Manager with supplier, item, project, and expected date for immediate follow-up.
Recipient: Operations Manager · Trigger: Date threshold
04 — Budget Alert
Low Remaining Budget → CFO
Fires when the Remaining Balance on any Procurement record falls below a defined threshold — signalling that a material budget is close to being exhausted. The CFO is notified before the firm goes over budget on a material order.
Recipient: Chief Financial Officer · Trigger: Field threshold
08
Documentation Package

Every engagement produces a complete documentation package. Not a PDF export of an Airtable base — a structured suite of architectural blueprints, process maps, and technical registers that belong to the client permanently. The kind of documentation that goes in a branded box and sits on a CEO's desk.

🗺️
Blueprint Series
Organisational Hierarchy
Managing Director at the centre with all five departments radiating outward. Blueprint aesthetic — dark background, gold grid lines, angular branch connections. The authority map of the firm on one page.
⚙️
Blueprint Series
Departmental Function Breakdown
Each department's core functions documented with its corresponding operational pain point. Interactive — click any department to see its anatomy. The foundation of the system justification on one page per department.
🕸️
Blueprint Series
Departmental Intersection Map
Nine numbered intersection points showing exactly where departments depend on each other. Click any node to see what crosses at that point and how the system makes the crossing automatic, immediate, and traceable.
🔄
Business Process Map
Financial Cycle — BPM
Six-lane swimlane diagram tracing the complete financial cycle from monthly measurement to payment received. Decision points, exception paths, automation interventions, and a ten-step pain point analysis panel.
🏗️
Technical Register
System Architecture Blueprint
Four-tab interactive technical document — architecture overview, module detail with full field schemas per module, automations register with trigger conditions and recipients, and interfaces register with access levels.
✉️
Email Templates
Automation Email Suite
Three Make-compatible HTML email templates — HSE high severity alert, overdue invoice notice, and procurement delivery overdue alert. All branded, all containing field variable placeholders mapped to Airtable trigger records.
09
What This Delivers

A firm running ₦13.3 billion in contracts now has one system where everything connects — financial, operational, site, compliance, and commercial data — visible from a single executive view in real time.

14
Linked Tables
Every operational and commercial record in the firm connected through a central spine. One source of truth for all ten active projects.
0
Manual Escalations
Four automations handle every critical alert — HSE incidents, overdue payments, delivery delays, and budget thresholds — without anyone asking for an update.
60s
To Full Financial Picture
The CFO reads three numbers on the Financial Overview board. ₦2.3B invoiced. ₦1.67B received. ₦624M outstanding. Done. No report prepared.
What This Model Represents

This was built as a self-initiated project to demonstrate the depth of operational architecture possible for a firm in this sector. The scope — 14 linked tables, role-based interfaces, automations, data migration, full documentation, and custom external sites — reflects what a full client engagement of this nature would involve. A US or UK consultancy building the equivalent would price the engagement at $80,000 to $150,000 USD.

Nigerian Market Range
₦25M – ₦45M
Full implementation · all six delivery layers
10
Technology Stack
DATABASE
Airtable
14 tables · 100+ fields
AUTOMATION
Make
4 scenarios · email workflows
EXTERNAL SITES
HTML · JS · Netlify
Airtable REST API
DOCUMENTATION
React JSX · SVG
Interactive blueprints
EMAIL TEMPLATES
HTML Email
Make-compatible variables
11
System Walkthroughs

Video walkthroughs of the system — from the full operational overview to individual board demonstrations. Each video shows the system navigated live, with real data, in the same way a client would use it on their first day.

Full Walkthrough
Complete System Overview
A full walkthrough of the Jite Projekts Operations Hub — from the project portfolio through financial tracking, document control, HSE management, and the live intelligence dashboard.
Board Walkthrough
Financial Management Board
A deep walkthrough of the financial tracking module — invoice lifecycle, real-time balance updates, contract variation management, and the automated payment alert system.
Staff Board Walkthrough
Project Manager Board
A walkthrough of the Nkechi PM Manager board — active project tracking, document approval pipeline, inspection hold points, and the PM Intelligence Portal external site.
Staff Board Walkthrough
HSE Officer Board
The Onoba HSE Officer board walkthrough — incident logging, severity tracking, corrective action management, and the HSE Compliance Register external site with one-click monthly report generation.
Business Systems Architecture

Your firm's operational infrastructure — built properly.

I build custom operational systems for professional firms using Airtable, Make, and the platforms that connect them. The methodology is the same every time — discovery first, architecture before build, documentation at delivery. The system is always specific to you.