Vendor Product Inventory Integration

NOV 2019 - JUN 2020

Integrated vendor inventory from various firearm distributors to display available quantity and to alert associates of items that are restocked. The integration included the automation of sales price calculator for cash or credit exchanges. Integration involved developing a windows console application that would download vendor catalogs in either CSV or XML format to a specified onsite location. In addition, MSSQL stored procedures were created to BULK INSERT data of CSV or XML content to a database table location.

Product Release

AUG 2019

Released the next version GainRM application that eliminated dependency of Crystal Reports and leverages SQL Server Reporting Services. Enhanced security including better session handling and encryption. Extraction of functions from DLLs to backend database server. New theme and icons as well as addressed several bugs reported from the previous version.

Created an Internal Web Application for Triadd Software Corporation

AUG 2018 - SEPT 2018

Created an internal application that would generate a new support id for clients emailing or calling for support. The application logs the detailed tasks done by associates and saves it to a database. Each support ticket is also ranked by priority to manage focus within the company. The application also logs the number of environments our product was installed on and notes the registration key along with the client's environment specs. In addition, the application also is a central location for our knowledgebase for resources, instructions, tutorials, and guidance.

Created A New Website for Triadd Software Corporation

AUG 2018 - SEPT 2018

Created a new website for Triadd Software Corporation who was on a Drupal platform. The new site is created using ASP.NET MVC and hosted on the company's own server instead of an online host.

Database Migration from Oracle to Sql Server

JUL 2018 - AUG 2018

Migrated client database whose was on Oracle 11g to SQL Server 2014 by creating a VM environment with necessary applications to convert the database and test its functionality with our software product.

Senior Capstone Project

APR 2018 - MAY 2018

Creation of an all in one point of sales application that's tied to a database using SQL Server Management Studio. The POS application can log employee timesheets, request leave, view pay, and accumulation of hours worked. The POS also keeps track of inventory and freight. The software allows the user to ring up customers and automatically deduct from inventory levels.

Bear Arms Website Upgrade

NOV 2018

This project involved upgrading the BearArms website to utilize ASP.NET MVC Core. My responsibility as a backend web developer was to create models, views, and controllers. I had to create an algorithm that would display the company products on the products page which was tied to a database using SQL Server Management Studio. I had to create and implement the following features: search bar, filters, add to cart button, checkout button and javascript to access local storage and create inner HTML text.

Excell Drywall FreePBX Install

FEB 2018 - MAR 2018

Install and configure FreePBX on a newly purchased server. Termination of Rj11 phone lines and install of Rj45 plugs with 8 port Unifi Switch. Integration of FreePBX with 2 Yealink T46S phones.

Northwest Lining Hardware Upgrade

DEC 2017 - JAN 2018

Upgrade 8 desktops to recently purchased Dell Inspiron, migrate user-profiles and install software components, replace gateway, and six network switches to Unifi hardware. Install SSD drives in 6 laptops and Microsoft Office 365.

Creation of Audit System

AUG 2017 - Aug 2017

Created a weekly audit system to capture information regarding inventory shrinkage. The system involved a weekly rotating inventory captain and auditor. Warehouse aisles of interest are cordon off for the auditor to count inventory and report findings to the captain. The captain will then instigate significant gaps in inventory. The same captain and auditor will not be allowed to audit the same aisle in the next audit cycle as a precaution to insider threats.