# Portfolio

> Browse the full portfolio of Engineer ApS engineering achievements, each with a detailed review.

=> /portfolio/twice-the-engagement-from-listening-first/ Brand communication informed by audience response
=> /portfolio/one-infrastructure-plan-for-14-departments/ One infrastructure plan for 14 departments
=> /portfolio/a-month-of-meter-readings-in-180-milliseconds/ 30 days of electricity data in 180 ms
=> /portfolio/made-a-geographical-data-pipeline-50x-faster/ Made a geographical data pipeline 50x faster
=> /portfolio/improved-gis-map-performance-10x-on-postgresql/ Improved GIS map performance 10x on PostgreSQL
=> /portfolio/resolved-1000-issues-in-geographical-data/ Resolved 1,000 issues in geographical data
=> /portfolio/designed-and-ran-6-etl-elt-pipelines/ Designed and ran 6 ETL/ELT pipelines
=> /portfolio/built-the-companys-first-observability-dashboard/ Built the company's first observability dashboard
=> /portfolio/delivered-8-power-bi-projects-with-manuals/ Delivered 8 Power BI projects with manuals
=> /portfolio/released-500-electricity-and-gis-data-reports/ Released 500 electricity and GIS data reports
=> /portfolio/ran-100-postgresql-ms-sql-bigquery-warehouses/ Ran 100 PostgreSQL, MS SQL, BigQuery warehouses
=> /portfolio/ran-10-postgresql-and-ms-sql-servers-on-ubuntu/ Ran 10 PostgreSQL and MS SQL servers on Ubuntu
=> /portfolio/wrote-1000-rbac-rules-to-secure-linux-servers/ Wrote 1,000 RBAC rules to secure Linux servers
=> /portfolio/accelerated-postgresql-performance-by-10x/ Accelerated PostgreSQL performance by 10x
=> /portfolio/automated-gis-saas-deployment-with-github-actions/ Automated GIS SaaS deployment with GitHub Actions
=> /portfolio/automated-delivery-of-20-gis-data-pipelines/ Automated delivery of 20 GIS data pipelines
=> /portfolio/automated-100-critical-data-backups-using-barman/ Automated 100 critical data backups using Barman
=> /portfolio/optimized-forecasting-and-investment-strategies/ Optimized forecasting and investment strategies
=> /portfolio/gathered-and-analyzed-business-requirements/ Gathered and analyzed business requirements
=> /portfolio/led-30-gis-projects-from-build-to-support/ Led 30+ GIS projects from build to support
=> /portfolio/saved-4000-hours-with-github-and-gitlab-ci-cd/ Saved 4,000 hours with GitHub and GitLab CI/CD
=> /portfolio/developed-a-data-analytics-reporting-system/ Developed a Data Analytics reporting system
=> /portfolio/automated-data-processing-in-python-and-pl-pgsql/ Automated data processing in Python and PL/pgSQL
=> /portfolio/engineered-600-pl-pgsql-etl-elt-pipelines/ Engineered 600 PL/pgSQL ETL/ELT pipelines
=> /portfolio/a-mapping-product-carried-end-to-end/ A mapping product, carried end to end
=> /portfolio/a-maritime-platform-built-in-clean-layers/ A maritime platform with clear system boundaries
=> /portfolio/designed-a-json-passthrough-from-postgres-to-api/ Designed a JSON passthrough from Postgres to API
=> /portfolio/designed-a-function-first-postgresql-data-layer/ Designed a function‑first PostgreSQL data layer
=> /portfolio/quicker-answers-from-a-better-choice-of-key/ Time‑ordered keys for a growing data model
=> /portfolio/implemented-a-catalogue-driven-deep-merge/ Implemented a catalogue‑driven deep‑merge
=> /portfolio/modeled-348-tables-across-34-postgres-schemas/ Modeled 348 tables across 34 Postgres schemas
=> /portfolio/implemented-backups-and-disaster-recovery-as-code/ Implemented backups and disaster recovery as code
=> /portfolio/delivered-analysis-and-regular-progress-reports/ Delivered analysis and regular progress reports
=> /portfolio/designed-a-time-management-and-reporting-system/ Designed a time‑management and reporting system
=> /portfolio/built-stripe-and-in-app-purchase-entitlements/ Built Stripe and in‑app purchase entitlements
=> /portfolio/moved-slow-work-onto-a-river-job-queue/ Moved slow work onto a River job queue
=> /portfolio/1022-migrations-behind-a-schema-drift-gate/ 1,022 migrations behind a schema drift gate
=> /portfolio/built-first-party-analytics-inside-postgresql/ Built first‑party analytics inside PostgreSQL
=> /portfolio/built-a-loyalty-wallet-leagues-and-badges/ Built a loyalty wallet, leagues and badges
=> /portfolio/built-the-hiring-and-seafarer-career-workspaces/ Built the hiring and seafarer career workspaces
=> /portfolio/wrote-a-scope-rule-after-a-credential-leak/ Wrote a scope rule after a credential leak
=> /portfolio/generated-495-pages-from-a-sqlite-export/ Generated 495 pages from a SQLite export
=> /portfolio/replaced-963-metadata-blocks-with-one-graph/ Replaced 963 metadata blocks with one graph
=> /portfolio/built-a-database-driven-cv-generator/ Built a database‑driven CV generator
=> /portfolio/wrote-tests-for-the-checkers-themselves/ Wrote tests for the checkers themselves
=> /portfolio/moved-every-string-into-a-content-tree/ Moved every string into a content tree
=> /portfolio/built-a-cross-language-figure-check/ Built a cross‑language figure check
=> /portfolio/know-the-licence-of-everything-you-ship/ Know the licence of everything you ship
=> /portfolio/measured-13-addresses-with-no-tracking/ Measured 13 addresses with no tracking

=> https://data.engineer.company/portfolio/ This page on the web
