Data Engineer and Developer in Dubai, United Arab Emirates

The SQL Messenger project was meant to provide a simple mechanism for database monitoring. Users can write queries and add them to the control table along with the notification info targeting recipients and send criteria. It runs via a simple stored procedure, which allows different checks on different schedules defined as hourly, daily, or weekly.

It comprises unlimited possibilities, including sending a list of orders that haven't been completed to the shipping department, a list of offline databases to the DBA team, or data quality check reports to data stewards. If users can write a query to identify a condition that needs attention, they can easily automate notifications to appropriate users with this tool.

Ballistic Calculator is an easy-to-use calculator for exterior ballistics using hand-derived equations. It enables users to calculate external ballistic performance for any situation.

Developed in React, the entirely client-side application allows users to enter information about their load, calculate results, and save favorites for later review.

Mathematically, starting from the general-form equation for bullet deceleration due to air resistance—a = (A * V^m) / c—we can integrate twice to form equations for velocity and distance traveled, adjusting for initial muzzle velocity and gravity drop. Using a computer program to iterate, we can also calculate the amount of sight adjustment needed to compensate for drop at any given distance.

An application that allows users to find the table/view they're looking for quickly, see what objects are used to populate that data and where it flows downstream from there, and what automation jobs run the refresh function, when they're scheduled, and what happened the last time they failed. Exciting, isn't it? Users spanning ETL support to data analysts to business users saved tons of time using this helpful tool. Over 2-3 years of working closely with both Data Governance and business users, I took this project from the back-burner to something with more useful features, eventually adding all the tools necessary to have a one-stop metadata source.

A SQL Server database system with automated 'crawlers' (C#, Python, and Powershell scripts) to populate database object dependency and lineage info from databases, integration packages, and additional metadata—automated job scheduling and status, job failure tickets, user notes—about those. A web application (C# WebAPI with an AngularJS front-end) allowed users to do a quick search, traverse the data lineage 'tree' view, and add supplemental metadata, such as business aliases, data domains, etc., to the auto-generated base.