Scroll To View More
Alec Peters, SQL Developer in Portland, OR, United States
Alec Peters

SQL Developer in Portland, OR, United States

Member since January 31, 2018
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.
Alec is now available for hire

Portfolio

Experience

  • SQL, 5 years
  • Python 3, 5 years
  • Django, 4 years
  • JavaScript, 4 years
  • .NET, 4 years
  • Pandas, 2 years
  • Docker, 1 year
  • Vue.js, 1 year
Portland, OR, United States

Availability

Part-time

Preferred Environment

Unix, Vim, Git

The most amazing...

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

Employment

  • 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: Docker, Python, Pandas, Elasticsearch, Kibana, Django, PostgreSQL
  • 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: Python, Pandas, Django, Jupyter, SQL Server, PostgreSQL
  • 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: C#, .NET, SQL Server, Git, JavaScript
  • 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: Python, Django

Experience

  • Woras Woodworking (Development)
    http://www.woraswoodworking.com

    A simple portfolio website for a local woodworking business.

  • Hack Oregon Housing Affordability Project (Development)
    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.

Skills

  • Languages

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

    Django, .NET, Django REST Framework, Bootstrap 4, Flask
  • Libraries/APIs

    Pandas, jQuery, REST APIs, TensorFlow, Scikit-learn, Vue.js
  • Tools

    Vim Text Editor, Git, Docker Compose, Kibana, Visual Studio
  • Paradigms

    Agile
  • Platforms

    Docker, Jupyter Notebook, Linux
  • Storage

    PostgreSQL, SQL Server 2008, Elasticsearch
  • Other

    Data Analysis

Education

  • Bachelor's degree in Mathematics
    2009 - 2013
    Colby College - Waterville, ME, USA
I really like this profile
Share it with others