Projects

High-level overview of my most recent Projects.

Client Delivery · Princeton IT Services

Feb 2024 - Present

NOVA · Teams AI Chatbot

Enterprise chatbot for Connor Strong & Buckelew

Azure OpenAITeams SSOGraph APIKey VaultBicep
  • Integrated Azure Document Intelligence into a Teams app to process user-uploaded files end-to-end.
  • Moved the bot to a single-tenant identity model and wired Graph API access via an Entra app to safely shuttle files.
  • Shifted secrets to Key Vault and templated runtime env delivery with bicep for safer deployments.

Latista Data Extraction & Dashboard

Clark Construction

PythonBox SDKSnowflakePDFPlumberCamelotStreamlitReact
  • Automated archival pulls from Oracle dumps via Box SDK, cleaned the data, and landed it in Snowflake.
  • Used multiprocessing to extract text/images from PDFs and generated entity relationships from JSON payloads.
  • Built a Streamlit/React dashboard to expose the Latista dataset to non-technical users.

SAP BO → Power BI Migration

Power BI paginated reports at scale

Power AutomatePower BISnowflake
  • Designed a Power Automate flow to export 2000+ paginated reports in under 2 hours.
  • Rebuilt KPI reports from SAP BO into Power BI dashboards backed by Snowflake data models.
  • Introduced parameterized reports and data masking to protect sensitive fields while keeping exports flexible.

Data Quality Analysis

Procore → Snowflake transfers

SQLSnowflakePython
  • Established metrics to compare parallel data flows and surfaced drifts between Procore and Snowflake.
  • Authored complex SQL to capture history (travel feature) and trend analysis for ongoing QA.
  • Prototyped Snowflake notebook automation to generate daily stats for downstream teams.

SecureDNS · DNS Record Validator & Generator

Internal security tool

PythonCryptographyFlaskAWS LambdaZappa
  • Built a validator to audit existing DNS records for DMARC, DKIM, and SPF compliance.
  • Added a guided DNS record generator (cryptography-backed) and deployed the app with Flask + Lambda via Zappa.

Systems & Research

BCFL · Blockchain-based Federated Learning

Python, gRPC

Distributed LedgerProof-of-WorkPythongRPC
  • Replaced the FL central server with PoW-validated miners and a distributed ledger for model updates.
  • Tracked model versions over time to harden integrity and reliability in federated settings.

Distributed Machine Learning Cluster

10-node fault-aware cluster

PythonSocketsPyTorchMultithreading
  • Implemented a log-saver program to capture crashes and a failure detector for simultaneous/cascading node faults.
  • Designed SDFS, a versioned, replicated file system to back the cluster’s training artifacts.
  • Ran multi-model distributed training with built-in failure detection and storage resilience.

Apps & Tools

Chat-Time

Real-time chat web app

ReactNode.jsAppwrite
  • Used client-server subscriptions for real-time messaging and added message deletion by ID.

VTOP-Extended

Campus companion app

FlutterFirebase
  • Centralized VIT student services with auth, club/event management, faculty DB, web view, and online quiz module.

Blog Application

REST API backend

JavaSpring BootMySQL
  • Delivered CRUD, pagination, sorting, JWT auth, and role-based security with clean DTOs and exception handling.