MySQL

21 Projects

PickupMVP

Play & reward yourself, your community, & all athletes in any sport.
A web and mobile application to find, create, promote and win rewards from live sports matches. Available in the App Store & Google Play
  • Created entire frontend, backend, Tests and AI for PickupMVP.com
  • Published Flutter application in App Store and Google Play
  • Annotated data set and trained YOLOv4 model for detecting 6 classes across different sports
  • Designed all business logic for tracking the clip's subject athlete and ball
  • Built video annotation tool for ongoing additions to data set
  • Streamlined all DevOps with git and bash scripts to GCP

Started: 2022-04-01

Launched/Lasted: 2023-04-01

Industries: Music, Sports, Events

Team: E.A.Taylor: Design, Front-End, Back-End, Business Development

Companies/Brands: TaylorMadeTraffic, Track Authority Music

Track Authority Music

Rewarding Musical Tastes
A platform for building gamified groups and applications with rewards for engagement

Built all aspects API, CMS, and CRON jobs

  • API built with PHP around Drupal and Symfony, leveraging the Cache API and dependency injection for services, query factory, and entity normalizers.
  • Built CRUD routing paths dynamically from registered Entities and entity bundles
  • Built end-to-end functional testing suite to test all endpoints over CURL requests
  • Integrated Cloud9 Gateway alongside Commerce Funds to process transactions and keep records of users 'wallet' value
  • Wrote OAuth2 Authentication system to issue short and long term access token from the Password Grant via HTTP and encrypted OTP links
  • Wrote Email Blast tools for Group owners to send OTP links to existing and new users safely and securely.

Built all aspects of ReactJS responsive web app with Redux and Material-UI

  • Built single codebase to compile different applications with unique branding, themes and functionality. For examples, see
  • Wrote abstract form builder to render any layout and set of field components.
  • Wrote Cypress.io Test Suite using TypeScript and NodeJS to generate unique end-to-end tests for each brand, each with 3 device sizes. Also wrote FFMpeg script to crop and repurpose Cypress recordings as HowTo / demo videos.
  • Designed and copywrote entire application, icons and logo, sometimes in California, sometimes abroad

Started: 2020-01-01

Launched/Lasted: 2021-01-01

Industries: Music, Events, Gaming

Team: E.A.Taylor: Design, Front-End, Back-End, Business Development

Companies/Brands: TaylorMadeTraffic, Track Authority Music

LenguaPlus is a plug-in for CodeIgniter that manages translations of system copy and user-generated content. It was built within Track Authority, this site, and extended for ID Interactive's Dashboard project in order to version control text changes by authorized user/authors
Includes 8 configuration for tracking and translating system text and user-generated-content by environment and language

Started: 2012-12-01

Launched/Lasted: 2013-12-01

Industries: Language

Team: E.A.Taylor: Front-End, Back-End

Companies/Brands: TaylorMadeTraffic

An online and mobile game that rewards high-rated users with free music, gift certificates, concert tickets and cash
  • Engineered MVC architecture for dual website / API using CodeIgnitor and HMVC Modular Extensions, to allow complex types of permission combinations across user types, and make all components completely portable across applications, serving either HTML or JSON.
  • Optimized memory usage with several Bash scripts and CRON jobs to crop / resize images, handle email queues, and generate static HTML pages for common anonymous requests.
  • Built CMS for managing user-generated and editorial content, review internal traffic logs, logins, and all emails.
  • Built asynchronous email service to seamlessly convert website templates to tablular HTML documents with inline CSS, and manage queue of emails prepared, sent, failed, and clicked.
  • Built Node.js server to authenticate requests to static mp3 files before streaming via ffluent-ffmpeg
  • Automated performance testing with XHProf and data integrity tests with built in logging tools

Started: 2012-11-01

Launched/Lasted: 2013-01-01

Industries: Music, Events, Gaming

Team: E.A.Taylor: Design, Front-End, Back-End, Business Development. Drew Williams: Business Development

Companies/Brands: TaylorMadeTraffic, Track Authority Music

FLC

Federal Laboratory Consortium for Technology Transfer
Promoting, Educating, and Facilitating Knowledge Transfer
  • Programmatically migrated a custom Solr server into Drupal for easier content management
  • Wrote duplicate reducer to compare nodes by measuring the similarity of common fields across sources. Used Levenshtein Distance algorithm and took action based on threshold configurations.
  • Rebuilt new Solr indexes with Drupal's Search API to respect CMS revisions and publish settings
  • Built front-end Full-Text search tools for the global site Search and FLCBusiness and showing facet counts
  • Built custom in-page editorial tools available by Drupal roles and node access hooks
  • Integrated CAS Authentication System for unified login portal between FLC sites
  • Rebuilt custom theme with Bootstrap to improve overall site responsiveness, scalability, and ARIA compliance
  • Wrote automated crawling importers for all NASA labs and various 3 parties technology sources
  • Upgraded Google Map integration to automatically update Map results alongside listed search results

