Client results, by the numbers

Seventeen engagements from dot. tech studio's own client work in Saudi Arabia. Client names are withheld; the industry, the problem and the measured result are real.

Insurance: Three insurance databases, one schema

Insurance

Consolidated three separate legacy insurance databases into one schema, working solo over about a year. Mapped master data that carried different codes per branch, with dependencies up to seven levels deep, and merged duplicate customers into single accounts and statements. Delivered with full data integrity.

Result: The outside vendor had judged it impossible and quoted 8 million US dollars to freeze the data and start fresh.

Read this as a question and answer →

Insurance: Ten years of claims in one weekend

Insurance

A regulator-mandated upload of ten years of historical claims across all branches, rescued over a single three-day weekend after the appointed vendor could not do it. Degraded legacy records were cleaned and rebuilt, and policies matched to national identities.

Result: The SAMA deadline was met, removing the company's shutdown risk.

Read this as a question and answer →

Takaful insurance: Integration and reporting rebuild

Takaful insurance

Reverse-engineered a faulty hourly integration between the core insurance system and Oracle E-Business Suite, then rebuilt the process and the customer statement and ageing reports. Transactions now reflect instantly with no errors.

Result: Statement report from two hours to seven seconds. The code has run in production unchanged since 2012.

Read this as a question and answer →

Takaful insurance: 300 million SAR reconciled

Takaful insurance

Resolved a mismatch between invoices and receipts by building and running Oracle API routines.

Result: 300 million SAR resolved in 26 seconds, replacing a proposed one-month, four-person vendor engagement.

Read this as a question and answer →

Takaful insurance: Budgeting go-live rescue

Takaful insurance

Took over a failing Hyperion budgeting go-live with no integration licence and an incomplete handover. Learned the manual data process and corrected every mismatched number to the halalah.

Result: A successful executive presentation within a two-week deadline.

Read this as a question and answer →

Takaful insurance: Four integrations the vendor could not deliver

Takaful insurance

Delivered four enterprise system integrations the vendor had failed to complete, working solo.

Result: Each delivered within a one-week window, after each had been allocated three to six months.

Read this as a question and answer →

Insurance: Legacy migration without vendor access

Insurance

Migrated a legacy insurance system to a new core system with zero downtime by reverse-engineering the database directly, bypassing the vendor's pending support and extraction fees.

Result: Extraction to the new system's templates completed in under three weeks.

Read this as a question and answer →

Insurance: Motor claims automation

Insurance

A motor claims system integrating Najm and Yaqeen for automatic data capture, and Laserfiche document scanning with optical character recognition (OCR). Service-level timers, fraud flags and a multi-level approval workflow by claim value.

Result: A 20-minute manual process cut to under two minutes.

Read this as a question and answer →

Insurance: Mass-upload performance fix

Insurance

Found why mass policy uploads crawled: the core system scanned the full policy table to generate each new number. Built dynamic Oracle sequences per transaction type.

Result: From 25 minutes per batch to under 10 seconds, enabling a large production increase in medical policies.

Read this as a question and answer →

Insurance: Self-service claim status line

Insurance

An automated call-centre line, 2014, where a customer enters a national identity number and hears claim status, missing documents, pending approvals and the expected amount.

Result: Reduced call-centre load.

Read this as a question and answer →

Insurance: Rating engine optimisation

Insurance

Reverse-engineered and optimised a vendor-built insurance rating engine. On the SAMA price aggregator, the fastest response ranks highest.

Result: Quotation time from 42 seconds to 0.07 seconds. Rank 32 of 34 to rank 1, capturing a dominant share of new sales.

Read this as a question and answer →

Insurance: Motor fraud ruleset

Insurance

A logic-based fraud process flagging claims by timing within the policy, shared family names, address proximity, related parties, high-value vehicles and repeat damage to the same part.

Result: Caught real fraud for the dedicated review team.

Read this as a question and answer →

Manufacturing: Factory operations dashboard

Manufacturing

Heavy production machinery for lighting poles and towers fitted with sensors and integrated with Oracle E-Business Suite, tracking every pole by order, stage, machine, scrap and time across six factories. The schedule was reordered to cut multi-hour changeovers.

Result: Welding found as the true bottleneck. Inventory prediction added so purchasing never stalled the line.

Read this as a question and answer →

Manufacturing: Payroll report rebuild

Manufacturing

Rebuilt the payroll report for more than 10,000 employees, matched to historical figures to the halalah, and added Oracle BI Publisher bursting to email payslips instead of printing and hand-delivering them.

Result: From 18 hours to 16 seconds.

Read this as a question and answer →

Insurance: 750,000 policies in one day

Insurance

Set up the upload interface to Najm and ran the load in parallel across 25 machines over a weekend.

Result: More than 750,000 motor policies uploaded under a single-day deadline.

Read this as a question and answer →

Healthcare: Independent hospital financial audit

Healthcare

A financial audit of a hospital treating work and industrial injuries under GOSI cooperation. Contracts and payments revised, and billing and controlled-substance handling irregularities surfaced.

Result: An estimated 250 million SAR in unbilled and improperly handled amounts recovered.

Read this as a question and answer →

Payments: Payments licensing architecture

Payments

Authored the infrastructure, security and data-flow architecture and the evidence package for a payments platform.

Result: Used to pass the SAMA technical audit and secure the financial services licence and investment.

Read this as a question and answer →