Development and Database:

I've been gratified to participate in solving a number of issues requiring development of some sort of application, despite not being a programmer. I am, instead, very familiar with a lot of programming-adjacent languages and technologies, particularly those in the front-end arena of a typical web stack (including experience with a couple CMS systems) or on the back end of a casino solving promotional issues with presentational apps or querying and writing reports against SQL databases (specifically, a couple casino-focused CRM systems).

SQL Stored Procedure - Jackpot Progressive

SQL Query & Stored Procedure Development

SQL development work includes a number of on-demand or SQL Server Agent scheduled stored procedures in MS SQL Server, as well as Tableau, SQL Server Reporting Services, and Crystal Reports development for triggering the on-demand SPs and displaying custom reports. Using these tools I was able to integrate three separate CRM OLTP databases and individual accounts into one Marketing database, build on-demand CRM reports for front-line personnel, and build a ticketless contest drawing system. The latter featured: over a dozen nested and linked SQL stored procedures optimised to be called by each drawing in the span of a few seconds; conditional criteria allowing full configuration of promotion based on set of input variables (points per entry, include or exclude bonus points, include VIPs only, date and time of entry earn and activation, etc); data trail recorded for all virtual drawings for regulatory oversight and compliance.


Dynamic Data Signage Applications

"Dynamic SignApps" are high-definition Flash-based applications that display dynamic data information based on variable data. Examples I've built include: a menu that updates items instantly based on a chef's changes to a file; a progressive that increments each time a jackpot above a certain amount hits on a range of machines; a branded "specials" board that changes restaurant name based on time-of-day; and a SQL-driven virtual drawing application that displays the winning name of a drawing of entries based on slot points earned.

Features: Dynamic data fields pulled from output of SQL stored procedures or user input; Adobe Animate or Flash animation integrated with rich animation from After Effects, added as video; user interface designed for back-end presenter to run virtual drawing using a presentation remote.

Music Credits:

  1. "In The Mood" by The Glenn Miller Orchestra
  2. "Beat The House Ambient Soundtrack" by MacPlay

Happy Game Family - Static Site

The hand-coded CSS for this static HTML portfolio web site you're reading right now was workshopped and developed at the Happy Game Family site. Combination vanity site, combination long-dormant web site business experiment, the site was at first launched to simply house a family gaming podcast with which I was also experimenting, and its associated RSS feed. Eventually it has expanded to include other game-related content.


Keep of Imbarkus - Dynamic Site

This personal blog represents my opportunity to work with the Wordpress CMS platform. I'm working with the JetBlack theme by Firefly Themes, with some additional code snippets and customizations. Classic blocks are largely used for older posts as they were imported from an original Blogger platform site. Movie-related posts on the site contain some large GIFs I've made from original footage. I have experimented with using WEBM and MP4 embeds to cut these file sizes but results of sizing and autoplay on mobile remain fluid and unreliable.


Old Web Sites

Old Web Site Development

This page will demonstrate various static web site developments I executed from the late 1990's through the early 2000's. These include a mix of professional and freelance projects, for clients and friends both. As such, they contain photography and other intellectual property that are owned by their originators. Fortunately these sites were designed for the low resolutuion environment of consistent CRT computer displays of the early 2000's, and thus any such materials are in fantastically low resolution. I recommend bumping your browser zoom up to at least 150% to view these sites as they were intended. Enjoy the kitschy internet nostalgia!