Data Architect Developer in Las Vegas, NV, United States

A highly-performant SaaS application for business financial planning and reporting. I wrote the statement of work (SOW), designed the business logic, created the initial front-end framework, and developed all back-end functionalities. The system uses a Cloud Firestore NoSQL database and exposes Cloud Functions microservices that perform all calculations and consolidations. The front end is built with Angular, Akita state management, and Angular Material and heavily uses RxJS to take advantage of the real-time features of Cloud Firestore. I also developed Python scripts for ETL and back-end processes.

An application that consolidates data from regulatory reports such as FFIEC and NCUA from all banks nationwide for commercial real estate entities to identify lenders with potential sale assets.

I developed this app using Python to ETL the data into a Cloud Firestore database. A React front end accesses the data through a REST API exposed by Cloud Functions for Firebase.

An analytics app for Las Vegas Strip casinos' gaming revenue, based on the data published by the Nevada gaming regulator. I designed and implemented the entire application, beginning with ETL of the source data into a SQL database (SQLite), selecting, aggregating, and filtering the data with SQLAlchemy, creating the API endpoints with Flask, and displaying the analytics in the Angular front end.

I designed and developed a live tracking system for outdoor running events utilizing 3G GPS trackers.

A tracking server implemented as a Windows service receives GPS positions from individual trackers, performs necessary geographic calculations, and saves the positions to the database. The web application displays runners on a map and calculates statistics. The back end is built using C# .NET Web API, accessing the SQL Server database using Entity Framework. The front end is entirely HTML and JavaScript-based and implemented using the Kendo UI framework around Bootstrap and flat UI design.

I created this system as an alternative to the tracking architecture that required cellular service for deployment in remote event locations. I designed, assembled, and coded an ARM-based tracking device featuring a 900 MHz XBee radio and SiRF IV GPS receiver. The prototype was built with Tiva C LaunchPad.

The WPF client connects to the receiving XBee radio via a serial connection and plots GPS positions on a map enhanced with a predefined GPX course map.

A cross-platform mobile app running on the instructor's device, allowing members to sign in at outdoor fitness class locations. I developed the app using the Xamarin framework and integrated it with a legacy ASP.NET Web Forms application to sync data with the SQL Server member database.