# Periscube (https://periscube.com/)

> Principal-Led Data Engineering, Sovereign Cloud, Air-Gapped DevSecOps & AI Decision Cockpit Architecture for Mission-Critical Enterprises.
> Aligned with Turkish Presidency of Defense Industries (SSB) Savunma Sanayii Teknoloji Taksonomisi (SSTT) 2.0 & YETEN/EYDEP.
> Global Hubs: London, UK (Est. 2011) & Istanbul, Türkiye.

## Canonical Brand & Legal Entity Disambiguation

- **Canonical Brand Name**: Periscube (`periscube.com`)
- **Primary English Route**: https://periscube.com/
- **Primary Turkish Route**: https://periscube.com/tr/
- **Registered Legal Entity**: Periscube Ltd (Company No. 07691565, Registered in England & Wales)
- **Registered Office Address**: Aa House 39, 27 Old Gloucester Street, London, England, WC1N 3AX
- **Company Type**: Private limited Company
- **Incorporation Date**: 4 July 2011
- **Nature of Business (SIC)**: 62012 (Business and domestic software development) · 62020 (Information technology consultancy activities)
- **Entity Disambiguation Note**: Periscube (`https://periscube.com/`) is an enterprise data engineering, sovereign cloud, air-gapped DevSecOps, and AI decision cockpit consultancy. It is completely distinct from AnyLogic simulation software (`anylogic.com`) and the general English noun "analogy".

Periscube is an elite, principal-led Enterprise Data Engineering, High-Availability Cloud/On-Prem Architecture, Air-Gapped DevSecOps, and ADF Decision Studio consultancy.
Led by Principal Architects with 20+ years of verified delivery across Defense, Telecommunications, Investment Banking, and Mobility (Yahoo Inc., Siemens Mobility, Bank of America Merrill Lynch, Türk Telekom, Lockheed Martin / UK Met Police, LC Waikiki, and Türkiye İş Bankası).

## Raw Markdown & Text Summaries for AI Agents (Zero HTML Clutter)

