HIDEKITOYAMA

Data pipeline for ingestion and transformation of orders stored in Azure Data Lake. ETL orchestration with Dataflow Gen2, replicating Alteryx-style processes required by the client.

Migration of legacy data flows to Databricks notebooks using PySpark, and orchestration of the resulting processes through Databricks Jobs. Involved in design, testing, and rollout.

Internal Java/Spring Boot service for users, roles and permissions, built by a team I contributed to. My part was role management: implementing it at the API layer and verifying that the authorization checks behaved correctly for each role.

The operational backbone for clients and studio management: centralizes web analytics, lead pipelines, support requests, and financial reporting in a single multi-tenant dashboard. Built on a clean architecture across sixteen domain modules — billing, site health, complaints book API, lead routing, internal finance — isolating domain rules, server access, and UI layers. Strict tenant data isolation enforced at the database level via PostgreSQL Row Level Security (RLS), with automated Playwright smoke testing and Sentry telemetry gating production deploys.

Public commercial platform and service engine for the studio. More than static landing pages, it delivers production-ready web infrastructure with native Peruvian regulatory compliance (integrated Libro de Reclamaciones API and legal data terms), real-time lead capture with UTM attribution piped directly to the admin portal, and interactive product demos.

Inventory and logistics system for a mining contractor. Multi-warehouse stock with a transactional kardex: balances and costs are computed atomically in the database, so concurrent movements can't drift. Built around fast data entry — dense tables, keyboard-first flows, Excel import and export — over 80 SQL migrations and roles hardened with RLS.

Institutional site for the same contractor, deployed separately from the ERP so neither can take the other down. Fully static for SEO, with every text, service, KPI and image centralized in a single content file the client's team can edit without touching components.

Storefront for a made-to-order canvas printing business in Lima. Quote builder with real-time size and price comparison, filterable catalog, blog, and a Peruvian complaints book for regulatory compliance. Orders close over WhatsApp, which is how the business already sold.

The store's internal tools had grown into eight isolated pages, each with its own login form and its own diverging CSS — and every admin deploy risked the public site. I pulled them out into a single SPA with one auth provider, role-based route guards, and one set of design tokens. The storefront and the panel now ship independently.

Site for a mining contractor registered with Peru's Ministry of Energy and Mines. Service and capability pages aimed at procurement teams evaluating suppliers, with contact routing as the single conversion goal.

Catalog and cart for artisan products where checkout hands off to WhatsApp instead of a payment gateway — the flow the client's customers already used. Includes product filtering, a complaints book, and 3D scene work in the landing.

Linux VMs on GCP running my own services: firewall rules, SSH access and networking configured by hand, containerized deploys with Docker, Cloud Storage buckets, and a few migrations between environments. Nothing here has users, which is the point: it is where I try the things I would not try first on a client's box.