Chad Bourque Email & Phone Number

Baltimore, Maryland, Us

- Architected, designed, helped develop, and deployed a complete system used in substance use disorder treatment facilities called Vitals+. The system allows patients in detox and/or rehab to wear a smart ring which is read by numerous custom BLE mesh network gateways via Bluetooth Low Energy. The gateways send biometric data to a backend server over WiFi. The data is stored in MariaDB and provided to a web frontend via REST APIs and WebSocket communication to allow facility staff to see realtime biometric stats for all patients.- Architected, designed, and built API backend containing HTTP REST endpoints and a WebSocket endpoint using TypeScript, Fastify, and Node-Tap- Architected, designed, and built Android app that uses BLE to find, connect to, and configure custom BLE mesh network gateway devices using Kotlin, Jetpack Compose, BLE, and Preferences DataStore- Architected and designed iOS mobile app which was built by another developer- Architected, designed, prototyped, and built POC for a BLE mesh network gateway using Arduino Nano ESP 32 microcontrollers- Provided production support for the legacy Pretaa application using TypeScript and PostgreSQL in AWS

- Highly active on MySQL forums in the past with 2000+ posts- Architected new database model in SQL Server for the replacement of a financial aid application with all application data access via stored procedures- Designed and developed a browser-based single page application (SPA) using Google Web Toolkit (GWT) and CSS with user security, privilege and role based access control, full audit logging, and reporting deployed to IIS on Windows- Architected, designed, developed, tested, released, supported, and maintained an asset tracking SPA written in GWT, styled with CSS, integrated with Google Maps, included KML/KMZ support, with user security, privilege, role, and group based access controls, MySQL backend with all data access via stored procedures, deployed to Apache Tomcat on Linux, and integrated satellite short burst messaging systems- Architected, designed, developed, tested, released, supported, and maintained a dashboard/portal SPA written in GWT, styled with CSS, with user security, privilege, role, and group based access controls, SQL Server backend with all access via stored procedures, deployed to IIS on Windows

- Developed intranet website/single page application utilizing Sign in with Google- Developed CRM single page web application integrated into intranet- Developed reporting dashboard single page web application integrated into intranet- Developed REST API for all web applications- Developed KPI reports consolidating multiple data sources for executive reporting- Architected, Built, and Maintained database for web applications- Achieved Clean Reports from Breachlock for Penetration testing on intranet website and API- Created and Maintained workflows in Vision (OSS/BSS from Fibersmith)- Developed Slack Workflows for handling employee add/remove requests- Developed Slackbot Application to automatically post/update/remove alert messages from SMx- Developed REST API for Slackbot Application- Created training videos using DaVinci Resolve- Responsible for FCC BDC filings and Form 477 filings- Responsible for managing the transition from BroadHub to Vision (OSS/BSS)- Administrator for Google Workspace Business Standard, Slack, AWS, NGINX, Vision (OSS/BSS from Fibersmith), BroadHub (OSS from GLDS), SafeTitan (includes creating and running training and phishing campaigns), Apple Business Manager, and Microsoft 365- Tech stack utilized: Angular, TypeScript, HTML, CSS, SQL, Amazon EC2, Koa, NGINX, Bash, ECharts, Sign in with Google, Javascript, REST, Bolt, MariaDB, SSH, NPM, Git, Jasmine, Jira, DaVinci Resolve

San Antonio, Texas, Us

Promotion to Lead April 01, 2020Relocation from Plano, TX January 01, 2018. Conversion to full-time employee July 10, 2017

Contracting for Cisco provided by Apex Systems

Plano, Texas, Us

- Instituted a new system for updating and maintaining data in MySQL using DDL files tracked in Git written with replication-safe, repeatable SQL via temp tables and table renames- Identified and fixed MySQL replication issues- Reviewed and fixed MySQL queries for both speed and accuracy- Reviewed and modified table designs and SQL queries written by others- Developed command-line utility in Java to run on Linux servers via cron which extracted data from WordPress database tables, normalized the data, and stored it on another MySQL server - Used Rally to track and support development efforts using Agile methodology- Architected a new content delivery system for the company’s main website- Developed, as part of a small team, a new content delivery system in Java- Developed Hadoop Map/Reduce jobs in Java used to process Akamai log files and construct and analyze website user session data- Created and deployed hotfixes and releases using Maven and jgitflow plugin, Jenkins, and ssh- Wrote bash scripts to run Hadoop jobs and export data to MySQL that were run via cron- Researched and recommended installation and adoption of Upsource for code reviews

New Jersey, New Jersey , Us

- Mentored junior developers- Architected, designed and, developed Windows-based client-server multi-user merchandise allocation application in Visual FoxPro using SQL Server- Created a job monitor application for Windows using Visual FoxPro and SQL Server to monitor SSIS jobs- Wrote a console application in C# for automating the execution of SQL script files used for data refreshes across environments and production deployments- Created Excel spreadsheets with pivot tables with data pulled remotely from data cubes- Created custom buyer proficiency report in an Excel spreadsheet that pulled data remotely from SQL Server- Developed custom user interface controls in Visual FoxPro for use in other in-house applications such as: multibar 3D progress bar with customizable gradient colors, grid with support for sub-grids, and numeric textbox

Mason, Oh, Us

Us

Birmingham, Alabama, Us