Engineering Atlas
☰ Menu
PortfolioAtlasDeploySQLData ViewsEnvBites
PT
Portfolio / Engineering Atlas
V5 // Living technical system

Engineering Atlas.

My personal operating manual for the stack I use, the systems I inherit and the problems I learn to solve. Reference material, production memory and interactive tools live together — with evidence levels that separate real hands-on experience from labs and study.

Open Deployment CockpitEnvironment ConsoleBuild AI Context Pack
BUILDRecipes + reusable implementation pathsDEPLOYContextual validation + rollbackINCIDENTGuided troubleshooting + evidenceMIGRATIONDiscovery → dependency → validation
Fast paths

Start where the problem is.

The Atlas is moving beyond documentation: build, deploy, troubleshoot and learn from the same knowledge model.

OPERATIONS // INTERACTIVEDeployment Cockpit

Contextual checklists for releases that actually ship

Choose Journey, Automation, SQL, DE, CloudPage, MobileConnect, WhatsApp, API, SFTP and deliverability components. The cockpit generates PRE-DEPLOY, DEPLOY, POST-DEPLOY and ROLLBACK checks with blockers, verification items, local history and exportable evidence.

18 presetsLocal-firstMarkdown / JSONRollback
INCIDENT MEMORYProduction gotchas

Shit That Bites You in Production

19 traps with symptoms, mechanisms, checks and prevention — because the painful part should only be learned once.

SQL // DEEP DIVEQuery Engineering

ROW_NUMBER, dedup, grain & performance

Production patterns for deterministic ranking, SARGable filters, joins, staging, target actions, segmentation and runtime health.

ROW_NUMBER()DedupPerformanceStaging
DATA VIEWSPlatform Topology

15 views mapped as a graph

Email tracking, Journey, Automation health and MobileConnect data with fields, retention/timezone notes, relationships and starter joins.

OPERATIONSTroubleshooting

15 runbooks before guesswork

Journey injection, Automation health, Query timeouts, SMS, CloudPages, APIs, personalization failures, deliverability and migration discovery.

REFERENCEReusable Building Blocks

67 snippets with context and evidence

Not a paste bin: use cases, mechanics, gotchas, related references and confidence levels live beside the code.

Connected Atlas

Public knowledge now meets private environment context.

Knowledge Graph, Recipes, Workspace, query analysis and private environment snapshots reuse the same IDs and relationships. Client metadata stays local; public knowledge stays reusable.

MAP

Knowledge Graph

Explore Data Views, SQL, snippets, runbooks, production bites, deployment presets and recipes as one connected system.

EXECUTE

13 Engineering Recipes

End-to-end flows that stitch the right references together for real work.

ANALYZE

SQL Query Workbench

Paste a Query Activity and get local heuristic signals plus direct links into the Atlas.

LOCAL-FIRST

My Workspace

Saved knowledge, recent context, deployment snapshots and query analyses in this browser.

INCIDENT MODE

Incident Console

Runbook-driven troubleshooting with local notes, progress, related context and exportable incident reports.

PRIVATE GRAPH

Environment Console

Import SFMC-AUDITOR snapshots locally, inspect hotspots and compare drift without uploading client metadata.

AI BRIDGE

Context Pack Builder

Package Atlas knowledge plus selected private context for any LLM without turning the site into a generic chatbot.

Evidence model

Confidence is part of the documentation.

The Atlas should never make Study look like Production. Every knowledge type can evolve as hands-on responsibility grows.

PRODUCTION

Used in real production work and defensible from hands-on experience.

PROJECT

Implemented in a project, internal tool or meaningful hands-on build.

LAB

Tested hands-on in a controlled environment or homelab.

STUDY

Reference material or active learning; not presented as production expertise.

Domains

One stack. Multiple depths.

PRODUCTION

Salesforce Marketing Cloud

Platform engineering, data views, journeys, automations, personalization, messaging and migration.

PRODUCTION

Data Engineering

SQL patterns, modeling, identity, quality, deduplication and analytical data flows.

PROJECT

Automation & Integration

APIs, webhooks, orchestration, n8n patterns and integration reliability.

PROJECT

Systems & Infrastructure

Linux, Docker, networking, reverse proxies, Git and operational reliability.

STUDY

Security

Secrets, authentication, application hardening and secure integration patterns.

STUDY

AI & Data Science

Python, analytics, LLM engineering and future data science notes.

Generate

JOIN Builder

Find a relationship path between modeled Data Views and generate starter SQL.

Design

Patterns

17 patterns and anti-patterns with tradeoffs.

Verify

Platform Limits

Limits tied to Salesforce sources instead of folklore.

Evolve

Atlas Roadmap

What gets deeper next and which areas are still Study or Lab.

Private

Environment & Drift

The private environment graph connects locally to public Atlas knowledge.