Skip to content
FP
es

Available for new projects

Franco Jhoel Parra Aguilar

Software DeveloperIT Technical Support

I build web, mobile and desktop applications end to end — interface, API and database.

View projectsDownload CVPDF · Spanish
francoparra70@gmail.comgithub.com/SkyWing3La Paz, Bolivia
15
Olympiad medals7 gold · 3 silver · 3 bronze · 2 honorable mentions
3+
Years buildingClient projects since 2023
9
Featured projectsWeb, mobile, simulation and APIs
B2
EnglishUpper intermediate · Native Spanish

Technologies I work with

  • TypeScript
  • React
  • Next.js
  • Angular
  • Flutter
  • NestJS
  • Laravel
  • Django
  • Prisma
  • PostgreSQL
  • Three.js
  • C++
  • Python
  • Docker
01
About

From olympiads to production software

I started programming by competing. Between 2018 and 2023 I went through fifteen national and international Computer Science and Robotics olympiads and came back with fifteen medals — seven of them gold. That stage left me something I still use every day: the habit of breaking a problem down until it becomes solvable, and of judging a solution by its real cost rather than its looks.

Since 2023 I have been building software independently for private clients. I own the full cycle: gathering requirements, designing the data model, writing the backend and the interface, deploying and maintaining. I have delivered everything from a statistically validated agent-based simulation to an LMS with microservices, a Laravel + Inertia e-commerce platform and Flutter mobile apps.

In parallel I work at the Computing Center of Universidad Católica Boliviana, where I resolve hardware and software incidents, administer labs and configure network equipment. It is the practical counterweight to code: understanding the machine and the network your software actually runs on.

02
Projects

Selected work

Nine projects spanning simulation, education platforms, e-commerce, mobile apps and APIs. Each one states the problem it solves, its architecture and the outcome.

01FeaturedFinal project · SIS-216, UCB2026

Mi Teleférico — Agent-based simulation

Statistically validated queueing model of the Red Line, with a 3D web twin

Simulation of passenger flow through the La Paz–El Alto cable car system using agent-based modelling. The model reproduces the three real stations of the Red Line as a queueing system with origin→destination routing, and was validated against twelve field measurement sessions. On top of it I built a 3D web simulation where each passenger picks a destination, boards a cabin and gets off at their station.

Highlights

  • Validated with a Welch t-test over 30 runs: p = 0.932 against real-world data, so the null hypothesis holds and the model is considered reliable.
  • BehaviorSpace experiments pinpointed the saturation point: opening a third ticket booth per station cuts total waiting time by 36% (~18s to ~11s); a fourth adds nothing.
  • 3D web twin with React Three Fiber: cable, cabins and agents rendered in real time over the line's actual topology.
  • Reproducible Python analysis (pandas + SciPy) that regenerates the validation from the field and simulation CSVs.
  • NetLogo
  • BehaviorSpace
  • Python
  • Next.js
  • React Three Fiber
  • Three.js
View code
02FeaturedPersonal project2025

LMS — Learning Management System

Next.js as a BFF plus two NestJS microservices for files and email

A complete academic management platform: courses, enrolments, materials, assignments, submissions, exams with a question bank and a gradebook. The architecture is deliberately hybrid — Next.js handles the interface and business logic as a backend-for-frontend through Server Actions, while the concerns worth isolating (file storage and email notifications) live in independent NestJS microservices.

Highlights

  • Twelve-entity Prisma data model: users, courses, enrolments, assignments, submissions, materials, exams, questions, options, results, answers and a system audit log.
  • Authentication with JWT sessions signed via jose and bcrypt-hashed passwords, with role-based access control (admin, teacher, student).
  • Email microservice that fires welcome and grade-published notifications; upload microservice that centralises file storage and delivery.
  • Mutations through Server Actions instead of an intermediate REST layer, removing the glue code between client and server.
  • Next.js 16
  • React 19
  • TypeScript
  • NestJS
  • Prisma
  • SQLite
  • Tailwind CSS
