Richard Pillaca

Skills & Stack

The languages, tools, and platforms I use to build automated pipelines, software systems, and data models.

Data & Analytics

Translating messy data into clean, automated reporting pipelines. I build solutions that replace hours of manual spreadsheet work with reliable refreshable reports.

Core Stack

SQLPower BI / DAXPython (Pandas, Numpy)Power Query / MExcel (VBA)

Software Engineering

Building full-stack applications with an emphasis on robust backends, continuous integration, and clean user interfaces.

Core Stack

PythonTypeScriptJavaReact / Next.jsDjango

Modeling & Research

Applying statistical methods and graph theory to uncover patterns. From analyzing 5,000+ codebases for technical debt to optimizing city-wide bike share networks.

Core Stack

Graph Theory (NetworkX)SciPyStatistical TestingGeopandas

All Technologies

Core Languages

  • Python
  • SQL
  • TypeScript
  • Java
  • VBA
  • M Language
  • R
  • PHP

Data & DevOps

  • Power BI
  • Excel Advanced
  • Docker
  • GitHub Actions
  • PostgreSQL
  • Firebase
  • Supabase

Frameworks

  • React
  • Next.js
  • Django
  • Tailwind CSS
  • Android Studio

Research & AI

  • Pandas / Numpy
  • NetworkX
  • SciPy
  • Claude MCP
  • Cursor / Windsurf

Certifications

Microsoft Certified: Power BI Data Analyst (PL-300)
Certified Scrum Master (CSM)
Python Institute: Certified Associate