Full-Stack Developer | Data Analytics & AI | Business-Oriented Web Solutions
Modern web systems for businesses that need clarity, speed, and practical results.
I build websites, web applications, APIs, dashboards, and automation tools that connect clean user experience with real business value.
About
A Colombian developer in Pittsburgh with a business, software, and leadership background.
I am Juan Barrera, a Colombian developer based in Pittsburgh, Pennsylvania. I double majored in Computer Science and Business Management and I am currently completing a master's degree in Data Analytics and Information Systems at Point Park University.
My background combines technology, business, leadership, athletics, and international experience. I have worked on web applications, business websites, APIs, dashboards, data analytics projects, and technology consulting assignments. I am also a student-athlete, tutor, Resident Assistant, and International Students Club President.
Technical Builder
Business Mindset
Leadership & Discipline
Bilingual: English and Spanish
Services
Digital solutions for businesses, founders, students, and local brands.
Business Websites
Modern, responsive websites for restaurants, service businesses, personal brands, and local companies.
Web Applications
Custom platforms with dashboards, portals, forms, user flows, and data management.
Automation Tools
Workflow systems that reduce repetitive work and organize business information.
Data Dashboards
Reports and visualizations that help businesses understand performance and make decisions.
Backend & APIs
REST APIs, database-backed systems, integrations, and scalable backend logic.
Portfolio Websites
Personal websites for professionals, athletes, students, and entrepreneurs.
Selected Work
Projects focused on users, operations, and useful data.
Featured Project
Full-Stack Tutoring Management Platform
A role-based tutoring platform for scheduling, student dashboards, tutor dashboards, assigned modules, and contact workflows.
- Problem
- Organizes tutoring operations across students, parents, and tutors.
- Role
- Full-stack developer focused on product flow, UI structure, and dashboards.
Featured Project
Restaurants CRUD Application
A deployed full-stack restaurant management application with frontend, backend API, and PostgreSQL database.
- Problem
- Demonstrates dependable CRUD operations and API communication.
- Role
- Built frontend, backend routes, database flow, and deployment setup.
Featured Project
Trackeo
A sports analytics data platform concept for athlete, competition, performance, filtering, and reporting workflows.
- Problem
- Turns scattered performance data into structured information.
- Role
- Designed the data model, backend concepts, and analytics workflow.
Web App
Picklers App
A pickleball results platform focused on structured match data, usability, testing, backend consistency, and real user interaction.
- Problem
- Keeps match results consistent, usable, and easier to manage.
- Role
- Worked across frontend interaction, backend logic, testing, and UX refinement.
Client Website
Efficiency Appliance Services Website
A responsive business website for a Pittsburgh service company, focused on mobile usability and client communication.
- Problem
- Creates a clearer digital presence for a local service business.
- Role
- Designed and developed responsive structure, content flow, and user path.
AI Project
AI Campus Simulation
An AI-powered campus simulation with interactive agents, time slots, agent types, and an Ask the Agent interface.
- Problem
- Makes campus behavior and agent interaction easier to explore.
- Role
- Connected frontend interaction with AI and Python-backed simulation concepts.
Academic Platform
MIS510 Statistics Learning Website
A custom academic website for chapters, Excel work, quizzes, explanations, and structured statistics materials.
- Problem
- Turns course content into a structured digital learning experience.
- Role
- Built the website structure, learning pages, and supporting interactions.
Analytics
Data Analytics & Dashboard Projects
A collection of analytics projects involving Excel dashboards, R models, business intelligence, reporting, and data mining.
- Problem
- Transforms raw data into clearer insights for decision-making.
- Role
- Cleaned data, built reports, and designed dashboard views.
Capabilities
Technical skills with a practical business lens.
Frontend
HTML, CSS, JavaScript, TypeScript, React, Tailwind CSS, Material UI, UI/UX, animations, responsive design.
Backend
Node.js, Express.js, Flask, REST APIs, PostgreSQL, SQL, NoSQL, backend logic, authentication concepts.
Data & Analytics
Python, pandas, Excel, Tableau, Power BI, data cleaning, dashboards, reporting, and visualization.
Workflow
Git, GitHub, Netlify, Render, Postman, VS Code, deployment, debugging, testing, and documentation.
Experience
Work shaped by tutoring, residence life, leadership, and athletics.
Tutor, Point Park University
Tutored students in programming, data structures, debugging, technical concepts, and academic problem solving.
Summer Resident Assistant, Pre-College Programs
Supported students ages 14 to 17, supervised residential safety, completed night checks, and created activities.
Resident Educator / Resident Educator Mentor
Supported residential students, helped resolve conflicts, mentored peers, and contributed to student life operations.
International Students Club President
Led initiatives to support international students, build community, connect students with resources, and create events.
Student-Athlete, Track & Field
Balanced academics, athletics, leadership, and work while building discipline, resilience, and time management.
SAAC Representative
Represented student-athletes, communicated needs, and contributed to campus athletic leadership.
Education
Point Park University
- Master's in Data Analytics and Information Systems
- Bachelor's in Computer Science and Business Management
More Than Code
Technology, athletics, leadership, and international experience.
I was born and raised in Bucaramanga, Colombia. As a student-athlete and international student in the United States, I have learned to adapt quickly, work under pressure, communicate across cultures, and stay disciplined while managing academics, work, and competitive sports.
Contact
Let's build something useful.
Whether you need a business website, web application, dashboard, automation tool, or stronger digital presence, I would be happy to connect.