← BACK

SPENCER LINK

PROJECTS

AutoChef

Automatic Meal Planning Web Application

PostgreSQL Express React Node.js AWS RDS AWS EC2 Supabase REST API

A full-stack PERN application that dynamically generates grocery lists and weekly meal plans based on user preferences and pantry inventory. The system intelligently matches recipes with available ingredients and dietary restrictions.

Key Features:

  • Dynamic meal plan generation based on user preferences and dietary restrictions
  • Real-time pantry inventory management with automatic grocery list generation
  • Responsive React frontend optimized for all devices and screen sizes
  • Relational database schema hosted on AWS RDS for scalability
  • Node.js backend with REST APIs for user preferences and recipe matching
  • Intuitive interface for customizing meal preferences and reviewing weekly plans

Astrolosphere

AI-Generated Horoscopes Web Application

MongoDB Express React Node.js OpenAI API Astrological APIs

A full-stack MERN application that displays real-time planetary positions and generates personalized astrological insights using AI. The system combines traditional astrological calculations with modern AI content generation.

Key Features:

  • Real-time planetary position tracking and astrological chart generation
  • AI-driven horoscope content using OpenAI API for personalized insights
  • MongoDB database for storing planetary data, astrological charts, and user profiles
  • Node.js backend handling complex astrological calculations and positioning
  • Responsive React frontend for intuitive user experience
  • Integration with external astrological APIs for accurate celestial data

Automated Okta-Controlled SOC-2 Compliant Roles-Based Access Control System

Enterprise Security Infrastructure for Texas Department of Information Resources

ServiceNow Okta Access Control Security Automation Compliance

Led the development of an automated custom roles-based access control system for a Managed Security Services Provider serving the State of Texas Department of Information Resources. This system addressed the critical challenge of managing access for a constantly changing workforce requiring annual background checks, training, and fingerprinting while ensuring government data security.

Key Features:

  • Automated job role-based access provisioning and deprovisioning
  • Integration with annual clearance status verification systems
  • Secure auditable access controls with full compliance tracking
  • Scalable system handling constant onboarding/offboarding cycles
  • Reduced manual workload for small onboarding team
  • Maintained SOC-2 compliance standards throughout implementation

Impact:

  • Successfully managed access for a seven-year government contract
  • Eliminated manual access control bottlenecks
  • Ensured continuous security compliance for government data
  • System remains operational and effective to this day

MongoDB-ServiceNow Data Synchronization System

External Connectivity & Automated Data Sync for AT&T Reporting Infrastructure

MongoDB ServiceNow API Integration Data Synchronization Flow Automation Reporting Systems

Designed and developed external connectivity to AT&T MongoDB Cluster via API to automate the synchronization of Customer Lookup and Project Lookup data between ServiceNow and MongoDB. This system eliminates manual updates and reduces errors in the reporting process by creating a bidirectional data sync between the two systems.

Key Features:

  • Custom ServiceNow flow actions and subflows for MongoDB Data API integration
  • Bidirectional data synchronization between ServiceNow and MongoDB clusters
  • Automated nightly sync jobs to maintain data consistency
  • Dynamic and reusable flow architecture for future MongoDB integrations
  • Real-time updates triggered by ServiceNow record changes
  • Cross-reference system using MongoDB Object ID and ServiceNow Sys ID fields

Technical Implementation:

  • Developed custom flow actions since ServiceNow lacks built-in MongoDB communication
  • Created two new tables in ServiceNow Report Entitlements application
  • Implemented supporting backend flows utilizing MongoDB Data API methods
  • Designed entangled data structure for Customer Lookup and Project Lookup records
  • Built scheduled jobs for nightly synchronization maintenance

Impact:

  • Eliminated tedious and error-prone manual MongoDB document updates
  • Reduced administrative workload on Reporting team members
  • Improved data accuracy and consistency across systems
  • Created foundation for future ServiceNow-MongoDB integrations
  • Paved way for user-submitted changes via Service Catalog