Started: 2017-08-01

Launched/Lasted: 2020-01-01

Industries: Technology, Marketing, Events, Analytics

Team: E.A.Taylor: Front-End, Back-End, API. Joseph Anderson: Cypher CEO. Denise Wainer: UTRS Director of Communications. Will Dyson: UTRS System Administrator, Release

Companies/Brands: Federal Labs Consortium, Cypher LLC, UTRS

Blingby

Live the Experience
Blingby lets users 'live the experience' of their favorite music videos and movie trailers. Blingby LLC tags top-voted YouTube videos with purchase links so products, hotels, and artists are shown in-sync as the video plays.
  • Configured and hooked Drupal Views to query content internally and from Amazon for album artwork as well as YouTube for matching videos.
  • Rebuilt Drupal templates for a more responsive experience across devices with CSS3
  • Developed google-map interface and query logic to re-order of ad / affiliates' links based on the user's location and affiliates’ geographic settings.
  • Built several administrative tools for configuring home page settings, photo carousels, and reviewing data-integrity from error logs and Drupal’s url_alias table.

Started: 2015-11-01

Launched/Lasted: 2016-04-01

Industries: Travel, Music, Fashion, Marketing

Team: E.A.Taylor: Front-End, Back-End. Robert Stanicic: Business Development

Companies/Brands: Blingby LLC

tripchi - Auto Importer & Taxonomy Builder

HTML Scraper & Importer with Automated Taxonomy Builder
Tags map many-to-many and are used by the global search box, Types map 1-to-many and are used by the main drawer menu's selectable filters.
  • Developed scraper tool for importing Airport data from HTML, JSON, and RSS feeds.
  • Automated and improved categorization - despite an insufficient taxonomy - by learning from the full text of previous imports.
  • Built batch processing tool to review and update importer decisions by tagging content to effect Tag weights to a primary Type.

Started: 2014-10-01

Launched/Lasted: 2015-10-01

Industries: Travel, Language, Analytics

Team: E.A.Taylor: Front-End, Back-End

Companies/Brands: tripchi

tripchi - CMS & API

Content Management System and API
Your passport to explore the airport. Discover restaurants, shopping, deals, unlock airport secrets & more.​
  • Built OAuth2, token secured CMS & API with Drupal 7
  • Hooked Drupal Views to set default filters based users' profiles, location, next flight information.
  • Integrated FlightStats API at runtime while adding or editing flight information.
  • Optimized site and API with CRON jobs to update flight status and real time airport details from FlightStats API

Started: 2014-03-01

Launched/Lasted: 2014-10-01

Industries: Travel

Team: E.A.Taylor: Front-End, Back-End. Roberto Galan: Design. Chandra Jacobs: Project Management & Business Development

Companies/Brands: tripchi

Cultur is your Ultimate Event Resource, to get what you need when you want it. Find any activity/event going on around you at any time and any place. See if your friends or people with like interests will be there.
Cultur has a simple jquery mobile interface for navigating events crawled by a Ruby on Rails crawler

Started: 2014-09-01

Launched/Lasted: 2015-02-01

Industries: Music, Events

Team: Kaili Miyamoto: Design. E.A.Taylor: Front-End. Rama Mcintosh: Back-End. Caleb Haye: Back-End. Jan Uetz Ayacaba Ondo: Business Development. Jonny Mack: Business Development. Mike Hegazy: Business Development

Companies/Brands: Cultur LLC

ID interactive builds marketing platforms for a long list of great clients with creative projects and campaigns. This was just one of the projects I got to build while working there. View more projects I built with ID Interactive here: http://taylormadetraffic.com/companies?qtfilter=ID%20Interactive
  • Built responsive interface, pixel perfect to design specs, with elegant client-side form validation using HTML5, CSS3 and pure JavaScript.
  • Wrote barcode queries and prize distribution algorithm to evenly distribute 285 prizes, without predefined winners, across the 60 day campaign, against 20 million codes printed on Oreo packages throughout Colombia. Supported business rules such as Captcha when a user searched more than 12 times in a day.
  • Included several backend tracking tools for reviewing code attempts and wins, as well as an automated QA tester to simulate varying degrees of traffic, code searches, and minimum probabilities.

