TECHNICAL SKILLS

Live Environments: Windows, Linux, Amazon Cloud (AWS), Rackspace Cloud, Microsoft Azure

Database Platforms: Microsoft SQL Server, MySQL, MongoDB, Amazon Redshift, Percona, MariaDB, Sybase

Programming Languages: SQL, C++, PHP, HTML, CSS, JavaScript/jQuery, Bash/Shell Script, Windows Batch(cmd&bat)/PowerShell, Excel VBA/Macros

Agile/Scrum & Jira: I have worked with daily scrum, weekly sprints, and the Kanban style of project management in Jira. Tableau I write reports, create interactive dashboards and provide self - serve analytics using Tableau Server. I also serve as the Tableau Server Administrator handling installation & deployment, updates, backups, users & permissions and more.

ETL: For most reports in Tableau it's best to create Tableau extracts. However, to create your extracts you must first ETL your data into dimensional data warehouse tables, OLAP, or other preconfigured results tables for easy use with Tableau. MS SQL has a more complete toolset for ETL but I have crafted open-source ETL solutions for use with Tableau via the use of bash, stored procedures & OOP languages.

Live/Production Environments: With over 15 years of experience as a programmer, web developer, database developer/DBA and systems architect I have debugged my fair share of emergency outage/downtime situations with a calm, cool head. I am not a systems administrator by profession but I can lend assistance in that arena when required.

Cloud Hosting: I have worked with Amazon Web Services (AWS), Rackspace Cloud, and Microsoft Azure professionally. Cloud platforms provide powerful tools to craft your web, data, and systems architecture.

Windows Server: I have worked with Windows Server 2008 R2 & 2012 R2 professionally. Currently Tableau Server is only available for hosting on Windows Server but that may change in late 2017. I use PowerShell to script backups and more. Linux Very comfortable working in any flavor of Linux ranging from development to administration. Bash scripting veteran. MS SQL Server I have worked professionally with MS SQL 2005 & 2008 and recently certified MCP for SQL Server 2012/14. MySQL I am a long-time MySQL veteran spanning from version 5.0 to 5.7. I have crafted several large-scale database solutions in MySQL that my past companies still operate on to this day. I have learned the pros and cons of using MySQL. MongoDB I have worked professionally with MongoDB for high volume storage solutions. There are pros & cons to NoSQL. Web Development I spent several years as a web developer so I am quite proficient with languages like PHP, HTML, CSS, Javascript/jQuery with AJAX, JSON, XML, MVC Frameworks such as CakePHP, Laravel, custom VC and more. I have created mobile/responsive web design solutions as well as iPhone & Android apps in the free sector.

Versioning: I am a veteran of repos such as SVN, GIT and CVS. I have installed and maintained SVN repos professionally. Development Tools MS SQL Server has a complete toolset but for open source I like Toad for MySQL, MySQL Workbench, Navicat and Netbeans IDE for web/back end development. Linux/Bash and Windows/Power Shell for scripting.

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

BI & Reporting Developer, Tableau Administrator

Responsibilities:

I currently work as the BI & Reporting Developer / Tableau Administrator for Confidential . Confidential has a massive amount of manual reports and one- off SQL queries/stored procedures that need to be automated into a permanent, automated reporting solution. I was hired to help fulfill that mission via the use of Tableau Server. Tableau server of course does not work well with preformatted summary reports in the form of SQL. Instead it thrives off reading, counting, and aggregating data records. I am in charge of the planning and implementation of ETL strategies to organize data in an easy to report fashion while allowing for as much reuse of data warehouse tables & data sources as possible. We use Tableau connectors to connect to Google Analytics/GTM, Facebook & other Social Media, MongoDB and MySQL. These ETL jobs are then scheduled to upload into Tableau data extracts and are stored on the Tableau Server for fast, interactive reporting. Here at Confidential I installed, configured, and deployed our Tableau Server with some Windows Server 2012 R2 setup help from our Ops team. I created the scripted backups utilizing Windows PowerShell and I am also in charge of managing users & permissions, software upgrades, extract schedules and data source maintenance.

Confidential, Aliso Viejo, CA

Data Architect, LAMP Developer, Database Developer/DBA, Cloud Engineer (MySQL, MongoDB, Toad, Linux, Bash, Tableau)

Responsibilities:

I was hired at Confidential to architect a way to download, parse, import and track history on massive amounts of real estate listing data pulled on a daily basis from ListHub (MLS data aggregator) and over 200 MLS's nationwide. After 5 years the system I setup is thriving and providing the lifeblood of the business. I learned many valuable lessons about how to store and quickly access large amounts of data ranging from MySQL databases tracking live and historical listing data to file storage for a ridiculous amount of real estate listing photos. Some of the highlights of working at Confidential include 1) Working in cloud environments like Rackspace Cloud, Amazon Cloud (AWS), Microsoft Azure and taking advantage of all the powerful, scalable tools on each of those platforms, 2) Deploying solutions in multiple database systems including MySQL, MongoDB, and MS SQL Server, 3) Working with Tableau software for the first time, 4) creating numerous forms of For Sale Listing searches via geo-spatial indices and point in polygon type scenarios, 5) fending off hackers and upgrading security, 6) constantly crafting new products, systems, and ideas for my company on my dry- erase wall, 7) working in both a leading role as well as a programming/DBA role, 8) creating scripts to automatically generate real estate property websites from MLS data, 9) developing responsive design layouts to fit from desktop to mobile, and 10) developing mobile apps for iOS and Android using Cordova + jQuery.

Confidential, Aliso Viejo, CA

Database Developer, Web Developer (HTML, CSS, PHP, MySQL, jQuery Javascript)

Responsibilities:

I was responsible for building much the jQuery UI, PHP, & MySQL back end Site Administration tool for Confidential . I also worked to optimize the entire site thru PHP code changes and MySQL query optimization (index tuning and MySQL database redesign). I personally introduced and implemented MEMCACHED on all Live and Dev servers as a caching solution to prevent the flood on resources we were seeing on our production site. Confidential was the first job where I had the opportunity to work with a cloud host. We hosted our website with RackSpace Cloud servers . Rackspace provides powerful tools to "spin up" new servers and hardware with any configuration in just minutes. I created both staging and development servers to better follow best practices. I wrote numerous linux bash/shell scripts to backup our LIVE environment and restore fresh data to our development environment. Unfortunately, Confidential was only around for about 2 years before all members of the tech team were laid off and the company was sold to another organization.

Confidential, Los Angeles, California

Database Developer, Web Developer (MS SQL Server, MySQL, HTML, CSS, PHP)

Responsibilities:

I was on call at LuxuryLink 24/7 to be accountable for helping keep the database and website, Confidential online and available for live auctions and bidding at all times. Downtime means lost revenue in a live auction website, so we had to ensure maximum uptime 24/7 including weekends. I have restored and restarted the system from many crashes and freezes due to a wide variety of problems.

Most frequently, our problems would lie in over-utilized CPU on web or database servers. In these situations, I would use monitoring tools in MS SQL or MySQL to determine the state of the database and any potential problem-makers such as long running stored procedures, too many requests, or other users of system resources. I would coordinate with our Systems Administrator to determine the cause of any downtime/outage/overload and (if database related) resolve/restore/restart the system as necessary. * Performance Tuning: I used a variety of platform specific tools to monitor DB performance and identify problem areas in the DB such as poor performing stored procedures & queries, inefficient table structures & relationships, inefficient use of indexes, need for hardware upgrades or any other problems with poor programming practices. I also created/edited numerous stored procedures & nightly jobs to keep LL.com dynamic and fresh for daily user. I planned and crafted all the new databases, tables/field types, procedures and all other groundwork necessary to create new systems/modules for the website and infrastructure of Confidential . I also wrote the majority of the SQL on the website for the PHP developers. Database Design: I was part of a team of 3 who redesigned the entire database and infrastructure of Confidential . We changed platforms from MS SQL to MySQL.

Confidential, Santa Monica, California

Database Coordinator, Report Writer

Responsibilities:

I was the go-to man at Summit when it came to implementing creative technologies. One of the highlights at Summit was creating the official website for one of our movies "Dot The I" (dottheimovie.com). Primary projects include full-time maintenance, development, and report creation for Sybase/iAnywhere SQL databases & software, Lotus Notes email Administration/Programming, Barracuda Spam/Spyware firewall administration, Blackberry Enterprise Server Admin, creation of feature film websites, IT maintenance/repair/setup, deployment and customization of information systems. Tasks: SQL Database Admin: BKUPs, load/unload, indexing, upgrades, ODBC setup, other standard maintenance. SQL Database Content Maintenance: strong in SQL queries (selects, updates, inserts, deletes) with powerful mechanics necessary for standard DB maintenance. SQL Report Creation: MS Excel (thru ODBC) & VBscript/macros, Crystal Reports, Infomaker. Database creation, modeling, and implementation of Sybase, MYSQL / PHP databases from the ground up with foresight to prevent future problems/inefficiencies/roadblocks.