A reference guide to the technologies, standards and methods discussed in these chapters, grouped by purpose. Project examples and illustrative designs are distinguished in the chapters.
Data & analysis SQL · Amazon Redshift · Teradata · MongoDB · SQL Server · SSIS · SSRS · ETL and BI pipelines · Apache Camel · Sqoop · Tableau · Excel · funnel and cohort analysis · bottom-up sizing · cost-per-unit modelling · risk-priority scoring Master data & integration Reltio MDM · customer book-of-record · identity resolution · data-mapping specifications · JSON · XML / XSD · YAML · EDI 837 / 834 / 270-271 · CMS-1500 / UB-04 · cXML · CIF · UNSPSC · SFTP pipelines · Microsoft BizTalk · homegrown EDI shredding into a normalized datamart before adjudication · OnBase · LifePRO · Salesforce Cloud & services Amazon Web Services — Lambda, Fargate, S3, KMS, CloudWatch, Amazon Connect · REST API design · synchronous vs. asynchronous service design · Kafka streaming · multi-tenant authorisation · over-the-air deployment · CI/CD pipelines AI & agents Amazon Bedrock (agents, knowledge bases, guardrails, prompt management) · LangGraph · Strands SDK · Model Context Protocol tool contracts · retrieval-augmented generation · vector databases · Amazon Connect with real-time transcription and conversation analytics · intent detection · LLM-as-judge evaluation · Langfuse tracing · shadow mode and offline replay · OCR / ML document extraction Healthcare systems NCPDP SCRIPT and D.0 standards · drug database and dose screening · Medi-Span · First Databank · State PDMP reporting and lookup · Identity verification service · NDC / GPI / GCN / RxCUI · SNOMED · ICD-10 · state PMP systems · Medicare eligibility and benefit logic · Medicaid rules Commerce & procurement Punchout / Punch-in · Coupa · SAP Ariba · Jaggaer · Oracle · Integrated Quoting price lock and inventory reservation when won; Ordering API / XML order; post-order Reconciliation / Invoice API · SSO / identity · hosted catalogs · order-on-behalf-of · point-of-sale and pharmacy-management platforms Ways of working Working backwards (PR/FAQ) · versioned requirements · annual operating plans · weekly / monthly / quarterly business reviews · monthly product review · Scaled Agile — PI planning, WSJF · two-way / one-way doors · work-back plans · Correction of Errors · Jira · Jira Align · Confluence · Quip Testing & launchunit and integration test review · automated regression on masked production data · performance and load testing against a latency budget · user acceptance testing · offline replay parity · shadow mode · go / no-go · staged dial-up · feature flags · LMS-delivered training · SOPs and job aids · customer and partner onboarding · hypercare runbooks