- [Complete Consolidated Technical Dossier (EN + TR)](https://periscube.com/llms-full.txt): Single-file plain-text compendium of Periscube's capabilities, SSB SSTT 2.0 taxonomy matrix, case studies, engineering playbooks, ADF Decision Studio, and corporate compliance.
- [SSB SSTT 2.0 Defense & Enterprise Capabilities Matrix](https://periscube.com/llms/sstt-2.0.md): Detailed technical breakdown of Periscube's alignment with SSB SSTT 2.0 codes A09.01, B13.02, B14.07, B14.12, B13.01, A08.04, B14.05, B09.12, B09.10, and C07.20.
- [Enterprise Services, Open IP Accelerators & Engagement Pricing](https://periscube.com/llms/services-and-pricing.md): Data Vault 2.1, Oracle Exadata 19c/23ai RAC, Snowflake, Air-Gapped DevSecOps, Agentic Data Factory (MCP), ADF Decision Studio (3-Second KPI Cockpits), tokener, and fixed-scope pilot pricing.
- [Proven Enterprise Case Studies (Field Execution)](https://periscube.com/llms/case-studies.md): Audited architectural outcomes across Tier-1 Telecommunications, Global Rail & Mobility (Siemens Mobility context), Tier-1 Investment Banking, and Enterprise AI Lakehouses.
- [Principal Engineering Playbooks & Benchmarks](https://periscube.com/llms/playbooks.md): Technical deep dives on 300,000 rows/sec PyArrow streaming (<80 MB RAM), 10-node Exadata 19c RAC Advanced DB Resource Management Plans tuning (-99.9% CPU waits), and 6-minute Packer/Terraform CI/CD provisioning.
- [Corporate Identity, Information Security Policy (ISO/IEC 27001) & KVKK/GDPR Compliance](https://periscube.com/llms/corporate-and-security.md): Legal entity heritage, NATO/SSB air-gapped data protection principles, KVKK Law No. 6698, and UK/EU GDPR governance.
- [Türkçe Kurumsal Künye, SSB SSTT 2.0 ve Bilgi Güvenliği Özeti](https://periscube.com/llms/tr-kurumsal-ve-sstt.md): Turkish-language executive and defense procurement summary for SSB YETEN/EYDEP auditors and Turkish defense primes (ASELSAN, HAVELSAN, TUSAŞ, ROKETSAN, STM).

## Direct Executive & Principal Contact

- Email: hello@periscube.com
- Calendly (30-Min Principal Architecture Review): https://calendly.com/periscube/30min
- LinkedIn: https://www.linkedin.com/company/periscube
- GitHub: https://github.com/periscube
---

# Periscube SSB SSTT 2.0 Defense & Enterprise Capabilities Matrix

Periscube's engineering capabilities are mapped directly to the Turkish Presidency of Defense Industries (SSB) "Savunma Sanayii Teknoloji Taksonomisi (SSTT) 2.0" and YETEN/EYDEP procurement standards.
All implementations operate within sovereign on-premise data centers or accredited air-gapped cloud environments.

## A09.01 - Veri ve Bilgi Yönetimi Teknolojisi (Data & Information Management)
- High-availability enterprise data warehousing on Oracle Exadata (19c/23ai RAC, Smart Scan, Advanced DB Resource Management Plans, Active Data Guard), Snowflake, and DuckDB.
- Real-time mission and simulator database structures with deterministic low-latency query execution.
- Metadata management, enterprise data lineage, and Data Vault 2.1 / TM Forum SID (GB922) canonical modeling.
- High-throughput ELT/ETL pipelines engineered with Oracle Data Integrator (ODI 12c), dbt, and Apache Airflow.

## B13.02 - Büyük Veri Analitiği (Big Data Analytics)
- High-volume, high-velocity streaming data ingestion (300,000+ rows/sec via PyArrow zero-copy C++ memory streams).
- Real-time operational analytics and executive BI platforms (Oracle Analytics Server / OAS, Power BI, Tableau).
- Governed AI-driven semantic data workflows and Text-to-SQL reasoning layers (Wren AI, MCP).

## B14.07 & B14.12 - Uygulama Güvenliği (DevSecOps) & Taşıyıcı Güvenliği (Container Security)
- Air-gapped CI/CD pipeline design for disconnected defense and financial networks.
- Automated SAST, DAST, SBOM generation, and fuzz testing gates integrated into every build.
- On-demand ephemeral developer sandboxes and CIS-hardened Packer Golden AMIs.
- Reproducible Infrastructure-as-Code (Terraform) and hardened Kubernetes/OpenShift container orchestration.

## B13.01 & A08.04 - Servis Bulut Platformu & Dağıtık Mimariler (Private Cloud & Distributed Architectures)
- Sovereign and on-premise cloud infrastructure design with zero external telemetry leakage.
- Dynamic load balancing, fault-tolerant distributed systems, and active-active multi-site replication.
- High-concurrency database and middleware rescue under peak mission load.

## B14.05 & B09.12 - Veri Güvenliği & Ara Katman Sistemleri (Data Security & Middleware)
- Enterprise database security including immutable auditing, Transparent Data Encryption (TDE), and static/dynamic PII data masking.
- Data Loss Prevention (DLP) and role-based access control (RBAC) across production and non-production tiers.
- High-throughput message-oriented middleware (Apache Kafka, DDS) bridging legacy mainframes and modern lakehouses.

## B09.10 & C07.20 - Operasyonel Veri Toplama & Platform Durum İzleme (Telemetry & Predictive Maintenance)
- Time-series sensor, rail, and avionics telemetry ingestion at sub-second intervals.
- High-compression columnar storage and real-time anomaly detection backends for predictive maintenance.
---

# Periscube Enterprise Services, Open IP & Engagement Pricing

Periscube provides principal-led Enterprise Data Engineering, Sovereign Cloud, and Air-Gapped DevSecOps consultancy from London and Istanbul.

## Core Architectural Services
1. **Enterprise Data Warehousing & Lakehouse Architecture:** Petabyte-scale Oracle Exadata (19c/23ai RAC), Snowflake, Databricks, and DuckDB platforms structured on Data Vault 2.1, Kimball Star Schema, and TM Forum SID (GB922).
2. **High-Velocity Streaming & ELT/ETL Engineering:** Zero-copy PyArrow streaming (300,000+ rows/sec in under 80 MB RAM), Oracle Data Integrator (ODI 12c), dbt Core/Cloud, and Apache Airflow orchestration.
3. **Air-Gapped DevSecOps & Sovereign Cloud:** Hardened Kubernetes clusters, Terraform Infrastructure-as-Code, Packer Golden AMIs, and SAST/DAST/SBOM CI/CD automation for classified and regulated environments.
4. **Database Rescue & Cloud FinOps:** Elimination of Exadata CPU/interconnect bottlenecks (+40% headroom without new hardware) and 25% to 40% cloud data warehouse TCO reduction.
5. **Enterprise UI/UX & Decision Cockpits:** Human-centered design architecture, Enterprise Decision Studio methodology, 3-second KPI scorecards, and multi-persona executive decision portals.

## Open IP & Engineering Accelerators
- **Agentic Data Development Factory (MCP):** Model Context Protocol (MCP) servers for Oracle Exadata AXI telemetry, TM Forum SID conformance auditing, and automated Data Vault 2.1 DDL/dbt generation.
- **ADF Decision Studio & UI/UX Playbook:** Reusable Power BI templates, high-contrast accessible design systems, and multi-persona decision cockpit blueprints.
- **tokener (LLM FinOps Gateway):** Token budget enforcement, semantic caching, and multi-model routing gateway for enterprise AI workloads.
- **PyArrow 300k/s Streaming Loader:** Memory-bounded (<80 MB RSS) high-throughput ingestion engine replacing legacy Java/heap-heavy batch loaders.

## Transparent Engagement Models
1. **4-Week Fixed-Scope Pilot ($18,000 - $25,000 fixed fee):** A bounded 4-week production pilot executed inside the client's sovereign cloud or on-premise data center with measurable SLA and TCO targets.
2. **Monthly Principal Advisory & Architecture Retainer ($12,000 - $20,000/month):** Direct hands-on architectural leadership, design authority, PR/DDL review, and FinOps governance.
3. **Custom Outcome-Based Turnkey Delivery:** End-to-end platform modernization, Exadata/Snowflake migration, or air-gapped DevSecOps buildout scoped to milestone deliverables.

## Direct Principal Contact
- **Email:** `hello@periscube.com`
- **30-Minute Executive Booking:** `https://calendly.com/periscube/30min`
---

# Periscube Proven Enterprise Case Studies (Field Execution)

Periscube's engineering practice is led by Principal Architects with over 20 years of production delivery across Defense, Tier-1 Telecommunications, Global Investment Banking, and Rail/Mobility infrastructure.

## 1. Tier-1 Telecommunications Provider (Landline, Broadband & GSM)
- **Context:** Petabyte-scale enterprise data warehouse and executive BI infrastructure serving tens of millions of subscribers.
- **Architecture:** 10-node Oracle Exadata 19c RAC, Oracle Data Integrator (ODI 12c), Data Vault 2.1, TM Forum SID (GB922), and Oracle Analytics Server (OAS).
- **Measured Impact:** Achieved 99.999% availability, eliminated 99.9% of `resmgr:cpu quantum` waits via Advanced DB Resource Management Plans, freed 512 parallel query threads, and unlocked +40% hardware capacity with zero CAPEX.

## 2. Global Rail & Mobility Infrastructure Prime (Siemens Mobility Context)
- **Context:** High-reliability signaling, telemetry, and engineering software delivery pipelines across European rail programs.
- **Architecture:** Reproducible CI/CD pipelines, on-demand isolated developer test sandboxes, Packer Golden AMIs, Docker/Kubernetes orchestration, and Terraform Infrastructure-as-Code.
- **Measured Impact:** Compressed environment provisioning and release validation cycles from 6 weeks to 6 minutes while enforcing strict security and compliance gates.

## 3. Tier-1 Global Investment Banking & Financial Services (UK / US Context)
- **Context:** Mission-critical regulatory reporting, trade data transformation, and cloud migration under strict FCA/SEC/GDPR controls.
- **Architecture:** High-integrity ELT pipelines, automated static and dynamic PII data masking, RBAC least-privilege governance, and zero-downtime cloud data warehouse migration.
- **Measured Impact:** 100% regulatory audit pass rate, zero data leakage, and 34% reduction in annual cloud compute and licensing TCO.

## 4. Enterprise AI & High-Speed Lakehouse Workflows
- **Context:** Replacement of failing 14.5-hour overnight batch loads and deployment of governed self-service executive analytics.
- **Architecture:** PyArrow zero-copy streaming ingestion into Snowflake, DuckDB, and dbt Data Vault 2.1 models paired with a governed Text-to-SQL semantic layer (Wren AI & MCP).
- **Measured Impact:** Reduced batch ingestion from 14.5 hours to 3.5 hours at 300,000+ rows/sec (<80 MB RAM) and eliminated ad-hoc BI reporting bottlenecks.
---

# Periscube Principal Engineering Playbooks

## Playbook 1: Cutting Overnight Data Loads from 14.5 Hours to 3.5 Hours (PyArrow 300k/s Streaming & Data Vault 2.1)
- **Problem:** Legacy JVM/ORM batch loaders suffered OOM crashes and required 14.5 hours to ingest daily telecom and banking extracts, violating morning SLA windows.
- **Architectural Fix:** Replaced row-by-row object materialization with zero-copy Apache Arrow (`PyArrow`) C++ record batch streaming, deterministic SHA-256 hash keys, and parallel bulk loading into Data Vault 2.1 Hub, Link, and Satellite tables.
- **Benchmark Result:** Sustained 300,000+ rows/second throughput inside a strict <80 MB RAM footprint, completing the entire overnight window in 3.5 hours.

## Playbook 2: Unlocking +40% Database Capacity Without New Hardware (Oracle Exadata 19c RAC & Advanced DB Resource Management Plans)
- **Problem:** A 10-node Oracle Exadata 19c RAC cluster experienced severe CPU saturation (`resmgr:cpu quantum`), Parallel Query (PX) server exhaustion, and Cache Fusion (`gc buffer busy`) contention during peak ETL and BI hours.
- **Architectural Fix:** Engineered Advanced DB Resource Management Plans isolating ODI batch pools from interactive OAS BI consumers, enforced `PARALLEL_DEGREE_POLICY = AUTO` with strict PX caps, eliminated Partition-Wise Join skew, and restored Smart Scan cell offloading.
- **Benchmark Result:** Reduced `resmgr:cpu quantum` waits by 99.9%, freed 512 parallel execution threads, and unlocked +40% cluster capacity with zero hardware spend.

## Playbook 3: Shipping Enterprise Data & Cloud Releases 10x Faster (Agentic Data Factory & Air-Gapped DevSecOps)
- **Problem:** Manual environment provisioning, unverified DDL changes, and brittle CI/CD scripts caused 6-week lead times and frequent production rollbacks.
- **Architectural Fix:** Built CIS-hardened Packer Golden AMIs, reproducible Terraform modules, ephemeral Kubernetes developer sandboxes, and Model Context Protocol (MCP) static/dynamic auditing gates for TM Forum SID and Data Vault 2.1 conformance.
- **Benchmark Result:** Compressed environment and release provisioning from 6 weeks to 6 minutes with 100% automated compliance verification.

## Playbook 4: Eliminating Enterprise Insight Latency (Design Studio, Decision Cockpits & Power BI Accelerators)
- **Problem:** Complex ML predictions and multi-cloud analytics were siloed in dense, cluttered dashboards with 30+ second cognitive latency, preventing executive stakeholders from taking confident, timely operational actions.
- **Architectural Fix:** Implemented the Periscube Enterprise UI/UX Playbook, enforcing persona-driven progressive disclosure (Executive Scorecards, Managerial Drill-downs, Analyst Sandboxes), high-contrast institutional color tokens, the 3-second KPI comprehension rule, and reusable Power BI / Web component accelerators.
- **Benchmark Result:** Reduced decision latency by 65%, increased executive dashboard daily active adoption by 3.8x, and guaranteed 100% WCAG 2.1 AA accessibility compliance across all operational cockpits.
---

# Periscube Corporate Identity, Information Security Policy & Legal Compliance

## 1. Corporate Identity (Verified Companies House Registration)
- **Legal Entity Name:** Periscube Ltd
- **Brand Name:** Periscube (`https://periscube.com`)
- **Company Number:** 07691565 (Companies House, England & Wales)
- **Company Type:** Private limited Company
- **Incorporation Date:** 4 July 2011
- **Nature of Business (SIC):**
  - 62012 - Business and domestic software development
  - 62020 - Information technology consultancy activities
- **Registered Office Address:** Aa House 39, 27 Old Gloucester Street, London, England, WC1N 3AX
- **Corporate Heritage:** Founded and incorporated in London, United Kingdom (2011).
- **Engineering Leadership & Accreditations:** Periscube Principal Architecture Practice (Computer Science Engineering; TOGAF 9.1 Certified; dbt Labs Certified; dlt Certified; Oracle Innovation Award Winner).
- **Global Engineering Hubs:** London, United Kingdom & Istanbul, Türkiye.
- **Official Contact:** `hello@periscube.com` | `https://calendly.com/periscube/30min`
- **Verified Profiles:**
  - LinkedIn: `https://www.linkedin.com/company/periscube`
  - GitHub: `https://github.com/periscube`

## 2. Information Security Policy (ISO/IEC 27001 & NATO/SSB Aligned)
- **Zero Data Exfiltration:** All data engineering, database tuning, and DevSecOps work executes 100% inside the client's sovereign on-premise data center or accredited private cloud VPC.
- **Air-Gapped Execution:** Native support for disconnected (air-gapped) CI/CD pipelines, local artifact registries, and offline semantic/LLM execution.
- **Cryptographic & Access Controls:** Enforcement of TLS 1.3 in transit, AES-256 / Oracle TDE at rest, RBAC least-privilege access, multi-factor authentication (MFA), and static/dynamic PII data masking across all non-production environments.

## 3. Data Privacy (KVKK Law No. 6698 & UK/EU GDPR)
- Periscube acts as Data Controller in strict compliance with Turkish Personal Data Protection Law No. 6698 (KVKK) and UK/EU GDPR.
- Corporate and procurement contact records are processed exclusively for contractual scoping, security clearance verification, and statutory obligations.
- Periscube never sells, rents, or monetizes personal or corporate data with third parties.

## 4. Quality & ITSM Governance (ISO 9001 & ISO/IEC 20000-1)
- Engineering deliverables follow peer-reviewed Architecture Decision Records (ADRs), automated regression gates, and ISO/IEC 20000-1 IT Service Management change and incident controls.
---

# Periscube Kurumsal Künye, SSB SSTT 2.0 Yetkinlik Matrisi ve Bilgi Güvenliği (Türkçe Özeti)

Periscube; kritik kurumsal sistemler ve savunma sanayii için High-Availability Veri Mühendisliği, Sovereign Cloud, Oracle Exadata / Snowflake Mimarisi ve Kapalı Devre (Air-Gapped) DevSecOps çözümleri sunan principal liderliğinde bir mühendislik ve mimari danışmanlık şirketidir.
2011 yılında Londra'da (Periscube Ltd) kurulmuş olan şirket, Birleşik Krallık ve Türkiye mühendislik merkezleriyle global kurumsal operasyonlar yürütmektedir.

## 1. T.C. Cumhurbaşkanlığı Savunma Sanayii Başkanlığı (SSB) SSTT 2.0 Taksonomi Eşleşmesi
- **A09.01 - Veri ve Bilgi Yönetimi Teknolojisi:** High-Availability kurumsal veri ambarı (Oracle Exadata 19c/23ai RAC, Snowflake, DuckDB), gerçek zamanlı görev/simülatör veritabanı yapıları, metadata yönetimi, Data Vault 2.1 / TM Forum SID (GB922) modelleme ve yüksek hacimli ELT/ETL pipeline'ları (ODI 12c, dbt, Apache Airflow).
- **B13.02 - Büyük Veri Analitiği:** Saniyede 300.000+ satır PyArrow Zero-Copy Streaming, gerçek zamanlı analitik, kurumsal BI (Oracle Analytics Server / OAS) ve yönetişimli AI semantic veri katmanları.
- **B14.07 & B14.12 - Uygulama Güvenliği (DevSecOps) ve Container Güvenliği:** Kapalı devre (air-gapped) CI/CD pipeline tasarımı, otomatik SAST/DAST/SBOM/fuzz test entegrasyonu, isteğe bağlı izole test ortamları, Infrastructure as Code (Terraform IaC) ve sıkılaştırılmış Kubernetes/container orkestrasyonu.
- **B13.01 & A08.04 - Cloud Servis Platformu ve Dağıtık Mimariler:** Kurum içi Sovereign Cloud (Private Cloud) altyapısı, dinamik yük dengeleme, hata toleranslı dağıtık sistemler ve yüksek eşzamanlılık altında veritabanı/sistem kurtarma.
- **B14.05 & B09.12 - Veri Güvenliği ve Middleware Sistemleri:** Kurumsal veritabanı güvenliği (denetim izleri, TDE şifreleme, statik/dinamik veri maskeleme), DLP ve yüksek kapasiteli mesaj yönelimli middleware sistemleri (Apache Kafka, DDS).
- **B09.10 & C07.20 - Operasyonel Veri Toplama ve Platform Durum İzleme:** Zaman serisi sensör, demiryolu ve aviyonik telemetri verilerinin toplanması, sıkıştırılmış sütunsal depolanması ve kestirimci bakım anomali tespiti.

## 2. Doğrulanmış Kurumsal Künye (Companies House Resmi Kayıtları) ve İletişim
- **Yasal Şirket Ünvanı:** Periscube Ltd
- **Kısa Ünvan / Marka:** Periscube (`https://periscube.com/tr/`)
- **Şirket Sicil Numarası (Company Number):** 07691565 (Companies House, Cardiff / İngiltere ve Galler)
- **Şirket Türü:** Private limited Company (Özel Limited Şirket)
- **Kuruluş Tarihi:** 4 Temmuz 2011
- **Faaliyet Alanı (SIC Kodları):** 62012 (Yazılım Geliştirme) ve 62020 (Bilişim Teknolojileri Danışmanlığı)
- **Tescilli Merkez Adresi:** Aa House 39, 27 Old Gloucester Street, Londra, İngiltere, WC1N 3AX
- **Mühendislik Merkezleri:** Londra, Birleşik Krallık ve İstanbul, Türkiye
- **Mühendislik Liderliği:** Periscube Principal Mimari Kadrosu
- **E-posta:** `hello@periscube.com`
- **Yönetici Randevusu (30 Dakika):** `https://calendly.com/periscube/30min`
- **LinkedIn:** `https://www.linkedin.com/company/periscube`
- **GitHub:** `https://github.com/periscube`
- **Uyumluluk:** ISO/IEC 27001 BGYS, ISO/IEC 20000-1 ITSM, ISO 9001 Kalite Yönetimi, NATO/SSB kapalı devre veri güvenliği ilkeleri ve UK/EU GDPR / 6698 sayılı KVKK.