View code
03FeaturedClient project2025

Rincón Creativo — Online store

E-commerce with Laravel and Inertia: catalogue, orders and admin panel

An online store with a public catalogue, cart, registration with email verification and checkout, plus an internal panel where the team manages products, categories, orders and user roles. It is built on Inertia.js, which lets the interface be written in React without giving up Laravel's routing and authorisation: a single application, with no intermediate API to keep in sync.

Highlights

  • Relational model of products, categories, orders and order lines with Eloquent, on top of versioned migrations.
  • Authentication with Laravel Breeze and Sanctum, mandatory email verification and role changes from the admin panel.
  • Full products and categories CRUD protected by middleware, with admin routes kept separate from the public catalogue.
  • React frontend with Tailwind CSS, Headless UI and Framer Motion, typed with TypeScript and bundled by Vite.
  • Laravel 12
  • PHP 8.2
  • Inertia.js
  • React
  • TypeScript
  • Tailwind CSS
  • Vite
View code
04FeaturedPersonal project2026

Diario Minimalista — Block-editor blog

React SPA with a NestJS API, PostgreSQL and Notion-style editing

A Markdown writing and publishing app designed around the writing experience rather than the admin panel. The editor is block-based — slash commands, drag and reorder — and the reading view renders Markdown with GFM support. Behind it sits a NestJS REST API with Prisma 7 over PostgreSQL, kept separate from the frontend so each can evolve on its own.

Highlights

  • BlockNote WYSIWYG editor fully translated into Spanish, with slash commands and reorderable blocks.
  • NestJS 11 API with Prisma 7 and the native PostgreSQL adapter, with migrations and strongly typed queries.
  • React 19 frontend on Vite with React Router 7, Tailwind CSS 4 and HeroUI; safe Markdown rendering with react-markdown and remark-gfm.
  • React 19
  • Vite
  • NestJS 11
  • Prisma 7
  • PostgreSQL
  • Tailwind CSS 4
  • BlockNote
View code
05Personal project2026

Interactive Curriculum Planner

Degree map with a prerequisite graph and per-student progress tracking

A tool for students to visualise their full degree map and plan the semester. Each course declares its prerequisites, so the app resolves the dependency graph and shows what can be taken now, what is blocked and why. Progress is stored per user, with individual accounts and email password recovery.

Highlights

  • Per-course prerequisite graph resolution, with individual state (passed, in progress, available, locked) persisted per user.
  • Custom authentication with JWT and bcrypt, plus a full token-based password recovery flow with Nodemailer delivery.
  • Interface with Framer Motion transitions on Next.js 16 and React 19, persisted through Prisma.
  • Next.js 16
  • React 19
  • TypeScript
  • Prisma
  • JWT
  • Nodemailer
  • Framer Motion
View code
06Client project2026

Water Meter

Flutter mobile app with a Laravel 13 API authenticated through Sanctum tokens

A system for recording and consulting water meter readings from a phone, aimed at field staff who walk the connections. The mobile app is written in Flutter with a layered architecture, and consumes a versioned Laravel 13 REST API that issues Sanctum access tokens to authenticate each device.

Highlights

  • Versioned REST API (/api/v1) with register, login, logout and profile endpoints, protected by the auth:sanctum guard.
  • Flutter client organised into core and presentation layers, with navigation and state kept separate from HTTP communication.
  • Backend on Laravel 13 and PHP 8.3, with PHPUnit 12 tests configured and consistent formatting via Pint.
  • Flutter
  • Dart
  • Laravel 13
  • PHP 8.3
  • Sanctum
  • REST
View code
07Client project2025

Public Transport Routes Admin

Django REST API and map editor for drawing routes, stops and schedules

An admin portal for drawing the routes of a public transport application on a map: itineraries are traced point by point, stops are assigned and per-day schedules attached. The data model keeps route, stop, coordinate and schedule as separate entities joined by intermediate tables, so one stop can belong to several routes and one route can run different schedules depending on the day.

