G_K

Project History

A highlighted list of work

Tritone Analytics

Migrating AWS Lambda reporting to a dedicated server

Dec '23 - Feb '24

Closed

FastAPI (Python)

Matplotlib / Seaborn

Pandas

Pydantic

SMTPlib

SQLAlchemy

Code Migration

Platform migration from AWS lambda functions (python) to a self-hosted python server (FastAPI) and Postgres database

Automated Requests and Reports

Replicated original functionality to regularly query Open Dental and build internal reports for owners, managers and team leads.

Interfacing Data Warehouse

Raw data, processed data and generated reports are stored to a local data warehousing solution.

API Creation

Added API functionality for dashboard integration. Data warehouse is accesible via RESTful API for irregular report access and custom data visualization

Internal Business Reporting: Server Migration

Migrating AWS Lambda reporting to a dedicated server

Dec '23 - Feb '24

Closed

FastAPI (Python)

Matplotlib / Seaborn

Pandas

Pydantic

SMTPlib

SQLAlchemy

Code Migration

Platform migration from AWS lambda functions (python) to a self-hosted python server (FastAPI) and Postgres database

Automated Requests and Reports

Replicated original functionality to regularly query Open Dental and build internal reports for owners, managers and team leads.

Interfacing Data Warehouse

Raw data, processed data and generated reports are stored to a local data warehousing solution.

API Creation

Added API functionality for dashboard integration. Data warehouse is accesible via RESTful API for irregular report access and custom data visualization

Office Operations Auditing Software

A web UI that reduced time-spent by 40%.

Oct '23 - Nov '23

Closed

FastAPI (Python)

HTMX

Jinja

Pandas

Pydantic

SQLAlchemy

Data Input UI

The app was able to streamline the data input process with a centralized UI.

Automated Reports

Results and feedback for each office are generated as pdfs and emailed to managers automatically

Interfacing Data Warehouse

Raw data, processed data and generated reports are stored to a pre-existing data warehouse.

Load Testing: Fastify REST API

A personal learning project using Node.js with Fastify and Grafana K6 to optimize API throughput

API RepoK6 Repo

Oct '23 - Oct '23

In Progress

Fastify

Grafana K6

Node.js (TS)

Postman

Stress Testing

Sustained heavy load...

Spike Testing

Short maximum peak load...

Soak Testing

Average load for a long time can help identify memory leaks

Breakpoint Testing

Ramp the request load well beyond normal operation to determine where failures exist.

G_K Hello

A portfolio site of recent work. You are currently viewing this project.

Github

August '23 - Current

Open (ongoing)

TypeScript

Next.js (TS)

Nodemailer

Chakra UI

Light/Dark Mode

Having a Light/Dark mode option instantly makes your website "super cool" and modern UI libraries make it straight forward to implement.

Auto Engagement

Upon submission of this form, nodemailer uses my SMTP server to send you and I an email to begin a conversation.

TDB Dashboard (formerly 'Mimir')

Business dashboard for Texas Dental & Braces

August '22 - June '23

Closed

TypeScript

Next.js (TS)

Node.js (TS)

PostgreSQL

Material UI

AWS Lambda

Prisma ORM

Chart.js

Nivo Charts

NextAuth.js

Puppeteer

Data Warehouse

Data is regularly collected from multiple APIs, processed into easily consumable metrics and stored as historical records

Dynamic Report Generation

Custom reports can be built from all available data and exported to a pdf or csv for presentations or further analysis

User Access Tiers

Users are granted access to features, admin settings and certain data based on their account type and profile

Admin Controls

Admin are able to set performance targets and specify access settings for other users

Domain Specific Userbase

Each instance of the mimir dashboard whitelists users of specific Google Suite domains integrating an entire team safely

OpenDental Integration

The associated Nintu server instance regularly queries and stores vital bussiness metrics from the OpenDental API to expose behaviors over time.

Dental Risk

New Patient intake form for dentists to collect and provide information about a patient's potential risks related to their dental health.

Demo

April '23 - May '23

Closed

Chakra UI

Docker Containers

GraphQL API

Hasura

Next.js (TS)

Nodemailer

PostgreSQL

React Hook Form

TypeScript

Automated Emails

Upon user form submission, the results for the questionnaire are generated and sent to the provided email from the doctor's chosen email address.

Form Validation

Ensure data submitted matches the requirements set forth in the various form controls.

Content Management

The list of questions and the resulting information exposed to the user can be customized by the instance admin.

SaaS Deployments

Instances of Dental Risk can be independently deployed for seperate offices with custom styling and content.

Modern Suite for RMH

Developed by New West Technologies, Modern Suite is a device-agnostic software extension to Retail Managment Hero that's accessible via any device with a web browser and local network connection.

More

Feb '21 - April '22

Closed

.NET

GitLab

Jira & Confluence

Linux OS

Node.js (TS)

PM2

Python 3

SQL Server

Sequelize ORM

TypeScript

Vim

New West Technologies

From New West Technologies, a device-agnostic software extension to Retail Managment Hero that's accessible via web browser on internal store network

Quick Tasks

Quick Tasks have redefined efficiency in Modern Suite task execution. Akin to making a call to someone on speed dial, Quick Tasks are rapid singular-action commands that simply get the job done quicker!

Data Consistency

Real-time bidirectional synchronization to RMH, ensuring data at RMH Central matches the stores while 'Zamboni Data Cleanup' cleans up and resyncs Item, PO, and Transfer based on a designated date

Escape Collective

Escape Collective is a team of designers, artists, engineers, builders, and sewers. Friends before business partners, their mission is to promote escapism through creative practice driven by curiosity and adventure.

More

Jun '12 - Fall '18

Closed

Python 3

Structural Design

Nike Dome...

Project Managment

Years of mananagement...

Project Managment

Years of mananagement...

Installation Lead

Leading teams of people to construct and install large structures