Back to Home
CURRICULUM VITAE→

Resume & CV

Farrel Zandra

Frontend & Full-Stack Engineer

Summary
Versatile Frontend & Full-Stack Software Engineer with proven experience delivering production-grade web platforms using Next.js (App Router), React, TypeScript, and modern component systems. Proven expertise across the engineering lifecycle: Turborepo monorepo architecture, upstream requirements engineering, client backoffice CMS delivery, installable mobile-first web applications, and AI workflow orchestration (n8n/Gemini), complemented by enterprise experience managing TB-scale distributed databases at PT Neural Technologies Indonesia. Certified JLPT N3 holder with professional working English proficiency, prepared to contribute clean architecture and high-performance UI/UX to cross-border engineering teams.
Technical Skills

Frontend & Web: Next.js 15/16 (App Router), React 19, TypeScript, JavaScript (ES6+), Tailwind CSS v4, Material UI (MUI v6), Recharts, Framer Motion, PWA Manifest, Flutter

Backend & APIs: NestJS 11, Node.js, Express.js, RESTful APIs, Prisma ORM, PostgreSQL (Citus), ClickHouse, Supabase

DevOps & Observability: GitHub Actions (CI/CD), Datadog (APM & RUM Basics), Telemetry & Latency Logging, n8n Automation, Docker, Linux (Ubuntu/Debian CLI)

Software Engineering: Monorepo (Turborepo), Upstream Requirements Specification, Software Analysis & Design, SSR/CSR Hybrid Architecture, Responsive UI/UX

Work Experience

PT Neural Technologies Indonesia · South Jakarta, Indonesia

Database Engineer Intern (Client: Tier-1 Telco Provider in Indonesia)

Jul 2026 – Present
  • Spearheaded the frontend and full-stack architecture of Superflow, an autonomous BI agent powered by Gemini API, n8n workflow automation, and Apache Superset REST API, proposed for an enterprise-wide Big Data Analytics Platform initiative.
  • Engineered an interactive Agentic Trace Widget in Next.js that visualizes AI multi-step reasoning processes and dynamically renders analytical charts from multi-node database clusters.
  • Optimized 90+ complex SQL/PL-pgSQL stored procedures across 94 enterprise tables and 2,700+ Citus PostgreSQL partitions processing TB-scale telecom records.
  • Automated ETL data pipelines using Apache Airflow and ClickHouse/PyArrow, processing 16.8M+ raw records into compressed Parquet datasets.
Key Projects

SiMona Polban · Integrated Dormitory Operations Platform (Web & Mobile) | Trifur Group

Role: Frontend Lead & Requirement Engineer · Tech: Turborepo, Next.js 15, React 19, TypeScript, MUI v6, NestJS 11, Prisma, PostgreSQL

Jun 2026 – Present
  • Co-authored comprehensive system requirements specifications establishing domain rules for room quotas, ticketing workflows, and multi-role RBAC across 48 units (192 residents).
  • Architected an installable mobile-first PWA for resident interactions, delivering a seamless app-like experience with homescreen prompts and unified Material UI components across device viewports.
  • Developed incident ticketing modules with photo attachments and anonymous reporting toggles, alongside administrative verification dashboards for quarterly rent payments.

NewlyMom · Maternal Mental Health Ecosystem (Web Admin CMS & Mobile App) | Client Project

Role: Frontend Web Lead & Mobile Integrator · Tech: Next.js 16, React 19, TypeScript, Tailwind CSS v4, Recharts, Supabase, Flutter

Feb 2026 – Jun 2026
  • Architected a client backoffice CMS using Next.js App Router and TypeScript to manage user directories, educational content taxonomy, and community forum moderation.
  • Built an analytics dashboard using Recharts to visualize EPDS screening risk distributions, daily mood trends, and system telemetry metrics.
  • Implemented non-blocking API latency logging to Supabase to monitor backend response health, alongside session-secure HTTP-only cookie authentication.
  • Co-developed the Flutter mobile application featuring EPDS depression screening, PIN-protected journaling, and smart recommendation triggers.
Education

Politeknik Negeri Bandung (POLBAN) · Bandung, Indonesia

Bachelor of Applied Science (D4) in Informatics Engineering

Aug 2023 – Aug 2027 (Expected)

Relevant Coursework: Software Analysis & Design, Data Structures & Algorithms, Software Architecture, Web Programming, Database Systems.

Honors & Certifications
  • Japanese Language: JLPT N3 Certified (2022) | Conversational & Daily Communicative Proficiency
  • English Language: Professional Working Proficiency (Technical Documentation & Team Collaboration)
  • 3rd Place Winner: National Japanese Presentation Competition (The Japan Foundation x MoECRT, 2023)
  • 1st Place Winner: KMIPN VII National Polytechnic Informatics Competition (UI/UX Category, 2025)
  • Top 10 National Finalist: Samsung Innovation Campus Batch 7 (2026)
  • Finalist (Top 20): Gemastik XIX Data Mining Competition (Puspresnas / MoECRT, 2026)
  • Former President: Nihongo Kurabu (Japanese Language & Culture Club, 2021 – 2023)