Software Engineer
Data Engineer
Data Analyst

I'm Ed. My expertise spans full-stack web development, data engineering, and data analysis.

My background in accounting and finance across real estate, media & entertainment, and e-commerce provides a strong foundation for understanding business needs and translating them into technical solutions.

I'm actively seeking new opportunities. Contact me via email or LinkedIn, and let's discuss how I can add value to your organization.

Projects

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.
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
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
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
Screenshot of Haus 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
Screenshot of Harmonious Voices (Team Project) website

Skills

Data Engineering & Analysis

Languages

PythonSQL

Data Pipelines/ETL

PandasOpenpyxlAirflowAWS Glue

Databases

PostgreSQLSQLAlchemy

Cloud/DevOps

AWS (S3, RDS, EC2, Glue)DockerTerraform

Web Development

Languages

PythonJavaScriptHTMLCSS

Backend

DjangoFlaskRESTful APIs

Frontend

ReactNext.js

Testing/QA

Postmanpytest

Contact