Farrel Zandra
Frontend & Full-Stack Engineer
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
PT Neural Technologies Indonesia · South Jakarta, Indonesia
Database Engineer Intern (Client: Tier-1 Telco Provider in Indonesia)
- 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.
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
- 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
- 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.
Politeknik Negeri Bandung (POLBAN) · Bandung, Indonesia
Bachelor of Applied Science (D4) in Informatics Engineering
Relevant Coursework: Software Analysis & Design, Data Structures & Algorithms, Software Architecture, Web Programming, Database Systems.
- 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)