PILY CT

Hi, I'm Pily

A Full-Stack developer with a background rooted in data.

I build web products with TypeScript, React and Python, and lately I’m exploring AI and LLM agents.

GET IN TOUCH

DATAFULL-STACKAIFIG. 02 OVERLAPIDEABUILDTESTSHIPFIG. 03 NETWORKFIG. 04 TRENDVISITORPILYHELLO AMIGOREPLYFIG. 05 SEQUENCE

AUTOPLAY · PAUSE TO STOP

01 / 05 HERO

About.

From dashboards to products

I started out turning raw data into dashboards that helped teams understand their data and make decisions. I wrote Python scripts, queried databases with SQL and built the dashboards in Tableau and Power BI. My favourite part was the moment someone read a chart and knew what to do next.

I still care about that, and about how the product feels to use. Over time I wanted to own more of what came after the chart: the product around it.

Now I build Full-Stack applications with TypeScript, React and Python. I like learning across the whole stack, and lately that includes AI, from LLM agents to how they fit into real products.

You can see how I think, build and ship in the Projects section.

NAME
Pilar Cuéllar Taracido (Pily)
OPEN TO
Full-Stack · Data · AI roles
BASED IN
Berlin, Germany
LANGUAGES
Spanish (Native), English (C1), German (B1)
USING TODAY
  • TypeScript
  • React
  • Next.js
  • Python
  • FastAPI
  • PostgreSQL
LEARNING
  • LLM APIs
  • Vector databases
  • Evaluation

02 / 05 ABOUT

Projects.

Curious first, then built.

Things I’ve built to learn, to solve a problem, or both. Some on my own, some with a team. Select a project to see the details.

Projects
No.ProjectTrackStackYearLinks
01Document Memory Agent

A RAG assistant that answers questions about your documents with cited sources, running free on a local model and measured by its own eval.

AI
  • Python
  • smolagents
  • Ollama
  • Streamlit
  • SQLite
  • BM25
  • pytest
2025
02Finderella

Map of Berlin cafés scored for laptop work by an LLM tool-use agent. I built the Apify review-selection pipeline and now develop the React frontend.

AIFull-Stack
  • React
  • TypeScript
  • MapLibre
  • FastAPI
  • LLM API
  • Apify
  • Supabase
2026
03Berlin Short-Term Rentals

dbt + DuckDB pipeline on Inside Airbnb data measuring host concentration and registration-number coverage across Berlin's 12 districts.

Data
  • dbt Core
  • DuckDB
  • Python
  • SQL
2026
04Cosmica

An editorial reader for NASA's Astronomy Picture of the Day, with the full archive since 1995 and a frontend that stays up when NASA's API doesn't.

Full-Stack
  • Next.js
  • React
  • TypeScript
  • TanStack Query
  • Zod
  • Upstash Redis
  • Tailwind CSS
  • Vitest
2026
05Data Fixer

A web app where signed-in users upload a CSV, preview it with incomplete rows removed, and download the cleaned file.

Full-StackData
  • React
  • TypeScript
  • Python
  • Flask
  • SQLite
2024
06Quotes Scraper

A Python ETL that scrapes 100 quotes and 50 author bios from Quotes to Scrape, joins them and loads one PostgreSQL table, with mocked unit tests.

Data
  • Python
  • Requests
  • BeautifulSoup
  • pandas
  • SQLAlchemy
  • PostgreSQL
  • pytest
2024
07EVAPP

A ride-sharing mobile app: passengers find trips, book seats and pay in credits held until the driver accepts.

Full-Stack
  • React Native
  • Expo
  • TypeScript
  • Node.js
  • Express
  • MongoDB
  • Vercel
2023
08NimbusCast

A weather app that pairs live forecasts for any city with a poem matched to its sky. React front end, Express API on Vercel serverless.

Full-Stack
  • React
  • TypeScript
  • Express
  • Vercel
  • Tailwind CSS
2023

8 of 8 projects

03 / 05 PROJECTS

Experience.

The path behind the projects.

Data first, software next. Here’s how the two fit together.

FIG. 04A CAREER PATH
  • Data: Feb 2019 to Mar 2023, and May 2025 to Present
  • Full-Stack: Nov 2023 to Present
  • AI: Oct 2024 to Present
Experience
Period / LocationRole / CompanyOutcomesStack
HMay 2026 to PresentBerlin, GermanyFull-Stack Developer (Volunteer)Finderella
  • Full-Stack
  • AI
Case study
  • Designed the FastAPI review-selection pipeline (Apify to FastAPI): fetches up to 35 reviews per venue and picks the 15 most relevant by keyword prioritisation plus recency before the scoring agent.
