Edgar's Portfolio

Automated Economic Indicator Dashboard

PythonAWSAirflowTerraformPostgreSQLGlueLooker Studio

Automated data pipeline to track economic indicators over time. Data is ingested from the FRED API, stored in an S3-based data lake, transformed using AWS Glue, and stored in an RDS database. An interactive Looker Studio dashboard visualizes key economic indicators for data-driven decisions.

AWS Data Pipeline: Data ingestion (Glue), transformation (Glue), and storage (S3, RDS) on AWS.
Infrastructure as Code (Terraform): Automated provisioning and management of AWS resources (S3, Glue, RDS, EC2) using Terraform.
Workflow Orchestration (Airflow): Automated data pipeline management and regular updates using Apache Airflow on EC2.

GitHub

Screenshot of Automated Economic Indicator Dashboard website

Apache Superset (Open Source Contributor)

TypeScriptReactJestCypressPythonFlaskCelery

Apache Superset is an open source Data Visualization and Data Exploration Platform

Screenshot Generation: Developed RESTful API endpoints for generating screenshots, allowing users to share different dashboard states
Accessibility: Improved accessibility for users with disabilities by implementing proper HTML semantics for clickable elements
User and Developer Experience: Collaborated with the Project Management Committee to improve project quality and developer experience

GitHub Live Website

Screenshot of Apache Superset (Open Source Contributor) website

Lucky Parking (Open Source Contributor)

TypeScriptNode.jsExpress.jsReactMongoDB

Visualization of parking data to assist in understanding of the effects of parking policies on a neighborhood by neighborhood basis in the City of Los Angeles

MongoDB Client: Implemented a MongoDB client to enable efficient storage and retrieval of 17 million parking citation records from LADOT
MapBox API Integration: Merged custom data for 99 neighborhood councils with existing Mapbox API data to create more comprehensive search results
Cross-functional Teamwork: Partnered with Product, Data Science, and UX to ensure software solutions aligned with the organization's civic tech objectives

GitHub Live Website

Screenshot of Lucky Parking (Open Source Contributor) website

Haus

JavaScriptPythonReactReduxFlaskHTML5CSS3SQLAlchemySQLite3PostgreSQL

A real estate marketplace web app where users can browse home listings, schedule tours, and make offers

Cloud Storage: Optimized listing image uploads with AWS S3, resulting in a scalable storage and retrieval process for thousands of home images
Google Maps Support: Integrated Google Maps API to dynamically display home locations using user-submitted geo-coordinates
Flask/PostgreSQL Backend: Implemented a Flask backend with SQLAlchemy, ensuring efficient user authentication, seamless database operations, and rapid server-side routing

GitHub Live Website

Harmonious Voices (Team Project)

JavaScriptPythonReactReduxFlaskHTML5CSS3SQLAlchemySQLite3PostgreSQL

A messaging web app where users can form and join interest-based online communities

WebSockets Integration: Incorporated WebSockets to offer users an instant messaging experience
Streamlined Messaging Experience: Reduced messaging feature development time by 50% with a versatile component for direct and channel messaging
User-Centered Design: Leveraged React state and event handlers to enable hover actions for modifying and deleting user messages

GitHub

Screenshot of Harmonious Voices (Team Project) website

Software Engineer

Projects

Automated Economic Indicator Dashboard

Apache Superset (Open Source Contributor)

Lucky Parking (Open Source Contributor)

Haus

Harmonious Voices (Team Project)

Skills

Data Engineering & Analysis

Languages

Data Pipelines/ETL

Databases

Cloud/DevOps

Web Development

Languages

Backend

Frontend

Testing/QA

Contact