Highlights

  • Nine related Django ORM models with timestamps inherited from an abstract base model, including notifications for an affected route and its fallback route.
  • REST API with separate endpoints for routes, stops, coordinates, stop-route relations, schedules and days.
  • In-browser map editor served by Node.js, where the itinerary is recorded as an ordered sequence of coordinates.
  • Django
  • Django REST Framework
  • Python
  • SQLite
  • Node.js
  • JavaScript
View code
08Academic project2025

Viajero — Graph editor with a genetic algorithm

Flutter app that solves the travelling salesman problem on a hand-drawn graph

A desktop and mobile app where the user draws a graph on a canvas — nodes, edges and weights — and the app searches for the shortest tour visiting every node, solving the travelling salesman problem with a genetic algorithm. The problem is NP-hard, so instead of exhaustive search it applies a metaheuristic: a population of candidate tours, selection, crossover and mutation across generations.

Highlights

  • Custom genetic solver written in Dart, with tour representation, crossover and mutation operators and fitness by tour length.
  • Interactive canvas with CustomPainter: creating, dragging and editing nodes and edges with weight dialogs.
  • A single codebase that compiles to Android, iOS, web, Windows, macOS and Linux.
  • Flutter
  • Dart
  • Algoritmos genéticos
  • CustomPainter
View code
09Personal project2025

Bicentennial Timeline

Django backend with multimedia and an interactive React timeline

An interactive walkthrough of two hundred years of Bolivian history. The Django backend exposes milestones and their associated multimedia through a REST API, and the React frontend presents them as a navigable timeline where each event expands with its context and images.

Highlights

  • Separate Django multimedia app to manage the assets attached to each milestone.
  • React 19 frontend with Tailwind CSS 4, with timeline and event components decoupled from the data layer.
  • API consumption through a centralised Axios service, so the data source can be swapped in a single place.
  • Django
  • Python
  • React 19
  • Vite
  • Tailwind CSS 4
  • Axios
View code
See all 15 repositories on GitHub
03
Experience

Professional track record

  1. Technical Support — Information Technology Department

    Aug. 2025 — Present

    Computing Center · Universidad Católica Boliviana San Pablo

    • Handling and resolving hardware and software incidents reported by campus users.
    • Installing, configuring and updating operating systems, drivers and utility software.
    • Preventive and corrective maintenance of desktops, laptops and peripherals.
    • Supporting network equipment configuration and computer lab administration.
    • Windows
    • Linux
    • macOS
    • Redes
    • Hardware
    • Virtualización

  2. Independent Software Developer

    Jul. 2023 — Present

    Self-employed · Projects for private clients

    • End-to-end development of web, mobile and desktop applications, backend included.
    • Design and implementation of APIs, business logic and data persistence.
    • Full project lifecycle ownership: requirements gathering, development, testing, deployment and maintenance.
    • Direct client communication to define scope, deadlines and deliverables.
    • Next.js
    • React
    • Flutter
    • NestJS
    • Laravel
    • Django
    • PostgreSQL
04
Skills

What I work with

Development

Web, mobile and desktop applications with their own backend.

  • React and Next.js
  • Angular
  • Flutter and Dart
  • NestJS and microservices
  • Laravel and Django
  • TypeScript, C++ and Python
  • Algorithms and data structures
  • Prisma, PostgreSQL and SQLite

Support and hardware

Assembling, diagnosing and maintaining computer equipment.

  • Assembling and installing machines
  • Diagnosing hardware and software faults
  • Preventive and corrective maintenance
  • BIOS/UEFI configuration
  • Formatting, partitioning and data recovery
  • Peripheral configuration

Systems and virtualisation

Fluent across all three desktop operating systems.

  • Windows, Linux and macOS
  • Operating system installation and configuration
  • Basic system administration
  • Driver and utility installation
  • VirtualBox and VMware

Networking and infrastructure