+ 2 more outcomes− Fewer outcomes
  • Joined a team of 9 volunteers; now the only developer on the React frontend, working directly with the project owner on features, debugging and new parts of the app.
  • Built the venue details view, showing AI-generated venue scores (Wi-Fi, noise, laptop- and group-friendliness) synthesised from Google Maps, Reddit and other review sources.
  • TypeScript
  • Vite
  • FastAPI
  • Supabase
GMay 2025 to PresentBerlin, GermanyIndependent Study & ProjectsSelf-directed
  • Full-Stack
  • AI
  • Data
  • Built a RAG-based AI agent with smolagents and Streamlit: BM25 retrieval, SQLite-backed local memory and answer caching for near-zero-cost operation.
+ 2 more outcomes− Fewer outcomes
  • Covered it with a full Pytest suite and deployed it live on Streamlit Cloud.
  • Built a dbt + DuckDB analytics pipeline on public data.
  • Python
  • RAG
  • AI Agents
  • Smolagents
FOct 2024 to May 2025Remote, GermanyFounding EngineerScavenger AI
  • Full-Stack
  • AI
  • Owned product quality and testing across the stack: an automated Pactum.js suite covering ~130 API endpoints, run in GitHub Actions on prod and dev branches with a failure report after every update, plus a company-wide manual QA suite in Excel.
+ 2 more outcomes− Fewer outcomes
  • Built a Next.js/TypeScript dashboard feature letting users save and revisit favourite responses from the chat interface, plus bug fixes and new API integrations across the frontend.
  • Started the app's technical documentation, including acceptance criteria and decision logs. One of 4 engineers in an 8-9 person startup.
  • TypeScript
  • Next.js
  • FastAPI
  • PostgreSQL
  • AWS
ENov 2023 to Apr 2024Berlin, GermanyFull-Stack Developer (Codeworks Capstone)EVAPP
  • Full-Stack
Case study
  • Built User Profile, Live Chat and Add Credits features in React Native (Expo), Node.js/Express.js and MongoDB, in a 4-person team.
+ 1 more outcome− Fewer outcomes
  • Designed RESTful backend routes with Express.js for frontend-backend communication.
  • TypeScript
  • React Native
  • Express.js
  • MongoDB
DNov 2021 to Mar 2023Berlin, GermanyData ScientistLooping Group
  • Data
  • Replaced daily manual pipeline monitoring with an automated Python/SQL process requiring only a weekly health check.
+ 2 more outcomes− Fewer outcomes
  • Designed and maintained BI dashboards (Tableau and Power BI) and ETL pipelines for DAX 30 enterprise clients (7+ dashboards delivered).
  • Led Tableau training for a 3-person analytics team and co-authored the dashboard style guide, adopted as the team-wide standard.
  • Python
  • SQL
  • Azure
  • Tableau
  • Power BI
CNov 2019 to Nov 2021Berlin, GermanyJunior Data ScientistLooping Group
  • Data
  • Supported data integration and automation on Microsoft Azure: Blob Storage for .csv data and documentation, a database kept current by Azure WebJobs, and Azure Functions orchestrated via Data Factory.
+ 2 more outcomes− Fewer outcomes
  • Built dashboards and reports with Tableau, SQL and Power BI, helping enterprise clients make data-driven decisions.
  • Cleaned and validated multi-source datasets in Python and R; delivered the resulting dashboards in Shiny for stakeholder review.
  • Power BI
  • Tableau
  • R Shiny
  • Python
BMay 2019 to Nov 2019Berlin, GermanyData Science Intern (Associate Data)Looping Group
  • Data
  • Supported data analysis, sentiment analysis, and reporting with R, Excel, and PowerPoint.
  • R
  • Excel
  • PowerPoint
  • Sentiment Analysis
AFeb 2019 to Mar 2019Berlin, GermanyData Science Intern (Trainee Final Project)YUKKA Lab AG
  • Data
  • Worked on sentiment analysis and NLP techniques, including topic modelling with LDA, as the final project of the Data Analysis & Machine Learning trainee program.
  • Python
  • R
  • NLP

04 / 05 EXPERIENCE

Contact.

Got a project or a role in mind?Let’s talk about what you’re building.

Whether it’s a role, a freelance project or just an idea, I’d love to hear about it. Tell me a bit about what you’re working on and what you need, and I’ll get back to you as soon as I can. Thanks for stopping by.

STATUS
Open to workAvailable at short notice
TIME ZONE
Berlin (CET/CEST)
WORKS
Remote / hybrid
© 2026 PILY CT

05 / 05 CONTACT