Started: 2013-11-01

Launched/Lasted: 2013-12-01

Industries: Gaming

Team: Cristopher Allen Lara: Design. E.A.Taylor: Front-End, Back-End. Oscar Gil: Project Management. Sharon Lewis: Account Manager. Jimmy Rodriguez: QA. John Parra: QA

Companies/Brands: Oreo, ID Interactive

The tool automates monthly reports for clients, by aggregating data from all active marketing channels or installed tracking tools, such as Twitter, Facebook Insights, Google Analytics, and YouTube.
  • Built fluid interface of drag-and-droppable graphs for Project Managers to create monthly performance reports of client campaigns.
  • Built API to customize each graph with comments, unique headers, colors, sizes, and display orders before generating shareable URLs to produce reports across accounts or without login.
  • Built site permissions matrix for view, write, and delete privileges limited per user, client, brand, and project.
  • Modularized graph components to build and refresh off a normalized JSON structure, produced on-load and via AJAX, further allowing data drilling on all metrics and dimensions.

Started: 2013-07-01

Launched/Lasted: 2013-12-01

Industries: Analytics

Team: E.A.Taylor: Design, Front-End, Back-End. Juan Ruiz: Business Development. Claudia Huertas: Business Development. Alejandra Farfan: Project Management. David Duran: Project Management. John Parra: QA. Mauricio Zambrano: UX. Catalina Molina: UX

Companies/Brands: ID Interactive

A curly-hair competition for a $250 shopping spree
Another quick campaign application to generate FanPage likes. In order to compete, users were required to like Sedal's FanPage, complete registration, and upload videos, images, or a tip on maintaining their curly hair (ideally using Sedal products;). Voting was validated by IP, user agent, and session, while video uploads were POST'd directly to a public YouTube channel using their PHP SDK. The project extended ID's fork of the Slim PHP Framework. I personally found more hurdles than helpers in the tightly namespaced codebase and it's odd use of closures for routing/controllers.

Started: 2013-06-01

Launched/Lasted: 2013-07-01

Industries: Fashion, Gaming

Team: Zandro Gil: Design. Luisa Vicaría Azuero: Account Manager. E.A.Taylor: Front-End, Back-End. Fabian Mariño: Front-End. Natalia Uribe: Project Management. Jimmy Rodriguez: QA

Companies/Brands: Sedal, ID Interactive

Design & developed e-commerce platform based on CMS OpenCart with custom modules for resident skater / surfer profiles and FBConnect (depreciated)

Started: 2010-03-01

Launched/Lasted: 2010-06-01

Industries: Sports, Ecommerce

Team: E.A.Taylor: Front-End, Back-End, Design. Ajax Gokhale: Front-End. Ishwar Joshi: Back-End. Lisa Vasquez: Product Development. Cedric Bell: Product Development. William Lamar: Product Development

Companies/Brands: Planet Maple, Burst Entertainment

A fun, educational site for kids and parents to learn about, and find recipes on healthy lifestyles and nutrition. Includes tooling book, jquery shopping page, recipes table, videos, and translation of virtually everything into 12 languages at runtime via Google's language API.
Designed and developed all animation and interactivity for a kids' website on healthy eating habits and recipes (AS2/XML/PHP: www.goodlifewithgabby.com / flash.goodlifewithgabby.com). Applications included coloring book, recipes sorter, dynamic video player, and language translator via Google Language API

Started: 2008-08-01

Launched/Lasted: 2009-01-01

Industries: Kids, Health

Team: E.A.Taylor: Front-End, Back-End. Unknown: Free-Hand. Lisa Vasquez: Business Development

Companies/Brands: Good Life With Gabby, Burst Entertainment

A social networking tool for connecting sellers, buyers, and services
  • Wrote advanced search logic for finding and filtering results by type, distance, price, date, time and other criteria.
  • Plotted all search results on a Google mapping application - by distance using the Haversine formula - with custom markers for Cubi type. Upon clicking markers expanded with tabbed windows to provide additional StreetViews, 'cubi' details, and directions (using Google maps v2 API).
  • Built Facebook application (using FBConnect) to post on user walls and send messages to friend's inboxes.
  • Integrated and upgraded social networking 'inviter' script to share/publish user profiles and details across a dozen email clients and two dozen social networks.

Started: 2009-09-01

Launched/Lasted: 2010-01-01

Industries: Marketing, Ecommerce

