GaragePlot 2.0
GaragePlot.com
ZacharyDouglass.com
MVC Code Generator
Graduate School Admissions
People Directory Mobile App
People Directory
Data Backup/Sync Solution
Employment Center Software
Mission Office Administration

GaragePlot 2.0

Makes garage-sale hunting easy! Parses garage sale information from craigslist and plots it onto a map. What really sets it apart from other similar websites is that it parses addresses from listings much better than it's competitors and thus lists far more sales.

Features

  • Highly Scalable -
    • A new web instances can be up in less than 5 minutes on either Amazon Web Services (AWS) or another hosted virtual machine service.
    • Developing can proceed quickly thanks to the Django Web Framework, which focuses on keeping the stack decoupled. This allows for changes in one part of the application to be made without affecting other parts.
  • Reliable - Using AWS provides high reliability. Automatic failover of load balancers and databases ensures that the site continues even if a few machines go down.
  • Shows garage sales posted in the last week
  • Scrapes data from multiple garage sale posting sites.
  • Uses GeoIP to automatically detect visitor location.
  • Custom algorithm extracts addresses from listings
  • Uses Google Maps API to geocode the addresses into latitude and longitude
  • Uses Google Maps API to display map of all sales

Technology

MVC Code Generator

Using the PHP Zend framework I created a script which generates Business Objects, Data Access Objects, and DbTable Objects. Only enter a database name and the script intelligently generates code for each table.

Features

  • Translates foreign keys into object relations: (Person knows it's related to CreditCardTransaction etc)
  • Creates english readable method names from database schema: student_id -> getStudent
  • Writes files to specified locations.
  • Uses hashes to intelligently update only the files needs to be changed.
  • Compatable with the PHP Zend framework

Technologies

  • PHP
  • Zend Framework
  • MySql
  • MySql Workbench

Graduate School Admissions

A complete web application solution for graduate school admissions. Handles online applications as well as administration functions for the Master of Accounting and Master of Information Systems Management programs at Brigham Young University.

Student Features

  • Student contact data pulled from central university database
  • Academic data entered via transcript parser
  • Automated reminder emails
  • Essay word autocount
  • Essay autosave
  • Online fee payment
  • Confirmation Emails - peace of mind knowing the submitted the application
  • Acceptance letter from dean

Administrator Features

  • Quickly enter and validate grades using transcript parser
  • Edit application deadlines
  • Edit messages/automatic emails
  • Email applicant groups
  • Mail merge feature
  • Statistics summary page
  • Export data to csv
  • ODBC connection to office reporting software
  • Track verification of academic data
  • Audit trail of admissions decisions
  • Automated reminder emails
  • Online help

Technologies

  • ColdFusion
  • Cashnet Credit Card Processing
  • ExtJS
  • JavaScript
  • Cascading Style Sheets (CSS)
  • MySql

People Directory Mobile App

Mobile webapp for managing group membership records. This project was catered to a BYU student congregation.

Features

  • Sort records by name, apartment, or record completness.
  • Edit member information on mobile phone.
  • iPhone look and feel maintained thanks to a 3rd party template.
  • Browser top bar is hidden.
  • Role-based security.
  • Mobile phones automatically routed to mobile site.
  • Integrated with full browser companion website.
  • Autogenerated thumbnails are cached serverside using a custom caching function.

Technologies

  • PHP
  • Image Manipulation Library
  • HTML
  • JavaScript
  • Cascading Style Sheets (CSS)
  • MySql
  • RSync

People Directory

A functional webapp for managing group membership records. This project is catered to a BYU student congregation.

Features

  • List records by name, apartment, or record completeness.
  • Edit member information online.
  • Send emails to the entire group.
  • Use mail-merge variables in emails (i.e. #first_name#, #last_name#)
  • Download directory in PDF format ready for publication.

Technologies

  • PHP
  • Image Manipulation Library
  • HTML
  • JavaScript
  • Validation Library
  • Cascading Style Sheets (CSS)
  • MySql
  • RSync

Data Backup/Sychronization Solution

Using a conglamoration of tools I created a custom automatic data synchronization and backup system.

Features

  • Automatic two-way synchronization occurs after any file change
  • Data synchronized to external server every 15 minutes
  • Files accessable through the internet.
  • Syncs across Windows, Mac, and Linux

Technologies

  • Bash Scripting
  • Rsync
  • Cron
  • Windows Live Sync

Employment Center Software

Designed and implemented software that was the primary tool for the "Centro de Recursos de Empleo". It allowed job seekers to enter their resume and be matched with employers.

Features

  • Network database allowed users on 8 different computers to enter resume's simultaneously.
  • Employer resume search
  • Automatic email notification of new job seekers

Technologies

  • MS Access
  • Visual Basic

Mission Office Administration

Wrote software that managed missionary work for the Church of Jesus Christ of Latter Day Saints in Costa Rica. The software tracked missionaries, baptisms, immigration records, referrals, and inventory.

Features

  • Track missionaries progress
  • Track new convert progress
  • Track inventory
  • Monitor referral status
  • Track church records
  • Track immigration records
  • Generate statistical information: convert retention, church attendance.