From home cabling to cybersecurity fundamentals.

  • Home and office networks
  • Router and repeater configuration
  • Local servers
  • IoT device integration
  • Cisco Packet Tracer
  • Cybersecurity fundamentals

Cloud and collaboration

Cloud platforms and team collaboration tooling.

  • Git and GitHub
  • Cloud deployment platforms
  • Team collaboration tools

Competencies and languages

How I work, and in which languages.

  • Technical analysis and problem solving
  • Fast learning of new technologies
  • Autonomy and accountability
  • Communication with users and clients
  • Spanish — native
  • English — B2 upper intermediate
05
Awards

Fifteen medals across fifteen competitions

National and international Computer Science and Robotics olympiads between 2018 and 2023.

Gold
7
Silver
3
Bronze
3
Honorable mention
2
2023

  • 11th Bolivian Plurinational Student Science Olympiad

    RoboticsMinisterio de EducaciónJul. 2023

    Gold

  • 11th Bolivian Plurinational Student Science Olympiad

    Computer ScienceMinisterio de EducaciónJul. 2023

    Honorable mention
2022

  • San Andrés Science Olympiad 2022

    Computer ScienceUMSADec. 2022

    Silver

  • School Science Olympiad 2022

    Computer ScienceUMSASep. 2022

    Gold

  • 10th Bolivian Plurinational Student Science Olympiad

    Computer ScienceMinisterio de EducaciónMay 2022

    Bronze
2021

  • 26th Mexican Informatics Olympiad

    Computer ScienceComité Mexicano de InformáticaSep. 2021International

    Bronze

  • School Science Olympiad 2021

    Computer ScienceUMSAAug. 2021

    Gold

  • Bolivian Science Olympiad 2020

    Computer ScienceUMSAFeb. 2021

    Honorable mention
2020

  • Emprenday Latin America Challenge — Season 2

    Computer ScienceSOLACYTNov. 2020International

    Bronze

  • School Science Olympiad 2020

    Computer ScienceUMSASep. 2020

    Silver

  • 14th Latin American Student Science Project Contest

    RoboticsSOLACYTFeb. 2020International

    Gold
2019

  • Mexican Technology Olympiad — Bolivia National Stage «Iatronics»

    RoboticsChemy-RobSep. 2019International

    Gold

  • Robotic Battle Competition

    RoboticsIEEESep. 2019

    Gold

  • 1st BALLIVIANITOBOT National Robotics Contest

    RoboticsIatronicsAug. 2019

    Gold
2018

  • 8th Bolivian Plurinational Student Science Olympiad

    RoboticsMinisterio de EducaciónNov. 2018

    Silver
06
Education

Academic background and certifications

Academic background

  1. Systems Engineering

    Universidad Católica Boliviana San Pablo

    Aug. 2023 — Present

  2. Computer Science

    Universidad Mayor de San Andrés (UMSA)

    Feb. 2023 — Jun. 2023

  3. Preparatory Education

    San Francisco de la Tercera Orden

    Feb. 2021 — Dec. 2022

  4. Bilingual Primary and Secondary Education

    Instituto Americano

    Feb. 2011 — Dec. 2020

Continued education

  • Development, networking and cybersecurity

    Introduction to Cisco Packet TracerCisco Networking Academy
    Jun. 2026
  • Introduction to CybersecurityCisco Networking Academy
    Jun. 2026
  • Microservices with NestJSInnova Code
    May 2026 — Jun. 2026
  • Mobile Application Development with FlutterBlumbit
    Mar. 2026 — Apr. 2026
  • Frontend Web Development with AngularBlumbit
    Feb. 2026 — Apr. 2026
  • Frontend Web Development with React/NextBlumbit
    Nov. 2025 — Jan. 2026
07
Contact

Let's talk about your next project

I'm open to internships, junior roles and freelance projects. I reply by email within 24 hours.

francoparra70@gmail.comDownload CV

Professional reference

Ing. Edgar Callisaya

Head of the Computing Center · Universidad Católica Boliviana San Pablo

+51 940 180 206