Ekya Muhammad

System Analyst and Full-Stack Developer

I turn ideas and real-world problems into thoughtful, reliable digital products.

System Analyst & Full-Stack Developer focused on high-performance digital systems, workflow automation, and scalable architectures.

About & Engineering Approach

I focus on understanding operational workflows before selecting frameworks. In production, code is only one part of a larger chain: identifying constraints, designing data structures, building APIs, deploying to Linux servers, and maintaining systems over time.

My work combines deep backend development (PostgreSQL optimization, Redis queues, Django, FastAPI), offline-first architectures (SQLite, Flutter), and modern web engineering (TypeScript, React, GSAP).

Selected Work & Case Studies

01 • GitTrace (2026)

Role: Architecture, Core Development & AI Integration • Category: Academic Tool · AI · Git

A student productivity tool that transforms Git history into structured internship logbooks, originally built to reduce the repetitive documentation required during my POLINEMA internship.

Tech Stack: Flutter, Dart, Riverpod, Ollama, DeepSeek, Git CLI

Read complete GitTrace engineering case study →

03 • Resurva (2026)

Role: Backend Architecture & AI Integration • Category: Backend Systems & AI Agents

Modular monolith FastAPI backend across 18 domain modules, featuring FEFO batch inventory deduction, escrow wallet transactions, real-time SSE streaming, and a 12-tool MCP AI orchestrator.

Tech Stack: FastAPI, Python, PostgreSQL, MCP, SQLAlchemy, SSE, AI Integration

Read complete Resurva engineering case study →

Work Experience

Software Developer Intern — PT Surabaya Autocomp Indonesia (Yazaki Group · Japan)

2026-01-01 – Present | On-site (Internship)

Building and maintaining internal operational software across Production Planning Control (PPC) and Inventory Control (IC), with end-to-end ownership spanning requirement discussions, UI and backend architecture, data-heavy optimizations, and manual Linux server deployment.

  • Collaborate directly with department supervisors to translate operational challenges into functional UI flows, backend architecture, and database designs.
  • Manage end-to-end delivery across 8 internal projects: building 4 greenfield applications, executing 1 major Laravel-to-Django refactor, and actively maintaining 3 production systems.
  • Engineered high-volume data processing workflows for a ~10K-row wide Excel master dataset (extending to column BIS) merged with ~5K operational rows, introducing Redis-backed processing and parallel execution to keep operations responsive.
  • Investigated database connection bottlenecks across multiple internal applications experiencing request timeouts, presenting PgBouncer as a prospective connection-pooling strategy while evaluating broader PostgreSQL optimization approaches.
  • Took internal applications from development through manual deployment on Ubuntu servers, handling Nginx reverse proxy configuration, systemd service setup, and production troubleshooting.

Technologies: Django, React, PostgreSQL, Redis, Nginx, Ubuntu Server

Freelance Software Developer — NexaCode

2025-12-27 – Present | Remote (Freelance)

Building custom cross-platform software, web applications, and standalone product solutions independently—handling requirement discovery, architecture design, frontend/backend implementation, and iterative client delivery.

  • Work directly with freelance clients to discover business requirements, design software architecture, and deliver cross-platform mobile/desktop apps and web solutions.
  • Architected a local-first offline Point of Sale (POS) application engineered to reliably index and query millions of records locally using SQLite without cloud dependence.
  • Engineered a token-based activation mechanism with a lightweight FastAPI backend (hosted on Vercel) to manage and authorize offline POS installations across client hardware.

Technologies: Flutter, Next.js, FastAPI, SQLite, Tailwind CSS, TypeScript

Technical Toolbox & Capabilities

Backend & APIs

Primary: Django, FastAPI, Laravel, REST APIs

Supporting & Tooling: SQLAlchemy, Alembic, JWT

Frontend & Web

Primary: React, Next.js, Astro, Tailwind CSS

Supporting & Tooling: TypeScript, GSAP

Mobile & Desktop Systems

Primary: Flutter, Dart, Riverpod

Supporting & Tooling: Process CLI, diff_match_patch

Data & Storage

Primary: PostgreSQL, Redis, SQLite

Supporting & Tooling: Connection Pooling (PgBouncer evaluation)

Infrastructure & Linux

Primary: Ubuntu Server, Nginx, systemd, Git

Supporting & Tooling: GitHub Actions

AI Integration

Primary: Ollama, LLM APIs, DeepSeek, MCP

Supporting & Tooling: Prompt & Context Engineering

Verified Milestones & Achievements

KMIPN VIII 2026 — Carbon Market Pilot Platform (2026-09)

Result: 2nd Place — Poster (E-Government Category) | Scope: national

Organizer: Politeknik Negeri Lampung (Host) / Bakorma

Developed a pilot carbon-market platform exploring blockchain-based tokenization and transparent transaction records, with Isolation Forest used to detect anomalous transaction patterns.

BytesFest Hackathon 2026 (2026-07)

Result: Top 15 Finalist — Hackathon | Scope: national

Organizer: HMP MIKROPTIK, FKIP Universitas Sebelas Maret (UNS)

Advanced the surplus-food marketplace concept under competition constraints, implementing additional cases within roughly eight hours and reaching the finalist stage.

UNS Certificate Verification →

Intercomp & PLAY IT! 2026 (2026-06)

Result: 1st Place (Intercomp) & 3rd Place Best Solver (PLAY IT!) | Scope: internal

Organizer: Jurusan Teknologi Informasi, Politeknik Negeri Malang

Double milestone in June 2026 competing under Team "Kata Juan Penting Jadi" (a humorous alias for our NexaCode team): won 1st Place in Web Development with a surplus-food marketplace ecosystem, and 3rd Place Best Solver in a one-day company attendance hackathon.

Ceriaku — KMIPN VII & PBL Expo (2025-10)

Result: 2nd Place (KMIPN VII) & Product Showcase (PBL Expo) | Scope: national

Organizer: Politeknik Negeri Padang (KMIPN) & Politeknik Negeri Malang (PBL Expo)

Mobile developer for Ceriaku, an assistive communication prototype for children with autism — progressing from a national 2nd Place award at KMIPN VII to live interactive demonstrations at Polinema’s PBL Expo.

Intercomp 2024 — English News Casting (2024-04)

Result: Juara Harapan 2 — English News Casting | Scope: internal

Organizer: Jurusan Teknologi Informasi, Politeknik Negeri Malang

Achieved Juara Harapan 2 in the campus-wide English News Casting competition, an early milestone that strengthened my confidence in structured communication and presentation.

Articles & Engineering Reflections

When PostgreSQL Became the Problem

Category: Backend & Database • Published: 2026-08-18 • 7 min read

A production investigation into connection pressure, Django's connection behavior, and the trade-offs behind introducing PgBouncer.

Read article →

Git Is More Than Version Control

Category: AI & Developer Tools • Published: 2026-08-25 • 6 min read

What happens when commit history is treated not only as version control, but as source material for a project's development memory.

Read article →

The Architecture I Actually Need

Category: Architecture • Published: 2026-09-02 • 6 min read

Why architecture should be justified by the problem, the team, and the constraints—not by how many technologies appear in the diagram.

Read article →

Browse full article archive →

Contact & Profiles

Feel free to reach out directly regarding engineering collaborations, backend architecture, or system analysis: