Alec Peters, Developer in Portland, OR, United States
Alec is available for hire
Hire Alec

Alec Peters

Verified Expert  in Engineering

Software Developer

Portland, OR, United States

Toptal member since March 26, 2018

Expertise
PythonSQLDjangoData AnalysisC#jQuerySQL Server.NETGitJavaScriptREST APIAgile DevelopmentDockerPostgreSQL
Bio

Alec works at the intersection of data and software development. With over four years of professional software development experience, he primarily focuses on writing full-stack web applications and data processing pipelines in various technologies including Python and .NET. He also is experienced in data analysis and telling stories with interactive visualizations, dashboards, and reports.

Portfolio

Hack Oregon
PostgreSQL, Django, Kibana, Elasticsearch, Pandas, Python, Docker
Gateway to College National Network
PostgreSQL, Microsoft SQL Server, Jupyter, Django, Pandas, Python
Energy GPS
JavaScript, Git, Microsoft SQL Server, .NET, C#

Experience

  • SQL - 5 years
  • Python 3 - 5 years
  • .NET - 4 years
  • Django - 4 years
  • JavaScript - 4 years
  • Pandas - 2 years
  • Vue - 1 year
  • Docker - 1 year

Availability

Part-time

Preferred Environment

Git, Vim Text Editor, Unix

The most amazing...

...project I've worked on is an interactive JavaScript dashboard for synthesizing and understanding grid-scale energy industry data.

Work Experience

Volunteer Software Developer | Data Scientist

2018 - PRESENT
Hack Oregon
  • Implemented an Elasticsearch-and-Kibana-based data portals using Docker and Digital Ocean for exploring housing-related data from the American Community Survey and other sources.
  • Wrote ETL scripts in Python to interact with the US Census Bureau APIs and transform their data into Elasticsearch for further analysis.
  • Analyzed data using Python, Pandas, and Matplotlib on American Community Survey housing data.
  • Wrote parser scripts in Python for myriad data sources such as IPUMS and Harvard's Joint Center for Housing Studies data tables.
  • Implemented the REST API using Django REST Framework for housing data.
Technologies: PostgreSQL, Django, Kibana, Elasticsearch, Pandas, Python, Docker

Data Analyst | Research Assistant

2017 - 2017
Gateway to College National Network
  • Implemented a data analysis using Python and Pandas to measure our programs' performance over a broad range of metrics.
  • Began designing and coding a Django-and-PostgreSQL-based data system to replace an aging Microsoft Access one.
  • Created dynamic program portals in JavaScript for viewing program reports and survey results.
  • Offered technical support to our programs, including troubleshooting Microsoft Access and website connection issues.
  • Developed and enforced source control for our SQL Server database and website using Git and GitLab.
  • Implemented various testing scripts to ensure data integrity in our CRM.
  • Wrote data import and export scripts in JavaScript and Python for interacting with the Adobe Business Catalyst CRM.
Technologies: PostgreSQL, Microsoft SQL Server, Jupyter, Django, Pandas, Python

Senior Software Developer

2014 - 2016
Energy GPS
  • Implemented ETL processes in C# and .NET, including data scraping using CasperJS and SQL Server database design and administration.
  • Performed Columbia River flow and hydropower generation modeling using various statistical techniques in R and SQL.
  • Created an interactive, customizable JavaScript dashboard for viewing energy industry data with customizable, draggable, and resizable widgets.
  • Implemented a REST API in .NET for our clients to access our data in a consistent, standardized format.
  • Performed research and data analysis in R, Python, and Excel to come up with and present insights into energy industry data.
  • Designed and maintained an ASP.NET MVC website for our clients to view reports and interact with our data.
Technologies: JavaScript, Git, Microsoft SQL Server, .NET, C#

Intern

2014 - 2014
Oregon Research Institute
  • Worked on the initial release of a Django and PostgreSQL based web application.
  • Implemented a linked-list data structure in Python for page navigation in a Django application.
  • Supported the front-end development using Sass, Bootstrap, Gulp, Bower, and Webpack.
Technologies: Django, Python

Excel to Elasticsearch: ETL Data Processing with Pandas for Indexing Excel Sheets

This code uses Pandas to parse the data from several sheets of an Excel file into an Elasticsearch index. It can be run directly and needs to have a valid Elasticsearch instance on localhost:9200. This showcases some simple ETL processing to transform Excel tables into organized JSON for Elasticsearch or any other database system.

Woras Woodworking

http://www.woraswoodworking.com
A simple portfolio website for a local woodworking business.

Hack Oregon Housing Affordability Project

https://github.com/adpeters/housing-2018
I volunteer for Hack Oregon and currently, I am working in a team looking at housing affordability in Portland and the United States. My role in this project is of a software developer and data analyst and I gather the necessary data and provide a REST API to the public along with some visualizations and interactive features to tell the story of housing affordability that we find.
2009 - 2013

Bachelor's Degree in Mathematics

Colby College - Waterville, ME, USA

Libraries/APIs

Pandas, jQuery, REST APIs, TensorFlow, Scikit-learn, Vue

Tools

Vim Text Editor, Git, Jupyter, Docker Compose, Kibana, Microsoft Visual Studio

Languages

Python 3, SQL, C#, JavaScript, Python, CSS, Bash

Frameworks

Django, .NET, Django REST Framework, Bootstrap, Flask

Paradigms

Agile

Platforms

Docker, Jupyter Notebook, Unix, Linux

Storage

PostgreSQL, SQL Server 2008, Microsoft SQL Server, Elasticsearch

Other

Data Analysis

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring