Technologies :: MySQL :: TaylorMadeTraffic.com

5more images

FieldWorks APIs

November, 2023 ~ Present

API for Web App Dashboard for scheduling, dispatching and tracking campaigns

Maintained Django APIs and MySQL database powering mobile app and admin portal.
Wrote efficient Stored Procedures to replace Django ORM queries and unnecessary serializers.
Optimized SQL queries and aggregation endpoints for analytics dashboard, doubling data output while maintaining speed and adding search filters.
Wrote k6 tests to benchmark API performance across all environments.
Enhanced PDF generator for canvasser routes and instructions.

api.fwcanvass.com

MySQL Python Django AWS SQS Chalice ElasticBeanstalk K6

Started: 2023-11-01

Industries: Analytics, Language, Marketing

Team: Alex Gibson: CTO. E.A.Taylor: Web and Mobile APIs

Companies/Brands: FieldWorks

2more images

Djmote API

March, 2024 ~ November, 2024

Wrote Django API, CMS, and CD pipeline to GCP
Built GCP server with load balancers for API on Cloud Run with Cloud SQL, and for the web app in a HTTPS Cloud Bucket
Integrated various social APIs using OAuth2 for authentication and syncing music playlists

api.djmote.com/admin

MySQL Python Django Google Cloud Platform Cloud Run Shell Scripting AllAuth

Started: 2024-03-01

Launched/Lasted: 2024-11-01

Industries: Marketing, Music, Events, LifeStyle

Team: E.A.Taylor: Full Stack. Imminent Victory: CEO. Zachary Ebel: CMO. Jake Chao: COO.

Companies/Brands: Djmote

1more images

PickupMVP Backend

April, 2022 ~ April, 2023

Developed a scalable backend and AI-powered video analysis platform for PickupMVP.com in App Store & 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.
Wrote video annotation tool for ongoing additions to data set.
Built video effect automation with ffmpeg and scikit using YOLO and DeepSort.
Streamlined complete deployment pipeline with Bash and gcloud to GCP.
Extended Track Authority Music platform and API to connect all rating and reward services.

pickupmvp.com

Python Darknet Google Cloud Platform DeepSort YOLO scipy scikit Drupal mySQL Apache Youtube API

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

17more images

Track Authority Music backend

January, 2020 ~ January, 2021

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
Authored 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
Implemented OAuth2 to issue short and long term access token from the Password Grant via HTTP and encrypted OTP links
Designed Email Blast tools for Group owners to send OTP links to existing and new users safely and securely.
Wrote FFMpeg scripts to crop and repurpose Cypress recordings as HowTo / demo videos.

trackauthoritymusic.com

PHP Symfony Drupal mySQL Apache Youtube API Shell Scripting

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

16more images

Track Authority - CodeIgniter Website / API

November, 2012 ~ January, 2013

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

trackauthoritymusic.com

PHP CodeIgniter mySQL JavaScript Bash Facebook Graph API Node.js Express.js

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

29more images

FLC

August, 2017 ~ January, 2020

Promoting, Educating, and Facilitating Knowledge Transfer

Migrated data from Solr server into Drupal CMS for streamlined content management while maintaining the Solr API functionality with optimized index updates from adds, edits and deletes.
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.
Developed front-end full-text search tools for global site search and FLCBusiness, implementing facet counts for enhanced filtering.
Built custom in-page editorial tools accessible based on Drupal Roles using Node Access Hooks.
Integrated CAS Authentication System for unified login capabilities between FLC sites.
Rebuilt custom theme with Bootstrap to improve overall site responsiveness, scalability, and ARIA compliance.
Developed CRON jobs to automate the import of licensable technologies from all NASA labs and other federally subsidized entities.
Upgraded Google Map integration to automatically update Map results alongside listed search results.

www.federallabs.org

Apache Solr PHP Drupal Levenshtein mySQL Google Maps API Sass Bootstrap

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

9more images

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.

blingby.com

MySQL Drupal 7 PHP JavaScript YouTube API Google Maps API AJAX Apache

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

9more images

tripchi - Auto Importer & Taxonomy Builder

October, 2014 ~ October, 2015

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.

cms.tripchi.com/admin/tripchi/bg/import

MySQL Drupal 7 PHP JavaScript Apache

Started: 2014-10-01

Launched/Lasted: 2015-10-01

Industries: Travel, Language, Analytics

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

Companies/Brands: tripchi

8more images

tripchi - CMS & API

March, 2014 ~ October, 2014

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

cms.tripchi.com

MySQL Drupal 7 PHP Facebook Graph API JavaScript Apache

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

4more images

Cultur

September, 2014 ~ February, 2015

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

www.cultur.io

www.cultur.io/app.html

Ruby on Rails mySQL AJAX JavaScript jQuery Mobile Facebook Graph API MapBox

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

5more images

Oreo Navidad

November, 2013 ~ December, 2013

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.

www.ganaoreo.com

PHP mySQL JavaScript

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

4more images

ID Dashboard

July, 2013 ~ December, 2013

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.

analytics.idinteractive.co

PHP CodeIgniter mySQL AJAX JavaScript Google Visualization API Facebook Graph API YouTube API Twitter API Laraval CSS3 HTML5

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

5more images

Sedal Rizos

June, 2013 ~ July, 2013

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.

apps.facebook.com/sedalrizos/

fbtabs.imagendigital.co/unilever/sedal/surprise/

PHP Slim Framework mySQL AJAX JavaScript Facebook Graph API

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

6more images

Planet Maple

March, 2010 ~ June, 2010

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

pmsk8.com

PHP mySQL Facebook Graph API JavaScript AJAX CSS3 HTML5 Apache

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

11more images

Good Life With Gabby

August, 2008 ~ January, 2009

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

www.goodlifewithgabby.com

ActionScript 2 PHP CodeIgniter mySQL JavaScript AJAX Google API CSS3 HTML5 Apache

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

9more images

MyCubi.com

September, 2009 ~ January, 2010

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.

PHP CodeIgniter mySQL Facebook Graph API JavaScript AJAX CSS3 Apache

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

7more images

ChartMedica

March, 2009 ~ October, 2009

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.

www.chartmedica.com

ActionScript 3 Flex PHP mySQL Apache

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

12more images

Elite Wedding Locations

May, 2009 ~ July, 2009

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.

www.weddinglocation.com

www.weddinglocation.com/clientpass/index.php

AJAX ActionScript 3 Flex PHP mySQL JavaScript

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

17more images

Black Panther Party

July, 2009 ~ August, 2009

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

www.blackpanther.org

bpp.taylormadetraffic.com/

ActionScript 3 PHP CodeIgniter mySQL AJAX JavaScript CSS3 Apache

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

5more images

The Means

September, 2008 ~ February, 2009

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

www.TheMeans.info

www.TheMeans.info/_dev/web40.php

ActionScript 3 PHP mySQL AJAX JavaScript CSS3 Apache

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: TaylorMadeTraffic, Berkeley High School

9more images

HerveLeger

July, 2008 ~ August, 2008

The highest priced brand from the BCBGMaxAzriaGroup

Developed store location profiles & finder, along with runway/fashion show video presentations

www.herveleger.com

ActionScript 2 PHP mySQL

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

5more images

BCBGMaxAzriaGroup

April, 2008 ~ August, 2008

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)

www.bcbgmaxazriagroup.com/Fall2009

ActionScript 2 PHP mySQL

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