Backend & API Development
Selected work demonstrating this service.
- Designed, implemented, and administered 6 ETL/ELT pipelines, utilizing Google BigQuery, MSSQL, PostgreSQL, Shell scripting, PL/pgSQL, and Transact‑SQL, integrating data for efficient Python API processing.
- Delivered 8 Power BI projects with comprehensive manuals, integrating Microsoft Power BI tools with NodeJS API and Python FastAPI for effective data analytics and visualization.
- Directed full‑stack GIS map development, overseeing PostgreSQL, Mapbox, ReactJS, and NodeJS to deliver an integrated solution.
- Led the development, deployment, and support of over 30 GIS projects, demonstrating expertise in PostgreSQL, Bash, Python, JavaScript, GDAL, ArcGIS, PostGIS, and Mapbox technologies.
- Developed a Data Analytics reporting system, increasing quarterly software revenue by 400% through Python‑based PDF reports.
- Architected a layered maritime platform separating a Next.js PWA frontend, a Go (Huma/Fiber) API, and a PostgreSQL function layer, keeping all business logic in the database.
- Designed a JSON passthrough architecture where PostgreSQL functions return complete JSON forwarded verbatim by the Go API, eliminating intermediate unmarshalling and decoupling the frontend from schema changes.
- Designed an organization context‑switching system with client localStorage and server‑side cookie mirroring, letting users act as managed organizations while enforcing least‑privilege authorization.
- Migrated the HTTP API from Fiber to Huma v2, gaining automatic request validation and OpenAPI modeling across all endpoints.
- Built a request‑schema validation contract with automated guards that catch frontend/backend payload mismatches before they reach production.
- Implemented startup mail‑provider validation across three providers (SendGrid, SMTP2GO, Azure ACS) with environment‑aware behaviour — logging in development, failing the boot in staging and production.
- Designed a PostgreSQL function‑first data layer across the platform's domain schemas (identity, organization, review, message, notification and more), exposing all data access through stored functions.
- Implemented a catalogue‑driven deep‑merge for stored JSON preferences, preventing missing‑key crashes as the schema evolves.
- Built a Python vessel‑data scraper (MarineTraffic, Maritime‑Database) and imported roughly 700 maritime companies to seed the platform's core reference data.
- Hardened the application with nonce‑based CSP, HSTS, SameSite cookies, least‑privilege database roles and server‑side entitlement re‑checks.
- Architected and implemented the platform end to end — backend, database, frontend, design system, infrastructure and security — establishing the technical foundation and engineering standards.
- Developed and maintained Django web applications for the IPTV platform, shipping new features and improving performance and stability.