Team: E.A.Taylor: Front-End, Back-End. Anatoliy Yastreb: Front-End, Back-End. Danielle McCormick: Product Development. Maeve Hackett: Product Development. Will McCormick: Product Development. Michael D Montoya: Product Development. Colm Walsh: Product Development

Companies/Brands: MyCubi

Features included an advanced pdf viewing tool, autocompletes searching over 600K records, and automated faxing via MyFax API.
Developed Flex-based interface for a patient's medical records system. Extended the server-side services to generate dynamic PDF (fpdf) of records and record requests. PDFs were then automatically faxed to physician offices when 5 available incoming fax lines to parse and import records (using myFax.com API). The application also included other libraries and components such as e-signing with Flex and hospital searches by location and specialty.

Started: 2009-03-01

Launched/Lasted: 2009-10-01

Industries: Health

Team: E.A.Taylor: Design, Front-End, Back-End. Roy: Back-End. David: Back-End

Companies/Brands: ChartMedica LLC

A reporting system for advertisers to view site traffic, user inquiries on their properties, and return-on-investment figures.
This system included 3 levels of access with top level administrators being able to change cost values per account or property, receive notifications upon account logins, and scheduling custom reports to be email at any frequency or time span, to anyone. The system provides complete drilling capabilities on any data set for any time frame; and populates both Flex graphs and DHTML tables and charts with a single click.

Started: 2009-05-01

Launched/Lasted: 2009-07-01

Industries: Analytics, Marketing

Team: E.A.Taylor: Design, Front-End, Back-End. Jacquas Habra: Project Management. Kevin Kent: Project Management. James McCorkle: Project Management

Companies/Brands: Elite Wedding Locations, Noospheric LLC

Design & developed a unique interface for navigating articles, essays, events, and new program initiatives. This was a volunteer project with early ambitions for a commercial joint venture. It fell apart over internal issues.
Eli implemented the Google Language API (php) to translate entire site and individual articles to nearly any language using an asynchronous AJAX cue-engine to control http request priorities, frequency and timeouts. Extended open source CMS OpenCart with configuration options to map and re-stylize all products and profiles

Started: 2009-07-01

Launched/Lasted: 2009-08-01

Industries: Education, Ecommerce

Team: E.A.Taylor: Front-End, Back-End. David Hilliard: Brand Development. Justin Herman: Flash Movie Animation.

Companies/Brands: Huey P. Newton Foundation

A vision from Biko Eisen-Martin for his students at Berkeley High School to create a tool for teachers and students to collaborate and compete in the writing process. Modeled after a traditional newsroom, students and teachers would be able to develop assignments, work on multiple versions of a story, share ideas within the class, and more. We built a prototype site that supported a semester of great essays still worth reading, but the project lost momentum as we both moved cities.

This project's greatest potential was in a version-controller for teachers to review, grade and provide feedback on student's essays, while peer reviews drove friendly competition between writer and school rankings.

If you work in Education or feel something like this could help your classroom or school district, please email me. I'd love bring it back to life in our spare time.

UI Tools include tinyMCE text editor, advance sourcing maps, and multi-category search options

Started: 2008-09-01

Launched/Lasted: 2009-02-01

Industries: Education, E-learning

Team: E.A.Taylor: Design, Front-End, Back-End. Biko Eisen-Martin: Product Development

Companies/Brands: TaylorMadeTrafficTaylorMadeTraffic, Berkeley High School

The highest priced brand from the BCBGMaxAzriaGroup
Developed store location profiles & finder, along with runway/fashion show video presentations

Started: 2008-07-01

Launched/Lasted: 2008-08-01

Industries: Fashion

Team: Joe: Design. E.A.Taylor: Front-End. Edwin Ado: Back-End

Companies/Brands: HerveLegerHerveLeger, BCBGMaxAzriaGroup

A major overhaul of the corporate branding home
  • Created Fall 2008 BCBGMaxAzriaGroup company site and flash catalogue with another team member
  • Built BCBG.tv to archive all video content with search and sorting capabilities. Delivered thumbnail and text descriptions of every video with content pulled from static XML, Flash Media Server, and mySQL/PHP
  • Created Tell-A-Friend applications for users to email their friends products and links directly from our site
  • Added client side features for saving settings and style preferences via Local Shared Objects (flash cookies)

Started: 2008-04-01

Launched/Lasted: 2008-08-01

Industries: Fashion

Team: Natasha Li: Design. E.A.Taylor: Front-End. Robert Baindourve: Front-End. Edwin Ado: Back-End. Ray: Back-End. Edwin Roses: Artistic Direction

Companies/Brands: BCBGMaxAzriaGroup